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

Please have a look at the wiki page for the lab (and all other labs) as well. All of the information that I am responsible for covering is in these pages. We will be using quite a bit of that content as well.

These can be found Here.

Links
Excel Custom Format Guide - Helps to manage data that's already entered

Microsoft Official Help Pages are online, as a alternative to the in-application help

Skills For Quiz

 * 1) Type in some basic data – used for rest of the quiz
 * 2) Autofill a field(s)
 * 3) Set up appropriate Field formats (Currency, Numbers, Text, etc.)
 * 4) Calculate Basic Statistics (Min, Max, Average, SD, Median)
 * 5) Use Chart Wizard to do a default chart on a data set.
 * 6) Customize a chart according to good chart design principles
 * 7) Do a custom calculation using a formula (possibly in several steps)
 * 8) Use a nested If ... Then statement to define classes.
 * 9) Use a Lookup table to define classes.
 * 10) Summarize data in a Pivot table.
 * 11) Forecasting (examples may be spreadsheet for a budget, manufacturing, or a simple AI model)
 * 12) Some basic text functions (examples are concatenation, count-if, and matches to a particular text value)
 * 13) Spreadsheets design rules