# 139187 Level 3 Unit 19 Spreadsheet Mode

Powerful Essays
3515 Words
Grammar
Plagiarism
Writing
Score
139187 Level 3 Unit 19 Spreadsheet Mode
Cambridge
TECHNICALS

OCR LEVEL 3
CAMBRIDGE TECHNICAL
CERTIFICATE/DIPLOMA IN

IT
Y/601/6637
LEVEL 3 UNIT 19
GUIDED LEARNING HOURS: 60
UNIT CREDIT VALUE: 10

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

## You May Also Find These Documents Helpful

• Satisfactory Essays

There are seven forms of business: sole proprietorship, partnership, limited liability partnership, limited liability company (including the single member LLC), S Corporation, Franchise, and Corporation.…

• 130 Words
• 5 Pages
Satisfactory Essays
• Good Essays

Cable toner: A device for determining if the fundamental cable installation has been done properly.…

• 440 Words
• 2 Pages
Good Essays
• Good Essays

Zone three shows locked safety doors at the foot of the stairs in the main hallway. This is where the infant pupils are brought to school. These doors are staffed at the beginning of the school day when pupils arrive. No parents are allowed beyond this point. When all…

• 948 Words
• 4 Pages
Good Essays
• Good Essays

* Went into Tesco in Coulby Newham asked if they had any jobs was told they didn’t but to hand in a CV so I did.…

• 2713 Words
• 11 Pages
Good Essays
• Good Essays

In this assignment I will be describing the different types of specialist tourism as well as providing examples for each of the types of tourism.…

• 2206 Words
• 7 Pages
Good Essays
• Better Essays

Sam and Sonia would like you to produce a spreadsheet model that would empower them to reserve product details and prices and when new products become available they can simply add them onto the list. They would also like the spreadsheet model to store customer details and enables them to form and print invoices for placed orders.…

• 2504 Words
• 8 Pages
Better Essays
• Satisfactory Essays

Ethnocentrism the use of one’s own culture as a yardstick for judging the ways of other individuals or societies, generally leading to a negative evaluation of their values, norms, and behaviors…

• 442 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

George is a 14 year old boy who attends secondary school. He is extremely overweight and obesity among children can disrupt their physical development and have an impact on their social and emotional wellbeing. The fact that George is overweight may mean that he struggles when doing sports activities at school, which could result in him being teased by his classmates, leaving him embarrassed and self-conscious. Also getting changed on front of his peers may embarrass him which could result in him not wanting to take part in PE, affecting his health even more. George may then prefer to stay at home instead of going to school and being ridiculed, resulting in absences and then falling behind at school. Obesity can also affect the onset of puberty especially in boys as hormones get affected and slow down the male development. This again could lead to teasing and bullying, result in low self-esteem and even depression.…

• 570 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

|3 |Teaching |To be an efficient teacher, you must be able to understand now only what the students know, but what they need to learn. A successful teacher must be able to challenge |…

• 658 Words
• 3 Pages
Satisfactory Essays
• Good Essays

Welsh language is all about introducing basic welsh to the children, this may include short phrases, colours and numbers.…

• 967 Words
• 4 Pages
Good Essays
• Powerful Essays

1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured…

• 1737 Words
• 7 Pages
Powerful Essays
• Better Essays

Outcome 4 Understand the importance of early intervention to support the speech, language and communication needs of children and young people.…

• 1654 Words
• 7 Pages
Better Essays
• Powerful Essays

1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured…

• 2272 Words
• 11 Pages
Powerful Essays
• Good Essays

The reason we have resources for learning is to enhance the whole process for all learners and make it an enjoyable and effective experience. Also by having multiple resources this will benefit a variety of different learners as not everyone will prefer powerpoint for example. Sometimes the use of resources will change the attitude I receive as a instructor. Im fully aware that not all learners are going to feel in the right mind set to learn if their either too tired or maybe having trouble concentrating or absorbing information. I have personally experienced this many times during my time in the Army as we are often subjected to frequent shows of…

• 2330 Words
• 10 Pages
Good Essays
• Satisfactory Essays

Took assigned youth out to certain environments away from the family to aid in the progression towards self-assessment and betterment of attitude.…

• 397 Words
• 2 Pages
Satisfactory Essays