Criteria

P1 explain how spreadsheets can be used to solve complex problems

P2 develop a complex spreadsheet model to meet particular needs

P3 use formulae, features and functions to process information

P4 use appropriate tools to present data

P5 customise the spreadsheet model to meet a given requirement

P6 use automated features in the spreadsheet model to meet a given requirement

P7 test a spreadsheet model to ensure that it is fit for purpose

P8 export the contents of the spreadsheet model to an alternative format

P9 produce user documentation for a spreadsheet model.

M1 refine a complex spreadsheet model by changing rules and values

M2 analyse and interpret data from a spreadsheet model

M3 compare different automation methods

M4 produce technical documentation for a spreadsheet model.

D1 discuss how organisations can use interpretation methods to analyse data

D2 evaluate a spreadsheet model incorporating feedback from others and make recommendations for improvements.

No comments: