+
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

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

Fruitvale Extension

For Teachers 6th - 8th
Students determine sources and extent of ground water contaminate, apply mathematics to model in real world simulation, and use technology to present results.
+
Lesson Plan
Curated OER

What's Your Favorite? Survey And Graphing Project

For Teachers 6th
Sixth graders create and edit spreadsheet documents using all data types, formulas and functions, and chart information. They collect and organize data that be portrayed in a graph that they create using EXCEL.
+
Lesson Plan
Curated OER

Putting Your Money to Work

For Teachers 9th - 11th
Learners create a collect data on expenses. In this algebra lesson, students create a spreadsheet to solve scientific equations. They incorporate math, science and technology in this lesson.
+
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

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

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

Solving Polynomial Equations

For Teachers 9th - 12th
Young scholars 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

A Cylinder Workshop

For Teachers 7th - 10th
Students work with given formulas to solve for specific variables. The calculation of the volume of a cylinder and the change in volume when there is a constant surface area is analyzed in this lesson.
+
Lesson Plan
Curated OER

What's Your Line?

For Teachers 5th
Fifth graders collect temperature readings over a period of time, enter the information into a spreadsheet and choose the appropriate graph to display the results.
+
Lesson Plan
Curated OER

Simple Sequence

For Teachers 8th - 11th
Students identify the nth term in a sequence. In this algebra lesson, students generate sequences given the formula for each sequence. They find the formula given the sequence.
+
Lesson Plan
National Sailing Hall of Fame

Sail Area Calculations

For Students 7th - 12th Standards
Do bigger sails mean that the sailboat goes faster? Middle and high schoolers compare sailboats, and learn that simply calculating sail area is not enough. A slideshow presentation demonstrates how to calculate the Sail Area to...
+
Lesson Plan
Curated OER

Investing

For Teachers 8th - 10th
Students collect data on investments and draw conclusions. In this algebra lesson, students analyze exponential graphs as they relate to money. They discuss the cause of an account balance being high or low.
+
Lesson Plan
Curated OER

Twelve Days of Christmas

For Teachers 6th - 8th
Students create charts and graphs using a spreadsheet. They chart the number of each gift given day by day from the song, "The Twelve Days of Christmas." They create a bar graph and a circle graph from their data on the spreadsheet.
+
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

Ict Activity 22

For Teachers 6th - 8th
Young scholars 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

The Derivation of (Pi)

For Teachers 7th
Seventh graders groups measure the diameter and circumference of each of the circular objects in the room. They record their results on their student worksheets and access a computer spreadsheet program to compile their results.
+
Lesson Plan
Curated OER

Color Matters

For Teachers 6th - 8th
Students create a spreadsheet to chart favorite colors, then collect data, create appropriate charts, and use percentages to describe quantities.
+
Lesson Plan
Curated OER

Stock Reports

For Teachers 6th - Higher Ed
Students spend $10,000 by picking up to 3 stocks in which to invest. They monitor their progress for three weeks, and chart results in a spreadsheet template.
+
Lesson Plan
Curated OER

Collecting Data on Running Speeds

For Teachers All
Students collect data on running speeds of various individuals in class to determine the average running speed for a distance of 20 meters.
+
Lesson Plan
Curated OER

Understanding Food Labels

For Teachers 3rd - 5th
Students determine the number of calories, serving size, and vitamins and minerals in different food products and use this information to create a formula determining the number of calories per serving size and the daily percentages of...
+
Lesson Plan
Curated OER

Fighting Obesity with Footsteps

For Teachers 1st - 5th
Analyze the influence of culture, media, technology, and other factors in health through the use of pedometers and daily walking/jogging logs with this activity. The key focus is in dealing with obesity and how small steps can help...
+
Lesson Plan
Curated OER

Home, Home in the City

For Teachers 7th - 9th
Students create a spreadsheet that organizes housing information in the Houston area. They write a formula to determine the average price of homes in the Houston area.