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

== General Information ==
'''Tutorial:''' T8<br>
'''Lecture:''' L02<br>
'''Instructor:''' [http://pages.cpsc.ucalgary.ca/~kawash/ Jalal Kawash]<br>
'''Lab:''' Tuesday & Thursday 17:00 - 17:50 (MS 237)<br>
'''CT:''' Tuesday 18:00 - 19:00 (MS 237)<br>
<br>
'''Office:''' ICT 527<br>
'''Tel:''' (403) 210 9559<br>
'''Email:''' mnurolah (a) ucalgary.ca<br>

== 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.<br>
12 Apr 2010: Project flowcharts can be sketched by hand. However, hand drawn flowcharts have to be scanned and submitted through Blackboard.<br>
09 Apr 2010: You can use the free illustration software [http://download.cnet.com/Diagram-Designer/3000-2191_4-10429024.html?tag=mncol Diagram Designer] to generate the flowcharts of your final project. Convert your diagrams to one of the image types like JPEG before submission.<br>
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).<br>
05 Apr 2010: Assignment #2 feedback sheet was sent to everyone through email.<br>
31 Mar 2010: Alice project progress reports 2 and 3 will be submitted through the Blackboard.<br>
31 Mar 2010: I have added some video tutorials and sample student projects to the [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Winter_2010_Lab_Manual/TA_Examples_for_Alice_Programming TA Examples for Alice Programming] page.<br>
27 Mar 2010: Quiz #2 feedback sheet was emailed to you.<br>
23 Mar 2010: Starting from today project pairs are required to sit next to each other in the lab.<br>
16 Mar 2010: Students who have not formed project groups will be randomly paired up on Thursday's lab.<br>
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.<br>
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.<br>
01 Mar 2010: Assignment #1 feedback sheet was emailed to you. You've got three weeks from today to inquire about your assignment grade.<br>
19 Feb 2010: Quiz #1 feedback sheet was emailed to you. You've got three weeks from today to inquire about your quiz grade.<br>
09 Feb 2010: There would be no tutorial this Thursday. The next tutorial would be after the reading week on Tuesday Feb 23.<br>
06 Feb 2010: The solution of the spreadsheets review questions is now available.<br>
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.<br>
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.<br>
20 Jan 2010: Please verify that your campus email is valid. I will use email as the primary means of communication with you.<br>
19 Jan 2010: If you do not have a UCIT account, please visit UCIT Support Center (7th floor Math Sciences) or register [https://www.ucalgary.ca/itutil?process=WebRegister online].

== Important Pages ==
[http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Winter_2010_Lab_Manual/CPSC203_Winter_2010_Lab_and_CT_Hour_Schedule Lab and CT Hour Schedule]<br>
[http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/TA_Examples_for_Spreadsheets TA Examples on Spreadsheets]<br>
[http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/TA_Examples_for_Access TA Examples for Access]<br>
[http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Winter_2010_Lab_Manual/TA_Examples_for_Alice_Programming TA Examples for Alice Programming]<br>
[http://alice.org/index.php?page=downloads/download_alice2.2 Alice Download Page]<br>
[http://download.cnet.com/Diagram-Designer/3000-2191_4-10429024.html?tag=mncol Diagram Designer Download Page]

== Project Groups ==
Aseel Ayoub and Kai Chen<br>
Javer Badruddin and Palvinder Brar<br>
Graham Osborne and Wharran Blahey<br>
Esther Yu and Vivian On<br>
Brandon Le and Dylan Webster<br>
Chris Nastase and Yunlong Zhang<br>
Zachary Forrest and Sonia Sanghera<br>
Asaad Remtulla and Aimee Hoffman<br>
Teang Tang<br>
Dillon Stecyk<br>

== Lab Manual ==
=== Spreadsheets ===
19 Jan 2010, Week 1, Lab 1 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/Week_1_-_Lab_1:_Introduction_to_Spreadsheets_and_Basic_Calculations_(revision) Introduction to Spreadsheets and Basic Calculations] '''[[Media:CPSC203-T8-SS-W1-L1.pdf|Slides]]'''<br>
21 Jan 2010, Week 1, Lab 2 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/Week_1_-_Lab_2:_Complex_Calculations,_If-Then_Statements,_and_Pivot_Tables Complex Calculations, If-Then Statements, and Pivot Tables] '''[[Media:CPSC203-T8-SS-W1-L2.pdf|Slides]]''' '''[http://sites.google.com/site/mehrdad1976/home/cpsc-203-winter-2010/CPSC203-T8-SS-W1-L2.xlsx?attredirects=0&d=1 Examples]'''<br>
26 Jan 2010, Week 2, Lab 1 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/Week_2_-_Lab_1:_Charts_and_Visual_Design_Rules Charts and Visual Design Rules] '''[[Media:CPSC203-T8-SS-W2-L1.pdf|Slides]]'''<br>
28 Jan 2010, Week 2, Lab 2 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/Week_2_-_Lab_2:_Spreadsheet_Design_Rules Spreadsheet Design Rules] '''[[Media:CPSC203-T8-SS-W2-L2.pdf|Slides]]'''<br>
02 Feb 2010, Week 3, Lab 1 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/Week_3_-_Lab_1:_Analysis_and_Forecasting Analysis, Forecasting, Sorting, and Filtering] '''[[Media:CPSC203-T8-SS-W3-L1.pdf|Slides]]''' '''[http://sites.google.com/site/mehrdad1976/home/cpsc-203-winter-2010/CPSC203-T8-SS-W3-L1.xlsx?attredirects=0&d=1 Examples]'''<br>
04 Feb 2010, Week 3, Lab 2 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Winter_2010_Lab_Manual/CPSC203_Spreadsheets_review Spreadsheets Review] '''[[Media:CPSC203-T8-SS-W3-L2.pdf|Slides]]''' '''[[Media:Spreadsheets_module_review_answers.xls|Solutions]]'''<br>
09 Feb 2010, Week 4, Lab 1 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Winter_2010_Lab_Manual/CPSC203_Lab_Quiz_1_on_Spreadsheets Lab Quiz on Spreadsheets] '''[[Media:CPSC203-T8-SS-W4-L1.pdf|Slides]]'''<br>
11 Feb 2010, Week 4, Lab 2 - No Lab
=== Databases ===
23 Feb 2010, Week 1, Lab 1 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/Week_1_-_Lab_1:_Intro_to_Databases_%28quick%29:_Basic_Parts_of_a_Database Introduction to Databases] '''[[Media:CPSC203-T8-DB-W1-L1.pdf|Slides]]'''<br>
25 Feb 2010, Week 1, Lab 2 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/Week_1_-_Lab_2:_Fields,_Keys,_Simple_Queries_%28single_table%29Intro_to_Assignment_1 Fields, Keys, and Simple Queries] '''[[Media:CPSC203-T8-DB-W1-L2.pdf|Slides]]'''<br>
02 Mar 2010, Week 2, Lab 1 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/Week_2_-_Lab_2:_Multi-table_queries,_Aggregate_Qureies Multi-table Queries, Aggregate Qureies] '''[[Media:CPSC203-T8-DB-W2-L1.pdf|Slides]]''' '''[http://mehrdad1976.googlepages.com/CPSC203-F09-T25-W2-L2.mdb Examples]'''<br>
04 Mar 2010, Week 2, Lab 2 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/Week_3_-_Lab_1:_Crosstab_queries_and_Custom_Calculations Crosstab Queries and Custom Calculations] '''[[Media:CPSC203-T8-DB-W2-L2.pdf|Slides]]'''<br>
09 Mar 2010, Week 3, Lab 1 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/Week_3_-_Lab_2:_Query_Analysis_Examples_(Union_Append_queries)._Review_for_Assignment_3 Query Analysis Examples] '''[[Media:CPSC203-T8-DB-W3-L1.pdf|Slides]]''' '''[http://sites.google.com/site/mehrdad1976/ClassSurveyData.xls?attredirects=0 Spreadsheet]''' '''[http://sites.google.com/site/mehrdad1976/DataAnalysisExample.accdb?attredirects=0 Database]'''<br>
11 Mar 2010, Week 3, Lab 2 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Winter_2010_Lab_Manual/Databases_review Databases Review] '''[[Media:CPSC203-T8-DB-W3-L2.pdf|Slides]]''' '''[http://sites.google.com/site/mehrdad1976/home/cpsc-203-winter-2010/CPSC203-T8-Database-Review.accdb?attredirects=0 Solutions I]''' '''[http://sites.google.com/site/mehrdad1976/home/cpsc-203-winter-2010/W10_AccessReview.mdb?attredirects=0 Solutions II]'''<br>

=== Problem Solving ===
16 Mar 2010, Week 1, Lab 1 - [http://wiki.ucalgary.ca/page/Courses/Computer_Science/CPSC_203/CPSC_203_Template/Labs_Template/Lab_Quiz_on_Databases Lab Quiz on Databases]<br>
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]]''' '''[http://sites.google.com/site/mehrdad1976/home/cpsc-203-winter-2010/CPSC203-T8-PS-W1-L2.zip?attredirects=0&d=1 Examples]''' '''[http://pages.cpsc.ucalgary.ca/~kawash/peeking/tutorials/lab1.a2w Exercise]'''<br>
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]]''' '''[http://pages.cpsc.ucalgary.ca/~kawash/peeking/tutorials/lab2.a2w Exercise]''' '''[http://sites.google.com/site/mehrdad1976/home/cpsc-203-winter-2010/lab2answer.a2w?attredirects=0&d=1 Solution]'''<br>
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]]''' '''[http://pages.cpsc.ucalgary.ca/~kawash/peeking/tutorials/lab3If1.a2w Exercise I]''' '''[http://pages.cpsc.ucalgary.ca/~kawash/peeking/tutorials/lab3Rep.a2w Exercise II]''' '''[http://sites.google.com/site/mehrdad1976/home/cpsc-203-winter-2010/CPSC203-PS-W2-L2.zip?attredirects=0 Solutions]'''<br>
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]]''' '''[http://pages.cpsc.ucalgary.ca/~kawash/peeking/tutorials/lab4egypt.a2w Exercise]''' '''[http://sites.google.com/site/mehrdad1976/home/cpsc-203-winter-2010/lab4egyptanswers.a2w?attredirects=0&d=1 Solution]''''<br>
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]]''' '''[http://pages.cpsc.ucalgary.ca/~kawash/peeking/tutorials/lab4egypt.a2w Exercise]''' '''[http://sites.google.com/site/mehrdad1976/home/cpsc-203-winter-2010/lab4egyptanswers.a2w?attredirects=0&d=1 Solution]''''<br>
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]]''' '''[http://pages.cpsc.ucalgary.ca/~kawash/peeking/tutorials/lab6.a2w Exercise I]''' '''[http://pages.cpsc.ucalgary.ca/~kawash/peeking/tutorials/lab6lists.a2w Exercise II]''' '''[http://sites.google.com/site/mehrdad1976/home/cpsc-203-winter-2010/lab6answers.a2w?attredirects=0 Solution I]''' '''[http://sites.google.com/site/mehrdad1976/home/cpsc-203-winter-2010/lab6listsanswers.a2w?attredirects=0 Solution II]'''<br>
08 Apr 2010, Week 4, Lab 2 - Groups work on project '''[[Media:CPSC203-T8-PS-W4-L2.pdf|Slides]]'''<br>
13 Apr 2010, Week 5, Lab 1 - Groups work on project<br>
15 Apr 2010, Week 5, Lab 2 - Groups work on project<br>
<br>
16 Apr 2010, Lectures end, Project is due 11:59 pm