Your journey to excellence in
IT
By Revision Genie
Let's master IT together!Data vs information
Data types in context
Validation vs verification
Validation tools
Verification tools
Data collection methods
Data storage locations
Storage devices
Purpose of testing
Test data types
Technical vs user testing
Threats: DoS, hacking, malware
Threats: social engineering
Impacts of cyber attacks
Prevention measures: physical
Prevention measures: logical
Secure data destruction
IT-related legislation
Communication types
Software for digital comms
Digital devices
Distribution channels
Connectivity methods
Audience demographics
What IoE is
Four pillars of IoE
Pillar interactivity
Digital interactivity types
Tailoring devices to users
IoE application areas
Design tools for planning
Functionality design
Navigation design
Output design
HCI design: calculations
HCI design: sorting and filtering
HCI design: user aids and validation
Data validation methods
Cell formatting
Conditional formatting
Sorting and filters
Formulae and operators
Relational operators
Cell referencing (relative/absolute/named/multi-sheet)
Built-in functions (IF, COUNTIF, VLOOKUP)
Pivot tables
Importing file types
Data types in spreadsheets
Security measures (locked cells)
Modelling tools (what-if, goal seek)
Outputs: charts and graphs
Outputs: page layout
Outputs: row/column settings
User interface features (buttons, macros, hyperlinks, forms)
What AR is
Purpose of AR
AR sectors
AR uses
Types of AR (marker-based/markerless/superimposed)
User interaction types (static/interactive)
Devices for AR (mobile/smart devices/PC)
Purpose and user requirements
Target audience
Content planning
Asset types (audio, text, images, video, links, charts)
Trigger types
Layers and action flow
Design tools for AR planning
House style planning
Model prototype characteristics
Building from design documentation
Trigger characteristics and quality
Trigger selection for context
Layers: single vs multiple
Interactive layer access (swipe/click/voice)
Information output formats