Unit 42 Spreadsheet Modelling
PEARSON (PEARSON)
Here are the best resources to pass Unit 42 Spreadsheet Modelling. Find Unit 42 Spreadsheet Modelling study guides, notes, assignments, and much more.
23 results
Essay
Unit 42 - Assignment 1 - P1, D1
Unit 42 Spreadsheet Modelling - Assignment 1. All criteria achieved, P1 and D1. Using Spreadsheets to solve complex problems.
Essay
Unit 42: Spreadsheet Modelling Refining a spreadsheet model and presenting data P4; P8; M1; M2; M3
P4	Use appropriate tools to present data.
P8	Export the contents of the spreadsheet model to an alternative format.
M1	Refine a spreadsheet model by changing rules and values
M2	Analyse and interpret data from a spreadsheet model
M3	Compare different automation methods

Scenario
You work for a small hotel (The Kings Arms) who have recently expanded their premises to include a functions room. 
The management team like you to finish a prototype of the booking system in time for the next management...
Essay
Unit 42: Spreadsheet Modelling How can spreadsheets be used to solve complex problems P1,D1
P1 explain how spreadsheets can be used to solve complex problems.

D1 discuss how organisations can use interpretation methods to analyse data.

Scenario

Ridgeway is a large college offering a full range of academic courses, together with vocational courses such as plumbing, carpentry and so on. It also offers evening and weekend courses as part of its adult education programmes.
The administration team at Ridgeway want to use spreadsheet software to keep track of student enrolments and course...