Fairtrade foundation ocr nationals in ict unit 1 ict skills for business ao5 l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 7

FAIRTRADE FOUNDATION OCR Nationals in ICT Unit 1 ICT Skills for Business AO5 PowerPoint PPT Presentation


  • 71 Views
  • Uploaded on
  • Presentation posted in: General

FAIRTRADE FOUNDATION OCR Nationals in ICT Unit 1 ICT Skills for Business AO5. Task 5: Create and use a simple spreadsheet. Assessment Objective 5: Create and use a simple business spreadsheet

Download Presentation

FAIRTRADE FOUNDATION OCR Nationals in ICT Unit 1 ICT Skills for Business AO5

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Fairtrade foundation ocr nationals in ict unit 1 ict skills for business ao5 l.jpg

FAIRTRADEFOUNDATIONOCR Nationals in ICTUnit 1ICT Skills for BusinessAO5


Task 5 create and use a simple spreadsheet l.jpg

Task 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 spreadsheet3 l.jpg

Task 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 spreadsheet4 l.jpg

Task 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 spreadsheet5 l.jpg

Task 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 spreadsheet6 l.jpg

Task 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.)


Resources l.jpg

Resources

Fairtrade Packs Spreadsheet

Showing Formula

One Page Printing

Teach ICT Spreadsheet


  • Login