Courses/Computer Science/CPSC 203/CPSC 203 Template/Winter 2010 Teaching Assistants/W10 Shreya Rawal

TA: SHREYA RAWAL

Email: srawal@ucalgary.ca

Instructor: Angela Duta

Welcome to CPSC 203 T-14!

Tutorial Times: MS 237, TuTh 9:00am - 9:50am

CT Hours: Friday 12:00pm - 2:00pm

Section 1: Spreadsheets
TA Examples on Spreadsheets

19 Jan 2010, Week 1, Lab 1 - Introduction to Spreadsheets and Basic Calculations Slides

21 Jan 2010, Week 1, Lab 2 - Custom Calculations, If-Then Statements, Pivot Tables and Lookup Functions Slides

26 Jan 2010, Week 2, Lab 1 - We covered lookup functions in the class and the practice questions posted below Slides

Practice Questions

Data Set

28 Jan 2010 Week 2, Lab 2 - Charts and Visual Design Rules Spreadsheet Design Rules Slides

Dataset for Charts - Click here to Download

Dataset for practice on charts - Click here to Download

2 Feb 2010 Week 3, Lab 1 - Sorting Dataset: Data Set

4 Feb 2010 Week 3, Lab 2 - General Tips and Review Slides

Practice Problem Download dataset

Section 2: Database
23 Feb 2010, Week 1, Lab 1 - Introduction to Databases Slides

25 Feb 2010, Week 1, Lab 2 - Fields, Keys, and Simple Queries Slides

02 Mar 2010, Week 2, Lab 1 - Multi-table Queries, Aggregate Qureies Slides

04 Mar 2010, Week 2, Lab 2 - Crosstab Queries and Custom Calculations Slides

09 Mar 2010, Week 3, Lab 1 - Query Analysis Examples

11 Mar 2010, Week 3, Lab 2 - Databases Review

Assignment 2 grading sheet Click here to download

Section 3: Problem Solving using Alice
Alice support material and exercises

16 Mar 2010, Week 1, Lab 1 - Lab Quiz on Database Marking Guidelines

18 Mar 2010, Week 1, Lab 2 - Lab 1: Introduction to Alice Slides

1 April 2010, Lab 5 Solution for previous class

Groups for Project
Final Teams:

Team 1: Tamiz & Tyler

Team 2: Kavin & Daniel

Team 3: Michael & Chris

Team 4: Patrick, Waleed & Gloria

If you have any problem with the team please inform me sooner than later.

Grading Sheet