Week

Topics covered

Sept 6 - 12

No tutorials

Sept 13 - 19

• Using the 203 lab computers: [My help link]
• Submitting assignments using D2L: [UC-IT help link]
• 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:

To do before tutorials: 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)

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

What TA's will cover in tutorial

• Linking documents between different MS-Office applications (e.g., Excel and Word)
• Find and replace: case sensitive and employing a wildcard
• Change tracking
• Using, creating and modifying styles
• Citations, bibliographies, footnotes, figure captions, table of figures
• Master and sub-documents

Sept 20 - 26

• Evaluating logical expressions in different forms: AND, OR, NOT [Support document]
• Describing assignment submission requirements (especially D2L specific requirements)

Second tutorial (Wednesday or Thursday)

• Overview of MS-Excel: [spreadsheets]

Partial A1 due on Sept 25

Sept 27  - Oct  3

• Overview of requirements for A2
• Excel statistical functions
• Excel string functions: upper, lower, proper, concatenate, trim
• Finding and extracting text: find, left, right, mid
• Example spreadsheet

Oct 4 - 10

• Simple If function (if, else)
• Nested if functions
• Lookup functions: LOOKUP, VLOOKUP
• Cell references: absolute, relative
• Example starting spreadsheet

Oct 11 - 17

First tutorial (Monday or Tuesday)

• No tutorial on Monday because it's the Thanksgiving holiday
• Tuesday tutorial will an 'open tutorial'. TAs will be available for help and to answer questions but no new material will be taught (although they may cover material that they missed covering in the previous week). Any student from 203 can ask for help during an open tutorial (you don't have to be registered in that section). Students can also work on their assignment in the lab.

Second tutorial (Wednesday or Thursday)

• 'Open tutorial'. TAs will be available for help and to answer questions but no new material will be taught (although they may cover material that they missed covering in the previous week). Any student from 203 can ask for help during an open tutorial (you don't have to be registered in that section). Students can also work on their assignment in the lab.

A2 due October 16

Oct 18 - 24

• Discussion of A3
• Overview of the Access: Design view, datasheet view, creating queries, viewing relationships
• Creating a new table, specifying attributes
• Details of the design view
• Data integrity concepts illustrating in Access (referential integrity)
• Input masks
• Validation rules

Oct 25 - 31

Database queries (query builder and SQL): [Starting database]

Nov 1 - 7

• ERDs
• Graphical forms for data entry
• Graphical report view of queries
• Database normalization (up to third normal form)
• Extra: complex database validation example and exercise [Starting database]

Nov 8 - 14

• Open tutorial'. TAs will be available for help and to answer questions but no new material will be taught (although they may cover material that they missed covering in the previous week). Any student from 203 can ask for help during an open tutorial (you don't have to be registered in that section). Students can also work on their assignment in the lab.

Second tutorial (Wednesday or Thursday)

• Reading Days: November 11 - 14. No lectures, tutorials or labs (for this course it refers to CT time) held during these days.

Nov 15 - 21

• Open tutorial'. TAs will be available for help and to answer questions but no new material will be taught (although they may cover material that they missed covering in the previous week). Any student from 203 can ask for help during an open tutorial (you don't have to be registered in that section). Students can also work on their assignment in the lab.

Second tutorial (Wednesday or Thursday)

• Discussion of A4
• Midterm examinations will be returned. TAs will cover select questions

A3 due November 17

Nov 22 - 28

• Writing VBA programs for Word
• Using the debugger
• Variables
• Constants
• Input and output
• If, If Else-If

Nov 29 - Dec 5

• Multiple Ifs
• If, Else-If, Else
• For loops
• Do While loops
• Nesting
• The DIR() function
• Finding/Replacing words
• Counting instances of word
• Macro enabled Word document with the example subroutines: [Document]

Dec 6 - 12

First tutorial (Monday or Tuesday)

• Open tutorial'. TAs will be available for help and to answer questions but no new material will be taught (although they may cover material that they missed covering in the previous week). Any student from 203 can ask for help during an open tutorial (you don't have to be registered in that section). Students can also work on their assignment in the lab.
   

A4 due December 8