• computing4

KS5 ICT

Year 12

Topic areas covered in course include the following:

Data, information and knowledge
The value and importance of information
Quality of information
Validation and verification
Capabilities and limitations of ICT

Uses of ICT in: Business/Education/Health/Home

Presenting information
Networks
Human computer interface (HCI)
Social issues
Database systems

Spreadsheet modelling:

  • You will learn advanced spreadsheet skills
  • You will create a spreadsheet model which you will use to answer exam questions


Assessment
30% (IT1) 2 hours 15 minutes Written Paper 80 marks (120 UMS)
20% (IT2) Internal Assessment 80 marks (80 UMS)

Year 13 Theory: Use and Impact of ICT

30% (IT3) 2 hours 30 minutes Written Paper 90 marks (120 UMS)

Topic areas covered in course include the following:

  • Networks
  • The internet
  • Human computer interface (HCI)
  • Working with ICT
  • ICT security policies
  • Database systems
  • Management of change
  • Management information systems (MIS)
  • System development life cycle (SDLC)

 

Year 13 Practical : Databases


20% (IT4) Internal Assessment 100 marks (80 UMS)

When undertaking this unit candidates should be able to:

  • discover how a structured database could be used in an organisation
  • understand data types and formats
  • discover how data is captured and prepared for use in a relational database
  • understand validation techniques to minimise errors
  • learn and apply the principles of normalisation of data with respect to relational database design
  • design, implement and test a relational database to meet a  specification
  • produce user documentation
  • develop good practice in their use of ICT
  • be able to evaluate their design