AO1 Develop a spreadsheet to meet the needs of an organisation

 Pass Merit Distinction Candidates will state user requirements. They will create a functional spreadsheet that mostly meets the requirements of the user. The spreadsheet will include formulas using at least two of +, -, * and /. Functions from at least two different categories (see below) will be used. Relative or absolute cell referencing will be used. The spreadsheet may contain only one sheet. Candidates will state user requirements. They will create a functional spreadsheet that meets the requirements of the user. The spreadsheet will include formulas using all of +, -, * and /. Functions from at least three different categories will be used. This will include the use of one IF statement. Relative or absolute cell referencing will be used. Most choices will be appropriate. The spreadsheet will contain more than one sheet, linked by formulas. Candidates will state user requirements. They will create a functional spreadsheet that meets the requirements of the user. The spreadsheet will include formulas using all of +, -, * , / and brackets. Functions from at least four different categories will be used. This will include the use of one IF statement. Relative and absolute cell referencing will be used. All choices will be appropriate. The spreadsheet will contain more than sheet, linked by formulas.

functions eg:

b. mathematical/trigonometric functions, eg SIN, COS, TAN, LOG, POWER, RND

c. rounding functions, such as INTEGER, ROUNDUP and  ROUNDDOWN, TRUNC

d. logical functions, such as IF, AND, OR and NOT, including nested IF statements

e. lookup functions, such as VLOOKUP, HLOOKUP, MATCH

f. reference functions, such as ROW, COLUMN

g. text functions, such as LEFT, MID, RIGHT, LEN, VALUE, TEXT, CONCATENATE, FIND

h. date and time functions, such as TODAY, NOW, YEAR, MONTH, DAY

a.   arithmetic and statistical functions such as SUM, AVERAGE, MAX, MIN, MEDIAN, MODE, COUNT, COUNTIF
Diweddarwyd diwethaf: Tuesday, 8 May 2012, 4:16 PM