This course provides both secretarial and computer skills to an intermediate standard (Level 2).

It is suitable for those who wish to gain a broad range of skills to a business standard suitable for their first job as a Secretary/Administrator, in a short space of time.

The qualifications gained in this course will provide you with a wide range of job opportunities and future promotional prospects.

This course is designed for those with very little knowledge or prior experience.

Skills are developed from a basic level up to an intermediate standard in all topics.

There are 2 main sections to this course:

• Computer/IT Skills
• Secretarial

This course is a 8 month course plus holiday periods.

Included in the course is our unique Career and Job Support Service which includes helping to design a professional CV, developing your interview techniques, looking at your options based on where you live and the types of businesses you would like to work in, supporting you as you apply for jobs and attend interviews.

All of the qualifications you will be studying towards are nationally recognised qualifications with one of the leading exam boards – OCR (Oxford, Cambridge and the RSA).  OCR qualifications are well recognised in businesses and in addition to vocational qualifications they also provide GCSEs, A Levels, and Teaching qualifications.

Upon successful completion you will be awarded 2 Diplomas:

OCR Intermediate Level 2 Diploma in IT
OCR Intermediate Level 2 Diploma in Text Processing

You can study this course by distance learning, which means you can study at home or work and complete your lessons at times to suit yourself to fit in around other commitments.

You will receive your lessons via email from your course tutor(s) who will send you the relevant courseware for that lesson plus some exercises/assignments to complete.

You will be able to return your completed work to your course tutor via email, who will then mark this and provide feedback and additional tutoring if required.

Gradually you will build your knowledge and skills and work your way through your course, preparing for exams and completing assessment portfolios as you progress.  You will complete your assessments and sit your exams at various stages throughout the course.

We are very keen to develop your confidence as you progress through the course, and it is important that we develop a close working relationship with you to ensure the course is both enjoyable and effective.

All courseware provided is written and designed specifically for our courses and is the copyright of Lewis College.

Topics you will cover on this course

Computer/IT Skills

In this section of the course you will cover the key Microsoft Office applications covering Outlook, Word, Excel, Access, and PowerPoint. 

Outlook

You will learn about a range of features which you may also find helpful in organising your work whilst completing the course.  You will learn how to use the different email features, create folders within Outlook for file management, and use the to do list and notes section as well as the digital diary features.

Word

You will learn how to use the basic Word features eg setting margins, copying/moving and pasting text, headers and footers, indenting, password protection, formatting text, as well as creating tables, importing files from other applications into Word documents, and creating a multi-page Word document.

PowerPoint

You will learn how to create a multi slide presentation using a range of different slide types eg tables, bulleted items, organisation charts, graphs and charts, create hyperlinks, set up master slides and templates, create transition and animation facilities and speakers notes.  You will also learn how to print handouts, slides and speakers notes.

Access

You will first of all learn how to create simple databases.  You will then develop your knowledge in creating queries to cover a range of simple queries to complex queries including logical operators and range operators.  Finally you will learn how to produce a range of reports including grouped reports, formatting reports, add labels and summaries.

Excel

You will cover how to create spreadsheets, develop your skills in formatting the display, use a wide range of formulas and functions including named range, and multi-stage calculations.  You will also produce a range of different graphs/charts from different data sources and produce a range of different reports.

Qualifications

You will complete 5 separate assessment portfolios which will be submitted to OCR as you complete them.

You will be awarded an individual certificate for each module and upon successful completion of all 5 modules, you will be awarded the OCR Level 2 Diploma for IT Users (CLAiT Plus).

Secretarial Skills

This section of the course is designed to develop your key secretarial skills to enable you to produce a range of professional documents used in business today.

These include:

Preparing a range of business documents eg letters, notices, minutes of meetings, reports, etc.

Audio Transcription – preparing a range of business documents from audio dictation.

Editing multi page documents using a range of editing functions eg setting margins, moving text, copying text, emphasising text, using different font styles, indenting, setting headers and footers, sorting text.

Tables including creating tables, modifying borders, sorting rows of data, splitting and merging cells, vertical text, aligning decimal point, sorting rows of data and moving columns.

Mail Merge including creating data files and main document templates, merging documents and matching criteria, developing repetitive data entry techniques.

Desk top publishing features including inserting pictures, using word art, borders, text wrapping options, creating a range of different types of documents using a variety of dtp features.

Qualifications

You will sit 6 separate exams as follows:

• Speed Keying
• Text Production
• Word Processing
• Audio Transcription
• Document Presentation
• Mail Merge

Upon successful completion of the above exams, you will be awarded the OCR Diploma Level 2 in Text Processing

Careers and Job Support

This section of the course is for those of you who would find it beneficial to have some guidance and support in developing a professional CV as well as developing interview techniques, either at the end of the course or part way through.

You will prepare a draft CV to include the qualifications gained on this course and submit this to our careers adviser who can provide help and guidance in developing this to a professional standard, ensuring it is suitable for the types of jobs and businesses you wish to work in.

You will also prepare draft answers to standard interviews, enabling you to prepare a “script” in readiness for any interviews, and again submit this to our careers adviser who can see how you are portraying yourself at the interview stage.

Additional support can also be provided in connection with individual job applications and career plans.

Equipment you will need for this course

You will need to be able to access the Internet – either at home or work to receive your lessons via email.

You will also need a computer – a tower or laptop, plus a printer to enable you to print off the courseware (if preferred) and practice papers.

You will need either Office 2003 or Office 2007 including Word, Excel, Access, PowerPoint and Outlook.

You will also need a folder with plastic pockets if you would wish to print off your courseware to create a hardcopy of the manual for each program.