Lesson Plan
Curated OER

Graphing Using Excel

For Teachers 5th
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information.  For this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the...
Lesson Plan
Curated OER

Counting

For Teachers 1st
First graders explore collecting data. They collect data using a data collection sheet and enter the data into Excel. Students create graphs using Excel. They share their graphs with the class.
Lesson Plan
Curated OER

Excel Lesson

For Teachers 4th - 5th
Students explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
Lesson Plan
Curated OER

Going Graph-y

For Teachers 2nd
Second graders listen to and dicuss the story Where the Wild Things Are. They play a pantomime game and act out various feelings so their classmates can guess. They listen for the frequency of certain words, and record their findings on...
Lesson Plan
Curated OER

What's Up With My Class

For Teachers 6th - 8th
Students collect data about their class and they use Excel spreadsheet to display their tables and graphs about the class. They answer survey questions and collect their data. Students create a graph of their choice to display the...
Lesson Plan
Curated OER

Excel Turns Data Into Information

For Teachers 3rd - 8th
Students use excel to analyze data. In this technology lesson plan, students enter data into the excel program to find averages and organize data.
Lesson Plan
Curated OER

Farm Stories, Animal Webbing, Favorite Farm Animal Graph

For Teachers K
Students brainstorm animals they would expect to see on a farm. They save these on a Kidspiration web. Students watch or read a farm story. They discuss the characters. Students vote for their favorite farm animal and crate a graph using...
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

Algebra: Coordinates and Straight Line Graphs

For Teachers 4th - 5th
Young mathematicians review what they have previously learned about coordinates and straight line graphs. Then, they access an interactive component within the lesson to gain more practice with this skill. Additionally, there are two...
Lesson Plan
Curated OER

Graphing Surveys and Analyzing Data

For Teachers 10th - 11th
Students analyze data and graph the results of their surveys. In this statistics lesson plan, students create graphs using excel to make graphs to be able to better observe their data. They conclude how great we as unique individuals.
Lesson Plan
Curated OER

Beginning Graphs in MS Excel

For Teachers 3rd - 5th
Students practice creating graphs in Microsoft Excel. In this technology lesson, students conduct a random survey and collect data. Students use the Microsoft Excel program to create a bar graph of the data.
Lesson Plan
Curated OER

Hopes and Dreams: A Spreadsheet Lesson Using Excel

For Teachers 4th
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
Lesson Plan
Curated OER

Using Excel to Draw a Best Fit Line

For Teachers 6th - 8th
Students 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. Students print graphs without trend lines and manually draw...
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

How Big Is Your Head?

For Teachers 4th - 5th
Students explore measurement by measuring classmates' heads. They record their measurements and they put the measurements in order from smallest to largest. Students figure the mean, median, mode, maximum, minimum, and range of their...
Lesson Plan
Polar Trec

How Much Data is Enough?

For Teachers 6th - 12th Standards
The next time you read a magazine or watch the news, make note of how many graphs you see because they are everywhere! Here, scholars collect, enter, and graph data using computers. The graphs are then analyzed to aid in discussion of...
Lesson Plan
Curated OER

Exploring Graphs

For Teachers 7th - 8th
Students are introduced to connecting graphing in a coordinate plane to making scatterplots on a graphing calculator. Working in pairs, they connect points plotted to make a sailboat and complete questions on a worksheet as well as plot...
Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Learners explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Learners title the columns on the spreadsheet and format the cells. ...
Lesson Plan
Curated OER

What's Your Shoe Size? Linear Regression with MS Excel

For Teachers 8th - 12th
Learners collect and analyze data. In this statistics lesson, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
Lesson Plan
Curated OER

Excel for Beginners

For Teachers 4th - 5th
In this Excel lesson, students set a formula to check their homework. Students also use clipart, work in groups, and learn to use the tools in the drop-down list.
Lesson Plan
Curated OER

Graphs! Graphs! Graphs!

For Teachers 6th - 8th
Learners 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.
Worksheet
Yummy Math

Parametric Equations and a Heart

For Students 8th - 12th Standards
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...
Lesson Plan
Curated OER

Speed + Graphing = Winners!

For Teachers 5th
Fifth graders take addition timed tests every day for a two week period. Using the data from the timed tests, they create a bar graph using Microsoft Excel computer software, a personal bar graph using graph paper and colored pencils,...
Lesson Plan
Curated OER

Graphing

For Teachers 5th - 12th
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.