Show understanding of the difference between: primary, secondary and off-line storage and provide examples of each, such as: Primary: Read Only Memory (ROM) and Random Access Memory (RAM) Secondary: hard disk drive (HDD) and Solid State Drive (SSD); off-line: Digital Versatile Disc (DVD), Compact Disc (CD), Blu-ray disc, USB flash memory and removable HDD Describe the principles of operation of a range of types of storage device and media including magnetic, optical and solid state. Describe how these principles are applied to currently available storage solutions, such as SSDs, HDDs, USB flash memory, DVDs, CDs and Blu-ray discs. Calculate the storage requirement of a file.

In this chapter you will learn about: 1.3.3 Input devices •• describe the principles of operation (how each device works) of these input devices: 2D and 3D scanners, barcode readers, Quick Response (QR) code readers, digital cameras, keyboards, mice, touch screens, interactive whiteboards, microphones. •• describe how these principles are applied to real-life scenarios, for example: scanning of passports at airports, barcode readers at supermarket checkouts, and touch screens on mobile devices. •• describe how a range of sensors can be used to input data into a computer system, including light, temperature, magnetic field, gas, pressure, moisture, humidity, pH and motion •• describe how these sensors are used in real-life scenarios, for example: street lights, security devices, pollution control, games, and household and industrial applications. 1.3.4 Output device •• describe the principles of operation of the following output devices: inkjet, laser and 3D printers; 2D and 3D cutters; speakers and headphones; actuators; flat-panel display screens, such as Liquid Crystal Display (LCD) and Light-Emitting Diodes (LED) display; LCD projectors and Digital Light Projectors (DLP). •• describe how these principles are applied to real-life scenarios, for example: printing single items on demand or in large volumes; use of small screens on mobile devices.

MS Word Test 1 for Year 7/8 and 9

Describe the purpose of an operating system (You will be required to understand the purpose and function of an operating system and why it is needed. you will not be required to understand how operating system work.) Show understanding of the need for interrupts Show understanding of the basic Von Neumann model for a computer system and the stored program concept (program instructions and data are stored in main memory and instructions are fetched and executed one after another) Describe the stages of the fetch-execute cycle, including the use of registers and buses

MS Word for Year 8 and 9 Mail Merge practical activities

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

Logic gates

Communication and Internet technologies 1 Data transmission 2 Security aspects 3 Internet principles of operation

***Data representation: ** 1.1.1 Binary systems •• recognise the use of binary numbers in computer systems •• convert positive denary integers into binary and positive binary integers into denary (a maximum of 16 bits will be used) •• show understanding of the concept of a byte and how the byte is used to measure memory size •• use binary in computer registers for a given application (such as in robotics, digital instruments and counting systems) 1.1.2 Hexadecimal •• represent positive numbers in hexadecimal notation •• show understanding of the reasons for choosing hexadecimal notation to represent numbers •• convert positive hexadecimal integers to and from denary (a maximum of four hexadecimal digits will be required) •• convert positive hexadecimal integers to and from binary (a maximum of 16 bit binary numbers will be required) •• represent numbers stored in registers and main memory as hexadecimal •• identify current uses of hexadecimal numbers in computing, such as defining colours in Hypertext Markup Language (HTML), Media Access Control (MAC) addresses, assembly languages and machine code, debugging 1.1.3 Data storage •• show understanding that sound (music), pictures, video, text and numbers are stored in different formats •• identify and describe methods of error detection and correction, such as parity checks, check digits, checksums and Automatic Repeat reQuests (ARQ) •• show understanding of the concept of Musical Instrument Digital Interface (MIDI) files, JPEG files, MP3 and MP4 files •• show understanding of the principles of data compression (lossless and lossy) applied to music/video, photos and text files

Students should be able to: Roles of the different computers within the network and subnetwork models Benefits and drawbacks of each model Justify the use of a model for a given situation Understand how packets are transmitted between two hosts for a given topology Justify the use of a topology for a given situation Including the use of public and private clouds. Benefits and drawbacks of cloud computing Describe the characteristics of copper cable, fibreoptic cable, radio waves (including WiFi), microwaves, satellites Including switch, server, Network Interface Card (NIC), Wireless Network Interface Card (WNIC), Wireless Access Points (WAP), cables, bridge, repeater Including Carrier Sense Multiple Access / Collision Detection (CSMA / CD) Methods of bit streaming, i.e. real-time and on-demand Importance of bit rates / broadband speed on bit streaming Including modems, PSTN (Public Switched Telephone Network), dedicated lines, cell phone network • format of an IP address including IPv4 and IPv6 • use of subnetting in a network • how an IP address is associated with a device on a network • difference between a public IP address and a private IP address and the implications for security • difference between a static IP address and a dynamic IP address

IGCSE Revision for Year 10/11- Theory of Computer Science for Chapter 1 and Chapter 2 Revision using Flip Learning and MTL Methodology Chapter 1: Data Representation Chapter 2: Communication and Internet technologies NB: MTL Methodology was created and developed by Noureddine Tadjerout

1 Data Representation Show understanding of binary magnitudes and the difference between binary prefixes and decimal prefixes Understand the difference between and use: •• kibi and kilo •• mebi and mega •• gibi and giga •• tebi and tera Show understanding of the basis of different number systems Use the binary, denary, hexadecimal number bases and Binary Coded Decimal (BCD) and one’s and two’s complement representation for binary numbers Convert an integer value from one number base / representation to another Perform binary addition and subtraction: Using positive and negative binary integers. Show understanding of how overflow can occur. Describe practical applications where Binary Coded Decimal (BCD) and Hexadecimal are used Show understanding of and be able to represent character data in its internal binary form, depending on the character set used Familiar with ASCII (American Standard Code for Information Interchange), extended ASCII and Unicode. Students will not be expected to memorise any particular character codes. Use and understand the terms: pixel, file header, image resolution, screen resolution, colour depth, bit depth Perform calculations to estimate the file size for a bitmap image Show understanding of the effects of changing elements of a bitmap image on the image quality and file size Show understanding of how data for a vector graphic are encoded: Use the terms: drawing object, property, drawing list. Justify the use of a bitmap image or a vector graphic for a given task. 2 Multimedia – Graphics and Sound. Show understanding of how sound is represented and encoded: Use the terms: sampling, sampling rate, sampling resolution, analogue and digital data Show understanding of how data for a bitmapped image are encoded. 3 Compression Show understanding of the need for and examples of the use of compression Show understanding of lossy and lossless compression and justify the use of a method in a given situation. Show understanding of how a text file, bitmap image, vector graphic and sound file can be compressed Including the use of run-length encoding (RLE)

MS Word Worksheet for year 9

MS Word worksheet for Year 8

Microsoft word worksheet and activities for year 7

ICT -YEAR 9- END OF YEAR EXAMINATION and EoY Revision ( MS Word/PowerPoint/Excel/Database IMPORTANT INSTRUCTIONS:  This Exam consists of four parts.  You must attempt all questions in the exam. – You have to prepare a word processing file using MS Office Word. – You have to prepare a presentation file using MS Office PowerPoint. – You have to prepare a presentation file using MS Office Excel – You have to prepare a presentation file using MS Office Access

ICT -YEAR 8- END OF YEAR EXAMINATION and EoY Revision ( MS Word/PowerPoint/Excel and practical revision for MS Word / Excel and PowerPoint – You have to prepare a word processing file using MS Office Word. – You have to prepare a presentation file using MS Office PowerPoint. – You have to prepare a presentation file using MS Office Excel

ICT - Year 7 - Practical END OF YEAR EXAMINATION ( Microsoft Word and PowerPoint and EoY Revision Microsoft Word Revision for Year 7 End of Year Exam– Practical Activities Powerpoint Revision for Year 7 for the End of Year Exam

• 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 : VLOOKUP and HLookUp Understand the use of the Vlookup function Understand the use of absolute cell referencing. Understand the use of an nested if statement. Understand the used of the different count functions. Understand the use of the sumif function.