CPSC 203: Fall 2017

Index

• Lecture, important administrative course information
• Tutorial (teaching and help tutorial) information
• Course schedule, assignment and examination information

Lecture, important administrative course information

Tutorial information

Teaching tutorials (commence week of Sept 24 - 30, TA assignment may still be subject to change):

• 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.
• Tutorial information (schedule, resources etc.): [Teaching teaching schedule]

Lecture #1 Tutorials	Date/Time	Location	Instructor	Email
T01	MW 10:00 - 10:50	MS 252	Parthasarathi Das	parthasarathi.das@ucalgary.ca
T02	MW 11:00 - 11:50	MS 252	Mahmudun Nabi	m.nabi@uleth.ca
T03	MW 12:00 - 12:50	MS 252	Shuai Li	shuai.li1@ucalgary.ca
T04	MW 13:00 - 13:50	MS 252	Shuai Li	shuai.li1@ucalgary.ca
T05	Cancelled
T06	Cancelled
T07	TR 10:00 - 10:50	MS 252	Md Mamunur Rashid	mdmamunur.rashid1@ucalgary.ca
T09	TR 15:00 - 15:50	MS252	Sathaporn Hu	sathaporn.hu@ucalgary.ca

Help tutorials (Continuous tutorials or CT for short): CT commence the week of Oct 8 - 14 (but they are not scheduled to run every week, see the PDF schedule below for the specific weeks that CT will run).

• 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.
• 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 CT] 

Course schedule: assignments, exams, lecture topics and notes

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
Sept 10 - 16	Course introduction and administrative information [Notes: PDF] [Notes: PowerPoint] Computer fundamentals [Notes: PDF] [Notes: PowerPoint]	Chapter 1: Computers
Sept 17 - 23	Computer fundamentals (continued) Logic [Notes: PDF] [Notes: PowerPoint] Spreadsheets: analyzing and visualizing information [Notes: PDF] [Notes: PowerPoint] [Example spreadsheets]	Chapter 2: Spreadsheets
Sept 24 - 30	Spreadsheets: analyzing and visualizing information (continued)		Assignment Zero (D2L) practice exercise / not graded) assignment submissions close in D2L on Sept 29
Oct 1 - 7	Spreadsheets: analyzing and visualizing information (continued)
Oct 8 - 14	Spreadsheets: analyzing and visualizing information (continued) Databases: storing information [Notes: PDF] [Notes: PowerPoint] [Example database] Extra resource: Overview of MS-Access (created by Microsoft)	Chapter 3 : Databases	Assignment 1 (MS-Excel, proportion of term grade 10%) due Friday October 13 at 4 PM
Oct 15 - 21	Databases: storing information (continued)     A brief in-class midterm review		Midterm examination information: Thursday Oct 19 from 4:30 PM until 5:45 pm in ST 148 (Outside of normal lecture time) [Exam information link]
Oct 22 - 28	Databases: queries [Notes: PDF] [Notes: PowerPoint]  [Example database]
Oct 29 - Nov 4	Databases: queries (continued) VBA programming in MS-Word Part I [Notes: PDF] [Notes: PowerPoint] [Example programs]	Chapter 4: VBA Programming. You can also refer to the other text for this section (Mastering VBA for Microsoft Office 2013)
Nov 5 - 11	VBA programming in MS-Word Part I (continued)
Nov 12 - 18	VBA programming in MS-Word Part I (continued)		Assignment 2 (MS-Access, proportion of term grade 10%) due Tuesday November 14 at 4 PM
Nov 19 - 25	VBA programming in MS-Word Part II [Notes: PDF] [Notes: PowerPoint] [Example programs]
Nov 26 - Dec 2	VBA programming in MS-Word (continued) Computer security & privacy [Notes: PDF] [Notes: PowerPoint]	Chapter 5: Building a webpage
Dec 3 - 9	Building web pages (if there is time) [Notes: PDF] [Notes: PowerPoint] [Example web pages] The Internet (if there is time) [Notes: PDF] [Notes: PowerPoint]		Assignment 3 (VBA programming in MS-Word, proportion of term grade 10%) due Friday 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]. [A link with information about the final exam]