Key Stage 3 Computer Science CS1 Understanding Computers Scheme of Work and e-learning 'Working Document' with self-assessment differentiated checklist.

Model used for controlled assessments. Used with students midway through OCR 20 Programming Challenges, to get Year 10 students to reflect and focus on the different stages in the Programming Cycle of Assessment and the importance. Class discussion of each stage, followed by students explaining and evidencing each stage. This enables them to work at a higher level and to understand the process required in September.

Tricky Words Revision Resource A451 Computer Systems & Programming Get your students ready for the A451 exam with this keyword sheet. a) Circle the ones you don't understand b) Starter: Allocate a word to each member of the class, they need to explain it to the rest of the class c) Plenary: Choose a word, explain it to leave the lesson d) Home revision: You need to know what these words mean for the exam, Fill students with confidence by word recognition. Good luck to all your students in the exam.

In the previous Programming & Algorithms unit, students were introduced to programming concepts of sequence, selection and iteration using visual-based programming in Scratch. This unit is the bridge between visual-based programming and text-based programming, and uses a robot to perform tasks using a limited range of instructions (whilst introducing Python syntax). It is a good unit for re-iterating programming concepts, and also for the concept of 'efficiency' in writing code, using libraries, functions and other programming techniques. This unit uses the Reeborg website: http://reeborg.ca/reeborg.html to complete the Python challenges.

Revision lesson: Each revision lesson gets the students working independently for the first part of the lesson, followed by a review of the answers. A specific area of Component 1 is then revised, and the lesson concludes with a QWC question. If you have longer lessons, you could add in past exam questions from the A451 syllabus which are related. Independent questions: Memory and Storage Teacher-led revision: ELCE QWC question: Technology today

Scratch Christmas Story Scratch activity designed for Year 3 & 4 to introduce the concept of coding using blocks. Used Scratch 2 offline editor (Scratch.mtu) Program files can only be opened in Scratch, however the powerpoint instructions have all the required code in should you wish to use the online version.

Paired Discussion/Written-based Revisision Activity Discussion Cards for Component 3 - A2 Impact of Modern Technologies Peer: Read the card asking the same questions for each key concept: What is it? How is this relevant to business? Why is this relevant to me? Once discussion has taken place, the student then writes a paragraph summarising the discussion. Peer Support: Knowledge Organiser provides overview of topic. Golden Nuggets of key concept theory included in case prompting is needed in the discussion.

Paired Discussion/Written-based Revisision Activity Discussion Cards for Component 3 - D1 Forms of Notation Peer: Read the card asking the same questions for each key concept: What is it? How is this relevant to business? Why is this relevant to me? Once discussion has taken place, the student then writes a paragraph summarising the discussion. Peer Support: Knowledge Organiser provides overview of topic. Golden Nuggets of key concept theory included in case prompting is needed in the discussion.

Converting Hexadecimal to Denary (via Binary) A quick method of converting to hexadecimal to denary, via binary. Teacher solution and student worksheet included.

Preparation for the GCSE Computer Science 9-1 Paper 2. Reminders on how to do sorting, searching and data conversion. Student questions (differentiated - some with ‘methods’, some with additional pseudocode challenge) - Teacher solutions to main questions. DTT Revision - Key Areas: Data structures, errors, robustness and data types ( Therapy - as identified in mock exam).

As requested by my students to practice for their controlled assessment, prompt sheets for common tasks. Adding a record number to a file. Reading from, writing to, appending file. Lists, for loops and while loops. Troubleshooting Trees

A differentiated assessment to measure individual progress in introductory Python unit: Sequence, Selection and Iteration.

Use these as revision guides to help students prepare for the MySQL practical investigation for A452 Controlled Assessment (June 2017 submission)

Knowledge Build Cards for LA.A Online Services & Communication. Developing over the Summer term 2017. This resource includes the first 10 Knowledge Build Cards (15 minutes - Read & Answer differentiated questions). Small chunking of theory as start to lesson. Also included student working documents to answer the questions to the Knowledge Build Cards. LA.B and LA.C development by September 2017.

A final short unit for the end of Key Stage 3: Creating graphics for a smoothie company called Juicin'. This resource includes a working document for students and an introduction to the scenario.

Evaluate the usefulness and ease of use of maintaining a database with MySQL, compared with using Query By Example (QBE) In preparation for the A452 Controlled Assessment material 2, I created this activity so that students could see the difference between creating a resource in Microsoft Access compared with command line in MySQL. Worked well for them completing Task 9 of the controlled assessment

This lesson looks at how to create a decision tree for a problem to be solved in Python. The program then uses functions to search for keywords in user responses. The first function provides a response internal to the program whereas the second function looks externally and imports the information from a text file. As .py file extensions are not accepted, I have uploaded it as a text file - this simply needs copied and pasted into Python IDLE.

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.

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