Courses/Computer Science/CPSC 203/CPSC 203 Template/Fall 2009 Teaching Assistants/F09 Thomas Burt/Assignment 1

General Notes
You will need to use the following skills for this assignment. If you don't understand how to do any of them, you must visit CT hours to get help, or figure it out on your own. Use the wiki pages for each lab as a reference.

Skills
These are just copied from the Lab Manual Pages.

Lab 1

 * using the AutoFill feature
 * setting-up appropriate field formats, such as currency, numbers, text, etc.
 * calculating basic statistics

Lab 2

 * doing a custom calculation using a formula (possibly in several steps)
 * using a nested If... Then statement to define classes
 * summarizing data in a Pivot table
 * using a Lookup table to define classes

Lab 3

 * using Chart Wizard to create the default chart on a data set
 * customizing a chart according to good chart design principles

Lab 4

 * Spreadsheet / Presentation design rules