Courses/Computer Science/CPSC 203/CPSC 203 Template/Winter 2010 Teaching Assistants/w10 Shahedul Huq Khandkar

General Information
Tutorial: 1 Lecture: L01 Instructor: Angela Duta Lab: Tuesday & Thursday 11:00 - 11:50 (MS 237) CT: Thursday 18:00 - 19:00 (MS 237), Friday 2:00 - 3:00 (MS 237) Blog: http://cpsc203.blogspot.com/ Office: ICT 524 Tel: (403) 401 8927 Email: shkhandk@ucalgary.ca, shahedk@gmail.com

Important Pages
TA Examples on Spreadsheets

Microsoft Excel
19 Jan 2010, Week 1, Lab 1 - Introduction to Spreadsheets and Basic Calculations [[Media:CPSC203Lab1.pdf|Slides]]

21 Jan 2010, Week 1, Lab 2 - Complex Calculations, If-Then Statements, and Pivot Tables [[Media:CPSC203Lab2.pdf|Slides]] [[Media:CPSC203Lab2.xls|Example]]

26 Jan 2010, Week 2, Lab 1 - Charts and Visual Design Rules [[Media:CPSC203Lab3.pdf|Slides]]

28 Jan 2010, Week 2, Lab 2 - Spreadsheet Design Rules [[Media:CPSC203W2L2.pdf|Slides]] [[Media:CPSC203W2L2Ex.xls|Exercise]] Answer

2 Feb 2010, Week 3, Lab 1 - Sorting, Filter, Analysis and Forcasting [[Media:CPSC203W3L1Exv2.xls|Exercise]]

4 Feb 2010, Week 3, Lab 2 - Spreadsheet Review Exercise

Microsoft Access
23 Feb 2010, Week 4, Lab 1 - Intro to Databases [[Media:CPSC203DB1.pdf|Slides]]

25 Feb 2010, Week 4, Lab 2 - Fields, Keys, Simple Queries [MyDatabase.zip]

2 Mar 2010, Week 5, Lab 1 - Multi-table queries, Aggregate Qureies [[Media:CPSC203W5L1DBv2.mdb|Exercise]] [[Media:CPSC203W5L1DBv2_ans.mdb|Answer]]

4 Mar 2010, Week 5, Lab 2 - Crosstab queries and Custom Calculations

9 Mar 2010, Week 6, Lab 1 - Query Analysis Examples (Union Append queries) WebsiteRankings.xls Slides

11 Mar 2010, Week 6, Lab 2 - Databases review DatabaseReview.mdb DatabaseW6L1.zip

Alice
* Alice support material and exercises * Lab Manual * Answers * lab2answer.a2w * lab3answer.a2w * lab3If1answer.a2w * lab3Repanswer.a2w * lab4egyptanswers.a2w * lab6answers.a2w * lab6listsanswers.a2w * horse01.wav

Project Groups
1. Scott Au & Tansie Kuang 2. Goran Jeftic & Jason Kenneth Murchie 3. Bonnie MacArthur & Rachel Herauf 4. Dixie Serrano & Leanne Frederick 5. Steve Lumbala & Andy Yiu 6. Ruth Ma & Yu Wang 7. David Bell & Kate-Lynn 8. Ji Lee & Davis de Souza 9. Andrew Brier & Kyle Bly -- 10. Chanmi Kim & Devin Ness 11. Hans Mitsch, Tylan Stephens & Timothy Licudine