Curated OER
Weather, Weather, Everywhere!
Sixth graders collect weather data to compare temperatures around the world. Using the Internet, learners collect data, put it into spreadsheets, and analyze and graph the results. An interesting way to cover the topic of weather.
Curated OER
Buying a Car
Eighth graders create spreadsheets to calculate payments. They create a list of items they would like to purchase that require monthly payments. They simulate buying a car and create a spreadsheet to determine the amount of the monthly...
Curated OER
Solving Polynomial Equations
Students demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Curated OER
Rouge River Data
Students participate in using Excel sofware in order to create graphs. They create the graphs using data that they gathered during the Rouge River Field Trip they attended. The produce bar graphs from the excel spreadsheets.
Curated OER
Meet The Graphs
Students identify two types of graphs. They analyze and interpret authentic data shown in bar and pie graphs and complete a graph given specific data. Perform simple functions within an Excel document:
Curated OER
Graphically Speaking
Students discover the links between population and Congressional representation. In this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.
Curated OER
One, Two, Three...and They're Off
Students make origami frogs to race. After the race they measure the distance raced, collect the data, enter it into a chart. They then find the mean, median, and mode of the data. Next, students enter this data into Excel at which time...
Curated OER
Creating Climographs
Students use satellite data to compare precipitation and surface temperatures on different islands. For this satellite lesson students create graphs and explain the differences between weather and climate.
Code.org
Making Data Visualizations
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The activity encourages...
Curated OER
What's Playing Tonight?
Pupils collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Pupils answer statistical questions regarding the data.
Curated OER
Topic 6: Evaluating and Presenting Results
Students construct spreadsheets from raw data. In this spreadsheet construction lesson, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Curated OER
Dental Detectives
First graders explore the theme of dental health and hygeine. They make tooth loss predictions, count lost teeth, and graph tooth loss. In addition, they listen to dental health stories, read online stories, create spreadsheets, and play...
Curated OER
Pedestrian Safety for Students
Young scholars create a spreadsheet. In this spreadsheet lesson, students take the responses they received from a pedestrian safety survey to create their spreadsheet. Then they turn this information into a graph.
Curated OER
Penny Pushing
Fifth graders use an Excel spreadsheet to show them how to enter the amount of pennies they bring each week to school for a fundraising project. They count their pennies each Friday and enter the total amount in the correct columns. In...
Curated OER
Dough Lake Topology
High schoolers practice coordinates and measurements, develop 2D, 3D topological map, construct grid with string on real surface, establish "level" fixed point for measurements, take and record data points of elevation, and enter data on...
Curated OER
The Hundred Penny Box
Sixth graders research payload specialists and see how many are men and how many are women and what countries they come from. They then create an excel spreadsheet to reflect data they found and must have two graphs for interpretation.
Curated OER
What Color Are Your Skittles?
Students create spreadsheets and manipulate data. They collect data, create appropriate graphs and use percentages to describe quantities. Students compare and contrast data. They use spreadsheets to generate a pie chart.
Curated OER
Pumped Up Gas Prices
Students calculate gas prices. In this transportation lesson, students tally the mileage and gas costs of their car for one months. They figure out how much was spent on gas and create a graph showing average gas prices over time.
Curated OER
Don't Settle for a Byte... Get the Megabyte on Technology
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
Curated OER
Comuter Technology-Applying Spreadsheet Information
Students create spreadsheets and practice sorting within the spreadsheet with three different activities. Students manipulate different materials such as addresses, real estate sales, and athletic participation numbers.
Curated OER
Who is Being Left Behind?
Learners investigate scores as they relate to race. In this algebra lesson, students analyze standardized scores and how race can affect these scores. They plot their findings on a graph and draw conclusions.
Curated OER
Using A Volunteer Acquired Database Constructed On The Internet, Examine the Relationship between Dissolved Oxygen and Water Temperature
Ninth graders access a database and open a spreadsheet. In this oxygen and water temperature lesson students save the database, sort it and generate scatter plot graphs.
Curated OER
Significant Science: Statistics for Planet Earth
Ninth graders discover how statistics are used to interpret results of scientific experiments. Students write hypotheses and test the hypotheses by collecting data and organizing the data. Students graph their data to produce a visual....
Curated OER
Tiling a Patio
Fifth graders practice, with spreadsheets, to demonstrate how to determine the number of tiles needed to create a patio. They use pictures and gathered data to determine a pattern that can be used to solve problems. Students create a...