#### Scratch DIRT SHEET - Assessment

Created this DIRT sheet for my Year 8’s but can be used for any year group. SIMPLE TO FOLLOW Teacher can look through their scratch projects and tick the boxes the pupils have covered in their Project. Pupils can then reflect on their project and suggest improvements they could make.

#### Scratch Programming Fractal Tree Activity

One of the areas of the national curriculum that we should be introducing students to is RECURSION. This is an excellent activity to introduce that concept in a visual way with a simple task to create a fractal tree in Scratch programming. This activity I had a learning observation on. I had my students work in small groups to try and complete the main activity together. When they finished this, they were to research other fractal activities on-line and see what they could create. Students really enjoyed this activity at the end of the Scratch topic to introduce a very complex topic that is not part of GCSE, but that appears again at IB level and A level. I expect students to learn that recursion is a complex rule that simplifies programs, but is very difficult to understand and it is a function that uses itself to solve a problem.

#### Scratch Programming Test 2 + Answers

End of section test (I use with Y8 students) to assess their comprehension of coding using Scratch (I have uploaded my unit of work which goes with this. This is used a long with the assessment activity uploaded in the other unit of work, to check student progress. This is a problem solving assessment which tests students abilities to read and interpret code, as well as explain it. Checks their logical and computational thinking skills and ability to spot and correct errors.

#### [GCSE + IGCSE] Introduction to Algorithms (Problem Solving)

This is the unit that I complete before I start programming with my GCSE students. It features a variety of problem solving activities that I use to introduce Flow Charts and Pseudocode. This has massively helped my students understand the concepts and process of planning before progressing onto writing code. This covers a lot of the concepts of Unit 1 and Unit 2 from the curriculum. Introduces the ideas of Abstraction, Decomposition, Algorithms etc

#### [GCSE+IGCSE] Strings, Functions and Procedures Unit

This is my Strings, Functions and Procedures unit that I use in the lead up to the end of Term 1 at Christmas. It compromises 9 individual tasks. Each of these tasks, I take at least two lessons to deliver with students. I start off each with some starter questions (included file) and a discussion of the task. At this point, I would expect my students to be comfortable with planning in pseudcocode and flow charts. For each activity, I either get them to design it for Scratch, or I create a partially completed plan which they then fill in the blanks (These are usually hand drawn, so I didn’t include them) We then code the solutions which normally takes a full lesson. To support and challenge students, several activities contain challenging scenarios to keep better students engaged allowing me to support weaker students to aim towards completing minimum requirements. After we completely implement them, we spend time discussing test plans, the purpose of testing etc. This covers a lot of the theory in the course of looking at modular testing, why we use predefined functions/procedures, how large groups of programmers work together to decompose a task and implement it simultaneously etc. For each of the 9 activities included, I have included blank student files (when they are required) tested solutions for each activity and the overview of the task with instructions. For this activity, it will require a bit of teacher input to explain task at the beginning. At this point, I show students the completed activity, so they know what they are aiming to produce. For my weaker students, I give them a copy of the completed code (eventually) and get them to add internal commentary, or do testing. In some cases, I make simple syntax errors in it and get them to fix it. This activity booklet takes me around 8-10 weeks off 3 lessons per week. We use the Christmas themed lessons at the end, this introduces/recovers arrays, as well as some challenging problem solving that we all work on in groups to complete.

#### Excel Pivot Table Exercise / Task

This resource has been developed as a practice Exercise for learners who have been introduced to Pivot Tables in Excel. It is a practical task that can be undertaken in teams, pairs or individually. It includes a set of data that needs to be analysed. Learners are required to brainstorm questions that a Sales Manager would need to know about the transactional data. They then create pivot tables based on the questions. There is a second spreadsheet that contains 8 sample questions and pivot tables that relate to the questions. This activity has been well received in my classroom of adult learners. They become very engaged in the process and develop a better understanding of the use of pivot tables.

#### [GCSE Computer Science] 2D Arrays Introduction [IGCSE also]

A series of activities to introduce students to 2D arrays. This is an area my students regularly struggled with understanding the concept. This year their test results were much improved compared to my last year groups - I believe this is mainly down to spending more time on getting students to visualise where data is, how it is stored and accessed. We spent a week on this activity - discussing the theory at the beginning of the lesson, tracing the execution, coding the solutions and then practicing writing flow charts for the equivalent pseudocode. I also updated this to work with records, but I will upload as a separate resource,

#### Cluedo murder mystery riddle - adaptation from Einstein's '5 houses' logic puzzle

**Mr Black has been found dead at Tudor Manor. ** You are the lead investigating detective. You have all six suspects brought to the main hall of the mansion, seated next to each other around a circular table. Every one of them has a motive to murder Mr Black, but only one committed the crime. Can you solve the case and bring the killer to justice? Who killed Mr Black? What weapon was used? Where was the weapon hidden? This activity is an adaptation of mine based off Einstein’s ‘five houses’ logic problem Students extract relevant information from text; create an appropriate data structure to record these facts; and use a process of elimination to solve the problem I have been using it with KS4/5 Computer Science classes to demonstrate computational thinking (abstraction and decomposition)

#### [GCSE + IGCSE] Computer Science Programming (Visual Basic)

Advanced programming resources for teaching IGCSE + GCSE Computer Science and beyond This is also useful for anyone teaching IB Computer Science using Visual Basic 8 individual ‘activities’ with advanced challenges for each. More than 8 lessons work once I build in introduction, designing of the code and plenary reviews at end of lessons. Taking our time to build up skills, do traces on the code etc, each takes (or could take) three lessons to thoroughly cover the knowledge

#### WEBSITE Development Performance Assessment for Assignments > CHECKLIST & RUBRIC

This Checklists is a quick way to assess if a performance task has been completed according to the assignment objectives. Specifically designed for Web Development projects. Appropriate for creating original websites, or for redesigns. This checklist is a quick, accurate way to assess student knowledge. Teachers can evaluate projects using this Rubrics, and it can also be used to set student expectations. Standards Addressed Include: ~ Website Organization ~ Design and Technical Skills ~ Research and Validation ~ Communication and Navigation ~ Project Planning and Management

#### IGCSE Computer Science Records, Arrays, 2D arrays Tasks

Three different activities to introduce the concept of how data is stored in 2D arrays and records. Some complex problem solving to decrypt a short message using the Vigenere Cipher Covers some theory as why arrays are better than individual variables and how records and arrays differ.

#### Presentation: how to test a system (x11 slides)

The presentation introduces the idea behind testing and covers the ideas behind the idea of creating a test plan, difference between a fault and an error and shows a blue screen error. It describes the importance of reliability, using different test data (typical, erroneous, exaggerated data) and how to formulate a test plan.

#### KS3 Computing - Cryptography Unit of Work - Lesson Presentations, Worksheets and Assessment

This is a whole unit of work that this aimed at KS3 - it covers all aspects of Cryptography that the students have absolutely loved doing and this has been uploaded to Google Classroom and made the whole unit very interactive. The work is split into Flight Paths and contains an assessment. All work has stretch and challenge extension tasks too. This is a really enjoyable unit of work for about 6 weeks.

#### Computer Science: Programming with pseudocode and Python AQA (9-1) GCSE

Great for AQA (9-1) GCSE Computer Science revision and help with the programming project. This workbook covers the AQA GCSE Computer Science (8520) specification section 3.2 “Programming”. It includes a 116-page PDF document including theory, tasks and includes all the answers. Whenever possible pseudocode is shown alongside the Python code to allow students to compare the similarities and differences between them. Perfect for NQTs, non-specialist teachers or teachers who feel a little unsure about the qualification content and want to improve their subject knowledge. Also ideal as a teaching resource and covers programming in Python from the basics to more advanced techniques including writing to text files, 2D arrays and using subroutines. It also gives help on planning robust programs and testing programs along with the difference between an interpreter, a compiler and an assembler. Table of contents: Data types Variables and constants Iteration Selection Subroutines (procedures and functions Global and local variables Operators One-dimensional arrays Two-dimensional arrays Input and Output Reading from and writing to a text file String handling operations Random number generation Structuring programming Robust and secure programming Data Validation Creating a simple authentication routine Testing your programs Low-level and high-level languages Translators Other workbooks in this series: * Fundamentals of Algorithms GCSE revision student workbook Fundamentals of Data Representation GCSE revision student workbook * Computer Systems GCSE revision student workbook Fundamentals of Computer Networks GCSE revision student workbook Cyber Security GCSE revision student workbook Ethical, legal and environmental impacts

#### 9626 - AS Applied ICT - Unit 19 - Programming for the Web - Unit of Work, Assessment and Video

9626 - AS Applied ICT - Unit 19 - Programming for the Web - Unit of Work, Assessment and Video. Any issues downloading, email me at enderoth@hotmail.com

#### Cosmopolitan Coding - Fun INSET Introduction to Coding

Many teachers were never taught the coding and computer science elements of the new curriculum themselves. This introductory activity helps teachers understand the simplicity of using algorithms as instructions to complete tasks. Teachers will learn: Algorithms and how these are simple instructions Syntax and how this is simply known action in new language Problem solving and debugging code Testing code to see if it works Teachers love this INSET introduction!

#### Testing and Review Sheet

A double sided / 2-page document that is used for testing and peer reviewing a product or item. The testing and review is general purpose and can be applied to most items that have been developed or created, including programs / software. Aimed mainly at KS3 students but can also be used with KS4 students and easily adaptable if required.

#### KS3 Computational Thinking Project - Practical Problem Solving (Full Unit of Work)

**KS3 Computational Thinking Project - Practical Problem Solving (Full Unit of Work) ** This project is designed to either introduce computational thinking skills or to supplement and build on knowledge and skills already acquired. It is suggested that the student booklet is used in conjunction with the associated presentation through all of the lessons. The project has been designed so that is hands-on and practical. The suggested time frame from start to finish of the project is approximately 6-8 lessons, depending on what additional aspects the teacher wishes to introduce during the project. Students are asked to create a stationery holder using everyday objects. The problem has to be approached and solved using computational thinking skills. The project can be approached from a totally ‘unplugged’ pedagogy. No computers required! The resource consists of: a) A student booklet. This can be printed as an A4 or A5 booklet. b) A student booklet containing examplar responses. Also contains extension / homework tasks. c) A PowerPoint presentation for use in lessons to guide students and the teacher. Many of the slides have accompanying ‘speaker notes’ with ideas and suggestions for lessons. The project allows students to be very creative when they move on to the development (making) section of the project. Expect to have lots of fun and engagement!

#### Computing Design/Algorithm pro-formas (PDF and editable Word docx)

As described in my “Delve in, for twelve min!” video CPD, these are example pro-formas to give pupils to design their computing projects. These could be Scratch projects; animations, games, quizzes etc. The design process, which is largely missed in computing, forms an essential part of a coding project, and also provides many benefits in terms of AFL. Please use in conjunction with the training video, and also check out the entire “Delve in, for twelve min!” series: https://www.youtube.com/playlist?list=PL3kA-gpaSB2a6Vfdq04rGt5xcKQg8FG8x

#### New National 5 Software Design and Development Slides (2017/18 onwards)

This resource is a PowerPoint that covers all aspects of the new updated National 5 Computer Systems (2017/18 onwards). It matches to the new arrangements and provides slides on all the content within the following: Development methodologies Analysis Design Implementation (data types and structures) Implementation (computational constructs) Implementation (algorithm specification) Testing Evaluation These slides have worked wonderfully well with my class and have made new parts of National 5 much more accessible to my classes. I have included a PDF version as well. The Fonts I have used are called Fortuna Dot and Abscissa The programming language that I use in some of the slides in Visual Basic

#### GCSE Computing High and Low Level Languages Presentation

GCSE Computing High and Low Level Languages Presentation with Quiz. Great for lessons and teachers or student revision. Pack Includes Presentation, Script and Student Handouts. Based off the OCR (9-1) GCSE

#### Scratch Exercises for computational thinking

Build students ability to make independent progress and think computationally with a range of programming skills using scratch. Students will learn vital keywords required as fundamental building block for computer science GCSE. Each exercise is independent of each other. Challenges range from simple to difficult and students are encouraged to consider and compare alternative solutions. Solutions for each challenge is provided, easy to follow and understand even for a non specialist teacher. This series of exercises is targeted at KS3 students, although KS4 students will also benefit from it as a revision tool for GCSE computer science. It is strongly advised that these exercises are used after students are taught fundamental skills from algorithms in scratch series.

#### Mouse Maze - KS3 Algorithm Starter

Mouse Maze is a fun introduction to decomposition, algorithms and iteration (loops). It works well as an extended starter. Print out the simple maze, or distribute the PowerPoint file to students (the mouse icon can be dragged and rotated). They must list the steps required for Mousey to reach the cheese. Decomposition: breaking the problem into smaller steps (i.e. solving the maze) Algorithms: listing the steps to guide Mousey through the maze Iteration: making the algorithm more efficient by repeating parts of it (challenge / extension activity) The download includes: A full set of teacher’s instructions PowerPoint maze for students which can be used electronically or printed out PowerPoint 6 slides showing the task, solution, sections which are repeated, and a more efficient solution. The final slide has definitions of ‘algorithm’ and ‘decomposition’, plus a note to tell students that they have already achieved both during the lesson. Pupils enjoy the activity and it is a great way to introduce the concepts for the first time. I hope you and your pupils enjoy it :)

#### Computing for KS3 - Part 02 - History, Web Design and Creation and Human Computer Interface

Chapters 5-8 of the Computer-IT Computing Course, the Foundations of Computing, How the Web Works, Web Page Creation from the Ground Up and Human Computer Interface.

#### Python Programming - I CAN Statements

These I Can statements are perfect to guide your students to develop the necessary skills when learning to code/program using Python. The teacher or the student can tick off each I Can statement once they have demonstrated evidence for them. I Can statements fall under the following 4 categories: • Criteria 1: Planning • Criteria 2: Skills Development • Criteria 3: Explanation of Code • Criteria 4: Efficiency of Code

#### Computer Science: Algorithms AQA (9-1) GCSE revision and exam practice

Great for AQA (9-1) GCSE Computer Science revision and exam practice. This student revision workbook that covers ALL of the “Fundamentals of Algorithms” syllabus for AQA (9-1) GCSE Computer Science. Includes 82 pages covering the theory and giving lots of practical activities and even includes the answers Ideal as a GCSE revision aid or as a teaching resource. Perfect for NQTs, non-specialist teachers or teachers who feel a little unsure about the qualification content and want to improve their subject knowledge. Table of contents: • What are algorithms? • Decomposition • Abstraction • Basic Pseudocode • Arithmetic Operations • Relational Operators • Boolean Operators • Input and Output • Iteration • Selection • Nesting statements • Flowcharts • Trace Tables • Dealing with Arrays • Subroutines • Dealing with strings • ASCII and Unicode • Linear search • Binary Search • Compare the two search algorithms &lt; • Bubble Sort • Merge Sort • Compare the two sort algorithms Other student workbooks in this series include: Programming Fundamentals of Data Representation GCSE revision student workbook Computer Systems GCSE revision student workbook Computer Networks GCSE revision student workbook Cyber Security GCSE revision student workbook Ethical, legal and environmental impacts GCSE workbook

#### Computer Science Algos | Pseudos for 2210 | 0478

A set of 8-questions based on real-world scenarios that will make students to understand the situations where they can think and demonstrate their abilities to solve these worksheets. They can also be used to set an assessment. You can have it singly or the whole set. Prepared for CAIE 2210 and IGCSE 0478 Syllabus Components.

#### Algorithms | Pseudocode Part 8 | Worksheet

A set of 8-questions based on real-world scenarios that will make students to understand the situations where they can think and demonstrate their abilities to solve these worksheets. They can also be used to set an assessment. You can have it singly or the whole set.

#### Algorithms | Pseudocode Part 7 | Worksheet

A set of 8-questions based on real-world scenarios that will make students to understand the situations where they can think and demonstrate their abilities to solve these worksheets. They can also be used to set an assessment. You can have it singly or the whole set.

#### Algorithms | Pseudocode Part 6 | Worksheet

A set of 8-questions based on real-world scenarios that will make students to understand the situations where they can think and demonstrate their abilities to solve these worksheets. They can also be used to set an assessment. You can have it singly or the whole set.

#### Algorithms | Pseudocode Part 4 | Worksheet

A set of 8-questions based on real-world scenarios that will make students to understand the situations where they can think and demonstrate their abilities to solve these worksheets. They can also be used to set an assessment. You can have it singly or the whole set.

#### Algorithms | Pseudocode Part 2 | Worksheet

A set of 8-questions based on real-world scenarios that will make students to understand the situations where they can think and demonstrate their abilities to solve these worksheets. They can also be used to set an assessment. You can have it singly or the whole set.

#### Algorithms | Pseudocode Part 1 | Worksheet

A set of 8-questions based on real-world scenarios that will make students to understand the situations where they can think and demonstrate their abilities to solve these worksheets. They can also be used to set an assessment. You can have it singly or the whole set.

#### Scheme of work for Microbits

This document includes, a full Scheme of work for microbits. Please check my other products for lesson plans and other resources. Thanks

#### Visual Basic 6 FULL COURSE Software Development

A full unit of work utilising VB 6, Visual Basic programming language. PDF document of tasks/instructions included as well as all the starting files which students require

#### GCSE Run Length Encoding Programming Lesson tasks

This resource contains tasks for a complete programming lesson based on Run Length Encoding. If students have looked at the theory this lesson is a good follow up as it improves their programming skills and reinforces the theory learned previously. Included in this resource is a self-marking Excel starter document, and Powerpoint presentation for the lesson. The code with tasks is included for students to copy and paste into Visual Basic, or pseudocode for more of a challenge. EDITED: Now includes a basic Testing table in a Word document so the students can prove that their program is working and become familiar with the process for their coursework.

#### KS2 / KS3 Scratch superunit - introduction and follow-up unit

This bundle contains two units of work for Scratch, including at least 14 lessons in total (some may take longer, depending on programming speed). It can be broken down into two units, or potentially completed in one go. I have completed these with the same students over two years - the introductory unit in Y5 and then the second unit in Y6. However, this could be used with older children with little Scratch experience. The lessons conatined are as follows: Unit 1 Introduction to Scratch - algorithms Joke - sequencing Disco - sequencing / iteration Etch-a-sketch - controlling sprites Maze - Selection / iteration Assessment Unit 2 Flowcharts - algorithms Chatbot - sequencing / selection Scrolling maze - variables Falling fruit - indefinite iteration / variables Breakout - Variables / subroutines Rock, Paper, Scissors - Definite iteration / subroutines Assessment

#### KS2 / KS3 Scratch intermediate unit

This unit is designed to be used after the initial Scratch unit, and contains lessons on flowcharts, sequencing, selection, iteration, variables and subroutines. The games that will be made through this unit include: A chatbot A scrolling maze Falling Fruit game Breakout Rock, paper, scissors Following the flowcharts lesson, the students will complete the other lessons to create the above programs, and then finish with an assessment. The assessment says Y6 at the top as this was the year group I have used it with, but that is because my Y5s completed the introductory unit and so moved onto this in Y6. However, this could be used for KS2 or KS3, depending on programming and Scratch experience.

#### KS2 / KS3 Scratch Assessment

This assessment is similar but more advanced than the introductory Scratch unit assessment in my shop, and includes questions on subroutines and variables as well as algorithms, sequencing, selection and iteration. This is aimed at students who have completed two units of Scratch.

#### [GCSE/IGCSE] Introduction to Algorithms

I use this unit of work to introduce students to creating algorithms. We look at some classic AI problems which are a fun challenge to solve, as well as board games. This introduces students to flow charts and pseudocode, abstraction, decomposition whilst improving their Problem Solving and Logical Reasoning skills. Definitely can see an improvement in my current Y10 class who were introduced to this Unit in Y9