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.