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

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.

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.

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.

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.

Pearson BTEC Level 3 Creative Digital Media Production: Unit 18 Storyboarding Learning Assignment A assignment booklets and powerpoints.BTEC L3 Creative Digital Media Production: Unit 19 Scripwriting (Learning Aim C resources)

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).

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.

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

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)

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)

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

Pearson BTEC Level 3. Unit 1. E: Impact of IT systems. Booklet, powerpoints, exam question booklet and answers for this examined unit.

Pearson BTEC Level 3. Unit 1. F: Issues (moral, ethical, legal) Booklet, powerpoints, exam question booklet and answers for this examined unit.

Pearson BTEC Level 3 Creative Digital Media Production: Unit 19 Scriptwriting Learning Assignment B Booklet: 44 detailed pages covering all learning aims and assessment criteria.

Pearson BTEC Level 3 Creative Digital Media Production: Unit 19 Scriptwriting Learning Assignment C assignment worksheets: Frames for writing a draft script proposal, and final script proposal, and a ‘script feedback and changes log’. Also added is a ‘short film analysis template’, so students can show that they are thinking about genre, narrative etc.

Pearson BTEC Level 3 Creative Digital Media Production: Unit 19 Scriptwriting Teen Drama genre script pack: 16 pages with script excerpts from Wednesday, Glee, Teen Wolf and Riverdale. Questions and answer spaces lead students to complete Learning Aim A, B and C learning objectives.

Pearson BTEC Level 3 Creative Digital Media Production: Unit 19 Scriptwriting Learning Assignment A Booklet: 38 detailed pages covering all learning aims and assessment criteria.

This FREE TASTER includes a 20 page booklet. Students will need access to Microsoft Access. By following the booklet, they will produce their first database. Also included is 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. Also see the free taster video (see bold text below) I suggest checking out my detailed Activity 1 (ERD / normalisation) practice booklets and DETAILED ANSWERS explaining why the answer is what it is, due to 1NF, 2NF, 3NF and many-to-many relationships (junction tables and Composite Keys). That can be found here: https://www.tes.com/teaching-resource/resource-12945626 I also suggest this discounted bundle of all my Unit 2 resources: https://www.tes.com/teaching-resource/resource-12945635 I have also created three sets of video walkthroughs. Written walkthroughs are also present in these resources, and are used in the videos. I show how to use Access and the activity templates to get a Distinction, covering all activities. Each exam resource page features a free taster video! https://www.tes.com/teaching-resource/resource-12945691 https://www.tes.com/teaching-resource/resource-12951870 https://www.tes.com/teaching-resource/resource-12949688 Contents of the free Activity 1 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) This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information