This lesson contains all the required skills in IGCSE ICT - Presentation module, using PowerPoint. It uses concept in Section 2 - Printers as the materials, so that students able to revise their section 2 concept will manipulating the presentation slides. In this lesson, it also contains all the important notes and extra care for exam based on my experience in IGCSE ICT.

Spreadsheet with formula, functions and modelling

This project assesses student’s ability on the use of spreadsheet. It covers the use of formula, IF function; Data entry, inserting columns, merging cells, basic formatting, rounding off numbers, alignment and border. It covers research skills using Internet. The worksheet has a is suitable for grade 8 and 9.

understanding file structure. Skills involved: create database and table, add data into table set validation routine create relationships create form.

Worksheet for IGCSE computer science Data representation worksheet number system: convertion binary manipulation negative numbers (binary) Text, sound, images data storage data compression

This project assesses student’s ability on the use of spreadsheet. It covers the use of formula, IF function, Nested-if function; Data entry, inserting columns, merging cells, basic formatting, rounding off numbers, alignment and border. It covers data modelling and ‘what-if’ using spreadsheets. The worksheet has a is suitable for grade 7, 8 and 9. This is also suitable as assessment.

Theory questios for spreadsheet (KS2/KS3) functions: count, sum, average formula, efficient formula/ function formatting

understanding file structure. Skills involved: create database and table, import text into table, set validation routine.

This project assesses students’ ability on the use of spreadsheet. It covers the use of formula, Data entry, inserting columns, merging cells, basic formatting, rounding off numbers, alignment and border. The worksheet has a is suitable for grade 7, grade 8 and 9.

This project assesses student’s ability on the use of spreadsheet. It covers the use of formula, IF function, SUMIF, COUNTIF, COUNT, COUNTA functions. The worksheet is suitable for grade 8 and 9. It also suitable as a starter for IGCSE ICT [0417] data analysis.

This resource contains a full lesson with Data representation from IGCSE Computer Science CIE. Fully animated slides.

Presentation skill: - Master slide elements - layout of slides - text editing - included theory: Input and Output Devices

Paper 2: Presentation Skills involved: - Import outline - master slides elements - Theory answering in slides - Transition - Printing configuration Provided with marking scheme

Section 21 Web authoring Paper 1 Practice on partial code in HTML and styelsheet