Hi, what do you want to do?
Curated OER
Parts of a Spreadsheet
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.
Curated OER
Creating a Spreadsheet
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.
Curated OER
Using a Spreadsheet
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.
Las Cumbres Observatory
Plotting a Supernova Light curve
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...
Curated OER
Using Electronic Manipulatives in Multiplication
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...
101 Questions
Coins in a Circle
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.
Curated OER
Discovering Pi
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.
Curated OER
Math Hunt
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.
Curated OER
Spreadsheet Function Machine
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.
Curated OER
Reading & Using a Nutrition Label
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...
Curated OER
Growing a Seed
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...
Curated OER
Excel Lesson
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...
Statistics Education Web
Are Female Hurricanes Deadlier than Male Hurricanes?
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...
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
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.
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
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...
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.
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
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
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
Houses and Cars and Loans
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...