+
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

What's Up With My Class

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

Excel Turns Data Into Information

For Teachers 3rd - 8th
Students use excel to analyze data. In this technology lesson, 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
Illustrative Mathematics

Bike Race

For Teachers 7th - 9th Standards
A graph not only tells us who won the bike race, but also what happened during the race. Use this resource to help learners understand graphs. The commentary suggests waiting until the end of the year to introduce this topic, but why...
+
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, 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

Data Lesson Vital Information

For Teachers K - 2nd
Students prepare and collect data and use excel and create a graph. They collect data about the number of pattern blocks that are put on tables. Students then record that data in Excel.
+
Lesson Plan
Curated OER

Curious Clouds

For Teachers 2nd
Second graders explore clouds. They read The Cloud Book by Tomie dePola. Students sort the cloud pictures into three categories. Students create a graph using the cloud pictures. They use Excel to create a bar graph.
+
Activity
2
2
Teach Engineering

Using Hooke's Law to Understand Materials

For Teachers 10th - 12th Standards
Provide a Hooke for a lesson on elasticity with an activity that has groups investigate a set of springs. They use a set procedure to collect data to calculate the spring constant for each spring using Hooke's Law. The groups predict the...
+
Lesson Plan
Illustrative Mathematics

Who Has the Best Job?

For Teachers 7th - 9th Standards
Making money is important to teenagers. It is up to your apprentices to determine how much two wage earners make with their after school jobs. Participants work with a table, an equation, and a graph and compare the two workers to see...
+
Lesson Plan
Curated OER

Data Collection

For Teachers 3rd - 5th
Students write a journal exercise that relates to pets. They collect information from each other in order to practice making and interpreting bar graphs. They Continue building different kinds of graphs with the group.
+
Lesson Plan
Curated OER

Class Birthday Graph

For Teachers 2nd - 3rd
Students analyze the basics of an Excel spreadsheet. They highlight cells in a spreadsheet. They make a column graph. Students are introduced to X-axis and Y-axis. They play various address games on the spreadsheet.
+
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

Microsoft Office Excel

For Teachers 6th - 8th
Middle schoolers use Microsoft Office Excel. In this technology lesson plan, students enter data on a spreadsheet using Excel. This programs tallies data and presents it using graphs. 
+
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
Young scholars 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. Young scholars print graphs without trend lines and...
+
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 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.
+
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
Curated OER

Data! Data! Graph that Data!

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

Fairy Tales

For Teachers 6th
Sixth graders explore the elements of fairy tales. In this fairy tales lesson, 6th graders analyze several versions of Cinderella from around the world. Students graph fairy tale elements using Excel and create Venn diagrams comparing...
+
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 graph are...