• No tutorials

• 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]
• 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

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

• 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

• Logic: refresher from lecture, [Logic exercise]

Second tutorial (Wednesday or Thursday): [Resources]

• Excel overview
• Shortcuts: Autofill, fastfill
• Changing view: freezing panes
• Multiple worksheets
• Calculations and order of operation

• TAs over go the requirements of the Excel spreadsheet assignment: A2
• If there is time TAs may start some of the Excel functions during this tutorial

Second tutorial (Wednesday or Thursday): [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 spreadsheet: using the if() function in conjunction with a lookup table, column charts, countif() function, pivot tables: [Excel sheet]
• Second spreadsheet: using the lookup() function, absolute vs. relative cell references: [Excel sheet]
• Third spreadsheet: a modified corrected version of the first spreadsheet with the proper application of absolute vs. relative cell references: [Excel sheet]
• Fourth spreadsheet: using the vlookup() function: [Excel sheet]
• Fifth spreadsheet: a modified version of the fourth spreadsheet introducing what-if analysis; [Excel sheet]

• Folder containing example spreadsheets: [Link to folder]

• Basic logic functions in Excel (AND, OR, NOT): [Spreadsheet data]
• Logical functions used in conjunction with the IF-Function: [Spreadsheet data]
• String functions: [Spreadsheet data]

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.

• TAs cover the requirements for A3
• TAs may start some of their coverage of Access in this first tutorial if there is time

Second tutorial (Wednesday or Thursday): [Example database used in tutorial]

• 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
• Defining input masks

[Summary of TA materials for databases week 1]

• Student exercise: Input masks
• Student exercise: ERD

Second tutorial (Wednesday or Thursday):

• Validation rules
• Student exercise: validation rules
• Creating a graphical input form in Access

[Version of the database used in this weeks tutorial]

• Database normalization
• Introduction to queries: simple, single table queries

Second tutorial (Wednesday or Thursday):

• Multiple table queries
• Logical operations and queries: AND, OR, NOT
• Complex queruies
• Student query exercises

Resources for this week:

• External resource: [Database normalization]
• [Version of the database used in this weeks tutorial]
• Queries and exercise for this weeks tutorials

• Midterms will be returned
• TAs will go over select midterm questions

Second tutorial (Wednesday or Thursday):

March 25: Good Friday, no classes (or CT)

• TAs over go the requirements of A4: the Webpage and JavaScript programming assignment
• TAs go over the rules for what's allowed and not allowed for assignments
• Review of creating a webpage (shown in the context of the lab computers)
• Supporting material for student html exercise: [Starting document] [Screenshot of solution]
• Supporting material for student JavaScript exercise: [Starting document]

• JavaScript, Part 2: Advanced use of html controls, branching: [Link to folder containing intermediate versions] [Complete final version]
• JavaScript, Part 3: Looping: for and while [for-loop solution] [while-loop solution]
• Exercise 1, writing nested code: [Starting program]
• Exercise 2, finding the logic error: [Program]
• Exercise 3, finding multiple errors: [Program]