Core syllabus content SL core The topics that must be studied, including some practical work are: • Topic 1: System fundamentals (20 hours) • Topic 2: Computer organization (6 hours) • Topic 3: Networks (9 hours) • Topic 4: Computational thinking, problem-solving and programming (45 hours)

Content overview Candidates study the following topics: Computer systems 1 Data representation 2 Data transmission 3 Hardware 4 Software 5 The internet and its uses 6 Automated and emerging technologies Algorithms, programming and logic 7 Algorithm design and problem-solving 8 Programming 9 Databases 10 Boolean logic

**Designing Strong Bridges with Popsicle Sticks ** with marking scheme Introduce the problem statement. In this project, your challenge is to design and build a bridge using only popsicle sticks and glue. Your goal is to create a bridge that showcases strong structural concepts and makes the most of how much weight it can carry compared to its own weight. The focus is on making a bridge that works really well and can support a lot of weight while using only a few materials. Let’s explore the world of building strong bridges and see how well you can balance making it strong and creative in your design.

Chapter 10 - Boolean logic Candidates should be able to: 1 Identify and use the standard symbols for logic gates 2 Define and understand the functions of the logic gates 3 (a) Use logic gates to create given logic circuits from a: (i) problem statement (ii) logic expression (iii) truth table (b) Complete a truth table from a: (i) problem statement (ii) logic expression (iii) logic circuit © Write a logic expression from a: (i) problem statement (ii) logic circuit (iii) truth table Notes and guidance: • See section 4 for logic gate symbols • Including: – NOT – AND – OR – NAND – NOR – XOR (EOR) – the binary output produced from all the possible binary inputs • NOT is a single input gate • All other gates are limited to two inputs • Circuits must be drawn for the statement given, without simplification • Logic circuits will be limited to a maximum of three inputs and one output

Chapter 9- Databases Candidates should be able to: 1 Define a single-table database from given data storage requirements 2 Suggest suitable basic data types 3 Understand the purpose of a primary key and identify a suitable primary key for a given database table 4 Read, understand and complete structured query language (SQL) scripts to query data stored in a single database table Notes and guidance • Including: – fields – records – validation • Including: – text/alphanumeric – character – Boolean – integer – real – date/time • Limited to: – SELECT – FROM – WHERE – ORDER BY – SUM – COUNT • Identifying the output given by an SQL statement that will query the given contents of a database table

Paper 2: Algorithms, programming and logic Chapter 8: Programming 8.1 Programming concepts 8.2 Arrays 8.3 File handling

Year 7/8/9 Test 1- Excel Spreadsheet

IB DP Year 12/13- Test 5- Topic 3- Networks with Question and Answers

** IGCSE Computer Science -Year 10/11 ** 2023/2024 updated version Chapter 7-Algorithm design and problem-solving: ** Learning Objectives: ** 1 Understand the program development life cycle, limited to: analysis, design, coding and testing. 2 (a) Understand that every computer system is made up of sub-systems, which are made up of further sub-systems (b) Understand how a problem can be decomposed into its component parts © Use different methods to design and construct a solution to a problem 3 Explain the purpose of a given algorithm 4 Understand standard methods of solution 5 (a) Understand the need for validation checks to be made on input data and the different types of validation check (b) Understand the need for verification checks to be made on input data and the different types of verification check. 6 Suggest and apply suitable test data 7 Complete a trace table to document a dry-run of an algorithm. 8 Identify errors in given algorithms and suggest ways of correcting these errors. 9 Write and amend algorithms for given problems or scenarios, using: pseudocode, program code and flowcharts

IGCSE Cambridge Computer Science Approved Pseudocode and logical gate

IB DP Computer Science -Y12/13- Internal Assessment (IA) The Internal Assessment for Computer Science is an opportunity for you to showcase your algorithmic and technical prowess at developing software intended to solve a legitimate, real world problem for someone.

Paper 2 : Option 4—Database (SL -30 hours) A.1 Basic concepts (5 hours) A.2 The relational database model (15 hours) A.3 Further aspects of database management (10 hours) HL Extension A.4 Further database models and database analysis (15 hours)- In Progress

IB DP Computer Science - Year 12/13 - Test 2- V2 - Topic 2

Topic 4—Computational thinking, problem-solving and programming (45 hours) 4.1 General principles (10 hours) 4.2 Connecting computational thinking and program design (22 hours) 4.3 introduction to programming (13 hours)

IB DP Computer Science Past Paper 1 and 2 (Year 2023)

IGCSE Computer Science for Year 10 and 11- Term 1-Test 2 from chapter 2 /3 and 4 Questions and Answers

IB DP Year 12/13-Test 4-Topic 2 and 3 with Question and Answers

IB DP Year 12/13-Test 3 - Topic 2 with Question and Answers

Welcome to Project 2, our exciting STEAM (Science, Technology, Engineering, Arts, and Mathematics) journey into Car Construction. In this project, we will explore the fascinating world of automotive design and engineering. Objectives: Main objectives for this project are: To learn the fundamental principles of car design and construction. To develop creativity and problem-solving skills by building a Bugatti-inspired car model. To understand the potential of incorporating Sensors , Arduino and other components to enhance your car’s functionality and performance. Making It Smart: One exciting aspect of this project is the opportunity to make our cars smarter by incorporating sensors and additional components. As we progress, we may explore how these technological elements can take our car construction to the next level. Let’s get started on this thrilling journey of innovation and hands-on learning

IB DP - Approved notation for developing pseudocode