Courses/Computer Science/CPSC 203/CPSC 203 Template/Winter 2010 Teaching Assistants/W10 Mehrdad Nurolahzade
Contents
General Information
Tutorial: T8
Lecture: L02
Instructor: Jalal Kawash
Lab: Tuesday & Thursday 17:00 - 17:50 (MS 237)
CT: Tuesday 18:00 - 19:00 (MS 237)
Office: ICT 527
Tel: (403) 210 9559
Email: mnurolah (a) ucalgary.ca
Notices
16 Apr 2010: Don't forget to burn a CD, with your project files. Put it in an envelope and label it with your name, lecture, and tutorial numbers. Drop the envelope in the CPSC 203 assignment submission box next to MS-237. You may also use a flash disk. Put the stick in an envelope and label it the way described. I'll arrange with you so that you can pickup your flash disk from my office later.
12 Apr 2010: Project flowcharts can be sketched by hand. However, hand drawn flowcharts have to be scanned and submitted through Blackboard.
09 Apr 2010: You can use the free illustration software Diagram Designer to generate the flowcharts of your final project. Convert your diagrams to one of the image types like JPEG before submission.
08 Apr 2010: Groups will be working on their Alice projects in the lab starting form today. Project is due the last day of classes (Friday, April 16, 11:59 pm).
05 Apr 2010: Assignment #2 feedback sheet was sent to everyone through email.
31 Mar 2010: Alice project progress reports 2 and 3 will be submitted through the Blackboard.
31 Mar 2010: I have added some video tutorials and sample student projects to the TA Examples for Alice Programming page.
27 Mar 2010: Quiz #2 feedback sheet was emailed to you.
23 Mar 2010: Starting from today project pairs are required to sit next to each other in the lab.
16 Mar 2010: Students who have not formed project groups will be randomly paired up on Thursday's lab.
08 Mar 2010: Course project groups have to be setup by the end of this week. Please let me know who you pair up with by sending me an email or talking to me in the lab.
05 Mar 2010: Next Thursday's lab will be a review on Databases. Please make sure you attend this lab in order to get ready for the Quiz #2.
01 Mar 2010: Assignment #1 feedback sheet was emailed to you. You've got three weeks from today to inquire about your assignment grade.
19 Feb 2010: Quiz #1 feedback sheet was emailed to you. You've got three weeks from today to inquire about your quiz grade.
09 Feb 2010: There would be no tutorial this Thursday. The next tutorial would be after the reading week on Tuesday Feb 23.
06 Feb 2010: The solution of the spreadsheets review questions is now available.
03 Feb 2010: This Thursday's lab will be a review on Spreadsheets. Please make sure you attend this lab in order to get ready for the Quiz #1 next Monday.
01 Feb 2010: Quiz #1 on spreadsheets will be taken in the lab next Tuesday Feb 9, 17:00. Don't forget to bring along a photo ID. You will NOT have access to the Internet during the quiz. However, course notes, books, or anything printed (like Wiki manuals, slides, etc.) are allowed.
20 Jan 2010: Please verify that your campus email is valid. I will use email as the primary means of communication with you.
19 Jan 2010: If you do not have a UCIT account, please visit UCIT Support Center (7th floor Math Sciences) or register online.
Important Pages
Lab and CT Hour Schedule
TA Examples on Spreadsheets
TA Examples for Access
TA Examples for Alice Programming
Alice Download Page
Diagram Designer Download Page
Project Groups
Aseel Ayoub and Kai Chen
Javer Badruddin and Palvinder Brar
Graham Osborne and Wharran Blahey
Esther Yu and Vivian On
Brandon Le and Dylan Webster
Chris Nastase and Yunlong Zhang
Zachary Forrest and Sonia Sanghera
Asaad Remtulla and Aimee Hoffman
Teang Tang
Dillon Stecyk
Lab Manual
Spreadsheets
19 Jan 2010, Week 1, Lab 1 - Introduction to Spreadsheets and Basic Calculations Slides
21 Jan 2010, Week 1, Lab 2 - Complex Calculations, If-Then Statements, and Pivot Tables Slides Examples
26 Jan 2010, Week 2, Lab 1 - Charts and Visual Design Rules Slides
28 Jan 2010, Week 2, Lab 2 - Spreadsheet Design Rules Slides
02 Feb 2010, Week 3, Lab 1 - Analysis, Forecasting, Sorting, and Filtering Slides Examples
04 Feb 2010, Week 3, Lab 2 - Spreadsheets Review Slides Solutions
09 Feb 2010, Week 4, Lab 1 - Lab Quiz on Spreadsheets Slides
11 Feb 2010, Week 4, Lab 2 - No Lab
Databases
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 Examples
04 Mar 2010, Week 2, Lab 2 - Crosstab Queries and Custom Calculations Slides
09 Mar 2010, Week 3, Lab 1 - Query Analysis Examples Slides Spreadsheet Database
11 Mar 2010, Week 3, Lab 2 - Databases Review Slides Solutions I Solutions II
Problem Solving
16 Mar 2010, Week 1, Lab 1 - Lab Quiz on Databases
18 Mar 2010, Week 1, Lab 2 - Lab 1: Introduction, Pages 3-12 of Introduction to programming using Alice Slides Examples Exercise
23 Mar 2010, Week 2, Lab 1 - Lab 2: Sequential & parallel programming, Pages 13-23 of Introduction to programming using Alice Slides Exercise Solution
25 Mar 2010, Week 2, Lab 2 - Lab 3: If statements & loops, Pages 24-40 of Introduction to programming using Alice Slides Exercise I Exercise II Solutions
30 Mar 2010, Week 3, Lab 1 - Lab 4: Object oriented programming, Pages 41-50 of Introduction to programming using Alice Slides Exercise Solution'
01 Apr 2010, Week 3, Lab 2 - Lab 5: Object oriented programming, Pages 50-57 of Introduction to programming using Alice Slides Exercise Solution'
06 Apr 2010, Week 4, Lab 1 - Lab 6: Sounds & Lists, Pages 58-66 of Introduction to programming using Alice Slides Exercise I Exercise II Solution I Solution II
08 Apr 2010, Week 4, Lab 2 - Groups work on project Slides
13 Apr 2010, Week 5, Lab 1 - Groups work on project
15 Apr 2010, Week 5, Lab 2 - Groups work on project
16 Apr 2010, Lectures end, Project is due 11:59 pm
