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

#### Most Used Excel Functions

Teach your students the most used Excel functions. All explained with details and includes an example each. The presentation can be adapted to your class activities. Functions that include in the presentation: SUM ( ) AVERAGE ( ) MAX ( ) - MIN ( ) COUNT ( ) COUNTA ( ) CONCENATE ( ) IF ( ) COUNTIF ( ) VLOOKUP ( ) SUMIF ( ) Assessment supports learning abilities and gives a chance to practice them in carefully designed examples with instructions for each. (All functions are used). The “Assessment_SOLVED” file gives the answers of each question. Please make sure you leave a review after your use. THANK YOU!!!

#### Data Storage - Presentation Project

The resource is specifically based against the IGCSE Computer Science syllabus, but is suitable for any Data Storage module. It includes some knowledge tests at the beginning and leads on to creating 5 groups to work on a presentation about a different element of Data Storage. The group worksheets can be handed out or sent electronically and each has a series of keywords to prompt research. Each group is challenged with answering one Big Question and explaining it to the class at the end of the lesson. If you find the resource useful please leave a review so that others can find it. HackDragn

#### World Cup 2018 Spreadsheet Project Resource Pack

An ICT Spreadsheet project all set up to launch the 2018 FIFA World Cup in Russia - Aimed at Year 9 and KS4 3 resources available: a student template, with no formatting, formulae or functions; a teacher demo version, containing examples of a number of advanced features; finally a fully functioning working model showing a range of advanced features. A great motivational resource for teaching IF / COUNTIF Functions; relative &amp; absolute cell referencing; defining cell names; macros; there is also further scope to develop the project further by incorporating graphs / charts; conditional formatting and VLOOKUP Functions. The project is set up to run through the entirety of the World Cup until its conclusion on 15 July.

#### Edexcel Computer Science 9-1 paper 2 half a terms lessons

This half a term worth of lessons cover: error types data types relational databases test Each lesson begins with the basic concepts, then adds until they are at GCSE level. Students have been very engaged with this work.

#### OCR GCSE Computing - Translators presentation task

Student are required to create a presentation on translators in groups or pairs, to present to rest of the class

#### WEBSITE Development Performance Assessment for Assignments > CHECKLIST & RUBRIC

This Checklists is a quick way to assess if a performance task has been completed according to the assignment objectives. Specifically designed for Web Development projects. Appropriate for creating original websites, or for redesigns. This checklist is a quick, accurate way to assess student knowledge. Teachers can evaluate projects using this Rubrics, and it can also be used to set student expectations. Standards Addressed Include: ~ Website Organization ~ Design and Technical Skills ~ Research and Validation ~ Communication and Navigation ~ Project Planning and Management

#### HTML One Day Lesson Plan > Webpage Building Using Notepad > NO Prep Printable!

This HTML One Day Lesson Plan is designed as a self directed activity for your students. Step-by-Step instructions are easy to follow and easy to understand. Use this lesson as a stand alone assignment or in conjunction with your curricula. Created as a printable in black and white. For a comprehensive one semester curricula, reference the all inclusive guidebook on WEBSITE BASICS by Patty Ann.

#### Presentation: how to test a system (x11 slides)

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.

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

Mock exam paper and exam support for the exam.

#### 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

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

#### Cambridge Technicals - IT - Unit 03 - Personal Digital Assistant - Mock Exam - May 2018 Scenario

Cambridge Technicals - IT - Unit 03 - Personal Digital Assistant - Mock Exam - May 2018 Scenario - With answers.

#### Computer Science Flash Activity Sheets

Prepare your computer science students for Exam season with this great practice resource! This versatile resources is aimed to develop your GCSE computer scientists retrieval skills and practice a range of fundamental skills which consistently appear within GCSE computer science exams. This resource includes a pack of 10 activity sheets within both PowerPoint and PDF format. I have included three different versions: Student pack - activity sheets only Teacher pack - answers (with explanations) only Student self assessment pack - both activity and answers Skills covered include: ASCII conversion Understanding binary and hexadecimal values Binary, denary and hexadecimal conversion Huffman coding Binary addition Memory size conversions These activities can be used as classroom starters, homework or as main classroom activities. It is recommended that these activities are used to practice and assess students ability to perform these skills, not as an introduction. Please leave a review!!!

#### AS / A2 IT 12 mark question and mark scheme

12 marks, ideal for a strater task or homework. Includes mark scheme. Covers security, firewalls, securing a contempary tablet device etc.

#### Cambridge Technicals Level 3 IT Unit 2 Exam Revision Guide

Unit 2 Exam Revision Guide featuring text, mind maps and information needed for the exam. 49 pages.

#### Complete IGCSE ICT 0417 teaching and learning resources / Grade 9-10 / Year 10-11

Hi ICT teachers, I have created this resource bundle with teaching resources that will last for two academic years. You can view details of all of them individually. I am sure you will find these very useful not only for conducting ICT lessons, but also managing the ICT department in your school. NOTE: Please make sure to download this resource immediately upon payment. You can send me a private message or contact me on my site for any further FAQs.

#### Enigma Machine Fact Sheet for Primary Pupils

Enigma fact file for primary pupils from primary computing scheme of work 6-8 week cryptography unit. Credit :

#### Cambridge Nationals - R0001 - June 2018 - Maes Knoll Gym Scenario Mock Exam Paper

Mock exam paper for the Maes Knoll Gym scenario with answer sheet. Any issues or corrections, suggestions, please feed back to me at

#### GCSE Computing Exam Style Questions and Answers - OVER 30% OFF

**GCSE Computing Exam Question for Students and Teachers. ** Great for analysing answers in class as a starter or student revision. These questions are worth between 6-8 marks and are concerning Ethical, Legal and Clutural Issues. The questions are based off of the OCR (9-1) GCSE New Exam Papers. OVER 30% OFF as apposed to buying separately!

#### GCSE Computing Exam Style Question with Answer: School Software

GCSE Computing Exam Question for Students and Teachers. Great for analysing answers in class or student revision. Based off the OCR (9-1) GCSE See the Full Bundle for a Discounted Price!

#### GCSE Computing Exam Style Question with Answer: School Saving Pupil Data

GCSE Computing Exam Question for Students and Teachers. Great for analysing answers in class or student revision. Based off the OCR (9-1) GCSE See the Full Bundle for a Discounted Price!

#### IGCSE Computer Science(0478) Pre Release may/June 2018 TASK 1 Solution in Visual Basic

This Coding contains proper validation for both Range check and duplication. This is the simplest code as well as smallest code for Task 1. This is the most recommended code for Task 1.

#### Programming core concepts flashcards

A set of flashcards for students to use to revise key programming terminology. I created these for my GCSE students, so that they would be clear on key terms. These cards help them remember the core ideas, which helps them program and discuss their programming.

#### Excel Project from beginner to advanced

This is a mini project that lasts about 60-100 minutes depending on the ability of the students. I used this for my year 9 and 10 students but it can also be used for other years. Allow them to create the project themselves as they will learn how to merge cells and add borders to the cells as well as other formatting skills. This project includes using a lot of functions and useful tools in excel and is great if you want the students to learn independently. This project is super easy to mark as all you need to do is check whether they have completed the set tasks and give them a grade and a comment. If the students forget or do not know how to create Vlookups or If statements then I direct them my Youtube channel which actually has a tutorials on how to do both of them. The link can be found below. Let me know if this is useful or helpful to any of you.

#### Information Security Unit 302 City & Guilds

Level 3 (Technical) Certificate/Extended Certificate/Diploma in Digital Technologies (5220-30/31/32) The aim of this unit is to give an introduction to the principles concerned with the security of Information Technology systems and data. Learners should explore a range of techniques used to enhance security of systems and data. The unit will also explore network infrastructure security, and how security measures can be both physical and logical. Learners will also explore new and emerging technologies used for cryptography and will have the opportunity to research cryptographic techniques that are applied in organisations. In this unit, learners will be able to: 1. apply security concepts 2. determine infrastructure security 3. identify types of cryptography.

#### Spreadsheet and Chart Drawing Guide and Activities

Guide and Activities for Year 11-13 spreadsheets, charts and spreadsheet modelling and applications aimed at the 9626 or AS Applied ICT curriculum. Also useful for GCSE ICT and iGCSE students. One file did not upload as it is an Access file. Email em at enderoth@hotmail.com for this or a zip of everything.

#### BTEC L3 NQF - IT - Unit 5: Data Modelling

This resource takes BTEC Level 3 students through how to do the skills needed for Unit 5 of the BTEC NQF Level 3 course. It contains 66 videos which take students through how to use the basics and more advanced features of MS Excel. This is a tried and tested unit which works with a broad range of abilities and usually takes about 8 hours to complete in full. Students need to create a school production spreadsheet which contains IF Statements, charts, vLookups, Macros, Conditional Formatting to name but a few. The pack contains a checklist which students can use to monitor their progress. The checklist also links to all of the videos.

#### BTEC ICT UNIT 1 Digital Workbooks Learning Aim A - Resources Bundle

A resource bundle of digital workbooks to work through Learning Aim A of Unit 1. This resource includes 8 x workbooks that covers all areas for Learning Aim A. The workbooks include a variety of tasks for students to complete during independent study, including relevant exam questions. Resources are saved as fully editable Microsoft Word Files.

#### Cybersecurity &The Internet - Full Resources

EDIT 4th Feb - If you purchased this resource before 4th Feb and the videos don't work on the Powerpoints then please message me and I will send you the amended versions. Includes a workbook of 15 A4 pages and 8 lessons with full links to resources, extension tasks and teacher Powerpoints to lead the lessons. Designed for non-specialists teaching the Edexcel GCSE Computer Science specification, but would be suitable for other exam boards as well. I was fed up trying to find decent resources for this topic and some of the concepts send students to extremely advanced pages about cybersecurity - this has been created to make sure that they understand the main parts in an accessible yet interesting way. 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.

#### Data Transmission and Errors - Full Lesson GCSE

Full lesson with all resources for Data Transmission and Errors Learning Objectives Understand what is meant by transmission of data Know the difference between serial and parallel data transmission understand of the reasons for choosing serial or parallel data transmission Know why it is necessary to check for errors All necessary resources to run the lesson are included in this download. The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. All activities and resources have been used in class and any errors will be fixed and resources updated as soon as I am aware of any errors. All comments and suggestions are very welcome and will be used to improve future resources. ------------------------------------- The contents of this page and all downloaded materials are copyrighted Harvey Taylor (2018)

#### BTEC ICT 2017 Learning Aim A - Presentations Bundle

Here is a bundle of all of the presentations that cover all of Learning Aim A. Each presentation includes exam questions & answers for your students to have a go at. They have been designed for your students to work through in their own time or for the teacher to present at the front of the class.

#### GCSE ICT Complete revision workbook pack

A complete set of 6 workbooks that include: 36 different topics. This set of workbooks will fully prepare students for the GCSE examinations. Used either as revision activities, or in class as unit/content coverage. Ideal for use with Google Classroom.

#### GCSE ICT Revision workbook 3: Operating Online

Workbook 3 of 6. Includes 12 slides of revision activities.A checklist to help students manage revision and instructions for each activity/task within the slide notes. 6 Topics covered: 3.1 World Wide Web 3.2 Identification &amp; Authentication 3.3 Online Accounts 3.4 Personal Spaces 3.5 Profiling (public &amp; private) 3.6 Data Protection Created to support students preparing for examinations, however this resource could also be use as a set of lesson activities too.

#### MS Access Spreadsheets FULL UNIT of WORK

Lesson activities and student files for MS Access Spreadsheets

#### Cambridge Technicals - ICT - Level 03 - Unit 07 - Data Analysis and Design - Code A/507/5007

Cambridge Technicals - ICT - Level 03 - Unit 07 - Data Analysis and Design - Code A/507/5007 - Delivery materials and assessment sheets for the unit. Access file will not upload to TES due to restrictions. Email me at enderoth@hotmail.com for the Database file if needed. (Only necessary for Merit and Distinction)

#### Full Set GCSE Computing Revision Flash Cards!

GCSE Computing Revision Flash Cards for Students. This bundle has money off, as apposed to buying the Flashcards separately. £25 instead of over £30! 20% Off compared to if you bought them separately. Based off of the OCR Specification (9-1)

#### GCSE Computing Revision Flash Cards - Databases

GCSE Computing Revision Flash Cards for Students. See Full Set of Flashcards for Computing for a Discounted Price! Based off of the OCR Specification (9-1)

#### Network Security and Threats

For AS / A2 Computer Science but would also be suitable for GCSE level.

#### Computer Science Network Bundle

4 worksheets on the topic of NETWORKS

#### 37 MS Access Video Guides for BTEC L3 NQF Unit 2 - Databases

This resource contains 37 MS Access video tutorials to quickly walk students through all of the practical skills they require for the 10 hour controlled assessment. This has been tried and tested, particuarly on the run up to exams and has proven to be an excellent resource. The video guides are stored on google drive and students can therefore access remotely. The resource comes with a pdf and word doc checklist that students work their way through. It takes them approximately 6-8 hours from start to finish. In this project, students build an electronic 'time-out' system in order to streamline the behaviour sanction system used in my school.

#### BTEC ICT Level 3 Unit 2: Creating systems to manage Information Dissford Art Centre datafiles

A spreadsheet for the worked example in the Pearson BTEC National student book - Unit 2. It is all in one spreadsheet but can easily be cut and pasted so as to save it as CSV files if required. It includes the 4 venues, the 4 clients and 7 days of booking slots.