Lesson Plan
Curated OER

Money Math: Lessons for Life

For Teachers 11th - Higher Ed
Students develop a budget for a college student using all of the influences that the student would have.  In this budgeting lesson plan, students use real life examples to create a budget spreadsheet.  Students read and study...
Lesson Plan
Curated OER

The Solar Cycle

For Teachers 7th - 12th
Students research the solar cycle. In this Science lesson, students use the internet to investigate the solar cycle. Students produce a spreadsheet and graph from the information collected.
Lesson Plan
Curated OER

Simple Bar Graphs Using Excel

For Teachers 6th - 8th
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Lesson Plan
Curated OER

Sales Spreadsheet

For Teachers 6th - 8th
Young scholars use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
Lesson Plan
Curated OER

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
Lesson Plan
Curated OER

Publisher Brochures

For Teachers 7th - 8th
Students create brochures on subjects they are studying in Publisher. In this nonfiction writing instructional activity, students use Publisher to create a brochure telling all the main ideas of a topic they are studying. Students use...
Lesson Plan
Curated OER

Life Through Time: The Heart of the Phanerozoic

For Teachers 9th - 11th
Students gain a deeper understanding of geological time and the evolution of life on Earth. They use iMovie to tell a complex story of a discrete time period with narration and images.
Lesson Plan
Curated OER

Introduction to Spreadsheets

For Teachers 6th
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

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

Numbers, Patterns, and Algebraic Thinking

For Teachers 5th
Fifth graders use spreadsheets.
Lesson Plan
Curated OER

Using Computer for Statistical Analysis

For Teachers 6th - 12th
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
Lesson Plan
Curated OER

Flavorful Spreadsheets

For Teachers 4th - 8th
Students create a spreadsheet which includes a bar graph. They sort and classify information and use the average function on a spreadsheet. They research Skittles candy and summarize their findings on a spreadsheet.
Lesson Plan
Curated OER

Probability Using M & M's

For Teachers 6th - 8th
Middle schoolers develop an understanding of probability by sorting bags of M & M's by color and recording the results in percents. The data is entered onto a spreasdsheet and graphed.
Lesson Plan
Curated OER

Organizing Writing/Composing a First Draft

For Teachers 7th - 9th
Does your language arts class have a hard time with writing transitions? Use this organizational writing instructional activity to create three effective transition sentences that middle schoolers will use in their research of renewable...
Lesson Plan
Curated OER

Graphically Speaking

For Teachers 4th - 6th
Students discover the links between population and Congressional representation. In this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.
Lesson Plan
Curated OER

Fantasy Basketball

For Teachers 6th - 8th
Learners play Fantasy Basketball in order to practice locating Internet information and using technology tools to display data; students demonstrate an understanding and use of graphing, probability, and statistics.
Lesson Plan
Curated OER

EXCEL It!

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

Income Levels & Social Class: Is It All About Cash?

For Teachers 5th - 8th
Young scholars graph data and interpret that data after reading information about lifestyles and income levels. They calculate percentages, set up spreadsheets and calculate columnar data.
Lesson Plan
Curated OER

A Holiday Card in KidPix

For Teachers K - 3rd
Students create a holiday card using computer software.  In this computer card making lesson, students design an original holiday card using a variety of tools.  Students navigate the software utilizing various tools.
Lesson Plan
Curated OER

Are You Here Today?

For Teachers K
Students recognize their own name in print and the names of their classmates. They use one to one correspondence to determine who has not checked in, completed their field, and if absent indicate that on the form. Students tally the...
Lesson Plan
Curated OER

How Much Sport Is Good For YOu

For Teachers 6th - 9th
Young scholars using spreadsheets, devise a weekly exercise timetable for a fitness fanatic and a realistic one for themselves. Students chart out the number of calories used by doing different sports. Young scholars plan out a healthy...
Lesson Plan
Curated OER

Sportsround

For Teachers 6th - 10th
Pupils devise a plan to help get kids more active by encouraging them to participate in sports. Student, using spreadsheets, devise a weekly exercise timetable for a fitness fanatic and a realistic one of themselves.
Lesson Plan
Curated OER

Best Buy!!

For Teachers 6th - 8th
Students use newspaper ads to determine the best buy on products. They enter the information into a spreadsheet and then use word processing software to complete a written analysis, complete with graphs.
Lesson Plan
Curated OER

Let's Get Linear

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