Data and information teaching resources: Verification and validation

Resources and ideas for computing, data and information, verification and validation, written by teachers to support teaching and learning

  1. Home
  2. Computing
  3. Data and information
  4. Verification and validation
System Analysis Worksheets for IGCSE/GCSE ICT

System Analysis Worksheets for IGCSE/GCSE ICT

This collection of worksheets covers everything on System Analysis and Design.Analysis worksheets-2tasks, 2pages+mark schemeDesign worksheets-2tasks, 3pages+mark schemeDocumentation worksheet-2tasks, 2pages+mark schemeImplementation worksheet-2tasks, 2pages+mark scheme-2tasks, 2pages+mark schemeTesting worksheet-1task, 1page+mark schemeWorksheet summary-1task, 1page+mark schemeStep by step Presentation Lesson with short instant assessments

By ohiolei_sunlaw

Excel bundle

Excel bundle

Learn how to use Excel with my easy to follow guide, then consolidate your learning through Excel Jurassic Park. As a handy reference, I have also included my interactive spreadsheet display!

By RobbotResources

System Analysis&Design: Analysis Revision / Worksheet

System Analysis&Design: Analysis Revision / Worksheet

This revision worksheet is suitable to evaluate what the learner has learnt and can be used for assessment purposes. It covers data collection methods, advantages and disadvantages of each method as well as true or false statements. Suitable for IGCSE and GCSE .

By ohiolei_sunlaw

System Analysis &Design: Design Phase Revision Worksheet

System Analysis &Design: Design Phase Revision Worksheet

This worksheet covers data validation, verification, form design, data types and data structure. Suitable for IGCSE and GCSE revision and evaluation. It covers in detail the designing phase of the system analysis and design topic. It is accompanied with a mark scheme.

By ohiolei_sunlaw

Sale
GDPR Principles Exercises

GDPR Principles Exercises

The Exercises aim to educate and make the students think about what Data Protection means to both the Data Subjects Personal Data (You and me) and Users of the Personal Data.

By biznetworker

Sale
A Level Computer Science Mega Revision Bundle

A Level Computer Science Mega Revision Bundle

A wide range of A-Level computer science revision worksheets/booklets. Including Programming Techniques Logic Gates, Masks, Shifts Layers, OSI, TCP/IP Compilation (Lexical, Syntax, Code Gen, Optimization) Big O Notation Stacks & Queues Trees, Graphs CPU Entity Relationship Diagrams Binary, Hex, Floating Point, two's compliment Software Development Networks

By moggga

Database Revision/Homework Question 5

Database Revision/Homework Question 5

A 19 mark database homework/revision question covering:Relationships Between TablesCompound and Surrogate keysInput Validation ProblemsA Report and its Underlying QuerySum Function in Report FooterForm DesignWritten for the Scottish Higher course but valid for all intermediate level Database units.My students found this very useful.Question 5 of 6.

By snegreid

Excel Jurassic Park

Excel Jurassic Park

Teach your students how to use Excel through Jurassic Park! Students have been given a budget of £100,000,000 to build their park. They need to consider what dinosaurs they want to buy, how much space they will need, what facilities they require, staffing costs and ticket price.Excel Jurassic Park teaches you how to use functions and formulas through a series of engaging and interactive tasks which are differentiated to support a range of abilities.Skill that you will learn include:Add Raw dataCreate a graph Title a graphFormatting dataMake arithmetic calculations using ExcelData validation (Drop down menus)Lookup formulasUse cell referencing in formulasFormat graphsCross worksheet referencingAdvanced arithmetic calculations (nested)Use absolutely relative cell referencingAdding messages to data validationEfficient calculations (autosum)Conditional formattingAdvanced graph formattingIF formulasLinking IF formulas and conditional formattingThe clear explanations and step by step nature make it ideal for KS3 classes, but it is also suitable for ECDL, GCSE and beyond!Use alongside RobbotResources' How2Excel' workbook for a comprehensive understanding of how confidently use Excel!************************Please leave a review!*************************

By RobbotResources

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

Cambridge Technicals Level 3 ICT Spec 2016 Unit 2 PLC (Global Information)

Cambridge Technicals Level 3 ICT Spec 2016 Unit 2 PLC (Global Information)

6 files in total to cover 6 Learning Objectives for Unit 2 Global Information for Spec 2016 for Cambridge Technicals Level 3. A great resource to help your students, to identify what they need to know and learn for this unit. These PLC documents are not just a transfer from the spec but have included many important points they need to know, from authorised content. This makes these PLCs a good snapshot for revision or when students need quick reminders as they stand outside the exam hall.....If you like Unit 1 PLCs, you will like Unit 2 PLCs even more. My students have rated these PLCs as the most important tool they need. 100% of my students passed the Unit 1 exams in January'17. What you are paying for, is the time you save to construct these PLCs to a student-friendly format learning tool. There are some analysis involved to make them useful.

By AlysR

Database Revision/Homework Question 1

Database Revision/Homework Question 1

A 25 mark database homework/revision question covering:Field TypesInput ValidationPrimary and Foreign keysReasons for Using Relational DatabaseSearchingSortingWritten for the Scottish National 5 course but valid for all introductory Database units.My students found this very useful.Question 1 of 6.

By snegreid

OCR A451 - Computing Revision Bundle

OCR A451 - Computing Revision Bundle

3 Worksheets on a range of topics from the A451 computing GCSE exam. Perfect for revision lessons Individual starter activities for more able. Perfect cover work.

By moggga

L03 PLC Cambridge Technicals Level 3 ICT Spec 2016 Unit 2 PLC (Global Information)

L03 PLC Cambridge Technicals Level 3 ICT Spec 2016 Unit 2 PLC (Global Information)

one file for Learning Objective 3 for Unit 2 Global Information for Spec 2016 for Cambridge Technicals Level 3, for those who want a taster before deciding to buy the whole bundle of all 6 PLCs.A great resource to help your students, to identify what they need to know and learn for this unit. This PLC document is not just a transfer from the spec but hasincluded many important points the students need to know, from authorised content. This makes these PLCs a good snapshot for revision or when students need quick reminders as they stand outside the exam hall.....If you like Unit 1 PLCs, you will like Unit 2 PLCs even more. My students have rated these PLCs as the most important tool they need. 100% of my students passed the Unit 1 exams in January'17. What you are paying for, is the time you save to construct these PLCs to a student-friendly format learning tool. There are some analysis involved to make them useful.

By AlysR

Sale
A Level Computer Science Revision Pack

A Level Computer Science Revision Pack

5 Worksheets + 1 workbok on a range of topics including: Lexical & Syntax analysis Big O Notation Stacks & Queues Binary, Binary Addition & Subtraction Hexadecimal Two's Compliment Networks The Internet Software Development Methodologies Ideal for homework or starting point of a revision session

By moggga

Sale
GCSE Computing OCR spec bundle

GCSE Computing OCR spec bundle

5 x revision worksheets + 1 Starter activity sheetLogic GatesTechnical Terminology (Wide range of topic areas)SoftwareNetworksDatabases

By moggga

Sale
A Level Computer Science Revision Bundle

A Level Computer Science Revision Bundle

2 worksheets + 1 starter activity sheet with a wide range of topics to revise. Descriptions, Matching exercises, multiple choice.Topics:Big O NotationSearching AlgorithmsData TypesDatabasesCompression (Lossy v Lossless)Acronym ChallengeCPU+ a nice starter activity using keywords.

By moggga

10 Wordsearches ICT Computing GCSE or KS3 Keyword Starters Wordsearch Homework or Cover Lesson

10 Wordsearches ICT Computing GCSE or KS3 Keyword Starters Wordsearch Homework or Cover Lesson

10 starter-style keyword wordsearches covering 10 themes including ICT Systems, Hardware, Software, Data & Databases, Networks, Measurement & Control, Modelling & Simulation, Legal Framework, Risks & Implications of ICT and Industrial & Commerical Applications. Includes space for students to explain the keywords and suggested extension activities. Ideal for the start of a lesson, a quick filler, part of a cover lesson or as a plenary on the board with a whiteboard pen.

By mikedean

How2Excel: A guide to understanding Excel spreadsheet software

How2Excel: A guide to understanding Excel spreadsheet software

Ideal to support the delivery of GCSE, BTEC and ECDL ICT courses!If you like the quality of my other resources, you won't want to miss this!!!A comprehensive guide on a broad range of differentiated Excel skills which include;Data Types: Raw, Changing Type, Relative & Absolute Cell ReferencingFormatting: Cells, Colours, Font & BordersBasic Arithmetic Formulas: Simple arithmetic (+ - * /), Relative & Absolute Formulas, Common ErrorsFunctions: SUM, AVE,MIN, MAX, COUNT, COUNTA, ROUNDAdvanced Functions: BOOLEAN (< > =), COUNTIF, IF, Nested IF, LOOKUP, CONCATENATEApplying Cell ReferencingValidation Rules: Including Drop Down ListsUsing Table FiltersCreating Graphs and ChartsConditional FormattingCreating MacrosEach skill includes a tutorial and a task to show you how to apply it.There are also two consolidation exercises which require the application of a range of skills learned within the tutorials. These include;Create an Interactive SpreadsheetDream Team GeneratorA checklist at the start of the workbook allows you to keep track of your progress.***Please Leave a Review!***

By RobbotResources

GCSE Computing - Revision on a page

GCSE Computing - Revision on a page

Selection of handy revision sheets that summarise the main aspects of the GCSE curriculum. The focus is on the AQA 8520 (9 - 1) specification but this could be easily applied to other specifications.Free GCSE ICT revision on a page included as a sample.Also KS3 computer systems revision given for free.

By chrdol72

OCR GCSE Computing revision flash cards

OCR GCSE Computing revision flash cards

These fully completed flash cards cover ALL 88 sub-topics for the OCR GCSE A451 Computing exam.I was asked by one of my students to make these, so here they are.I hope they are useful to your students.

By doradora17