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
Contents
Section 1: 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
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.