Curated OER
Introduction to the National Debt
Learners relate the national debt to the economy. In this algebra lesson, students discuss what the national debt is, create a national budget based on priority and what the government should spend money on. They analyze their findings...
Curated OER
Acceleration Science
In collaborative groups, physics learners design and create a web portfolio of internet resoucres explaining poitive and negative acceleration, zero acceleration, and positive and negative velocity. This is a terrific assignment for...
Curated OER
Energy Efficiency Ambassadors
Young scholars research energy conservation devices. They also create their own light efficiency project and presents their findings on science fair night.
Yummy Math
Parametric Equations and a Heart
Trigonometry, art, and Valentine's Day come together in a creative activity about parametric equations. Learners calculate several equations before graphing them either by hand, on a graphic calculator, or Excel spreadsheet to curve...
Polar Trec
Temperature Profile above the South Pole
Collecting and understanding data is a big part of understanding the world and how it changes. To better grasp what temperatures are changing and how they affect global populations, learners create a graph based on the date provided....
Curated OER
Pizza! Pizza!
Third graders tally, sort, and organize pizza orders from monthly school sales. They create an advertising campaign to promote the School Pizza Sale, record the data in graph form, compare and contrast the tallies throughout the year,...
Museum of Tolerance
Why is This True?
Are wages based on race? On gender? Class members research wages for workers according to race and gender, create graphs and charts of their data, and compute differences by percentages. They then share their findings with adults and...
EngageNY
Sampling Variability in the Sample Mean (part 2)
Reduce variability for more accurate statistics. Through simulation, learners examine sample data and calculate a sample mean. They understand that increasing the number of samples creates results that are more representative of the...
Noyce Foundation
Ducklings
The class gets their mean and median all in a row with an assessment task that uses a population of ducklings to work with data displays and measures of central tendency. Pupils create a frequency chart and calculate the mean and median....
Inside Mathematics
Aaron's Designs
Working with transformations allows the class to take a turn for the better. The short assessment has class members perform transformations on the coordinate plane. The translations, reflections, and rotations create pattern designs on...
California Education Partners
T Shirts
Which deal is best? Learners determine which of two companies has the best deal for a particular number of shirts. They begin by creating a table and equations containing each company's pricing structure....
Howard Hughes Medical Institute
Human Impacts on Biodiversity
Have you always wanted to take your science class on an amazing field trip they will never forget? Now you can! Observe the wildlife in an African savanna through trail cameras with a five-part data analysis activity. Learners analyze...
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...
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...
Teachers Pay Teachers
What Kind of Smart Are You
Gain insight into the type of learners that fill your classroom. An eight-question survey asks scholars questions about themselves. Using their color-coded answers, they conclude their degree of intelligence in multiple areas—music,...
Curated OER
Introduction to Spreadsheets
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...
Curated OER
Graphing Data from the Chemistry Laboratory
High schoolers graph and analyze data using a spreadsheet.
Curated OER
Tasty Tech Activity With Excel
Students are introduce to basic Excel skills, rank their opinions of menu items from fast food restaurants, add their answers to the spreadsheet, and then create a simple graph of the results.
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
Building Arrays Using Excel Spreadsheets
Students create arrays using Microsoft Excel. In this technology-based math instructional activity, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
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...
Curated OER
Loving Literature
First graders, after having "Are You My Mother?" by P.D. Eastman read to them, participate in group discussions or independentally work to analyze a spreadsheet to identify essential elements in the story and graph their data. In...
Curated OER
Graphing
Students gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the class.
Curated OER
Math: Football Fever Fun
Students compile statistics from high school or other football team and construct a spreadsheet on which to record their findings. Using Chart Wizard to analyze the data, they construct charts and graphs for a visual display of the...