3. Time Sheets
This is the first assignment where you'll be required to use a formula (don't worry, they are not as hard as you think and can often be configured using only buttons in the tool bars).
In this assignment you need to create a spreadsheet that could be used to track totals. For example, a time sheet tracking all of my hours spent working in a week or tracking total number of dollars spent in a week. i.e.:
Day | Hours |
Monday | 8 |
Tuesday | 9.5 |
Wednesday | 5 |
Thursday | 6 |
Friday | 11 |
Saturday | 2 |
Sunday | 1 |
Total | 42.5 |
The following are required for full credit in this assignment:
- There must be more than one column and more than one row
- The spreadsheet must be propagated with contact information (even if it's fake)
- It must be evident that the spreadsheet could scale to include many items either by adding more column items or row items (or both)
- File must show experimentation in formatting (font, text style, cell color and cell border).
- File must show mastery of resizing cell sizes (double clicking the line between rows and columns headers, along the top and side of the workspace is the easiest way to accomplish this).
- File must show mastery of basic formulas (specifically SUM), this can be done by adding up an entire column into a total or subtotal.