Unit 1 2010 – AO6 Using databases

Lesson Aim

  • To be able to add, edit and delete a database record
  • To be able to create a simple query
  • To be able to create a report

Your Task

You need to download the following two files and save them in to your AO6 folder and then complete the tasks on the evidence sheet using the database:

Hosts database

Evidence sheet 1

You may use the following video tuitorials to help you create the query required:

Query Tutorials

To complete the task you will also need the complete the tasks on the worksheet below:

Evidence Sheet II

Unit 2 – AO2 Backup Evidence

Lesson Aim

  • Know : Why it is important to back up their work
  • Understand: How to back up their website
  • Why: To ensure that in the event the hard drive fails they will be able to retrieve their work

Starter

Explain necessity of backing up there website and show example

Main Task

Back up your website and provide evidence on the worksheet below:

Backup evidence Sheet

Alternative Link

Backup evidence sheet

If you have provided evidence of backing up your unit 2 work, ensure you have met the merit and distinction requirements for AO2 in Unit 2

Unit 2 – AO2 Image Optimisation

Lesson Aims

  • Know: How to optimise images for the WWW in Serif Webplus
  • Explain: The importance of optimising images for the WWW
  • Why: To create an effective website

Starter

Image Optimisation

Main Task

Explain the importance of Optimising Images by using the worksheet below:

Image Optimisation (Distinction)

Use the helpsheet below to optimise the images in your website provide the evidence on the evidence sheet:

Optimising images in Serif Webplus

Evidence Sheet

Alternative Links

Image Optimisation (Distinction)

Evidence Sheet

 

Introduction to AO5

Review of Spreadsheets

Spreadsheet Tasks

Your Task

In preparation for AO5 you will carry out a practice task. Follow the instructions on the worksheet to create a spreadsheet to work out the costs for a student trip. Ensure you complete the evidence sheet as well. If you get stuck use the links to the tutorials.

Download and save the files to your folder:

Task Sheet 

Evidence Sheet 

Spreadsheet tutorials 

If you complete the task then go onto Nexus and start to create a spreadsheet for AO5. Click on the link below

Unit 1 2010