Case Study Running a Multi-Unit Independent Restaurant Group(Using Restaurant 365)
Please you should know how to use (Restaurant 365) before accepting.
I will give more details about how to log in after accepting.
https://unlvsp24student15.restaurant365.com/?state…
You need to follow the guide in the PDF to complete it on Restaurant 365
Requirements: follow the guide in the PDF to complete it on Restaurant 365
Category: Programming
Team – B: [Every document and screenshot should be named as ‘Team-B’] Overview:
Team – B: [Every document and screenshot should be named as ‘Team-B’]
Overview:
This week you will work with your group on your final project.
Objectives
Apply concepts learned about Hadoop Ecosystem
Apply concepts learned in data preparation to preprocess data
Construct an external table using basic SQL commands in BigQuery
Develop queries in BigQuery.
Construct a well-defined schema using basic HQL commands in Hive
Develop queries in Hive
Develop queries in Spark
Instructions
Each group will research their assigned use case. They will select a static dataset and streaming data source from the approved list provided or locate another and obtain the instructors’ approval.
Each group will create an executive summary. This summary should be between 400 and 550 words, not including the title page, references, or other supporting documents. It should read like a summary of your presentation, giving the use case project, stepping through the data lifecycle, identifying tools/applications used during certain phases of the data lifecycle, and concluding with the next steps for the data science or analyst teams. The executive summary is in Times New Roman, 12-point, with one-inch margins.
Each group will create a document with screenshots that includes the project and storage they created for their use case in GCP, setting up their Hadoop ecosystem, performing data processing with their static and streaming data, and performing queries in BigQuery, Hive, and Spark to ensure the quality of their data for the data science or analysts teams. Through each step, the team will take screenshots of their work and present them in a word document with brief explanations of the screenshots. The desciption should include the application used, the task performed, and why it was performed. Do not include how-to instructions.
Each group will create a presentation that tells a story using the data lifecycle as a guide, and they will present their work during the designated time. You may be creative with the presentation with PowerPoint. The presentation is a professional business presentation. Each member of the group should speak. After the presentation, the group will entertain questions from the audience. The presentation should be at least 10-15 minutes in length.
Meeting_Notes_Template:
I have provided the ‘Meeting_Notes_Template.docx’, please fill the provided template.
Approved Data Sources:
I have provided ‘Approved Data Sources.pdf’ please select a two datasets from any USE CASES Approved Data Sources provided in the pdf.
PPT and Word:
Topic: Use cases from the discussion post
Data: Use approved data sources (two or more)
Executive Summary (25%): This paper should be between 400 and 550 words, not including the title page, code, and references.
Screenshots (25%): These screenshots should show how you applied what you learned. Create a new project in GCP for this use case.
Presentation (50%): The group will present
Grading: This project is worth 20% of your final course grade. The Executive Summary will comprise 25% of this grade, screenshots 25%, and the presentation will be 50%
Document Type: Word and PPT
Executive Summary Requirements:
400 to 550 words, not counting the title page, references, or supporting documents.
Title page: Organization Name, Logo, Use case, group number, and group members
Introduction: Introduce the use case and its purpose (Example: Data Engineering Request)
Body: Step through the data lifecycle with your use case and the tasks you did
Conclusion: Summarize and discuss the next steps for the data science and analyst teams
Double-spaced Word Document
References
Application Screenshots Requirements:
GCP project & storage
Hadoop
OpenRefine
BigQuery
Hive
Spark
Include an explanation (3-10 sentences) with the screenshots telling the application used and the task performed.
Supporting Documents:
Reference page
Meeting notes or Task board
Data Sheet – List of Data sources and any
additional information such as the website
address
Other documents
Word Document
Meeting Notes Template:
Date:
Start and End time:
Attendees:
Note-taker:
Notes:
Decisions:
Action Items:
Task board:
Create a Task board using MS Teams – Planner,
Excel, or Word
Task board Columns
To-Do
In Progress
Review
Done
Task Info: Description, Owner, Due Date
Presentation Requirements:
Business casual
TELL A STORY
Every group member must present
10-15 minutes to present
2 minutes for questions
10-20 PowerPoint Slides
Title page: Organization Name, Logo, Use case, group number, and group members
Outline or Agenda
Every step of the data lifecycle – No definitions
Hive and Spark SQL comparison chart
A few of your screenshots (No more than 5)
Cite the source on the slide if not your own words
Word document regarding rubrics instructions.
Components – Pancreas The pancreas is a vital organ located in the upper left ab
Components – Pancreas
The pancreas is a vital organ located in the upper left abdomen, behind the stomach and in front of the spine. It plays a critical role in digestion and maintaining blood sugar levels.
Functions and Importance
The pancreas produces digestive enzymes that are released into the small intestine to help break down proteins, carbohydrates, and fats
The pancreas also produces hormones, including insulin and glucagon, that help regulate blood sugar levels
Insulin helps the body’s cells
glucose (a type of sugar) from the bloodstream, while glucagon helps release stored glucose when blood sugar levels drop
In conclusion, the pancreas plays critical roles in digestion and maintaining blood sugar levels. It produces digestive enzymes that aid in breaking down food and hormones that help regulate blood sugar.
Salivary System: Role and Importance
The salivary system plays a crucial role in the digestive process. The following are some of the key points regarding the role and importance of the salivary system:
Production of Saliva: The salivary system is responsible for producing saliva, which is a mixture of water, electrolytes, enzymes, and antibacterial compounds.
Digestion: The enzymes present in saliva, such as amylase, begin the digestion process by breaking down carbohydrates into simple sugars.
Moistening and Lubricating Food: Saliva helps moisten and lubricate food, making it easier to swallow.
Antibacterial Properties: The antibacterial compounds present in saliva help protect the mouth and digestive system from harmful bacteria.
Speech: Saliva also plays a role in speech, as it helps form sounds and words.
Taste: The taste of food is enhanced by saliva, as it helps dissolve chemicals in food and allows taste buds to detect flavors.
Overall, the salivary system plays a vital role in the initial stages of digestion, as well as in maintaining oral health and overall well-being.
Functions of the Respiratory System
The primary function of the respiratory system is to facilitate the exchange of gases between the body and the environment.
The nose and mouth filter, warm, and humidify incoming air, while the trachea and bronchi transport the air to and from the lungs.
The diaphragm and the muscles of the ribcage work in concert to allow us to breathe in and out by changing the volume and pressure within the lungs.
The alveoli are the site of gas exchange, where oxygen from the air we breathe is absorbed into the bloodstream and carbon dioxide is expelled from the body.
Additional Notes
The respiratory system also plays a role in protecting the body from harmful substances in the air we breathe, such as bacteria, viruses, and allergens.
The production of mucus and the movement of hair-like structures called cilia in the airways help to trap and remove these substances from the body.
Respiratory disorders such as asthma, emphysema, and chronic bronchitis can significantly impair lung function and lead to serious health complications.
Proper care and maintenance of the respiratory system, such as avoiding smoking, exercising regularly, and getting vaccinated against respiratory illnesses, can help to promote optimal lung health and prevent respiratory disease.
I have to make a Visualization in Tableau for the sports dataset. Req built 5-8
I have to make a Visualization in Tableau for the sports dataset. Req built 5-8 visualizations using the dataset. Try to incorporate parameters, filters, dual axis, sets, or some other advanced techniques. I will provide you the data set, as file link https://www.raed.net/file?id=848947 dataset is big, Visualization should be about most of the years. I Have to present the final Dashboard.
Use the CSV data file provided below to complete the “Coffee Chain Demo” present
Use the CSV data file provided below to complete the “Coffee Chain Demo” presented in Chapter 8 of the Murray text. Start with a new, empty workbook; do not use the starter workbook provided by the author if you happen to find it online. Your workbook should contain your worksheets and the final dashboard
I have included the following PowerPoint slide set which contains screen images from each worksheet showing dimensions and filters. Use the FSCJ logo instead of the InterWorks logo displayed in the textbook and slides. To download the logo file, right-click the image below and select “Save Link As” or “Save Image As.”
(I had to zip the CSV file to upload it here you can unzip it)
summary 2-4 paragraphs will write and a brief summary of the important concepts
summary 2-4 paragraphs will write and a brief summary of the important concepts using the file below.
2nd separate assignment is answer these 4 discussion posts, reply should be 5-6 sentences for each discussion:
Program 1 Roman Numerals: Design a program that prompts the user to enter a nu
Program 1 Roman Numerals:
Design a program that prompts the user to enter a number within the range of 1 through 10. The program should display the Roman numeral version of that number. If the number is outside the range of 1 through 10, the program should display an error message.
Program 2 Change for a Dollar Game:
Design a change-counting game that gets user to enter the number of coins required to make exactly one dollar. The program should ask user to enter the number of pennies, nickels, dimes, and quarters. If the total value of the coins entered is equal to one dollar, the program should congratulate the user for winning the game. Otherwise, the program should display a message indicating whether the amount entered was more than or less than one dollar.
The Task: Write a program in PLP assembly that counts up by one starting from ze
The Task:
Write a program in PLP assembly that counts up by one starting from zero (or one) inside a loop and writes this
value to the LEDs every time the value is increased. The memory address of the LEDs is 0xf0200000.
check the attached pdf to get the whole idea
Which of the following statements best describes the transport layer of the TCP/
Which of the following statements best describes the transport layer of the TCP/IP hierarchical model?
Question 11 Choose one:.
(1) The main roles of the transport layer communication protocols are IP address management and routing.
(2) The main role of transport layer communication protocols is to control the standards of wired LANs and the hardware standards that comprise them.
(3) The main role of transport layer communication protocols is to determine and implement data transfer methods.
(4) The main role of transport layer communication protocols is to convert the data of a communication application into a data format that a computer can understand.
Which of the following statements best describes TCP and communication using TCP?
Question 21 Choose one:.
(1) It is a communication protocol that leaves data in packet units and does not perform error checking.
(2) Communication using TCP is connection-based communication.
(3) Communication using TCP is connectionless communication.
(4) TCP is used for communications that require real-time transmission of information, such as IP telephony and Internet video relay.
Which of the following statements best describes the TCP header?
Question 31 Choose one:.
(1) [1] Sender port number (16 bits), [2] Receiver port number (16 bits), [3] Sequence number (32 bits), [4] Acknowledgement number (32 bits), [5] Data offset (4 bits), [6] Reserved (6 bits), [7] Control flag (6 bits), [8] Window size (16 bits), [9] checksum (16 bits), [10] emergency pointer (16 bits), [11] options and [12] padding are written.
(2) The checksum is used as a means of communicating the communication status to the communicating party.
(3) Only the sending port number (16 bits), receiving port number (16 bits), length (16 bits) and checksum (16 bits) are written.
(4) The sequence number is used as data to identify which communication application created the data at the sending application layer.
Which of the following statements best describes the port number?
Question 41 Choose one:.
(1) The port number used by the client, reserved in the range 0 to 1023, is called the well-known port and is assigned to the communication application.
(2) The port number used by HTTP is 80.
(3) The port number used for SMTP is 110.
(4) The port number used by the communication application for the server is the same as the port number used by the communication application for the client.
Which of the following statements best describes the procedures for communication by TCP?
Question 51 Choose one:.
(1) The amount of data a receiver can receive at one time is called the segment size.
(2) The checksum of the TCP header is used as a means of communicating the communication status to the communication partner.
(3) The control flag SYN is used to establish a connection and Fin is used to terminate a connection, but these requests are always confirmed by the ACK flag, which is an acknowledgement.
(4) A number is written in the acknowledgement number of the TCP header to indicate where the split received data was located in the transmitted data so that it can be recovered by the receiving side.
Binary Subtopic: other character encodings such as UTF-8 Character encodings for
Binary
Subtopic: other character encodings such as UTF-8
Character encodings for beginners (w3.org)Links to an external site. – short reading
What is UTF-8 Encoding? A Guide for Non-Programmers (Jamie Juviler)Links to an external site. – short reading
Characters, Symbols and the Unicode Miracle – ComputerphileLinks to an external site. – video, length: 9:36
Subtopic: floating point number encoding (in particular, IEEE Standard 754)
Floating Point/Scientific Notation (Wikibooks)Links to an external site. – short reading
IEEE Standard 754 Floating Point Numbers (GeeksforGeeks)Links to an external site. – short reading
IEEE 754 Floating Point Representation to its Decimal Equivalent (Abishalini Sivaraman)Links to an external site. – video, length: 7:25
Computer Hardware
Subtopic: how magnetic disks and optical disks work
How Hard Disks Work (Marshall Brain, HowStuffWorks)Links to an external site. – short reading
Magnetic Disks – Georgia Tech – HPCA: Part 4 (Udacity)Links to an external site. – video, length: 5:37
How do CD-R discs work? (HowStuffWorks)Links to an external site. – short reading
Subtopic: how solid-state drives work
How Solid-state Drives Work (William Harris, HowStuffWorks)Links to an external site. – medium-length reading
How do SSDs Work? | How does your Smartphone store data? | Insanely Complex Nanoscopic Structures! (Branch Education)Links to an external site. – video, length: 17:54
Subtopic: overclocking
What Is Overclocking? The Beginner’s Guide to Understanding How Geeks Speed Up Their PCs (Chris Hoffman, How-To Geek)Links to an external site. – short reading
What is Overclocking as Fast As Possible (Techquickie)Links to an external site. – video, length: 2:32
Is Overclocking Worth It? (Techquickie)Links to an external site. – video, length: 5:27
Subtopic: interface types (like USB) and adapters
Types of Computer Ports (GeeksforGeeks)Links to an external site. – short reading
HDMI, DisplayPort, DVI, VGA, Thunderbolt – Video Port Comparison (PowerCert Animated Videos)Links to an external site. – video, length: 7:35
USB Ports, Cables, Types, & Connectors (PowerCert Animated Videos)Links to an external site. – video, length: 9:15
Data
Subtopic: types of databases
Types of Databases (GeeksforGeeks)Links to an external site. – short reading
What is SQL? [in 4 minutes for beginners] (Danielle Thé)Links to an external site. – video, length: 4:25
How do NoSQL databases work? Simply Explained! (Simply Explained)Links to an external site. – video, length: 7:37
Subtopic: the .mp3 file format
How Digital Audio Works (Don Cross)Links to an external site. – medium-length reading
How MP3 Files Work (Marshall Brain, HowStuffWorks)Links to an external site. – medium-length reading
How Digital Audio Works – ComputerphileLinks to an external site. – video, length: 12:24
How MP3 File Works | MP3 Compression Explained In 3 Minutes (CSRocks)Links to an external site. – video, length: 3:17
Subtopic: file compression
How File Compression Works (Tom Harris, HowStuffWorks)Links to an external site. – short reading
Huffman Encoding for Dummies (Pawan Kishor Singh)Links to an external site. – short reading
Compression: Crash Course Computer Science #21Links to an external site. – video, length: 12:47
Subtopic: bit parity and redundant arrays of independent disks
Parity bit (Computer Hope)Links to an external site. – short reading
How does Parity Work? (YimmyTalks)Links to an external site. – video, length: 2:40
A Beginner’s Guide to RAID (General Technics)Links to an external site. – short reading
What is RAID 0, 1, 5, & 10? (PowerCert Animated Videos)Links to an external site. – video, length: 5:03
The Internet
Subtopic: making a basic webpage with HTML
The Internet: HTTP & HTML (Code.org)Links to an external site. – video, length: 7:06
HTML Tutorial (W3Schools)Links to an external site. – long reading
Complete the first 19 sections (through “HTML Lists”).
Subtopic: routing packets through the internet
Internet routing protocol (Pamela Fox, Khan Academy)Links to an external site. – short reading
The Internet: Packets, Routing & Reliability (Code.org)Links to an external site. – video, length: 6:25
Subtopic: collision detection
Collision Detection in CSMA/CD (GeeksforGeeks)Links to an external site. – short reading
CSMA/CD and CSMA/CA Explained (PowerCert Animated Videos)Links to an external site. – video, length: 6:13
Privacy and Security
Subtopic: two-factor authentication
Two-Factor Authentication for Beginners (Martin Shelton)Links to an external site. – medium-length reading
2FA: Two Factor Authentication – ComputerphileLinks to an external site. – video, length: 12:33
Subtopic: antivirus software
What is an antivirus product? Do I need one? (National Cyber Security Centre, UK)Links to an external site. – short reading
How an Antivirus Works? (GeeksforGeeks)Links to an external site. – short reading
What is an Antivirus and How Does it Work in 2021? (SafetyDetectives)Links to an external site. – video, length: 5:08
Global Impact
Subtopic: online harassment such as doxing and cyberstalking
Online Harassment (Maeve Duggan, Pew Research CenterLinks to an external site.) – medium-length reading
You only need to read the first page, entitled “Summary of Findings.” However, you are more than welcome to read the subsequent pages in this report!
Here’s What Online Harassment Looks Like | AJ+Links to an external site. – video, length: 9:24
Content warnings: stories about violence and threats of violence, including sexual violence
Subtopic: labor issues in electronics manufacturing
New Report Looks at Ethical Sourcing Risks in the Global Electronics Supply Chains (RELX Sustainable Development Goals Resource Centre)Links to an external site. – short reading
The deadly cost of cobalt for smartphones | DW StoriesLinks to an external site. – video, length: 4:28
Content warnings: mining injuries and deaths
Subtopic: sustainability and computing
The World Has an E-Waste Problem (Alana Semuels, TIME)Links to an external site. – medium-length reading
If you are unable to access the resource above, you are welcome to use the following resource instead: About E-Waste (Geneva Environment Network)Links to an external site. – longer reading
How Can We Fix The Massive E-Waste Problem? (CNBC)Links to an external site. – video, length: 17:05
Subtopic: diversity in the tech industry
There Aren’t Enough Women in Tech. Here’s Why. (CJ Riculan, NPR)Links to an external site. – video, length: 3:07
Why Aren’t There More Women In Tech? A Tour Of Silicon Valley’s Leaky Pipeline (Antonia Cereijido and Alina Selyukh, NPR)Links to an external site. – medium-length reading
Is Big Tech Still Struggling With Diversity? (CNBC)Links to an external site. – video, length: 13:28
Why I Used A Brown Hand For The “Add To Slack” Button (Diogenes Brito, FastCompany)Links to an external site. – short reading
Subtopic: artificial intelligence and bias
Why it’s so damn hard to make AI fair and unbiased (Sigal Samuel, Vox)Links to an external site. – longer reading
Algorithmic Bias and Fairness: Crash Course AI #18Links to an external site. – video, length: 11:19
How I’m fighting bias in algorithms | Joy Buolamwini (TED)Links to an external site. – video, length: 8:44
Paper
Requirements
Your paper must be at least 500 words in length.
Your paper must cover at least 3 main ideas related to your topic.
Your paper must provide at least 3 supporting details per main idea.
Resources
How to Write an Informative Essay (Megan Morgan, wikiHow)Links to an external site. – medium-length reading
Informative Writing – Introduction (Mr. S – Upper Elementary)Links to an external site. – video, length: 3:34
Informative Writing – Introduction Paragraph (Mr. S – Upper Elementary)Links to an external site. – video, length: 5:47