Art and Design
Biology and Human Biology
Business Education and Administration
Managing your dept/faculty
Modern Languages
Modern Studies
Pastoral Care/ Guidance/ Pupil Support
Physical Education
Preparing for Senior Management
Pupil Mental Health
Supporting a Probationer teacher


AOKlearning Limited
Station House
Suite 2.3
34 St Enoch Square
Glasgow G1 4DF

Tel: +44 (0)141 221 1001
Fax: +44 (0)8704 909081


AOK organises study visits to Scotland. Please click on the link for more information.



Using Microsoft Excel and PowerPoint

  image coming soon

Aileen Jamieson is an ICT Training Consultant and former teacher with over 17 years’ experience of developing and delivering CPD training to education staff from a wide range of backgrounds and with varying levels of experience and ability. She has Microsoft Office Specialist qualifications in Word, Excel and PowerPoint.

Using Excel and PowerPoint in the classroom
Wednesday 6th June 2018
10.00 - 15.30
£129 plus VAT

Excel is a tool with a broad range of uses in the classroom. It can be used for classroom management or as a tool for teaching. Spreadsheetskills allow pupils to organize, calculate, graph, and analyse data, for example, from a field trip or experiment. Teachers can produce class lists, record and manipulate pupil assessment data and keep track of departmental budgets and expenditure. The latter would be useful for those responsible for presenting PEF funding results. The chart tools in Excel allow you to present data in a visual format using a variety of chart types, for example, column, bar and pie.
This course is suitable for beginners and cover the following:

  • Entering data in a worksheet
  • Printing a worksheet
  • Using cell references
  • Applying formatting
  • Applying conditional formatting
  • Using simple formulae – Sum, Average, Percentage
  • Sorting data
  • Replicating formulae
  • Creating charts from your data
  • Printing a chart
  • Using multiple worksheets

PowerPoint presentations provide the opportunity to combine many tools into one place. Pupils can create multimedia projects on any subject matter. They can animate words and graphics, add sound effects, include videos. It captures the pupils’ attention and helps keep them interested.
Teachers could use PowerPoint to display pupils’ work and curriculum materials or create presentations for parent meetings. You can set PowerPoint presentations to run automatically during such events, providing a slide show of classroom activities and events as parents tour your classroom or school.
This course is suitable for beginners and will cover the following:

  • Adding slides
  • Changing slide layout
  • Adding content – images, videos
  • Simple animation
  • Adding transitions
  • Formatting the background
  • Running a presentation
  • Changing timings

This is a hands on workshop format.

Courses available to all teachers:

Introduction to Pastoral Care/ Guidance/ Pupil Support -
18th May 2018

Preparing for Senior Managment - 22nd May 2018

Supporting a Probationer Teacher in your department/faculty - 23rd May 2018

Mindfulness for Students - 4th June 2018

Using Excel and PowerPoint in the classroom - 6th June 2018

Supporting Young Peoples Mental Health AND Understanding and responding to self-harm - Friday 15th June 2018

Mental Health First Aid - 26th October and 2nd November 2018

Supporting young people with ASD and ADHD in the classroom - 14th November 2018