Create a budget for a new computer system in Microsoft Excel, Open Office Calc, or Google Sheets.
The top row should have column headings with columns for item, price. and URL where you can buy it for that price. Include a column to classify each item as software or hardware. If you will be using free software, include the same information with a price of 0.00
All money should be formatted to show 2 decimal places. Include a grand total as well as a total for software and hardware.
All fields that can be calculated should use equations.
Include a pie graph to show the breakdown of costs.
Name and title are not given. 0 points
Name and or title is missing. 0 points
Includes a text box or heading giving your name and title of project. 1 point
Several items are missing from budget. 0 points
List of necessary hardware and software is mostly complete. 2 point
List of necessary hardware and software is complete. 3 points
There are no equations or they are incorrect. 0 points
Uses some equations.. 1 point
Format, layout, and formulas show knowledge of the spreadsheet software. 2 points
There is no graph or the labels are missing. 0 points
Includes a graph with some sections labeled 1 point
Includes a graph with all sections labeled 2 points
Your spreadsheet is fairly simple and incomplete. 0 points
Your spreadsheet has most of the items required. 1 point
Your spreadsheet is of sufficient length and complexity to show real effort. 2 points
Active Learning Index
Active Learning: Software