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.
Lessons in WIT13
- 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 - 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 - 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 - 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 - 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. - 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 - 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 - Data mining, data warehousing and data analytics
Warehouse: integrated historical data loaded by ETL. Mining: finds hidden patterns (association, classification, clustering, anomalies). Analytics: descriptive - 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 - Virtualisation: virtual machines and containers
Virtualisation = software-simulated resources sharing physical hardware. VMs: hypervisor, full guest OS, strong isolation. Containers: engine, shared kernel, li - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - Transaction processing systems
Transaction processing records business events quickly, accurately and atomically, in real time or in batches. Examples: EPOS, order processing, financial syste - 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 - 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 - 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 - 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 - 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 - 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 - 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 = - The waterfall method
Waterfall: linear phases, each completed and signed off: requirements/analysis, design, implementation, testing/debugging, installation, maintenance. Good for s - 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 - Information flow diagrams
Information flow diagrams: entities (people, departments, organisations, systems) as simple shapes, labelled arrows showing what information moves and in which - 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 - 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 - 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 - 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 - 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 - 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 - 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
- Summer 2027: Fri 28 May 2027, morning, 2h 00m
From Pearson's final timetables. All exam dates. Always confirm your entries with your exams officer.