GRADE 12 / YEAR 13 AS ICT COURSE SYLLABUS 2020-2021

Course Outline

Overview

This syllabus overview provides ideas for teachers about how to construct and deliver a course for Cambridge International AS & A Level Information Technology (9626). The syllabus has been broken down into teaching units with suggested teaching activities and learning resources to use in the classroom. This scheme of work, like any other, is meant to be a guideline, offering advice, tips and ideas. It can never be complete but aims to provide teachers with a basis for planning their lessons. As well as making sure that the content of the Information Technology syllabus is covered, it includes development ideas for topics.

Learning Outcomes

The key concepts on which this syllabus is built are set out below.

Impact of Information Technology

Information Technology (IT) is the application of technology to process information.

The impact of IT on all aspects of everyday life is immense. The enormity of the impact can be seen in industry and commerce, transport, leisure, medicine and the home. The impact on the work force is a very important factor to consider and communications using new technologies have made the World seem smaller.

Hardware and software

Many hardware components and software applications are used in IT systems. It is important to

understand how these work, and how they interact with each other and within our environment.

Network

Computer systems can be connected together to form networks allowing them to share resources.

The internet

The internet is a global communications network that allows computers worldwide to connect and share information in many different forms. Examples include email, web pages, and audio and video files. The impact of the internet on our lives is profound. While it provides huge benefits to society, security of data is an issue, both in the workplace and for personal data. 

Ongoing Objectives

  • There are objectives that are covered and built upon throughout each unit of work.
  • develop a broad range of IT skills
  • develop an understanding of the parts, use and applications of IT systems within a range of organizations, including the use of basic computer networks
  • develop an understanding of how IT systems affect society in general
  • develop an understanding of the main system life cycle and apply this understanding to workplace situations
  • develop a broad knowledge of the use of Expert Systems
  • be aware of new and emerging technologies
  • be aware of the role of the internet and its potential but also its risks
  • apply their knowledge and understanding of IT to solve problems.
  • To articulate and justify answers, arguments, and opinions
  • Recall, select and communicate knowledge and understanding of IT
  • Apply knowledge, understanding and skills to produce IT-based solutions
  • Analyse, evaluate, make reasoned judgements and present conclusions

Unit Overviews

Term 1

Unit 1 – Data, information, knowledge and processing 

Approximate length: 3 weeks

Information Technology (IT) is the application of technology to process information. The impact of IT on all aspects of everyday life is immense. The enormity of the impact can be seen in industry and commerce, transport, leisure, medicine and the home. The impact on the workforce is a very important factor to consider and communications using new technologies have made the World seem smaller.

Specific National Curriculum Objectives Covered:

All pupils must have the opportunity to study aspects of information technology and computer science at sufficient depth to allow them to progress to higher levels of study or to a professional career.

All pupils should be taught to:

  • develop their capability, creativity and knowledge in computer science, digital media and information technology

Unit 2 – Hardware and software 

Approximate length: 2 weeks

Many hardware components and software applications are used in IT systems. It is important to understand how these work, and how they interact with each other and within our environment.

Specific National Curriculum Objectives Covered:

All pupils must have the opportunity to study aspects of information technology and computer science at sufficient depth to allow them to progress to higher levels of study or to a professional career.

All pupils should be taught to:

develop their capability, creativity and knowledge in computer science, digital media and information technology

Unit 3 – Monitoring and control

Approximate length: 1 week

In this unit, the students identify a range of sensors and describe their use in monitoring technologies, identify a range of sensors and describe their use in control technologies, evaluate the use of monitoring technologies in everyday life (including: CCTV monitoring, environmental monitoring, workplace monitoring), evaluate the use of control technologies in everyday life (including: household appliances, car park barriers, traffic lights).

Specific National Curriculum Objectives Covered:

All pupils must have the opportunity to study aspects of information technology and computer science at sufficient depth to allow them to progress to higher levels of study or to a professional career.

All pupils should be taught to:

  • develop their capability, creativity and knowledge in computer science, digital media and information technology
  • develop and apply their analytic, problem-solving, design, and computational thinking skills

Unit 4 – E-safety and health and safety

Approximate length: 1 week

In this unit, the students explore a explain why personal data should be kept confidential, describe how personal data can be gathered by unauthorized persons (including: by smishing, vishing, phishing and pharming), and how this might be prevented, discuss why e-safety is necessary, describe malware issues (including: Trojan Horse, worms, spyware, adware, rootkit, malicious bots, ransomware), describe a range of potential health issues that could arise from using IT, describe a range of safety issues relating to the use of IT.

Specific National Curriculum Objectives Covered:

All pupils must have the opportunity to study aspects of information technology and computer science at sufficient depth to allow them to progress to higher levels of study or to a professional career.

All pupils should be taught to:

  • develop their capability, creativity and knowledge in computer science, digital media and information technology
  • develop and apply their analytic, problem-solving, design, and computational thinking skills
  • understand how changes in technology affect safety, including new ways to protect their online privacy and identity, and how to identify and report a range of concerns.

Unit 5 – The digital divide

Approximate length: 1 week

In this unit, the students should be able to understand that the digital divide refers to the gap between people and regions that have access to aspects of modern technology (including: telephone, television, personal computers and the internet), and those that do not or those that have restricted access, understand that the digital divide can exist between: people in cities and people in rural areas, the educated and the uneducated, 

socioeconomic groups, more and less industrially developed nations, high and low performance computers, wireless connections.

Specific National Curriculum Objectives Covered:

All pupils must have the opportunity to study aspects of information technology and computer science at sufficient depth to allow them to progress to higher levels of study or to a professional career.

All pupils should be taught to:

  • develop their capability, creativity and knowledge in computer science, digital media and information technology
  • develop and apply their analytic, problem-solving, design, and computational thinking skills
  • understand how changes in technology affect safety, including new ways to protect their online privacy and identity, and how to identify and report a range of concerns.

Unit 8 – Spreadsheets

Approximate length: 3 weeks

In this unit, the students will create a spreadsheet, create formatting, create formulae and functions, use validation rules, Graphs and charts, Modelling, Simulations.

Specific National Curriculum Objectives Covered:

All pupils must have the opportunity to study aspects of information technology and computer science at sufficient depth to allow them to progress to higher levels of study or to a professional career.

All pupils should be taught to:

  • develop and apply their analytic, problem-solving, design, and computational thinking skills

Term2

Unit 6 – Using networks

Approximate length: 2 weeks

In this unit, the discuss the advantages and disadvantages of networking computers, compare the characteristics of a local area network (LAN) with a wide area network (WAN), describe client-server and peer-to-peer networks, describe the characteristics and purpose of virtual private networks (VPN), discuss the advantages and disadvantages of different network types (including: client-server, peer-to-peer, VPN), describe the characteristics and purpose of intranets and extranets, describe the characteristics and purposes of the internet, define the term the internet, describe how the internet is used for communication (including: IM, VOIP and news services), discuss the benefits and drawbacks of using the internet, define the term World Wide Web, discuss the difference between the internet and the World Wide Web, discuss the advantages and disadvantages of mobile networks, discuss about Video and web conferencing.

Specific National Curriculum Objectives Covered:

All pupils must have the opportunity to study aspects of information technology and computer science at sufficient depth to allow them to progress to higher levels of study or to a professional career.

All pupils should be taught to:
  • develop their capability, creativity and knowledge in computer science, digital media and information technology
  • develop and apply their analytic, problem-solving, design, and computational thinking skills
  • understand how changes in technology affect safety, including new ways to protect their online privacy and identity, and how to identify and report a range of concerns.

Unit 7 – Expert systems and other types of processing            Approximate length: 1 week

In this unit, the students should be able to: describe the components of an expert system, explain how the components of an expert system produce possible solutions, explain how an expert system can be used by organisations, describe the terms backward chaining and forward chaining, explain the use of master and transaction files (including in: payroll and customer orders), analyse the different types of processing and their uses (including: batch, online (interactive), real time)

Specific National Curriculum Objectives Covered:

All pupils must have the opportunity to study aspects of information technology and computer science at sufficient depth to allow them to progress to higher levels of study or to a professional career.

All pupils should be taught to:

  • develop their capability, creativity and knowledge in computer science, digital media and information technology
  • develop and apply their analytic, problem-solving, design, and computational thinking skills

Unit 9 – Database and file concepts

Approximate length: 4 weeks

In this unit, the students will create a Create a database, validate and verify data entry, perform searches use arithmetic operations, numeric and logical functions to perform calculations within a database, sort data, design, create and evaluate an appropriate data entry form, design, create and evaluate database reports including grouped reports, design, create and evaluate a switchboard/menu within a database, import data (including: .csv, .txt, .rtf), export data (including: table, query, report, export as .csv, .txt, .rtf), perform the Normalisation to third normal form (3NF), describe the characteristics of data in un normalised form (0NF), first normal form (1NF), second normal form (2NF) and third normal form (3NF), Create a Data dictionary, describe the components of a data dictionary, and perform the Query selection.

Specific National Curriculum Objectives Covered:

All pupils must have the opportunity to study aspects of information technology and computer science at sufficient depth to allow them to progress to higher levels of study or to a professional career.

All pupils should be taught to:

  • develop their capability, creativity and knowledge in computer science, digital media and information technology

develop and apply their analytic, problem-solving, design, and computational thinking skills 

10. Sound and video editing

 Approximate length: 2 weeks

In this unit, the students will edit a video clip to meet the requirements of its intended application and audience describe how typical features found in video editing software are used in practice, edit a sound clip to meet the requirements of its intended application and audience, describe how typical features found in sound editing software are used in practice and describe how file sizes depend on sampling rate and sampling resolution.

Specific National Curriculum Objectives Covered:

All pupils must have the opportunity to study aspects of information technology and computer science at sufficient depth to allow them to progress to higher levels of study or to a professional career.

All pupils should be taught to:

  • develop their capability, creativity and knowledge in computer science, digital media and information technology
  • develop and apply their analytic, problem-solving, design, and computational thinking skills

Assessment

Formative: Throughout the units, the students will complete graded work, quizzes and theory and practical tasks which allows the teacher to assess the student’s attainment and modify their planning.

For each unit, the students complete a topic tests and quizzes. This allows us to see progress across the units.

Summative: At the end of each term we complete internal end of term exam that includes both the theory and practical concepts. This allows us to measure the students’ progress throughout the term. At the end of February, the students will sit for the AS Mock IT exam for both theory and practical which helps them to prepare for the final external exams from Cambridge.

Remote Learning

Mode of Teaching/Learning:

Live lessons using Microsoft Teams

Live lessons using Phoenix/Zoom

Prerecorded Tutorials to assist the low ability students                       

Video demonstrating the step by step procedure to solve the practical concepts

Online Assessments:

One to One Question and Answer

Online/Real time Quizzes

Online projects

Online tests created using different software

الخطوات التالية

X
تساعدنا ملفات تعريف الارتباط على تحسين تجربتك في استخدام موقعنا وتعزيزها.
ومن خلال استخدام الموقع، فإنكم توافقون على سياسة ملفات تعريف الارتباط الخاصة بنا.
تأكيد