ST 148
| Course web page: Introduction to problem solving with applications James Tam | Return to the course web page |
|
Day/Time |
L01: TR 12:30 - 13:45 (EDC179) |
|
Contact Information |
James Tam |
|
|
Office: ICT707 |
|
|
Office hours: MT: 14:00 - 14:50 (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) |
| Electronic
response system: TopHat Monacle: [JT's
how-to guide] [Full
help document] Estimating your term grade: [Grade calculator spreadsheet] |
Teaching tutorials (commence week of Jan 21 - 27, 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
T01 TR 11:00 - 11:50 MS 252 Abdelghani Guerbas abdelghani.guerbas@ucalgary.ca T02 TR 14:00 - 14:50 MS 252 Karthik Mahadevan karthik@ualberta.ca T03 TR 15:00 - 15:50 MS 252 Fahim Hasan Khan fahimhasan.khan@ucalgary.ca T04 TR 16:00 - 16:50 MS 252 Arkady Eidelberg aeidelbe@ucalgary.ca T05 MW 10:00 - 10:50 MS 252 Sogand Sadrhaghighi sadr.sogand@gmail.com T06 MW 12:00 - 12:50 MS 252 Sogand Sadrhaghighi sadr.sogand@gmail.com T07 TR 10:00 - 10:50 MS 252 Fahim Hasan Khan fahimhasan.khan@ucalgary.ca T09 MW 13:00 - 13:50 MS252 Karthik Mahadevan karthik@ualberta.ca Help tutorials (Continuous tutorials or CT for short): CT commence the week of Feb 4 - 10, 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]
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 Jan 7 - 13 Course introduction and administrative information
[Notes: PDF] [Notes: PowerPoint]Computer fundamentals
[Notes: PDF] [Notes: PowerPoint]
Chapter 1: Computers
Jan 14 - 20 Computer fundamentals (continued)
Logic
[Notes: PDF] [Notes: PowerPoint]Spreadsheets: analyzing and visualizing information
[Notes: PDF] [Notes: PowerPoint] [Example spreadsheets]Chapter 2: Spreadsheets
Jan 21 - 27 Spreadsheets: analyzing and visualizing information (continued) Assignment Zero (D2L) practice exercise / not graded) assignment submissions close in D2L on Jan 26 Jan 28 - Feb 3 Spreadsheets: analyzing and visualizing information (continued)
Feb 4 - 10 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 February 9 at 5 PM Feb 11 - 17
Databases: storing information (continued) A brief in-class midterm review
Midterm examination information: Thursday Feb 15 from 4:30 - 5:45 PM (Outside of normal lecture time in ST 148) [Exam information link]
Feb 18 - 24 READING WEEK: No lectures, tutorials or CT
Feb 25 - Mar 3 Databases: queries
[Notes: PDF] [Notes: PowerPoint] [Example database]Mar 4 - 10 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) Mar 11 - 17 VBA programming in MS-Word Part I (continued) Mar 18 - 24 VBA programming in MS-Word Part I (continued) Assignment 2 (MS-Access, proportion of term grade 10%) due Tuesday March 20 at 5 PM Mar 25 - 31
Friday March 30 is Good Friday (no lecture or tutorial)
VBA programming in MS-Word Part II
[Notes: PDF] [Notes: PowerPoint] [Example programs]
April 1 - 7 VBA programming in MS-Word (continued) Computer security & privacy
[Notes: PDF] [Notes: PowerPoint]Chapter 5: Building a webpage April 8 - 14 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 April 13 at 5 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]. [Exam information link]