Lesson Plan
Curated OER

Charting and Graphing Sales

For Teachers 3rd - 5th
Students analyze graphs, charts and tables. For this data analysis lesson, students practice creating and analyzing charts, graphs and tables corresponding to sales and surveys. This lesson uses data relevant to students and includes...
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. In 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

A Data Processing Lesson for Statistics -- Reading a Table or Chart

For Teachers 10th - 11th
Learners identify the structure and key parts of tables and charts. They determine which data is meanjngful and make comparisons with the data. They describe the scope of the AIDS plague throughout the world.
Lesson Plan
Curated OER

Fractions and Measurement

For Teachers 2nd - 3rd
Using a Smart Board, or a plain ol' white board or chalkboard, the teacher pulls up a grid and demonstrates how squares and rectangles can be divided up into equal parts. The class will get their own graph paper to draw shapes and divide...
Lesson Plan
Curated OER

Five Minute Adding Frenzy (B)

For Teachers 1st - 2nd
In this addition worksheet, young scholars complete a five minute addition frenzy sheet. They complete 4 charts finding the sums of the columns and rows in each space. They have five minutes to finish each chart with 98% accuracy.
Lesson Plan
Curated OER

Charting The Planets

For Teachers 7th - 12th
Students conduct different activities in order to unlock the secrets of the universe. They answer different questions that are written to assess knowledge of the planets. Information can be found on the internet to help.
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
Lesson Plan
Curated OER

Akhenaton

For Teachers 6th - 8th
Students look into the development of religious beliefs. In this ancient civilization lesson, students research the founders of several world religions including Akhenaton. Students use their findings to create world religion charts and...
Lesson Plan
Curated OER

Candy Database

For Teachers 3rd - 5th
Students make a database of their Halloween candy and decide which types are the healthiest. In this diet lesson plan, students make written data charts using their candy, locate dietary information on one type, sort the candy by shape,...
Lesson Plan
Curated OER

Muggie Maggie

For Teachers 3rd - 4th
Learners explore the book Muggie Maggie by Beverly Cleary. In this vocabulary instructional activity, students read to discover multiple meaning words, synonyms, antonyms and identify important details. Learners make story predictions...
Lesson Plan
Curated OER

Colorful Fractions

For Teachers 4th - 5th
Students use charts to show fractions.  In this fractions and percents instructional activity, students review fractions, percents and ratios.  Students create tables and color the cells to make different fractions. ...
Lesson Plan
Curated OER

Five Minute Adding Frenzy (A)

For Teachers 5th - 8th
In this five minute adding frenzy worksheet, students problem solve four charts containing a hundred addition equations in each in less than five minutes for each one.
Lesson Plan
Curated OER

Sorting

For Teachers 4th - 6th
Students examine how sorting is the process of putting things into an orderly sequence based on some key value. In this lesson students create a spreadsheet with 26 rows of data, then sort those rows by different values.
Lesson Plan
Curated OER

Technology Integration Lesson Plan: Civil War Spreadsheet

For Teachers 8th
Eighth graders discuss and analyze Civil War data, manually graph data on handout, work with partners to enter data into spreadsheets, and create charts on spreadsheet for each data set.
Lesson Plan
Curated OER

Graphing Data on Ellis Island

For Teachers 3rd
Third graders use data to make a bar graph. In this graphing and social studies lesson, 3rd graders use data about where Ellis Island immigrants came from to complete a bar graph on Microsoft Excel.
Lesson Plan
Curated OER

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.
Lesson Plan
Curated OER

And You Thought Gasoline Was Expensive!

For Teachers 3rd - 12th
Students carry out a cost analysis. In this comparative math lesson, students compare the cost of equal measures of gasoline to mouthwash, house paint, fruit juice, white-out, and other liquids.
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

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. For this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to their...
Lesson Plan
Curated OER

Synonyms

For Teachers 3rd - 4th
Students examine synonyms from their reading. In this synonyms lesson, students use vocabulary from their reading to create a chart and illustrate the words. Students complete online activities from the story.
Lesson Plan
Curated OER

Excel Lesson

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

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
Lesson Plan
Curated OER

Around the World

For Teachers K - 5th
Young scholars discuss the major geographical and cultural differences in the world. In this social science lesson, students pretend they are traveling and research information about where they wish to stay by finding information about...
Lesson Plan
Curated OER

Elements of Messages

For Teachers 9th - 12th
Students examine media messages. In this media awareness lesson, students analyze political cartoons and identify the literary elements they incorporate. Students also use the Media Elements Handout to identify the elements in other...