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. |