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