ICT

Unit 1 - ICT in Society

Externally Assessed on-screen examination (1 Hour 20 Minutes)

Topic 1 - How IT can be used to fulfil the needs of organisations and individuals

• Functionality of different hardware devices. 

• Functionality og different software

• Services provided by IT

Topic 2 - How data and information is transferred

• Why data must be fit for purpose

• How input data is checked for errors

• How data transfers over different types of network.

• Different types of connectivity. 

Topic 3 - Legal, moral, ethical, cultural and environmental impact of IT and the need for cybersecurity. 

• Risks to information held on computers

• The impact of data loss, theft or manipulation on individuals and businesses

• Methods used to protect information

• How moral and ethical issues affect computer users

• How legal issues protect computer users

• The cultural, personal and environmental impact of ICT

• How a digital footprint can impact computer users. 

Unit 2 - ICT in Context

Internally Assessed, externally moderated NEA (40 Hours) 

Topic 1 - Planning, creating and modifying using databases

• Planning and designing a database

• Creating and modifying a database

• Interrogating a database

• Creating user interfaces

• Testing and evaluating a database

Topic 2 - Planning, creating, modifying and using spreadsheets 

• Planning and designing a spreadsheet

• Creating and formatting a spreadsheet

• Use of appropriate data formatting and adding suitable validation rules

• Use of appropriate formulae and functions to meet set outcomes. 

• Arranging, reducing and outputting data tohelp make decisions. 

• Modifying data and formulae to model what if scenarios

• Testing and evaluating spreadsheets. 

Topic 3 - Planning, creating and modifying an automated document

• Planning and designing an automated document

• Creating an effectively structured data source and linking this to a standard document

• Appropriately structuring the content of the standard document and inserting fields as required. 

• Merging and outputting final documents

Topic 4 - Planning, creating, manipulating and storing images

• Planning and designing an image

• Creating and modifying an image using appropriate tools and techniques

• Storing the image appropriately and outputting the final image in a format that is fit for purpose.