Information Technology

Year 10

Students practice the basics of computing on a course based on the European computer driving licence. This enables all students to have a basic understanding of all Microsoft Office applications to a standard that will enable them to be proficient in any working environment.

Topic Key Content Learning Outcomes
Microsoft Word
  • General formatting text
  • Inserting images
  • Adding tables
  • Formatting tables
  • Adding data to tables
  • Understanding and implementing Mail Merge
  • Connecting a word document to a spreadsheet
  • Understanding Templates
Students will learn how to create various documents using MS Word working towards a customer’s requirement
Microsoft PowerPoint
  • Create a master slide
  • Insert images to a slide
  • Insert a title slide
  • Formatting a presentation
  • Setting single slide layout
  • Adding a table to a slide
  • Inserting a spreadsheet to a slide
  • Adding a graph to a slide using data from a spreadsheet
  • Add transition formatting in addition to animation
Students learn the basics of creating a business presentation based on customers’ requirements.
Microsoft Excel
  • Add data in a number of formats to a simple spreadsheet
  • Format data within a spreadsheet
  • Use basic formula to given outcomes
  • Use what if statements
  • Use conditional formatting
  • Understand the use of basic functions
  • Insert a variety of charts and graphs to display data trends
Students learn the basics of creating a spreadsheet based on a set of customer requirements.

Year 11

In Year 11 we cover number of advanced IT skills based on the European Driver's Licence to enable those students who have not chosen a computer-based subject to have access to the following:

Topic Key Content Learning Outcomes
Microsoft Word
  • General formatting text
  • Inserting images
  • Adding tables
  • Formatting tables
  • Adding data to tables
  • Understanding and implementing Mail Merge
  • Connecting a word document to a spreadsheet
  • Understanding Templates
  • Creating formatted documents to a given purpose
  • Using advanced tools within MS Word add a corporate design to a document.
Students will learn how to create various documents using MS Word working towards a customer’s requirement
Microsoft PowerPoint
  • Create a master slide
  • Insert images to a slide
  • Insert a title slide
  • Formatting a presentation
  • Setting single slide layout
  • Adding a table to a slide
  • Inserting a spreadsheet to a slide
  • Adding a graph to a slide using data from a spreadsheet
  • Add transition formatting in addition to animation
  • Adding a media file to a presentation
  • Adding sound to a presentation
  • Using a corporate design to a presentation
Students learn the basics of creating a business presentation based on customers’ requirements.
Microsoft Excel
  • Add data in a number of formats to a simple spreadsheet
  • Format data within a spreadsheet
  • Use basic formula to given outcomes
  • Using advanced formula to a spreadsheet automating an outcome
  • Use what if statements
  • Use conditional formatting
  • Understand the use of basic functions
  • Insert a variety of charts and graphs to display data trends
Students learn the basics of creating a spreadsheet based on a set of customer requirements.

March 2025

MTWTFWE
1
345678
101112131415
171819202122
242526272829
31     

View the calendar in full