139187 Level 3 Unit 19 Spreadsheet Mode
Cambridge
TECHNICALS
OCR LEVEL 3
CAMBRIDGE TECHNICAL
CERTIFICATE/DIPLOMA IN
IT
SPREADSHEET MODELLING
Y/601/6637
LEVEL 3 UNIT 19
GUIDED LEARNING HOURS: 60
UNIT CREDIT VALUE: 10
SPREADSHEET MODELLING
Y/601/6637
LEVEL 3 UNIT 19
AIM OF THE UNIT
The success of a business relies on its methods of recording business transactions. With the use of complex spreadsheets this task is made relatively easy for businesses. A business therefore requires employees to have knowledge of how to create a spreadsheet and how to use formulae and functions effectively. This unit will provide the learner with the skills to enable them to create and use a complex spreadsheet model. The aim of this unit is to help the learner understand how spreadsheets can be used to solve complex problems.
Learners will learn how to create a complex spreadsheet model and to use a range of formulae and functions.
Learners will also learn how to automate and customise their spreadsheet models. Finally learners will learn how to test and create user and technical documentation.
www.ocr.org.uk
2
Spreadsheet Modelling Level 3 Unit 19
ASSESSMENT AND GRADING CRITERIA
Learning Outcome (LO)
Pass
Merit
1 Understand how spreadsheets can be used to solve complex problems P1 explain how spreadsheets can be used to solve complex problems
2 Be able to develop complex spreadsheet models P2 develop a complex spreadsheet model to meet particular needs
M1 use formatting to enhance the complex spreadsheet model
P3 use formulae, features and functions to process information M2 use advanced formulaic functions to process information The assessment criteria are
To achieve a merit the the pass requirements for evidence must show that, this unit. in addition to the pass criteria, the learner is able to:
The learner will:
The learner can:
Distinction
To achieve a distinction the evidence must show that, in addition to the pass and merit criteria, the learner is able to:
P4 use
TECHNICALS
OCR LEVEL 3
CAMBRIDGE TECHNICAL
CERTIFICATE/DIPLOMA IN
IT
SPREADSHEET MODELLING
Y/601/6637
LEVEL 3 UNIT 19
GUIDED LEARNING HOURS: 60
UNIT CREDIT VALUE: 10
SPREADSHEET MODELLING
Y/601/6637
LEVEL 3 UNIT 19
AIM OF THE UNIT
The success of a business relies on its methods of recording business transactions. With the use of complex spreadsheets this task is made relatively easy for businesses. A business therefore requires employees to have knowledge of how to create a spreadsheet and how to use formulae and functions effectively. This unit will provide the learner with the skills to enable them to create and use a complex spreadsheet model. The aim of this unit is to help the learner understand how spreadsheets can be used to solve complex problems.
Learners will learn how to create a complex spreadsheet model and to use a range of formulae and functions.
Learners will also learn how to automate and customise their spreadsheet models. Finally learners will learn how to test and create user and technical documentation.
www.ocr.org.uk
2
Spreadsheet Modelling Level 3 Unit 19
ASSESSMENT AND GRADING CRITERIA
Learning Outcome (LO)
Pass
Merit
1 Understand how spreadsheets can be used to solve complex problems P1 explain how spreadsheets can be used to solve complex problems
2 Be able to develop complex spreadsheet models P2 develop a complex spreadsheet model to meet particular needs
M1 use formatting to enhance the complex spreadsheet model
P3 use formulae, features and functions to process information M2 use advanced formulaic functions to process information The assessment criteria are
To achieve a merit the the pass requirements for evidence must show that, this unit. in addition to the pass criteria, the learner is able to:
The learner will:
The learner can:
Distinction
To achieve a distinction the evidence must show that, in addition to the pass and merit criteria, the learner is able to:
P4 use