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.