Cambridge TECHNICALS LEVEL 2 IT - ocr.org.uk

1 U n i t 17 Using data analysis software L /615/138 6 Guided learning hours: 60 Version 1 September 20162016 SuiteCambridge TECHNICALS LEVEL OCR 2016 2 unit 17: Using data analysis software LEVEL 2 unit 17: Using data analysis software L/615/1386 Guided learning hours: 60 Essential resources required for this unit : Any software supporting data analysis. This unit is internally assessed and externally moderated by OCR. unit AIM Everyone and every business uses data. Whether it is the brain calculating the speed of a car, a business forecasting sales or a manufacturer identifying colours for new products based on historical customer preferences. The data used must be grouped, sorted, validated and processed to make it understandable and useful. Software is used to analyse this data and provide businesses with the ability to carry out the necessary actions to convert it into business information.

2 This unit will enable you to understand the difference between data and information and the quality of the data, which data needs to be analysed for a given business need and how to carry out the analysis and present the findings and recommend the use of your analysis model for future analyses and decision making. This unit is optional in the Award in Digital Business and is mandatory in the Certificate in IT. It is also a mandatory unit in the Digital Business Practitioner pathway in the Diploma. OCR 2016 3 unit 17: Using data analysis software TEACHING CONTENT The teaching content in every unit states what has to be taught to ensure that learners are able to access the highest grades. Anything which follows an details what must be taught as part of that area of content. Anything which follows an is illustrative, it should be noted that where is used, learners must know and be able to apply relevant examples in their work, although these do not need to be the same ones specified in the unit content.

3 For internally assessed units you need to ensure that any assignments you create, or any modifications you make to an assignment, do not expect the learner to do more than they have been taught, but must enable them to access the full range of grades as described in the grading criteria. Learning outcomes Teaching content The Learner will: Learners must be taught: 1. Understand the data used by business Types of data stored, : text characters images numbers lack of formal organisation Sources of data, : internal ( financial reports, market analysis) external ( government, suppliers, trade bodies) Purpose of data, : operational support ( monitoring and controlling activity) analysis ( to identify patterns or trends) decision making ( operational, tactical, strategic) marketing and sales communication Characteristics of data, : reliability validity relevance time frame accessible quality cost-effective appropriate.

4 The impacts of poor data on business, : monetary costs, : o time o poor decision making ( reduced profits, loss of sales, etc.) o excessive costs ( selecting expensive raw materials, systems, delivery methods) reputation, : o poor quality of service to clients o loss of client confidence or respect o loss of markets OCR 2016 4 unit 17: Using data analysis software Learning outcomes Teaching content The Learner will: Learners must be taught: 2. Be able to select software to analyse data for business purposes Types of software used to analyse quantitative data : spreadsheets databases specialist software ( SPSS, Minitab, QDA Miner, Solver) Business uses for data analysis, : business intelligence ( efficiency of business processes, decision making) cost management forecasting staffing market share sales time management customer satisfaction Features within software, : spreadsheet ( mean, median, range, forms, reports, queries, external data, financial, functions, formulae) database ( queries, reports, relational tables) specialist software (forecasting, visualisations) Functions.

5 Range of presentation styles such as graphs, charts, tables, reports data analysis such as pivot tables and scenarios data organisations such as sorting, querying and filtering other business forecasting facilities 3. Be able to use software to analyse data for business purposes Considerations for data selection, : purpose to business extent of data (subsets) source of data characteristics required for sourced data justification. Use an appropriate range of features for proposed software, (tables, queries, forms, reports, linked data, charts, graphs, formulae, functions, etc.). Documentation formats, : charts graphs tables reports video 4. Be able to present the results of data analysis to the client Methods of presentation, : written report graphs and charts presentation forecasts.

6 Using an analysis model,( support decision making.) OCR 2016 5 unit 17: Using data analysis software GRADING CRITERIA LO Pass Merit Distinction The assessment criteria are the Pass requirements for this unit . To achieve a Merit the evidence must show that, in addition to the Pass criteria, the candidate is able to: To achieve a Distinction the evidence must show that, in addition to the pass and merit criteria, the candidate is able to: 1. Understand the data used by business P1: Outline types and sources of data used by business P2: Describe the characteristics of data M1: Explain how poor data can impact on a business 2. Be able to select software to analyse data for business purposes P3: Select software to analyse data for a specified business need M2: Review the features and functions of the selected software 3.

7 Be able to use software to analyse data for business purposes P4: Select data for analysis for a specified business need D1: Justify the choice of selected data for a specified business need P5: Analyse the selected data for a specified business need M3: Document the outcomes of data analysis 4. Be able to present the results of data analysis to the client P6: Present the outcomes of data analysis to the business. D2: Recommend use of the analysis model to support future business decision making OCR 2016 6 unit 17: Using data analysis software SYNOPTIC ASSESSMENT AND LINKS BETWEEN UNITS When learners are taking an assessment task, or series of tasks, for this unit they will have opportunities to draw on relevant, appropriate knowledge, understanding and skills that they will have developed through other units. See section 6 of the Centre Handbook for more information on synoptic assessment.

8 This unit and specific LO Name of other unit and related LO LO1: Understand the data used by business unit 1: Essentials of IT LO5: Know about the benefits of using IT in business unit 2: Essentials of cyber security LO1: Know about aspects of cyber security LO2: Understand the threats and vulnerabilities they can make LO3: Understand how organisations/individuals can minimise impacts from cyber security incidents unit 5: Creating business solutions LO2: Be able to designs solutions to meet business needs LO3: Be able to present business solutions to stakeholders unit 6: Participating in a project LO2: Be able to contribute to a project unit 8: Using emerging technologies LO1: Know about the technologies currently emerging LO2: Be able to explore how emerging technologies can support business needs unit 16: Using social media channels for business LO1: Know the social media channels used in business LO2: Be able to select social media channels to meet business needs unit 18: Creating visual business products LO1: Know about creating visual products for business LO2: Be able to select software to analyse data for business needs unit 1: Essentials of IT LO2: Know about software components LO5: Know about the benefits of using IT in business unit 2: Essentials of cyber security LO1: Know about aspects of cyber security LO2: Understand the threats and vulnerabilities they can make LO3: Understand how organisations/individuals can minimise impacts from cyber security incidents unit 5: Creating business solutions LO2: Be able to designs solutions to meet business needs LO3: Be able to present business solutions to stakeholders LO4.

9 Be able to use IT applications to meet business needs OCR 2016 7 unit 17: Using data analysis software This unit and specific LO Name of other unit and related LO unit 6: Participating in a project LO2: Be able to contribute to a project unit 16: Using social media channels for business LO2: Be able to select social media channels to meet business needs unit 18: Creating visual business products LO1: Know about creating visual products for business LO2: Be able to select software and hardware for creating visual products for business needs LO3: Be able to use software to analyse data for business needs unit 1: Essentials of IT LO5: Know about the benefits of using IT in business unit 2: Essentials of cyber security LO1: Know about aspects of cyber security LO2: Understand the threats and vulnerabilities they can make LO3: Understand how organisations/individuals can minimise impacts from cyber security incidents unit 5: Creating business solutions LO2: Be able to designs solutions to meet business needs LO3: Be able to present business solutions to stakeholders LO4: Be able to use IT applications to meet business needs unit 6: Participating in a project LO2: Be able to contribute to a project unit 7: Pitching the product LO2: Be able to pitch a product to internal stakeholders unit 18: Creating visual business products LO3: Be able to create visual products to meet a business need LO4: Be able to improve visual products to meet a business need LO4: Be able to present the results of data analysis to the client unit 1: Essentials of IT LO5: Know about the benefits of using IT in business unit 2: Essentials of cyber security LO1.

10 Know about aspects of cyber security LO2: Understand the threats and vulnerabilities they can make LO3: Understand how organisations/individuals can minimise impacts from cyber security incidents unit 5: Creating business solutions LO2: Be able to designs solutions to meet business needs LO3: Be able to present business solutions to stakeholders LO4: Be able to use IT applications to meet business needs unit 6: Participating in a project OCR 2016 8 unit 17: Using data analysis software This unit and specific LO Name of other unit and related LO LO2: Be able to contribute to a project unit 7: Pitching the product LO2: Be able to pitch a product to internal stakeholders unit 18: Creating visual business products LO3: Be able to create visual products to meet a business need LO4: Be able to improve visual products to meet a business need ASSESSMENT GUIDANCE LO1 Understand the data used by business P1: The learner should outline the sources and types of data used by business and the formats this may take.