Quick Look
Grade Level: 9 (810)
Time Required: 1 hours 30 minutes
(two 45minute class periods at least four days apart)
Expendable Cost/Group: US $0.00
Group Size: 1
Activity Dependency: None
Subject Areas: Data Analysis and Probability, Number and Operations, Physical Science
Summary
Students collect a large set of data (approximately 60 sets) of individual student’s water use and learn how to use spreadsheets to graph the data and find mean, median, mode, and range. They compared their findings to the national average of water use per person per day and use it to evaluate how much water a municipality would need in the event of a recovery from a water shutdown. This analysis activity introduces students to the concept of central tendencies and how to use spreadsheets to find them.Engineering Connection
All branches of engineering require acquiring and analyzing data—usually large sets of data. Measurements of central tendency (mean, median, mode, and range) are commonly used to evaluate these data sets. Environmental engineers rely on similar data sets to measure the amount of resources available or needed, and to evaluate what kind of remediation solution a municipality must take to solve a shortage of water or other event.
Learning Objectives
After this activity, students should be able to:
 Analyze data for measurements of central tendencies: mean, median, and mode.
 Make decisions based on data analysis.
Educational Standards
Each TeachEngineering lesson or activity is correlated to one or more K12 science,
technology, engineering or math (STEM) educational standards.
All 100,000+ K12 STEM standards covered in TeachEngineering are collected, maintained and packaged by the Achievement Standards Network (ASN),
a project of D2L (www.achievementstandards.org).
In the ASN, standards are hierarchically structured: first by source; e.g., by state; within source by type; e.g., science or mathematics;
within type by subtype, then by grade, etc.
Each TeachEngineering lesson or activity is correlated to one or more K12 science, technology, engineering or math (STEM) educational standards.
All 100,000+ K12 STEM standards covered in TeachEngineering are collected, maintained and packaged by the Achievement Standards Network (ASN), a project of D2L (www.achievementstandards.org).
In the ASN, standards are hierarchically structured: first by source; e.g., by state; within source by type; e.g., science or mathematics; within type by subtype, then by grade, etc.
NGSS: Next Generation Science Standards  Science

Analyzing data in 9–12 builds on K–8 and progresses to introducing more detailed statistical analysis, the comparison of data sets for consistency, and the use of models to generate and analyze data.
(Grades 9  12)
More Details
Do you agree with this alignment?

Analyze data using tools, technologies, and/or models (e.g., computational, mathematical) in order to make valid and reliable scientific claims or determine an optimal design solution.
(Grades 9  12)
More Details
Do you agree with this alignment?
Common Core State Standards  Math

Summarize, represent, and interpret data on a single count or measurement variable
(Grades
9 
12)
More Details
Do you agree with this alignment?

Use statistics appropriate to the shape of the data distribution to compare center (median, mean) and spread (interquartile range, standard deviation) of two or more different data sets.
(Grades
9 
12)
More Details
Do you agree with this alignment?

Make inferences and justify conclusions from sample surveys, experiments, and observational studies
(Grades
9 
12)
More Details
Do you agree with this alignment?
International Technology and Engineering Educators Association  Technology

Students will develop abilities to use and maintain technological products and systems.
(Grades
K 
12)
More Details
Do you agree with this alignment?

Use computers and calculators to access, retrieve, organize, process, maintain, interpret, and evaluate data and information in order to communicate.
(Grades
9 
12)
More Details
Do you agree with this alignment?
State Standards
Pennsylvania  Math

Summarize, represent, and interpret data on a single count or measurement variable.
(Grades
9 
12)
More Details
Do you agree with this alignment?

Make inferences and justify conclusions based on sample surveys, experiments, and observational studies.
(Grades
9 
12)
More Details
Do you agree with this alignment?
Pennsylvania  Science

 Compare and contrast scientific theories.
 Know that both direct and indirect observations are used by scientists to study the natural world and universe.
 Identify questions and concepts that guide scientific investigations.
 Formulate and revise explanations and models using logic and evidence.
 Recognize and analyze alternative explanations and models.
 Explain the importance of accuracy and precision in making valid measurements.
Do you agree with this alignment?
Materials List
Each group needs:
 A device with internet access; access to Google forms and Google sheets
To share with the entire class:
 Water Use Tracking Log
 Making Decisions: WaterUse Analysis Sheet
 Water Use Survey (see example on Google Forms)
 Survey Results Sheet (see example on Google Sheets)
Worksheets and Attachments
Visit [www.teachengineering.org/activities/view/drex2357wateruseconservationdataanalysiscentraltendency] to print or download.PreReq Knowledge
Basic knowledge of how to use Google docs, forms, and sheets.
Introduction/Motivation
As one of the most valuable resources on earth, water is critical to almost all aspects of human life—from daily household and municipal use to agricultural and industrial projects. The amount of it available in the world is constant, but it changes forms as it moves through the water cycle.
The water that we use in everyday life comes from groundwater or reservoirs that hold river water and rainwater. Municipal treatment plants process the water to make it clean enough to drink. However, towns can lose access to their water supply if there is an issue with the plant or contamination of the river water or reservoir. Engineers are often tasked with building systems that manage water supplies as well as mitigate problems that may arise with local water resources. While we may think of these systems as consisting of infrastructure (which they often do) engineers are often tasked with creating and measuring these systems using large amounts of data.
In this activity, you will analyze how much water your family uses in your house for 3 days. We will use this data to perform a data analysis to determine how much water would need to be delivered if we had to go without water in the event of a natural disaster. Environmental engineers use data analysis to assist communities in the event of natural disasters.
Procedure
Background
This activity can be taught as part of a unit on scientific methods and measurements. Previous lessons should focus on the scientific method, how to design an experiment, the SI (metric) system of measurements, and recommendations for layout of data tables and use of graphs to represent data. This is an activity to show the use of computer science to help organize and analyze data with bigger data sets then students may normally experience in a lab.
Measurements of central tendency are used to statistically analyze data. The mode is the least used method and only appropriate when analyzing nominal data. The mean is the most appropriate method for continuous, symmetrical data. If the data set is skewed then the median is usually the preferred method. Mean, median, and mode would be equal to each other in a normal, symmetrical data set.
To calculate the mean, or average, add up all the numbers, then divide by how many numbers there are. To find the median, find the central value in the data list. To find the mode, find the number that appears most often in the data set.
Before the Activity
The bulk of the activity is the Making Decisions: Water Use Analysis Sheet. At least four days before that portion of the activity, assign students the Water Use Tracking Log. Review that document in class and instruct them that they need to individually track their household’s water use for three days. Once all students have tracked three days of water use, then they are ready to move on to the Making Decisions: Water Use Analysis Sheet. This sheet includes links to a Water Use Survey (on Google Forms) Survey Results Sheet (on Google Sheets). Note: Teachers should clear the Google Sheet of previous class data before students begin the Making Decisions: Water Use Analysis Sheet, or they can make a new one based on the example.
With the Students
 Do a preassessment writing prompt: “Explain what mean, median, mode, and range are? How are they used in scientific investigations?” Gather the students answers and discuss as group.
 Go over the Making Decisions: Water Use Analysis Sheet. They need approximately 3040 minutes to use the sheet to quantify the liters of water that they used over the threeday period based on data from the Water Use Tracking Log.
 Once every student has their water use calculated, have students use the Water Use Survey (Figure 1) to log their personal water use. This feeds into a spreadsheet that shows every students water use. Use the Survey Results Sheet to access the Google document (Figure 2). Make this available to the students.
 Once all the data for the class has been entered, tell students to make their own copy of the spreadsheet and follow the instructions in the Making Decisions: Water Use Analysis Sheet to graph the data into a histogram (Figure 3) and use the spreadsheet to find mean, median, mode, and range.
 Have students answer the series of questions on their water use comparing it to the national average of 370 L/day. They may also calculate how much water would need to be shipped in to their town if they lost access to the municipal water supply in the event of a disruption.
 Circulate among students to help those having difficulty with the calculation of water use or difficulty with using the sheets commands.
Vocabulary/Definitions
central tendency: In statistics, a central or typical value for a probability distribution. It may also be called a center or location of the distribution.
hydrologic cycle: Continuous movement of water on, above, and below the surface of the Earth.
mean: The average of the numbers in a set or the calculated "central" value of a set of numbers. To calculate it: add up all the numbers, then divide by how many numbers there are.
median: The "middle" value in the list of numbers.
mode: The number which appears most often in a set of numbers.
Assessment
PreActivity Assessment
Writing prompt: Explain what mean, median, mode, and range are? How are they used in scientific investigations? (Mean is the average of the data set, median is the middle number in the data series, mode is the most repeated number in the data set, range is the largest number minus the smallest number.) They are used in scientific investigations to find the central tendency of the data set.
Discussion: Gather the students’ answers and discuss as a group.
Activity Embedded Assessment
Analysis Sheet: Have students complete the questions in the Making Decisions: Water Use Analysis Sheet and the student spreadsheets. Grade the questions based on how accurately they represent the data collected.
PostActivity Assessment:
Class Discussion: Discuss the questions in Making Decisions: Water Use Analysis Sheet or the Investigating Questions as a class. Have the students break into groups or discuss and analyze the data for mean, median, mode, and range.
Investigating Questions
These are all in the Making Decisions: Water Use Analysis Sheet.
 What is the range within your class? (From sample data set provided: 2899 L)
 Calculate the mean, median, and mode values for the class data. (From sample data set provided: mean = 528L; median = 429L; mode = 221)
 Compare your daily water use with the estimated average volume of water used daily by each person in the United States, that estimate is 370 gallons per day. Why would your value be different than the national average? (Varies by student, many had higher daily water use and many said it was because of extralong showers)
 Which is closer to the national average, water use or the class average? Why would that be? (Class average would be closer than personal water use in most cases. Averages smooth out the individual variances in the data)
 On the basis of the wateruse data collected and analyzed by your class, explain how you would estimate the total volume of water that would need to be hauled to our town for three days if our water supply was cut off? (Take the daily water use mean and multiply it by the population for daily water need. Then multiply that by 3 to find the 3day water needs)
 What other information could you gather that would help you improve your estimate above? Why? (Possible answers can include that the need of businesses and industries would be different that a student’s needs. Hospitals, day cared, and nursing homes would most likely need more water because so much cleaning is required)
 What assumptions did you make to complete your estimate? (The students assume that everyone needs the same amount of water that they need)
 If water was in limited supply what activity could you not do without? (Answers vary, many students said they would not do without showering and using it for cooking and drinking)
 How could you reduce your water use? (Answers vary, many students say they would stop watering lawns, washing cars and pets, take shorter showers)
 Impurities added by using water for one particular use may not prevent its reuse for other purposes. For example, you might decide to save dish water and use it later to water your plants. What are some activities where you could use impure water? (Answers vary. Possible answers include saving water from the washing machine to water their lawns or wash their cars)
Troubleshooting Tips
Watch what they enter as their daily water use, some accidentally put in the 3day total and you need to point out if the number looks too high and help them reevaluate their daily water use number.
Activity Extensions
In the next lab that the students do, collect the lab results from each group and each class and have the students analyze that data set for mean, median, mode, and range.
Activity Scaling
 For lower grades, provide more time for teacher support or do the spreadsheet analysis as a whole group, then break into small groups to answer the questions in teams.
 For higher grades reduce the time to two class days and instruct students to independently analyze the data sets, providing answers for mean, median, mode, and range.
Copyright
© 2019 by Regents of the University of Colorado; original © 2018 Drexel UniversityContributors
Jackie GartnerSupporting Program
REThink Project, College of Computing and Informatics, Drexel UniversityAcknowledgements
This material was developed based upon work supported by the National Science Foundation under grant no. EEC 1711773—RET in Engineering and Computer Science Site for Machine Learning to Enhance HumanCentered Computing at Drexel University. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the authors and do not necessarily reflect the views of the National Science Foundation.
Last modified: August 2, 2019
User Comments & Tips