# ICT Shop

2k+Views

(1)
Objectives of the Topic - Understand how Binary makes computers work - Be able to convert Binary to Denary - Understand the Denary numbers are - Be able to convert numbers to Binary - Understand the Hexidecimal system - Be able to convert Binary to Hexidecimal - Be able to convert Hexidecimal to Binary

#### Emerging Technologies

(2)
For both IT and Computing subjects.

#### Transmission Control Protocol (TCP) & IP

(0)
Transmission Control Protocol (TCP) &amp; IP for iGCSE and A Level Covers the basics in a way that is easy for pupils to understand

#### Intro to Computer Networks

(0)
Suitable for year KS3

#### Mock Exam iGCSE Theory Paper 1

(0)
A selection of questions for the year 10 or 11 Mock exams. This is relevant for the 2017-19 Syllabus

#### Database Concepts GCSE & AS IT

(0)
Covers the following areas: describe the three types of relationships create and interpret an entity relationship diagram evaluate difference between flat file &amp; relational database create a relational database analyse the function of key fields (including: primary key, compound key, foreign key) validate and verify data entry use validation rules test validation applied to a database complex queries using multiple criteria using text, numeric, date, time, wildcard, Boolean operators (AND, OR, NOT), ., ,, =, .=, ,= create and evaluate an appropriate data entry form

#### Spreasheets for GCSE & AS IT

(0)
Covers the following areas: Use validation rules in a spreadsheet Test validation rules Test a spreadsheet model &amp; evaluate effectiveness Search for data within a spreadsheet Sort data Import &amp; export data Analyse &amp; select appropriate type of chart Describe the characteristics of modelling software Analyse the need for computer models Evaluate the use of simulations

#### Database Normalisation

(0)
What the Syllabus states that you need to know about normalisation Normalisation to third normal form (3NF) • describe the characteristics of data in unnormalised form (0NF), first normal form (1NF), second normal form (2NF) and third normal form (3NF) • discuss the advantages and disadvantages of normalisation • normalise a database to 3NF

#### Index Formula in Excel

(0)
Index Formula in Excel Note: Will require teacher to make Excel questions

#### Video Editing

(0)
For the new IT/ Computing Syllabus

#### Central Processing Unit (CPU)

(1)
Insight in to the Central Processing Unit

#### Product Development

(0)
This resource allows the teacher to incorporate Spreadsheet, Database, Research and Presentation topic areas as they wish. Project management can be used as an extra if required. There are no set instructions on how to use the resources. Therefore, the teacher has the ability to adapt the classes as they wish. It is recommended to use over a period of 5-6 lessons. -Research using the internet for Ingredients -Presenting findings on a spreadsheet or database report -Finding recipes online and breaking it down in to activities using Gantt chart -Designing product packaging -Present the work as a PPT or any other means to the class