INLS261/461 | Tools for Information Literacy

Task - format spreadsheets to take advantage of the underlying tools

You are to download and modify several existing worksheets (which I will provide to you) to make them a more useful product. 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:

• eight worksheets, each containing statistical data (numerical and/or textual) about selected current topics
• you are to modify all worksheets in some fashion to make them more useful both as an electronic and as a paper product
  • 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.

You will be called upon to demonstrate specific spreadsheet skills on one or more of the worksheets. These skills will be laid out as subtasks on the gradesheet.

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

[top]

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 will work in the same teams on this task as you did on the previous task. When your team has completed the task, one member of the team will store it in that person's password protected directory. Each of the members of the team will place a hyperlink to it on their respective web sites (the individual storing it will have a relative link to it, the others will have absolute links to the finished task). When it's ready for me to download and grade, send me a note telling me to retrieve it from your websites.

[top]

Standard

It should meet the standards laid out on the task 04 gradesheet.

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

[top]