Coursera was launched in 2012 by Daphne Koller and Andrew Ng with the goal of giving life-changing learning experiences to students all around the world. In the modern day, Coursera is a worldwide online learning platform that provides anybody, anywhere with access to online courses and degrees from top institutions and corporations.
Foundations: Data, Data, Everywhere Week 1 Quiz Answers
Practice Quiz-1 Answers
L3 Understanding the data ecosystem:
Q1. Which of the following statements best defines data?
- Data is an assortment of questions.
- Data is a business process.
- Data is a collection of facts.
- Data is the use of calculations and statistics.
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.
- organize
- ingest
- merge
- locate
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?
- Data life cycle
- Data insight
- Data elements
- Data analysis
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?
- Analytical thinking
- Performance measurement
- Collaboration with stakeholders
- Data-driven decision-making;
Foundations: Data, Data, Everywhere Weekly challenge 1 Answers
Q1. Which of the following options describes data analysis?
- Creating new ways of modeling and understanding the unknown by using raw data
- The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making
- The various elements that interact with one another in order to provide, manage, store, organize, analyze, and share data
- Using facts to guide business strategy
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?
- Workforce observation
- Employee retention
- Team collaboration
- People analytics
Q3. In data analytics, a model is a group of elements that interact with one another.
- True
- False
Q4. Fill in the blank: The term _____ is defined as an intuitive understanding of something with little or no explanation.
- awareness
- personal opinion
- rational thought
- gut instinct
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?
- Identification of trends
- Data-driven decision-making
- Customer service
- Data science
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.
- subject-matter experts
- stakeholders
- competitors
- customers
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?
- Archived the datasets in order to keep them secure
- Created a model based on the results of the analysis
- Shared the results with subject-matter experts from the marketing team for their input
- Surveyed customers about results, conclusions, and recommendations
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.
- Including an advertisement for how to subscribe to the data analytics magazine
- Checking your post for typos or grammatical errors
- Giving credit to the original author
- Including your own thoughts about the article;
Foundations: Data, Data, Everywhere Week 2 Quiz Answers
Practice Quiz-1 Answers
L2 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.
<image: svg%3E>
Answer:
<image: svg%3E>
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;
<image: svg%3E>
Based on the images above, which option comes next in the pattern?
Answer:
<image: svg%3E>
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, _____
- 10
- 55
- 33
- 25
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, _____
- 81
- 62
- 30
- 64
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
<image: svg%3E>
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
<image: svg%3E>
Select the image below that completes the statement.
Answer:;
<image: svg%3E>
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:
<image: svg%3E>
Which image completes it?
Answer:;
<image: svg%3E>
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, _____
- J15
- H16
- D17
- H15
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, ________
- BBBA
- BBBB
- BBAA
- BBAAA
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:
<image: svg%3E>
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:
<image: svg%3E>
Practice Quiz-2 Answers
L3 Thinking about analytical thinking:
Q1. What practice involves identifying, defining, and solving a problem by using data in an organized, step-by-step manner?
- Context
- Data design
- Analytical thinking
- Visualization
Q2. Data visualization is the graphical representation of information, including which of the following? Select all that apply.
- Icons
- Maps
- Charts
- Graphs
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.
- True
- False
Practice Quiz-3 Answers
L4 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.
- analytical skills
- business strategies
- thought processes
- data models
Q2. Surveying customers about their preferences and using that information to inform business strategy is an example of data-driven decision-making.
- True
- False
Q3. In data analysis, which analytical skill involves the management of people, processes, and tools?
- Data control
- Data strategy
- Data analytics
- Data design;
Foundations: Data, Data, Everywhere Weekly challenge 2 Answers
Q1. Fill in the blank: Analytical skills are defined as _____.
- qualities and characteristics associated with solving problems using facts
- an analyst’s intuition, inner voice, or gut instinct
- the management of people, processes, and tools
- the ability to break things down into smaller steps
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?
- Understanding context
- Curiosity
- Data strategy
- Having a technical mindset
Q3. Identifying the motivation behind data collection and gathering additional information are examples of which analytical skill?
- Data design;
- Understanding context
- Data strategy
- A technical mindset
Q4. Having a technical mindset is an analytical skill involving what?
- Managing people, processes, and tools
- Breaking things down into smaller steps or pieces
- Understanding the condition in which something exists or happens
- Balancing roles and responsibilities
Q5. Which analytical skill involves managing the people, processes, and tools used in data analysis?
- Curiosity
- Understanding context
- Data strategy
- Data design
Q6. Correlation is the aspect of analytical thinking that involves figuring out the specifics that help you execute a plan.
- True;
- False
Q7. Fill in the blank: Detail-oriented thinking is about figuring out all of the _____ that will help you execute a plan.
- specifics
- datasets
- instructions
- information
Q8. The five whys is a technique that involves asking, “Why?” five times in order to achieve what goal?
- Identify the root cause of a problem
- Visualize how a process should look in the future
- Use facts to guide business strategy
- Put a plan into action
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?
- Gap analysis
- The five whys
- Strategy
- Data visualization
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.
- True
- False;
Foundations: Data, Data, Everywhere Week 3 Quiz Answers
Practice Quiz-1 Answers
L2 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.
- archive
- planning
- manage
- capture
Q2. In the data life cycle, which phase involves gathering data from various sources and bringing it into the organization?
- Manage
- Analyze
- Archive
- Capture
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.
- True
- False
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?
- Manage
- Plan
- Analyze
- Archive
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?
- Capture
- Plan
- Analyze
- Archive;
Practice Quiz-2 Answers
L3 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?
- Clean the data
- Define the problem to be solved
- Collect and store data
- Create data visualizations.
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.
- True
- False
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?
- Act
- Analyze
- Process
- Prepare
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?
- Process
- Share
- Act
- Prepare
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?
- Act
- Prepare
- Ask
- Process
Practice Quiz-3 Answers
L4 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.
- Store data
- Organize data in columns and rows
- Sort and filter data
- Automatically access the latest data in real-time
Q2. Fill in the blank: A set of instructions that performs a specific calculation using spreadsheet data is called _____.
- a program
- a function
- an operation
- a formula
Q3. A database is a collection of data stored in a computer system.
- True
- False
Q4. In data analytics, SQL is an acronym meaning _____ query language.
- structured
- syntax
- software
- statistical
Q5. What is the term for the graphical representation of data?
- Data visualization
- Data summary
- Data language
- Data collection
Foundations: Data, Data, Everywhere Weekly challenge 3 Answers
Q1. 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.
- True
- False
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?
- Manage
- Destroy
- Plan
- Archive
Q3. In the analyze phase of the data life cycle, what might a data analyst do? Select all that apply.
- Use a formula to perform calculations
- Use spreadsheets to aggregate data
- Create a report from the data
- Choose the format of spreadsheet headings
Q4. Describe how the data life cycle differs from data analysis.
- The data life cycle deals with transforming and verifying data; data analysis is using the insights gained from the data.
- The data life cycle deals with the stages that data goes through during its useful life; data analysis is the process of analyzing data.
- The data life cycle deals with making informed decisions; data analysis is using tools to transform data.
- The data life cycle deals with identifying the best data to solve a problem; data analysis is about asking effective questions.
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?
- Analyze
- Process
- Share
- Act
Q6. Fill in the blank: Spreadsheets are _____ that can be used to store, organize, and sort data.
- digital worksheets
- formulas and functions
- interactive dashboards
- visual representations
Q7. Fill in the blank: A formula is a set of instructions used to perform a specified calculation; whereas a function is _____.
- a question written by the user
- a predefined operation
- a computer programming language
- a particular value
Q8. Fill in the blank: A query is used to _____ information from a database. Select all that apply.
- update
- request
- retrieve
- analyze
Q9. Structured query language (SQL) enables data analysts to communicate with a database.
- True
- False
Q10. The graphical representation of information helps stakeholders understand data insights. Formulas and functions make this possible.
- True
- False;
Foundations: Data, Data, Everywhere Week 4 Quiz Answers
Practice Quiz-1 Answers
L2 Mastering spreadsheet basics:
Q1. In a spreadsheet, what is text wrapping used for?
- To allow text to overflow into an adjacent cell
- To automatically change cell height in order to allow all of the text to fit inside
- To remove text that is too long to fit in a cell
- To clip text within a cell so it doesn’t overflow into an adjacent cell
Q2. The columns in a spreadsheet are ordered by letter, and the rows are ordered by number.
- True
- False
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.
- names
- commonalities
- attributes
Practice Quiz-2 Answers
L3 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?
- Select, then delete data.
- Select and filter data.
- Select and multiply data.
- Select all data.
Q2.
SELECT * FROM employee WHERE jobCode = ‘FTE’ AND LastName = ‘James’
In this query, the data analyst wants to retrieve data from which table?
- LastName
- employee
- James
- jobCode
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.
- True
- False
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_inventory;
Practice Quiz-3 Answers
L4 Visualizing the data:
Q1. Fill in the blank: A data visualization is the _____ representation of information.
- contextual
- tabulated
- graphical
- attributed
Q2. A data analyst uses data visualizations to support their findings.
- True
- False
Q3. A data analyst is creating a data visualization to share with stakeholders. Which spreadsheet tool do they use to select different chart types?
- Chart Editor
- Chart Maker
- Chart Picker
- Chart Chooser;
Foundations: Data, Data, Everywhere Weekly challenge 4 Answers
Q1. In the following spreadsheet, the column labels in row 1 are called what?
A | B | C | D 1RankNamePopulationCounty21Charlotte885,708Mecklenburg32Raleigh474,069Wake (seat), Durham43Greensboro296,710Guilford54Durham278,993Durham (seat), Wake, Orange65Winston-Salem247,945Forsyth76Fayetteville211,657Cumberland87Cary170,282Wake, Chatham98Wilmington123,784New Hanover109High Point112,791Guilford, Randolph, Davidson, Forsyth1110Concord96,341Cabarrus |
- Attributes
- Characteristics
- Descriptors
- Criteria
Q2. In the following spreadsheet, the observation of Greensboro describes all of the data in row 4.
A | B | C | D 1RankNamePopulationCounty21Charlotte885,708Mecklenburg32Raleigh474,069Wake (seat), Durham43Greensboro296,710Guilford54Durham278,993Durham (seat), Wake, Orange65Winston-Salem247,945Forsyth76Fayetteville211,657Cumberland87Cary170,282Wake, Chatham98Wilmington123,784New Hanover109High Point112,791Guilford, Randolph, Davidson, Forsyth1110Concord96,341Cabarrus |
- True
- False
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?
A | B | C | D 1RankNamePopulationCounty21Charlotte885,708Mecklenburg32Raleigh474,069Wake (seat), Durham43Greensboro296,710Guilford54Durham278,993Durham (seat), Wake, Orange65Winston-Salem247,945Forsyth76Fayetteville211,657Cumberland87Cary170,282Wake, Chatham98Wilmington123,784New Hanover109High Point112,791Guilford, Randolph, Davidson, Forsyth1110Concord96,341Cabarrus |
- Organize range
- Sort range
- Name range
- Randomize range
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.
A | B | C | D 1RankNamePopulationCounty21Charlotte885,708Mecklenburg32Raleigh474,069Wake (seat), Durham43Greensboro296,710Guilford54Durham278,993Durham (seat), Wake, Orange65Winston-Salem247,945Forsyth76Fayetteville211,657Cumberland87Cary170,282Wake, Chatham98Wilmington123,784New Hanover109High Point112,791Guilford, Randolph, Davidson, Forsyth1110Concord96,341Cabarrus |
=AVERAGE(C2:C11)
Q5. In the following query, what is the asterisk (*) telling the database to do?
SELECT *
- Return one specific field.
- Select all of the data from the table.
- Filter certain information.
- Use proper syntax.
Q6. In the following query, what is FROM telling the database to do?
SELECT * FROM Orders
- From which field data should be stored
- From which table to select data
- From which filter data should be selected
- From which field data should be updated
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.
WHERE customer_id = 5656
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.
- image
- rename
- chart editor
- filter view
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?
<image: svg%3E>
- Column chart
- Area chart
- Line chart
- Bar chart;
Foundations: Data, Data, Everywhere Week 5 Quiz Answers
Practice Quiz-1 Answers
L2 Roles of a data analyst:
Industry data example | Industry Use geographic data to power GPS technology in carsTechnologyUse demographic data to target advertisements for a new consumer product for youthsMarketingUse stock market data to determine which portfolios to invest inFinanceUse bed occupancy data to determine the number of nurses and orderlies to schedule on a given shiftHealthcareUse past booking data to accurately anticipate levels of demand for hotel roomsHospitalityUse population data to determine which communities need federal fundingGovernment |
Practice Quiz-2 Answers
L3 Making decision with data:
Q1. Data-driven decision-making and the application of data strategy are examples of what?
- Business metric
- Business platform
- Business mission
- Business task
Q2. Fill in the blank: Data-driven decision-making involves using _____ to guide business strategy.
- facts
- processes
- intuition
- tools;
Practice Quiz-3 Answers
L4 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?
- Make sure their recommendation doesn’t create or reinforce bias
- Decline to accept ads from Avens Engineering because of fairness concerns.
- Let Avens Engineering decide which type of applicants to target ads to.
- Only show ads for the engineering jobs to women.
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?;
- Disregard accidents that weren’t caused by driver error.
- Take a closer look at the social context of their conclusion.
- Analyze the safety data for other types of drivers.
- Create a report to share the results with project stakeholders.
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?
- Nighttime riders
- Daytime riders
- Male passengers
- Female passengers
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.
- True
- False;
Foundations: Data, Data, Everywhere Weekly challenge 5 Answers
Q1. 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.
- Reports that predict the success of sales leads to secure future subscribers
- Reports that compare past weather patterns to the number of people taking up gardening recently
- Reports that show how many customers shared positive comments about the gardening magazine on social media in the past year
- Reports that examine how a recent 50%-off sale affected the number of subscription purchases
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.
- True
- False
Q3. What is the process of using facts to guide business strategy?
- Data programming
- Data visualization
- Data ethics
- Data-driven decision-making
Q4. Fill in the blank: A business task is described as the problem or _____ a data analyst answers for a business.
- solution
- comment
- question
- complaint
Q5. Data-driven decision-making is using facts to guide business strategy. The benefits include which of the following? Select all that apply.
- Getting a complete picture of a problem and its causes
- Using data analytics to find the best possible solution to a problem
- Making the most of intuition and gut instinct
- Combining observation with objective data
Q6. It’s possible for conclusions drawn from data analysis to be both true and unfair.
- True
- False
Q7. Fill in the blank: Fairness is achieved when data analysis doesn’t create or _____ bias.
- resolve
- reinforce
- constrain
- highlight
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.
- Collect data anonymously.
- Survey only people who don’t currently go to the gym.
- Increase the number of participants.
- Ensure participants represent a variety of profiles and backgrounds.
Review:
Based on our knowledge, we urge you to enroll in this course so you can pick up new skills from specialists. It will be worthwhile, we trust.