Unit 1 Pearson Level 3 AAQ Information Technology - for teaching starting 2025 (new AAQ spec)Quick View
TomKrawec

Unit 1 Pearson Level 3 AAQ Information Technology - for teaching starting 2025 (new AAQ spec)

(0)
FREE TASTER (A1 SECTION ONLY) HERE: https://www.tes.com/teaching-resource/free-taster-unit-1-a1-section-only-pearson-level-3-aaq-information-technology-13362354 This resource covers all parts of Unit 1 for the 2025 AAQ in IT. This is an externally assessed unit. This zip file contains all Word documents and Powerpoints. It’s in a zip file to preserve the folder structure, as it is broken into Sections (A through to F), with some section having separate subfolders (e.g. ‘A1’, ‘A2’, ‘A3’, and ‘A4 & A5’). These resources cover this new 2025 spec in detail. I will teach Unit 1 starting in January 2026 and plan to update this zip file with changes I make. This is a resource for Pearson Level 3 Alternative Academic Qualification BTEC National in Information Technology (Extended Certificate) (Qualification number: 610/3960/3). This AAQ has a first teaching date of September 2025. You can find details about this qualification, and the specification, here: https://qualifications.pearson.com/en/qualifications/btec-nationals/information-technology-aaq.html
Unit 3 (Website Development) LAA: Pearson Level 3 AAQ Information TechnologyQuick View
TomKrawec

Unit 3 (Website Development) LAA: Pearson Level 3 AAQ Information Technology

(0)
This resource covers LAA for Unit 3 (Website Development). It contains five word Documents that take students through the specification content and a practice assignment. This practice assignment is based on V1 of the brief, so you may wish to amend it to address the requirements of other briefs. You can find details about this qualification, and the specification, here: https://qualifications.pearson.com/en/qualifications/btec-nationals/information-technology-aaq.html This is a resource for Pearson Level 3 Alternative Academic Qualification BTEC National in Information Technology (Extended Certificate) (Qualification number: 610/3960/3). This AAQ has a first teaching date of September 2025.
BTEC IT Unit 2 Databases Testing and Evaluation (Part A, Activities 4&5)Quick View
TomKrawec

BTEC IT Unit 2 Databases Testing and Evaluation (Part A, Activities 4&5)

(1)
This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information This booklet is part of a series. I do not suggest using it standalone. It refers to a practice database made in booklet 1, which can be found for free here: https://www.tes.com/teaching-resource/resource-12945808 The resource is a 20 page booklet which takes students through the both Activities 4 & 5 (structure testing and structure evaluation). Students will need access to Microsoft Access. By following the booklet, they will be able to complete Part A, Activities 4&5 of the Unit 2 Controlled Assessment. Contents of booklet Part A Activity 4 explanation (6 marks) Part A Activity 5 explanation (6 marks) How to get maximum marks in Activity 4 (Structure testing) How to get maximum marks in Activity 5 (Structure evaluation) Part A Activities 4&5 practice (Jan 2021 Smart Art) Overall revision guidance for Part A of your controlled assessment
BTEC IT Unit 2 VIDEO WALKTHROUGHS & written answers for the January 2024 AND May 2024 examsQuick View
TomKrawec

BTEC IT Unit 2 VIDEO WALKTHROUGHS & written answers for the January 2024 AND May 2024 exams

(0)
More free taster videos for other papers are here: https://www.tes.com/teaching-resource/resource-12951622 I also have previous resources covering the June 2022 exam (video walkthrough and written answers): https://www.tes.com/teaching-resource/resource-12945691 the January 2023 exam (again, videos and written): https://www.tes.com/teaching-resource/resource-12951870 the June 2023 exam (again, video walkthroughs and written answers): https://www.tes.com/teaching-resource/resource-12949688 I also have a 56% off bundle of my other, 2023 and earlier Unit 2 resources here: https://www.tes.com/teaching-resource/resource-12945635 This 2024 exam resource is not in this bundle.
BTEC IT Unit 2 Databases Activity 1 practice booklets WITH DETAILED ANSWERSQuick View
TomKrawec

BTEC IT Unit 2 Databases Activity 1 practice booklets WITH DETAILED ANSWERS

(0)
This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information This is a collection of ERD questions and data for seven past controlled assessment papers. Students are asked to attempt an initial answers based on 1NF, 2NF and 3NF. They then improve after discussion, and finally take down the correct answer. By doing this repeatedly (seven times on these sheets, and then doing at least some again), the practice will help most students become very capable at this activity. Later marks are dependent on Activity 1 being correct, so this level of practice is arguably a good idea. I then provide detailed answers, in the separate answer booklet, which explain why the answer is what it is. I hope you, and your students, find those details useful.
BTEC IT Unit 2 Part B, activities 6, 7&8Quick View
TomKrawec

BTEC IT Unit 2 Part B, activities 6, 7&8

(0)
This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology, Unit 2: Creating Systems to Manage Information This booklet is part of a series. However, it doesn’t refer to previous booklets, so it can be used standalone to cover Part B. You will need access to the Pearson Unit 2 past papers for the Part B databases that they provide. The resource is a 32 page booklet which takes students through all Part B activities (6, 7 and 8). It guides students through answering multiple past paper questions for each of these activities, with step-by-step guidance for how to do so. There is also revision guidance, so students can revise producing input forms. The booklet also contains links to YouTube video guides. Students will need need Microsoft Access to open the controlled assessment Part B databases (not provided, find the Pearson exam materials), and will need to use Microsoft Access to meet the demands of the assessment questions (forms, testing and evaluation).
BTEC IT Unit 2 Databases Activity 1 (ERD) practice worksheetsQuick View
TomKrawec

BTEC IT Unit 2 Databases Activity 1 (ERD) practice worksheets

(0)
IN FREE TASTER PACK: https://www.tes.com/teaching-resource/resource-12945808 This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information This is a collection of ERD questions and data for seven past controlled assessment papers. Students are asked to attempt an initial answers, then improve after discussion, and finally take down the correct answer. By doing this repeatedly (seven times on these sheets, and then doing at least some again), the practice will help most students become very capable at this activity. Later marks are dependent on Activity 1 being correct, so this level of practice is arguably a good idea. While these sheets are useful, they do not represent anywhere near as much effort as the booklets I also offer, so I’m offering them for the lowest price that I can select. I hope they find you well.
BTEC IT Unit 2 VIDEO WALKTHROUGHS & written answers for the June 2023 HB Caravan Park examQuick View
TomKrawec

BTEC IT Unit 2 VIDEO WALKTHROUGHS & written answers for the June 2023 HB Caravan Park exam

(0)
Embdedded on this page is a video to help you gauge your interest (covering Activity 1 for this paper). There is another taster video for this paper. All free taster videos (covering three exam papers so far, and I plan to add more in future) are here: https://www.tes.com/teaching-resource/resource-12951622 This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information It contains WORD DOCUMENTS and VIDEO WALKTHROUGHS. I use the Word docs in the video walkthroughs, so everything ties together. I use Access and the activity templates to complete exam papers. Every single activity is covered, for both Part A and B.
BTEC IT Unit 2 Databases Normalisation, Drawing ERDs, Relational Databases (Part A, Activity 1)Quick View
TomKrawec

BTEC IT Unit 2 Databases Normalisation, Drawing ERDs, Relational Databases (Part A, Activity 1)

(0)
This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information This booklet is part of a series. I do not suggest using it standalone. It refers to a practice database made in booklet 1, which can be found for free here: https://www.tes.com/teaching-resource/resource-12945808 The resource is a 21 page booklet and a powerpoint. Students will need access to Microsoft Access. By following the booklet, they will be able to complete Part A, Activity 1 of the Unit 2 Controlled Assessment. Contents of booklet What is a Relational database? Drawing ERDs (Entity Relationship Diagrams) Normalisation Part A Activity 1 practice (8 marks): using the Smart Art (Jan 2021) paper
BTEC IT Unit 2 VIDEO WALKTHROUGHS & written answers for the June 2022 Automatic Vending examQuick View
TomKrawec

BTEC IT Unit 2 VIDEO WALKTHROUGHS & written answers for the June 2022 Automatic Vending exam

(0)
There’s a taster video on this page, to help you gauge your interest. It covers Part A Activity 4. All free taster videos (covering three exam papers so far, and I plan to add more in future) are here: https://www.tes.com/teaching-resource/resource-12951622 This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information It contains WORD DOCUMENTS and VIDEO WALKTHROUGHS. I use the Word docs in the video walkthroughs, so everything ties together. I use Access and the activity templates to complete exam papers. Every single activity is covered, for both Part A and B.
BTEC IT Unit 2 Databases Queries and Reports (Part A, Activity 3)Quick View
TomKrawec

BTEC IT Unit 2 Databases Queries and Reports (Part A, Activity 3)

(0)
This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information This booklet is part of a series. I do not suggest using it standalone. It refers to a practice database made in booklet 1, which can be found for free here: https://www.tes.com/teaching-resource/resource-12945808 The resource is a detailed 33 page booklet which takes students through the intricacies of creating queries and reports Activity 3. Students will need access to Microsoft Access. By following the booklet, they will be able to complete Part A, Activity 3 of the Unit 2 Controlled Assessment. Contents of booklet Part A Activity 3 explanation (12 marks) Query 1: Repeating the query from the introduction booklet Query 2: learning about the Total row and creating calculated fields / expressions Query 3: using an IIf function to decide true/false based on a value Creating and formatting a report: Input mask and lookup practice, including our first ever report (using Report Wizard) Skills for producing more detailed reports (both for showing existing data and making calculations on that data) Exam practice on both queries and reports: Part A Activity 3 practice (Jan 2021 Smart Art)
BTEC IT Unit 2 VIDEO WALKTHROUGHS & written answers for the Jan 2023 Martlepool LFC examQuick View
TomKrawec

BTEC IT Unit 2 VIDEO WALKTHROUGHS & written answers for the Jan 2023 Martlepool LFC exam

(0)
Embedded in this page is a video to help you gauge your interest (covering the Report, Activity 3c, for this paper). All free taster videos are here: https://www.tes.com/teaching-resource/resource-12951622 I also have previous resources covering the June 2022 exam (video walkthrough and written answers): https://www.tes.com/teaching-resource/resource-12945691 the June 2023 exam (again, video walkthroughs and written answers): https://www.tes.com/teaching-resource/resource-12949688 This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information It contains WORD DOCUMENTS and VIDEO WALKTHROUGHS. I use the Word docs in the video walkthroughs, so everything ties together. I use Access and the activity templates to complete exam papers. Every single activity is covered, for both Part A and B.
BTEC IT Unit 2 Databases Making 1st DatabaseQuick View
TomKrawec

BTEC IT Unit 2 Databases Making 1st Database

(0)
IN FREE TASTER PACK: https://www.tes.com/teaching-resource/resource-12945808 This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information The resource is a 20 page booklet. Students will need access to Microsoft Access. By following the booklet, they will produce their first database. Contents of booklet The specification for Unit 2 (pages 1-4) Grade descriptors (page 4) Key assessment terms (page 5) Making your first database (p6-14) Making your first query (p15-17) Consolidation, homework, and revision (pages 18, 19 and 20)
BTEC IT Unit 2 Databases Validation rules, Format checks and Lookups (Part A, Activity 2)Quick View
TomKrawec

BTEC IT Unit 2 Databases Validation rules, Format checks and Lookups (Part A, Activity 2)

(0)
This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information This booklet is part of a series. I do not suggest using it standalone. It refers to a practice database made in booklet 1, which can be found for free here: https://www.tes.com/teaching-resource/resource-12945808 The resource is an 18 page booklet which takes students through all the validation rules, checks and lookups needed for Activity 2. Students will need access to Microsoft Access. By following the booklet, they will be able to complete Part A, Activity 2 of the Unit 2 Controlled Assessment. Contents of booklet Part A Activity 2 explanation (8 marks) The 6 validation rules / checks / lookups Part A Activity 2 practice (Jan 2021 Smart Art) Input mask homework Video guidance (on YouTube) specifically for Activity 2 Video tutorials (on YouTube) with guided tutorials for multiple previous papers
BTEC IT Unit 2 Databases bundle (56% off, 11 packs of resources covering every aspect of the assessment, pre-2024 exams only)Quick View
TomKrawec

BTEC IT Unit 2 Databases bundle (56% off, 11 packs of resources covering every aspect of the assessment, pre-2024 exams only)

11 Resources
This bundle has all the booklets, written walkthroughs, video walkthroughs, and ERD / Normalisation practice sheets uploaded in my first year uploading to this site. 2024 resources are NOT included. You can find those here: https://www.tes.com/teaching-resource/resource-12945635 The booklets in this bundle cover all activities, with reference to past papers and their answers throughout. Written and VIDEO answer walkthroughs for the June 2022 (Automatic Vending) paper, covering all activities in that paper. Also, the same for both the June 2023 (Heather Burn Caravan) paper and for the Jan 2023 (Martlepool College LFC) paper. There are free taster videos on their respective pages. They are combined together in this free pack: https://www.tes.com/teaching-resource/free-taster-videos-for-unit-2-databases-video-walkthroughs-covering-multiple-papers-and-activities-12951622. Activity 1 / Entity Relationship Diagram / Normalisation practice sheets, booklets, and detailed answers so students can understand why the answer is what it is (because of junction tables, composite keys, and more).