App Inventor is a free, cloud-based service that allows you to make your own mobile apps using a blocks-based programming language. You access App Inventor using a web browser (Chrome, Firefox, Safari). With these beginner-friendly tutorials, you will learn the basics of programming apps for Android and iOS phones and tablets. you can use it for year 7 and 8 Please click the link below to use the tutorial https://appinventor.mit.edu/explore/ai2/tutorials Click the link below to start Beginner Tutorials https://appinventor.mit.edu/explore/ai2/beginner-videos

IGCSE (CIE) Computer Science Revision for paper 21/22/23 Part B only with answers

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

IGCSE (CIE) Computer Science Revision for paper 11/12/13 only with answers

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

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.

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

Revision for the IGCSE (CIE) computer science paper 22 May/June 2022 (part A and B) with pseudocode solution for part A Attached revision paper 2 for Part A and B Part A: Attached Pseudocode Solutuon for task 1/2/3 please help yourself Part B: Database , validation, data type and Selection and Repetition, Database: Trace Table Data Type and Selection or Repetition Validation Pseudocode algorithm

Blockly programming for Year 6 and 7 Blockly is a client-side library for the programming language JavaScript for creating block-based visual programming languages and editors. A project of Google, it is free and open-source software released under the Apache License 2.0. It typically runs in a web browser, and visually resembles the language Scratch. https://blockly.games/

Test with question and answer for year 6/7 and 8 -Geometric shapes using python programming turtle graphics

Please make sure you practice geometric shapes below using python programming (turtle graphics) and make sure you learn the name of each geometric shape. Please click the link below to start your practical tasks https://trinket.io/

IGCSE Year 10 and 11 Computer Science TEST 1 with Answer

AS/ A Level Computer Science TEST 1 with Answer

IGCSE Year 10 and 11 Computer Science TEST 1 and 2 with answers

11.1 Programming Basics 11.2 Constructs 11.3 Structured Programming 11.1 Programming Basics Implement and write pseudocode from a given design presented as either a program flowchart or structured English Write pseudocode statements for: • the declaration of variables and constants • the assignment of values to variables and constants • expressions involving any of the arithmetic or logical operators input from the keyboard and boutput to the console. Use built-in functions and library routines Any functions not given in the pseudocode guide will be provided String manipulation functions will always be given 11.2 Constructs Use pseudocode to write: • an ‘IF’ statement including the ‘ELSE’ clause and nested IF statements • a ‘CASE’ structure • a ‘count-controlled’ loop: • a ‘post-condition’ loop • a ‘pre-condition’ loop Justify why one loop structure may be better suited to solve a problem than the others **11.3 Structured Programming ** Define and use a procedure Explain where in the construction of an algorithm it would be appropriate to use a procedure. Use parameters: A procedure may have none, one or more parameters and A parameter can be passed by reference or by value. Define and use a function Explain where in the construction of an algorithm it is appropriate to use a function. A function is used in an expression, e.g. the return value replaces the call. Use the terminology associated with procedures and functions: including Procedure / function header, procedure / function interface, parameter, argument, return value Write efficient pseudocode

Declare and use one-dimensional arrays, for example: A[1:n] Show understanding of the use of one-dimensional arrays, including the use of a variable as an index in an array Read or write values in an array using a FOR … TO … NEXT loop

Declare and use variables and constants Understand and use basic data types: Integer, Real, Char, String and Boolean Understand and use the concepts of sequence, selection, repetition, totalling and counting Use predefined procedures/functions

•Understand and use pseudocode for assignment, using ← •understand and use pseudocode, using the following conditional statements: IF … THEN … ELSE … ENDIF CASE … OF … OTHERWISE … ENDCASE •U nderstand and use pseudocode, using the following loop structures: FOR … TO … NEXT REPEAT … UNTIL WHILE DO … ENDWHILE •U nderstand and use pseudocode, using the following commands and statements: INPUT and OUTPUT (e.g. READ and PRINT) totalling (e.g. Sum ← Sum + counting (e.g. Count ← Count + •U nderstand and use standard flowchart symbols to represent the above statements, Key Objectives in this unite 2- Pseudocode and flowcharts are to revise: Pseudocode: Assignment Loop structures Input and output Standard actions Flowcharts: Symbols

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.

For all Teacher attached a student project for you attention: Please before you solve any pre-release material for students. It is better to let them try to solve it first. please give this project to your student for a period of a month therefore you can measure students progress and attainment. IGCSE Pre- release material for Computer Science paper 2 - Student Project Attached the Pre-release material for paper 2 exams , Please ask the students to open the PDF and watch the video and it will give students a starting point how to solve task 1/2/3 for this year exam. Thank you But before that. student should start attempting pre-release paper 2 for last year May/June 2021, Please ask the student to go straight to slide 11 and do the last year exam paper 2 May/June 2021 , Students will find the questions/answers and the python programming code for task 1 / 2 and 3 . I included python programming code for last year paper 2 exams for task 1/2/3 . Please make sure students practice using last year exam paper 2 before they start solving this year paper 2 . Thank you Ask the students to solve and provide the following three tasks for this year exam: pseudo code and python programming for Task 1 pseudo code and python programming for Task 2 pseudo code and python programming for Task 3