Unit 42 Spreadsheet Modelling (P2,P3,P4,P5,P6,P7,P7,P8,P9,M1,M2,M3,M4 and D1
439 views 1 purchase
Module
Unit 42: Spreadsheet Modelling
Institution
Modern College Of Business And Science
All my work received distinctions overall in this unit. Please feel free to email me for documentation. Feel free to use my work as guide to complete your own Unit 42 Spreadsheet Modelling (P2,P3,P4,P5,P6,P7,P7,P8,P9,M1,M2,M3,M4 and D1. Listed at the lowest possible price to give you a grade that ...
p2 develop a complex spreadsheet model to meet particular needs
features and functions to process informat
Written for
Modern college of Business and science
Unit 42: Spreadsheet Modelling
All documents for this subject (2)
Seller
Follow
Badaralsalmy
Reviews received
Content preview
DEVELOP A COMPLEX SPREAD SHEET MODEL TO MEET
PARTICULAR NEEDS (P2).
In this task, I will be developing that will be used to track BTEC student’s
enrolment and grades. I should develop complex spread sheet model that meets
user requirements.
Requirements.
Spread should include above requirements to meets users needs like Students names, students id
Courses , Grades they scored, multiple worksheets (with links), complex formulae e.g. at least two-step
process; large data sets cells linkage data entry forms e.g. menu systems, list boxes, drop-down boxes,
event controls; data validation error trapping lookup tables nested IF functions cell protection.
,The following are the requirements which I have included in developing complex spreadsheet:
Complexity in spreadsheet model can arise when there is combination of factors likemultiple pages,
complex formula, larger data sets and cell linkage between two sheet in excel. In order to make it
simple to the user, We need to make complex spreadsheet model which includes data entry forms, data
validation, nested if statements, error trapping and other which improves the quality of spreadsheet.
Multiple worksheets.
Instead of having single worksheet, you may design spreadsheet model which includes several separates
worksheets since there are number of benefits of linked worksheets.
You can simplify the development of large complex models by breaking down them in to series
of differents dependant work sheets. This will helps a lot since smaller worksheets are easier to
change, they don’t require too much memory and they are easier to open and close.
You can enter all data into one or more worksheets and then create differents views. For
example by creating reports which have links to relevant information
For example, in the spread sheet model, I created multiple work sheets to differentiate information of
students from each subject or unit. This helps easily the user to get releavant information which is
searching for. I created worksheets for each units like worksheets of computer system unit, information
system, database design, computer networks and IT support, this helps user easily to find information
for specifics subjects.
Worksheets for
different courses
,Complex formulae.
These are equations which perform calculations on values in excel sheet. For
example, the complex formular which I use is as follows;
The complex formular which I use above is for calculating the grade of each
student in a subject. It returns Distinctions if the student pass all the task in a unit.
It returns “merit” if student achieve all pass grade and merits grade on tasks. Also
returns “Pass” if the student achieve only Pass tasks and it returns “unclassified”
If the student didn’t even achieve pass grade in tasks. Generally, complex
formular helps easily to perform calculations in excel.
Large data sets.
Large data sets might involve using large number of excel sheets. With large data
sets user will need help in interpreting this data. In large data sets, by
summarizing the data for example by using pivot tables, this will helps user to see
data more clearly. For example, as you can see above, I have created large data
sets in my spread sheet model.
, Cell linkage.
Cell linkage is useful when when data of single spreadsheet model is kept in
various excel sheets, it is necessary that a formular in one excel sheet will require
data from cell or range of a cell in another worksheet. That’s why there is a facility
to links cell between worksheet which enable to create a complex formulae. By
linking cells between excel sheets, changes in one worksheet can have effects on
data in releavant cell cell which is linked to.
For example, In spreadsheet model which I have created, I did cell linkage
between each course sheets to consolidate grading sheet. This helps once data
such as grade changed on course sheet, also changes also will made on linked cell
in another sheet.
Cell linkage.
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 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 Badaralsalmy. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £18.86. You're not tied to anything after your purchase.
