• Using the 203 lab computers: [My help link]
• Submitting assignments using D2L: [UC-IT help link]
• A0: Practicing submissions and checking your results: [Assignment description]
• Go over A1 assignment requirements: [Assignment description]

(Catch up material for MS-Word - if needed).
It's assumed that everyone has worked with the very basic features of word processors such as MS-Word. In tutorials TA's will go over some of the more 'advanced' features of Word which some of you may not be familiar with partly so you can learn some useful features but also because it will be quite helpful to know the existing features of Word well before trying to write programs to augment these features.

• Creating your first Word document, using basic features
• Tips for working with Word online (the interface is the same as the latest version of office so topics such as find/replacing text and printing could still be helpful)
• Setting margins, headers and footers
• Getting statistics about Word documents (counts of characters, words, lines, paragraphs, pages)

To do before tutorials: More advanced features of Word

• Using formatting 'styles' in Word (which begs the question: Why use styles in Word)
• Creating an academic paper using the MLA template
• Writing resumes with Word
• Using mail merge
• Advanced table of contents

Features of Word TAs cover this week [Resources]

• Citations, bibliographies, footnotes, figure captions

What TA's will cover in tutorial: [MS-Word Resources] [Resource file for logic]

• Master and sub-documents
• Using, creating and modifying styles
• Automatically generated table of contents
• Linking documents between different MS-Office applications (e.g., Excel and Word)
• Find and replace: case sensitive and employing a wildcard
• Change tracking
• Logic: AND, OR, NOT

• TAs over go the requirements of the Excel spreadsheet assignment: A2
• Formatting and layout effects: setting the cell fill  & font color, text wrapping & indenting

Second tutorial (WR): [Resources]

• 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
• Setting the format of cell data: general, number, currency, accounting, date, time, percentage, fraction, scientific, special and custom
• Third spreadsheet, basic logic: [Excel sheet, basic logic]

• First spreadsheet: using string functions. [Excel sheet]
• Second spreadsheet: using the if() function in conjunction with a lookup table, column charts, countif() function, pivot tables: [Excel sheet: salaries, if and pivot table]
• Third spreadsheet, basic logic: [Excel sheet, note only a part of this sheet will be covered during the first tutorial]
• Student exercise: applying conditional formatting if time less than 240 seconds run and age over 50 years: [Excel sheet, conditional formatting]

Second tutorial (WR):

• First spreadsheet: alternate version of the spreadsheet from last tutorial, this one employs absolute cell references: [Excel sheet, IF-function absolute table lookups]
• Second spreadsheet: using the VLOOKUP() function, absolute vs. relative cell references: [Excel sheet, salaries via a lookup function and a lookup table]
• Third spreadsheet: a modified version of the previous spreadsheet introducing what-if analysis: [Excel sheet, salaries VLOOKUP and what-if analysis]

• Logic functions (AND, OR, NOT) combined with the IF function
• Spreadsheet design

Second tutorial (WR):

• TAs over go the requirements of the Access database assignment A3

• Overview of the features of MS-Access: DesignView ('General tab', types of data) vs. DataSheet, documenting a database via the 'description' field
• Primary vs. foreign keys, database relationship types (1:1, 1:*, *:*)
• Ensuring referential integrity

Second tutorial (WR):

• Defining input masks
• Student exercise: Input masks
• Student exercise: Creating an ERD

Resource files for the week

• Validation rules
• Student exercise: validation rules

Second tutorial (WR):

• Creating a graphical input form in Access
• Finding images online and copyrights to images
• Database normalization

[The database used in this weeks tutorial]

• Introduction to queries: simple, single table queries
• Multiple table queries

Second tutorial (WR):

• Logical operations and queries: AND, OR, NOT
• Complex queries
• Student exercises

Resources for this week:

• [Version of the database used in this weeks tutorial]
• [Queries and exercise for this weeks tutorials]

• '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 2017.

Second tutorial (WR):

• TAs will return the midterms and go over select questions
• Recording macros in VBA: [Lab notes] [Document for lab exercise]

• TAs will go over in detail, the requirements for A4
• Input and output using the InputBox and MsgBox
• Variables
• Branching: IF, IF-Else, IF-ElSE-IF, Multiple IFs
• Looping/repetition using do-while: simple counting loops
• Student exercises

Link to tutorial programs for this week

• Branching (using DO-WHILE)
• Nesting
• Student exercises

Link to tutorial programs for this week

• Using the the 'DIR' function (multiple variations)
• 'Finding' and replacing words in a Word document
• Counting spelling errors, writing text to a document via 'TypeText'
• Using the 'DIR' function to iterate in succession through all the Word (2003 and 2007+) documents in a folder and employing the 'Documents' collection to open Word documents.
• TAs go over the requirements of PA5

Second tutorial (WR):

• TAs cover any material that was missed during the last tutorial
• '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 2017.