Lesson Plan: Pocket Change

Grade level: Four

 

Outcomes


Curriculum:
Math
Students will:

estimate sums and differences of whole numbers and decimals B13

Technology:
Students will:

understand the structure of a simple spreadsheet D4
• understand the terms: spreadsheet file, cell, cell address, row and column D4.1

enter information into a preexisting spreadsheet D5
• enter text and numbers into a preexisting spreadsheet D5.1
• correct data entry errors D5.2
• save changes to a spreadsheet file D5.3

create a spreadsheet as one strategy for collecting and organizing information D6
• recognize that spreadsheets can perform simple calculations D6.1
• enter simple formulas (such as sum, difference, and average) D6.2

 

Created by: Acknowledgments

Last Updated: June 25, 2003

Activity

 

One of the important features of the AppleWorks Spreadsheet utility is that it allows individuals to perform numerous calculations, organize, and display data in tabular and/or graphical form. In this activity, students will learn how to create a spreadsheet and perform calculations. Once the student has created the spreadsheet, he/she will be given a math problem to solve using their spreadsheet. In this activity, students are told the total number of coins and the amount of money those coins equal. The task is to find combinations of coins which equal the given amount. Using a spreadsheet simplifies this task.

 

Resources

The Drawing application in AppleWorks.

Pocket Change problems

Instructions

Suggestions for other activities

Necessary File

pocket.cwk