Term 2 - Jan to Apr 2004
| Week / date | Subjects covered | Relevant resources | |
|---|---|---|---|
| Wk1 06/01/04 |
Spreadsheets
|
Basic Excel procedures, | basic_excel.html |
| The student house phone bill | phonebill.xls | ||
| Example question similar to assignment | |||
| Wk2 13/01/04 |
More Integrated Apps & Spreadsheets
|
Exporting Excel tables to use in web pages | export_xl_tables.html |
Wk3 |
Why do we need databases?
|
Importing an Excel spreadsheet into Access | import_to_access.html |
...said excel spreadsheet |
docs/contacts and complaints.xls | ||
| Wk4 27/01/04 |
Looking at databases
|
||
| Wk5 03/02/04 |
Working with Databases
|
Performing a Mail Merge in Word | poit/mailmerge.html |
Wk6 |
Email: types of email, general issues and simple emailing | ||
Wk7 |
Email: multiple adresses, receipts, priority, attachments, etc. | ||
| Wk8 24/02/04 |
Preparation for assignment and exercises. |
Exercise - example questions | |
| Wk9 02/03/04 |
Preparation for assignment and exercises. | Summaries of questions of type: | poit/databases.doc poit/email.doc poit/file manage.doc poit/hardware HnS.doc poit/searches.doc poit/spreadsheets.doc poit/word processors.doc |
| Wk10 9/03/04 |
Assignment | Question papers | www.city-and-guilds.co.uk/e-quals |
| Wk11 16/03/04 |
Debrief on assignment / Prepare for test | Sample questions | www.city-and-guilds.co.uk/e-quals |
| Wk12 23/03/04 |
Prepare for Test |
Relevant City and Guilds 7261 tests | 212-tests.pdf |
| Wk13 30/03/04 |
3hr session as part of Web Page Design assignment |
|
|
Last updated 21/10/03
the luvvit company ©2000-2003