unit 5 assignment 2 p5

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

Assignment 1

Learning Aim A

5/A.P1 Explain the importance of promoting equality and diversity for individuals with different needs.

5/A.M1 Analyse the impact of preventing discrimination for individuals with different needs.

5/A.P2 Explain the skills and personal attributes necessary for professionals who care for individuals with different needs.

5/A.M2 Assess different methods professionals might use when building relationships and establishing trust with individuals with needs .

5/A.D1 Evaluate the success of promoting anti-discriminatory practice for specific individuals with different needs.

Learning Aim B

5/B.P3 Explain how to incorporate ethical principles into the provision of support for individuals with different needs

5/B.M3 Analyse how an ethical approach to providing support would benefit specific individuals with different needs.

Learning Aim C

5/C.P4 Explain the strategies and communication techniques used with individuals different needs to overcome different challenges.

5/C.M4 Assess the strategies and communication techniques used to overcome different challenges faced by individuals with different care and support needs.

5/C.P5 Explain the benefits of promoting personalisation when overcoming challenges faced by individuals with different needs.

5/BC.D2 Justify the strategies and techniques used to overcome ethical issues and challenges experienced by individuals with different needs when planning and providing care.

Assignment 2

Learning Aim D

5/D.P6 Explain why meeting the needs of the individuals requires the involvement of different agencies.

5/D.P7 Explain the roles and responsibilities of different members of the multidisciplinary team in meeting the needs of specific individuals

5/D.M5 Assess the benefits of multi-disciplinary and multi-agency working for specific individuals with care and support needs

5/D.D4 Evaluate how multiagency and multidisciplinary working can meet the care and support needs of specific individuals

5/D.P8 Explain the arrangements for managing information between professionals.

5/D.M6 Analyse the impact of legislation and codes of practice relating to information management on multidisciplinary working.

5/D.D3 Justify how organisations and professionals work together to meet individual needs while managing information and maintaining confidentiality.

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

Travel & Tourism BTEC - L2 - Unit 5 - Entire Unit

Subject: Vocational studies

Age range: 14-16

Resource type: Unit of work

Last updated

22 February 2018

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

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.

rachelmcelhone

Empty reply does not make any sense for the end user

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: