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

Digestive System

For Teachers 6th - 8th
Students explore the parts of the digestive system. Using interactive spreadsheet software, students observe, name and describe the function of each part of the digestive system. Students may work individually or in pairs.
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

Math and the NFL - Statistical Representations

For Teachers 7th
Seventh graders use the Internet to get current sports information for data analysis. They use their data to find the mean, median, mode and range. Students then place their data on a spreadsheet.
Lesson Plan
Curated OER

There's No Accounting for Good Journals

For Teachers 10th
Tenth graders create journals on their spending habits. In this money-management lesson plan, 10th graders create and keep journals of their personal income and expenditures. Students learn to use Excel to create a spreadsheet for their...
Lesson Plan
Curated OER

Technology vs. Nontechnology

For Teachers 4th
Fourth graders determine the range, mean, median and mode using a computer spreadsheet. An identical set of calculations is done without using a computer. The results of each method are compared. They calculate the mode, median and range...
Lesson Plan
Curated OER

Real-World Linear Equations

For Teachers 8th
Eighth graders practice technology skills through the use of a spreadsheet and a discovery lesson plan focusing upon linear equations. The technology allows for the visual changes to be displayed for different lines of equations.
Lesson Plan
Curated OER

Super Spreadsheets

For Teachers 6th - 8th
Young scholars 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...
Lesson Plan
Curated OER

A Christmas Project

For Teachers 7th
Seventh graders publish a letter and spreadsheet using the computer. They build a three-dimesnsional object with construction paper and develop a Christmas object using coordinates on a graph. Students compose a response in their journals.
Lesson Plan
Curated OER

Thanksgiving Feast

For Teachers 7th - 9th
Use the Tool Factory Workshop to have your class create a list of people to invite to their Thanksgiving Feast.They will take pictures related to the fall season and create invitations using Tool Factory Database. Learners make a grocery...
Lesson Plan
Curated OER

A Birthday Basket for Tia

For Teachers Pre-K
Students practice reading and math skills using technology.  In this main idea lesson, students retell the important events of A Birthday for Tia in sequence using Kid Pix.  Students create a bar graph using The Graph Club...
Lesson Plan
Curated OER

The Expenditure Sheet

For Teachers 9th - 10th
Students differentiate between expenditure and income. In this algebra lesson, students create a spreadsheet labeling the date, item and amount as they track their expenses. They format the cells of the spreadsheet to do all the...
Lesson Plan
Curated OER

Using Computers to Produce Spreadsheets and Bar Graphs

For Teachers 4th - 12th
Students review graphing terminology and how to plot data points, how to input data into a spreadsheet, and how to make a chart using a computer.
Lesson Plan
Curated OER

Finding Percent When Given A Fraction

For Teachers 7th
Seventh graders calculate percentages when given a fraction. They convert a percentage to a fraction. All of this be done by each student's ability to read the graphs made available by the spreadsheet information.
Lesson Plan
Curated OER

Spreadsheets and Database in Social Studies

For Teachers 5th
Fifth graders create/use spreadsheets to solve real-world problems, explore patterns and make predictions, select/explain most appropriate types of graph to display data, and enter data into a prepared spreadsheet to perform calculations.
Lesson Plan
Curated OER

Weather Watchers

For Teachers 1st - 3rd
Students practice using objective and quantitative means to describe and compare the weather. They compile weather conditions and create a spreadsheet to record their findings.
Lesson Plan
Curated OER

Catalog Display for the Novel : The Family Under the Bridge by Natalie Carlson

For Teachers 4th
Fourth graders explain the novel through creative descriptions, learn importance of word choice in descriptive writing, and implement technology skills of searching the Internet, typing, cutting and pasting, graphic designs, and...
Lesson Plan
Curated OER

Dough Lake Topology

For Teachers 9th - 12th
Young scholars practice coordinates and measurements, develop 2D, 3D topological map, construct grid with string on real surface, establish "level" fixed point for measurements, take and record data points of elevation, and enter data on...
Lesson Plan
Curated OER

Wildlife Sampling

For Teachers 7th
Seventh graders discuss water issues and its affect on salmon population. They recreate a sampling river with fish (cheddar) and scoop them to tag them (which means they exchange them for pretzel fish.) They complete a spreadsheet to...
Lesson Plan
Curated OER

PLANNING A DIVERSIFIED INVESTMENT PORTFOLIO

For Teachers 12th
Twelfth graders research stocks and how to read and interpret financial data. They choose 5 companies to invest in and track their performance over 10 weeks. They create a spreadsheet which shows the results.
Lesson Plan
Curated OER

The Ultimate Vacation

For Teachers 9th - 12th
Students use research skills to solve a problem. They research information needed to plan a vacation. Students create a letter, a flyer, an itinerary, an activity list, cost spreadsheet, a reference page, table of contents and a title page.
Lesson Plan
Education World

A Spooky Adlib Story

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

Measuring Ourselves

For Teachers 5th
Fifth graders conduct various measurement activities on themselves and a partner. They measure their height, weight, thumb-to-pinky span, and body temperature, recording the information in the form of an Excel spreadsheet.
Lesson Plan
Curated OER

Ice Melting Investigation

For Teachers 7th - 9th
Young scholars conduct an ice melting investigation in which they observe and measure the melting of two ice spheres. They develop a hypothesis as to which sphere will melt the fastest, collect data every ten minutes, and graph the data...

Other popular searches