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.

ICT Year 7 or 8 Test - Hardware and Software Component

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

ICT-Year 8 and 9 Type of computer components Test

MIT App Inventor is an intuitive, visual programming environment that allows everyone – even children – to build fully functional apps for smartphones and tablets. Those new to MIT App Inventor can have a simple first app up and running in less than 30 minutes. And what’s more, our blocks-based tool facilitates the creation of complex, high-impact apps in significantly less time than traditional programming environments. The MIT App Inventor project seeks to democratize software development by empowering all people, especially young people, to move from technology consumption to technology creation. Please click the link to access MIT App inventor below : https://appinventor.mit.edu/explore/ai2/tutorials

Upon completion of this chapter, you should be able to answer the following questions: Define hardware, giving examples Define software, giving examples Describe the difference between hardware and software Identify the main components of a general-purpose computer: central processing unit, main/internal memory (including ROM and RAM), input devices, output devices and secondary/backing storage Identify operating systems, including those which contain a graphical user interface, a command line interface Identify different types of computer including Personal Computer or desktop, mainframe, laptop, palmtop and Personal Digital Assistant Describe recent developments in ICT How do I open the case? What is the process to install the power supply? How do I attach the components to the motherboard and install the motherboard? How do I install internal drives? How do I install drives in external bays? How do I install adapter cards? What is the process to connect all internal cables? How do I reattach the side panels and connect external cables to the computer? What happens when I boot the computer for the first time

ICT Test for Year 8 and 9 MS Word and MS PowerPoint

Objective: •Understand the use of the different operators in Python. •Explain What is an algorithm, Pseudocode and Flowchart? •Understand the following terms, (IF , ELSE & ELIF) Outcomes: Explain the use of an IF and Else statement

Revision Python print/input and data type for Year 8 and 9

1- Define hardware as consisting of physical components of a computer system 2- Identify internal hardware devices (e.g. motherboards, random access memory (RAM), read-only memory (ROM), video cards, sound cards and internal hard disk drives) 3- Identify external hardware devices and peripherals (such as monitors, keyboards, mice, printers as input and output device 4- Define software as programs for controlling the operation of a computer or processing of electronic data 5- Identify the two types of software applications software and systems software 6- Define applications software (e.g. word processing, spread sheet, database management systems, control software, measuring software , photo-editing software, video-editing software, graphics manipulation software) 7- Define system software (e.g. compilers, linkers, device A big thanks for Mr Ahmed for his tremendous effort on the IGCSE ICT

How to design and plan a very good lesson plan that include pair/group activities and self assessment : in this example, I included lesson plan, lesson Presentation (example Mathematics 2D shapes) and Worksheet for 2D shapes