Lesson Plan
Curated OER

Cross Cultural Transportation and Resources Exchange

For Teachers 10th - 11th
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Lesson Plan
Curated OER

Favorite Food

For Teachers K
Students are given three choices of food. They then decide on their favorite and predict what the class's favorite food will be. After the teacher enters the data into the computer, students gather around the computer to view the...
Lesson Plan
Curated OER

Apple Graph

For Teachers K - 1st
Students sample three types of apples. They choose their favorite apple. They create a graph, charting the favorite apples of their classmates. They answer a series of questions.
Lesson Plan
Curated OER

Graphs! Graphs! Graphs!

For Teachers 6th - 8th
Students practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the lesson.
Lesson Plan
Curated OER

BUS: Farming: It's A Fact (Ag)

For Teachers 9th - 12th
Students create two different types of graphs from the information in the "Farm Facts" booklet (i.e., bar graph, pie chart, etc.). They calculate where your food dollars are spent (on and off farm).
Lesson Plan
Curated OER

Trends of Snow Cover and Temperature in Alaska

For Teachers 9th - 12th
Students gather historical snow cover and temperature data from the MY NASA DATA Web site. They compare this data to data gathered using ground measurements from the ALISON Web site for Shageluk Lake. They graph both sets of data and...
Lesson Plan
Curated OER

Skittle it Up

For Teachers 6th - 8th
Students make a graph. In this graphing and Excel lesson, students work in groups and are given a bag of skittles. Students count the number of each color skittle and create a table in Excel. Students learn how to make a pie graph using...
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature instructional activity, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend...
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

Data! Data! Graph that Data!

For Teachers 5th
Fifth graders create data graphs using Microsoft Excel. In this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Lesson Plan
Curated OER

Creating a Spreadsheet and Graph

For Teachers 4th - 5th
Students create graphs in Excel.  In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions to create the...
Lesson Plan
Curated OER

One, Two, Three...and They're Off

For Teachers 5th - 6th
Students make origami frogs to race. After the race they measure the distance raced, collect the data, enter it into a chart. They then find the mean, median, and mode of the data. Next, students enter this data into Excel at which time...
Worksheet
K12 Reader

Displaying Data

For Students 2nd - 3rd Standards
It's important to learn how to display data to make the information easier for people to understand. A reading activity prompts kids to use context clues to answer five comprehension questions after reading several paragraphs about...
Lesson Plan
Curated OER

Creating Circle Graphs with Microsoft Excel

For Teachers 9th - 10th
Students create graphs of circles. In this geometry lesson, students use Microsoft Excel to create graphs. They construct the graphs using paper and pencil as well as the computer.
Lesson Plan
Curated OER

Students Favorites

For Teachers 7th - 8th
Students complete activities using a frequency table and construct a pie graph for the data. For this frequency table lesson, students complete a survey to find data for a frequency table. Students use the given link to make a pie graph...
Lesson Plan
Curated OER

Student Costs Data Table

For Teachers 5th - 7th
Students compare and contrast two routes selected for a virtual field trip. They create a data table of educational activities, lodging, and meal costs using Microsoft Excel software.
Lesson Plan
Curated OER

Seasons and Cloud Cover, Are They Related?

For Teachers 6th - 12th
Students use NASA satellite data to see cloud cover over Africa.  In this seasons lesson students access data and import it into Excel. 
Lesson Plan
Code.org

Making Data Visualizations

For Teachers 9th - 12th
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The...
Lesson Plan
Curated OER

Spreadsheet Graphs

For Teachers Higher Ed
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
Lesson Plan
Curated OER

Integration and the "Barrier Breakers": Black Baseball 1945-1960

For Teachers 9th - 12th
Students explore integration of Major League Baseball, identify important individual baseball players who played key roles in integration, and analyze historical information through charts, graphs, and statistics.
Lesson Plan
Curated OER

Graphing on the Computer

For Teachers 6th - 8th
Students create a bar graph on the computer using given information from the teacher. They create a bar graph using their own information chart (they need to create one on separate paper first). They utilize Microsoft Excel for this...
Lesson Plan
Curated OER

Creating Circle Graphs with Microsoft Excel

For Teachers 7th
Seventh graders will learn how to construct circle graphs using paper and pencil. Then they will learn how to construct circle graphs using Microsoft Excel. This lesson uses technology and shows learners how to cross skills into the...
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

Excel Lesson Plan Coin Statistics

For Teachers 2nd
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...

Other popular searches