Assignment front sheet
Criteria To achieve the criteria the evidence must show that Page
Task no. Evidence
reference the student is able to: no
P5 Customise the spreadsheet model to meet a given requirement Task 2 customisation
Word document
P6 Use automated features in the spreadsheet model to meet a given Task 4 automation
requirement Word document
P7 Test a spreadsheet model to ensure it is fit for purpose Task 5
test plan
P8 Export the contents of the spreadsheet model to an alternative format Task 1 exported data -
alternative
format
M3 Compare different automation methods Task 3
Word document
D2 Evaluate a spreadsheet model incorporating feedback from others and Task 6 Evaluation Word
make recommendations for improvements document
Learner name Assessor Name
Muhammad Hasan Qadri Shehreen Khan
Date issued Hand in deadline Submitted on
05/11/2019 19/11/2019
Resubmission (out) (if
Resubmission (in) Lead IV authorisation
applicable)
Qualification Unit number and title
Level 3 BTEC National Subsidiary Diploma in IT Unit 42 – Spreadsheet Modelling
Assignment title 42.2 Fit Floppies – structure and use /customising and automation
In this assessment you will have opportunities to provide evidence against the following criteria.
Learner feedback and declaration
Learner feedback
Learner declaration
I certify that the work submitted for this assignment is my own and research sources are fully acknowledged
OR by submitting on Turnitin you agree to the above statement.
Learner signature: Date:
, Muhammad Hasan Qadri
J58828
Assignment 42.2
Contents
.....................................................................................................7
.....................................................................................................7
.....................................................................................................7
...................................................................................................10
...................................................................................................10
, VLOOKUP: VLOOKUP is the formula fir floppies used so that when the order number
changes the size, colour, gender and price would also change matching the order
number. This is use full for fit floppies as they do not have to look at the data
analysis page which has all the order numbers on they can look at individual orders
at a time. To set up the VLOOKUP formula you have to:...............................12
...................................................................................................12
...................................................................................................12
...................................................................................................12
...................................................................................................12
...................................................................................................12
...................................................................................................12
...................................................................................................13
Criteria To achieve the criteria the evidence must show that Page
Task no. Evidence
reference the student is able to: no
P5 Customise the spreadsheet model to meet a given requirement Task 2 customisation
Word document
P6 Use automated features in the spreadsheet model to meet a given Task 4 automation
requirement Word document
P7 Test a spreadsheet model to ensure it is fit for purpose Task 5
test plan
P8 Export the contents of the spreadsheet model to an alternative format Task 1 exported data -
alternative
format
M3 Compare different automation methods Task 3
Word document
D2 Evaluate a spreadsheet model incorporating feedback from others and Task 6 Evaluation Word
make recommendations for improvements document
Learner name Assessor Name
Muhammad Hasan Qadri Shehreen Khan
Date issued Hand in deadline Submitted on
05/11/2019 19/11/2019
Resubmission (out) (if
Resubmission (in) Lead IV authorisation
applicable)
Qualification Unit number and title
Level 3 BTEC National Subsidiary Diploma in IT Unit 42 – Spreadsheet Modelling
Assignment title 42.2 Fit Floppies – structure and use /customising and automation
In this assessment you will have opportunities to provide evidence against the following criteria.
Learner feedback and declaration
Learner feedback
Learner declaration
I certify that the work submitted for this assignment is my own and research sources are fully acknowledged
OR by submitting on Turnitin you agree to the above statement.
Learner signature: Date:
, Muhammad Hasan Qadri
J58828
Assignment 42.2
Contents
.....................................................................................................7
.....................................................................................................7
.....................................................................................................7
...................................................................................................10
...................................................................................................10
, VLOOKUP: VLOOKUP is the formula fir floppies used so that when the order number
changes the size, colour, gender and price would also change matching the order
number. This is use full for fit floppies as they do not have to look at the data
analysis page which has all the order numbers on they can look at individual orders
at a time. To set up the VLOOKUP formula you have to:...............................12
...................................................................................................12
...................................................................................................12
...................................................................................................12
...................................................................................................12
...................................................................................................12
...................................................................................................12
...................................................................................................13
