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

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

By anthellison

Edexcel ICT GCSE  - Unit 1 Extended Answers Help

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

By anthellison

Sale
SQL

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.

By kevin_b_savage

Sale
Coding from algorithms

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

By kevin_b_savage

While Loops Starter

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.

By bw999

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

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

By Krazikas

Developing Computer Games Project Template - Based on Unit 25 TLM

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.

By moggga

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

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.

By moggga

List of programming techniques

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

By sekhon1976

iPad Success in Primary Education Workshop - Best Apps

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.

By biowriterab

Little Man Computer Introduction

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

By tjra

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

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.

By kellyocs

Database Revision/Homework Question 4

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.

By snegreid

Database Revision/Homework Question 3

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.

By snegreid

Database Revision/Homework Question 2

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.

By snegreid

Data Types Computing Science Doodle Notes

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>

By STEMthinking

Solid State Storage Computing Science Doodle Notes

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

By STEMthinking

Sale
OCR - AS-Level Computer Science - Bulk Resource Download

OCR - AS-Level Computer Science - Bulk Resource Download

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.

By r_chambers

Arbor Day: An Internet Activity

Arbor Day: An Internet Activity

Learn about the history of Arbor Day and all about trees with this web quest! There are 11 web questions, a Did You Know? section, comprehension questions and a teacher section with keys, additional links and lots(11 extension activities).This could also be something to use with EARTH DAY, when you are studying TREES and, of, course, for ARBOR DAY! Did you know that more than 30 countries in the world have a day to celebrate trees?Other resources that would go well during this time:1. Exploring the Ocean Blue: A Web quest, will introduce students to our oceans. There are nine informative web questions. Fun Facts, comprehension questions,extension activities and links are also provided as is the key. Can be used as part of a unit on oceans, for Earth Day, World Ocean Day or as an activity for a Friday, before a vacation break or as an end of the year activity. This can be a one day class resource or used for a couple of days depending on whether the activities(creative writing/art work/online simulation games, etc.) are used with the students. There are 9informative web questions. Fun Facts, comprehension questions,extension activities,links: Let's Explore the Oceans: A Webquest2. Learn about Jacques Cousteau with this Reader's Theater Script: Oceanographer, photographer,filmmaker, scientist, writer, inventor, Cousteau spent his life studying the oceans and the marine life that lived in the oceans. His books and films on his studies sparked much interest in our oceans and created an awareness about the need for marine conservation. Part of my Ms. Bie Ografee Talk Show Series where Jacques Cousteau is a guest on her talk show and answers questions of her studio audience. There are 10 audience questioners, a Did You Know? section, comprehension questions, a teacher section with extension activities, links and the key.Jacques Cousteau: A Reader's Theater Script3. Learn about the history of Earth Day and, our planet, EARTH, with this informative web quest. There are 15 web questions as well as comprehension questions and a Did You Know? fun fact section. The teacher page includes extension activities, the key, and additional links. EARTH DAY, A Webquest"4. A Biologist and marine zoologist, Carson’s books shared her love of nature, especially the ocean and its inhabitants. Her book, Silent Spring, sparked concern in how chemical pesticides were harming our environment. Carson helped to start the environmental movement in our country, which led to the creation of the U.S. Environmental Protection Agency. This Reader's Theater Script could be used as a STEM biography any time of year or especially during the time of Earth Day.Rachel Carson, A Reader's Theater Script

By gailhennessey

2. Data Casting & IF Statements (KS3 + KS4 Friendly)

2. Data Casting & IF Statements (KS3 + KS4 Friendly)

The second lesson in my Python scheme of work, this is aimed at building upon the introduction lesson and taking the students through the following:- Data Casting-If statements-Elif StatementsStudents will be challenged to complete some tasks alongside these, easy to follow and all set up for you to use! Reduce your planning time!

By msmarwaha