Courses/Computer Science/CPSC 203/CPSC 203 Template/Fall 2009 Teaching Assistants/F09 Mehrdad Nurolahzade
Contents
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
Lab Manuals
Spreadsheets
14 Sep 2009, Week 1, Lab 1 - Introduction to Spreadsheets and Basic Calculations Slides
16 Sep 2009, Week 1, Lab 2 - Complex Calculations, If-Then Statements, and Pivot Tables Slides
21 Sep 2009, Week 2, Lab 1 - Charts and Visual Design Rules Slides
23 Sep 2009, Week 2, Lab 2 - Spreadsheet Design Rules Slides
28 Sep 2009, Week 3, Lab 1 - Analysis and Forecasting 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 Slides
07 Oct 2009, Week 1, Lab 2 - Fields, Keys, Simple Queries Slides
12 Oct 2009, Week 2, Lab 1 - No lab
14 Oct 2009, Week 2, Lab 2 - Multi-table queries, Aggregate Queries Slides Examples
19 Oct 2009, Week 3, Lab 1 - Crosstab queries and Custom Calculations Slides Examples
21 Oct 2009, Week 3, Lab 2 - Query Analysis Examples 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 Slides
02 Nov 2009, Week 2, Lab 1 - Loops and conditions Slides
04 Nov 2009, Week 2, Lab 2 - Functions Slides
09 Nov 2009, Week 3, Lab 1 - Problem Solving Review 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 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 Slides
30 Nov 2009, Week 3, Lab 1 - Prototyping: A simpler, comprehensive example including ER diagram 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
