Courses/Computer Science/CPSC 203/CPSC 203 Template/Fall 2009 Teaching Assistants/F09 Mehrdad Nurolahzade

General Information
Tutorial: 25 Lecture: L04 Instructor: Jalal Kawash Lab: Monday & Wednesday 9:00 - 9:50 (MS 236) CT: Monday 19:00 - 21:00 (MS 236) Office: ICT 527 Tel: (403) 210 9559 Email: mnurolah (a) ucalgary.ca

Notices
14 Oct 2009: Quiz#1 feedback has been emailed to everyone. If you didn't receive it you can collect a printed copy either from my office or next Monday in the lab. 07 Nov 2009: Assignment#1 feedback has been emailed to everyone. If you did not receive it please contact me. 30 Nov 2009: Quiz #4 teams will be as follows: Group 1: Dana Andrews, Leevon Bennett, Tyler Billington, Keith Blundell, Alyssa Morrison, Gareth Dobson Group 2: Garrett Charlton, Ryan Hadwell, Cyntia Hall, Scott Job Group 3: Megan Kramer, Marina Litwack, Jeremy Luzzi, Michael McEwen, Aaron Morrill Group 4: Colleen Parker, Tanya Puka, Alexis Sine, Omar Tabsh, Calvin Wong 02 Dec 2009: Assignment#2 and Quiz#3 feedback was emailed to everyone. 18 Dec 2009: Assignment#3 and Quiz#4 feedback was emailed to everyone.

Important Pages
Lab and CT Hour Schedule TA Examples on Spreadsheets TA Examples for Access TA Examples for JES

Spreadsheets
14 Sep 2009, Week 1, Lab 1 - Introduction to Spreadsheets and Basic Calculations [[Media:CPSC203%E2%80%93T25-W1-L1.pdf|Slides]] 16 Sep 2009, Week 1, Lab 2 - Complex Calculations, If-Then Statements, and Pivot Tables [[Media:CPSC203–T25-W1-L2.pdf‎|Slides]] 21 Sep 2009, Week 2, Lab 1 - Charts and Visual Design Rules [[Media:CPSC203–T25-W2-L1.pdf‎|Slides]] 23 Sep 2009, Week 2, Lab 2 - Spreadsheet Design Rules [[Media:CPSC203–T25-W2-L2.pdf‎|Slides]] 28 Sep 2009, Week 3, Lab 1 - Analysis and Forecasting [[Media:CPSC203–T25-W3-L1.pdf‎|Slides]] Examples 30 Sep 2009, Week 3, Lab 2 - Lab Quiz on Spreadsheets

Databases
05 Oct 2009, Week 1, Lab 1 - Intro to Databases: Basic Parts of a Database [[Media:CPSC203%E2%80%93T25-DB-W1-L1.pdf|Slides]] 07 Oct 2009, Week 1, Lab 2 - Fields, Keys, Simple Queries [[Media:CPSC203%E2%80%93T25-DB-W1-L2.pdf|Slides]] 12 Oct 2009, Week 2, Lab 1 - No lab 14 Oct 2009, Week 2, Lab 2 - Multi-table queries, Aggregate Queries [[Media:CPSC203%E2%80%93T25-DB-W2-L2.pdf|Slides]] Examples 19 Oct 2009, Week 3, Lab 1 - Crosstab queries and Custom Calculations [[Media:CPSC203%E2%80%93T25-DB-W3-L1.pdf|Slides]] Examples 21 Oct 2009, Week 3, Lab 2 - Query Analysis Examples [[Media:CPSC203%E2%80%93T25-DB-W3-L2.pdf|Slides]] Database Spreadsheet

Problem Solving
26 Oct 2009, Week 1, Lab 1 - Lab Quiz on Databases 28 Oct 2009, Week 1, Lab 2 - Introduction to JES, variables and constants Jython and JES Tips [[Media:CPSC203%E2%80%93T25-PS-W1-L2.pdf|Slides]] 02 Nov 2009, Week 2, Lab 1 - Loops and conditions [[Media:CPSC203%E2%80%93T25-PS-W2-L1.pdf|Slides]] 04 Nov 2009, Week 2, Lab 2 - Functions [[Media:CPSC203%E2%80%93T25-PS-W2-L2.pdf|Slides]] 09 Nov 2009, Week 3, Lab 1 - Problem Solving Review [[Media:CPSC203%E2%80%93T25-PS-W3-L1.pdf|Slides]] 11 Nov 2009, Week 3, Lab 2 - No lab

Design Skills
16 Nov 2009, Week 1, Lab 1 - Quiz 3 on Problem Solving 18 Nov 2009, Week 1, Lab 2 - Defining the problem: Use case diagrams [[Media:CPSC203%E2%80%93T25-DS-W1-L2.pdf|Examples]] 23 Nov 2009, Week 2, Lab 1 - Use cases: Use case descriptions 25 Nov 2009, Week 2, Lab 2 - Planning: Comprehensive example including UI (form and report), excluding ER diagram [[Media:CPSC203%E2%80%93T25-DS-W2-L2.pdf|Slides]] 30 Nov 2009, Week 3, Lab 1 - Prototyping: A simpler, comprehensive example including ER diagram [[Media:CPSC203%E2%80%93T25-DS-W3-L1.pdf|Slides]] 02 Dec 2009, Week 3, Lab 2 - Lab Quiz 4 (Part 1): Go to the Start 07 Dec 2009, Week 4, Lab 1 - Lab Quiz 4 (Part 2): Submission