<p>More free taster videos for other papers are here: <a href="https://www.tes.com/teaching-resource/resource-12951622">https://www.tes.com/teaching-resource/resource-12951622</a></p> <p>I also have previous resources covering</p> <ol> <li>the June 2022 exam (video walkthrough and written answers): <a href="https://www.tes.com/teaching-resource/resource-12945691">https://www.tes.com/teaching-resource/resource-12945691</a></li> <li>the January 2023 exam (again, videos and written): <a href="https://www.tes.com/teaching-resource/resource-12951870">https://www.tes.com/teaching-resource/resource-12951870</a></li> <li>the June 2023 exam (again, video walkthroughs and written answers): <a href="https://www.tes.com/teaching-resource/resource-12949688">https://www.tes.com/teaching-resource/resource-12949688</a></li> </ol> <p>I also have a 56% off bundle of my other, 2023 and earlier Unit 2 resources here: <a href="https://www.tes.com/teaching-resource/resource-12945635">https://www.tes.com/teaching-resource/resource-12945635</a><br /> <strong>This 2024 exam resource is not in this bundle</strong>.</p>

<p>This resource is relevant to:</p> <ul> <li>Pearson BTEC Level 3 National Extended Diploma in Information Technology</li> <li>Unit 2: Creating Systems to Manage Information</li> </ul> <p><strong>This booklet is part of a series. I do not suggest using it standalone.</strong><br /> <em>It refers to a practice database made in booklet 1, which can be found for free here: <a href="https://www.tes.com/teaching-resource/resource-12945808">https://www.tes.com/teaching-resource/resource-12945808</a></em></p> <p>The resource is a 20 page booklet which takes students through the both Activities 4 &amp; 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&amp;5 of the Unit 2 Controlled Assessment.</p> <p><strong>Contents of booklet</strong></p> <ul> <li>Part A Activity 4 explanation (6 marks)</li> <li>Part A Activity 5 explanation (6 marks)</li> <li>How to get maximum marks in Activity 4 (Structure testing)</li> <li>How to get maximum marks in Activity 5 (Structure evaluation)</li> <li>Part A Activities 4&amp;5 practice (Jan 2021 Smart Art)</li> <li><em>Overall revision guidance for Part A of your controlled assessment</em></li> </ul>

<p>Embdedded on this page is a video to help you gauge your interest (covering Activity 1 for this paper).<br /> 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: <a href="https://www.tes.com/teaching-resource/resource-12951622">https://www.tes.com/teaching-resource/resource-12951622</a></p> <p>This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information</p> <p>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.</p>

<p>Embedded in this page is a video to help you gauge your interest (covering the Report, Activity 3c, for this paper).<br /> All free taster videos are here: <a href="https://www.tes.com/teaching-resource/resource-12951622">https://www.tes.com/teaching-resource/resource-12951622</a></p> <p>I also have previous resources covering</p> <ol> <li>the June 2022 exam (video walkthrough and written answers): <a href="https://www.tes.com/teaching-resource/resource-12945691">https://www.tes.com/teaching-resource/resource-12945691</a></li> <li>the June 2023 exam (again, video walkthroughs and written answers): <a href="https://www.tes.com/teaching-resource/resource-12949688">https://www.tes.com/teaching-resource/resource-12949688</a></li> </ol> <p>This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information</p> <p>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.</p>

<p>This resource is relevant to:</p> <ul> <li>Pearson BTEC Level 3 National Extended Diploma in Information Technology</li> <li>Unit 2: Creating Systems to Manage Information</li> </ul> <p>This is a collection of ERD questions and data for <em>seven past controlled assessment papers</em>. 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.<br /> Later marks are dependent on Activity 1 being correct, so this level of practice is arguably a good idea.</p> <p><strong>I then provide detailed answers, in the separate answer booklet, which explain <em>why</em> the answer is what it is.</strong> I hope you, and your students, find those details useful.</p>

<p>There’s a taster video on this page, to help you gauge your interest. It covers Part A Activity 4.<br /> All free taster videos (covering three exam papers so far, and I plan to add more in future) are here: <a href="https://www.tes.com/teaching-resource/resource-12951622">https://www.tes.com/teaching-resource/resource-12951622</a></p> <p>This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology Unit 2: Creating Systems to Manage Information</p> <p>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.</p>

<p>This resource is relevant to: Pearson BTEC Level 3 National Extended Diploma in Information Technology, Unit 2: Creating Systems to Manage Information</p> <p><strong>This booklet is part of a series.</strong> However, it doesn’t refer to previous booklets, so it can be used standalone to cover Part B. <em>You will need access to the Pearson Unit 2 past papers for the Part B databases that they provide.</em></p> <p>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.<br /> Students will need need Microsoft Access to open the controlled assessment Part B databases (<strong>not provided</strong>, find the Pearson exam materials), and will need to use Microsoft Access to meet the demands of the assessment questions (forms, testing and evaluation).</p>

<p><strong>IN FREE TASTER PACK: <a href="https://www.tes.com/teaching-resource/resource-12945808">https://www.tes.com/teaching-resource/resource-12945808</a></strong></p> <p>This resource is relevant to:</p> <ul> <li>Pearson BTEC Level 3 National Extended Diploma in Information Technology</li> <li>Unit 2: Creating Systems to Manage Information</li> </ul> <p>This is a collection of ERD questions and data for <em>seven past controlled assessment papers</em>. 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.<br /> Later marks are dependent on Activity 1 being correct, so this level of practice is arguably a good idea.</p> <p>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.</p>

<p>This resource is relevant to:</p> <ul> <li>Pearson BTEC Level 3 National Extended Diploma in Information Technology</li> <li>Unit 2: Creating Systems to Manage Information</li> </ul> <p><strong>This booklet is part of a series. I do not suggest using it standalone.</strong><br /> <em>It refers to a practice database made in booklet 1, which can be found for free here: <a href="https://www.tes.com/teaching-resource/resource-12945808">https://www.tes.com/teaching-resource/resource-12945808</a></em></p> <p>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.</p> <p><strong>Contents of booklet</strong></p> <ul> <li>What is a Relational database?</li> <li>Drawing ERDs (Entity Relationship Diagrams)</li> <li>Normalisation</li> <li>Part A Activity 1 practice (8 marks): using the Smart Art (Jan 2021) paper</li> </ul>

<p>This resource is relevant to:</p> <ul> <li>Pearson BTEC Level 3 National Extended Diploma in Information Technology</li> <li>Unit 2: Creating Systems to Manage Information</li> </ul> <p><strong>This booklet is part of a series. I do not suggest using it standalone.</strong><br /> <em>It refers to a practice database made in booklet 1, which can be found for free here: <a href="https://www.tes.com/teaching-resource/resource-12945808">https://www.tes.com/teaching-resource/resource-12945808</a></em></p> <p>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.</p> <p><strong>Contents of booklet</strong></p> <ul> <li>Part A Activity 3 explanation (12 marks)</li> <li>Query 1: Repeating the query from the introduction booklet</li> <li>Query 2: learning about the Total row and creating calculated fields / expressions</li> <li>Query 3: using an IIf function to decide true/false based on a value</li> <li>Creating and formatting a report: Input mask and lookup practice, including our first ever report (using Report Wizard)</li> <li>Skills for producing more detailed reports (both for showing existing data and making calculations on that data)</li> <li>Exam practice on both queries and reports: Part A Activity 3 practice (Jan 2021 Smart Art)</li> </ul>

<p><strong>IN FREE TASTER PACK: <a href="https://www.tes.com/teaching-resource/resource-12945808">https://www.tes.com/teaching-resource/resource-12945808</a></strong></p> <p>This resource is relevant to:</p> <ul> <li>Pearson BTEC Level 3 National Extended Diploma in Information Technology</li> <li>Unit 2: Creating Systems to Manage Information</li> </ul> <p>The resource is a 20 page booklet. Students will need access to Microsoft Access. By following the booklet, they will produce their first database.</p> <p><strong>Contents of booklet</strong></p> <ul> <li>The specification for Unit 2 (pages 1-4)</li> <li>Grade descriptors (page 4)</li> <li>Key assessment terms (page 5)</li> <li>Making your first database (p6-14)</li> <li>Making your first query (p15-17)</li> <li>Consolidation, homework, and revision (pages 18, 19 and 20)</li> </ul>

<p>This resource is relevant to:</p> <ul> <li>Pearson BTEC Level 3 National Extended Diploma in Information Technology</li> <li>Unit 2: Creating Systems to Manage Information</li> </ul> <p><strong>This booklet is part of a series. I do not suggest using it standalone.</strong><br /> <em>It refers to a practice database made in booklet 1, which can be found for free here: <a href="https://www.tes.com/teaching-resource/resource-12945808">https://www.tes.com/teaching-resource/resource-12945808</a></em></p> <p>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.</p> <p><strong>Contents of booklet</strong></p> <ul> <li>Part A Activity 2 explanation (8 marks)</li> <li>The 6 validation rules / checks / lookups</li> <li>Part A Activity 2 practice (Jan 2021 Smart Art)</li> <li>Input mask homework</li> <li>Video guidance (on YouTube) specifically for Activity 2</li> <li>Video tutorials (on YouTube) with guided tutorials for multiple previous papers</li> </ul>

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

<p>Pearson BTEC Level 3 Creative Digital Media Production: Unit 19 Scriptwriting<br /> <strong>Learning Assignment B Booklet</strong>: <em>44 detailed pages covering all learning aims and assessment criteria</em>.</p>

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

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

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

<p>Pearson BTEC Level 3 Creative Digital Media Production: Unit 19 Scriptwriting<br /> <strong>Learning Assignment A Booklet</strong>: <em>38 detailed pages covering all learning aims and assessment criteria</em>.</p>

<p>Pearson BTEC Level 3 Creative Digital Media Production: Unit 19 Scriptwriting<br /> <strong>Teen Drama genre script pack</strong>: <em>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</em>.</p>