**Paper 1- Chapter 3: Hardware ** **3.1 Computer architecture ** 1- (a): Understand the role of the central processing unit (CPU) in a computer. (b): Understand what is meant by a microprocessor. 2- (a): Understand the purpose of the components in a CPU, in a computer that has a Von Neumann architecture. (b): Describe the process of the fetch–decode–execute cycle including the role of each component in the process. **Paper 2 - Chapter 7: Algorithm design and problem-solving ** **7.4 Algorithm design and problem-solving ** 4 - Understand standard methods of solution. • linear search • bubble sort

This HTML Beginner’s Guide assumes that you have no previous knowledge of HTML. It should be quite easy to follow if you work through each step, which are all brought together at the end of this lesson.

Basic Python programming for Year 7/8/9/10/11 and 12 . I will keep uodating the lessons.

Test 1 - Topic 1—System fundamentals with Questions and Answers Test 1: 1.1.1 Identify the context for which a new system is planned. Test 2- 1.1.2 Describe the need for change management.

Paper 2 : Option 4—Database (SL -30 hours) A.1 Basic concepts (5 hours) A.2 The relational database model (15 hours) A.3 Further aspects of database management (10 hours) HL Extension A.4 Further database models and database analysis (15 hours)- In Progress

IB DP Year 12/13-Test 3 - Topic 2 with Question and Answers

IB DP - Approved notation for developing pseudocode

Network fundamentals Data transmission Wireless networking

IB DP Year 12/13 - Test 1 - Computer Science - Topic 1-System fundamentals - 1.1 - Systems in organizations

Topic 4—Computational thinking, problem-solving and programming (45 hours) 4.1 General principles (10 hours) 4.2 Connecting computational thinking and program design (22 hours) 4.3 introduction to programming (13 hours)

• 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) Thanks to our dear colleagues Mr. Yasar Ahmed for his tremendous work for developping reources in ICT and please click the link below where you can find a lot of resources for your ICT subjects from year 7 - 12.

Learning Objectives: 12.1 Program Development Life cycle Show understanding of the purpose of a development life cycle Show understanding of the need for different development life cycles depending on the program being developed (Including, waterfall, iterative, rapid application development (RAD) Describe the principles, benefits and drawbacks of each type of life cycle Show understanding of the analysis, design, coding, testing and maintenance stages in the program development life cycle. 12.2 Program Design Use a structure chart to decompose a problem into sub-tasks and express the parameters passed between the various modules / procedures / functions which are part of the algorithm design Describe the purpose of a structure chart Construct a structure chart for a given problem Derive equivalent pseudocode from a structure chart. Show understanding of the purpose of state-transition diagrams to document an algorithm. 12.3 Program Testing and maintenance Show understanding of ways of exposing and avoiding faults in programs. Locate and identify the different types of errors: syntax errors logic errors run-time errors Correct identified errors Show understanding of the methods of testing available and select appropriate data for a given method (Including dry run, walkthrough, white-box, black-box, integration, alpha, beta, acceptance, stub) Show understanding of the need for a test strategy and test plan and their likely contents. Choose appropriate test data for a test plan (Including normal, abnormal and extreme/boundary) Show understanding of the need for continuing maintenance of a system and the differences between each type of maintenance (Including perfective, adaptive, corrective) Analyze an existing program and make amendments to enhance functionality

Step by Step database practical activities how to download a csv file and how to do query and report in database and create a relationship between two tables. NB: Please make sure you download Movie and football excel and convert them to csv file and Football along the practical activities. Please feel free to leave any comments or review. Thank you Mr.N.T

2.1 Computer organization Computer architecture Secondary memory Binary representation Simple logic gates

STEAM Project for Year 7/8 and 09 Sustainability City Development Project

Lesson Objectives: 5.1 Operating System Explain why a computer system requires an Operating System (OS)Explain the key management tasks carried out by the Operating System:Including memory management, file management, security management, hardware management (input / output / peripherals), process management.Show understanding of the need for typical utility software provided with an Operating System:Including disk formatter, virus checker, defragmentation software, disk contents analysis/disk repair software, file compression, back-up software.Show understanding of program libraries: Including: • software under development is often constructed using existing code from program libraries• the benefits to the developer of software constructed using library files, including Dynamic Link Library (DLL) files. Learning Objective: 5.2 Language Translators Show understanding of the need for:• assembler software for the translation of an assembly language program• a compiler for the translation of a high-level language program• an interpreter for translation and execution of a high-level language programExplain the benefits and drawbacks of using either a compiler or interpreter and justify the use of each Show awareness that high-level language programs may be partially compiled and partially interpreted,such as JavaDescribe features found in a typical Integrated Development Environment (IDE)Including:• for coding, including context-sensitive prompts• for initial error detection, including dynamic syntax checks• for presentation, including prettyprint, expand and collapse code blocks• for debugging, including single stepping, breakpoints, i.e. variables, expressions, report window

1.1 Systems in organizations 1.2 System design basics

Test 2 - Topic 1—System fundamentals: 1.1 Systems in organizations

MS Word Test 1 for Year 7/8 and 9

Lesson Objectives: Lesson 1 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 Lesson 2 Understand the motion commands with Python turtle module Understand the use of Variables and how to assign them values. Understand the use of different commands such as PenUp/PenDown, goto, forward, backward, left, right and t.begin_fill() & t.end_fill(), t.goto(x,y), t.setposition(x,y), t.pensize(value), t.setheading(value), t.color(‘green’) Lesson 3 What you’re aiming for in this lesson is to: familiarize yourself with the various code statements play with the code and learn how to change and adapt it. For example, if you have the code for a small red square, you should be able to change it to make a big yellow square. be able to use the code we have developed for various shapes to create a picture.