+
Lesson Plan
Curated OER

Excel Turns Data Into Information

For Teachers 3rd - 8th
Students use excel to analyze data. In this technology lesson, 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
Young scholars 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.
+
Lesson Plan
Alabama Learning Exchange

The State Capital of Stem and Leaf

For Teachers 5th - 10th Standards
Students explore the concept of stem and leaf plots.  In this stem and leaf plots lesson, students plot the 50 US states' capitals on a stem and leaf plot according to the first letter of each state.  Students compare their stem and leaf...
+
Lesson Plan
Curated OER

Graphing

For Teachers 5th - 12th
Young scholars gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the...
+
Lesson Plan
Curated OER

Comp Tech: Format Cells Scavenger Hunt

For Teachers 6th - 8th
Learners begin their use of Microsoft Excel. Individually, they practice using the program, formatting cells and changing the appearance of the spreadsheet. To end the instructional activity, they participate in a scavenger hunt...
+
Lesson Plan
Curated OER

Integrated Project

For Teachers 6th - 8th
Young scholars participate in a project that integrates Microsoft Word, Excel and PowerPoint. In groups, they write a proposal for their project and complete the necessary steps to create and design it. To end the lesson, they are...
+
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
Education World

A Spooky Adlib Story

For Teachers 3rd - 5th
Learners navigate a simple spreadsheet and develop their creativity. They answer questions, filling in cells on Excel, using a template after filling in all the fields, a silly spooky story is created from the answers they give. Students...
+
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

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

Mound Math

For Teachers 6th - 8th
Students examine the many different burial mounds in Wisconsin. In groups, they use the internet to discover how long it took to build a specific mound. They must calculate the measurements of the mound to make a scale model.
+
Lesson Plan
Curated OER

Peopling the New World -- An Archaeological Exercise in Excel

For Teachers 6th - 8th
Young scholars examine different types of spears that have been discovered from various civilizations. In groups, they calculate the answers to various word problems and enter their information on a spreadsheet. They use the data in...
+
Lesson Plan
Curated OER

Skyscraper Capers

For Teachers 5th - 8th
Young scholars discuss skyscrapers and listen as the teacher introduces the project. They use the Internet to perform research on one skyscraper. Students use information they gather to create a brochure of their building . They create...
+
Lesson Plan
Curated OER

Careers

For Teachers 8th
Eighth graders research careers on the computer to determine which career they are interested in. They create a spreadsheet using the Excel program and calculate the budget for their desired lifestyle and determine if this income is...
+
Lesson Plan
Curated OER

Pet Count Excel Graphing

For Teachers 3rd - 5th
Students used collected data to distinguish what pets they have or would like to have. They correlate findings with appropriate technology--Excel. At the end of the lesson they tabulate a bar chart and present their findings to the class.
+
Lesson Plan
Curated OER

Using Averages to Create Graphs Through Excel

For Teachers 6th
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
+
Lesson Plan
Curated OER

Food for Thought

For Teachers 3rd
Third graders conduct a survey of their class' favorite foods voting on 3-4 favorites overall. They then go to the computer lab and examine how to produce a horizontal bar graph by graphing the favorite foods of the class.
+
Lesson Plan
Curated OER

Code Crackers

For Teachers 6th - 8th
Young scholars work in teams creating and posing math rules and trying to guess them using a formula controlled worksheet they create with Excel. Student pairs take turns to see who can crack the other's code the fastest.
+
Lesson Plan
Curated OER

Virtual Field Trip

For Teachers 4th - 6th
Learners calculate gasoline cost per mile on a virtual field trip. They calculate the gasoline costs and travel time for each of the 2 routes, and record on a data sheet. They use Excel to create data tables for mileage, gasoline...
+
Lesson Plan
Curated OER

Graphing

For Teachers 5th
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
+
Lesson Plan
Curated OER

You mean college costs that much?

For Teachers 7th
Seventh graders collect, organize, and analyze data as they research colleges on the Internet. They graph their collected data on a line graph and use a spreadsheet on Microsoft Excel in order to organize the data.
+
Lesson Plan
Curated OER

Divisibility Rules

For Teachers 8th
Eighth graders explore Excel and discover rules of divisibility for the numbers 2, 3, 4, 5, 6, 9, and 10; students examine multiples of 2 using pencil/ paper, then create a chart in Excel that will allow them to more easily see patterns...