Main aims of the student project for Security Privacy and Data Integrity: You are going to search on: • data integrity • data privacy • data security • validation and verification

MS EXCEL Practical Test 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.

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

Show understanding of the need for input, output, primary memory and secondary (including removable) storage.Describe the principal operations of hardware devices Show understanding of the use of buffersExplain the differences between Random Access Memory (RAM) and Read Only Memory (ROM)Explain the differences between Static RAM (SRAM) and Dynamic RAM (DRAM)Explain the difference between Programmable ROM (PROM), Erasable Programmable ROM (EPROM) and Electrically Erasable Programmable ROM (EEPROM)Show an understanding of monitoring and control systems Candidates should be able to:Use the following logic gate symbols: Understand and define the functions of: NOT, AND, OR, NAND, NOR and XOR (EOR) gatesConstruct a logic circuitConstruct a truth tableConstruct a logic expression

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

6.1 Data Security 6.2 Data Integrity Explain the difference between the terms security , privacy and integrity of data Show appreciation of the need for both the security of data and the security of the computer system Describe security measures designed to protect computer systems, ranging from the stand alone PC to a network of computers. Including user accounts, passwords, authentication techniques such as digital signatures, firewall, antivirus software, anti spyware, encryption. Show understanding of the threats to computer and data security posed by networks and the internet. Including malware (virus, spyware), hackers, phishing, pharming. Describe methods that can be used to restrict the risks posed by threats Describe security methods designed to protect the security of data Including encryption, access rights

10.1 Data Types and Records: Select and use appropriate data types for a problem solution including integer, real, char, string, Boolean, date (pseudocode will use the following data types: INTEGER, REAL, CHAR, STRING, BOOLEAN, DATE, ARRAY, FILE) Show understanding of the purpose of a record structure to hold a set of data of different data types under one identifier Write pseudocode to define a record structure. Write pseudocode to read data from a record structure and save data to a record structure 10.2 Arrays: Use the technical terms associated with arrays (Including index, upper and lower bound) Select a suitable data structure (1D or 2D array) to use for a given task Write pseudocode for 1D and 2D arrays Write pseudocode to process array data Sort using a bubble sort Search using a linear search 10.3 Files: Show understanding of why files are needed Write pseudocode to handle text files that consist of one or more lines 10.4 Introduction to Abstract Data Types (ADT): Show understanding that an ADT is a collection of data and a set of operations on those data. Show understanding that a stack, queue and linked list are examples of ADTs Describe the key features of a stack, queue and linked list and justify their use for a given situation Use a stack, queue and linked list to store data (You will not be required to write pseudocode for these structures, but they should be able to add, edit and delete data from these structures) Describe how a queue, stack and linked list can be implemented using arrays

Chapter 7: Ethics and Ownership 7.1 Legal, Moral, Ethical and Cultural implication 7.2 Copyright issues 7.3 Artificial Intelligence Show understanding of the need for and purpose of ethics as a computing professional Understand the importance of joining a professional ethical body including BCS (British Computer Society), IEEE (Institute of Electrical and Electronic Engineers). Show understanding of the need to act ethically and the impact of acting ethically or unethically for a given situation. Show understanding of the need for copyright legislation Show understanding of the different types of software licensing and justify the use of a license for a given situation. Licenses to include free Software Foundation, the Open Source Initiative, shareware and commercial software.Show understanding of Artificial Intelligence (AI) Understand the impact of AI including social, economic and environmental issues Understand the applications of AI

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

Show understanding that every computer system is made up of sub-systems, which in turn are made up of further sub-systems Use top-down design, structure diagrams, flowcharts, pseudocode, library routines and sub-routines Work out the purpose of a given algorithm Explain standard methods of solution Suggest and apply suitable test data Understand the need for validation and verification checks to be made on input data (validation could include range checks, length checks, type checks and check digits) Use trace tables to find the value of variables at each step in an algorithm Identify errors in given algorithms and suggest ways of removing these errors Produce an algorithm for a given problem (either in the form of pseudocode or flowchart) Comment on the effectiveness of a given solution

9.1 Computational Thinking Skills: Show an understanding of abstraction Need for and benefits of using abstraction Describe the purpose of abstraction Produce an abstract model of a system by only including essential details Describe and use decomposition Break down problems into sub-problems leading to the concept of a program module (procedure / function) 9.2 Algorithms: Show understanding that an algorithm is a solution to a problem expressed as a sequence of defined steps. Use suitable identifier names for the representation of data used by a problem and represent these using an identifier table Write pseudocode that contains input, process and output Write pseudocode using the three basic constructs of sequence, selection and iteration (repetition) Document a simple algorithm using pseudocode Write pseudocode from: a structured English description a flowchart Describe and use the process of stepwise refinement to express an algorithm to a level of detail from which the task may be programmed Use logic statements to define parts of an algorithm solution

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

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

Step by Step practical activities for year 8 pupils how to create a Rollover Button and Banners using Fireworks CS6 and Dreamweaver practical activities Please feel free to leave comment and review. Thank you Mr.N.T

1.1 Number systems 1.2 Text, sound and images 1.3 Data storage and compression

1.1 Systems in organizations 1.2 System design basics

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

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