+
Lesson Plan
Curated OER

Ladybugs in the Garden

For Teachers 5th
Fifth graders estimate the size a population (ecosystems) Students make a chart from information collected then create a graph (line or bar) from this information. Students do a instructional activity where they observed, examine, and...
+
Lesson Plan
Curated OER

Charting the Heights

For Teachers 6th - 8th
Students enter data regarding the height of classmates into a spreadsheet. Formulas will also be entered to find the median, mean, and mode of the data.
+
Lesson Plan
Curated OER

Number and Algebra: Again and Again

For Teachers 5th - 9th
Students use a given spreadsheet to investigate an iterative process by changing the variables. They design their own spreadsheet to investigate the iterative process.
+
Lesson Plan
Curated OER

Running a Business

For Teachers 6th - 8th
Students discuss spreadsheets and how they work. They then imagine they are owners of a store, determine twenty items that they would sell, and create spreadsheets to record amounts of each item sold in a two-week period. After entering...
+
Lesson Plan
Curated OER

Spreadsheet Activity

For Teachers 7th - 8th
Students create a spreadsheet to match a given sample. This includes adjusting column width and row height, changing alignment, changing size and style of print, changing number format.
+
Lesson Plan
Curated OER

How is Your Driver Doing?

For Teachers 6th
Sixth graders explore the concept of averaging of numbers and the function of a spreadsheet. Data is collected, analyzed, and displayed in this lesson. The NASCAR race results provides the basis for the collection of data.
+
Lesson Plan
Curated OER

Following the Stock Market With a Palm

For Teachers 10th - 12th
Young scholars research and explore the stock market. They research a three-year history of stocks, develop a group and individual spreadsheets, and follow their stocks and prices for a ten-day period, graphing the results.
+
Lesson Plan
Curated OER

Graphing Favorite Colors

For Teachers 3rd
Third graders collect data and insert it into ClarisWorks to create a spreadsheet/graph of their favorite color. They interpret the data together.
+
Lesson Plan
Curated OER

Numbers, Patterns, and Algebraic Thinking

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

Sorting

For Teachers 4th - 6th
Students examine how sorting is the process of putting things into an orderly sequence based on some key value. For this lesson students create a spreadsheet with 26 rows of data, then sort those rows by different values.
+
Lesson Plan
Curated OER

Buying My First Car

For Teachers 5th - 12th
Students pretend they are about to buy their first new car. They must do all the calculations necessary to estimate the cost of purchasing the car. They see that the math they learn in school really does have real-life applications.