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