Courses/Computer Science/CPSC 203/CPSC 203 Template/Fall 2009 Teaching Assistants/F09 Thomas Burt/Assignment 1
From wiki.ucalgary.ca
< Courses | Computer Science | CPSC 203 | CPSC 203 Template | Fall 2009 Teaching Assistants | F09 Thomas Burt
Contents
Must be submitted to Blackboard by 11:59PM on Tuesday, October 13th
Must be completed in Excel 2007 format. Make sure you can open this file on one of the computers in the undergraduate labs before you submit it.
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
