Class Schedule
21 Aug | intro
23 Aug | clients
28 Aug | servers
30 Aug | networks
04 Sep | basics lab
06 Sep | structural layer
11 Sep | presentational layer
18 Sep | working with layers
20 Sep | behavior layer
25 Sep | images & design
27 Sep | website lab
02 Oct | object layers
04 Oct | tools that read markup
09 Oct | document markup lab
11 Oct | spreadsheets, formulas & functions
16 Oct | data display
18 Oct | Fall Break
23 Oct | database tools
25 Oct | spreadsheets lab
30 Oct | relational databases
01 Nov | tables
06 Nov | relationships
08 Nov | input & output
13 Nov | SQL
15 Nov | complex queries
20 Nov | databases lab
22 Nov | Thanksgiving
27 Nov | presentation design
29 Nov | presentation delivery
04 Dec | presentation lab
13 Dec | 0800-1100 | final in class presentation
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | class blog | syllabus | contact | grades
You will be called upon to demonstrate specific spreadsheet skills on a set of worksheets.
You are to download and modify several existing worksheets to make them a more useful product. To be specific, these worksheets from a variety of publicly available data provided by the US government in spreadsheet form.
The task will require you to construct a workbook that can be used both as an electronic spreadsheet and as a paper product, capable of being easily used by a busy executive. The final workbook will include:
You are to modify 12 worksheets in some fashion to make them more useful both as an electronic and as a paper product. You will be expected to create 4 additional worksheets by copying and modifying one or more of the provided worksheets.
Some worksheets will be modified specifically to make the data in them more visible. This may include converting data already in the worksheet to different kinds of data; may include using one or more of the tools to manipulate the data; or may include using your formatting skills to tidy up some spreadsheet inefficiencies.
Everything in this task is something we will have demonstrated and/or tried in class.
There are several different commercial spreadsheet software applications, and you may use the one of your choice. However, I will have to be able to open the file using either MSOffice or OpenOffice.
You may work alone on this task, or you may work in groups. If you choose to work in a group, follow the same guidance as we did for task 03.
It should meet the standards laid out on the task 04 gradesheet.
Everything on that gradesheet will be analogous to something we will have done in class.
Save the finished product using the standard file name structure for this class.
I have posted an approximate example that should provide some visual guidance for the task.