Course content

This course will help you to develop your skills using basic applications to create work-related documents. It will also give you a good understanding of cyber security. It covers how this affects individuals and organisations and what you can do to keep yourself and others safe.

The course is mostly aimed at learners who want to get a job. This could be in admin or another role that uses Microsoft applications. This course is accredited and after a successful assessment you'll achieve a Level 1 Certificate in Vocational Studies (Gateway).

As well as Office 365, you'll also learn about managing files. The course will also cover how to work safely in a work environment.

This course will enable you to:

Build skills to create and edit basic documents in Word and Excel. Gain software specific skills with a focus on work related documents. You'll also build on your study skills. Key areas include:

• Word. You'll develop the skills to produce a range of documents with a professional look. This will include letters, memos and reports. You'll also learn how to review and adjust content and layout. This will include using settings, tables, images, formats, mail merge, styles, tabs and alignment.
• Excel. You'll learn how to use formulas and functions (min, max, average and count). You'll also find out how to create charts, links and adjust document settings. You'll develop skills in presenting data in different ways, using numbers, text and graphs.
• PowerPoint. You'll develop skills in the software but also improve your ability to present to an audience or job interview panel.

The assessment is portfolio based with evidence to show your skills and knowledge. There are four modules in total.  A further two modules are:

• Cyber security. You'll learn about cyber crime and the risks and effects it has on people and organisations. You'll find out about the methods used to maintain cyber security. 
• Working safely. You'll develop an understanding of different types of risk and hazard. You'll learn the importance of workplace guidelines and policies to ensure you're working safely. You'll find out how safe working reduces the risk of harm to yourself and others.

You will also develop the following skills for work:

• Working as part of a team, sharing ideas and motivating peers to complete a task.
• Having a positive attitude to plan your own work and complete it within a set timeframe.
• Be a good listener and follow instructions accurately.
• Be able to adapt the way you work when things change. Be able to switch to other tasks quickly when needed.
• Be resilient and be able to stick with a task. Even if things don’t go to plan, you should learn from setbacks.
• Develop your literacy and numeracy skills.