Resubmission (out) (if applicable) Resubmission (in) Lead IV authorisation
Qualification Unit number and title
Level 3 BTEC National Subsidiary Diploma in IT Unit 42 – Spreadsheet Modelling
Assignment title 42.3 Fit Floppies – user/technical documentation
In this assessment you will have opportunities to provide evidence against the following criteria.
Criteria To achieve the criteria the evidence must show that Page
Task no. Evidence
reference the student is able to: no
P9 Produce user documentation for a spreadsheet model Task 1 Word
document –
pg
user guide
M4 Produce technical documentation for a spreadsheet model Task 2 Word
document
with
technical pg
language and
guidance
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:
,P9- Produce user documentation for a spreadsheet model
Locating the workbook and opening it
To open the fit floppies workbook you will have
turn to your desktop and open the “file” app
Once you have opened the “file” app you will
have to click onto the “OneDrive – Luton six
form” tab that is located on the left side of the
screen.
Once you have clicked the “OneDrive – Luton
six form” tab you will then need to double click
the fille that is called “IT level 3”
Once you have opened the “IT level 3” folder
you will see four more folders you should
double click the file named “Unit 42”
Once you have opened the “Unit 42” file you
will see the work book it is named “fit floppies
spread sheet”.
Once you have found it you should doble click it
to open it.
The menu work sheet
On the menu page you will find button at the top that automatically take you to the named page.
This was set up with formulars to create a quick process to change pages.
, in the screen shot above I was floating the arrow on the “data analysis” page to display the formular.
The formular is shown on the right side the rest of the information shows were the spread sheet is
located.
Once you click the button you will automatically switch to the page you have selected
As you can see I
switched pages by clicking the button. I went from the “menu” page to the “data analysis” page.
as you can see I have now switched back to the menu page.
Creating a Pivot table
a pivot table is used to display data to create a pivot table you have to firstly open the Microsoft
excel and click the “insert” tab at the top of the page.
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.67. You're not tied to anything after your purchase.