Lesson Plan
Curated OER

Simple Bar Graphs Using Excel

For Teachers 6th - 8th
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Lesson Plan
Curated OER

Nascar Unit Activity 2

For Teachers 8th
Eighth graders divide into groups of 4 or 5. They go to the track and have every student run/walk one lap around the school track. Call out their times as they cross the finish line. In the computer lab, have the students create a table...
Lesson Plan
Curated OER

Math Lesson: What Do You Want to Know? - Country Statistics

For Teachers 9th - 12th
High schoolers are able to identify the characteristics of a variety of graphs (i.e. bar graph, line graph, pie graph, scatter plot, population pyramids, etc.) They recognize how the type of data to be presented plays a role in choosing...
Lesson Plan
Curated OER

The Big Hand Challenge

For Teachers K
Students utilize a computer spreadsheet to record and analyze data. In this problem solving lesson plan, students compare their hand size to that of the principal. Students understand standard and nonstandard measurement.
Lesson Plan
Curated OER

Money Math: Lessons for Life

For Teachers 11th - Higher Ed
Students develop a budget for a college student using all of the influences that the student would have.  In this budgeting lesson plan, students use real life examples to create a budget spreadsheet.  Students read and study...
Lesson Plan
Curated OER

Math TODAY Challenge - New Color of Money

For Teachers 9th - 12th Standards
Students read about the changes in the "new money" and then create a graph to represent various combinations of currency produced.
Lesson Plan
Curated OER

Graph Lesson

For Teachers 1st
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
Lesson Plan
Curated OER

Using Electronic Manipulatives in Multiplication

For Teachers 9th - 11th
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Lesson Plan
Curated OER

Graphing Our Marbles

For Teachers K
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
Lesson Plan
Curated OER

The Nifty Fifty-What's Your Size?

For Teachers 3rd - 5th
Students explore state populations. In this state geography activity, students use a variety of technology tools to research and graph population and area of assigned states.
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

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

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

How Long...?

For Teachers 3rd - 5th
Students explore measurement. They use appropriate units of measurement for different sized objects. Students collect their data and enter it into an Excel data base. They graph their findings and analyze their outcomes.
Lesson Plan
Alabama Learning Exchange

Origami Geometry

For Teachers 2nd - 5th Standards
Origami is an excellent way to combine Japanese culture, art, and geometric shapes into one engaging instructional activity! Scholars begin by listening to the story Sadako and the Thousand Paper Cranes and learn the origin of...
Lesson Plan
Curated OER

Band Tour Across America

For Teachers 8th - 10th
Students plan the trip of a band across America. In this money planning lesson, students create a budget for the band using excel basic functions. They manage the band and its budget and relate the tour to future budgeting needs of the...
Lesson Plan
Curated OER

Daily Time Ratios

For Teachers 7th - 9th
Students track and record how much time they spend on each activity. In this spreadsheet instructional activity, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time...
Lesson Plan
Curated OER

Tracking Your Favorite Web Sites

For Teachers 9th
Ninth graders track the hit count on their favorite web sites.  In this Algebra I activity, 9th graders record the number of hits on their favorite web site for twenty days.  Students explore the data to determine if the...
Lesson Plan
Curated OER

Made Round To Go Round

For Teachers 2nd - 3rd
In this lesson students investigate what it would cost to furnish one room of their choice by shopping on the Internet. Both Australian and American dollars are to be given for each item to demonstrate the difference between two...
Lesson Plan
Curated OER

Computer Olympics

For Teachers 2nd - 6th
Young scholars compete to achieve excellence in math facts, writing terms, problem solving, and writing skills on the computer. In this Computer Olympics lesson plan, students practice the skill of drill and practice in order to succeed...
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

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Students construct spreadsheets from raw data. In this spreadsheet construction instructional activity, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Lesson Plan
Curated OER

Fraction Strips on Excel

For Teachers 6th
Sixth graders create three different sets of fraction strips using Excel by following a packet of instructions that taper off as the students gain confidence in their knowledge of Excel. They copy and paste the strips into Word so that...
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...