<p>understanding file structure.<br /> Skills involved:</p> <ul> <li>create database and table,</li> <li>add data into table</li> <li>set validation routine</li> <li>create relationships</li> <li>create form.</li> </ul>

<p>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.<br /> In this lesson, it also contains all the important notes and extra care for exam based on my experience in IGCSE ICT.</p>

<p>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.</p>

Spreadsheet with formula, functions and modelling

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

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.

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

<p>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.</p>

<p>Theory questios for spreadsheet (KS2/KS3)</p> <ul> <li>functions: count, sum, average</li> <li>formula, efficient formula/ function</li> <li>formatting</li> </ul>

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

<p>Web authoring for KS3/ KS2<br /> Project / assessment</p> <p>HTML<br /> CSS</p>

<p>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.</p>

<p>Presentation skill:<br /> - Master slide elements<br /> - layout of slides<br /> - text editing<br /> - included theory: Input and Output Devices</p>

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

<p>Presentation skill:</p> <ul> <li>Master slide elements</li> <li>layout of slides</li> <li>Image editing in presentation package</li> <li>text editing</li> <li>included theory: DDE, Email terms</li> </ul>

Section 21 Web authoring<br /> Paper 1 Practice on partial code in HTML and styelsheet