New to PG?
Start here
BusinessComputer ScienceDesign & TechnologyEnglishHumanitiesLanguagesMathematicsPEScienceClearReviseAbout
Back to All Units

BTEC L1-2 DIT

£120.00 + VAT Discounted rate from £96.00

+

2022 C2 Pack B Creating a dashboard

Component 2: Learning Aims B & C

B

Inside the Unit...

Download Free Sample 5.2mb

Areas Covered

  • Topic 1 Spreadsheet basics
  • Download sample lesson above
  • Topic 2 Data manipulation methods
  • Topic 3 Other processing methods
  • Topic 4 Producing a dashboard
  • Topic 5 Producing a dashboard using pivot tables
  • Topic 6 Conclusions and reviewing presentation methods
  • Assessment

There are 6 worksheets, 6 homework tasks, and an assessment test, each with answers included in this Series.

Component 2 - Pack B: Summary

New specification for teaching from September 2022

This pack covers all the teaching required for Component 2 Learning outcomes B and C.

The learning outcomes covered over six lessons. The first lesson covers spreadsheet basics which is useful to give students the foundations required later in later lessons. Data manipulation methods are covered in the second and third lessons, including the functions required in the new specification such as COUNTA. Lessons 4 and 5 give a comprehensive look at how a dashboard is produced covering all the methods given in the specification. Finally, lesson 6 shows students how to draw conclusions and consider how the presentation affects understanding.

The resources give students the knowledge and practical skills they need to be able to create a dashboard using data manipulation tools and to also be able to draw conclusions and review data presentation methods.

What's included in the toolkit?

Toolkit

The BTEC Teaching Series has been written to satisfy the specification for the practical Components 1 and 2, and the theoretical element Component 3 of the new Pearson BTEC Level 2 2022 specification. Each pack contains:

  • PowerPoint slides for each lesson
  • Detailed lesson plans
  • Learning objectives and outcomes
  • Worksheets and homework activities with answers
  • End-of-unit Assessment test with answers
  • Other material and links to online resources

What people say...

“
”

All the resources I have brought from you previously have been excellent and a great help in delivering my lessons for BTEC Level 2 and GCSE. 

Theresa Brown. Computer Science Teacher, Paget High School

“
”

We’ve invested in the PG Online resources for both KS3 and 4 for years now, and couldn’t be happier, great lessons, happy students, happy teachers.

Christian Parkes. Head of Computer Science, Mary Webb School

Relevant Textbooks

Inside the Unit...

  • Download Free Sample 5.2mb

    Areas Covered

    • Topic 1 Spreadsheet basics
    • Download sample lesson above
    • Topic 2 Data manipulation methods
    • Topic 3 Other processing methods
    • Topic 4 Producing a dashboard
    • Topic 5 Producing a dashboard using pivot tables
    • Topic 6 Conclusions and reviewing presentation methods
    • Assessment

    There are 6 worksheets, 6 homework tasks, and an assessment test, each with answers included in this Series.

  • How to order

    1. Add individual units to a draft order or download a blank order form below to complete manually

    2. Using a draft order you can either:

    1. Save your order online
      (registration or log in required)
    2. Email us your complete order
      (registration or log in required)
    3. Create a PDF
      (to fax or email at a later date)

    Download blank order form

    PDF

    Word

  • Unit Pricing and Discounts

    Each unit is individually priced for LIFE. Please view each unit for detail. 

    Discounts are cumulative based on the total number of units licenced to your department.

    All prices subject to further discounts and VAT.

    There are no annual renewal fees.

    2-5 units 10% discount
    6-11 units 15% discount
    12+ units 20% discount