Latest Submission Grade: 100% The manage stage of the data life cycle is when a business decides what kind of data it needs, how the data will be handled, and who will be responsible for it. During planning, a business decides what kind of data it needs, how it will be managed throughout its life cycle, who will be responsible for it, and the optimal outcomes. A data analyst has finished an analysis project that involved private company data. They erase the digital files in order to keep the information secure. This describes which stage of the data life cycle? This describes the destroy phase, during which data analysts use secure data-erasure software and shred paper files to protect private information. In the analyze phase of the data life cycle, what might a data analyst do? Select all that apply. In the analyze phase of the data life cycle, a data analyst might use formulas to perform calculations, create a report from the data, or use spreadsheets to aggregate data. Describe how the data life cycle differs from data analysis. The data life cycle involves stages for identifying needs and managing data. Data analysis involves process steps to make meaning from data. A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes which step of the data analysis process? The act phase is when insights are put into action. Fill in the blank: Spreadsheets are _____ that can be used to store, organize, and sort data. Spreadsheets are digital worksheets that can be used to store, organize, and sort data. Fill in the blank: A formula is a set of instructions used to perform a specified calculation; whereas a function is _____. A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process. Fill in the blank: A query is used to _____ information from a database. Select all that apply. A query enables data analysts to request, retrieve, and update information from a database. Structured query language (SQL) enables data analysts to communicate with a database. SQL allows a data analyst to communicate with a database in order to retrieve and manipulate data. The graphical representation of information helps stakeholders understand data insights. Formulas and functions make this possible. The graphical representation of information is made possible by data visualization tools. These tools help stakeholders understand data insights.
End of preview. Want to read all 11 pages? Upload your study docs or become a Course Hero member to access this document Tags analyst, manage stage of the data life cycle
This is the first course in the Google Data Analytics Certificate. These courses will equip you with the skills you need to apply to introductory-level data analyst jobs. Organizations of all kinds need data analysts to help them improve their processes, identify opportunities and trends, launch new products, and make thoughtful decisions. In this course, you’ll be introduced to the world of data analytics through a hands-on curriculum developed by Google. The material shared covers plenty of key data analytics topics, and it’s designed to give you an overview of what’s to come in the Google Data Analytics Certificate. Current Google data analysts will instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources. Enroll in Foundations: Data, Data, Everywhere Coursera Foundations: Data, Data, Everywhere Quiz AnswersFoundations: Data, Data, Everywhere Week 1 Quiz AnswersPractice Quiz-1 AnswersL3 Understanding the data ecosystem:Q1. Which of the following statements best defines data?
Q2. Fill in the blank: In data analytics, the data ecosystem refers to the various elements that interact with one another to produce, manage, store, _____, analyze, and share data.
Q3. Which of the following terms refers to the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making?
Q4. An airline collects, observes, and analyzes its customers’ online behaviors. Then, it uses the insights gained to choose what new products and services to offer. What business process does this describe?
Foundations: Data, Data, Everywhere Weekly challenge 1 AnswersQ1. Which of the following options describes data analysis?
Q2. A business collects and analyzes information about its employees in order to gain insights that unlock potential and create a more productive workplace. What practice does this describe?
Q3. In data analytics, a model is a group of elements that interact with one another. Q4. Fill in the blank: The term _____ is defined as an intuitive understanding of something with little or no explanation.
Q5. A company defines a problem it wants to solve. Then, a data analyst gathers relevant data, analyzes it, and uses it to draw conclusions. The analyst shares their analysis with subject-matter experts, who validate the findings. Finally, a plan is put into action. What does this scenario describe?
Q6. Fill in the blank: The people very familiar with a business problem are called _____. They are an important part of data-driven decision-making.
Q7. A data analyst finishes analyzing data for a marketing project. The results are clear, so they present findings to the client and ask for conclusions and recommendations. What should they have done first?
Q8. You have recently subscribed to an online data analytics magazine. You really enjoyed an article and want to share it in the discussion forum. Which of the following would be appropriate in a post? Select all that apply.
Foundations: Data, Data, Everywhere Week 2 Quiz AnswersPractice Quiz-1 AnswersL2 Embracing data analyst skills:Q1. Identify the pattern from left to right in the set of blocks below and try to predict which block should replace the block with the question mark. Answer: Q2. Here’s a more complex pattern. Identify the pattern from left to right in the images below and try to predict which image should come next. A series of different boxes containing shapes and patterns with the last box containing a question mark Based on the images above, which option comes next in the pattern? Answer: Q3. Now, find a pattern in a different format. Select the next number in the sequence: Fill in the blank: 9, 13, 17, 21, 25, 29, _____ Q4. The following numbers are in a sequence from left to right. Determine the pattern and decide which number should come next: Fill in the blank: 4, 9, 16, 25, 36, 49, _____ Q5. The following question is about recognizing and matching patterns in shapes that are the same, but viewed from different angles. Two shapes are similar when one can become the other after a rotation clockwise ⟳ or counterclockwise ↺, or a reflection horizontally ↔ and/or vertically ↕. Top right, bottom left is to top left, bottom right Your task is to choose the figure that completes the statement. Pay attention to the pattern by which the first and second shapes are related, and then figure out which choice matches shape 3. Fill in the blank: Top: left & center, middle: right IS TO top: right & center, middle: left AS top: right, middle: center, bottom: left IS TO Select the image below that completes the statement. Answer: Q6. The following question is about recognizing and matching patterns in shapes that are the same, but viewed from different angles. Two shapes are similar when one can become the other after a rotation clockwise ⟳ or counterclockwise ↺, or a reflection horizontally ↔ and/or vertically ↕. Your task is to choose the figure that completes the statement. Fill in the blank: Which image completes it? Answer: Q7. The following series of codes are in a sequence from left to right. There is a repeating pattern that you will notice. Determine the pattern and decide which code should come next. Fill in the blank: A1, B3, C5, D7, E9, F11, G13, _____ Q8. The following series of codes are in a sequence from left to right. There is a repeating pattern that you will notice. Determine the pattern and decide which sequence of letters should come next. Fill in the blank: A, AA, AAA, B, BA, BAA, BAAA, BB, BBA, BBAA, BBAAA, BBB, ________ Q9. Now, identify patterns in a word problem using a data visualization. There are 12 chocolates in a box: eight have caramel filling, six have coconut filling, and two have both caramel and coconut filling. Choose the best image that describes this box of chocolates. Answer: Q10. There are 10 children in a class and they have all brought sandwiches for lunch: five children have sandwiches with peanut butter, six children have sandwiches with jelly, and three children have sandwiches with both peanut butter and jelly. Find out how many children have sandwiches with neither peanut butter nor jelly and choose the image that describes the situation best. Answer: Practice Quiz-2 AnswersL3 Thinking about analytical thinking:Q1. What practice involves identifying, defining, and solving a problem by using data in an organized, step-by-step manner?
Q2. Data visualization is the graphical representation of information, including which of the following? Select all that apply. Q3. Gap analysis is used to examine and evaluate how a process currently works with the goal of getting to where you want to be in the future. Practice Quiz-3 AnswersL4 Thinking about outcomes:Q1. Fill in the blank: Curiosity, understanding context, and having a technical mindset are all examples of _____ used in data-driven decision-making.
Q2. Surveying customers about their preferences and using that information to inform business strategy is an example of data-driven decision-making. Q3. In data analysis, which analytical skill involves the management of people, processes, and tools?
Foundations: Data, Data, Everywhere Weekly challenge 2 AnswersQ1. Fill in the blank: Analytical skills are defined as _____.
Q2. A junior data analyst is seeking out new experiences in order to gain knowledge. They watch videos and read articles about data analytics. They ask experts questions. Which analytical skill are they using?
Q3. Identifying the motivation behind data collection and gathering additional information are examples of which analytical skill?
Q4. Having a technical mindset is an analytical skill involving what?
Q5. Which analytical skill involves managing the people, processes, and tools used in data analysis?
Q6. Correlation is the aspect of analytical thinking that involves figuring out the specifics that help you execute a plan. Q7. Fill in the blank: Detail-oriented thinking is about figuring out all of the _____ that will help you execute a plan.
Q8. The five whys is a technique that involves asking, “Why?” five times in order to achieve what goal?
Q9. What method involves examining and evaluating how a process works currently in order to get it where you want it to be in the future?
Q10. Data-driven decision-making involves the five analytical skills: curiosity, understanding context, having a technical mindset, data design, and data strategy. Each plays a role in data-driven decision-making. Foundations: Data, Data, Everywhere Week 3 Quiz AnswersPractice Quiz-1 AnswersL2 Following the data life cycle:Q1. Fill in the blank: During the _____ phase of the data life cycle, a business decides what kind of data it needs, how it will be managed, who will be responsible for it, and the optimal outcomes.
Q2. In the data life cycle, which phase involves gathering data from various sources and bringing it into the organization?
Q3. A data analyst finishes using a dataset, so they erase or shred the files in order to protect private information. This is called archiving. Q4. A dairy farmer decides to open an ice cream shop on her farm. After surveying the local community about people’s favorite flavors, she takes the data they provided and stores it in a secure hard drive so it can be maintained safely on her computer. This is part of which phase of the data life cycle? Q5. After opening the ice cream shop on her farm, the dairy farmer surveys the local community about people’s favorite flavors. She uses the data she collected to determine that the top five flavors are strawberry, vanilla, chocolate, mint chip, and peanut butter. She feels confident in her decision to sell these flavors. This is part of which phase of the data life cycle?
Practice Quiz-2 AnswersL3 Outlining the data analysis process:Q1. The data analysis process phases are ask, prepare, process, analyze, share, and act. What do data analysts do during the ask phase?
Q2. The data analysis process phases are ask, prepare, process, analyze, share, and act. A data analyst cleans data to ensure it’s complete and correct during the process phase. Q3. The data analysis process steps are ask, prepare, process, analyze, share, and act. During which phase would a data analyst use spreadsheets or query languages to transform data in order to draw conclusions? Q4. The data analysis process steps are ask, prepare, process, analyze, share, and act. In which step would a data analyst use visuals such as charts or graphs to simplify complex data for better understanding? Q5. A data analyst shares insights from their analysis during a formal presentation. In a slideshow, they make a data-driven recommendation for how to solve a business problem. What step of the data analysis process would come next? Practice Quiz-3 AnswersL4 The data analysis toolbox:Q1. A spreadsheet is a digital worksheet that enables data analysts to do which of the following tasks? Select all that apply.
Q2. Fill in the blank: A set of instructions that performs a specific calculation using spreadsheet data is called _____.
Q3. A database is a collection of data stored in a computer system. Q4. In data analytics, SQL is an acronym meaning _____ query language.
Q5. What is the term for the graphical representation of data?
Foundations: Data, Data, Everywhere Weekly challenge 3 AnswersQ1. The manage stage of the data life cycle is when a business decides what kind of data it needs, how the data will be handled, and who will be responsible for it. Q2. A data analyst has finished an analysis project that involved private company data. They erase the digital files in order to keep the information secure. This describes which stage of the data life cycle? Q3. In the analyze phase of the data life cycle, what might a data analyst do? Select all that apply.
Q4. Describe how the data life cycle differs from data analysis.
Q5. A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes which step of the data analysis process? Q6. Fill in the blank: Spreadsheets are _____ that can be used to store, organize, and sort data.
Q7. Fill in the blank: A formula is a set of instructions used to perform a specified calculation; whereas a function is _____.
Q8. Fill in the blank: A query is used to _____ information from a database. Select all that apply.
Q9. Structured query language (SQL) enables data analysts to communicate with a database. Q10. The graphical representation of information helps stakeholders understand data insights. Formulas and functions make this possible. Foundations: Data, Data, Everywhere Week 4 Quiz AnswersPractice Quiz-1 AnswersL2 Mastering spreadsheet basics:Q1. In a spreadsheet, what is text wrapping used for?
Q2. The columns in a spreadsheet are ordered by letter, and the rows are ordered by number. Q3. Fill in the blank: In a dataset, a row is called an observation. An observation includes all of the _____ for something contained in the row.
Practice Quiz-2 AnswersL3 Learn about Structured Query Language (SQL):Q1. SELECT * FROM employee WHERE jobCode = 'FTE' AND LastName = 'James'What does the asterisk (*) after SELECT tell the database to do in this query?
Q2. SELECT * FROM employee WHERE jobCode = 'FTE' AND LastName = 'James'In this query, the data analyst wants to retrieve data from which table?
Q3. SELECT * FROM employee WHERE jobCode = 'FTE' AND LastName = 'James'In this query, the data analyst wants to retrieve all data from the employee table, where the jobCode is FTE and the last name is James. Q4. You are writing a query and want to instruct the database to retrieve data from the warehouse_inventory table. What is the SQL statement that follows SELECT *? Type your answer below. FROM warehouse_inventoryPractice Quiz-3 AnswersL4 Visualizing the data:Q1. Fill in the blank: A data visualization is the _____ representation of information.
Q2. A data analyst uses data visualizations to support their findings. Q3. A data analyst is creating a data visualization to share with stakeholders. Which spreadsheet tool do they use to select different chart types?
Foundations: Data, Data, Everywhere Weekly challenge 4 AnswersQ1. In the following spreadsheet, the column labels in row 1 are called what? ABCD
Q2. In the following spreadsheet, the observation of Greensboro describes all of the data in row 4. ABCD
Q3. If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B? ABCD
Q4. A data analyst types =POPULATION(C2:C11) to find the average population of the cities in this spreadsheet. However, they realize that have used the wrong formula. What syntax will correct this function? Type your answer below. ABCD
Q5. In the following query, what is the asterisk (*) telling the database to do? SELECT *
Q6. In the following query, what is FROM telling the database to do? SELECT * FROM Orders
Q7. You are writing a query that asks a database to retrieve data about the customer with identification number 5656. The column name for customer identification numbers is customer_id. What is the correct WHERE clause syntax? Type your answer below. Q8. Fill in the blank: A data analyst creates a table, but they realize this isn’t the best visualization for their data. To fix the problem, they decide to use the _____ feature to change it to a column chart.
Q10. A data analyst wants to demonstrate how the population in Charlotte has increased over time. They create the chart below. What is this type of chart called?
Q1. Data-driven decision-making and the application of data strategy are examples of what?
Q2. Fill in the blank: Data-driven decision-making involves using _____ to guide business strategy.
Practice Quiz-3 AnswersL4 Defining fairness in data:Q1. What steps do data analysts take to ensure fairness when collecting data? Select all that apply. Include data self-reported by individuals Clean the data provided Understand the social context Use an inclusive sample population Q2. Avens Engineering needs more engineers, so they purchase ads on a job search website. The website’s data reveals that 86% of engineers are men. Based on that number, an analyst decides that men are more likely to be successful applicants, so they target the ads to male job seekers. What should the analyst have done instead?
Q3. A data analyst working on a project related to truck-driver safety discovers that all reported accidents involve male drivers. What is their best course of action?
Q4. On a railway line, peak ridership occurs between 7:00 AM and 5:00 PM. The fairness of a passenger survey could be improved by over-sampling data from which group?
Q5. A real estate company needs to hire a human resources assistant. The owner asks a data analyst to help them decide where to advertise the job opening. The analyst learns that the majority of human resources professionals are women, validates this finding with research, and targets ads to a women’s community college. This is fair because the analyst conducted research to make sure the information about gender breakdown of human resources professionals was accurate. Foundations: Data, Data, Everywhere Weekly challenge 5 AnswersQ1. An online gardening magazine wants to understand why its subscriber numbers have been increasing. What kind of reports can a data analyst provide to help answer that question? Select all that apply.
Q2. A doctor’s office has discovered that patients are waiting 20 minutes longer for their appointments than in past years. A data analyst could help solve this problem by analyzing how many doctors and nurses are on staff at a given time compared to the number of patients with appointments. Q3. What is the process of using facts to guide business strategy?
Q4. Fill in the blank: A business task is described as the problem or _____ a data analyst answers for a business.
Q5. Data-driven decision-making is using facts to guide business strategy. The benefits include which of the following? Select all that apply.
Q6. It’s possible for conclusions drawn from data analysis to be both true and unfair. Q7. Fill in the blank: Fairness is achieved when data analysis doesn’t create or _____ bias.
Q8. A gym wants to start offering exercise classes. A data analyst plans to survey 10 people to determine which classes would be most popular. To ensure the data collected is fair, what steps should they take? Select all that apply.
Next Course Quiz Answers >> Ask Questions to Make Data-Driven Decisions All Course Quiz Answers of Google Data Analytics Professional Certificate Course 01: Foundations: Data, Data, Everywhere Course 02: Ask Questions to Make Data-Driven Decisions Course 03: Prepare Data for Exploration Course 04: Process Data from Dirty to Clean Course 05: Analyze Data to Answer Questions Course 06: Share Data Through the Art of Visualization Course 07: Data Analysis with R Programming Course 08: Google Data Analytics Capstone: Complete a Case Study Foundations: Data, Data, Everywhere Course Review:In our experience, we suggest you enroll in the Foundations: Data, Data, Everywhere Course and gain some new skills from Professionals completely free and we assure you will be worth it. Foundations: Data, Data, Everywhere course is available on Coursera for free, if you are stuck anywhere between quiz or graded assessment quiz, just visit Networking Funda to get Foundations: Data, Data, Everywhere Quiz Answers This Course is a part of the Google Data Analytics Professional Certificate Conclusion:I hope this foundations: Data, Data, Everywhere Quiz Answers would be useful for you to learn something new from this Course. If it helped you then don’t forget to bookmark our site for more Coursera Quiz Answers. This course is intended for audiences of all experiences who are interested in learning about Data Analytics in a business context; there are no prerequisite courses. Keep Learning! report this ad |