BTEC IT Unit 5 Data Modelling Resources

"Well worth the money."

Mrs J. Martin-Johnson, Teacher of Business and IT, Thomas Tallis School, London.

The BTEC Unit 5 Data Modelling is an optional unit for All certification levels from the Extended Certificate upwards.

 
Available for purchase - a full Scheme of Work for BTEC IT Unit 5.
 

TheComputingTutor, is proud to present a complete 27 Lesson scheme of work for the BTEC IT Unit 5 Data Modelling Unit.

 

The resource has been developed with a primary focus on using Microsoft Excel with over 70 exercises, class tasks, discussion and research activities with suggested answers covering Learning Aims A, B and C for the Unit 5 Specification.

 

The Scheme of Work includes a brand new scenario that students can use to practice the coursework requirements for Learning Aim B and C before attempting the Assignment.

 

The resources include:

 

​Learning Aim A

  • ​lessons covering all specification content theory including:

  • ​Class tasks covering stages in the decision making process.

  • Class tasks covering spreadsheet features to support data modelling.

  • Lots of data model examples for analysis in the assignment.

  • Consistent use of data models within the lessons to promote student understanding.

  • Lots of practice data model questions with answers.

Learning Aim B

  • Lessons covering all specification content theory including:

  • How to create a functional specification with suggested Answers.

  • How to design a data model to support a given scenario with suggested Answers.

  • How to review and refine data model designs with suggested Answers.

  • A new scenario with full worked answers is included for students where they can identify practice their design. documentation skills before attempting the assignment.

Learning Aim C

  • Lessons covering all specification content theory including:

  • Advanced spreadsheet features as detailed in the specification.

  • A fully worked original and revised solution for the new example scenario.

  • Answers for carrying out a test plan.

  • How to optimise a data model from testing, feedback and documentation.

  • How to carry out a data model review and evaluation.

Each lesson includes:

  • A teacher presentation with learning objectives, lesson content and end of lesson review.

  • A range of class tasks, from worked examples to discussion activities.

  • Student Worksheets for all class tasks.

  • Suggested answers for the class tasks to encourage and promote discussion and further learning.

  • Resource links to relevant websites and videos that can be used in lesson.

 

Also included is a full outline Scheme of Work for all suggested 27 lessons, which includes:

  • Learning objectives.

  • Lesson overview.

  • Assessment opportunities.

  • EDI considerations.

  • Homework suggestions.

  • A format that can be used for SLT inspections.

  • Teacher notes on resource content with suggested ideas for unit delivery

 
A downloadable sample of the Scheme of Work as well as pricing information is at the bottom of the page.
Available for purchase - a full model answer for the Pearson Authorised Assignment 2 'The Cheese Shop'.

TheComputingTutor is pleased to announce the release of a full worked model Answer exemplar for the BTEC IT Unit 5 Data Modelling Assignment 2 "The Cheese Shop" and is one of the more challenging assignments from Pearson. Please see the downloads section at the bottom of the page for samples.

Available for purchase - a full model answer for the Pearson Authorised Assignment 2 'The BMI Tracker'

TheComputingTutor is pleased to announce the release of a full worked model Answer exemplar for the BTEC IT Unit 5 Data Modelling Assignment 2 "The BMI Tracker". Please see the downloads section at the bottom of the page for samples.

More Information

 

Both of these exemplars are fully worked model answers which includes Named Ranges, Macros, VBA code, Graphs, Functions and Formulas as well as cell Styles and Formatting, all of which are designed to answer the Assignment 2 Authorised Assignment Brief from Pearson.

In addition to the spreadsheet,  there is also a Teacher Guide showing how the solution was designed along with explanation of key functionality.

You will have full access to the worksheets, the macros and the functions so you can see how it works and then use this to help guide your students.

 

Please have a look at the feedback for these resources.

A downloadable sample of the exemplar as well as pricing information is at the bottom of the page.

If you have any questions about purchasing our resources, please take a look at our Purchasing FAQ.

The samples are only available as a limited functionality excel sheet. All macros and functions have been removed and these will only be available in the full version.

Assignment Resources for Assignments 1 and 2 are now available!

The Unit 05 Assignments are relatively straightforward, except that there is a lot of content to cover which could get missed. As part of the new BTEC assessment procedures, assessors are not allowed to give students a list of tasks to cover to achieve a grade once the assignment is running. This means that learners can often forget to include key pieces of evidence, or to not provide evidence in the right format.

 

TheComputingTutor is pleased to announce the release of a full set of Student Guides for the Edexel BTEC IT UNIT 05 Data Modelling. The resources include:

  • A full set of Student Guide Assignment Resources covering what is required for Assignments 1 & 2

  • A Teacher presentation showing your students how to approach each of the Assignments

  • A Teacher resource document, with suggested hints and ideas for Unit delivery and how to structure the assignment content 

  • An editable PowerPoint and a printable PDF for each Student Guide

  • A tracking sheet for your students to monitor their own progress based on COMPLETE, IN PROGRESS and NOT STARTED for all tasks

Each Student Guide covers all the marking requirements for Pass criteria for Learning Aims A, B and C as well as showing extensive opportunities for where to include Merit and Distinction criteria evidence. The Student Guides are ideal for weaker candidates, or students struggling to organise their work, as it gives a simple, easy to follow checklist of all required Assignment criteria.

Please note: this is not a theory resource; this resource focuses entirely on making sure that your students are able to answer the Assignment tasks independently.

 

Please have a look at the feedback for these resources.

Each guide has references on every page to where the required content is covered in the 2016 Authorised Pearson textbook as well as continual assessment opportunities so students can identify the areas they are struggling with so you can support them where allowed.

You can use these learning resources for individual students who are finding the Assignment procedure challenging, or you can give the Guides to your entire group before they start each Assignment - the choice is yours. 

 

The Student Guides only contain the required Assignment content headings, the actual theory content taught is entirely down to you. You have full control of each Guide PowerPoint, so you can edit the slides and move them around to suit your teaching and the needs of your classroom.

These resources will help your learners to know exactly what they have to do to independently achieve their grades.

If you are interested in buying the resources, purchase options are given below. Samples of the files can be found in the downloads section.

If you have any questions about purchasing our resources, please take a look at our Purchasing FAQ.

Downloads

Documents included in the teaching resource sample download include:

  • 3x Teaching presentations, 1 each for Learning Aims A, B and C

  • 3x Student Guides, 1 each for Learning Aims A, B and C as an editable powerpoint

  • 3x Student Guides, 1 each for Learning Aims A, B and C as a read only PDF

  • 2x Student Checklists for Learning Aim A and Learning Aim B&C

  • 1x Student Tracking Document

  • 1x Teacher Notes with ideas and information about Unit Delivery.

In addition, documents in the data model sample include:

  • 1x Technical Information about the Data Model

  • 1x reduced functionality spreadsheet

To view a free sample of files available for the following resources click on the links below

 
 
 
 
 
Pricing Information

Ready To Place An Order?

  • If you are ready to place an order simply head over to the online Store.

  • Here you can add the items you want into your basket.

  • Once you have all the items you wish and you check out you will receive a confirmation email.

  • An invoice will be sent to your contact email with details for a BACS payment.

  • All emails must be from a valid educational institution email address. Personal emails are not acceptable and any order placed using a personal email will be cancelled.

  • Any applicable discount will be itemised in your invoice.

  • Once the funds have cleared you will be sent another email containing a link that will allow you to download your resources.

  • This link will be valid for 30 days.

  • If you have any problems with your purchase, please don't hesitate to get in touch.