| Weeks 1 - 3 | ||||||
|---|---|---|---|---|---|---|
| Week | Lecture | Tutorial/Exercise | ||||
|
1 |
Course Outline (Using Computer Applications) |
UCA Week 1 Exercises |
||||
2 |
Excel Tips |
|||||
|
|
If Exercise Spreadsheet case study |
||||
| Weeks 4 - 6 | ||||||
|---|---|---|---|---|---|---|
| Week | Lecture | Tutorial/Exercise | ||||
4 |
Naming and Vlookup Creating Macros |
Dave Deals |
||||
5 |
Spreadsheet Consolidation exercise |
UCA Excel Assignment |
||||
|
Data Types Exercise Lookups & Validation |
|||||
| Weeks 7 - 9 | ||||||
|---|---|---|---|---|---|---|
| Week | Lecture | Tutorial/Exercise | ||||
7 |
Queries |
UCA Database Assignment (Hand Out) |
||||
8 |
Reports |
|||||
|
Entity Relational Diagrams |
|||||
| Weeks 10 - 12 | ||||||
|---|---|---|---|---|---|---|
| Week | Lecture | Tutorial/Exercise | ||||
10 |
Documentation |
Example Technical Manual
Example User Manual |
||||
11 |
Workshop |
|||||
|
|
UCA Database Assignment (Hand In) |
||||
| Excel Links & Addtional Resources | ||||||
|---|---|---|---|---|---|---|
| Links | Additional Resouces | |||||
|
Module Descriptor
|
Excel 2007 Tutorial |
|||||
The majority of resources included on this page have been created by Janet Nichols for which a big thank-you is expressed.