Course web page: Introduction to problem solving with applications James Tam | Return to the course web page |
Day/Time |
L01: TR 12:30 - 13:45 (EEEL 161) |
Contact Information |
James Tam |
|
Office: ICT707 |
|
Office hours: T: 14:00 - 14:50, R: 16:45 - 17:15 (if I'm a bit late I could be just finishing off answering questions in the previous lecture) |
|
Email: tam@ucalgary.ca |
General information | Official course information sheet (summary of official course requirements) |
Electronic
response system: TopHat Monacle: [JT's how-to guide] [Full help
document] Estimating your term grade: [Grade calculator spreadsheet] |
Tutorials (commence Sept 14 (Wed, T01 - T04) or Sept 15 (Thur, T05 & T06)):
- Tutorials are a mandatory component of the courses. Time will be spent on the following: TA's teaching new skills, discussion of assignment requirements, completion of graded quizzes, and if possible some question and answer time.
- Schedule of activities for the tutorials: [Teaching teaching schedule]
Lecture #1 Tutorials
Date/Time
Location Instructor
T01 MW 10:00 - 10:50 MS 237 POLAT, SERHAN serhan.polat@ucalgary.ca T02 MW 11:00 - 11:50 MS 237 POLAT, SERHAN serhan.polat@ucalgary.ca T03 MW 12:00 - 12:50 MS 237 ONYEJEKWE, NWANNEKA OKEOGHENE nwanneka.onyejekwe@ucalgary.ca T04 MW 13:00 - 13:50 MS 237 ONYEJEKWE, NWANNEKA OKEOGHENE nwanneka.onyejekwe@ucalgary.ca T05 TR 11:00 - 11:50 MS 237 DOAN, TAM THANH tam.doan2@ucalgary.ca T06 TR 14:00 - 14:50 MS 237 DOAN, TAM THANH tam.doan2@ucalgary.ca Lab (Continuous tutorials or CT for short): CT commence the week of Sept 18 - 24
- In addition to my office hours and your time in lab there will be time set aside for you to ask questions. These sessions will typically be staffed by the tutorial instructors but they are not mandatory for students and are provided so that you can get help while you are in the computer lab.
- The CT for CPSC 203 is held in the 203 computer lab where your tutorials are held (different times of course).
- Continuous tutorial schedule: [CPSC 203 winter 2016 CT]
Topic #
Topic coverage
Course textbook chapters (you can purchase an access key through the university bookstore)
1 Course introduction and administrative information
[Notes: PDF] [Notes: PowerPoint]
2 Computer fundamentals
[Notes: PDF] [Notes: PowerPoint]Chapter 1 3 Logic
[Notes: PDF] [Notes: PowerPoint]4 Spreadsheets: analyzing and visualizing information
[Notes: PDF] [Notes: PowerPoint] [Example spreadsheets]Brief introduction into spreadsheet design
[Notes: PDF] [Notes: PowerPoint]Chapter 2 5 Databases: storing and retrieving information
[Notes: PDF] [Notes: PowerPoint] [Example database]Extra resource: Overview of MS-Access (created by Microsoft)
Chapter 3 6 VBA programming in MS-Word Part I [Notes: PDF] [Notes: PowerPoint] [Example programs]
Part II [Notes: PDF] [Notes: PowerPoint] [Example programs]
6 Building webpages
[Notes: PDF] [Notes: PowerPoint] [Example webpages]Chapter 4 8 The Internet
[Notes: PDF] [Notes: PowerPoint]9 Computer security & privacy
[Notes: PDF] [Notes: PowerPoint]
Assignment Zero (Learning how to submit and check/download files in D2L, practice exercise / not graded) due Thursday Sept 22 at 4 PM
Partial assignment 1 (Advanced MS-Word, proportion of term grade 5%) due Friday Sept 23 at 4 PM
Assignment 2 (MS-Excel, proportion of term grade 10%) due Tuesday Oct 18 at 4 PM
Midterm examination information: Out of class exam on Thursday, October 20 from 6:00 PM - 7:15 PM in ICT102 [Exam information link]
Assignment 3 (MS-Access, proportion of term grade 10%) due Tuesday
November 9November 8 at 4 PMAssignment 4 (VBA programming in MS-Word, proportion of term grade 10%) due Friday December 2 at 4 PM
Partial Assignment 5 (Building a webpage using html tags, proportion of term grade 5%) due Friday December 9 at 4 PM
The final exam will to be scheduled by university admin staff and not your course instructor: [See the exam schedule in PeopleSoft when the Office of the Registrar has scheduled it]. [A link with exam information]