100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Summary unit 42 $9.97   Add to cart

Summary

Summary unit 42

 6 views  0 purchase
  • Course
  • Institution

Summary of 16 pages for the course Unit 42 - Spreadsheet Modelling at PEARSON (unit 42)

Preview 3 out of 16  pages

  • September 22, 2022
  • 16
  • 2022/2023
  • Summary
avatar-seller
Learner name Assessor Name

Muhammad Hasan Qadri Shehreen Khan

Date issued Hand in deadline Submitted on

13/01/2020 24/01/2020

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 feedback and declaration
Grading Achieved?
Assessor Feedback
criteria Yes/No
P9

M4

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:

,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

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

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

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.97. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

83662 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$9.97
  • (0)
  Add to cart