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