1. Resources Home
2. Whole School
3. Computing
4. Data and information

#### Website Basics: EASY Lesson Plans 4 Teachers = Full Curricula with Activities!

A great introduction to website construction. Use as a complete curriculum or as a supplemental educational aid. Packed with lesson activities! Highlights Include: ~ Learn basic HTML codes ~ Use notepad to construct a website ~ Web terminology ~ Page design and re-designs ~ Create a personal website ~ Story boarding ~ Project planning with project charters ~ Create tables, lists, links + more ~ About browsers, domains and web hosting ~ JavaScript and Cascading Style Sheets Comes with: ~ Self Guided Lessons ~ Teachers Grading Rubrics and Criteria ~ Student and Peer Evaluations ~ Empty Rubric Templates** This is a full semester’s worth of curricula. If you need a pre-made, EASY lesson plan for “Website Basics” &gt; Here it is!

#### Presentation on how to test a system

The presentation introduces the idea behind testing and covers the ideas behind the idea of creating a test plan, difference between a fault and an error and shows a blue screen error. It describes the importance of reliability, using different test data (typical, erroneous, exaggerated data) and how to formulate a test plan.

#### Entity Relationship Diagrams (ERD)

The presentation introduces the idea of data redundancy (repeating data) inside tables. It shows using clear diagrams how to avoid this by splitting a table into two separate tables and introducing a one to many relationship between these two tables. It goes onto show how to represent ‘many to many’ relationships using two ‘one to many’ relationships, before defining the two important keys; primary and foreign key. There is a word document worksheet where the pupils have to describe the relationships between entities.

#### Google Sheets - Data Log with Automatic Graphs

This Google Sheet is setup to create data logs with automatic graphs. It is very easy to use. Students enter their data in the colored cells and the graph is automatically created. Included: • 5 different graph types. One on each tab. • Each graph has room for 200 entries. Decide how many to use. • Information page on using tabs. • Information page on using the chart. • Information page on using the graphs. Some Usage Ideas: • Surveys • Math Facts • Grades • Science Labs Students will never lose their data graphs again as this uses Google Drive!

When it comes to data you want secured, your email accounts are probably close to the top of the list. Strong passwords can help, but to be as secure as possible, you want to enable two-step authentication. This is a great resource to print out and have your students follow. It teaches students about 2 step verification! What You Get: • What is two-step authentication? • Setup your Google account • Alternative second steps

#### Boolean logic resource pack

Three Boolean logic worksheets with exam style questions on logic statements and truth tables. 22 questions in total. The worksheets cover AND, OR, and NOT gates. Answer sheets included. Fully editable. Good for homework assignments.

#### Stack data structure

The presentation describes what a stack data structure is, introduces the principle operations of PUSH / POP along with the stack pointer using simple, easy to understand diagrams. The presentation includes pseudo code for the PUSH / POP operations and describes three uses of the stack data structure.

#### Revision flash cards with answers for Computer Science iGCSE 0478

Units 1 - 7 sets of questions with answers to be printed and used as revision cards with students. Good for cold calling, pair work starter etc. Designed for CIE 0478 IGCSE Computer Science course but useful for UK GCSEs also Questions can be edited, added to etc…

The presentation introduces five different data types; boolean, integer, real, date/time, string. Each slide describes the data type and gives examples of what they can represent.

#### Cambridge Technicals IT Level 3 Unit 5: Virtual and Augmented 2016

An entire collection of my thoughts and ideas on this new unit. After teaching the legacy spec for many years, i have found my students to excel in the subject using resources like these, resulting in positive feedback from external moderators. For this course you cannot offer templates to learners, however the red notes may of use to aid learners in their writing. Please feel free to provide feedback or comments: eyeteateacher128@gmail.com

#### Computer Science GCSE 0478- One mark Questions - Unit 10 Databases

Unit 10 - Databases A set of 40+ questions with answers to be printed and used as revision cards with students. Good for cold calling, pair work starter etc. Designed for CIE 0478 IGCSE Computer Science course but useful for UK GCSEs also Questions can be edited, added to etc…

#### GCSE Computer Science Paper 2 Revision Work Booklet - Topic Quizzes and Model Answers - AQA 8520

This is a collection of module quizzes covering key content that is assessed in paper 2 of the new specification GCSE. I will be using these as a final push for my current year 11s in the run up to the final exam. They are specifically designed for AQA 8520 spec, but content is also suitable for OCR and other boards. In total there are 5 double page module quizzes, along with answers to each. The key topics are: Data Representation, Computer System (hardware/software), Networks, Binary Shifts/Arithmetic and Ethical, legal and Environmental impact. There are questions covering the vast majority of the specification, but these are in no way intended to be exhaustive. The question style features exam style questions, along with question types designed to prompt recall and understanding. Full answers are provided for each quiz. Note: These module quizzes can be obtained individually, or as a complete package, in my TES shop. If you have already purchased any module quizzes, or if you want topics spanning both paper 1 and 2, it may be better to buy the others instead. Hope these help. Thanks, Toby Watkins

#### KS3 Computing - Cryptography Unit of Work - Lesson Presentations, Worksheets and Assessment

This is a whole unit of work that this aimed at KS3 - it covers all aspects of Cryptography that the students have absolutely loved doing and this has been uploaded to Google Classroom and made the whole unit very interactive. The work is split into Flight Paths and contains an assessment. All work has stretch and challenge extension tasks too. This is a really enjoyable unit of work for about 6 weeks.

#### Introduction to Logic Gates (KS3 + 4 Friendly)

An introduction to logic gates which i used at KS3 and KS4. Easy to understand and straight forward. Included are: Teachers powerpoint (walks the students through the gates with examples) Progress log (Track students progress) Self marking spreadsheet that includes tasks, extension and a helpsheet

#### Royal Wedding QR Code Hunt

Based for Year 1 but can be changed to suit the ability of your class. QR codes to be placed around the classroom/school for the children to scan and display the family members name. The names can be written on the worksheet next to the family members picture.

#### Tackling extended answer questions - AQA GCSE Computer Science 9-1

This resource focuses on getting kids to take an active approach towards extended questions in their GCSE paper. This may be last minute considering the timing, however I used it recently with my Year 10s and they found answering the example question given to them much easier.

#### Unit 02 - Cambridge Technicals - Project LakeSailing - Mock Exam Scenario

Mock exam paper and exam support for the exam.

#### Unit 18 / 19 / 20 Cambridge Technicals Level 3 *Triple Pack*

**Unit 18 / 19 / 20 Cambridge Technicals (2016) Level 3 Triple Pack ** This rescource will provide you with the relevant resoucres to complete the following units on the Cambridge Technicals units: Unit 18 - Hardware Unit 19 - Software Unit 20 - Technical Support Combine these 3 units with the examination units (1 &amp; 2) to achieve 1 A Level for your students! Each unit is available on their own in my shop, the 3 together offered at over 40% off!

#### Computer Science GCSE Unit: 1 Data Representation - Motion terms - Learn the key terms

**Computer Science GCSE CIE 0478 ** Unit: 1 Topic: Data Representation Motion terms - Learn the key terms A set of editable presentations that help students learn the key terms and definitions for the topic stated. The presentation includes instructions and is setup to run ‘generation game’ type activities where the terms appear and move across the screen one after the other. Students watch and try to memorise the terms/definitions. Then write down as many as they can. Next, in groups they work together to see if they can reproduce a full list of key facts and definitions. Then they check the answers from the full list. My students enjoy these activities and retained more of the details when rechecked 4 weeks later compared to other strategies that I have used. Please leave some feedback.

#### Computer Science glossary of technical terms

Student glossary / dictionary of technical terms for GCSE Computer Science. Covering over 240 terms in 7 topics, each term has space for pupils to write a definition and to check the term off once it is understood. The glossary can be completed electronically by pupils or printed out and written by hand. A fully editable Word version is included to add / remove terms relevant to your GCSE syllabus.

#### Memory & Storage for OCR GCSE (9-1) in Computer Science (J276)

This “Memory and Storage” student workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about computer memory and storage to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.2. Memory” and “1.3 Storage” specifications. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 22-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: Read Only Memory (ROM) The purpose of ROM Random Access Memory (RAM) The purpose of RAM Dynamic RAM (DRAM) Static RAM (SRAM) The difference between ROM and RAM The need for virtual memory Flash memory The need for secondary storage Data capacity and calculation of data requirements Common types of storage Optical Magnetic Solid state Suitable storage devices and storage media for a given application Capacity Speed Portability Durability Reliability Cost

#### Computer Science Poster: Impact of Digital Technology on Society

Has technology improved our lives or has it actually made our lives worse? This poster was created to promote debate within the classroom within my year 11 students to prepare them for their computer science exams. I have included a range of topics with positive, negative and thought provoking questions for students to consider. The topics covered are also suitable for GCSE ICT exams. Please leave a review!

#### Computer Science GCSE 0478- One mark Questions - Unit 6 Security

Unit 6 - Security A set of 45+ questions with answers to be printed and used as revision cards with students. Good for cold calling, pair work starter etc. Designed for CIE 0478 IGCSE Computer Science course but useful for UK GCSEs also Questions can be edited, added to etc…

#### Computer Science GCSE 0478- One mark Questions - Unit 5 Software

Unit 5 Software A set of 50+ questions with answers to be printed and used as revision cards with students. Good for cold calling, pair work starter etc. Designed for CIE 0478 IGCSE Computer Science course but useful for UK GCSEs also Questions can be edited, added to etc…

#### Binary Shift Information and Practice

Binary Shift Information and Practice Activities This resource consists of a basic explanation of binary shifts (left and right) showing illustarted examples of how to perform the operations. There are also examples and activities to complete. The resource is linked to two videos that show how to perform the shift operations using 1 and 0’s. The practical activities are best performed by representing the 1 and 0’s on the printed sheet using plastic spoons, buttons, lollipop sticks with 1 and 0 written on them (or any other way to represent to 1 or the 0). The activity has deliberately been devised to be hands-on. Useful for KS3 and KS4 GCSE Computer Studies

#### ICT/INPUT, OUTPUT AND STORAGE DEVICES

A totally animated presentation that explains the concept of input, output and storage devices. The presentation also includes 20 questions that makes fun the recap part. Also there are an assessment and a poster in this resource. May this will be helpful for everyone.

#### Crazy Zoo - Intro to Spreadsheeting

This presentation is designed for KS3 as an introduction to spreadsheeting. Included files are the presentation, the finished spreadsheet and a homework / assessment sheet.

#### Unit 20 - Technical Support- Full Unit, Cambridge Technicals Level 3 (2016)

Here you will find the resources to complete Unit 20 in the level 3 Cambridge Technicals. All of the Learning Objectives have been covered within the lessons provided. The assignment which has been used has also been checked using the Assignment Checking service from OCR. (Service is £30 per assignment) Enjoy!

#### Database MOC Exam A-Level

MArking and FeedBAck

#### ACID - Database

The methods of capturing, selecting and exchanging data The referential integrity Transaction processing, ACID (Atomicity, Consistency, Isolation, Durability), Record Locking and Redundancy

#### SQL Knowledge Organiser GCSE OCR Computer Science J276

My current year 11 students have been extremely positive about the Knowledge Organisers that I have created for their Computer Science revision (and students in previous years on the legacy spec). This resource is a one-page knowledge organiser that covers everything that a student should need to be able to answer any of the SQL questions in the Computer Science exam (as tried and tested on my year 11 students). This is not a lesson plan - it covers the database terminology; an example flatfile database; data types used in databases; SQL terminology; example SQL commands to search a database and the results these would yield from the example table. This covers the new J276 OCR specification for GCSE Computer Science. You can either buy this knowledge organiser on its own - or all eight are available for a slightly lower overall cost. Please do leave feedback if possible, I hope you find it useful.

#### Teach yourself the ENTIRE AQA GCSE Computer Science specification

Detailed student workbooks that EXACTLY match the AQA GCE (9-1) Computer Science (8520) specification. Each includes theory, tasks to recap the knowledge and put their new skills into practice and the answers. Perfect for NQTs, non-specialist teachers or teachers who feel a little unsure about the qualification content and want to improve their subject knowledge. Also ideal to use as a revision aid for students. Provided as seven separate PDF documents: • Fundamentals of algorithms • Programming • Fundamentals of data representation • Computer systems • Fundamentals of computer networks • Fundamentals of cyber security • Ethical, legal and environmental impacts of digital technology on wider society, including issues of privacy These are ideal to use in the classroom, as homework tasks or for independent study as revision for the examinations.

#### Computer Science - Component One Revision Bingo

OCR Computer Science 9 - 1 Component One Bingo Revision Includes Lesson Power Point Bingo Card with questions. The questions cover a range of topics from component one.

#### BTEC ICT level 3 Unit 2 Creating Systems to Manage Information Exam Guidance and Checklist

A guide (with screenshots) to what the students are expected to produce for the Unit 2 exam as well as a checklist.

#### GCSE Computer Science Module Quiz - Ethical, Legal and Environmental - Linked to Knowledge Organiser

This is a module summary quiz on the topic of Ethical, Legal and Environmental Impact. Includes questions on legal issues, environmental impact and some larger scale ethics consideration questions. The assessment features a range of question types and includes full worked solutions and answers. I print these 2 to a page and use them as a low stakes quiz at the end of a module. I will also be reusing them as a revision resource for my year 11s. These module quizzes are linked to the Knowledge Organisers I have also made and are available on TES. Most of the content is featured on the similarly named organiser, but would still be more than suitable without the use of the organisers. Any questions, please feel free to ask. Thanks, Toby Watkins

#### GCSE Computer Science 9 x Module Quizzes - Great for exam revision, consolidation, assessment or homework

This is a collection of my module quizzes - a series of exam style questions and key knowledge/skill checks for each of the main Computer Science topic. Questions are applicable to all exam boards including AQA and OCR. All module quizzes come with full answers provided. I print these 2 to a page and use them both for end of topic assessments for current year 10, and exam revision for year 11.

#### GCSE Computer Science Module Quiz - Binary Calculations (Shifts etc) - Linked to Knowledge Organiser

This is a module summary quiz on the topic of Binary Calculations. Includes questions on binary arithmetic, shifts and data overflow errors. The assessment features a range of question types and includes full worked solutions and answers. I print these 2 to a page and use them as a low stakes quiz at the end of a module. I will also be reusing them as a revision resource for my year 11s. These module quizzes are linked to the Knowledge Organisers I have also made and are available on TES. Most of the content is featured on the similarly named organiser, but would still be more than suitable without the use of the organisers. Any questions, please feel free to ask. Thanks, Toby Watkins

#### GCSE Computer Science Module Quiz - Advanced Programming - Linked to Knowledge Organiser

This is a module summary quiz on the topic of Advanced Programming. Includes questions on data structures, subroutines and understanding code. The assessment features a range of question types and includes full worked solutions and answers. I print these 2 to a page and use them as a low stakes quiz at the end of a module. I will also be reusing them as a revision resource for my year 11s. These module quizzes are linked to the Knowledge Organisers I have also made and are available on TES. Most of the content is featured on the similarly named organiser, but would still be more than suitable without the use of the organisers. Any questions, please feel free to ask. Thanks, Toby Watkins

#### Python Programming Challenge - Creating a Strong Password, With clues, Extension Task

A python programming challenge where students are expected to write a program that checks if a password is considered to be strong. The password must be greater than a certain length, include numbers, symbols, upper &amp; lower case letters, not contain certain words or number pattens. The booklet includes: A tick sheet for when students have managed a certain task A test plan to check that certain passwords are ‘strong’ or not Some useful snipits of python code that will assist the students. An extension task. Good practice for string manipulation. Depending on your group ability, this could be a 1 or 2 lesson activity.

#### Cover Teacher Bundle - Key Stage 2

A range of resources that are quick to prepare and have everything you need for emergency or supply cover in upper key stage 2. Includes maths, English, reading comprehension, RE and ICT. The only thing you will need are some counters and a dice for the reading games. Please check out my other resources by clicking on my name above.

#### 9626 - AS Applied ICT - Unit 14 - Project Management - CAD, CAM, CPA and GANTT Unit of Delivery

9626 - AS Applied ICT - Unit 14 - Project Management - CAD, CAM, CPA and GANTT Unit of Delivery, videos and assessment materials. Any issues downloading, contact me at enderoth@hotmail.com