Zebra0

Learn to Program Step-by-Step

Active Learning: Software

Spreadsheets

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.

Checklist

  • Include a text box or heading giving your name and title of project: 1 point
  • List of necessary hardware and software is complete: 3 points
  • Format, layout, and formulas show knowledge of the spreadsheet software: 2 points
  • Includes a graph with all sections labeled: 2 points
  • Your spreadsheet is of sufficient length and complexity to show real effort. 2 points

Grading Rubric

  Novice Competent Proficient
Format

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

Subject

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

Spreadsheet

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

Graph

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

Effort

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

Like us on Facebook:


OER: Open Educational Resource
Creative Commons License Author: Janet E. Joy; Publisher: Zebra0.com
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License
Creative Commons Attribution-NonCommercial 4.0 International License
Last modified: July 09 2017 08:42:01.