Courses/Computer Science/CPSC 203/CPSC 203 Template/Winter 2010 Teaching Assistants/W10 Mehrdad Nurolahzade

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

Spreadsheets
19 Jan 2010, Week 1, Lab 1 - Introduction to Spreadsheets and Basic Calculations [[Media:CPSC203-T8-SS-W1-L1.pdf|Slides]] 21 Jan 2010, Week 1, Lab 2 - Complex Calculations, If-Then Statements, and Pivot Tables [[Media:CPSC203-T8-SS-W1-L2.pdf|Slides]] Examples 26 Jan 2010, Week 2, Lab 1 - Charts and Visual Design Rules [[Media:CPSC203-T8-SS-W2-L1.pdf|Slides]] 28 Jan 2010, Week 2, Lab 2 - Spreadsheet Design Rules [[Media:CPSC203-T8-SS-W2-L2.pdf|Slides]] 02 Feb 2010, Week 3, Lab 1 - Analysis, Forecasting, Sorting, and Filtering [[Media:CPSC203-T8-SS-W3-L1.pdf|Slides]] Examples 04 Feb 2010, Week 3, Lab 2 - Spreadsheets Review [[Media:CPSC203-T8-SS-W3-L2.pdf|Slides]] [[Media:Spreadsheets_module_review_answers.xls|Solutions]] 09 Feb 2010, Week 4, Lab 1 - Lab Quiz on Spreadsheets [[Media:CPSC203-T8-SS-W4-L1.pdf|Slides]] 11 Feb 2010, Week 4, Lab 2 - No Lab

Databases
23 Feb 2010, Week 1, Lab 1 - Introduction to Databases [[Media:CPSC203-T8-DB-W1-L1.pdf|Slides]] 25 Feb 2010, Week 1, Lab 2 - Fields, Keys, and Simple Queries [[Media:CPSC203-T8-DB-W1-L2.pdf|Slides]] 02 Mar 2010, Week 2, Lab 1 - Multi-table Queries, Aggregate Qureies [[Media:CPSC203-T8-DB-W2-L1.pdf|Slides]] Examples 04 Mar 2010, Week 2, Lab 2 - Crosstab Queries and Custom Calculations [[Media:CPSC203-T8-DB-W2-L2.pdf|Slides]] 09 Mar 2010, Week 3, Lab 1 - Query Analysis Examples [[Media:CPSC203-T8-DB-W3-L1.pdf|Slides]] Spreadsheet Database 11 Mar 2010, Week 3, Lab 2 - Databases Review [[Media:CPSC203-T8-DB-W3-L2.pdf|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 [[Media:CPSC203-T8-PS-W1-L2.pdf|Slides]] Examples Exercise 23 Mar 2010, Week 2, Lab 1 - Lab 2: Sequential & parallel programming, Pages 13-23 of Introduction to programming using Alice [[Media:CPSC203-T8-PS-W2-L1.pdf|Slides]] Exercise Solution 25 Mar 2010, Week 2, Lab 2 - Lab 3: If statements & loops, Pages 24-40 of Introduction to programming using Alice [[Media:CPSC203-T8-PS-W2-L2.pdf|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 [[Media:CPSC203-T8-PS-W3-L1.pdf|Slides]] Exercise Solution' 01 Apr 2010, Week 3, Lab 2 - Lab 5: Object oriented programming, Pages 50-57 of Introduction to programming using Alice [[Media:CPSC203-T8-PS-W3-L2.pdf|Slides]] Exercise Solution' 06 Apr 2010, Week 4, Lab 1 - Lab 6: Sounds & Lists, Pages 58-66 of Introduction to programming using Alice [[Media:CPSC203-T8-PS-W4-L1.pdf|Slides]] Exercise I Exercise II Solution I Solution II 08 Apr 2010, Week 4, Lab 2 - Groups work on project [[Media:CPSC203-T8-PS-W4-L2.pdf|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