Las Cumbres Observatory
Plotting an Asteroid Light Curve
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...
Curated OER
A Healthy Heart
Sixth graders create a spreadsheet using specific data. A speaker comes to discuss the heart, and the difference between anaerobic and aerobic activity. They make posters to encourage a healthy heart lifestyle.
Curated OER
Graph Lesson
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.
Curated OER
What Does George W. Bush Have in Common With Past U.S. Presidents?
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...
Foundation for Water & Energy Education
How Can a Dam Affect a River? Activity B
Second in a pair of activities, young ecologists continue to examine the food pyramid of a freshwater ecosystem. They take a look at the food pyramid drawn in Activity A and consider what would happen if a reservoir was created on the...
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 plan, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint...
Curated OER
A "Capital" Idea
Eighth graders prepare for a field trip to Washington, DC by researching landmark, monument, or building in Washington. They use the information in small groups to design a multimedia presentation. They include a spreadsheet that shows...
Curated OER
Correlation of Variables by Graphing
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.
Curated OER
Information Shuffle
Gather some information, print it onto sentence strips, and then have your class physically shuffle the cards to better understand the importance of organizational patterns in writing. Middle school learners examine information for a...
Virginia Department of Education
Mystery Iron Ions
Young chemists perform an experiment to determine if a compound is iron (II) chloride or iron (III) chloride. Then they determine the formula, balance the equation, and answer analysis questions.
Chicago Botanic Garden
Micro-GEEBITT Climate Activity
A truly hands-on and inquiry based learning activity bridges all the lessons in the series together. Beginning with a discussion on average global temperatures, young meteorologists use real-world data to analyze climate trends in order...
Curated OER
How Would You Spend a Million Dollars?
Students plan and organize a theme to spend one million dollars. They select a theme, research prices of items on the Internet, organize the information into a spreadsheet, write an introductory paragraph, and create a final project.
Curated OER
Spreadsheet Budget Project
Eighth graders record all the food they eat for one week, compute the costs for all of this food, and display the different categories on a spreadsheet and then convert to a chart.
Curated OER
Using Excel to Draw a Best Fit Line
Middle schoolers create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Middle schoolers print graphs without trend lines and...
ESL Kid Stuff
Daily Routines & Times of the Day
What time do you eat breakfast? Or go to school? Language learners practice crafting and answering questions about their daily routines.
Radford University
How Is Your Gender Represented?
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...
Curated OER
Creating a Bar Graph Using a Spreadsheet: Dice Rolling Probabilities
Tenth graders explore the concept of spreadsheets. They create a simple spreadsheet and chart from given data. Students perform basic formatting procedures on their chart. They use spreadsheet functions to perform calculations.
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
Graphing My Path to Success
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...
Curated OER
Using Excel to Reference and Graph Live Data from a Web Site
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...
Curated OER
Volcano Spreadsheet and Graph
Fourth graders use data from volcanoes to organize a spreadsheet and make a graph.
Curated OER
Three Squirrels and a Pile of Nuts
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,...
Curated OER
Party Math
Students create a spreadsheet that they will use to plan a small party or outing. They calculate expenses and stay within a budget amount for their party.
Curated OER
Should Voting in the United States be Mandatory? Research Activity
Eighth graders research how many voters actually vote in the U.S. and nine other nations. They create a spreadsheet using this information and write a persuasive essay.