CPSC 203: Winter 2014

Index

• Lecture information

• Tutorial & Lab information

• Course topics and notes for the lecture

• Assignments and exams

Lecture Information (L03: Lecture Three)

Tutorial and lab Information (commence the week of January 12)

Tutorials:

• 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 quizzes, and if possible some question and answer time.
• Schedule of activities for the tutorials (note that the material on Alice programming will not be required for the winter 2014 term): [Lab manual: outlines material to be covered] [Schedule]

Tutorial	Date/Time	Location	Instructor	Email
T16	TR 10:00 - 10:50	MS 237	Fatemeh Rajabiyazdi	f.rajabiyazdi@ucalgary.ca
T17	MW 13:00 - 13:50	MS 237	Hao Men	men.hao@ucalgary.ca
T18	MW 14:00 - 14:50	MS 237	Hao Men	men.hao@ucalgary.ca
T19	Not scheduled this semester
T20	MW 10:00 - 10:50	MS 236	Fatemeh Rajabiyazdi	f.rajabiyazdi@ucalgary.ca

"TBA component"/Lab component (Continuous tutorials):

• 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. They are located in the 203 tutorial rooms (MS 236 & 237).
• Continuous tutorials commence the week of January17: [MS 236 schedule] [MS 237 schedule]

 

Course topics and notes for lectures

Week	Date ranges	Monday lecture	Wednesday lecture
1	January 5 - 11	No lectures	Introduction to the course [Lecture slides: Course introduction] [Acrobat files: Course introduction]
2	January 12 - 18	Text book Chapter 1 (Part 1-1, 1-2): [Lecture slides: Problems & spreadsheets, Visualizing data] [Acrobat files: Problems & spreadsheets, Visualizing data] [Spreadsheet example: Starting Excel sheet, solution]	Text book Chapter 1 (Part 1-3): [Lecture slides: Spreadsheet design & abstraction] [Acrobat files: Spreadsheet design & abstraction]
3	January 19 - 25	Text book Chapter 1 (Part 1-4): [Lecture slides: Computers] [Acrobat files: Computers]	Text book Chapter 1, Section 2.3 & Section 2.4: [Lecture slides: Elementary set theory] [Acrobat files:  Elementary set theory] Extra example (multiplication): [Problem] [Solution]
4	January 26 - February 1	Text book Section 2.3 & Section 2.4: [Lecture slides: Set relations and algorithms] [Acrobat files: Set relations and algorithms] Extra example (review of logarithms): [Acrobat file]	Text book Section 3.1 & Section 3.2 (Graphs, Algorithms): [Lecture slides: Graphs & algorithms] [Acrobat files: Graphs & algorithms]
5	February 2 - 8	Text book Section 3.1 & Section 3.2 (Euler tours): [Lecture slides: Euler tours] [Acrobat files: Euler tours]	Text book Section 3.3 & Section 3.4 (Graph coloring): [Lecture slides: Graph coloring and trees] [Acrobat files: Graph coloring and trees]
6	February 9 - 15	Text book Section 3.3 & Section 3.4 (Trees and coding): [Lecture slides: Trees and encoding information] [Acrobat files: Trees and encoding information]	Text book Section 3.3 & Section 3.4 (Graphs and trees - finite state machines): [Lecture slides: Finite state machines] [Acrobat files: Finite state machines]
7	February 16 - 22	Reading week: no tutorials or lectures
8	February 23 - March 1	Section 2.1: Propositional logic [Lecture slides: Propositional logic] [Acrobat files: Propositional logic]	Chapter 2: implication, predicate logic [Lecture slides: Predicate logic] [Acrobat files: Predicate logic] JT's extra material: [Excel file: proof of implication equivalency] [Truth table: proof of contrapositive equivalency]
9	March 2 - 8	Midterm review	No lecture (in lieu of midterm of exam):
10	March 9 - 15	Section 4.1 - 4.3: Databases, data modeling [Lecture slides: Databases and modeling] [Acrobat files: Databases and modeling]	Section 4.4 - 4.5: Database schema [Lecture slides: Databases and modeling] [Acrobat files: Databases and modeling]
11	March 16 - 22	Section 4.6 - 4.7: Simple database queries [Lecture slides: Queries, Simple] [Acrobat files: Queries, Simple]	Section 4.6 - 4.7: Advanced database queries [Lecture slides: Queries, Advanced] [Acrobat files: Queries, Advanced]
12	March 23 - 29	Database practice/review lecture [Extra database exercise]	Section 6.1: Networking [Lecture slides: Networking] [Acrobat files: Networking]
13	March 30 - April 5	Section 6.2: security [Lecture slides: Security] [Acrobat files: Security] Extra resources: some serious, some just for fun	Section 6.2: security [Lecture slides: Security] [Acrobat files: Security] Extra resources: some serious, some just for fun
14	April 6 - 12	Section 6.2: security [Lecture slides: Security] [Acrobat files: Security]	Final exam review
15	April 13 - 19	No class?

Assignments and exams

Take home quiz info (the questions can be answered via TopHat: see the folder called "Take home quizzes" on my 203 TopHat course [link]

• Quiz 1: [Slides] [Acrobat]
• Quiz 2: [Slides] [Acrobat]

Midterm information

• Wednesday March 12 from 7 - 9 PM in ST140
• Review questions (to be covered in class Monday March 3)
• Solutions to the review
• JT's extra example: sum and offset functions together in an Excel file: [Spreadsheet]
• Midterm covers material from the first day of classes up to and including logic

Final exam information

• Review questions (most to be covered in class Wednesday April 9)

Assignments and quizzes

• The due dates can be found on the [course schedule]
• Assignment 2 starting data: [Compressed zip file]