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

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

How to design and plan a very good lesson plan that include pair/group activities and self assessment : in this example, I included lesson plan, lesson Presentation (example Mathematics 2D shapes) and Worksheet for 2D shapes

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