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

Lab Manuals

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 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

• 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. 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