BTEC IT Unit 2 Creating Systems to Manage Information resources

The BTEC Unit 2 Creating Systems to Manage Information is a Mandatory unit for all BTEC IT Level 3 qualifications 

T​he Unit 2 Database Non Examined Assessment is one of the more challenging units on the Pearson syllabus,

 

TheComputingTutor is pleased to announce the release of a set of teaching resources to help prepare for the 5 hour NEA exam. Each resource is designed to follow the NEA format closely, with Part A being 3 hours and part B being 2 hours.

The resources take the form of three new scenarios based around the 2019 NEA Assessment Format revisions. Within each scenario there are many worked examples for each activity allowing you the flexibility to pick the range of activities that suit your classroom best.

The scenarios are differentiated, with scenario 1 being straightforward and scenario 3 being more challening.

The new scenarios are:

  • Scenario 1 - A Doctor's Surgery

  • Scenario 2 - A Cinema Chain 

  • Scenario  3 - A Publishing Company.

 

Within each scenario you get the following:

Part A - 3 Hours

  • Activity 1 - exam style instructions, input data, example database and classroom presentation of the model answer

  • Activity 2 - exam style instructions, input data, example database and classroom presentation of the model answer

  • Activity 3 - exam style instructions, 11 differentiated queries, 4 differentiated reports, classroom presentation of the model answer and example database

  • Activity 4 - exam style instructions and classroom presentation of the model answer

  • Activity 5 - exam style instructions and model answer

  • Teacher notes on how the the solution was put together

Part B - 2 Hours

  • Activity 6 - A new database, exam style instructions,  4 differentiated forms, classroom presentation of the model answer 

  • Activity 7 - exam style instructions and classroom presentation of the model answer

  • Activity 8 - exam style instructions and model answer

  • Teacher notes on how the the solution was put together

The NEA exam usually has around 2 queries, 1 reports and 2 forms. These scenarios have a range of questions for you to choose from so you can create an exam tailor made to your learners ability. In addition you will be able to have lots of practice questions before setting a timed 'real run'. These scenarios will then leave the Pearson SAMs and Past Papers available to you as full trial mocks.

Each classroom presentation goes through step by step how each table, report or form field was created with step by step guidance in the teacher notes on how the more complicated calculated fields were created. In addition it uses the Pearson guidance for the number of screenshots required as evidence.

Samples of the resources are available in the downloads section at the bottom of the page.

If you are interested in buying the resources, the pricing information is given at the bottom of the page. Please email me for purchase information.

Downloads

24 Documents are included in each sample download for each scenario including 

  • Activity 1: instructions, teaching presentation with answers & example database

  • Activity 2: instructions, teaching presentation with answers & example database

  • Activity 3: instructions, teaching presentation with answers & example database

  • Activity 4: instructions, teaching presentation with answers & example database

  • Activity 5: instructions & example answer

  • Activity 6: instructions, teaching presentation with answers & example database

  • Activity 7: instructions, teaching presentation with answers & example database

  • Activity 8: instructions & example answer

  • Teacher notes and technical information for Parts A and B.

To view a free sample of all 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