Lesson Plan
Curated OER

Basic Excel

1st - 4th
Students explore basic Excel spreadsheets.  In 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

Excel Lesson

4th - 5th
Young scholars explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
Lesson Plan
Curated OER

Excel Lesson

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

Let's Get Linear

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
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Lesson Plan
Curated OER

Multiplication Tables Using Microsoft Excel

8th
Eighth graders are introduced to Microsoft Excel as a computer application software program. They create multiplication tables in Microsoft Excel. Students work in small groups. They discuss the $ (anchor) function in Microsoft Excel.
Lesson Plan
Curated OER

Excel Lesson

9th - 10th
Students investigate Microsoft excel. In this technology lesson plan, 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

Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs

5th - 12th
Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
Lesson Plan
Curated OER

Using Spreadsheets and Graphs

3rd
Third graders explore mathematics by utilizing computers. In this graphing activity, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
Lesson Plan
Curated OER

Conversation Heart Graphing

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

The Viewing Tube

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

EXCEL It!

5th - 8th
Students surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.
Lesson Plan
Curated OER

Hopes and Dreams: A Spreadsheet Lesson Using Excel

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

Shoe Showdown

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

Building Arrays Using Excel Spreadsheets

3rd - 5th
Students create arrays using Microsoft Excel. For this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Lesson Plan
Curated OER

Interest Calculation and Spreadsheets

5th - 12th
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
Lesson Plan
Curated OER

Using Excel to Reference and Graph Live Data from a Web Site

6th - 8th
Young scholars collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and examine...
Lesson Plan
Curated OER

Spreadsheet formulas

6th - 8th
Middle schoolers, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to...
Lesson Plan
Curated OER

Weather, Weather, Everywhere!

6th
Sixth graders collect weather data to compare temperatures around the world. Using the Internet, learners collect data, put it into spreadsheets, and analyze and graph the results. An interesting way to cover the topic of weather.
Lesson Plan
Curated OER

Buying a Car

8th
Eighth graders create spreadsheets to calculate payments. They create a list of items they would like to purchase that require monthly payments. They simulate buying a car and create a spreadsheet to determine the amount of the monthly...
Lesson Plan
Curated OER

Electronic Hydrology Lesson Plan - Revised

8th - 12th
Learners use Excel spreadsheets. They predict time and height of peak flow on river
Lesson Plan
Curated OER

Solving Polynomial Equations

9th - 12th
Students demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Lesson Plan
Curated OER

Super Spreadsheets

6th - 8th
Learners discover information about each of the fifty states in the United States. In groups, they create a spreadsheet organizing the information to show to the class. They discover different ways to display the data and identify the...
Lesson Plan
Curated OER

Exploring Careers

7th
Seventh graders investigate their career aptitudes and interests through a scavenger hunt. They display their choices in Excel spreadsheets.

Other popular searches