BTEC ICT - Online World Home Learning - Autumn 1 Comprehension exercise for the BTEC Information and Creative Technologies Unit 1 Online World Exam in November. Supports the follow criteria from the specification: Learning aim A - Online communication Learning aim C: Investigate issues with operating online

Integrate key programming skills for GCSE Computer Science 9-1 with a Christmas quiz in Python. Programming techniques: Iteration, selection, counter, functions, procedures, menus, lists, inputs and output. A bit of fun to end the term, whilst continuing to develop programming skills.

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.

Developed specifically for the BTEC Business - Unit 2 Business Finance Exam. Based directly on the BTEC Syllabus, it covers each element in bitesize chucks. A simple resource that can be used for independent revision, peer-to-peer Q&A and mix n’ match tasks. Golden Nugget Technique: Read a golden nugget. Read it again. Look away - what can you remember? Read it again - what did you forget? Read it again. Look away - have you remembered it yet? Repeat this process and learn the theory in little bitesize chunks Feedback from Parents Evening: “My child brought these home for revision. Even though I don’t understand the theory, I have the answers in front of me. I ask for a definition and compare his answers to those on the Golden Nugget. I can even give prompts because all the answers are there.”

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

Developed specifically for the GCSE Computer Science 9-1 Component 2 Exam. Based directly on the OCR Syllabus, it covers each element in bitesize chucks. A simple resource that can be used for independent revision, peer-to-peer Q&A and mix n’ match tasks. Golden Nugget Technique: Read a golden nugget. Read it again. Look away - what can you remember? Read it again - what did you forget? Read it again. Look away - have you remembered it yet? Repeat this process and learn the theory in little bitesize chunks Feedback from Parents Evening: “My child brought these home for revision. Even though I don’t understand the theory, I have the answers in front of me. I ask for a definition and compare his answers to those on the Golden Nugget. I can even give prompts because all the answers are there.”

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.

Developed specifically for the GCSE Computer Science 9-1 Component 1 Exam. Based directly on the OCR Syllabus, it covers each element in bitesize chucks. A simple resource that can be used for independent revision, peer-to-peer Q&A and mix n’ match tasks. Golden Nugget Technique: Read a golden nugget. Read it again. Look away - what can you remember? Read it again - what did you forget? Read it again. Look away - have you remembered it yet? Repeat this process and learn the theory in little bitesize chunks Feedback from Parents Evening: “My child brought these home for revision. Even though I don’t understand the theory, I have the answers in front of me. I ask for a definition and compare his answers to those on the Golden Nugget. I can even give prompts because all the answers are there.”

End of unit assessment for Python Introduction - The Basics. Differentiated for low, middle and high ability students. Supported by end of unit self-assessment checklist.

Knowledge Organisers for the Component 3 Topics. Flashcards created using the mindmaps on the Knowledge Organisers. Using flashcards to prompt students to discuss topics linked to specific business scenarios: Network Airbus The Royal Navy

Introduce students to BTEC Business or GCSE Business with this short induction unit. Develop a team ethos in the class from the outset, with The Pop Challenge. Bring a sense of competition to the class whilst introducing elements of marketing.

Student workbook (and teacher solution to exam style questions) 1.4 Wired & Wireless Networks Memory jogger - 'trigger words' Student task Key links to further revision OCR exam-style questions 1.5 Topologies & Protocols to follow soon.

Let’s Do It Activities Designed as lesson starters for component 2 - revision of the different methods for searching and sorting: Binary search, linear search, bubble sort, merge sort, merge sort lists and insertion sort. Each method is illustrated through worked examples and tips on how to search/sort with three practice questions that students can work on independently. In my lessons, I will have a folder with the solutions in so that students can self-mark once they have completed the activity. To follow shortly: Let’s Do It Activities for Programming Techniques.

With students, prior to assessment, we run a walk-through-talk-through lesson, where using a visualiser, we talk through the questions and then the teacher handwrites the answer explaining how they structure it. This has resulted in greater confidence displayed by students in the following assessment. As we have multiple teachers, a solution is provided with possible answers so that there is consistency in guidance given to students. Following the assessment, in the DIRT lesson, we go through a modelled answer to again show students how the teacher would have approached the actual assessment and things they should have picked up on when reading/answering the questions. This assessment is based on students having completed: Modern technologies, Impact of Modern Technologies, Cyber Security and ELCE Wider Impact. Another paper is currently also available for the year below, where they have so far studied: Modern Technologies, Impact of Modern Technologies.

3 Revision exercises for the BTEC Business Unit 2 Finance exam (also suitable for other Business Finance level 2 exams): Labelling or calculations Definitions Explanations linked to business Offering solutions Teacher solutions provided.

Help students to revise the concepts in the run up to the exam: Hand out a memory jogger: 1 minute (think), 1 minute (pair) then class discussion (share) A great way to revise a topic before getting them to attempt a previous exam question.

Learn to convert denary to binary to hexadecimal (and vice versa) using a simple method that reduces the amount of calculations a student has to do. This spreadsheet is designed with students in mind, showing them a fast and effective way to convert numbers without having to remember too many different stages in the calculation. Learning Objectives: To convert from binary to denary and vice versa To convert from binary to hexadecimal and vice versa Teacher PowerPoint and solution. Student worksheet for Excel. Coming shortly: To convert from hexadecimal to denary and vice versa

Unit 2 Business Finance All main elements assessed: Costs and revenues, break-even, cash flow, profit & loss, balance sheet. Aimed at the lower ability students who need a prompt in order to remember theory in order to apply, or need a reminder of the calculations (although can easily be adapted for more able by taking out the 'theory' and 'hints'. Based on an enterprise company the class are running this year.

A short check-test on Wired and Wireless networks. Teacher solution provided. An additional test of knowledge following mock exam weaknesses.

Common misconceptions from Year 11 Mock Exam - broken down into structure diagrams addressing key memory aids for these topics. Also includes a resource with sentence starters to help students structure answers when under pressure in exams. Hoping these resources can help other Year 11 students preparing for the GCSE Business exam. Good luck to them all.