Save for later
BTEC National IT, Unit 2 Creating systems to manage information: Car rentals database

This zip file contains a resource developed to help deliver the BTEC National Extended Certificate in IT, and specifically focuses on Unit 2, creating systems to manage information. It contains files that teachers can use to help students understand what is required from the exam in this unit. This resource is part of a scheme of work that resulted in an ALPS rating of “1” for Information technology at the college I work for.

The zip folder contains the following files:

Car rental database: A comprehensive solution to the question paper that can be used to guide students through various tasks and base lessons on. The database contains working log in forms based on the solution provided by Pearson following 2018 exams, relevant queries, tables and reports.

Car rental Question paper: This paper has been written to simulate the actual exam set by Pearson. It gives the students a chance to experience what is required of them and allow them to become completely familiar with the requirements of the Unit 2 exam.

Activity2tables, Activity3interface, activity4testing, activity5evaluation. These four attachments are based on the materials the student will be given in the exam. They are based on the most recent update (November 2018) by Pearson which affected the testing and evaluation activities specifically. The criteria for testing and evaluation has been left blank as this is something that should be entered by teachers who have a better knowledge of their students. It can be made more or less difficult according to range of abilities.

Rentals TXT file for importing into the database the students will set up.

Unit 2 Mark scheme – so the students work can be assessed once it is done.

Save for later
  • Car-Rentals.zip

About this resource


Created: Jan 30, 2019

Updated: Mar 22, 2019

Unit of work

zip, 566 KB


Report a problem

Tes Paid Licence

How can I re-use this?