Abdelghani Guerbas

Welcome to CPSC203 Tutorial - Winter 2010

Tutorial Information
TA email: aguerbas@ucalgary.ca

Tutorial#: 23 Lec#: 05

Instructor: Namrata Khemka

Lab Time: MW 15-15:50

Room: MS236

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

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

Alice Support Material

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: