Lesson Plan
Curated OER

Basic Excel

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

Data Displays with Excel

For Teachers 8th - 10th
Students collect and analyze data. In this statistics lesson, students display their data using excel. They plot the data on a coordinate plane and draw conclusion from their data.
Lesson Plan
Curated OER

Excel Lesson

For Teachers 9th - 10th
Students investigate Microsoft excel. In this technology lesson, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
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

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

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.
Unit Plan
Curated OER

Deciphering Word Problems in Order to Write Equations

For Teachers 5th - 8th Standards
Help young mathematicians crack the code of word problems with this three-lesson series on problem solving. Walking students step-by-step through the process of identifying key information, creating algebraic equations, and finally...
Lesson Plan
Curated OER

Tessellations in Excel

For Teachers 2nd - 9th
Students complete an Excel project on tessellations. In this technology and math lesson, students discuss tessellations and their occurrences in nature. Students use the Excel computer program to create tessellations.
Lesson Plan
Curated OER

The Math Star Wins the Cup

For Teachers K
Students recognize and count numbers 1-4 using a racing game. In this math lesson plan, students move cars around a racetrack by matching colors and seeing numbers. The student who finishes the race first is the winner.
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

Shoe Showdown

For Teachers 3rd
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
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

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

Get My Point!

For Teachers 3rd - 7th
Here is one of the better lessons I've come across on how to teach fractions and decimals. This lesson does a great job of showing how these two mathematical representations of numbers are interrelated. Some excellent websites, printable...
Unit Plan
National Security Agency

Introducing Integers and Their Operations

For Teachers 6th - 8th Standards
There's nothing negative about this mini-unit on integers! Engaging young mathematicians in a series of hands-on activities and collaborative learning opportunities, this resource offers an excellent way to introduce your class...
Lesson Plan
Curated OER

Math/Technology: Height Measurement

For Teachers 3rd
Third graders, using technology tools, determine the total height of their classmates in both inches and centimeters. Once the measurements are taken, they enter the results in the Excel file. Once students have prepared a KidPix number...
Lesson Plan
Curated OER

Place Value Review: Tens and Ones Place

For Teachers 1st - 2nd Standards
Young learners determine the place value of a digit in a given number.  They review 10s and 1s place value by participating in activities using unit blocks. Some excellent independent practice is built in to this plan. A written...
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

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

For Teachers 9th - 12th
Students 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 the...
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 on the Computer

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

Band Tour Across America

For Teachers 8th - 10th
Learners 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 lesson plan, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time spent each day....