FAIRTRADEFOUNDATION

OCR Nationals in ICTUnit 1

ICT Skills for Business

AO5

Task 5: Create and use a simple spreadsheetTask 5: Create and use a simple spreadsheet

Assessment Objective 5: Create and use a simple business spreadsheet

In this task you will create and use a simple spreadsheet appropriate to your work for the Fair Trade packs. Your spreadsheet should present the costs involved for at least two of the different pack options that you have found in Task 2a.

Use the activities below to produce evidence for your assignment.

Task 5: Create and use a simple spreadsheetTask 5: Create and use a simple spreadsheet

To achieve Pass level you need only complete parts A-E of this task.

A Create a simple spreadsheet to work out the cost each pack, there will be at least two different packs. This should include a title, column headings, row labels, text and numeric data.

For each item includes details as shown;

• Item• Description• Ref number• Cost

Task 5: Create and use a simple spreadsheetTask 5: Create and use a simple spreadsheet

B - Create appropriate formulas to calculate, for example:• cost of item adding VAT (17.5%)• total cost of each pack• average cost of all the items. (Merit and Distinction only)

C - Format text (font, style, size, alignment) and numbers (decimal places, percentage, currency, date/time). You could apply borders and shading.

D - Print the spreadsheet.

E - Change some data to get different results, for example you might change the price of certain irtems to investigate what happens to the final costs. Now print out your changed spreadsheet.

Task 5: Create and use a simple spreadsheetTask 5: Create and use a simple spreadsheet

F - Edit the spreadsheet by inserting/deleting rows. You may add or delete products from the packs created. (Merit and Distinction only)

G - Set the orientation and number of pages. To achieve Distinction level you should also set appropriate headers and footers and other appropriate print options (e.g. margins, gridlines, row and column headings).

H - Preview and print the spreadsheet in formula view. (Merit and Distinction only)

Task 5: Create and use a simple spreadsheetTask 5: Create and use a simple spreadsheet

To achieve pass level, your spreadsheet should contain formulas/functions that work.

To achieve Merit level, your spreadsheet should be effective, with accurate figures, appropriate heading and, a range of formatting. It should use several different formulas and at least one function. Your spreadsheet must be edited by inserting/deleting rows.

To achieve Distinction level, you should also use more than one function, and your headers and footers and print layout features should be appropriate.

(Evidence should be printouts of the original and changed spreadsheet. Changes to data, editing and setting of print options should be annotated.)

ResourcesResources

Fairtrade Packs Spreadsheet

Showing Formula

One Page Printing

Teach ICT Spreadsheet