New to PG?
Start here

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

Available Jul 2022

 
B

Inside the Unit...

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...

I don't normally purchase resources but the BTEC resources were money well spent.The BTEC resources are excellent and I have found them invaluable for teaching.

Lorraine Dickinson. Head of Computer Science, Wellfield Community School

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

Relevant Textbooks

Inside the Unit...

  • 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