Scenario: You have been employed by the 'iPod Store' as their ICT and Administration person. The manager needs you to show them how to perform a range of tasks (listed below) to improve their use of ICT and Administration.
This task requires you to use a range of graphics from a wide range of sources e.g. www, scanner, other programs e.g. graphs/charts from excel etc.
__________________________________________________________________
1. Create a Simple Business Spreadsheet (E) (Formula Help)
The iPod Store need you to create a new business spreadsheet as part of their moderisation.
- Pass - Create a simple spreadsheet using a limited number of calculations. You MUST use formula/functions, suitable column headings and some formatting e.g. alignment, bold, italic, cell formatting.
- Merit - Create an effective spreadsheet displaying accurate figures. You MUST use several different formulas and at least one function. You MUST also use suitable column headings and a range of formatting e.g. alignment, bold, italic, cell formatting.
- Distinction - Create an effective spreadsheet displaying accurate figures. Formulas will be used efficiently and more than one appropriate function. You MUST also use suitable column headings and a range of formatting e.g. alignment, bold, italic, cell formatting.
__________________________________________________________________
2. Obtaining different results (E) (Help)
The iPod Store also require you to show them how to obtain different results e.g. increase their profit.
- Pass - You show evidence of increasing the original selling price of each item by a suitable amount.
- Merit - You show evidence of increasing the original selling price of each item by a suitable amount. This must include before and after screenshots and suitable annotation.
- Distinction - You show evidence of increasing the original selling price of each item by a suitable amount. This must include before and after screenshots and detailed annotation.
__________________________________________________________________
3. Inserting and Deleting Rows (E) (Help)
The Manager would like you to show her how to delete sale items no longer being sold. She would also like you to show how to insert new sale products for sale.
- Merit - You show evidence of inserting a new row and product. You MUST also show evidence of deleting an existing row.
- Distinction - As above - no additional evidence needed.
__________________________________________________________________
4. Printing the spreadsheet (E) (Help)
The Manager needs you to show her how to print the spreadsheet (normal and formula views) so that it 'fits to page' has gridlines and is set to landscape.
- Pass - You print out your spreadsheet although the format might not be suitable.
- Merit - You print your spreadsheet in a suitable orientation and number your pages.
- Distinction - You print your spreadsheet in a suitable orientation (set to landscape, fit to page and using gridlines) as well as number your pages. Headers and/or Footers must be used correctly.
beside each task for more information.