No limits, no ads, full access
Design Tools
Human Computer Interface in Everyday Life
- Technical vs user testing
Cyber-security and Legislation
- Threats: DoS, hacking, malware
- Threats: social engineering
- Impacts of cyber attacks
- Prevention measures: physical
- Prevention measures: logical
- Secure data destruction
- IT-related legislation
Digital Communications
- Communication types
- Software for digital comms
- Digital devices
- Distribution channels
- Connectivity methods
- Audience demographics
Internet of Everything
- What IoE is
- Four pillars of IoE
- Pillar interactivity
- Digital interactivity types
- Tailoring devices to users
- IoE application areas
R060 Data Manipulation Using Spreadsheets
Planning and Designing the Spreadsheet Solution
- Design tools for planning
- Functionality design
- Navigation design
- Output design
- HCI design: calculations
- HCI design: sorting and filtering
- HCI design: user aids and validation
Creating the Spreadsheet Solution
- 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)
Testing the Spreadsheet Solution
- Technical testing during development
- Usability testing during development
- Post-development testing
- Recording test results
- Retesting and improvements
Evaluating the Spreadsheet Solution
- Evaluation against client requirements
- Evaluation against HCI principles
R070 Using Augmented Reality to Present Information
Augmented Reality
- 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)
R050 IT in the Digital World
0/5 lessons
Data and Testing
0/11 lessons
0/7 lessons
0/6 lessons
0/17 lessons
0/2 lessons
Designing an AR Model Prototype
0/8 lessons
Creating an AR Model Prototype
Testing and Reviewing
0/4 lessons
types of malware
malware#
Flowcharts
Internet of Everything (IoE)
Hi! 👋 Ask me anything about IT, or try the study modes.