All subjects · Information Technology · Unit 3

WIT13 2 hour written exam on data, enabling technologies and systems development

Edexcel IAL Information Technology, Unit 3 (A2 unit, usually Year 13). 36 lessons so far, in the suggested order.

Practise this unit in the app: instant marking and a fix for every mistake. Free, no email needed to start.

Practise in the app

Lessons in WIT13

  1. Data integrity, data governance and data dictionaries
    Integrity = accurate, complete, consistent, reliable data. Governance = the policies, roles and controls that keep it so. A data dictionary holds metadata for e
  2. Data validation and validation rules
    Validation = automatic check that data is sensible (not that it is correct). Seven rules: presence, range, lookup, list, length, format, check digit. Test with
  3. Data redundancy and why we normalise
    Redundancy = the same data stored more than once. It wastes space and causes update, insertion and deletion anomalies. Normalisation stores each fact once in li
  4. Normalising data to 1NF, 2NF and 3NF
    1NF: atomic values, no repeating groups, a primary key. 2NF: no partial dependency on part of a composite key. 3NF: no non-key attribute depending on another no
  5. Designing a logical data model
    Logical data model = normalised relations with PKs, FKs and relationships. FK goes on the many side. Resolve M:N with a link table. Use one clear notation.
  6. What Big Data is: the five Vs
    Five Vs: volume (amount), velocity (speed), variety (formats), veracity (trustworthiness), value (useful insight). Most Big Data is semi-structured or unstructu
  7. Big Data infrastructure and the impact of storing it
    Collect from many automatic sources; store with distributed systems, NoSQL, MPP, cloud, warehouses and lakes; transmit with fibre, compression and faster protoc
  8. Data mining, data warehousing and data analytics
    Warehouse: integrated historical data loaded by ETL. Mining: finds hidden patterns (association, classification, clustering, anomalies). Analytics: descriptive
  9. Uses of Big Data by individuals, organisations and society
    Uses: healthcare, infrastructure planning, transportation, fraud detection. Benefits for individuals, organisations and society are balanced by privacy, consent
  10. Virtualisation: virtual machines and containers
    Virtualisation = software-simulated resources sharing physical hardware. VMs: hypervisor, full guest OS, strong isolation. Containers: engine, shared kernel, li
  11. Distributed systems and their issues
    Distributed system = networked nodes acting as one. Needed for scale, performance, reliability and geography. Issues: failure (partial failure, partitions), con
  12. Human computer interaction: why it matters and how it is implemented
    Effective HCI raises productivity and satisfaction, cuts errors and training and improves accessibility. Implemented visually (screens, gestures), by audio (spe
  13. Ergonomics and interface design for individuals and organisations
    Ergonomics fits systems to people physically and mentally: comfort, consistency, feedback, low cognitive load, error prevention. WIMP: windows, icons, menus, po
  14. Cloud storage, file encryption and password protection
    Cloud storage: data replicated across remote data centres, accessed over the internet; flexible but depends on connection and a third party. Encryption makes st
  15. Controlling access and views with a DBMS
    DBMS functions include security. Authenticate, then authorise: discretionary, mandatory, role-based, rule-based; grant and revoke privileges; least privilege. V
  16. Symmetric and asymmetric encryption
    Symmetric: one shared key, fast, key distribution problem, n(n-1)/2 keys. Asymmetric: public and private keys, slower, solves distribution, 2n keys. Encrypt wit
  17. Certificate-based encryption and digital certificates
    A digital certificate binds a public key to an identity and is signed by a certificate authority. Browsers check the signature, dates, domain and revocation, th
  18. The role of IT systems in organisations
    Five roles: operational support, collaboration, knowledge management, product development, service delivery. Always apply them to the scenario and give the bene
  19. Transaction processing systems
    Transaction processing records business events quickly, accurately and atomically, in real time or in batches. Examples: EPOS, order processing, financial syste
  20. Customer relationship management and management information systems
    CRM: one customer view for marketing events, loyalty, trends, service, retention, upselling. MIS: turns data into summarised information for record-keeping, dec
  21. Intelligent transportation systems and expert systems
    ITS: scheduling and route planning, timetabling, live locations, fleet management. Expert system: knowledge base, inference engine, user interface, explanation
  22. IT governance, policy and disaster recovery planning
    IT governance: business continuity, disaster recovery, risk management, user policy. Risk = likelihood x impact; avoid, reduce, transfer or accept. A disaster r
  23. Changeover methods: direct, parallel, phased and pilot
    Direct: fast, cheap, risky. Parallel: safe, expensive. Phased: one part at a time. Pilot: one site first. Justify the choice from how critical the system is, bu
  24. System maintenance and archiving data
    Corrective fixes bugs; adaptive responds to changes in environment or rules; perfective improves a working system. Archiving moves inactive data to long-term st
  25. Project management, successful projects and SMART targets
    Project management controls time, cost, scope and risk. Successful projects: on time, on budget, meet requirements, clear objectives, user involvement, good pla
  26. Planning tools: precedence tables, Gantt charts and critical path analysis
    Precedence table: tasks, durations, predecessors. Forward pass gives earliest times (take the largest), backward pass latest times (take the smallest). Float =
  27. The waterfall method
    Waterfall: linear phases, each completed and signed off: requirements/analysis, design, implementation, testing/debugging, installation, maintenance. Good for s
  28. The agile approach: iterative, incremental, scrum and sprints
    Agile: iterative (repeat cycles) and incremental (add working parts). Phases: requirements, plan, design, develop, release, repeated. Scrum: product owner, scru
  29. Information flow diagrams
    Information flow diagrams: entities (people, departments, organisations, systems) as simple shapes, labelled arrows showing what information moves and in which
  30. Machine learning: supervised, unsupervised and its uses
    ML learns patterns from data. Supervised: labelled data, predicts labels (classification, regression). Unsupervised: unlabelled data, finds groups and anomalies
  31. Virtual reality and augmented reality
    VR: fully immersive virtual world via headset; training, education, design, games, therapy. AR: digital overlay on the real world via phone, glasses or HUD; ret
  32. The Internet of Things: concept and impact
    IoT = everyday objects with sensors, processing and connectivity that collect and share data and act automatically. Impacts: convenience and efficiency versus p
  33. IoT infrastructure and security issues
    IoT infrastructure: sensors (and actuators), networks (WSN, M2M, low-power protocols, gateways, IPv6), embedded systems (cheap, low-power, limited), storage (de
  34. Producing high-level designs for IoT systems
    IoT design: sensors and actuators, controller, IoT hub (gateway), labelled network links, cloud storage and rules, user app, security. Simple labelled shapes, l
  35. Unit 3 exam technique: the paper and the command words
    2 hours, 80 marks, all questions, June only, 25% of the A level. Most marks are for application and design. Explain = point + linked expansion. Apply every answ
  36. Extended answers: discuss and evaluate with the levels-based mark schemes
    6-mark discuss: accurate knowledge, coherent, balanced, developed, applied; no conclusion needed. 12-mark evaluate: all that plus competing arguments and a conc

Next exams for WIT13

From Pearson's final timetables. All exam dates. Always confirm your entries with your exams officer.