AO5 Pass Merit Distinction
Design, create and use a business spreadsheet.
  • Design and create a business spreadsheet for a given purpose using at least two different calculations
  • Functions/formulas work but may not be the most efficient
  • Sufficient row/column headings to make the spreadsheet reasonably easy to understand
  • Some formatting will be applied to improve the appearance of the spreadsheet
  • Change some of the numeric data in the spreadsheet to model the expected outcome of at least two different scenarios noting the results
  • Print out the spreadsheet
  • Design and create an effective business spreadsheet for a given purpose displaying accurate figures and using several different formulas, including;
    • at least one function, and
    • at least one arithmetic operator
  • The spreadsheet contains a title and appropriate row/column headings
  • A range of formatting is applied to improve the appearance of the spreadsheet
  • Change some of the numeric data in the spreadsheet to model the expected outcome of at least two different scenarios
  • Note and explain the results
  • Preview and print out the spreadsheet using appropriate page orientation and number of pages
  • Print out spreadsheet showing formula
  • Design and create an effective business spreadsheet for a given purpose displaying accurate figures and using several different formulas efficiently, including;
    • appropriate use of more than one function
    • at least two different arithmetic operators
  • The spreadsheet contains a title and appropriate row/column headings
  • The spreadsheet will be formatted effectively using a range of format options to improve the appearance of the spreadsheet
  • Change some of the numeric data in the spreadsheet to model the expected outcome of at least two different scenario
  • Note and explain the results
    Preview and print out the spreadsheet using appropriate page orientation and number of pages
  • Use appropriate headers and/or footers
  • Set at least one further print layout feature appropriately
  • Print out spreadsheet showing formula
Diweddarwyd diwethaf: Tuesday, 8 May 2012, 4:16 PM