• Using the 203 lab computers: [My help link]
• Submitting assignments using D2L: [UC-IT help link]
• A0: Practicing submissions and checking your results: [Support files]
• TAs 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.

  If you don't feel like you are already an expert using Word or even if you wish to review some features here are some help tutorials provided by Microsoft which you can work through before your first tutorial:
  
  Very basic 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)

  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, table of figures

What TA's will cover in tutorial: [Resources]

• 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

• 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

First tutorial (MT):

• 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, basic logic]
• Student exercise: applying conditional formatting if time less than 240 seconds run and age over 50 years: [Excel sheet, conditional formatting]

Second tutorial (WR):

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

Monday Oct 10: Thanksgiving day holiday

First tutorial (MT):

• No tutorial on Monday or Tuesday because of the Thanksgiving day holiday on Monday.
• CT: they are cancelled Monday, they will run as scheduled Tuesday.

Second tutorial (WR):

• Logic functions (AND, OR, NOT) combined with the IF function
• TAs over go the requirements of the Access Database assignment

First tutorial (MT):

• Basic introduction into Access
• 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): Databases to be used in tutorial

• Defining input masks
• Student exercise: Input masks
• Representing databases using ERDs
   

• Student ERD exercise
• Validation rules
• Student exercise: validation rules

Second tutorial (WR):

• Creating a graphical input form in Access
• Finding images online and copywriter
• 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 query exercises

Resources for this week:

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

Reading Days Nov 10 - 13 (No classes on Thursday)

• Open tutorial: no new material will be taught but you can go to any tutorial run by any Teaching Assistant for help during tutorial time. Or you can just work on your assignment in the lab.

Second tutorial (WR):

• Reading days on Thursday and Friday. No lectures, tutorials or Continuous tutorials will run on these days

• TAs over go the requirements of the Excel spreadsheet assignment: A4
• VBA introduction: variables, constants, input and output
• Objects: selection and ActiveDocument

Resources for this week:

• Example program where option explicit is used
• Example program where option explicit is not used
• TA VBA tutorial notes for the week

• TAs will hand back and go over select portions of the midterm

Second tutorial (WR):

• Branching mechanisms in VBA:
• TA VBA tutorial notes for the week

First tutorial (MT):

• Counting the number of occurrences (partial and exact matches)
• Counting typographical errors and annotating a document
• Opening and counting the number of typographical errors in all the documents in a specific location
• Exercise: running through all the documents of any type (defined by the file name suffix) in a folder
• VBA examples

Second tutorial (WR):

• Open tutorial: no new material will be taught but you can go to any tutorial run by any Teaching Assistant for help during tutorial time. Or you can just work on your assignment in the lab.

• TAs go over A5 assignment requirements: [Assignment description]
• Introduction to html and publishing a personal webpage on the University of Calgary web server: [Resource document] [Original document used in the tutorial exercise]