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:
, 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller hasanqadri12003. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.69. You're not tied to anything after your purchase.