Excel Spreadsheets Full Lesson If Statements and Graph **Objectives ** • Understand the use of absolute cell referencing. • Understand the use of simple functions (sum,max,min and average in a spreadsheet. • Understand the use of If statements including the logical, true and false statements. • Understand how calculations can be used as True statements • Understand the use of nested if statements including more than one true statement. • Understand the use of count and sum if functions. • Understand the need the need to present data in a graph format. • Understanding the need to present information in different forms (graphs)

Year 7/8/9 Project 3- IF statement - Excel Spreadsheet

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

16.1 - Purposes of an Operating System (OS) 16.2 - Translation Software

5.1 Operating System 5.2 Language Translators

Python 3 Sheet from KS3/4 and 5 . From Laurent Pointal (License Creative Commons Attribution 4) . thanks to a wonderful resources from Laurent Pointal (License Creative Commons Attribution 4)

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

Attached year 8 python programming practical test 1, 2 and end of term exam Please feel free to leave any comments and rate the review . Thank you Mr. N.T

2.1 Networks including the internet

15.1 Processors, Parallel Processing and Virtual Machines 15.2 Boolean Algebra and Logic Circuits

17.1 Encryption, Encryption Protocols and Digital certificates

7.1 Ethics and Ownership

6.1 Data Security 6.2 Data Integrity

4.1 Central Processing Unit (CPU) Architecture 4.2 Assembly Language 4.3 Bit manipulation

1: Identify and use the standard symbols for logic gates 2: Define and understand the functions of the logic gates 3:Use logic gates to create given logic circuits and Truth Table and write a logic expression

9.1 Computational Thinking Skills 9.2 Algorithms

Pseudocode Guide for Teacher and Students Cambridge International AS & A Level Computer Science 9618 Please click the link below to follow Pseudocode in examined components: The following information sets out how pseudocode will appear within the examined components and is provided to allow you to give learners familiarity before the exam. Also Python vs Pseudocode for IGCSE and AS/A level,. Thanks to the professional teacher Awab Aqib for his Kind contribution

19.1 Algorithms 19.2 Recursion

Fetch-Execute cycle easy to understand The stages of the fetch execute cycle , including the use of registers and buses description

Practical Scratch Block Programming exams with answer and project activities and more for Year 7