BTEC L3 NQF - IT - Unit 5: Data Modelling
This resource takes BTEC Level 3 students through how to do the skills needed for Unit 5 of the BTEC NQF Level 3 course. It contains 66 videos which take students through how to use the basics and more advanced features of MS Excel.

This is a tried and tested unit which works with a broad range of abilities and usually takes about 8 hours to complete in full.

Students need to create a school production spreadsheet which contains IF Statements, charts, vLookups, Macros, Conditional Formatting to name but a few.

The pack contains a checklist which students can use to monitor their progress. The checklist also links to all of the videos.
Save for later
  • Music-Festival-Model.pptx
  • Example-Spreadsheet.xlsm
  • Video-Guides.docx

About this resource


Created: Feb 9, 2018

Updated: Apr 2, 2018

Unit of work

zip, 241 KB


Unit of work

pptx, 1 MB


Unit of work

xlsm, 168 KB


Report a problem

Tes Paid Licence

How can I re-use this?