Year 8 Exam

Ali’s Bike Shop

Ali owns a shop that sells bicycles. You need to do the following tasks for Ali.

TASK 1

Ali needs to know what Rule 59 of the UK Highway Code states.

1)Find out the contents of Rule 59 of the Highway Code using the internet.

2)Prepare an email to send the information you have found to Ali. Ali's email address

Evidence you must provide

Screen shot showing the search you did. (2)

Screen shot or printout showing the information you found. (2)

Screen shot showing the email you prepared (4)

TASK 2

Ali has provided you with the files listed below. (This can be found on the intranet)

ali's bicycles logo

BMX bicycles price list

cruiser bicycles data

customer details text

cycling gloves image

cycling helmet image

cycling vest image

special offer flyer text

Ali is going to do a special offer on children’s cruiser bicycles.

1)Ali needs you to find the details of all the children’s bicycles from the file he has provided. Use the cruiser bicycles data to find this out.

2)Create a flyer to tell customers about the special offer. The flyer must include:

  • the special offer flyer text that Ali has provided (4)
  • the details of the children’s cruiser bicycles that you found (8)
  • suitable images (from the internet)including the logo given (4)

3)Make sure that the flyer is formatted appropriately. (4)

Evidence you must provide

A printout of the flyer you created.

TASK 3

Ali needs a new price list for the BMX bicycles. He has decided to increase the price of each

BMX bicycle by 2.45%.

1)Insert the BMX bicycles price list into a spreadsheet (2)

2)Calculate the new price for each of the BMX bicycles in a separate column (6)

3)At the bottom include some cells to work out the Average new price and also the highest new price and lowest new price (6)

4)Provide Ali with the new price list showing the new price of each BMX bicycle formatted properly (2)

5)Create a column chart to show the new prices for all the models (6)

Evidence you must provide

A printout of your spreadsheet in normal view

A printout of your spreadsheet in formula view

A print out of your chart.

TASK 4

Ali needs you to create a data capture form (questionnaire) that he can give to customers to get some personal details from them.

He has provided the text he wants in the document in a file called “customer details text”

The details he needs to collect from each customer are: First name, Last name, Address,

Town, County, Postcode, Phone number and Email address.

Create the document for Ali so that it is suitable for use.

Make it look professional by including suitable images and formatting.

Evidence you must provide

A printout of the document you created. (11)

Task 5

Ali needs you to create a folder on your computer and put the files you have created for him into it. (5)

Evidence you must provide

A screen dump showing the folder and files you created for Ali.

Task 6 – Extension

Create a new logo for Ali’s bike shop that uses vector graphics and gives off a good corporate image.

Evidence you must provide

A screenshot of the new logo.