Courses/Computer Science/CPSC 203/CPSC 203 Template/Winter 2010 Teaching Assistants/W10 Md. Tauhiduzzaman

General Information
Lecture: L01 Tutorial: T05 Instructor: Angela Duta Tutorial Times: Monday & Wednesday 10:00 - 10:50 (MS 237) CT Hours: Tuesday 15:00 - 16:00 (MS 237) and Friday 12:00 - 13:00 (MS 236) Office: ICT 719 Tel: (403) 397 5837 Email: mtauhidu@ucalgary.ca

Important Pages
TA Examples on Spreadsheets

Spreadsheets
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]] Example

25 Jan 2010, Week 2, Lab 1 - Charts and Visual Design Rules

27 Jan 2010, Week 2, Lab 2 - Spreadsheet Design Rules

1 Feb 2010, Week 3, Lab 1 - Analysis, Forecasting, Sorting, and Filtering

3 Feb 2010, Week 3, Lab 2 - Spreadsheets review

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

Database
23 Feb 2010, Week 4, Lab 1 - Intro to Databases

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

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

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
* Lab Manual * Answers * lab2answer.a2w * lab3answer.a2w * lab3If1answer.a2w * lab3Repanswer.a2w * lab4egyptanswers.a2w * lab6answers.a2w * lab6listsanswers.a2w * horse01.wav
 * Alice support material and exercises

Project Groups
1. Jaquelyn Djuranic, Joanne Kulinski & Todd Ness 2. Afshin Amirtabar & Leah Samel 3. Harrison Kim 4. Nora Aly 5. Jacob Shapka 6. Ivo Andric & Hemansha Jayasekera 7. Robert Giroux 8. Kaheer Fazel 9. Haley Thomson