Curated OER
Let's Get Linear
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.
Curated OER
The Viewing Tube
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...
Curated OER
Conversation Heart Graphing
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...
Curated OER
Data Analysis and Probability: Graphing Candy with Excel
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...
Curated OER
Adding and Subtracting Decimals With Excel
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.
Curated OER
Chart Challenge: Behavior Management
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.
Curated OER
How Big Is Your Head?
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...
Curated OER
kind of Bean
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.
Curated OER
Inserting Formulas in a Worksheet in Excel
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...
Curated OER
Hemlock Trees and the Pesky Pest, The Woolly Adelgid
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...
Curated OER
Excel: Working with Multiple Worksheets
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...
Curated OER
Microsoft Excel
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...
Curated OER
Excel Lesson
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.
Curated OER
Piecewise Linear Functions and Excel
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...
Curated OER
Using Excel To Teach Probability And Graphing
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...
Curated OER
Lemonade Business
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.
Curated OER
Excel Turns Data Into Information
Learners use excel to analyze data. In this technology activity, students enter data into the excel program to find averages and organize data.
Curated OER
How to keep a timecard in Excel
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.
Curated OER
Spreadsheet Means What
For this technology worksheet, students find the words in the word bank that correlate to the fifteen definitions for explaining a spreadsheet.
Curated OER
Introductory Excel Lesson involving Problem Solving
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.
Curated OER
Made Round To Go Round
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...
Curated OER
Using Imported Data in Excel
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.
Curated OER
Topic 6: Evaluating and Presenting Results
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.
Curated OER
Ict Activity 22
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.