• Submitting assignments using D2L: [UC-IT help link]
• A0: Practicing submissions and checking your results: [Assignment description]
• TAs over go the requirements of the Excel spreadsheet assignment: A1

Second tutorial (WR): [Resources]

• Formatting and layout effects: setting the cell fill & font color, text wrapping & indenting
• Setting the format of cell data: general, number, currency, accounting, date, time, percentage, fraction, scientific, special and custom
• Pre-created Excel functions: e.g., SUM, ROUND, TRUNC, COUNTIF, AVERAGE, COUNT, COUNTA, MAX, MIN, NOW, TODAY
• Student exercise: defining arbitrary functions in Excel Formatting and layout effects: setting the cell fill & font color, text wrapping & indenting

• First spreadsheet: logical functions in Excel [Excel sheet]
• Second spreadsheet: using string functions [Excel sheet]
• Third spreadsheet: using the if() function in conjunction with a lookup table, column charts, countif() function [Excel sheet: salaries]
• Student exercise: applying conditional formatting if time less than 240 seconds run and age over 50 years: [Excel sheet, conditional formatting]

Second tutorial (WR): [Resources]

• Using VLOOKUP for ranges (approximate matches) [Excel sheet]
• Using VLOOKUP for keys (exact matches) & changing the return column [Excel sheet]
• Using logic in conjunction with the IF function [Excel sheet]
• Absolute vs. relative cell references [Excel sheet]

• Spreadsheet string exercises
• TAs over go the requirements of the Access database assignment: A2

Second tutorial (WR):

• 'Open tutorial': TAs will be available for help in the lab (you can also work there without asking questions). Unlike regular tutorial you can go during any tutorial time and not just section in which you registered. List of all tutorials for CPSC 203, winter 2018.

A1 due Friday February 9 at 5 PM

• Access basics: where Access can be run, creating a databases, creating new tables, defining attributes and their type, documentation, Design View vs. DataSheet View
• Creating a graphical data entry form
• Primary keys
• Foreign keys and multiplicity: one to one, one to many, many to many

Second tutorial (WR): [Resources: Notes, Example database]

• Error prevention by specifying input masks
• ERDs

READING WEEK: No lectures, tutorials or CT

First tutorial (MT): [Resources: Database]

• Validation rules
• Student exercise: validation rules

Second tutorial (WR):

• Creating a graphical input form in Access
• Database normalization

• (This has a lower priority because some students missed their tutorials on Thur March 1 because of the fire in MS, they will go over the exam only if there is extra time): Teaching Assistants will hand back midterm examinations and go over select questions
• Examinations can only be picked up the student (university regulations do not allow you designate another person to do so)
• Make sure you attend your registered section. The exams distributed for a particular tutorial will only include papers for the students registered in that section

Second tutorial (WR): [Resources]

• Databases queries using the graphical design mode and SQL: simple queries, logical operations and queries (AND, OR, NOT)
• Student exercises

• Many student exercises: queries using logical operators (AND, OR, NOT)

Second tutorial (WR):

• Using wildcards in queries
• Forming multi-table queries
• Deriving values as table attributes vs deriving values in a query: how each approach is done and when to apply each approach

[Resources for the week]

• 'Open tutorial': TAs will be available for help in the lab (you can also work there without asking questions). Unlike regular tutorial you can go during any tutorial time and not just section in which you registered. List of all tutorials for CPSC 203, winter 2018.

Second tutorial (WR):

• TAs go over the rules about help other students vs. academic misconduct
• Automatically recording macros in Word
• TAs over go the requirements of the VBA programming assignment: A3
• [Resources for this tutorial]

A2 due Tuesday March 20 at 5 PM

Mar 25 - 31

Friday March 30 is Good Friday (no lecture or CT)

• Declaring and using variables
• Getting user input: InputBox
• VBA operators
• Branching: IF, IF-THEN
• Logic and branching
• Branching: Multiple IFs, IF-ELSEIF
• Simple counting loops

Second tutorial (WR):

• Error handling loops
• Loops vs. branches
• Nesting

[Resources for the week]

• Many student exercises: loops and branches
• The value of "Option Explicit"
• Using the VBA debugger
• The 'dir' function (several examples)
• Text processing and other useful functions/methods (several examples)

[Resources for the week]

 All tutorials during this week

• 'Open tutorial': TAs will be available for help in the lab (you can also work there without asking questions). Unlike regular tutorial you can go during any tutorial time and not just section in which you registered. List of all tutorials for CPSC 203, winter 2018.

A3 due Friday April 13 at 5 PM