The Study Podcast
HTQ Computing: The Study Podcast
80 episodes covering 15 units | Hosts: Alex with Sam, Computing Specialist
About This Podcast
The Study Podcast is your companion series for the Pearson BTEC Higher Nationals in Computing. Each episode features Alex, your host, in conversation with Sam, a computing specialist. Together they break down the key concepts from each lesson into accessible, engaging discussions.
Whether you are enrolled on the course or exploring what the HTQ covers, these episodes offer a clear, conversational introduction to each topic.
All Episodes
Unit 1: Programming
2
3
4
5
6
7
Understanding Algorithms: The Building Blocks of Code
Algorithms are at the heart of every piece of software ever written, and this lesson unpacks what they actually are and ...
Procedural Programming: Step-by-Step Code Execution
Procedural programming is one of the oldest and most widely used paradigms in software development, and understanding it...
Object-Oriented Programming: Classes, Objects and Inheritance
Object-oriented programming transformed the way developers build complex software, and this lesson explains why. You wil...
Event-Driven Programming: Responding to User Actions
Event-driven programming powers everything from graphical user interfaces to web applications, and this lesson explains ...
Implementing Algorithms in an IDE: Tools and Techniques
Writing code is one thing; writing code efficiently inside a professional development environment is another. This lesso...
Debugging and Coding Standards: Writing Reliable Software
Every developer encounters bugs, and knowing how to find and fix them systematically is a core professional skill. This ...
Unit 2: Networking
8
9
10
11
12
13
Networking Fundamentals: Principles and Protocols Explained
Networking is the invisible backbone of the modern digital world, and this lesson builds your foundational understanding...
Networking Devices: Routers, Switches and Their Roles
Networks are built from physical and virtual devices, each performing a specific role in moving data to its destination....
Network Topologies: Choosing the Right Architecture
The physical or logical arrangement of a network has a significant impact on its performance, reliability, and cost, and...
Designing Efficient Networked Systems: Planning for Scale
Designing a network that performs well today and scales tomorrow requires careful planning and an understanding of sever...
Implementing Networks: Configuration and Connectivity
Theory becomes practice in this lesson as you explore how networks are actually implemented and configured. From assigni...
Network Diagnostics: Troubleshooting Common Problems
When a network stops working, the ability to diagnose the problem quickly is invaluable, and this lesson gives you the t...
Unit 3: Professional Practice
14
15
16
17
18
Communication Skills for Computing Professionals
Being technically skilled is not enough on its own; computing professionals also need strong communication abilities to ...
Critical Thinking and Reasoning in a Technical Context
Computing problems are rarely simple, and working through them requires the ability to reason carefully, question assump...
Team Dynamics in Computing Projects: Collaboration and Conflict
Most computing projects involve teams, and understanding how those teams function is key to delivering successful outcom...
Continuing Professional Development: Staying Ahead in Tech
Technology evolves rapidly, and professionals who fail to keep up risk being left behind. This lesson examines Continuin...
Ethics and Professional Responsibility in Computing
Computing professionals face a growing range of ethical dilemmas, from data privacy and algorithmic bias to intellectual...
Unit 4: Database Design and Development
19
20
21
22
23
24
Relational Database Concepts: Tables, Keys and Relationships
Relational databases are the most widely used form of data storage in the world, and this lesson introduces the core con...
Entity-Relationship Diagrams: Modelling Data Structures
Entity-Relationship diagrams are the standard tool for visualising and communicating database designs, and this lesson t...
Normalisation: Eliminating Redundancy in Database Design
Data redundancy and inconsistency are two of the biggest problems in poorly designed databases, and normalisation is the...
Building a Relational Database: SQL and Practical Development
With a solid design in place, the next step is building the database itself, and this lesson takes you through the pract...
Database Testing: Verifying Against Requirements
A database that does not do what users need it to do is not fit for purpose, and this lesson focuses on how to test your...
Technical and User Documentation for Databases
Good documentation is what separates a professional database product from an informal prototype, and this lesson covers ...
Unit 5: Security
25
26
27
28
29
Assessing IT Security Risks: Threats, Vulnerabilities and Impact
Every IT system faces threats, and the first step in managing security is understanding what those threats are. This les...
IT Security Solutions: Firewalls, Encryption and Access Controls
Once you understand the risks, the next step is knowing what tools and techniques are available to counter them. This le...
Controlling Organisational IT Security: Policies and Procedures
Technical tools alone are not enough to secure an organisation; policies, procedures, and human behaviour are equally im...
Managing Organisational Security: Governance and Compliance
Managing security in an organisation requires a strategic, governance-led approach that goes beyond day-to-day technical...
Cyber Attack Types: From Phishing to Advanced Persistent Threats
Understanding the full range of cyber attack techniques is essential for building effective defences, and this lesson ta...
Unit 6: Planning a Computing Project
30
31
32
33
34
Defining Your Computing Project: Scope, Aims and Research Questions
Every successful computing project starts with a clearly defined scope, and this lesson guides you through the process o...
Research Methods and Data Collection for Computing Projects
Reliable data is the foundation of any credible project, and this lesson explores the range of research methods availabl...
Exploring Business Requirements: Stakeholder Needs and Technical Feasibility
Successful computing projects must meet both technical and business requirements, and this lesson focuses on how to iden...
Project Planning Techniques: Gantt Charts, Milestones and Risk Registers
A project without a plan is a project heading for trouble, and this lesson equips you with the tools to create robust, r...
Presenting Recommendations: Communicating Findings to Stakeholders
Gathering data and drawing conclusions is only valuable if you can communicate your findings persuasively to the people ...
Unit 7: Software Development Lifecycles
35
36
37
38
39
Introduction to Software Development Lifecycles: A Comparative Overview
Software development lifecycles provide the structured frameworks that guide how software is built from initial idea to ...
Waterfall vs Agile: When Each Methodology Fits
The debate between Waterfall and Agile is one of the most important in software development, and this lesson gives you t...
Feasibility Studies: Assessing Technical and Business Viability
Before a software project begins in earnest, it is vital to assess whether it is actually worth doing, and the feasibili...
Running an SDLC in Practice: Requirements to Delivery
Understanding lifecycle models in theory is one thing; applying them in practice is another, and this lesson bridges the...
Software Behavioural Design: Use Cases, UML and Modelling
Software does not just need to work correctly; it needs to behave in ways that users can predict and rely on, and this l...
Unit 8: Management in the Digital Economy
40
41
42
43
44
Organisational Structures in the Digital Era
The digital economy has transformed the way organisations are structured and managed, and this lesson examines those cha...
Stakeholders in Digital Organisations: Roles, Interests and Influence
Every organisation operates within a web of stakeholders whose interests, expectations, and levels of influence vary eno...
Digital-Led Management: Leadership in Technology-Driven Businesses
Technology-driven organisations require leaders who understand not just the business but also the digital tools and syst...
Motivation and Performance in Digital Teams
Building high-performing digital teams requires an understanding of what motivates people and how behaviour influences o...
Digital Transformation: Managing Organisational Change
Digital transformation is one of the most significant challenges facing organisations today, requiring them to rethink p...
Unit 9: Computing Research Project
45
46
47
48
49
Introduction to Computing Research Methodologies
Rigorous research is the foundation of credible computing scholarship, and this lesson introduces the methodological lan...
Quantitative vs Qualitative Research: Choosing Your Approach
One of the most fundamental decisions in any research project is whether to take a quantitative, qualitative, or mixed-m...
Conducting Computing Research: Data Collection and Analysis
With a methodology in place, the work of actually collecting and analysing data begins, and this lesson takes you throug...
Communicating Research Outcomes: Reports, Presentations and Artefacts
Research findings are only valuable if they reach the right audience in an accessible and compelling form, and this less...
Reflecting on Research: Critical Evaluation of Methods and Findings
Critical self-reflection is what distinguishes a good researcher from a great one, and this lesson develops your ability...
Unit 10: Business Process Support
50
51
52
53
54
The Role of Data in Modern Business Processes
Data has become one of the most valuable assets in modern business, but its role in supporting business processes is oft...
Data Ethics and Governance: Implications of How We Use Information
The widespread use of data brings with it serious ethical and legal responsibilities, and this lesson examines those imp...
Data Science Tools and Technologies: An Applied Overview
Data science is a rapidly evolving field with a rich ecosystem of tools and technologies, and this lesson gives you a co...
Applying Data Science Techniques to Business Problems
Understanding data science techniques in theory is one thing; applying them to real business problems is another, and th...
Data Visualisation and Storytelling for Business Decisions
Data alone does not drive decisions; it is the clear and compelling presentation of data that influences action, and thi...
Unit 11: Systems Analysis and Design
55
56
57
58
59
Traditional vs Agile Systems Analysis: Comparing Methodologies
Systems analysts have a range of methodologies to choose from, and understanding which to apply in which context is a cr...
Conducting a Systems Feasibility Study: What Makes a Project Viable?
Before any system is built, there must be a credible case for building it, and the feasibility study is the document tha...
Systems Analysis Methodologies: SSADM, DSDM and Beyond
Systems analysis has a rich history of structured methodologies, and this lesson examines some of the most significant o...
Designing Systems to Meet Requirements: From Concept to Blueprint
A system that meets user needs is built from a well-thought-out design, and this lesson walks you through the design pro...
User Requirements and System Specifications: Getting It Right
Getting requirements right is one of the hardest challenges in systems development, and this lesson explores the techniq...
Unit 12: Network Management
60
61
62
63
64
Network Management Concepts: Monitoring, Performance and Availability
Managing a network involves far more than just keeping it running; it means actively monitoring performance, maintaining...
Planning and Designing a Managed Network Infrastructure
Planning a managed network begins with a clear understanding of the organisation's requirements and constraints, and thi...
Configuring and Setting Up Network Systems: Hands-On Approaches
Network configuration is where design meets reality, and this lesson takes you through the practical process of setting ...
Network Protocols and Standards: SNMP, ICMP and Compliance
Standards and protocols are the common language that makes networks interoperable, and this lesson examines the key ones...
Network Management Tools: Security Monitoring and Threat Detection
Modern networks are managed and secured using a range of specialist tools, and this lesson introduces the most important...
Unit 13: Database Management Systems
65
66
67
68
69
Types of Database Management Systems: Relational, NoSQL and NewSQL
The database landscape has expanded enormously beyond traditional relational systems, and this lesson gives you a compre...
Designing a DBMS Using the Relational Model: Advanced Techniques
Designing a database at the Level 5 HND stage requires a deeper level of rigour and sophistication than the foundational...
Developing a Database Management System: Platform Selection and Build
Choosing the right platform for your DBMS is as important as the design itself, and this lesson explores how to make tha...
Database Administration: User Management, Backups and Recovery
Database administration is a specialised and highly valued computing discipline, and this lesson introduces its core res...
Query Optimisation and Performance Tuning in DBMS
A slow query can bring a busy application to its knees, and knowing how to identify and fix performance bottlenecks is a...
Unit 14: Internet of Things
70
71
72
73
74
IoT Fundamentals: Architecture, Devices and Connectivity
The Internet of Things is reshaping industries from agriculture to healthcare, and this lesson provides the foundational...
Planning an IoT Application: Requirements, Sensors and Data Flows
Turning an IoT concept into a working application starts with a well-structured plan, and this lesson guides you through...
Developing an IoT Application: Platforms, Protocols and Prototyping
Developing an IoT application involves combining hardware, firmware, connectivity, and software in ways that require car...
Evaluating IoT Applications: Performance, Security and Usability
Building an IoT application is only the beginning; evaluating its performance, security, usability, and reliability is w...
IoT Integration Challenges: Interoperability, Scalability and Standards
IoT systems rarely exist in isolation; they must integrate with existing IT infrastructure, third-party services, and ot...
Unit 15: Digital Sustainability
75
76
77
78
79
80
Technical Challenges for Digital Sustainability: Scope and Scale
The technology sector is one of the largest contributors to global energy consumption and carbon emissions, and this les...
Cross-Disciplinary Collaboration for Sustainable Technology
Achieving meaningful progress on digital sustainability requires computing professionals to work alongside colleagues fr...
Sustainable Software and Hardware: Green Computing Techniques
Green computing encompasses a range of techniques for reducing the environmental impact of software and hardware, and th...
Calculating Carbon Footprint: Measuring Digital Environmental Impact
You cannot manage what you cannot measure, and calculating the carbon footprint of digital systems is a critical first s...
Energy-Efficient Data Centres and Cloud Infrastructure
Data centres consume vast amounts of energy, and the choices made in designing and operating them have significant envir...
Building a Sustainable Digital Future: Strategy, Policy and Action
This final lesson brings together everything you have learned about digital sustainability and looks forward to the chal...