This shop sells materials that have been used in an ALPS rated "1" college (2019 results) for the results achieved in Key Stage 5 in BTEC Nationals Extended Certificate in Information technology, and in KS4, BTEC Tech Award in Digital Information Technology. Key Stage 4 resources now available for the three components of the BTEC Tech Award in Digital and information technology course. Email:

zip, 7.42 MB
zip, 7.42 MB

BTEC Tech Award in digital information technology

Component 2

Component 2 involves the creation of a Dashboard using Excel, covering quite a few complex functions and formulae. The resources in this pack have been designed to give all students the opportunity to aim for the Distinction grade and can therefore be differentiated according to the needs of an individual group.

The presentations are designed to give the students a guide as to what to put in their work and will be supported by teacher’s individual lessons or one on one interventions as and when required. They will be vital in helping students become as independent as possible which considering the nature of the qualification is key to success, as students will invariably find themselves at different stages of the assignments very quickly.

The folder contains the following files:

  • “Learning Aim A”, “Learning Aim B” and “Learning Aim C” presentations. These detailed presentations are to be used alongside Pearson assignments and teacher led lessons. They will help students develop a more independent style of working and should alleviate some of the workload felt by the class teacher.

  • “Holiday Data Macro” enabled spreadsheet and “Holiday Data” spreadsheet. The macro enabled spreadsheet has an example of all functions and formulae used in section B of component 2, and would is an excellent teaching aid and reference point for students. Students will be able to use these examples and in turn create Dashboards worthy of a Distinction grade.



Something went wrong, please try again later.


2 years ago

Do not purchase this. Presentations are skimpy at best. Do not trust TES to refund your money. Despite their assurances that purchase safely you cannot. <br /> <br /> Really disappointed in TES for this.

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.