OCR · GCSE
Your journey to excellence inIT
By Revision Genie
I want to study…
Start learning
Start with the first IT lesson.
Data vs information
1Data vs informationRead next2Data types in contextRead next3Validation vs verificationRead next4Validation toolsRead next5Verification toolsRead next6Data collection methodsRead next7Data storage locationsRead next8Storage devicesRead next9Purpose of testingRead next10Test data typesRead next11Technical vs user testingRead next
Data validation methods
1Data validation methodsRead next2Cell formattingRead next3Conditional formattingRead next4Sorting and filtersRead next5Formulae and operatorsRead next6Relational operatorsRead next7Cell referencing (relative/absolute/named/multi-sheet)Read next8Built-in functions (IF, COUNTIF, VLOOKUP)Read next9Pivot tablesRead next10Importing file typesRead next11Data types in spreadsheetsRead next12Security measures (locked cells)Read next13Modelling tools (what-if, goal seek)Read next14Outputs: charts and graphsRead next15Outputs: page layoutRead next16Outputs: row/column settingsRead next17User interface features (buttons, macros, hyperlinks, forms)Read next
Evaluation against client requirements
Purpose and user requirements
Model prototype characteristics