BTEC Level 2 Unit 2 Data and Spreadsheet Modelling Assignment Brief 2026

BTEC Level 2 Unit 2 Assignment Brief 

Unit in Brief

Learners will investigate the characteristics of data and information and how information can help organisations in decision making. They will use data manipulation methods to create a dashboard to present and draw conclusions from information.

Unit Introduction

To make decisions, organisations collect vast amounts of data from a range of different sources. Organisations need to use appropriate data-collection methods to ensure that the data is of sufficient quality to enable decision making. Data must then be converted into information to become useful.

Learners will explore the different data manipulation methods that can be used to change the way that data is presented. Learners will provide summaries of given  data and present them in a dashboard that will allow organisations to make effective decisions. It is up to the data user to look at the information and draw conclusions,  so how the information is presented is key to ensuring that effective and accurate decisions are made.

In this unit, learners will study the different presentation features that can be used  to ensure that information is understood clearly in an objective way so that it is not misinterpreted.

Assessment

This unit has a Pearson Set Assignment. Learners must complete a Pearson Set Assignment Brief.

Learning aims

In this unit you will:

• Understand the role of data and information in organisations
• Create a dashboard using data manipulation methods
• Review the effectiveness of the dashboard to provide information.

Summary of unit

Learning aim A: Understand the role of data and information in organisations

A1 Processing information

Identification and the characteristics of data, and how its processed into information.

• Characteristics of raw data: no meaning, structure or context, unprocessed.
• Data preparation processes, e.g. data cleansing, data redundancy, normalisation.
• Characteristics of information including meaning, structure, context.

A2 Data sources and characteristics 

Characteristics of data from different sources, and their usefulness for providing information.

• Sources of data and how they can be used to provide information:

o social media, e.g. user preferences, demographics o shop loyalty schemes, e.g. customer shopping habits o ATM/cash machines, e.g. customer services o census, sensors, e.g. economic and social o search engine data, e.g. customer shopping habits o mobile phone networks, e.g. usage.

• Data characteristics and reliability considerations: o data collection including primary, secondary data o size and completeness of data sets

o data consistency such as ways in which data is recorded,

e.g. date format, number format, currency.

A3 Quality of data and its impact on decision making

Factors that affect the quality of data and the data modelling and the impact on  decision making.

• Quality of data:
  • source and data collection method o completeness of the data o data accuracy o age of the data.
• Data modelling and its impact on decision making:
  • advertising/marketing, e.g. improved marketing targeting and sales o customer engagement/services, e.g. improved customer services  o performance and operations, e.g. improved productivity and sales o financial management, e.g. strategic management o predictive analytics, e.g. selling stocks and shares o demographic analysis, e.g. marketing campaign.

Learning aim B: Create a dashboard using data manipulation methods

B1 Data processing methods 

Applying data processing methods for different purposes.

• Reasons for processing data, e.g. decision making in relation to business processes, customer services, sales-forecasting.
• Presenting data:
  • data types, e.g. text, currency
  • formatting cells, e.g. colours, alignment, borders o other formatting, e.g. text wrap, merge o charts, e.g. column, line, pie, area, scatter, sunburst, pivot tables.
• Data manipulation methods: o importing data o formulae, e.g. =A2+B2
  • functions, e.g. =SUM( A2:A33), =AVERAGE(A2:A33), =MAX(A2:A33)
  • decision-making functions, e.g. if, whatif, sumif o lookup functions, e.g. vlookup, hlookup, match, index o count functions, e.g. countblank, countif o logical operators, e.g. not, and, or o sort, e.g. multiple columns and values o filter, e.g. greater than, equals.
• Other data processing methods:
  • absolute and relative cell referencing
  • macros o data validation
  • worksheets, e.g. linking worksheets o alternative views, e.g. hiding and unhiding cells, freezing and split planes o conditional formatting, e.g. colour-based formatting.

B2 Producing a dashboard

Methods for presenting information in a dashboard.

• Show data summaries from the data set:
  • totals o count o percentage
  • breakdown, e.g. finance, sales, budget o performance, e.g. social media, customer retention rate o allocations, e.g. time, budget.
• Presentation methods: o tables
  • graphs or charts, e.g. dynamic charts or graphs o pivot tables or charts o sparklines o radio buttons o

• Presentation features:
  • font size, style and colour o cell borders and shading o graphics/animation o titles, overall and section titles o labelling and data formatting.

Learning aim C: Review the effectiveness of the dashboard to provide information

Effectiveness of the dashboard to enable users to draw conclusions.

C1 Drawing conclusions

• Characteristics of different types of information:

o trends o patterns o anomalies.

C2 Review dashboard and presentation methods

Effectiveness of data manipulation methods to enable decision making.

• Dashboard information: o information is not misinterpreted o information is not biased o inaccurate conclusions are not made.
• Presentation methods: o form controls, e.g. dropdown menus, spinners o tables

o graphs or charts, e.g. dynamic charts or graphs o pivot tables or charts o sparklines o radio buttons o checkboxes o conditional formatting o allocations, e.g. time, budget.

Assessment Criteria

 Essential information for assignments

This unit is assessed using a Pearson Set Assignment Brief. A set assignment must be used to assess learners.

Further information for teachers and assessors

Resource requirements

For this unit, learners must have access to:

• a wide range of research resources, largely text and internet based. There are many free-to-use data sets available
• industry standard software, such as spreadsheets, and access to sufficient secure storage space to complete the analysis.

Essential information for assessment decisions

Learning aim A: 

For Level 2 Distinction, learners must examine data collection methods used and draw balanced, reasoned conclusions as to the impact on decision-making, using a wide range of relevant examples and demonstrating a sound understanding of the link between the data collection methods and the quality of data.

For Level 2 Merit, learners must examine data collection methods used by organisations and their effect on decision-making, providing some relevant examples  and demonstrating an understanding of the link between the data collection methods and quality of data.

For Level 2 Pass, learners must examine data collection methods used by organisations and the ways they are used to aid decision-making, using examples to illustrate their views. They will show some links between the data collection methods and their usefulness to aid decision-making.

Learning aim B

For Level 2 Distinction, learners must select and use effective and relevant methods  to accurately manipulate a range of data to provide a clear and accurate summary of data on the dashboard. Methods used should include complex formulas, functions and automated features, e.g. decision-making functions, lookup functions, count functions. The dashboard should contain a wide range of clear and accurate summaries of their manipulated data. These could include charts or graphics, tables, pivot tables and/or sparklines.

For Level 2 Merit, learners must select and use a range of relevant methods to manipulate the data. This includes the use of some advanced formulas and functions and automated features, e.g. buttons/macros, dropdown menus to show a different aspect of the data. Learners must provide clear summaries of data on the dashboard using a range of presentation methods, e.g. different charts/graphs, tables, pivot tables. These must be used appropriately in most places to communicate effective information. For Level 2 Pass, learners must select and use a range of basic data manipulation methods, such as Sum and Average, and include some advanced functions, such as lookup functions. The dashboard must have summaries of their manipulated data  that incorporates mostly appropriate presentation methods, including different charts/graphs and tables. Some presentation methods used must be appropriate  for the data being shown and make use of suitable presentation features on their dashboard in most places.

Learning aim C

Learners review the dashboard and its capacity to show appropriate information to enable decision-making.

For Level 2 Distinction, learners must judge the capacity of the dashboard to present information that enables a range of specific, relevant, and clear conclusions to be drawn, such as trends, patterns and possible anomalies.

Learners must make reasoned judgements as to the effectiveness of the dashboard  to enable accurate conclusions to be drawn. Their evaluation should consider how information was presented, and the methods and features used to ensure the information was not biased, or likely to be misunderstood.

For Level 2 Merit, learners must examine the capacity of the dashboard to draw specific and relevant conclusions. This must include some trends or patterns. Learners must show an understanding of the effectiveness of the presentation features they have used  to ensure the information on the dashboard was not biased or misunderstood.

For Level 2 Pass, learners must examine the capacity of the dashboard to enable  simple, mostly accurate conclusions to be drawn. These must include trends  and patterns.

Learners must indicate the presentation methods used, and show how they lead to these conclusions being made.

Assessment Controls

Time: this assignment has a recommended time-period. This is for advice only and can be adjusted depending on the needs of learners.

Supervision: you should be confident of the authenticity of learners’ work. This may mean that learners should be supervised.

Resources: all learners should have access to the same types of resource to complete the assignment.

Research: learners should be given the opportunity to carry out research outside of the learning context if required for the assignment.

Links to other units and curriculum subjects

This unit links to:

• Unit 1: Using IT to Support Information and Communication in Organisations
• Unit 10: Introduction to Database Systems
• International GCSE/core curriculum in Information Technology.

Employer involvement

This unit would benefit from employer involvement in the form of:

• guest speakers and interview opportunities
• work experience
• dashboard exemplars
• visits to appropriate business organisations.

Opportunities to develop transferable employability skills

In completing this unit, learners will have the opportunity to develop skills in research and planning, problem-solving, innovation, and self-direction.

The post BTEC Level 2 Unit 2 Data and Spreadsheet Modelling Assignment Brief 2026 appeared first on BTEC Assignment UK.