Secondary computing resources

This support pack is designed to provide a stimulating, engaging and effective way of preparing both teachers and students for the Non-Examined Assessment Component of the 9-1 GCSE in computer science. The pack contains: Help sheet 1 - Creating a board game using Python - Includes a complete set of instructions Help sheet 2 - Creating a database using Python - Includes a complete set of instructions Help Sheet 3 - Menus, Lists and Exporting using Python - Includes a complete set of instructions Programming project Sample Task 1 - Archside Academy Detention Database. Including: • NEA sample project scenario • NEA sample student solution • NEA sample Python code Programming project Sample Task 2 - Quiz Board Game Including: • NEA sample project scenario • NEA sample student solution • NEA sample Python code

This flowchart shows the links between fixing errors and resilience and also that repeated practice leads on to mastery, the more programming is practiced, they better you will get! The flowchart algorithm can be used in classes as a discussion point and a display. The embedded graphic can be resized, printed, cut-out and stuck into exercise books as a reminder that making mistakes is OK, normal and part of the programming cycle.

This module is the fourth module in a series to cover the requirements of the Cambridge Information and Communication Technology syllabus 0417, and any other syllabus that requires an introduction to Access. This module is a PDF file It contains 92 pages It is in landscape format It has an aspect ration of 16:9 It has a menu system whereby users can click on an item in the menu and go to that item The user can then click on any page number to return to the menu It is in full colour Has been design especially for Tablets and Smartphones

Python Version 3: Variables and Memory This is a high resolution poster that shows Variables and Memory. This is ideal as a poster on the wall or as a quick reference for the students. It covers variables, initialise, assign, identifier and memory address locations. The zip files contains the poster in both high resolution for a poster on the wall and a lower resolution to print in the students books or to place on the students drive. Please have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of other Python teaching resources.

Computing / ICT KS 2/3 Create a PowerPoint time capsule This is a 22 page pdf unt of work with 9 hours of lesson plans. This includes the lesson plan, all templates and completed samples for this unit, as well as all learner support material. This can be easily adapted to suit just about any topic. This is a 22 page unit of work on how to create a time capsule using Microsoft PowerPoint, but can be used in Google Slides as well. (9 hours of lesson plans ) This includes the lesson plan and completed samples for this unit.

This is the third module in a series to cover the Cambridge Information and Communication Technology 0417. Is sutiable for any curriculum that requires knowledge and understanding of operating systems. It is a PDF file. It icontains 85 pages. Is in landscape format The aspect ratio is 16:9 Click on any item in the menu to be taken to that item. Click on any page number to be taken back to the menu. Is in full colour Has been designed for PC monitors and especially 10" tablets and smartphones. The aspect ration is 16:9.

J276 Programming project Sample Task 1 - Archside Academy Detention Database. Including: NEA sample project scenario NEA sample student solution NEA sample Python code

This resource teaches students about how to create a menu system, how to use lists and how to export data from a list to an external file. It takes about two to three hours to complete.

This resource can be used by students to create a simple database using lists. They also learn about creating a menu system. This resource takes around two to three hours to complete.

This resource can be used to teach students how to create a simple board game. It starts from the very basic idea of creating a grid to producing a complete game. It will take students two to three hours to complete.

Computing / ICT KS 2/3 Create a board game on how to become an entrepreneur This is an award winning entire unit of work using Publisher to create a board game on how to become an entrepreneur. (10 hours of lesson plans) This includes the lesson plan, all templates and completed samples for this unit, as well as all learner support material. This can be easily adapted to suit just about any topic. Unzip the file, keeping the format. Run the file in the project plan folder and everything is linked to this.

Computer Science new curriculum Python 3: Variables Lesson 2 with instructional videos These python version 3 units are ideal for students, non-specialist computing teachers, NQTs and any person that would like to learn how to program using Python. This course covers everything for GCSE (9-1) in Computer Science. Lesson outcome: To be able to create a number guessing game using variables, input and import random Lesson Aim: To introduce and use variables to create a number guessing game. This 1 hour lesson comprises of: the lesson plan, a complete Power Point with all teaching videos embedded , (This means that you do not need to know anything about Python, the students can watch the videos on their own or you can watch it as a class.), (The videos covers: variables, data types, constants, random and import.) differentiated exercises, and the completed python files Download all the files into the same folder and run Python 3 Power Point 3.variables Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit

This is a simulation intended to demonstrate the problem with encoding negative numbers in a computer system. It was created to use a starter activity with a sixth form class prior to teaching sign & magnitude, ones complement and twos complement encoding. The PowerPoint file includes instruction on slide 1. The rest of the ppt shows a dial such as you might find in a car odometer (or a combination lock, date stamp, etc) with numbers. The slides show they can be ‘dialed’ forwards or backwards. When dialled backwards past zero we get 9, not -1 because there is no negative symbol available. This is the same problem in a computer system. We have only 0 and 1, we don’t have a negative symbol available. So how do we ‘encode’ a negative number? It is also effective to have some code locks or date stamps available to give students to demonstrate the principle for themselves. This then leads into a problem solving discussion where the teacher can then introduce the idea of sign & magnitude one ones/twos complement.

PowerPoint presentations that correspond to each (exam-based) topic in the AQA GCSE Computer Science course (separate folders for components 1 and 2). The set contains all the content needed to sit the two exams. The presentations start with learning objectives, then the topic content (with slide notes), interspersed with questions, and ending with key points. These presentations are modified and extended from those I used to create these playlists (Paper 1 and Paper 2) so there you can see the style and what is included, and some of the feedback I’ve received from students and teachers in the comment sections of those videos. The presentations are intended in their raw form for revision due to their concise nature and unwavering coverage of the specification, but they can be easily adapted to be just the base theory of a lesson. They will be especially useful for those new to teaching this qualification or those looking to build on previous resources. The individual presentations are compressed into a single .zip file, and I can be contacted at tutorcomputerscience@gmail.com if there are any issues/ any additional questions.

PowerPoint presentations that correspond to each topic in the AQA GCSE Computer Science ‘Written Assessment’ component (Paper 2, in other words). The set contains all the content needed to sit the component 2 exam. The presentations start with learning objectives, then the topic content (with slide notes), interspersed with questions, and ending with key points. These presentations are modified and extended from those I used to create this playlist so there you can see the style and what is included, and some of the feedback I’ve received from students and teachers in the comment sections of those videos. The presentations are intended in their raw form for revision due to their concise nature and unwavering coverage of the specification, but they can be easily adapted to be just the base theory of a lesson. The individual presentations are compressed into a single .zip file, and I can be contacted at tutorcomputerscience@gmail.com if there are any issues/ any additional questions.

PowerPoint presentations that correspond to each topic in the AQA GCSE Computer Science ‘Computational Thinking and Problem-Solving’ component (Paper 1, in other words). The set contains all the content needed to sit the component 1 exam. The presentations start with learning objectives, then the topic content (with slide notes), interspersed with questions, and ending with key points. These presentations are modified and extended from those I used to create this playlist so there you can see the style and what is included, and some of the feedback I’ve received from students and teachers in the comment sections of those videos. The presentations are intended in their raw form for revision due to their concise nature and unwavering coverage of the specification, but they can be easily adapted to be just the base theory of a lesson. The individual presentations are compressed into a single .zip file, and I can be contacted at tutorcomputerscience@gmail.com if there are any issues/ any additional questions.

Here is the resource I have been using to deliver R085. It has been put together having taught similar units by OCR and I have corresponded with OCR via their online questioning facility to confirm delivery methods are correct. Notes have been added in the notes section where relevant. The resource has been used by other teachers within our centre who are non specialist and they have found it easy to deliver.

Here is the resource I have been using to deliver R085. It has been put together having taught similar units by OCR and I have corresponded with OCR via their online questioning facility to confirm delivery methods are correct. Notes have been added in the notes section where relevant. The resource has been used by other teachers within our centre who are non specialist and they have found it easy to deliver.

Here is the resource I have been using to deliver R085. It has been put together having taught similar units by OCR and I have corresponded with OCR via their online questioning facility to confirm delivery methods are correct. Notes have been added in the notes section where relevant. The resource has been used by other teachers within our centre who are non specialist and they have found it easy to deliver. In quick summary it covers how to make sure the folder structure, how to develop detailed concept designs and has a full visualisation diagram example etc. I have also provided a list of what I believe needs to be on the website in order to gain MB3 e.g. google maps, HTML Fragments etc. *** You are more than welcome to message me if you have any questions on delivery ***

These resource has been produced to teach KS2/KS3 students about programming concepts by creating fun games using the text-based programming language Python. The activities and challenges have been designed to provide a stimulating, engaging and effective way of improving students’ knowledge of the core programming concepts.

Computer Science new curriculum Python 3: Variables with instructional videos These python version 3 units are ideal for students, non-specialist computing teachers, NQTs and any person that would like to learn how to program using Python. This course covers everything for GCSE (9-1) in Computer Science. Lesson outcome: To be able to use different data type variables, create a flowchart and pseudocode for creating a number guessing game. Lesson Aim: To introduce and use variables. This 1 hour lesson comprises of: the lesson plan, a complete Power Point with all teaching videos embedded , (This means that you do not need to know anything about Python, the students can watch the videos on their own or you can watch it as a class.), (The videos covers: variables, data types, flowcharts and pseudocode.) differentiated exercises, and the completed flowchart and pseudocode Download all the files into the same folder and run Python 3 Power Point 3.variables Have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of each unit

This photocopiable resource has been produced to provide KS2 and KS3 students with exciting and engaging opportunities to learn coding concepts using Python in a fun standalone project. Students learn about the random module, while loops, IF functions and variables. The project takes around one hour to complete and includes a series of activities to extend learning.

This photocopiable resource has been produced to provide KS2 and KS3 students with exciting and engaging opportunities to learn coding concepts using Python in a fun standalone project. Mystery of the Crystal Ball - Students have fun looking into their future. Students learn to use the time and random modules, Variables and IF-ELIF statements. The project takes around one hour to complete and includes a series of activities to extend learning.

This photocopiable resource has been produced to provide KS2 and KS3 students with exciting and engaging opportunities to learn coding concepts using Python in a fun standalone project. Guess the number -Students have fun making a game to guess the number. They learn to use IF-ELSE Statements, the random module, variables and nested IFs. The project takes around one hour to complete and includes a series of activities to extend learning.

ICT KS 2/3 Play the Stock Exchange using Excel or Google Sheets This is a 26 page unit of work on playing the London Stock Exchange using Microsoft Excel or Google Sheets. (8 hours of lesson plans with formal assessment at the end) It includes extensive lesson plans, completed samples and everything you need to run this module.

This photocopiable resource has been produced to provide KS2 and KS3 students with exciting and engaging opportunities to learn coding concepts using Python in a fun standalone project. Play the name game - Students have fun with their name. Students learn about print statements and manipulating text. The project takes around 30 minutes to complete and includes activities to extend learning.

This photocopiable resource has been produced to provide KS2 and KS3 students with exciting and engaging opportunities to learn coding concepts using Scratch in a series of 4 fun standalone projects. The projects are: Game 1 - Burst that Balloon- Students create a balloon game. They must burst the balloons to score points. Game 2 – Pong - Students create the traditional one player game of Pong. Game 3 – Frog Fun - The frog has to catch the butterflies to score points and must avoid the ladybirds. Game 4 - Catch the Birdy - The Scratch cat is being chased by an angry dog. The cat must catch the birds that are flying by whilst at the same time avoid the dog. Each project takes about an hour to complete and all of them include a series of challenges.

Python Version 3: Data Types This is a high resolution poster that shows the different data types in Python Version 3. This is ideal as a poster on the wall or as a quick reference for the students. The zip files contains the poster in both high resolution for a wall poster and a lower resolution to print in the students books or to place on the students drive. Please have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of other Python teaching resources.

A presentation outlining the first 7 lessons but can be adapated to cover more based on the detail on student writing and interaction. Covers Learning aim A.

This booklet contains related books, movies and TV shows to support students with a wider undestanding of the topic. It also includes activites which they can complete on their own and a guide to key words which is related to the specification. It can be given as holiday homework or throughout the year to support lessons. It only covers a few topics which can be self taught and is relevant to the exam.

This is a work-in-progress I would appreciate feedback and suggestions for further development to make it as useful for CS teachers as possible. Intended for: TEACHERS of IGCSE Cambridge Computer Science Purpose: You want to quickly gather a set of past exam paper questions on the topic you’ve been teaching in IGCSE Computer Science. But there are so many past papers and you have to look through each one to decide which questions are appropriate. With this (unfinished as yet!) tool, you can select your syllabus topic and you’ll see which papers and question numbers you need to assign to students.

Assembly presentation to launch and promote a Scratch Christmas Card Competition to help promote coding and computing at your school.

This resource pack contains everything you need to get started with Digital Leaders in your school. Application form, assembly presentation, FAQ, rota and log. @codeyjody

ICT KS 2/3 Start a company unit of work This is a 19 page unit of work on how to start a company using Word, Paint / Paint dot Net (11 hours of lesson plans with formal assessment at the end) This includes the lesson plan, all templates and completed samples for this unit. It includes creating your own logo, business card, letterhead, advertising and creating a brochure.

**Python Version 3: Variable, value and statements ** This is a high resolution poster that shows the Variable, value and statements in Python Version 3. This is ideal as a poster on the wall or as a quick reference for the students. The zip files contains the poster in both high resolution for a poster and a lower resolution to print in the students books or to place on the students drive. Please have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of other Python teaching resources.

Python Version 3: Reserved words This is a high resolution poster that shows the various reserved words in Python Version 3. This is ideal as a poster on the wall or as a quick reference for the students. The zip files contains the poster in both high resolution for a poster and a lower resolution to print in the students books or to place on the students drive. Please have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of other Python teaching resources.

Python Version 3: Variable rules This is a high resolution poster that shows the various variable rules in Python Version 3. This is ideal as a poster on the wall or as an A4 quick reference for the students. The zip files contains the poster in both high resolution for a poster and a lower resolution to print in the students books. Please have a look at https://www.tes.com/teaching-resource/python-version-3-sample-11943102 for a sample of other Python teaching resources.

These workbooks cover EVERYTHING outlined in the OCE specification for component 1 of the GCSE in Computer Science for OCR (J276/01) It includes the following workbooks: 1.1 System architecture 1.2 Memory and 1.3 Storage (combined into one workbook) 1.4 Wired and wireless networks 1.5 Network topologies, protocols and layers 1.6 System security 1.7 Systems software 1.8 Ethical, legal, cultural and environmental concerns Each PDF workbook includes theory, tasks and all the answers so you and your students are confident you are covering the specification. Ideal for classwork, as homework tasks and as self-study revision aids. They are written in student-friendly language which breaks down technical topics into easy to understand chunks making these workbooks perfect for students, NQTs and non-specialist teachers.

This student workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about the ethical, legal, cultural and environmental concerns with technology to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.8 Ethical, Legal, Cultural and Environmental concerns” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 41-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: • How to investigate and discuss Computer Science technologies • Ethical issues • Asking ethical questions • Legal issues • Cultural issues • Environmental issues • Privacy issues • How key stakeholders are affected by technologies • Environmental impact of Computer Science • Manufacturing technology • Transporting technology • Using and charging the technology • Disposing of technology • Cloud computing • Energy efficient • Flexible working • Cultural implications of Computer Science • Healthcare apps • Review culture • Open source vs proprietary software • Legislation relevant to Computer Science • The Data Protection Act 1998 • The Computer Misuse Act 1990 • The Copyright, Designs and Patents Act 1988 • Creative Commons Licensing • The Freedom of Information Act 2000

Alice is an innovative block-based programming environment that makes it easy to create animations, build interactive narratives, or program simple games in 3D. Unlike many of the puzzle-based coding applications Alice motivates learning through creative exploration. Alice is designed to teach logical and computational thinking skills, fundamental principles of programming and to be a first exposure to object-oriented programming. The Alice Project provides supplemental tools and materials for teaching using Alice across a spectrum of ages and subject matter with proven benefits in engaging and retaining diverse and underserved groups in computer science education. source: https://www.alice.org/ Contents include a PowerPoint Getting started with Alice, print screens and activities

A Microsoft Excel worksheet activity which tests students’ knowledge on the following skills: Cell referencing Use of formulae/calculations such as subtraction and multiplication. Making predictions by changing data Use of Sum() function What if questions Use this superb resource as a simple warm up exercise or to teach new skills. Answer Key included.

This resource encourages students to interpret data in tally chart to then enter into a Excel Spreadsheet. Students are then expected to read the instructions on their worksheet to either add to or modify their spreadsheet. This resource covers the following skills: Entering data Writing and entering formulae. Formatting spreadsheets Creating graphs and charts