ICT

Demonstrate knowledge and understanding from across the specification.
Apply skills (including practical skills), knowledge and understanding in a variety of contexts and in planning and carrying out investigations and tasks.
Analyse and evaluate information, making reasoned judgements and presenting conclusions.

This unit allows learners to explore the wide range of uses of hardware, application and specialist software in society. They will investigate how information technology is used in a range of contexts, including business and organisations, education and home use. Jobs in ICT exist in a variety of contexts. However, there are key areas of knowledge that any ICT specialist will be required to know. This base knowledge allows them to provide the best service and advice possible for their clients and the industries they are working in.

Year 10 will see students learn new skills with key office packages that will be applied to a practice scenario and will be accompanied by a self-made help guide. In Half Term 3 they will undertake 40 hours of controlled assessment. The NEA is time sensitive and is dictated by the exam board. Unit 2 is an exam based topic and begins with simple input and outputs but builds up in complexity. Students will need to have experience and knowledge of completing online assessments. Time with recap and revision will be built in to gain this experience.

Half Term 1

Photoshop

Photo Editing skills as well as image constructs

Database Management Systems

• ERD
• Table Creation and import
• Validation
• Queries
• Forms
• Reports
• Testing

Half Term 2

Word Processor 

Template Creation

Mail Merge

Spreadsheets

• Formulae
• Functions
• Formatting
• Macros
• Hyperlinks
• Chars
• What If Investigations
• Testing

Half Term 3

Controlled Assessment

Internally Assessed Project

Half Term 4

Controlled Assessment

Internally Assessed Project

Half Term 5

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

• Functionality of different hardware devices 
• Functionality of different software

Half Term 6

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

• Functionality of different software 
• Services provided by IT 

Assessment

Half Term 1

How data and information is used and 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 

Assessment

Half Term 2

Legal, moral, ethical, cultural and environmental impacts 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

Assessment

Half Term 3

Exam technique and practice of online Examinations

Recall Lessons for Year 10 Unit. 

Exam revision and preparation

Half Term 4

Exam technique and practice of online Examinations

Recall Lessons for Year 10 Unit. 

Exam revision and preparation