Lesson Plan
Curated OER

How Much Is It?

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

Microsoft Office Excel

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

What's your favorite physical fitness activity?

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

Integers in the Weather

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

Creating a Bar Graph with a Graphing Program

For Teachers 5th - 9th
Students use the S'COOL data base to create a bar graph.
Lesson Plan
Curated OER

Graphing With a Spreadsheet

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

Metrically Me!

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

Conversation Heart Graphing

For Teachers 6th
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...
Lesson Plan
Polar Trec

Temperature Profile above the South Pole

For Teachers 5th - 8th Standards
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....
Lesson Plan
1
1
Bonneville

Making Observations and Recording Data for Solar Powered Water Pumping

For Teachers 2nd - 5th Standards
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...
Lesson Plan
Curated OER

Creating a Nutrition Table in MicroSoftExcel

For Teachers 6th - 8th
Students access the internet to find Nutritional information from a restaurant of their choice and compile their information into an excel spreadsheet.
Lesson Plan
Curated OER

M & Ms in a Bag

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

Graphing Pendulum Results

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

Height and Weight

For Teachers 3rd
Third graders explore their height and weight. They measure the heights and weights of their peers. Students record their data using an Excel spreadsheet. They create a graph to compare the data and analyze it for a correlation between...
Lesson Plan
Curated OER

Heartbeat Project

For Teachers 9th - 12th
Pupils enter information about their heartbeats into a spreadsheet. They construct data displays and calculate statistics. They describe and justify their conclusions from the data collected.
Lesson Plan
Curated OER

Is the Rainbow Fair?

For Teachers 3rd
Third graders perform statistical calculations. Given a bag of Skittles, 3rd graders sort and collect data regarding the colors included in their bag. Using spreadsheet software, students create a bar graph of the information collected....
Lesson Plan
Curated OER

Louisville's Best Field Day Park

For Teachers 7th - 12th
Students create a survey to hand out to determine the best field day park. Using their local area, they select five parks, if possible, that meet the criteria and calculate the distance and estimated time travel. They use this...
Lesson Plan
Intel

Prototyping

For Teachers 6th - 10th
I need something to test. The three sessions in this lesson have individuals build and test a prototype of their design. The first two sessions are devoted to prepping for the prototype by drawing up specifications and materials. The...
Lesson Plan
Curated OER

Favorite Apple Graph

For Teachers 1st
First graders record their favorite type of apple in the form of a graph. They each try one slice of a Red Delicious, Golden Delicious, and Granny Smith apple, select their favorite type, and create a class graph using the data collected.
Lesson Plan
Curated OER

Examine Your State Government's Demographics

For Teachers 8th - 11th
How is your state government organized? How many elected officials are women? What is the mean age of your state representatives? Young scholars answer these questions in a research project before creating a chart to reflect their...
Lesson Plan
Curated OER

4 Month Budget Spreadsheet

For Teachers 8th
Eighth graders create and maintain a spreadsheet budget based on a predetermined salary. They have an opportunity to make "investments and purchases." Budget records be kept for an imaginary 4 month period.
Lesson Plan
Curated OER

Get A Life

For Teachers 9th - 12th
Students explore choosing a career and living on a budget. They receive an alternative identity and must make choices and decisions based upon given situations. Students research possible solutions, and use spreadsheet technology to...
Lesson Plan
American Institutes for Research

Digital Smiles

For Teachers 4th - 6th
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
Lesson Plan
Curated OER

Sweet Data

For Teachers 3rd - 12th
Students input data about the colors of their serving of M&M candies onto a spreadsheet. They create charts and graphs based on this information.