home & schedule | class blog | syllabus | contact | grades

You will be called upon to demonstrate specific spreadsheet skills on a set of worksheets.

Task ④ ⇒ spreadsheets

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:

15 worksheets, each containing statistical data (numerical and/or textual) about a variety of topics.

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.

You will also create several charts based on the worksheets and add these charts to the workbook.

Everything in this task is something we will have demonstrated and/or tried in class.

Condition

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.

Standard

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.

You do not have to follow the design of this example (it doesn't conform exactly to your current task), but you would do well to follow the guidance in it.