Abdelghani Guerbas
Welcome to CPSC203 Tutorial - Winter 2010
Contents
Tutorial Information
TA email: aguerbas@ucalgary.ca
Tutorial#: 23
Lec#: 05
Instructor: Namrata Khemka
Lab Time: MW 15-15:50
Room: MS236
SpreadSheets - Excel 2007
Week01
Tut01: Introduction to Spreadsheets and Basic Calculations
Tut02: Complex Calculations - if..then Statments & Pivot Tables
Week02
Tut01: Charts and Visual Design Rules
Tut02: Spreadsheet Design Rules
Week03
Tut01: Analysis and Forecasting
Tut02: Review
Databases - Access 2007
Week01
Tut01: Introduction to databases
Tut02: Simple_Queries
Week02
Tut01: Multi-Table Queries & Aggregate Queries
Tut02: Crosstab Queries and Custom Calculations
Week03
Tut01: Union & Append Queries
Tut02: Review
Programming with Alice
Note: Alice Lab Manual can be found on blackboard under course documents
Tut01:
media:Lab1Exercise02Answer-SCREENSHOT.jpg
media:Lab1Exercise03Answer-SCREENSHOT.jpg
Tut02:
media:Lab2Exercise04Answer-SCREENSHOT.jpg
Tut03:
media:Lab3-Rep-Answer-SCREENSHOT.jpg
Tut04:
Tut05:
Exercise06: Adding two parameters to the pharoah's method takeSteps
media:Lab5-pharaoh.takeSteps.jpg
Tut06:
