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 -
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 INDIVIDUAL bitesize courses to do at your own time, with downloadable notes, video presentations and assignments, please complete the form below.
OR - click here to order ALL the courses in our Unlimited Online Training Package for £299 per school.