Technical requirements for students in the distance learning version of this course (paraphrased version from what was provided by the university).
Although students using different types of computer operating systems (Windows, Mac OS, Chrome) have completed this lecture section in the past, this section is Windows specific. In years past there was a Mac specific lecture offered but you will need to check PeopleSoft for current information. (If you don't find anything there then check with the Faculty of Continuing Education for their current offerings). Because this is a Windows lecture section if you run into problems related to another operating system we won't have access to those resources so unfortunately it's not likely that we will be able to assist you.
An alternative for students who don't have MS-Office on a Windows computer: [Running Office 2016 using a remote connection to a Windows 10 TriLab computer]
|
Day/Time |
L01: MWF (10:00 - 10:50 AM) via Zoom links. Look under 'content' in D2L and lectures will be listed chronologically. |
|
Contact Information |
James Tam |
|
|
Office time: M (11:00 - 11:50 AM), Tuesday (2:00 - 2:50 PM) via a Zoom link |
|
|
Email: tam@ucalgary.ca |
| Official information |
Official course information sheet (summary of
official course requirements)
|
| General assignment information |
Grade calculator to estimate your term grade:
[Excel spreadsheet] Academic misconduct vs. collaboration: what is allowed for this class All assignments except for the last will be graded by your tutorial instructor. The first person to contact with questions about marking will be that person. |
| Books (available via the UC bookstore) |
Textbook (explanation of some course material):
Computer Science Chop Suey Lite. eBook ISBN 9781119545743, printed text
ISBN
9781119550273 Workbook (practice problems): Computer Science Chop Suey: Chop-Chop Problems. eBook ISBN 9781119699354, printed text ISBN In production (as of the start of September). |
| For more information | Grading information, how the course will be run etc. |
Teaching tutorials (commence the week of Sept 13 - 19) and will be available via a Zoom link (look under 'content' in D2L and under the appropriate week for the tutorial you will find a separate folder for each tutorial)
- Tutorials are a mandatory component of the courses. Time will be spent on the following: TA's teaching new skills, discussion of assignment requirements and if possible some question and answer time.
Tutorial
Date/Time
Instructor
Contact information: if you have questions it's best to reach the TA during the CT time but you can email them for relative short and simple questions. T01 MW 1:00PM - 1:50PM Baker, Zackary zackary.baker@ucalgary.ca T02 TR 1:00PM - 1:50PM Wang, Nanija (Eric) nanjia.wang1@ucalgary.ca T03 MW 11:00AM - 11:50AM Kwiatkowski, Christopher cakwiatk@ucalgary.ca T04 TR 9:00AM - 9:50AM Baker, Zackary zackary.baker@ucalgary.ca T05: TR 2:00PM - 2:50PM Kwiatkowski, Christopher cakwiatk@ucalgary.ca
Week Topics covered Before Word tutorials Assumed knowledge of Word (it would be a good idea to at least skim through those notes even though you are familiar with this program). [PDF] [PowerPoint] Sept 6 - 12 (first lecture is Sept 9) Sept 13 - 19
- Exercise: Assignment #0 (students can try out the process of submitting files into and learning how to properly verify their submission with a TA available for help).
- Go over requirements: Workbook Exercise #1
- Go over requirements: Assignment #1
- MS-Word: 'Save' vs. "Save as", tagging Office files, creating PDF versions of documents, approaches for mitigating disaster in Word, converting between different versions of Word, formatting text, show/hide formatting symbols, insertions (images, page breaks, cover pages, section breaks, symbols & equations). [Notes: PDF] [Notes: PowerPoint]
Sept 20 - 26 MS-Word: operations with tables (basics will be assumed), table formulas, document headers/footers, text styles, using the format painter, finding text, document views, master-subdocuments, linking Word documents with other types of files (e.g. Excel spreadsheets). [Notes: PDF] [Notes: PowerPoint] [Starting Word documents] Sept 27 - Oct 3 MS-Word: Mail merge without using the Wizard, creating a table of contents, creating & using citations, figure captions, footnotes & endnotes, tracking changes in Word. [Notes: PDF] [Notes: PowerPoint] [Starting Word documents] Before Excel tutorials Basic and useful features of Excel that won't be covered. [PDF] [PowerPoint] Oct 4 - 10 First tutorial (Monday or Tuesday): TAs will go over the requirements for:
Second tutorial (Wednesday or Thursday): MS-Excel: common math operators, order of operation, merging cells, wrapping cell data, indenting, defining custom formulas, data validation (string/character information) [Notes: PDF] [Notes: PowerPoint] [Starting Excel spreadsheets]
Oct 11 - 17 (Thanksgiving holiday Monday Oct 12). First tutorial (Monday or Tuesday): No tutorial on Monday because of the Thanksgiving holiday, during Tuesday tutorials no new teaching will occur but the TA will be available for help. During this "Open Tutorial" any CPSC 203 student can ask for help and not just the students who are registered in a particular tutorial.
Second tutorial (Wednesday or Thursday): working multiple worksheets, named constants, simple pre-created or pre-written functions: AVERAGE, TRUNC, COUNT, COUNTA, COUNTBLANK, MIN, MAX, SUM, ROUND, TODAY, DATE, Format cells and different types of data (Number, currency, accounting, percentage, fraction, scientific, text, special, custom), conditional formatting. [Notes: PDF] [Notes: PowerPoint] [Starting Excel spreadsheets] Oct 18 - 24 First tutorial: lookup tables and the VLOOKUP function, finding and fixing errors, counting occurrences (via the COUNTIF function), inserting a column chart.
Second tutorial:, branching (via the IF function) and logic (AND, OR functions), cell references (more advanced examples, transposing their use). Web searches using logic: AND, OR, NOT.
[Notes: PDF] [Notes: PowerPoint] [Starting Excel spreadsheets]
Oct 25 - 31 First tutorial: recording a VBA Word macro, displaying output using a MsgBox, declaring variables to store information, getting user typed input using an InputBox, common operators in VBA. Going over requirements: Work Exercise #3: First Word VBA macro exercise. [Notes: PDF] [Notes: PowerPoint] [Starting VBA programs] [Solutions to the tutorial exercises]
Second tutorial (Wednesday or Thursday): No new teaching will occur but the TA will be available for help. During this "Open Tutorial" any CPSC 203 student can ask for help and not just the students who are registered in a particular tutorial. The purpose is to provide extra help because a more challenging full assignment.
November 1 - 7 First tutorial: accessing the number of typographical errors in a document, changing font properties, writing text to a document, finding things in a document (text strings, font effects, formatting styles in Word). Also the TAs will go over the following requirements: Second tutorial: working with collections in Word (Documents, InlineShapes, Shapes, Tables).
Resources for the week [Notes: PDF] [Notes: PowerPoint] [VBA examples] [Material for the tutorial exercises]
Nov 8 - 14 (Reading week, no classes or CT) Nov 15 - 21 First tutorial: branching using the IF-structure, repetition using the WHILE-structure, nesting branches within branches. Second tutorial: nesting loops within branches, nesting branches within loops, branching & loops applied to VBA collections, benefit of including an Option Explicit instruction, using the VBA debugger.
Resources for the week [Notes: PDF] [Notes: PowerPoint] [VBA examples] [Material for the tutorial exercises]
Nov 22 - 28 First tutorial (Monday or Tuesday): using the DIR function to access files. Review and new information to avoid problems with academic misconduct. Resources for the 1st tutorial [Notes: PDF] [Notes: PowerPoint] [VBA examples] [Exercises]
Second tutorial (Wednesday or Thursday): No new teaching will occur but the TA will be available for help. During this "Open Tutorial" any CPSC 203 student can ask for help and not just the students who are registered in a particular tutorial. The purpose is to provide extra help because a more challenging full assignment.
Nov 29 - Dec 5 Going over the requirements for Workbook Exercise 5, Resources for the week [Notes: PDF] [Notes: PowerPoint] [VBA examples] [Solutions for the tutorial exercises]
Dec 6 - 12 (last day of class and CT is Dec 9) No new teaching will occur but the TA will be available for help. During these "Open Tutorials" any CPSC 203 student can ask for help and not just the students who are registered in a particular tutorial. Help tutorials = Continuous tutorials (or CT for short) where you can go for help outside of class in addition to my office time. Each TA will have a separate Zoom link. CT commences the week of Sept 27 - Oct 3. The number of hours vary according to the anticipated demand so check the schedule below for specifics.
- 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
- Continuous tutorial schedule: [CPSC 203 CT schedule]
