Lesson Plan
Curated OER

Parts of a Spreadsheet

For Teachers 9th - 12th
Learners create their own spreadsheet. They identify the different parts that make up a spreadsheet and organize their data. They practice using functions and formats.
Lesson Plan
Curated OER

Creating a Spreadsheet

For Teachers 8th - 10th
Students create a spreadsheet using ICT. In this algebra lesson, students collect and graph their data using a spreadsheet. They find solution to a given problem using trial and error.
Lesson Plan
Curated OER

Using a Spreadsheet

For Teachers 8th - 10th
Students create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
Activity
Las Cumbres Observatory

Plotting a Supernova Light curve

For Teachers 6th - 12th
Supernovas burn for a short time but can give scientists extensive information about the universe. Learners analyze given data about the change in the light magnitude of a supernova. They look for patterns in the data and use them to...
Lesson Plan
Curated OER

Using Electronic Manipulatives in Multiplication

For Teachers 9th - 11th
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Activity
101 Questions

Coins in a Circle

For Teachers 9th - 12th Standards
Round and round you'll go! Learners watch as different-sized circles fill with coins. They collect data and then make a prediction about the number of coins that will fit in a large circular rug.
Lesson Plan
Curated OER

Discovering Pi

For Teachers 9th - 11th
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
Lesson Plan
Curated OER

Math Hunt

For Teachers 8th - 10th
Go on a scavenger hunt around your school to find evidence of math. Investigate different areas of your school for patterns, fractions, and different geometric shapes. Finally, create a spreadsheet and plot the data you've collected.
Lesson Plan
Curated OER

Spreadsheet Function Machine

For Teachers 7th - 8th
Students create a spreadsheet to analyze functions. In this algebra lesson, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Lesson Plan
Curated OER

Reading & Using a Nutrition Label

For Teachers 8th - 12th
Students discover the importance of healthy eating. Using food nutrition labels, they read and examine the nutritional value. Students collect the data on a spreadsheet and create a graph. They analyze the media influences on product...
Lesson Plan
Curated OER

Growing a Seed

For Teachers 2nd - 3rd
Seeing how seeds grow into plants is such an enjoyable for students! They plant lima bean seeds and take pictures to record the growth of their plants. Students write in a journal to describe their daily observations of their plants, and...
Lesson Plan
Curated OER

Excel Lesson

For Teachers 5th
Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...
Lesson Plan
Statistics Education Web

Are Female Hurricanes Deadlier than Male Hurricanes?

For Teachers 9th - 12th Standards
The battle of the sexes? Scholars first examine data on hurricane-related deaths and create graphical displays. They then use the data and displays to consider whether hurricanes with female names result in more deaths than hurricanes...
Lesson Plan
Curated OER

A Comparison Study of Water Vapor Data to Precipitation over North America

For Teachers 10th - 12th
Young scholars use NASA satellite data to compare water vapor over the United States.  In this data analysis instructional activity students use an Excel spreadsheet to map their data. 
Activity
Las Cumbres Observatory

Plotting an Asteroid Light Curve

For Teachers 6th - 12th Standards
Data can tell us a lot about celestial objects that are just too far away to study otherwise. Learners examine data on the brightness of an asteroid to predict its rotation rate. Graphing the data reveals a periodic pattern that allows...
Lesson Plan
Curated OER

Graph Lesson

For Teachers 1st
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
Lesson Plan
Curated OER

What Does George W. Bush Have in Common With Past U.S. Presidents?

For Teachers 6th
Sixth graders discover what it takes to become President of the United States. Using a database, they complete a scavenger hunt to determine what George W. Bush has in common with past Presidents. They also create a spreadsheet which...
Lesson Plan
Curated OER

Correlation of Variables by Graphing

For Teachers 7th - 10th
Middle and high schoolers use a spreadsheet to graph data. In this graphing lesson, learners determine how two parameters are correlated. They create a scatter plot graph using a computer spreadsheet.
Unit Plan
Radford University

How Is Your Gender Represented?

For Teachers 9th - 12th Standards
Does the media shape people's views on gender? Scholars use data on gender portrayal in magazines to explore the idea. They use a spreadsheet program to create bar graphs and perform a chi-square test. They also use provided data to...
Lesson Plan
Curated OER

Graph Frenzy!!

For Teachers 6th - 7th
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.
Lesson Plan
Curated OER

Graphing My Path to Success

For Teachers 7th
Seventh graders examine their school performance through self-assessment of strengths and weaknesses. They construct a line graph, plotting all courses and achievements. Students use graph paper and colored pencils for each activity. If...
Lesson Plan
Curated OER

Using Excel to Reference and Graph Live Data from a Web Site

For Teachers 6th - 8th
Learners collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and examine any...
Lesson Plan
Curated OER

Three Squirrels and a Pile of Nuts

For Teachers 6th - 8th
Students solve story problems using a spreadsheet in combination with various problem-solving strategies. Working in teams of three, students create attempt to solve a story problem using three different methods; using manipulative,...
Lesson Plan
Curated OER

Houses and Cars and Loans

For Teachers 8th - 10th
Young scholars create a spreadsheet to track their spending. In this algebra lesson, students use loan formulas to calculate the payback amount plus interest on a loan. They calculate how much money they would need to buy a car and...