Spreadsheet Modelling Assignment 2015
Learner’s Comments ( What went well, What could you improve)
Assessor’s name:
Assessor’s signature:
Date:
Learner’s Declaration:
I declare that this assignment is my individual work. I have not worked collaboratively nor have I copied from any other student’s work or from any other source except where due acknowledgment is made explicitly in the text, nor has any part been written for me by another person.
Signed: ........................................................................................... Date: ................................
Learning Outcome Ref
Learning Outcome
Criteria reference
To achieve the criteria the evidence must show that the student is able to:
Met Yes or No
Student Evidence
(Page Nos)
Feedback (dated)
LO1
Understand how spreadsheets can be used to solve complex problems
P1
Explain how spreadsheets can be used to solve complex problems
D1
Discuss how organisations can use interpretation methods to analyse data
LO2
Be able to develop complex spreadsheet models
P2
Develop a complex spreadsheet model to meet particular needs [IE1]
P3
Use formulae, features and functions to process information
M1
Refine a complex spreadsheet model by changing rules and values
L03
Be able to automate and customise spreadsheet models
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
M2
Analyse and interpret data
M3
Compare different automation methods
Learning Outcome Ref
Learning Outcome
Criteria reference
To achieve the criteria the evidence must show that the student is able to:
Met Yes or No
Student Evidence
(Page Nos)
Feedback
LO4
Be able to test and document spreadsheet models.
P7
Test a spreadsheet model to ensure that it is fit for purpose
P8
Export the contents of the spreadsheet model to an
Assessor’s name:
Assessor’s signature:
Date:
Learner’s Declaration:
I declare that this assignment is my individual work. I have not worked collaboratively nor have I copied from any other student’s work or from any other source except where due acknowledgment is made explicitly in the text, nor has any part been written for me by another person.
Signed: ........................................................................................... Date: ................................
Learning Outcome Ref
Learning Outcome
Criteria reference
To achieve the criteria the evidence must show that the student is able to:
Met Yes or No
Student Evidence
(Page Nos)
Feedback (dated)
LO1
Understand how spreadsheets can be used to solve complex problems
P1
Explain how spreadsheets can be used to solve complex problems
D1
Discuss how organisations can use interpretation methods to analyse data
LO2
Be able to develop complex spreadsheet models
P2
Develop a complex spreadsheet model to meet particular needs [IE1]
P3
Use formulae, features and functions to process information
M1
Refine a complex spreadsheet model by changing rules and values
L03
Be able to automate and customise spreadsheet models
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
M2
Analyse and interpret data
M3
Compare different automation methods
Learning Outcome Ref
Learning Outcome
Criteria reference
To achieve the criteria the evidence must show that the student is able to:
Met Yes or No
Student Evidence
(Page Nos)
Feedback
LO4
Be able to test and document spreadsheet models.
P7
Test a spreadsheet model to ensure that it is fit for purpose
P8
Export the contents of the spreadsheet model to an