Course web page: Introduction to problem solving with applications James Tam Return to the course web page

CPSC 203: Fall 2016

Index

 

Lecture, important administrative course information

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)

My schedule

Electronic response system: TopHat Monacle: [JT's how-to guide] [Full help document]

Estimating your term grade: [Grade calculator spreadsheet]

Tutorial & Lab information

Tutorials (commence Sept 14  (Wed, T01 - T04) or Sept 15 (Thur, T05 & T06)):

Lecture #1 Tutorials

Date/Time

Location

Instructor

Email

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

 

Course topics and lecture notes

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 and examination information

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 9 November 8 at 4 PM

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