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)

18.1 Artificial Intelligence

DatabaseStructured Query Language (SQL) What is SQL? SQL stands for Structured Query Language SQL lets you access and manipulate databases What Can SQL do? SQL can execute queries against a database SQL can retrieve data from a database SQL can insert records in a database SQL can update records in a database SQL can delete records from a database SQL can create new databases SQL can create new tables in a database SQL can create stored procedures in a database SQL can create views in a database SQL can set permissions on tables, procedures, and views Using SQL in Your Web Site To build a web site that shows data from a database, you will need: An RDBMS database program (i.e. MS Access, SQL Server, MySQL) To use a server-side scripting language, like PHP or ASP To use SQL to get the data you want To use HTML / CSS to style the page **What is RDBMS? ** RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.

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

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.

This course adopts a step-by-step, project-based approach to teach students level 2 Java programming and concepts and skills for creating simple compute programs using java programming language. Java’s unique architecture enables programmers to develop a single application that can run across multiple platforms reliably seamlessly. In this hands-on course, students gain extensive experience with Java and its object-oriented features. Students will be able to explore and use classes, use methods and develop syntax to create windows components and change appearance of the components also Students learn to create robust console and GUI applications.

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- This course defines the competency level require to understand and explore the basic programming concepts/ principles while using a friendly mobile app creation environment (Blockly games programming), which mainly designed to create simple animations and fun games. It enables the learner to write scripts on mobile devices and traditional PCs. By going through this course, learners shall be well prepared to move on to HTML5, JavaScript, and more. In Term 3- This course defines the competency level require to understand and explore the basic programming concepts/ principles while using a friendly mobile app creation environment (Blockly games programming), Blockly Games is a series of educational games that teach programming. It is designed for students who have not had prior experience with computer programming. By the end of these games, players are ready to use conventional text-based languages which mainly designed to create simple animations and fun games. It enables the learner to write scripts on mobile devices and traditional PCs. By going through this course, learners shall be well prepared to move on to HTML5, JavaScript, and more.

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- This course defines the competency level require to understand and explore the basic programming concepts/ principles while using a friendly mobile app creation environment (Blockly games programming), which mainly designed to create simple animations and fun games. It enables the learner to write scripts on mobile devices and traditional PCs. By going through this course, learners shall be well prepared to move on to HTML5, JavaScript, and more. In Term 3 - This course defines the competency level require to understand and explore the basic programming concepts/ principles while using a friendly mobile app creation environment (Blockly games programming), Blockly Games is a series of educational games that teach programming. It is designed for students who have not had prior experience with computer programming. By the end of these games, players are ready to use conventional text-based languages which mainly designed to create simple animations and fun games. It enables the learner to write scripts on mobile devices and traditional PCs. By going through this course, learners shall be well prepared to move on to HTML5, JavaScript, and more.

This course adopts a step-by-step, project-based approach to teach students the Java Programming level 1 basic concepts and skills for creating simple compute programs using java programming language. Students will learn topics related to Java programing syntax and structure, primitive data types and operators. Students will also learn how to define and use conditional statements, loops and array their programs.