You are to modify several tables to make them more useful for a notional client. 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 workbook will include:
The North Carolina State Library annually produces the Statistical Report of North Carolina Public Libraries. For this task, we will use a subset of the tables used for the 2004-2005 report. If you want to see (only for comparison as the originals are not to be used for this task) the original tables, they are available on line at NC Public Library Statistics 2004/2005.
Though there are several different commercial spreadsheet software applications, we need to use Microsoft Excel for this purpose since it is the program in use at the State Library.
Everything in this task is something we will have demonstrated and/or tried in class.
Use this workbook as the raw material for completing your task. Download it, save it to your client, and follow the instructions in the gradesheet to modify it.
When you have completed this task, place it in your password protected directory and place a link pointing to that location on the task 4 page of your website. Send me an email with the URL that I may use to retrieve it, in the same manner as you did for Task 3.
I have posted an example that should provide some visual guidance for the task. You do not have to follow the design of this example, but you do have to follow the guidance in the specs sheet.