BTEC IT Unit 5 Data Modelling Resources

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

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 explaination 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 at the bottom of the page.

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

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.

Learning 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 Learning Resources for the Edexel BTEC IT UNIT 05 Data Modelling. The resources include:

  • A full set of Student Guide Learning Resources for Learning Aims A, B and C

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

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

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

  • Seperate Student Guides for Pass, Merit and Distinction criteria

  • 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 have a look at the feedback for these resources at the bottom of the page.

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 cover the required content headings, the actual material taught is entirely down to you. You have full control of each 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. Please note: this is not a theory resource; this resource focuses entirely on how to answer all the Assignment tasks.

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

Feedback

"The resources for Unit 5 Data Modelling are excellent and are really saving me a lot of time particularly with the current climate 

[they] have helped to differentiate the class and their learning abilities whilst at the same time encouraging students to work independently, as well as stretching and challenging them. The resources are easy for my students to understand and navigate as well as being clearly signposted to the specification. 

 

The handy references to the textbook is encouraging those students, who might not have, to read and reread the handbook associated with this unit."

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

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.

© 2018 by TheComputingTutor. Proudly created with Wix.com

  • Facebook Social Icon
  • Twitter Social Icon