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. In 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...
Curated OER
What's Playing Tonight?
Students 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. Students 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
Students create a spreadsheet. For 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
Young scholars 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
Pumped Up Gas Prices
Learners calculate gas prices. In this transportation instructional activity, 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...
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
Who is Being Left Behind?
Students 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
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...
Curated OER
Spreadsheet Function Machine
Students create a spreadsheet to analyze functions. In this algebra lesson plan, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Curated OER
Measuring Ourselves
Fifth graders conduct various measurement activities on themselves and a partner. They measure their height, weight, thumb-to-pinky span, and body temperature, recording the information in the form of an Excel spreadsheet.
Curated OER
American History Through Architectural Masterpieces: Monticello
Students examine the life of Thomas Jefferson, explore great American landmark Monticello, discover relationships between climate, geographical factors, and time as to what kind of architecture was used, conduct research online, write a...
Curated OER
What Temperature Is It?
Students use the internet to research information on the average maximum and minimum temperature for a city in their state. They create spreadsheets and enter data to analyze the information, focusing on averages, maximums, minimums and...
Curated OER
I'm in the Money - Practical Money Skills
Students make a budget and utilize math skills to keep a record of what they spend. They use technology and spreadsheets to help them keep track of their money.