| 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 (EDC 179) |
|
Contact Information |
James Tam |
|
|
Office: ICT707 |
|
|
Office hours: T: 14:00 - 14:50 (if I'm a bit late I could be just finishing off answering questions in the previous lecture), W & R (15:00 - 15:30) |
|
|
Email: tam@ucalgary.ca |
| General information | Official course information sheet (summary of official course requirements) |
| In class review
questions TopHat Monacle: [JT's how-to guide] [Full help
document] Estimating your term grade: [Grade calculator spreadsheet] |
Teaching tutorials commence Jan 11 (Wed, T05 - T06) or Jan 12 (Thur, T01 - T04, T07):
- 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 TR 11:00 - 11:50 MS 237 Serhan Polat serhan.polat@ucalgary.ca T02 TR 14:00 - 14:50 MS 237 Arkady Eidelberg ninuson123@gmail.com T03 TR 15:00 - 15:50 MS 237 Omar Addam omaddam@gmail.com T04 TR 16:00 - 16:50 MS 237 Omar Addam omaddam@gmail.com T05 MW 10:00 - 10:50 MS 237 Coskun Sahin coskun.sahin1@ucalgary.ca T06 MW 12:00 - 12:50 MS 237 Coskun Sahin coskun.sahin1@ucalgary.ca T07 TR 10:00 - 10:50 MS 237 Serhan Polat serhan.polat@ucalgary.ca Help tutorials (Continuous tutorials or CT for short): CT commence the week of Jan 15 - 21
- 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. Or you can just work on assignments on your own.
- 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 2017 CT]
Week
Topic coverage
Course textbook chapters ("Computer Science Chop Suey!")
Link to other online textbook resources (U of C safari library website)
Course component occurring during the week Jan 8 - 14 Course introduction and administrative information
[Notes: PDF] [Notes: PowerPoint]Computer fundamentals
[Notes: PDF] [Notes: PowerPoint]
Chapter 1
Jan 15 - 21 Computer fundamentals (continued)
Logic
[Notes: PDF] [Notes: PowerPoint]Spreadsheets: analyzing and visualizing information
[Notes: PDF] [Notes: PowerPoint] [Example spreadsheets]Assignment Zero (D2L) practice exercise / not graded) assignment submissions close in D2L on Thursday Jan 19 at 5 PM
Partial assignment 1 (Advanced MS-Word) due Friday January 20 at 5 PM
Jan 22 - 28
Spreadsheets: analyzing and visualizing information (continued) Jan 29 - Feb 4
Spreadsheets: analyzing and visualizing information (continued)
Chapter 2 Feb 5 - 11
Spreadsheets: analyzing and visualizing information (continued) Databases: storing and retrieving information
[Notes: PDF] [Notes: PowerPoint] [Example database] [Extra database - input mask and queries]Extra resource: Overview of MS-Access (created by Microsoft)
Chapter 3 Feb 12 - 18 Databases: storing and retrieving information (continued) A brief in-class midterm review
Chapter 4 Assignment 2 (spreadsheet) due Tuesday February 14 at 5 PM Midterm examination: Out of class exam on Thursday Feb. 16 from 6:00 until 7:15 pm ST 140 [Exam information link]
Feb 19 - 25 Reading Week: no lecture, tutorials or continuous tutorials Feb 26 - Mar 4
Databases: storing and retrieving information (continued) Mar 5 - 11
Databases: storing and retrieving information (continued) VBA programming in MS-Word
Part I [Notes: PDF] [Notes: PowerPoint] [Example programs]
Part II [Notes: PDF] [Notes: PowerPoint] [Example programs]
Mar 12 - 18 VBA programming in MS-Word (continued) Assignment 3 (database) due Tuesday Mar 14 at 5 PM Mar 19 - 25 VBA programming in MS-Word (continued) Mar 26 - April 1 VBA programming in MS-Word (continued)
April 2 - 8 VBA programming in MS-Word (continued) Building web pages
[Notes: PDF] [Notes: PowerPoint] [Example web pages]Chapter 5, you can also refer to the other text for this section (Mastering VBA for Microsoft Office 2013) Assignment 4 (VBA Word programming) due Friday April 7 at 5 PM April 9 - 15 The Internet
[Notes: PDF] [Notes: PowerPoint]Computer security & privacy (if there is time)
[Notes: PDF] [Notes: PowerPoint]Partial Assignment 5 (html web) due Wednesday April 12 at 5 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 information about the final exam]