Little Man Computer IntroductionQuick View
tjratjra

Little Man Computer Introduction

(6)
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
Python - Data Types WorksheetQuick View
tjratjra

Python - Data Types Worksheet

(10)
A simple resource for a single lesson. Students should be able to follow the instructions independently and complete it to show an understanding of the difference between strings, integers, float and Boolean data types.
Spreadsheets - Graphs & Charts (ideal for ECDL)Quick View
tjratjra

Spreadsheets - Graphs & Charts (ideal for ECDL)

(1)
A spreadsheet worksheet that can be easily marked (it self-marks for half of it). Students can mostly work through it independently - it introduces them to the concept of using charts and graphs in Excel. We use it as a lesson prior to the Excel ECDL exam. There are four tabs at the bottom: Starter: This follows on from my IF/COUNT/ROUND worksheet (available on TES) to see how much students remember. It self-marks. Task 1: This checks that students can format a chart and understand the link between the data and what is visually represented. Task 2: This gives students the opportunity to use modelling to put different values into a table to get the correct graph displayed. It self-marks. Task 3: This asks students to represent data in specific ways and gives them examples of what the charts should look like so they can self or peer assess. The data is given to them in a table and they are told what should be output. If they can manage this successfully then they should be able to tackle the ECDL exam charts without any problems! This should take most students 45-60 minutes to complete. It has been tested on a number of mixed-ability classes.
SQL Basic CommandsQuick View
tjratjra

SQL Basic Commands

(10)
A set of worksheets for us with SQLZoo and w3schools websites. They give some structure to the tasks that students can work through. These are intended to be used with the Edexcel Computer Science GCSE specification.
Small Basic - Entire Unit Resources (easy to use!)Quick View
tjratjra

Small Basic - Entire Unit Resources (easy to use!)

(2)
An entire unit of work for use with the program Small Basic suitable for Key Stage 3 (we deliver this to Year 8). It is a great (and free!) program to use if you want students to progress from block-based programming (such as Scratch) onto text-based programming. This contains: 7 lessons work, including a DIRT lesson in the middle for students to work on an area they need to improve on A full and detailed scheme of work with information about numeracy, literacy and a lesson plan for each lesson A two-part workbook (the DIRT lesson goes in between) as two separate DOC files, and the complete workbook if that is preferred. Clear extension tasks for all students in all lessons. 3 Homework worksheets Powerpoint presentations for all lessons We have had a few non-specialists in the department so this unit of work was designed to be easily accessible and clear for everyone to use - you should (hopefully!) be able to pick this up and teach it without too much preparation beyond the amount you would usually do for a lesson.
Python - Independent Challenges (Basic)Quick View
tjratjra

Python - Independent Challenges (Basic)

(11)
A short workbook which has a series of challenges which students can try to tackle independently after learning basic programming techniques. For each challenge, students are expected to draw a flowchart, write some pseudocode and then attempt to code it themselves. We print the booklets out and get students to print/cut/glue their code in, but they could complete them electronically. At the back of the booklet there is a section with helpful syntax tips - these are linked to each challenge (for example, Challenge 1 needs "INPUT" and "VARIABLE" so the student can refer to these sections at the back).
Cybersecurity &The Internet - 8 Lesson Workbook and Resources (easy to use!)Quick View
tjratjra

Cybersecurity &The Internet - 8 Lesson Workbook and Resources (easy to use!)

(0)
Includes a workbook of 16 A4 pages and 8 lessons with full links to resources, extension tasks and teacher Powerpoints to lead the lessons. Designed for non-specialists teaching GCSE or Key Stage 3 Computer Science. Lessons 1. Validation & Authentication 2. Cyberattacks 1 3. Cyberattacks 2 4. Preventing Cyberattacks 5. DIRT lesson (with examples of feedback to copy-and-paste) 6. Software Security 7. The Internet 8. The World Wide Web Included: 6 Full Teacher Powerpoints with videos and clear explanations of concepts. A well designed and clear workbook which students can work independently from on the computer or printed if they wish, with a range of different types of activities to ensure engagement. Documents and links for students to check their answers and understanding, including higher level case studies for those who wish to extend their learning. A glossary for students to check their understanding of keywords.
IGCSE (9-1) Computer Science - Knowledge Organiser bundleQuick View
tjratjra

IGCSE (9-1) Computer Science - Knowledge Organiser bundle

(0)
A set of 8 Knowledge Organisers which cover the entire syllabus for the 0478 and 0984 IGCSE Computer Science specifications. These took a long time to make but I have had fantastic feedback and reception from my students, who said they were really useful for their revision. These can also be downloaded individually at £3 (see my TES author shop), so this bundle is great value!
Spreadsheets - IF, ROUND, COUNT and COUNTA (ideal for ECDL)Quick View
tjratjra

Spreadsheets - IF, ROUND, COUNT and COUNTA (ideal for ECDL)

(0)
A spreadsheet task with clear explanations and self-marking short tests on how to use the following: Operators (greater than, less than etc) IF function ROUND function COUNT function COUNTA function The different tasks are available as tabs at the bottom and have been tested thoroughly. Students should be able to work through it independently (reading the guide then attempting the functions themselves) as it self-marks for most of the tasks. This was created for the ECDL qualification (Excel) but would be suitable for any lesson teaching functions.
Binary - 6 Lesson Workbook and Resources (easy to use!)Quick View
tjratjra

Binary - 6 Lesson Workbook and Resources (easy to use!)

(0)
Includes a workbook of 15 A4 pages and 6 lessons with full links to resources, extension tasks and teacher Powerpoints to lead the lessons. *Also included is a full 75-mark assessment on the topic with answers. *Designed for non-specialists teaching GCSE or Key Stage 3 Computer Science. Lessons Converting between binary and denary numbers Adding binary numbers together Using Sign & Magnitude Using Two’s Complement Using Logical and Arithmetic Shifts Converting to and from Hexadecimal Assessment Included: A well designed and clear workbook which students can work independently from on the computer or printed if they wish, with a range of different types of activities to ensure engagement. A glossary for students to check their understanding of keywords. A self-evaluation on the front of the booklet so students can check their own progress (useful for the teacher too) Full answers to all questions in the workbook Full 75-mark assessment and answers
Data (ASCII, Images & Sound) - 5 Lesson Workbook and Resources (easy to use!)Quick View
tjratjra

Data (ASCII, Images & Sound) - 5 Lesson Workbook and Resources (easy to use!)

(0)
Includes a workbook of 15 A4 pages and 5 lessons with full links to resources, extension tasks and teacher Powerpoints to lead the lessons. Designed for non-specialists teaching GCSE or Key Stage 3 Computer Science. Lessons Data Introduction (Analogue and Digital) ASCII Images & Binary Colour Depth & Resolution Sound & Binary Included: A well designed and clear workbook which students can work independently from on the computer or printed if they wish, with a range of different types of activities and keyword scaffolding to ensure engagement. A glossary for students to check their understanding of keywords. A self-evaluation on the front of the booklet so students can check their own progress (useful for the teacher too) A number of extension activities at the end of the booklet to help students who move ahead quicker and/or want to consolidate their notes
Databases (including SQL), Compression & Encryption - 7 Lesson Workbook (easy to use!)Quick View
tjratjra

Databases (including SQL), Compression & Encryption - 7 Lesson Workbook (easy to use!)

(0)
Includes a workbook of 23 A4 pages and 6 lessons with full links to resources, extension tasks and teacher Powerpoints to lead the lessons. *Also included is a full 60-mark assessment on the topic with answers. *Designed for non-specialists teaching GCSE or Key Stage 3 Computer Science. Lessons Introduction to databases Linked databases Introduction to SQL Lossy and lossless compression Run-Length Encoding Encryption and Caesar Ciphers Included: A well designed and clear workbook which students can work independently from on the computer or printed if they wish, with a range of different types of activities to ensure engagement. SQL extension taks for more able learners A self-evaluation on the front of the booklet so students can check their own progress (useful for the teacher too) Mini-test on key database concepts using exam-style questions (answers provided) Full 60-mark assessment and answers
Software - 6 Lesson Workbook (easy to use!)Quick View
tjratjra

Software - 6 Lesson Workbook (easy to use!)

(0)
Includes a workbook of 18 A4 pages and 6 lessons with full links to resources, extension tasks and teacher Powerpoints to lead the lessons. Designed for non-specialists teaching GCSE or Key Stage 3 Computer Science. Lessons Introduction to Operating Systems Utility software Modelling & simulations High level and low level languages Assemblers, compilers & interpreters Included: A well designed and clear workbook which students can work independently from on the computer or printed if they wish, with a range of different types of activities to ensure engagement. Glossary for students to keep track of keywords and their definitions A self-evaluation on the front of the booklet so students can check their own progress (useful for the teacher too) Mini-assessment on key concepts using exam-style questions (answers provided)