Courses/Computer Science/CPSC 203/CPSC 203 Template/Fall 2009 Teaching Assistants/F09 Thomas Burt/Spreadsheets
From wiki.ucalgary.ca
< Courses | Computer Science | CPSC 203 | CPSC 203 Template | Fall 2009 Teaching Assistants | F09 Thomas Burt
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
- Type in some basic data – used for rest of the quiz
- Autofill a field(s)
- Set up appropriate Field formats (Currency, Numbers, Text, etc.)
- Calculate Basic Statistics (Min, Max, Average, SD, Median)
- Use Chart Wizard to do a default chart on a data set.
- Customize a chart according to good chart design principles
- Do a custom calculation using a formula (possibly in several steps)
- Use a nested If ... Then statement to define classes.
- Use a Lookup table to define classes.
- Summarize data in a Pivot table.
- Forecasting (examples may be spreadsheet for a budget, manufacturing, or a simple AI model)
- Some basic text functions (examples are concatenation, count-if, and matches to a particular text value)
- Spreadsheets design rules