Lesson Objectives All of you will… Draw simple shapes using the turtle Understand the use of different commands such as move forward, backward, left, right Most of you will… Use computational thinking skills to look for repeating patterns and include them in your programming Table of Contents: Lesson 1: Motion Commands with Python turtle module Lesson 2: Main Colour Commands Lesson 3: Main Circle Commands Lesson 4: More Color Examples Lesson 5: Turtle Shapes Lesson 6: Loopy loops in Python Lesson 7: Numbers, Variables, functions print and input Lesson 8: Logical Operators, Conditional Statements Lesson 9: Strings, Lists Lesson 10: Random Numbers Lesson 11: Functions

IB DP Computer Science Approved notation for developing pseudocode Pseudocode in Examinations • Standard Data Structures • Examples of Pseudocode

Attached Computational Thinking Exam with solution , Computational Thinking classroom activities and full CT lesson by CS Unplugged for year 6/7/8/9 pupils.

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.

Revision Python print/input and data type for Year 8 and 9

In Term 1- This course is designed to provide students with fundamental Knowledge related to computer science. It also introduces students to Computational thinking and how computers work. In Term 2 - introduce students to computer programming and games in a fun and exciting way. The Scratch software used in this transition unit was designed with this goal in mind. Students will be able to write their own programs, animations and stories in a matter of minutes. Students will learn how to plan and design projects. They will learn how to work together on a plan in teams and they will have the opportunity to present their work to their peers and teachers. They will learn how to respond and react to feedback. They will research a project on the Internet and learn how to evaluate information on websites. In Term 3 - introduce students to computer programming and games in a fun and exciting way. The Scratch software used in this transition unit was designed with this goal in mind. Students will be able to write their own programs, animations and stories in a matter of minutes. Students will learn how to plan and design projects. They will learn how to work together on a plan in teams and they will have the opportunity to present their work to their peers and teachers. They will learn how to respond and react to feedback. They will research a project on the Internet and learn how to evaluate information on websites.

1- Define hardware as consisting of physical components of a computer system 2- Identify internal hardware devices (e.g. motherboards, random access memory (RAM), read-only memory (ROM), video cards, sound cards and internal hard disk drives) 3- Identify external hardware devices and peripherals (such as monitors, keyboards, mice, printers as input and output device 4- Define software as programs for controlling the operation of a computer or processing of electronic data 5- Identify the two types of software applications software and systems software 6- Define applications software (e.g. word processing, spread sheet, database management systems, control software, measuring software , photo-editing software, video-editing software, graphics manipulation software) 7- Define system software (e.g. compilers, linkers, device A big thanks for Mr Ahmed for his tremendous effort on the IGCSE ICT

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

Year 7/8/9 Project 2- Computer Shop - Excel Spreadsheet

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

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)

Year 7/8/9 Project 1- Party- Excel Spreadsheet

Students should be able to: Roles of the different computers within the network and subnetwork models Benefits and drawbacks of each model Justify the use of a model for a given situation Understand how packets are transmitted between two hosts for a given topology Justify the use of a topology for a given situation Including the use of public and private clouds. Benefits and drawbacks of cloud computing Describe the characteristics of copper cable, fibreoptic cable, radio waves (including WiFi), microwaves, satellites Including switch, server, Network Interface Card (NIC), Wireless Network Interface Card (WNIC), Wireless Access Points (WAP), cables, bridge, repeater Including Carrier Sense Multiple Access / Collision Detection (CSMA / CD) Methods of bit streaming, i.e. real-time and on-demand Importance of bit rates / broadband speed on bit streaming Including modems, PSTN (Public Switched Telephone Network), dedicated lines, cell phone network • format of an IP address including IPv4 and IPv6 • use of subnetting in a network • how an IP address is associated with a device on a network • difference between a public IP address and a private IP address and the implications for security • difference between a static IP address and a dynamic IP address

Year 7/8/9 Test 1- Excel Spreadsheet

Learning objectives : VLOOKUP and HLookUp Understand the use of the Vlookup function Understand the use of absolute cell referencing. Understand the use of an nested if statement. Understand the used of the different count functions. Understand the use of the sumif function.

Step By Step Microsoft Outlook 2010 Guide for beginner Please feel free to add a review thank you Mr N.T

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

IGCSE Cambridge Computer Science Approved Pseudocode and logical gate

Diploma Programme Computer science guide and curriculum