Center for Math and Science Education
Solar System Launch
Trying to understand the vastness of outer space can be quite a challenge for young scientists. Help put things in perspective with this cross-curricular activity as students work in pairs creating scaled models of...
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,...
It's About Time
Metals and Nonmetals
Did you know you can melt the metal gallium with just the heat of your hand? Pupils observe and test materials in order to classify them as metal or non-metal. A reading passage and analysis questions wrap up the lesson.
Conneticut Department of Education
Personal Finance Project Resource Book
Balancing a budget, paying taxes, and buying a home may feel out of reach for your high schoolers, but in their adult years they will thank you for the early tips. A set of five lessons integrates applicable money math...
Teach Engineering
Understanding the Air through Data Analysis
Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...
CK-12 Foundation
Newton's Method
Does the accuracy of the first guess make a difference down the line? Learners investigate the effects of the iterative process of finding roots, using Newton's Method. By moving the initial guess of a root on a graph, pupils observe the...
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...
Curated OER
Dude, You Gotta Move
In this biomes worksheet, students create a project about biomes after completing online research with websites given. Students complete 4 steps in completing their project.
Curated OER
BRIDGING THE GENERATION GAP
High schoolers create a hypothesis about the attitudinal differences between generations, test their hypothesis with a survey, chart their findings, and present their answers to the class.
Curated OER
Code Crackers Math Game
Middle schoolers, through this math game, are provided with opportunities to work with math operations and simple algebraic equations. They create a spreadsheet-based "rule machine."
Curated OER
How Much Is It?
Middle schoolers explore foreign currencies. For this foreign currencies lesson, students simulate travel to another country and determine the value of the US dollar compared to other countries. Middle schoolers use a conversion table...
Curated OER
Microsoft Office Excel
Learners use Microsoft Office Excel. In this technology lesson, students enter data on a spreadsheet using Excel. This programs tallies data and presents it using graphs.
Curated OER
What's your favorite physical fitness activity?
Fourth graders engage in a class discussion where they create a list of their favorite physical fitness activities. They tally the numbers on the board and use Microsoft Excel to create a spreadsheet and graph of the activities.
Curated OER
Integers in the Weather
Middle schoolers engage in a clever instructional activity that combines meteorology with mathematical thinking. They use integers in relation to high and low temperatures that they record. They use a spreadsheet of weather data, a...
Curated OER
Creating a Bar Graph with a Graphing Program
Students use the S'COOL data base to create a bar graph.
Curated OER
Graphing With a Spreadsheet
Fourth graders review how to create bar, line and circle graphs. Using jelly beans, they collect data and present it in a bar graph form. They enter the same data into a spreadsheet and watch as the program creates the same graph. They...
Curated OER
Metrically Me!
Students define the parts of a database, search strategies to locate information electronically, create/modify databases, etc. and enter data into a prepared spreadsheet to perform calculations.
Curated OER
Conversation Heart Graphing
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
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....
Bonneville
Making Observations and Recording Data for Solar Powered Water Pumping
Get pumped about an activity with water pumps. The fifth of seven installments in the Understanding Science and Engineering unit has pupils learn how to make observations, record data, and create data displays. Each group measures the...
Curated OER
Endangered Species
In this geography worksheet, high schoolers identify how to manipulate data on a range of endangered species. They create a bar graph of endangered animals from Africa, Asia, Australia, North America, or South America. Students use a...
Curated OER
Creating a Nutrition Table in MicroSoftExcel
Students access the internet to find Nutritional information from a restaurant of their choice and compile their information into an excel spreadsheet.
Curated OER
M & Ms in a Bag
Students make predictions about the number and colors of M&M's in a snack size package. They create an Excel spreadsheet to record the data from their small group's bag, create a graph of the data, and discuss the variations of data...
Curated OER
Graphing Pendulum Results
Sixth graders set up a pendulum experiment deciding which variable to manipulate (length of string or weight on the string). They create a hypothesis, collect necessary equipment, and write out each step of their experiment. They then...