+
Lesson Plan
Curated OER

Let's Get Linear

For Teachers 8th - 10th
Math whizzes utilize spreadsheets to examine linear modeling. They roll marbles down a ramp from three different heights and measure how far they roll. They use Excel to record their data and create a plot of their data.
+
Lesson Plan
Curated OER

The Viewing Tube

For Teachers 5th - 8th
Looking for an excellent lesson that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet.  This is a...
+
Lesson Plan
Curated OER

Conversation Heart Graphing

For Teachers 6th
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
+
Lesson Plan
Curated OER

Data Analysis and Probability: Graphing Candy with Excel

For Teachers 5th - 8th
Collect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to...
+
Lesson Plan
Curated OER

Adding and Subtracting Decimals With Excel

For Teachers 5th
What a great way to have pupils apply classroom learning to real-world skills! They complete problems involving the addition and subtraction of decimals related to banking-type questions, and then use a spreadsheet to display their results.
+
Lesson Plan
Curated OER

Chart Challenge: Behavior Management

For Teachers 3rd - 4th
Learners develop a behavior management plan using Excel. They use the computer to develop a behavior chart. Students record their behavior on a daily basis using the chart they developed using Excel.
+
Lesson Plan
Curated OER

How Big Is Your Head?

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

kind of Bean

For Teachers 3rd
Third graders sort different types of beans and collect the data. They create a data table, put the information on the data table and then graph their results. They answer follow-up questions.
+
Lesson Plan
Curated OER

Inserting Formulas in a Worksheet in Excel

For Teachers 9th
Ninth graders study the vocabulary necessary to create formulas in Microsoft Excel. They complete assigned problems from the textbook for each type of function demonstrated by the teacher until they have developed competency with each...
+
Lesson Plan
Curated OER

Hemlock Trees and the Pesky Pest, The Woolly Adelgid

For Teachers 5th - 6th
Students review Excel and how to create graphs with this program. They create two graphs in Excel, one showing the average number of woolly adelgid egg sacks on the outer 15 cm of hemlock branch at sites sorted by latitude, then one...
+
Lesson Plan
Curated OER

Excel: Working with Multiple Worksheets

For Teachers 4th - 8th
Students practice using education technology by creating spreadsheets.  In this Microsoft Excel lesson plan, students discover ways to work with several worksheets at once using Microsoft Excel, a spreadsheet program.  Students...
+
Lesson Plan
Curated OER

Microsoft Excel

For Teachers 9th - 11th
Young scholars investigate how to use Microsoft Excel. In this technology lesson, students enter their data into and excel spreadsheet and create formulas to manipulate their data. They test on their progress and analyze their data at...
+
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.
+
Worksheet
Curated OER

Piecewise Linear Functions and Excel

For Students Higher Ed
In this linear function activity, students use Excel worksheets to solve piecewise linear functions. They plot functions and produce piecewise linear functions. This six-page activity contains detailed instructions on how to use Excel...
+
Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

For Teachers 3rd - 8th
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
+
Lesson Plan
Curated OER

Lemonade Business

For Teachers 12th
Twelfth graders use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs. They use charts and graphs to make a Power Point Presentation.
+
Lesson Plan
Curated OER

Excel Turns Data Into Information

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

How to keep a timecard in Excel

For Teachers 3rd - 6th
Students fill out a timecard of family activities in Microsoft Excel. In this Excel lesson plan, students use the program to fill in times they do various activities with their families.
+
Worksheet
Curated OER

Spreadsheet Means What

For Students 6th - 8th
For this technology worksheet, students find the words in the word bank that correlate to the fifteen definitions for explaining a spreadsheet.
+
Lesson Plan
Curated OER

Introductory Excel Lesson involving Problem Solving

For Teachers 6th
Sixth graders analyze an introductory lesson for Microsoft Excel. They go step by step through the creation of a basic spreadsheet and the use of simple formulas in a problem solving format.
+
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

Using Imported Data in Excel

For Teachers 7th - 10th
Students import atmospheric data from the internet. In this earth science lesson, students graph the data they collected. They complete the worksheet after the activity.
+
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

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

Ict Activity 22

For Teachers 6th - 8th
Students use Excel to solve quadratic equations by trial and improvement. They enter formulas and try different solutions to improve their solutions more quickly. Afterwards, they report the solutions to different levels of accuracy.