unit 5 assignment 2

• International
• Education Jobs
• Schools directory
• Resources Education Jobs Schools directory News Search

Unit 5: International Business student checklist and feedback templates for ALL assignments!

Subject: Business and finance

Age range: 16+

Resource type: Worksheet/Activity

Last updated

19 November 2022

• Share through email
• Share through twitter
• Share through linkedin
• Share through facebook
• Share through pinterest

This resource comprises resource for all THREE assignments of Unit 5: International Business of the Level 3 BTEC National Extended Diploma in Business, this resources comprises three documents:

Assignment 1 (for LA & LB) checklist to help learners complete the assignment

Assignment 2 (for LC&LD) checklist to help learners complete the assignment

Assignment 3 (for LE) checklist to help learners complete the assignment

Feedback document to post to learners with written feedback against the criteria on a seperate doc to their coursework (two sets of feedback per assignment included on one doc)

Each checklist tells students when specific criteria has been achieved (often a challenge for teachers!)

This resource has made this unit such a breeze for teachers like myself, allowing students to start right away and complete the assignments independantly to a high standard (you can post this resource directly to students!).

All resources are hugely detailed and enable all LPA students to achieve a distinction for this unit.

*I am an experienced lead teacher of Business and Economics, as well as SV for BTEC Level 2 Tech Award in Enterprise and Associate Examiner for Level 3 BTEC externally assessed units

Tes paid licence How can I reuse this?

Your rating is required to reflect your happiness.

It's good to leave some feedback.

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

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

Not quite what you were looking for? Search by keyword to find the right resource:

The Computing Tutor

"inspiring students to succeed".

100% Student Pass Rate at AQA A Level!

STEM Learning Support Specialist in GCSE Maths, L2 & L3 BTEC IT and A Level Computer Science​. Online 1:1 support available to the whole of the UK!

NEW ARRIVAL! A Complete Scheme of Work Resource for the

Level 3 BTEC IT Unit 2 Exam Parts A and B

 "Well worth the money . "

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

The BTEC Unit 5 Data Modelling Unit is an optional unit for all certification levels from the Extended Certificate upwards Here is 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 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

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. 

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

​ 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. The sample downloads 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 RQF 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.  Theory content is covered in the associated Scheme of Work.

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

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

See What People Think Of Our Resources!

"The resources for Unit 5 Data Modelling are excellent and are really saving me a lot of time particularly with the current climate.  The resources 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.  Well worth the money!!"

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

Pardon Our Interruption

As you were browsing something about your browser made us think you were a bot. There are a few reasons this might happen:

• You've disabled JavaScript in your web browser.
• You're a power user moving through this website with super-human speed.
• You've disabled cookies in your web browser.
• A third-party browser plugin, such as Ghostery or NoScript, is preventing JavaScript from running. Additional information is available in this support article .

To regain access, please make sure that cookies and JavaScript are enabled before reloading the page.