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

CPSC 203: Fall 2015

 

Index

 

Lecture and important assignment information

Day/Time

L01: TR 12:30 - 13:45 (MFH 160)

 

Contact Information

James Tam

Office: ICT707

Office hours: Monday 11:00 - 11:50 AM, Tuesday 2:00 - 2:50 PM (if I'm a bit late I could be just finishing off answering questions

Email: tamj@cpsc.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 letter grade: [Spreadsheet]

 

Tutorial and lab Information

Tutorials (commence the week of Jan 18 - 24):

Tutorial No.

Date/Time

Location

Instructor

Email

T01 MW 10:00 AM - 10:50 AM MS 237 Parthasarathi Das dastheta@gmail.com
T02 MW 11:00 AM - 11:50 AM MS 237 Tam Thanh Doan tam.doan2@ucalgary.ca
T03 MW 12:00 PM - 12:50 PM MS 237 Nwanneka Okeoghene Onyejekwe nwanneka.onyejekwe@ucalgary.ca
T04 MW 1:00 PM - 1:50 PM MS 237 Raushan Ara Dilruba  rdilruba@ucalgary.ca
T05 TR 11:00 AM - 11:50 AM MS 237 Shaikh Jeeshan Kabeer sjkabeer@gmail.com
T06 TR 2:00 PM - 2:50 PM MS 237 May A. Sayed Mahmoud may.mahmoud2@ucalgary.ca
Admin TA     Konstantinos Xylogiannopoulos kostasfx@yahoo.gr

Lab (Continuous tutorials or CT for short): CT will starting time is TBA

 

Course topics and notes for lectures

Topic

Lecture topic and notes

Extra supplement: you can purchase printed versions of the book for this course via the Student Union: [Bound and copied]

1

Administrative information and course introduction

[PDF notes] [PowerPoint]

 

2

Computer fundamentals

[PDF notes] [PowerPoint]

Chapter 1 (currently available in Bound and Copied)

3

Logic

[PDF notes] [PowerPoint]

 

4

Spreadsheets: analyzing and visualizing information

[PDF notes] [PowerPoint] [Extra examples]

Chapter 2 (currently available in Bound and Copied)

5

Databases: storing and retrieving information

[PDF notes] [PowerPoint] [Example database]

Chapter 3 (done, should be available in Bound and Copied near end of week of Oct 11 - 17)

6

VBA macro programming (there is a recommended text in the bookstore - custom print by Wiley)

Part I: Introduction [PDF notes] [PowerPoint] [Example programs]
Part II: Intermediate concepts [PDF notes] [PowerPoint] [Example programs]

Chapter 4 (done, should be available in Bound and Copied near end of week of Nov 29 - Dec 5)

7

The Internet

[PDF notes] [PowerPoint]

 

8

Web design

HTML Tags: [PDF notes] [PowerPoint] [Example web pages]

Chapter 5: will be provided during the last lecture on Tuesday December 8. If you miss the class the remaining copies will be available outside of ICT707

9

Computer security & privacy

[PDF notes] [PowerPoint] [Resources]

 

 

Assignments and exams

 

Assignment submission requirements

 

Assignments: collaboration vs. cheating (what's allowed and not allowed for this class)

 

Partial assignment 1 (Advanced MS-Word worth 5%) Friday September 25 at 4 PM.

 

Assignment 2 (MS-Excel worth 10%) due Friday October 16 at 4 PM

 

Midterm examination information: Friday October 30 commencing at 4:30 PM in ICT102  [Link with exam information]

 

Assignment 3 (MS-Access worth 10%) due Friday November 13 Tuesday November 17 at 4 PM

 

Assignment 4 (VBA MS-Word programming worth 10%) due Tuesday December 8 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]. [Link with exam information]