Supporting the NEW EdExcel BTEC Tech Award BTEC Tech Award in Digital Information Technology Personalised Learning Checklists for Component 1 (+ Component 1 Assessment), Component 2 (+ Component 2 Assessment) and Component 3. Keep a record of student progress against the new syllabus content (1 - Grasped concept, 2 - need to revise, 3 - Did not understand (complete revisit). Ideal for completing after interim assessment, and will allow easy identification of areas for further teaching and intervention.

This resource has been developed based on student feedback from the Paper 2 2018 and the Paper 2 Examiner Report extract: “Candidates who did well on this paper generally… Understood the use of SQL and wildcards.” This resource provides: Syntax, example for a fruitShop table and practice with a bakery table. Solution provided - in lesson, I will get students to self-check against a printed copy of the solution. Thanks for taking an interest in this resource.

GCSE Computer Science Unit 1 - Storage Calculating the capacity of files: In the exam, students will be expected to be able to calculate the capacity of different file types: Text File, Database File, Sound File and Image File. This lesson provides students with practice calculating capacity for the four different file types - 5 minute lesson plan and teacher solution provided.

A practical exercise looking at: Key terms Layout Positioning of key terms Calculations Teacher solution provided.

A lesson which worked well with a high and low ability Year 10 class. They had struggled with the Statement of Account, but through this presentation, by the end of the lesson, all students were much more confident on the topic.

Pseudocode and flowchart Year 9 recap lesson.

BTEC Tech Award in Digital Information Technology Common Tricky Word Flashcards a) Print out and laminate for peer-to-peer knowledge testing. b) Use at home or in class for revision, keyword appears, define, definition appears. Written in simple terms, based on areas Year 11 2020 struggled on in preparation for the February exam.

Incorporate functional skills into the new KS3 Computing curriculum - essential transferable skills for use in other curriculum areas. This scheme of work and self-assessment checklist, will help develop students report writing skills in Microsoft Word, ready for use in KS4 controlled assessment write-up.

Worksheet that students can complete on computer (Excel) or by hand. Recaps on costs and revenues before delving into break-even. Teacher solution on second worksheet in file.

End of Unit assessment for Algorithms. Practice: Binary searching Linear searching Bubble Sorting Merge Sorting Lists Merge Sorting Insertion Sorting

I have trialled the teaching of BTEC TA Digital Information Technology during 2017/2018 and have produced the attached ‘placemats’ to ensure that students understand the key skills required for LAB/C and the knowledge required for the research task in Component A. Either print double-sided, laminate or simply display/view on screen. On side A is the LAA theory looking at sectors of industry. On side B is the LAB/C skills in Excel. I have used them laminated, 1 between 2 and supported the Excel element with short tasks that teach students the skills as listed in the specification. I hope these can be of help to you and your students. Thanks for taking an interest in this resource.

Activity with formulae, explanation and example. Student worksheet Teacher Solution worksheet. Calculating: Contribution per Unit Break-Even Point in Units Break-Even Point in Revenues

Activity with formulae, explanation and example. Student worksheet Teacher Solution worksheet. Calculating: Contribution per Unit Break-Even Point in Units Break-Even Point in Revenues

Break-Even Forecast See the chart appear in Excel as calculations are completed. Break-Even the visual way. Teacher solution. Example evidence of student work. Student worksheet.

BTEC Business - Unit 2 Finance Topics included: Costs & Revenues, Break-Even, Cash Flow and Budgets Assessing: Definition, selection and calculations. Once completed and reviewed in DIRT (Direct Improvement & Reflection Time) lesson, will act as a revision resource. Easily adaptable for future testing in preparation for online test.

GCSE Computer Science - Programming Techniques : LO1: The use of records to store data LO2: The use of SQL to search for data Using the subject matter of a Year 11 Computer Science class, students learn how to create a table in a database, how to add individual records, how to add multiple records and then how to search for records. The extension task is then to create a database on a topic of their choice using the programming techniques shown in the walk-through-talk-through example. This lesson comes complete with notepad copies of the Python code with and without comments (just copy and paste code into Python).

A simple resource to help students remember how to convert from Hexadecimal into Decimal number (denary), and from Decimal number (denary) into Hexadecimal. As there are no calculators in the exam this year, it would help if students could refer to the 16 times table quickly when converting.

BTEC Tech Award in Digital Information Technology In the final revision for the Component 3 exam, I have put together a simple presentation with all the key areas from the Component 3 syllabus for topics that may come up in the exam. Added to these are tips from the recent mock exam students did based on the specimen exam paper. I hope this can helps some other students out there doing the BTEC TA DIT. Good luck to them all.