Unit 1 – Email Task

Task

For AO2 in Unit1 you need to demonstrate that you can use E-Mail effectively. To produce the evidence you will need to undertake the following tasks:

  • Create an Email Account
  • You will then need to complete the tasks on the tasksheet and complete the evidence sheet
Then complete the tasks below:

Worksheets

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

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

Unit 1 – Email Task

Task

For AO2 in Unit1 you need to demonstrate that you can use E-Mail effectively. To produce the evidence you will need to undertake the following tasks:

  • Log in to your school email account

 

  • You will then need to complete the tasks on the tasksheet and complete the evidence sheet
(username = Initial + Surname,  Password = changeme)
Change the password to the school password
Worksheets

Year 9 – AO1 Revisited

Lesson Aims:

  • Improve explanations for health and safety measures suggested in AO1 task
  • Improve explanation for measure to protect files from loss and unauthorised access
  • Explain how to create a strong password

Starter

Health and Safety

Main

Your task today is to improve the work you have done for AO1.  You need to clearly explain any measures you have suggested and clearly explain how they will protect the Health and Safety of computer users.

You will also explain clearly what measure you would take to protect files from loss and unauthorised access.

Use links below to help you

Teach -ICT health and safety

BBC Bitesize

Unit 1 – 2010 AO4

For AO4 you need to produce a minimum of three business documents, one of these must be a a business letter. Please ensure you have created the following documents

 

  • Business letter (letter to parents of pupils who might want to go on the Paris trip)

  • Flyer advertising the trip to Paris (Must contain a clipart image and an image from the internet)

  • Business Card (for teachers)

  • Business leaflet (explaining to Pupils how to stay safe on PCs and how to protect their files)

  • Memo

You also need to have completed the House style document below:

House Style documents

Once you have completed the House styles document, you will need to add annotation to your documents.  You need to identify formatting you have made, images from clipart and the internet.

 Evidence of annotation

 

Unit 1 – 2010 AO4 Business letter

Your task is to create a Business letter using your House Style. The letter is for the parents of Year 11 pupils at Newsome wanting to go on the Paris trip.

Here is an example of the content you may put in the letter.

Example letter

 Use the presentation below to help you decide how to layout a business letter: