# High School computing lesson plans and activities

Resources and ideas for computing, written by teachers to support teaching and learning

Sale

#### 18 ICT/Computing Theory Lessons & Homework Booklets

When these booklets are printed you have 8 theory lessons primarily based on the BBC Bitesize website.Follow the bitesize online pages and activities and complete the task sheets. Homework can be completed on the homework booklet.They have been designed to be used without computers and there are enough lessons for 1 every 2 weeks.Hope they are useful

#### Edexcel ICT GCSE - Unit 1 Extended Answers Help

These past exam questions formatted in writing frames will help students answer 6 mark questions. Hopefully gets the pupils thinking about the structure as well as the number of points that need to be made. Created for Unit 1 - Living in a digital world

#### Edexcel ICT GCSE - Unit 1 Keyword Flash Cards

All keywords from the Edexcel text book for use with the GCSE ICT - Unit 1 - Living in a digital world

#### Edexcel GCSE ICT Unit 1

Revision Mind Maps for Edexcel GCSE ICT Unit 1
Sale

#### SQL

Structured Query Language (SQL) is the most widely used database query language in the world. In this investigation we look at:• the basic syntax of SQL• selecting columns and rows from a table• special operators: IN, BETWEEN, LIKE, etc.• updating an SQL database• subqueries and diagramming subqueries• processing of data in queries: arithmetic operators, functions, sorting, grouping• joining tables, including same-table joins• relational algebra terminology.This unit includes six classroom tested activities involving over 100 query questions (with answers) to reinforce the concepts learnt. The three databases used are avaialble as a free download on the title page.
Sale

#### Coding from algorithms

This bundle goes from the basics of setting up a use-friendly interface, through how to develop an algorithmic solution to a problem, and finishes with the basics of building computer program from first principles. (See individual titles for more detail.)

#### While Loops Starter

Three tasks in Scratch to introduce students to the while loop. Students must complete the while loop by inserting the correct code blocks in Scratch. Suitable for KS2/KS3 Computing or as a refresher/introduction for KS4.
Sale

#### TES Author Resource - Excel Sales and Accounts Tracker and Workbook

This is a resource for authors to keep an account of the numbers of sales and earnings each day. It will provide valuable data which will help to inform authors how to most effectively manage their business and, hopefully, show the growth and trends in their business. This excel work-book willKeep accounts of daily / weekly / monthly and yearly sales figures and numbers of products sold Record sales figures in graph formatProvide real-time averages of products sold and sales figures for each day of the weekProvide real-time averages of products sold and sales figures for each week of the yearProvide real-time averages of products sold and sales figures for each month of the yearProvide real-time averages of products sold and sales figures for each yearIt will enable authors to analyse Which days are the best for salesHow TES sales or individual sales impact on numbers of products sold Observe trends in sales throughout the yearThe workbook has been set up to input figures from September 2016 until December 2021.Other Resources for AuthorsHow to Become a Successful TES Author: Step by Step GuideTES Author Calendar and Planner

#### A Level / GCSE (9-1) Computer Science Logic Gates, Masks, Binary Logical Shifts Worksheet

Double sided worksheet covering:Logical Shifts and their effectsLogic Gates (AND, OR, NOT, XOR, NOR, NAND)Masking with logical operatorsAll included in the NEW GCSE spec and in A Level Computer ScienceIdeal for revision, securing understanding, cover work

#### GCSE (9-1) Computer Science Research Templates - Ideal Cover Work - System Security, Protocols, Law

Three files that students can use to store their research on the following topics from the OCR GCSE (9-1) spec:System SecurityNetwork ProtocolsLegislation relevant to Computer ScienceIdeal research lesson if cover work is required.

#### Developing Computer Games Project Template - Based on Unit 25 TLM

A Word document with sections relating to:Working out file sizes of images.Using co-ordinates.Looking at an existing game and looking for the decisions that need to be madeMake your own game with 3 decisionsModify a gameLegal issues related to modifying code (Open Source, Copyright and Patents Act)The document is set of tasks that pupils must provide evidence that they have completed. It does not teach students how to create the game.

#### Computer Science Starters Bundle GCSE

6 Starters for computer science lessonsWord searchesPicture cluesFile typesKeywordsRepresenting DataCrossword

#### Computer Science Starter Worksheet - Acronym Challenge & Spot the Variables from football image

Double sided worksheetSide 1: Two images taken from football related computer games. Task is to spot variables and state a suitable data typeSide 2: A whole load of computing acronyms. What do they stand for?

#### A Level / GCSE (9-1) Computer Science / Computing Programming Techniques Worksheet

An A3 (but works in A4) double sided worksheet for Computer Science. The overall topic is 'Programming Techniques' and includes tasks such as:Describe Key TermsData Types3 Basic ConstructsOperatorsFlowchart SymbolsSpotting iterations/conditions in codeRewriting loopsString ManipulationProgramming Standards.Good for general revision - Used with both A level and GCSE groups before Mocks.

#### Easter ICT/Computing Activities

A selection of activities for students to pick from.

#### Revision on a page - Basics parts of a spreadsheet`

Aimed at beginner level this is a summary condensed onto 1 visual page. It covers: -Key terminologyFormatting featuresGraphs and chartsBasic formulae and functions

#### List of programming techniques

List of all the programming techniques required for GCSE and A Level Computing; what do the students need to learn or show as part of the evidence in controlled assessments or Computing courseworks

#### iPad Success in Primary Education Workshop - Best Apps

This resource is presented as a PowerPoint with full notes on each slide. It has been created as a training resource for teachers. It also includes practical exercises and activities that showcase how to use the apps for educational purposes. It is very graphic and covers the following apps that are suitable for primary and below level:Pic Collage (makes collages out of photos and pictures)Book Creator (create stories) iBooks – viewing booksPuppet Pals (animation / recording)Popplet (mind mapping)Showme (Interactive Whiteboard)Most apps are easy to use. It’s Using apps effectively and with purpose that is the crucial step.

#### Little Man Computer Introduction

A basic introduction to how the Little Man Computer works. This is intended to be used with OCR GCSE Computing for Unit A452 - Practical investigation. The links on the VLE are simply ones from the website referenced in the controlled assessment guidance: http://www.atkinson.yorku.ca/~sychen/research/LMC/LMCHome.html
Sale

#### Creating an Australian Aboriginal style 'Dot' painting in Microsoft Word

Instructions for creating an Australian Aboriginal style 'Dot' painting using the drawing tools in Microsoft Word. This resource will assist middle school art teachers in fulfilling the mandatory programming requirements in Visual Arts to do with both the study of Indigenous Australian Art and the use of Computing Technologies in Visual Arts (Australian Curriculum). It can be presented as a hand out for self-paced learning or kept by the teacher as a resource for guided instruction. The sample image in pdf format for digital display is also included. Please complete a review of this resource if you have found it useful.

#### Computer Science Starter Worksheet (Use pics to find key term + Odd one out)

Double sided worksheetGCSE / A Level / KS3 Computer Science Starter WorksheetSide 1 (Guess the key term based on 4 picture clues)Side 2(Work out the odd one out from 4 picture/word clues)

#### Database Revision/Homework Question 4

A 14 mark database homework/revision question covering:Entity Relationship DiagramsData DictionariesCompound and Surrogate keysUse of Forms and ReportsNote that two versions of the question have been uploaded. One contains a simple ERD (entities and relationship) and the other contains a more complex ERD (also including attributes)Written for the Scottish Higher course but valid for all intermediate level Database units.My students found this very useful.Question 4 of 6.

#### Database Revision/Homework Question 3

An 11 mark database homework/revision question covering:Field TypesInput Validation (including Restricted Choice)Primary and Foreign keysModification ErrorsSorting on Two FieldsWritten for the Scottish National 5 course but valid for all introductory Database units.My students found this very useful.Question 3 of 6.

#### Database Revision/Homework Question 2

A 15 mark database homework/revision question covering:Update ErrorsField TypesPrimary and Foreign Keys to Link TablesPresence CheckSearchingWritten for the Scottish National 5 course but valid for all introductory Database units.My students found this very useful.Question 2 of 6.

#### Data Types Computing Science Doodle Notes

Data Types Computing Science Doodle NotesThese notes will help your students to review the basic definition of the following data types:- integer- real- character- string- booleanStudents color and complete and then add to their own notebook.No prep- just print and go!More computing science resources coming soon!You might also like:Cache Memory Doodle Notes RAM and ROM Doodle Notes/a&gt;

#### Solid State Storage Computing Science Doodle Notes

Solid State Storage Computing Science Doodle NotesThese notes will help your students to review the basic properties and advantages of solid state storage devicesStudents colour and complete and then add to their own notebook.No prep- just print and go!More computing science resources coming soon!You might also like:Cache Memory Doodle NotesRAM and ROM Doodle Notes
Sale

There are a bulk load of computer science resources here including the following topics:* Testing* Operating Systems* Lossy Vs Lossless* Logic Gates / Boolean / Karnaugh Maps* Exam questions and answers* Exam questions and answers V2* Data structures - Tuples / Lists etc.. * Branching and Selection* Computer Science - MethodologiesSome of these presentations link to my YouTube channel where I have included videos to help you deliver the content.