Bitesize Training Courses Word, Excel, School Finance & GDPR for Schools

 

Bitesize courses – these courses are designed to provide a series of short, snappy sessions that build up to a full knowledge of the topic.   They are delivered online, so can be accessed at any time, anywhere and anyone in your school can be involved.

All courses except GDPR have 10 x 20 minute sessions with a 5 minute assignment for each.  GDPR has 5 x 10 minute sessions for general school staff and 5 additional 10 minute sessions for those responsible for school compliance.

 

The courses takes you through from a beginner to a fully competent user although you can start at the very beginning or jump in at the point that suits you best.  You can stop at any point – submit your assignment and receive a certificate at the appropriate level.

Each session has notes to download, a video presentation for you to follow and replicate and a short assignment at the end to make sure you are happy with that topic.

 

Each whole course costs £99 per school and multiple staff can use the course for this price.   All 4 can be purchased for £299 per school.

Excel Topic List

Word Topic List

School Finance Topic List

GDPR Topic List

EXCEL - 

Beginner Level

Session 1 – Create a spreadsheet, what’s on screen, insert & edit text and numbers, simple calculations, printing.

Session 2 – Basic formatting or numbers and text, moving & copying, simple formulae

Basic User Level

Session 3 – Text & number formatting, Borders & Shading, Headings, Freeze panes

Session 4 – More formulae – IF, SUMIF etc

Session 5 – Charts

Regular User Level

Session 6 – Filters, Sorting, Subtotals & Pivot tables

Session 7 – Conditional formatting, data validation

Session 8 – Absolute & relative cell references, BODMAS

Session 9 – Multitab & multisheet calculations, Protection, Advanced printing

Session 10 – Macros & Toolbars

WORD - 

Beginner Level

Session 1 – Create a word document, what’s on screen, enter and edit text, move & copy, save

Session 2 – Format text, spell check and printing

Basic User Level

Session 3 – Margins & tabs, Orientation, Columns

Session 4 – Inserting objects – pictures, shapes and text boxes

Regular User Level

Session 5 – Headers & footers, Autotext & autocorrect

Session 6 – Inserting tables & charts, symbols & equations

Session 7 – Collaborative working – comments & track changes

Session 8 – Templates, Clipboards & translation

Session  9 – Mailmerge

Session 10 – Macros & Toolbars

SCHOOL FINANCE -

Session 1 – How schools are funded and what they spend their funding on. The accounting process in schools

Session 2 – Double entry bookkeeping

Session 3 – Appropriate Use of Funds and Value for Money

Session 4 – Separation of duties & Authorisation

Session 5 – Record keeping, traceability of records, external audit

Session 6 – Capital items/ fixed asset – what they are, treatment, depreciation

Session 7 – Financial reports – understanding and producing – Income Statement, Balance Sheet, Cash Flows

Session 8 – Management reports – understanding and using budgets

Session 9 – Period End procedures

Session 10 – Housekeeping, & Internal audit.

GDPR FOR SCHOOLS - 

Session 1 – Intro to GDPR & Personal data. GDPR requirements for schools & Privacy by design

Session 2 – The Lawful basis for holding personal data in schools.   Consent considerations.

Session 3 – Basic Security

Session 4 – What to do in a breach  & Subject Access Requests.

Session 5 – Special considerations for schools

Session 6 – Privacy Notices

Session 7 – Data Retention

Session 8 – The role of the DPO – do you need one?

Session 9 – Subject rights

Session 10 – Steps for compliance

 

To purchase the bitesize course to do at your own time, with downloadable notes, video presentations and assignments, please complete the form below.

 
 
 
 

PRIVATE FUND NEWSLETTERS

Newsletters for users:

3/6/19   22/5/19    29/4/19

8/3/19  13/2/19    5/2/19  23/1/19     

10/12/18   26/11/18  15/10/18

1/10/18   17/9/18     4/9/18

5/6/18

 

ADDRESS

Istek UK Ltd

3 St Ursula's Close

Salisbury

Wiltshire SP1 3FY

Tel - 01722 413255

  • Twitter Square
  • LinkedIn App Icon

THINKING OF PFM? LATEST EMAILS TO INTERESTED SCHOOLS

Jun 19 - Book a FOC online demo

Jun 19 - Preparing for a September start

 

Nov 18 - Ready for a January Start

 

Oct 18 - Why manage school fund separately?

 

Sep 18 - Managing School Funs, Trips & Clubs

 

Aug 18 - Online video of PFM & information pack