Short Academic courses

Network offer the following

Accredited courses

OCR Text Processing Stg II
OCR Text Processing Stg III
OCR Level 1 Certificate in Bookkeeping (Computerised)
OCR Level 2 Certificate in Accounting (Computerised)
ECDL
ECDL Advanced Word
ECDL Advanced Excel
ECDL Advanced PowerPoint
ECDL Advanced Access

Non-accredited courses

Sage Payroll
Basic Computers
Combination of Internet, Email & eBay

Brief Description of courses:

OCR Text Processing Stg II

The course is designed to develop the candidate’s ability to produce accurate, well presented documents at a reasonable speed.  The assessment of the programme takes place in the form of two set examinations, part 1 lasting 1 hour and fifteen minutes and part 2 lasting 1 hour forty five minutes.

Course Details

•    Powering up system
•    Insert/Delete text
•    Move text
•    Type abbreviations in full
•    Alter line spacing and line length
•    Insert dates
•    Insert special marks
•    Retrieve documents
•    Inserting phrases
•    Indicate routing
•    Printing documents
•    Emphasise text
•    Indicate enclosures
•    Correct indicated errors
•    Indent text
•    Justify text as requested
•    Save documents
•    Creating tables
•    Correct spelling
•    Sorting text
•    Use of search and replace
•    Inserting Headers and Footers

OCR Text Processing Stg III

The aim of this award is to assess candidate’s ability to apply advances processing and production skills to produce, from handwritten and typewritten draft, a variety of standard business documents.  These will include a letter, a memorandum and a report or article.  The assessment takes place in the form of two set examinations, part 1 lasting 1 hour and 15 minutes and part 2 lasting 1 hour and 45 minutes.

Course Details

•    Insert/Delete Text
•    Move text
•    Text Alignment
•    Alter line spacing and line length
•    Insert Date
•    Insert special marks
•    Insert phrases
•    Indicate routing
•    Pre-stored documents are recalled
•    Emphasise text
•    Replace/Reformat
•    Indicate enclosures
•    Insert footnotes
•    Indenting text
•    Save documents
•    Present Tables in Landscape output
•    Correct spelling and grammar
•    Sorting text
•    Inserting Headers/Footers

OCR Level 1 Certificate in Bookeeping (Computerised)

The aim of the course is to develop learner’s skills in carrying out routine bookkeeping activities using Sage computerised accounting software it is designed for the complete beginner; however you will need basic computer skills or already employed in bookkeeping roles.

Unit 4 Maintaining Ledgers

•    Accessing Accounting Software
•    Setting up Company Details
•    Checking Vat Codes
•    Entering New Customer
•    Entering New Suppliers
•    Creating Nominal Accounts
•    Creating Purchase Invoice/Credit Notes
•    Creating Sales Invoices/Credit Notes
•    Entering Supplier counterfoils
•    Entering Customer Receipts
•    Produce Printouts – Trial Balance, Summary Audit Trail, Detailed Customer and Supplier Activity Reports, A Customer and Supplier Address List
•    Backup Accountancy software

Unit 5 Processing Sales and Purchases Documents

•    Amending Customers Details
•    Entering Trade Discounts and Setting Default Nominal Codes
•    Amending Suppliers Details
•    Amending Nominal Codes
•    Creating Printable Service Invoices/Credit Notes
•    Updating Ledgers and Printing out an Updated Ledger Report
•    Printing Service Invoice/Credit Note Report
•    Entering Customers Receipts
•    Produce Printouts – Remittance Advice Notes, Customer Statements, Audit Trail, Trial Balance

OCR Level 2 Certificate in Accounting (Computerised)

This qualification is aimed at learners who have knowledge of bookkeeping and is already employed in a bookkeeping role. The aim of the course is to develop learner’s skills in managing ledgers.

Unit 4 Process Nominal Ledger Transactions

•    Accessing Accounting Software
•    Selecting appropriate Vat Codes
•    Enter Petty Cash Payments and Receipts
•    Enter Cash Payments and Receipts
•    Enter Bank Payments, Receipts and Bank Transfers
•    Set up and process Recurring Entries
•    Process Salary Journals
•    Correcting errors in Accounts
•    Carry out Bank Reconciliation of Bank Current Account
•    Updating and Making adjustments on bank statements
•    Calculate Company Vat liability
•    Print Vat Return
•    Journal the Sales and Purchase Tax Control Accounts to the Vat Liability Account.
•    Produce Printouts – Trial Balance, Audit Trail, Bank Statement, Bank Payment/Receipt Day Report, Nominal Activity Report
•    Backup Accountancy Software

Unit 5 Carry Out Stock Control Processes

•    Create and Amend Stock Records
•    Create and Amend Sales Orders
•    Create and Amend Purchase Orders
•    Amending Sales Orders Status and Creating Stock Invoices
•    Despatch and print Delivery Notes
•    Update Ledgers
•    Create Stock Credit Notes
•    Produce Printouts – Trial Balance, Stock Details Reports, Product Valuation Report (shows Stock Code, Description, Quantity in Stock, Cost or Average Cost Price, Stock Value, Sale Price and Estimated Sales), Stock Reorder Report, Sales Order Report, and Purchase Order Report.
•    Backup Accountancy Software

ECDL

Prior knowledge of computers is important

MODULE 1 (Basic concepts of Information Technology)

•    Applications of Computers
•    IT & Society
•    Security, Copyright, Law
•    Hardware, software, Ergonomics
•    Information Networks

MODULE 2 (Using the Computer and Managing Files)

•    Switch on and shut down properly
•    Understand the folder structure
•    Create folders and sub-folders
•    Create and save files in specified folders
•    Identify file location, size, date
•    Rename, copy, move, delete files
•    Format and save to floppy
•    Select printer and print file

MODULE 3 (Word Processing)

•    Access and load word processing software
•    Create a new document, or edit an existing one
•    Copy, cut, paste, headers, footers, italics, bold, underline, line spacing, justification, fonts
•    Use a spell check, use help functions
•    Print document

MODULE 4 (Spreadsheets)

•    Enter numbers, text, formulae
•    Format cells (size, text, number, etc)
•    Insert rows and columns
•    Calculate new values
•    Sort data
•    Use basic functions, totals, averages, count, max, min, if etc
•    Relative and absolute cell references
•    Produce and print charts and graphs, add titles and labels
•    Work with more than one spreadsheet

MODULE 5 (Databases)

•    Design a simple database, create a record structure
•    Enter and edit data, add and delete records
•    Define keys
•    Search for, select and sort data
•    Present selected data in a particular sequence
•    Modify the database structure
•    Carry out queries

MODULE 6 (Presentation)

•    Simple slide shows
•    Bullet points, symbols, clip art, borders
•    Change fonts, centre and embolden text
•    Use of organisation charts

MODULE 7 (Information Networks)

•    Send an e-mail message, with or without an attachment
•    Describe how to connect to, and possible uses of e-mail
•    Connect to the Internet or to a public information service
•    Retrieve specific information and submit to examine

ECDL Advanced Word

If you have completed your ECDL, here are some advanced features that you can learn through word.

•    Advanced Text editing features
•    Create and modify master documents and sub-documents.
•    Tables of contents and multiple column layouts
•    Document Organisation creating and modify bookmarks, indexes, cross-references, field codes, footnotes and endnotes.
•    Add and modify password protection to a document
•    Text comments and revision tracking
•    Use advanced mail merge features to edit and sort data source using merge criteria
•    Macros features to record run and copy macros
•    Forms with drop-down fields and check boxes
•    Use advanced spreadsheet features to modify an embedded worksheet within a document

ECDL Advanced Excel

If you have completed your ECDL, here are some advanced features that you can learn through Excel.

  • Editing Data (Name cell ranges)
  • Display (Freeze, Hide, sub-totalling, one-input or two in-put data tables)
  • Protection to worksheet
  • Security to spreadsheet
  • Data handling –     Sorting
  • Querying/Filtering
  • Data Linking
  • Templates
  • Charts & Graph techniques
  • Functions – Date/time, mathematical, statistical, financial, logical, text, lookup and reference function
  • Analysis – Pivot Tables/Dynamic crosstabs and named scenarios
  • Scenarios/Versions
  • Auditing
  • Special Tools – Macros/Templates

    • ECDL Advanced PowerPoint

    If you have completed your ECDL, here are some advanced features that you can learn through PowerPoint.

    •    Design consideration
    •    Merge presentations and word processed documents into presentations
    •    Manipulate, edit and apply effect to images, pictures and drawn objects in presentations
    •    Create and manipulate charts to create professional looking presentations.
    •    The use of sound and video in presentations
    •    Apply various slide transitions options and settings and creating a customised show
    •    Relating information and linking text from documents or spreadsheets and generating charts into slides, displaying as objects
    •    Macros features to record run and copy macros
    •    Forms with drop-down fields and check boxes
    •    Use advanced spreadsheet features to modify an embedded worksheet within a document

    ECDL Advanced Access

    If you have completed your ECDL, here are some additional features that you can learn through Access.

    • Table Design – Modify data types
    • Input masks and lookup fields, mandatory data fields
    • Relationships – Many-to-many relationships
    • Use referential integrity
    • Apply automatic deletion of related records
    • Query Design – Create queries to update data in table
    • Queries to save the selected information as a table
    • Query Formulas – Group information, Use functions in a query: sum, count, average, max, min
    • Crosstab query, wildcards query
    • Use arithmetic, logical expressions in a query
    • Refine query - Show duplicates, unmatched values, highest and lowest range of values in a query.
    • Form Design – forms with bound and unbound controls
    • Data fields to appear within form header
    • Subforms – create subforms and link to parent
    • Report Design – calculations
    • Macros – Record and assign
    • Import, Export and Link Data – Import and export to range of file formats

    Sage Payroll

    No previous knowledge of Sage is required although basic computer skills is required.

    •    Accessing Payroll Software
    •    Entering Company Details
    •    Setting Up New Employees
    •    Paying Your Employees
    •    Process Payslips
    •    Update Records
    •    Print  various reports
    •    Back Up Data
    •    Set Up Process Date
    •    SSP – Statutory Sick Pay
    •    Adding a New Employee
    •    Employee Returning to work from SSP
    •    Processing a Leaver
    •    Tax Credit Notification
    •    Amending Company Details
    •    Holiday Pay
    •    SMP- MATB 1 Certificate
    •    Changing Employees Pay Elements
    •    Maternity Pay
    •    Setting Up Departments within a company

    Basic Computers

    • Word Processing
    • Creating the perfect letter
    • Using Templates for Fax and letters
    • Creating Flyers
    • Printing from Word
    • Internet & Email
    • Setting up email account
    • Sending and Receiving emails
    • Attaching files to emails
    • Opening attachments in emails
    • Using Google search engine
    • Basics of Spreadsheets
    • Creating a spreadsheet
    • Using basic formulas
    • Printing out Workbook
Back to top