Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 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

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

Excel

For Teachers 9th - 11th
For this technology worksheet, students are taught how to create documents using Excel. They follow the directions on a handout to help them create documents. They print their final work and submit it.
Lesson Plan
Curated OER

How to Graph in Excel

For Teachers 4th
Fourth graders construct data graphs on the Microsoft Excel program. In this statistics lesson plan, 4th graders formulate questions and collect data. Students represent their results by using Excel.
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

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

For Teachers 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

Calculating Profits from Selling Virtual Lemonade

For Teachers 5th - 7th
Students set up and collect data for a virtual lemonade stand. In this entrepreneurship, economics, and technology lesson plan, students purchase ingredients, determine costs, and set up a virtual lemonade stand. Students consider...
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

For Teachers 3rd - 5th
Students create arrays using Microsoft Excel. In 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

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
Alabama Learning Exchange

Origami Geometry

For Teachers 2nd - 5th Standards
Origami is an excellent way to combine Japanese culture, art, and geometric shapes into one engaging instructional activity! Scholars begin by listening to the story Sadako and the Thousand Paper Cranes and learn the origin of...
Lesson Plan
Curated OER

Data! Data! Graph that Data!

For Teachers 5th
Fifth graders create data graphs using Microsoft Excel. In this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Lesson Plan
Curated OER

Journalism

For Teachers 7th - 10th
Learners insert raw data about Ad sales into an Excel chart. They use raw data in a letter to local businesses by using the Mail Merge program. They represent data using tables and graphs.
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

Interest Calculation and Spreadsheets

For Teachers 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 a Spreadsheet

For Teachers 8th - 10th
Young scholars create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
Lesson Plan
Curated OER

Great Online Art Sites

For Teachers K - 8th
Students complete an online study of art websites. In this art and technology lesson, students explore the links and try the activities to learn about art online.
Lesson Plan
Curated OER

Planet Protectors

For Teachers 6th - 8th
Students explore ways to protect the earth.  In this environmental issues and technology lesson, students investigate the water quality in their community and compare their findings to the water quality in other geographic...
Lesson Plan
Curated OER

Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions

For Teachers 7th - 12th
Students improve data entry in a spreadsheet.
Lesson Plan
Curated OER

Graph Frenzy!!

For Teachers 6th - 7th
Learners brainstorm for a survey question to ask classmates. They survey their classmates. They enter the results into a spreadsheet and create the best graph for the information. They share their graphs with the class.
Lesson Plan
Curated OER

Visit My Class Wikis

For Teachers 4th - 7th
Students visit the links on the blog site to learn about class wikis. In this technology integration lesson, students visit the links to view class wikis.
Lesson Plan
Curated OER

Holiday Cards using Publisher

For Teachers 2nd - 6th
Students create a holiday card using technology. In this technology lesson plan, students use Publisher templates to create a holiday card. Students organize, design, and edit their card.
Lesson Plan
Curated OER

Holiday Flier in Publisher

For Teachers 2nd - 5th
Students use Publisher in this lesson to make a holiday flier. In this technology lesson, students create a holiday flier. Students choose fonts, use clipart, use grammar and spelling check, and save to their work to a flash drive or...
Lesson Plan
Curated OER

Indegenous Cultures Magazine in Publisher

For Teachers 4th
Fourth graders use Publisher to create their own magazine. In this online magazine lesson, 4th graders follow the instructions to create a magazine using text, pictures, and colors within the Publisher system.