CPSC 203: Winter 2015

This course has been significantly changed from the versions run in previous semesters (including fall 2014). While thinking and problem solving skills are emphasized the goal is to make topics practical. For example, you won't just learn programming for the sake of writing a program (in reference to the old "Alice" and "Jython" sections of the course). but instead at  least  some of the concepts can be used in 'real life'. Consequently two  new assignments have been added: programming in Visual Basic for Applications  (MS-Word) and web page development (Java script programming). The MS-Excel and  MS-Access assignments have been reduced in scope to accommodate the new material. Also the quiz component has been dropped.

Index

• Lecture and important assignment information

• Tutorial & Lab information

• Course topics and notes for the lecture

• Assignment and examination information

Lecture and important assignment information

Tutorial and lab Information

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

• 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] (Examples that I provide the TA's can be found on this link)

Lecture #1 Tutorials	Date/Time	Location	Instructor	Email
T01	TR 11:00 AM - 11:50 AM	MS 237	Konstantinos Xylogiannopoulos	kostasfx@yahoo.gr
T02	TR 2:00 PM - 2:50 PM	MS 236	Ibrahim Karakira	ibrahim.karakira@ucalgary.ca
T03	Cancelled
T04	TR 4:00 PM - 4:50 PM	MS 237	Omar Addam	omaddam@gmail.com
T05	MW 10:00 AM - 10:50 AM	MS 237	Mohamad Darianian	mohamad.darianian@ucalgary.ca
T06	MW 12:00 PM - 12:50 PM	MS 237	Sukhpreet Dhaliwal	skdhali@ucalgary.ca
T07	Cancelled
Lecture #2 Tutorials	Date/Time	Location	Instructor	Email
T08	TR 3:00 PM - 3:50 PM	MS 237	Ibrahim Karakira	ibrahim.karakira@ucalgary.ca
T09	MW 2:00 PM - 2:50 PM	MS 237	Konstantinos Xylogiannopoulos	kostasfx@yahoo.gr
T10	MW 1:00 PM - 1:50 PM	MS 236	Omar Addam	omaddam@gmail.com
T11	MW 11:00 AM - 11:50 AM	MS 236	Sukhpreet Dhaliwal	skdhali@ucalgary.ca
T12	MW 9:00AM - 9:50 AM	MS 236	Mohamad Darianian	mohamad.darianian@ucalgary.ca
T13	Cancelled
T14	MW 4:00PM - 4:50PM	MS 237	Arash Niknafs	aniknafs@ucalgary.ca

Lab (Continuous tutorials or CT for short): CT will start the third week of the semester (Jan 25 - 31)

• 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.
• Continuous tutorial schedule: [MS 236 CT times]  [MS 237 CT times]

Course topics and notes for lectures

Week	Lecture topic and notes
1	Administrative information and course introduction [PDF notes] [PowerPoint]
2	Computer fundamentals [PDF notes] [PowerPoint]
3	Logic [PDF notes] [PowerPoint]
4	Spreadsheets: analyzing and visualizing information [PDF notes] [PowerPoint] [Example spreadsheets]
5	Databases: storing and retrieving information [PDF notes] [PowerPoint] [Example database]
6	VBA macro programming Part I: Introduction [PDF notes] [PowerPoint] [Example programs] Part II: Intermediate concepts [PDF notes] [PowerPoint] [Example programs]
7	The Internet [PDF notes] [PowerPoint]
8	Computer security [PDF notes] [PowerPoint]
9	Web design HTML Tags: [PDF notes] [PowerPoint] [Example webpages]
10	Java script web programming [PDF notes] [PowerPoint] [Example programs]

Assignments and exams