|
TASK
|
| Spend exactly $1,000 without going over. Careful planning will be necessary. |
Research:
| Using websites listed in the resources section below, research items you would like to purchase. | |
| You may visit any of the sites listed below. | |
| If you would like to visit other sites, you must check with your teacher first. | |
| You are only browsing to find items you are interested in and are NOT ALLOWED to actually purchase any items. | |
| You will be creating a "Wish List" by recording the item and its price on an Excel Spreadsheets that is titled "Wish List". | |
| Prices should be rounded to the whole dollar (for example: $1.49 would be rounded to $1.00 and $19.99 would be rounded to $20.00). Ignore shipping and handling costs and sales tax. |
Accounting:
| Record on the Excel Spreadsheets exactly how the $1,000 will be spent. | |
| Your purchases must be organized into several major categories. You must have no less than 3 major categories and the purchases in each category must total at least $100. | |
| Possible Category Ideas: Games, Toys, Books, Entertainment, Music, Sports, Recreation, Clothing, Electronics, CDs, Videos/Movies |
Assessment:
| Excel Spreadsheets should be neat and organized. | |
| All information must be completed. | |
| All final information will be organized onto the last spreadsheet workbook. | |
| A labeled graph will be created within the Excel program. |
PROCESSPlease download the "Wish List" spreadsheet from here and save it in your user folder!
| Research and enter information on purchases you would like to make from websites you have visited. | |
| Think about under what "Category" this item would be found. | |
| You must enter the item, the website, and the cost on a "Category" spreadsheets in the "Wish List" workbook. | |
| Remember you must have at least 4 categories and you must spend a minimum of $100 in each category. |
Final Accounting
| Once you have completed all of your research and your "Category" spreadsheets are complete, you will be selecting what items you will be purchasing with the $1000. | |
| Enter your final purchases on the "Final Accounting" spreadsheet in the "Wish List" workbook. | |
| Remember, the total amount must be equal to $1000! |
Graph
| Enter the information on the "Graph" spreadsheet. | |
| Together as a class, we will create a graph that illustrates your spending on the "Graph" spreadsheet in the "Wish List" workbook. |
Other Information
| Include your name and date in the footer section of both the "Final Accounting" sheet and the "Graph" sheet. | |
| Be sure to save as you go in YOUR USER FOLDER. | |
| Print out a copy of both the "Final Accounting" sheet and the "Graph" sheet for grading. |
Listed below are websites you will use to "shop" for items. If you would like to visit another site, please check with your teacher first.
EVALUATION

![]()
|
(Updated 10/02/2007) Copyright by Fern Hill Elementary School in West Chester Area School District, 2001-02 |