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

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)

Objective: •Understand the use of the different operators in Python. •Explain What is an algorithm, Pseudocode and Flowchart? •Understand the following terms, (IF , ELSE & ELIF) Outcomes: Explain the use of an IF and Else statement

Basic and intermediate JavaScript Tutorial for IGCSE and AS/Alevel with AS/A level questions and answers with practical projects

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

3.1 Computer architecture 3.2 Input and output devices 3.3 Data storage 3.4 Network hardware

7.1 Ethics and Ownership

2.1 Types and methods of data transmission 2.2 Methods of error detection 2.3 Encryption

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

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

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