All resources

Module 1

1. Video 1.1 Time-lapse of Sydney harbour – an example of an MPEG 4 video file (00:26 – no audio)

Module 3

1. Video 3.1 Inserting graphs (02:06)
2. Video 3.2 Using sections (03:15)
3. Video 3.3 Publishing tasks (05:12)
4. Video 3.4 More detailed newsletters (05:17)
5. Video 3.5 Inserting equations (04:03)
6. Video 3.6 Mail merge 1 (03:29)
7. Video 3.7 Mail merge 2 (01:57)

Module 4

1. Video 4.1 Creating an animation (02:47)
2. Video 4.2 Animating along a path (04:01)
3. Video 4.3 Movie clips (04:36)

Module 5

1. Video 5.1 Creating a drawing (04:48)
2. Video 5.2 Editing objects (01:43)
3. Video 5.3 Using symbols in designs (05:19)
4. Video 5.4 Freehand drawing tools (02:21)

Module 6

1. Video 6.1 Selecting parts of images (05:19)
2. Video 6.2 Adjusting image sizes (00:53)
3. Video 6.3 Saving files for the web (02:31)
4. Video 6.4 Repairing parts of photographs (03:10)

Module 7

1. Video 7.1 Working with multiple worksheets 1 (02:49)
2. Video 7.2 Working with multiple worksheets 2 (02:16)
3. Video 7.3 Pivot tables 1 (01:10)
4. Video 7.4 Pivot tables 2 (01:04)

Module 8

1. Video 8.1 Creating a database (04:14)
2. Video 8.2 Calculations in databases (01:38)

Module 9

1. Video 9.1 Creating a site (01:54)
2. Video 9.2 Inserting text and graphics (04:00)
3. Video 9.3 Using tables (02:02)
4. Video 9.4 Using templates 1 (02:53)
5. Video 9.5 Using templates 2 (01:52)

Module 10

1. Video 10.1 Creating a flyer (07:44)

Module 11

1. Video 11.1 Thinking logically (02:33)
2. Video 11.2 Flow diagrams (05:05)

Module 1

1. Computer awareness project example: Designing a network

Module 2

1. Social and ethical practice in IT project example

Module 3

1. Exercise 2 data: XSaction camping text
2. Exercise 3 data: Car image
3. Exercise 3 data: Deals on Wheels text
4. Exercise 4 data: Horizon microscopes text
5. Exercise 4 data: Microscope image
6. Exercise 4 data: Horizon image
7. Exercise 5 data: Travel brochure text
8. Exercise 5 data: Big Ben image
9. Exercise 5 data: Venice image
10. Exercise 7 data: Business letter text
11. Word processing project data: Jackson Real Estate flyer
12. Word processing project example: Jackson Real Estate

Module 5

1. Exercise 2 data: Hammer image
2. Exercise 6 data: Chair image
3. Exercise 6 data: Plant image

Module 6

1. Exercise 1 data: Car image
2. Exercise 4 data: Car image
3. Exercise 5 data: Girl image

Module 7

1. Exercise 3 data: Inventory spreadsheet
2. Exercise 4 data: Telephone Sales spreadsheet
3. Exercise 8 data: Split Sales spreadsheet
4. Exercise 8a data: Internet Charge spreadsheet
5. Exercise 9 data: Paid spreadsheet
6. Exercise 15 data: VLOOKUP spreadsheet
7. Exercise 15a data: HLOOKUP spreadsheet
8. Exercise 16 data: Pivot spreadsheet
9. Spreadsheets project example: Sporting Results

Module 8

1. Exercise 6 data: Pizza image
2. Download project data: Eastwick Football Club
3. Databases project example: Eastwick Football Club

Module 9

1. Exercise 2 data: Ticket image
2. Exercise 3 data: Movie Category images
3. Exercise 4 data: Logo image
4. Exercise 7 data: Facebook image
5. Exercise 9 data: Button images
6. Webpage authoring project data: Garden Gnomes
7. Webpage authoring project example: Garden Gnomes site diagram

Module 10

1. Exercise 1 data: House image
2. Exercise 2 data: Menu images
3. Exercise 2 data: Menu text
4. Exercise 3 data: Tour text
5. Exercise 3 data: Newsletter files
6. Exercise 3 data: Newsletter files 2
7. Exercise 4 data: Card files
8. Exercise 4 data: Dog image
9. Desktop publishing project data: NewSound
10. Desktop publishing project example: NewSound

Module 11

1. Algorithms and programming project example: Business ordering

1. Computer awareness project
2. Social and ethical practice in IT project
3. Word processing project
4. Flash animation project
5. Computer graphics project
6. Photo editing project
7. Spreadsheets project
8. Databases project
9. Webpage authoring project
10. Desktop publishing project
11. Algorithms and programming project