End of term activity comparing Scratch and Python. Lists Sequence Selection User Input Variables Output. Based on the 12 Days of Christmas songs. First 4 days completed in Scratch and Python to give the structure of the code for students to complete the challenge for the other 8 days. A bit of programming fun to end the term. (Python code included in notepad - copy and paste into Python; screenshots of Scratch code, in case the file won't open). Merry Christmas.

Unit of work looking at the modern technology used by organisations, the individual and society. Developing students skills in online software using Google Sites, this unit develops on from the unit on Modern Technologies.

By creating a Times Table Learning Game on Scratch, students can become familiar with key programming terms: Sequence Selection Iteration Variables Includes lesson powerpoint, student resource and Scratch quiz. Update: Additional resource added - screenshots of Scratch code for quiz in case you are not using Scratch 2 offline editor. Follow on lesson - Direct Reflection and Improvement Time. How much do they now understand.

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.

Once I have introduced the basics of the programming concepts, there are always students who the concept 'clicks' with and they are able to complete the program as other students work through at a slower pace. By having Challenge Cards on display in the class, as they finish a task, they can practice using the programming concept in independent challenges. Challenge tasks are used with Year 8 to develop the programming concepts introduced in the unit: Sequence, Lists, Selection and Iteration.

Written: Online World (LA.A) Practical: Unit 6 Graphics - Task 3 As the Year 10 become Year 11, I need to give them a mock exam. This tests their knowledge of Unit 1, and provides more coursework evidence for Unit 6 Digital Graphics. Solution to the Unit 1 mock exam now uploaded!

GCSE Computer Science/BTEC ICT/BTEC DTT An audio recording to use at the start of Computing lessons as students are logging on. Key terms: Internet, World Wide Web, ISP, DNS, Hosting

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: Storage, wired/wireless networks and legislation Teacher-led revision: Legislation QWC question: Application of legislation.

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.

Prepare students for the A452 Practical Investigation with MySQL (June 2017 submission) using these walk-through-talk-through guides I developed for my Year 10 class. Creating a database Creating tables Sorting and filtering tables Joining tables Creating queries on multiple tables

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

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

Converting numbers - a key skill for the A451 exam. Use these resources as 5 minute starters to engage students on arrival to lesson, and cover an important topic at the same time. More to follow as I develop these during the Autumn term.

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.

This worksheet is designed to give students practice converting numbers in denary, binary and hexadecimal conversion. Answer sheet provided showing working.

Incorporate functional skills into the new KS3 Computing curriculum - essential transferable skills for use in other curriculum areas. This is the scheme of work for the spreadsheet unit, with a self-assessment checklist and an end of unit test.

Differentiated self-assessment sheets for the main units in the new OCR GCSE Computer Science 9-1. Gauge the progress of students against their ability - Low Ability Pupils (LAP), Middle Ability Pupils (MAP), High Ability Pupils (HAP) and Most Able pupils (MA). Use as a progress check for students, and as a check for teachers that they are covering the content outlined in the OCR GCSE Computer Science 9-1 specification.

Establishing good practice in Computing from KS3, so that in KS4 the de Facto standards for programming and presenting work are already in place.

Differentiated checklists for KS3 Computing curriculum.