T-Levels Digital Production, Design and Development Syllabus

Digital Production, Design and Development syllabus — full chapter and topic list

Expand any chapter to see its topics and sub-topics. This is the whole examinable outline for Digital Production, Design and Development in T-Levels, not a summary of it.

1. 1

   Core Component: Digital Concepts and Theory

   4 topics

   • How digital technologies impact business and society
     • Productivity, automation and changing work patterns
     • Ethical, legal and environmental impacts of digital systems
     • Digital inclusion and accessibility considerations
   • Data and information management
     • Data types, structures and relational database concepts
     • Data quality, validation and integrity
     • GDPR and Data Protection Act principles
   • Digital environments and infrastructure
     • Client-server, cloud and on-premises models
     • Operating systems, networks and virtualisation
   • Emerging issues and impact of digital
     • Artificial intelligence and machine learning concepts
     • Internet of Things and big data
2. 2

   Security, Risk and Legislation

   4 topics

   • Threats, vulnerabilities and attack vectors
     • Malware, phishing and social engineering
     • Internal versus external threats
   • Security controls and mitigation
     • Encryption, authentication and access control
     • Firewalls, backups and disaster recovery
   • Legislation and standards
     • Computer Misuse Act and copyright
     • Industry standards and codes of practice
   • Risk assessment and management
3. 3

   Planning and Managing Digital Projects

   4 topics

   • Project lifecycle and methodologies
     • Waterfall versus Agile and Scrum
     • Iterative and incremental delivery
   • Requirements gathering and analysis
     • Functional and non-functional requirements
     • User stories and acceptance criteria
   • Stakeholder communication and documentation
   • Testing, quality assurance and review
4. 4

   Occupational Specialism: Software Development

   4 topics

   • Programming fundamentals
     • Variables, data types and control structures
     • Functions, procedures and object-oriented concepts
   • Analysis and design of software solutions
     • Algorithms, flowcharts and pseudocode
     • UML and design patterns
   • Implementation and coding standards
   • Testing, debugging and maintenance
     • Unit, integration and system testing
     • Version control and refactoring
5. 5

   Occupational Specialism: Digital Design and Development

   4 topics

   • User experience and interface design
     • Wireframing and prototyping
     • Accessibility and usability principles
   • Front-end development
     • HTML, CSS and responsive design
     • Client-side scripting and frameworks
   • Back-end and database integration
   • Deployment and evaluation of digital products

Digital Production, Design and Development flashcards for T-Levels

20 of 56 cards from the Digital Production, Design and Development deck — real questions with worked answers.

1. In the context of digital technologies and business, what is meant by 'disruptive technology'?

   A technology or innovation that significantly alters or displaces an established market, industry or business model (e.g. streaming replacing physical media, ride-hailing apps disrupting taxis), often creating new value networks while making older approaches obsolete.

2. Define the 'digital divide' and name two factors that cause it.

   The gap between people who have effective access to digital technology and those who do not. Causes include socio-economic status (cost of devices/internet), geography (rural broadband availability), age/digital literacy, and disability.

3. List the three components of the 'triple bottom line' used to assess the wider impact of digital technology on society.

   People (social impact), Planet (environmental impact) and Profit (economic impact) — sometimes summarised as social, environmental and economic sustainability.

4. Distinguish between 'data' and 'information' in data management.

   Data is raw, unprocessed facts and figures with no context (e.g. the number 42). Information is data that has been processed, organised or given context so it becomes meaningful and useful for decision-making (e.g. 42 = a customer's age).

5. What does the DIKW pyramid stand for, from bottom to top?

   Data, Information, Knowledge, Wisdom — representing the progression from raw facts to contextualised information, to applied knowledge, to the judgement to use it appropriately.

6. Name the three states in which data can exist and must be protected.

   Data at rest (stored on disk/database), data in transit/in motion (moving across a network), and data in use (being processed in memory or by an application).

7. Compare structured, semi-structured and unstructured data with one example of each.

   Structured: organised in a fixed schema, e.g. a relational database table. Semi-structured: has tags/markers but no rigid schema, e.g. JSON or XML. Unstructured: no predefined model, e.g. emails, images, video or free text.

8. In a relational database, what is the difference between a primary key and a foreign key?

   A primary key uniquely identifies each record in a table (no duplicates, not null). A foreign key is a field in one table that references the primary key of another table, enforcing referential integrity and linking the two tables.

9. Define 'cloud computing' and name its three main service models.

   On-demand delivery of computing resources (servers, storage, software) over the internet on a pay-as-you-go basis. The three service models are IaaS (Infrastructure as a Service), PaaS (Platform as a Service) and SaaS (Software as a Service).

10. Distinguish between IaaS, PaaS and SaaS by what the provider manages.

    IaaS: provider manages the hardware/virtualisation, you manage OS and apps (e.g. AWS EC2). PaaS: provider also manages OS and runtime, you manage apps/data (e.g. Azure App Service). SaaS: provider manages everything, you just use the software (e.g. Office 365).

11. What is virtualisation and what software component enables it?

    Virtualisation is running multiple isolated virtual machines on a single physical host, sharing its resources. It is enabled by a hypervisor (e.g. VMware ESXi, Hyper-V), which allocates CPU, memory and storage to each VM.

12. Differentiate a LAN, a WAN and a PAN.

    LAN (Local Area Network): covers a small area like one building. WAN (Wide Area Network): spans large geographic areas, e.g. the internet, often linking multiple LANs. PAN (Personal Area Network): very short range around one person, e.g. Bluetooth devices.

13. Name two emerging digital technologies and one ethical issue each raises.

    Artificial Intelligence — algorithmic bias and lack of accountability. Internet of Things (IoT) — privacy and insecure device surveillance. (Others: blockchain — energy use; deepfakes — misinformation.)

14. In the CIA triad of information security, what do the three letters stand for?

    Confidentiality (only authorised access), Integrity (data is accurate and unaltered) and Availability (data/systems are accessible when needed).

15. Define the terms 'threat', 'vulnerability' and 'risk' in cyber security.

    A threat is a potential cause of harm (e.g. a hacker, malware). A vulnerability is a weakness that a threat can exploit (e.g. unpatched software). Risk is the likelihood and impact of a threat exploiting a vulnerability.

16. What is an 'attack vector'? Give two examples.

    An attack vector is the path or method an attacker uses to gain unauthorised access to a system. Examples: phishing emails, malware-infected USB drives, unpatched software exploits, and SQL injection.

17. Distinguish between phishing, spear phishing and whaling.

    Phishing: mass deceptive messages to trick any user into revealing data. Spear phishing: targeted at a specific individual or organisation using personalised information. Whaling: spear phishing aimed at senior executives/high-value targets.

18. What is the difference between a virus, a worm and a Trojan?

    A virus attaches to a file and needs the user to run it to spread. A worm self-replicates and spreads across networks without user action. A Trojan disguises itself as legitimate software to trick users into installing it.

19. Explain what a SQL injection attack does and one way to prevent it.

    A SQL injection inserts malicious SQL through user input fields to read, alter or delete database data, or bypass authentication. Prevention: use parameterised queries/prepared statements and validate/sanitise all input.

20. What is a Distributed Denial of Service (DDoS) attack, and which part of the CIA triad does it target?

    A DDoS attack floods a system or network with traffic from many compromised machines (a botnet) to overwhelm it and make it unavailable. It primarily targets Availability.

See more Digital Production, Design and Development flashcards →

Planning Digital Production, Design and Development for T-Levels

Digital Production, Design and Development (T-Levels) FAQ