Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Curated OER
Data! Data! Graph that Data!
Fifth graders create data graphs using Microsoft Excel. For this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Curated OER
Gummy Bear Math
First graders predict, collect data, and create a graph based on gummy bear colors they are given. For this graphing lesson plan, 1st graders first predict how many colors of gummy bears there are. They then count the colors, graph them,...
Curated OER
Are You Full of Hot Air?
Explore the concept of measuring and recording circumference. In this physical science and measurement lesson, young learners blow up balloons, measure the circumference, and record the data on an interactive graphing website.
Curated OER
Identifying Ozone Variations over Different Locations
Students analyze ozone data. In this atmosphere lesson, students will use a NASA resource to gather data for different regions of the Earth. Students will then create a graph for their data and answer related questions.
Curated OER
Creek Detectives WISE On-line Research Community
Students investigate ways people cause harm to the environment. In this environmental lesson, students explore a case study on the Internet. Students explore all of the online activities and collect data for a presentation.
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.
American Institutes for Research
Digital Smiles
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
Curated OER
Gingerbread Man Math
Students collect and explore gingerbread man data. In this math and technology lesson plan, students examine how to organize and interpret data in three formats: objects, pictures, and graphs.
Curated OER
Create a Graph Online
Scholars create colorful bar, line, or pie graphs. They decide on a survey question to ask or a type of data to gather. From there, they collect information and data. They display this data in bar, line, or pie graphs that they create...
Curated OER
Graph Frenzy!!
Students brainstorm for a survey question to ask classmates. They survey their classmates. They enter the results into a spreadsheet and create the best graph for the information. They share their graphs with the class.
Curated OER
Collecting Data and Graphing
Eighth graders, in groups, count the different colors of M&M's in each kind of package and then draw a pictograph to show the results. Each group writes a program to show their results and then compare the manually-drawn and computer...
Curated OER
Designing a Study
Students explore features to consider when designing a scientific study. In this science research lesson plan, students examine different methods of data collection and consider which method would be appropriate for determining how many...
Curated OER
Basic Excel
Students explore basic Excel spreadsheets. In this spreadsheet lesson plan, students enter Alaska weather information and perform calculations. Students title the columns on the spreadsheet and format the cells. ...
Curated OER
Countdown to Disaster
Students discover the potential dangers of weather in their hometown. In this environmental lesson, students research Hurricane Hugo and the devastation it caused South Carolina in 1989. Students record weather data from...
Curated OER
Statistics Newscast in Math Class
Learners study sports teams, gather data about the teams, and create a newscast about their data. In this sports analysis lesson, students research two teams and define their statistical data. Learners compare the two teams, make...
Curated OER
Math Morphing Proximate and Evolutionary Mechanisms
Students identify the different types of fractals. In this geometry lesson, students use math to analyze different biological phenomena. They collect data from the experiments and construct graphs.
Howard Hughes Medical Institute
Spreadsheet Tutorial 4: t-Test
The t-test tutorial will fit your needs to a T. After calculating the mean, sum of squares, standard deviation, and variance of two data sets on a spreadsheet, scholars learn to calculate the t-values. They then learn to use the TTEST...
Curated OER
Excel temperature Graphs
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome. Students will find the average weather and add a trend line to their graph.
Curated OER
Calculating Profits from Selling Virtual Lemonade
Students set up and collect data for a virtual lemonade stand. In this entrepreneurship, economics, and technology lesson, students purchase ingredients, determine costs, and set up a virtual lemonade stand. Students consider weather...
Curated OER
How to Graph in Excel
Fourth graders construct data graphs on the Microsoft Excel program. In this statistics lesson, 4th graders formulate questions and collect data. Students represent their results by using Excel.
Curated OER
Graphing Family Reading Habits
Second graders collect data from their families about their reading habits and graph them. In this graphing family reading habits lesson, 2nd graders interview family members about their reading habits. They then use a graphing computer...
Curated OER
Livelihood of the Times
Students recognize the importance of analyzing historical information and data. In this historical analysis lesson, students collect information for a bar graph, complete a jobs worksheet and define vocabulary.
Curated OER
Dino-Myte Spreadsheet
Do your learners like dinosaurs and theme parks? An ambitious lesson plan invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which must include...