Activities
A 3.3.4 Worksheet Answers
SQL Query: Expected Result: 84.5 SQL Query: Expected Result: 20 SQL Query: Expected Result: 95 SQL Query: Expected Result: 70 SQL Query: Expected Result: 1690 SQL Query: Expected Result: History 84.3333333333333 ...
eBook
A 3.3.4 SQL Aggregate Functions (HL Only)
SQL aggregate functions (AVG, COUNT, MAX, MIN, SUM) perform calculations on grouped data for reporting and decision-making within a database. (HL only) In many real-world scenarios, you won't just need...
Assessment
Internal Assessment - Sample Submission
Let’s review the Computer Science Internal Assessment submission requirements for the May and November 2026 sessions. Apart from the Computer Science Guide (CSG) and Teacher Support Materials (TSM) we...
Activities
Case Study Activities - Module 5
CyberHealth Security is hired to conduct penetration testing on MedTechPro Hospital (MTPH), which heavily uses technology like EHRs and IoT devices. Using the 7-phase PTES standard, they'll assess network...
Activities
Case Study Activities - Module 5 - Full Paper Practice
Below are "model" responses that would achieve high marks. 1. Explain two problems that may arise during the data migration phase if MTPH merges with another hospital. (4 marks) 1. Incompatible Data Structures:...
Teacher Resources (new)
B 2.4.4 Recursion (HL Only)
Unlock the power of recursion! This section explores the fascinating world of recursive programming. Learn how functions can call themselves to solve problems, discover the advantages and limitations...
Activities
B 2.4.4 Worksheet Python Answers
Function A: fibonacci(n) Function B: sum_of_digits(n) Function A: print_numbers(n) The Fix: Add a condition to stop when n reaches a certain point (usually 0 or 1). Function B: factorial(n) The Fix: Define...
Activities
B 2.4.4 Worksheet Java Answers
Part 1: Code Analysis Analyze the recursive Java methods: fibonacci(int n): sumOfDigits(int n): Compare recursive and iterative implementations of power: Part 2: Identifying Potential Issues Examine the...
Activities
A 3.3.2 Worksheet
Instructions: Database Schema (Example - Adapt to your provided database): Table: Students Table: Courses You can use these SQL commands to create the tables and fill them with suitable data: Questions:...
Activities
A 3.2.7 Student Activity Answer
Denormalization Approach: To improve the performance of displaying a product list with category names, I could denormalize the database by adding the CategoryName column directly to the Products table....