Courses/Computer Science/CPSC 203/CPSC 203 Template/Winter 2010 Teaching Assistants/w10 Shahedul Huq Khandkar
Contents
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
Lab Manuals
Microsoft Excel
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
26 Jan 2010, Week 2, Lab 1 - Charts and Visual Design Rules Slides
28 Jan 2010, Week 2, Lab 2 - Spreadsheet Design Rules Slides Exercise Answer
2 Feb 2010, Week 3, Lab 1 - Sorting, Filter, Analysis and Forcasting Exercise
4 Feb 2010, Week 3, Lab 2 - Spreadsheet Review Exercise
Microsoft Access
23 Feb 2010, Week 4, Lab 1 - Intro to Databases 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 Exercise 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