Curated OER
Hemlock Trees and the Pesky Pest, The Woolly Adelgid
Young scholars review Excel and how to create graphs with this program. They create two graphs in Excel, one showing the average number of woolly adelgid egg sacks on the outer 15 cm of hemlock branch at sites sorted by latitude, then...
Curated OER
Microsoft Office Excel
Middle schoolers use Microsoft Office Excel. In this technology lesson, students enter data on a spreadsheet using Excel. This programs tallies data and presents it using graphs.
Towson University
Looking Backwards, Looking Forward
How do scientists know what Earth's climate was like millions of years ago? Young environmental scholars discover how researchers used proxy data to determine the conditions present before written record. Grouped pupils gain experience...
American Statistical Association
Scatter It! (Using Census Results to Help Predict Melissa’s Height)
Pupils use the provided census data to guess the future height of a child. They organize and plot the data, solve for the line of best fit, and determine the likely height and range for a specific age.
Curated OER
Tides at the Battery, NY
Skill in using Excel and increasing proficiency in manipulating data are challenged with this data analysis work. A web link supplies data and step-by-step instructions help learners create a graph. There are many extension activities...
Curated OER
kind of Bean
Third graders sort different types of beans and collect the data. They create a data table, put the information on the data table and then graph their results. They answer follow-up questions.
Curated OER
Excel Turns Data Into Information
Students use excel to analyze data. In this technology lesson, students enter data into the excel program to find averages and organize data.
Curated OER
The Viewing Tube
Looking for an excellent instructional activity that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet. ...
Curated OER
It's Your Life - Safe or Sorry/Safety Issues
Students examine and chart data about safety hazards and unsafe situations. For this safety hazard lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the data and...
Curated OER
Historical Pollution in the Hudson: Part 2
Ninth graders practice how to format and enter data into an Excel spreadsheet, make a graph, and interpret graphed data. They recognize how the pollution in the Hudson River has changed over time, and explain the consequences of these...
Curated OER
Graphing on the Computer
Young scholars create a bar graph on the computer using given information from the teacher. They create a bar graph using their own information chart (they need to create one on separate paper first). They utilize Microsoft Excel for...
Curated OER
Going Graph-y
Second graders listen to and dicuss the story Where the Wild Things Are. They play a pantomime game and act out various feelings so their classmates can guess. They listen for the frequency of certain words, and record their findings on...
Curated OER
Does cloud type affect rainfall?
Student use MY NASA DATA to obtain precipitation and cloud type data. They create graphs of data within MY NASA DATA. Students compare different cloud types, compare precipitation, and cloud type data They qualitatively describe graphs...
Curated OER
Populations Lab - Cultures Lesson: Statistics / Sampling Patterns
Ninth graders examine the application of statistical sampling, data collection, analysis, and representation that exists in schooling and teenage lifestyles in Japan and the United States.
Curated OER
Using Spreadsheets and Graphs
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
Curated OER
The Numbers Tell the Story
Students demonstrate how to gather and interpret statistical data. In this data analysis lesson, students search for statistics on the health effects of smoking and place the information into charts. Students create these charts online...
Curated OER
Great Graphing
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Curated OER
Using Excel To Teach Probability And Graphing
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
Curated OER
Bias in Statistics
Students work to develop surveys and collect data. They display the data using circle graphs, histograms, box and whisker plots, and scatter plots. Students use multimedia tools to develop a visual presentation to display their data.
Teach Engineering
Energy Perspectives
The data says ... the resource is great to use. Using Microsoft Excel, pupils analyze data from the US Department of Energy in the fifth lesson of a 25-part Energy Systems and Solutions unit. Each group looks at a different data set and...
Curated OER
Counting
First graders explore collecting data. They collect data using a data collection sheet and enter the data into Excel. Students create graphs using Excel. They share their graphs with the class.
Curated OER
Shoe Showdown
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
Curated OER
How Big Is Your Head?
Students explore measurement by measuring classmates' heads. They record their measurements and they put the measurements in order from smallest to largest. Students figure the mean, median, mode, maximum, minimum, and range of their...
Curated OER
Lemonade Business
Twelfth graders use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs. They use charts and graphs to make a Power Point Presentation.