onCourse handbook

Aristedes Maniatis

Natalie Morton

Stephen McIlwaine

Charlotte Tanner

Marcin Skladaniec

version 7.1


This Work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Australia License.


No liability for the contents of this document can be accepted. Use the concepts, examples and information at your own risk. There may be errors and inaccuracies that could be damaging to your system. Proceed with caution, and although it is highly unlikely that accidents will happen because of following advice or procedures described in this document, the author(s) do not take any responsibility for any damage claimed to be caused by doing so.

All copyrights are held by their by their respective owners, unless specifically noted otherwise. Use of a term in this document should not be regarded as affecting the validity of any trademark or service mark. Naming of particular products or brands should not be seen as endorsements.

15 Apr 2015

Table of Contents

I. Installation and setup
1. Downloading and installing onCourse
System requirements
Network requirements
Database considerations
onCourse on Windows
onCourse on Mac OS X
Running onCourse
Installing onCourse Server on other platforms
Upgrading onCourse
What is an onCourse upgrade?
Backing up your onCourse datafile
Upgrading the onCourse datafile
Upgrading the onCourse clients
Can I downgrade my onCourse software?
Starting a new data file
Running multiple versions of the onCourse Server
Troubleshooting connection problems
2. onCourse Cloud
What is onCourse cloud?
The onCourse Cloud Demo
Running onCourse from your browser
Trouble Shooting Java Web Start
3. Getting Started
How to get around the onCourse interface
Getting around
The onCourse home screen
Menu Bar
List View
Filters and query
Core Filters
Tag Groups
Simple Queries
Advanced Queries
Saved Finds
Cogwheel special functions
Bulk add or remove classes from website
Cancel classes
Contacting tutors and students
Finding related records
Create certificates.
Record detail view
Open related records
Clairvoyant fields and drag and drop
4. Users and Authentication
Changing user settings and passwords
onCourse Login with Two Factor Authentication
Enabling two factor authentication
Disabling or resetting two factor authentication
Emergency access
5. Sites and Rooms
onCourse Terms and Definitions
Working with Sites and Rooms
Site Record Tabs
Room Record Tabs
Creating Sites and Rooms
6. Creating and Modifying Contacts
onCourse contact types
Adding a new contact from the list view
Adding a new contact in Quick Enrol
Modifying contact details
Setting up Email, Phone and Mail Preferences
Adding VET data to students
Student's enrolment and VET history
Contact's financial records
Adding Pictures to Contacts
Notes tab
Enrolment tab
Relationships between contacts
Adding a relationship
Adding different types of relationships
Searching across relationship types
Using relationships in Quick Enrol
Finding contacts
Searching for related information
7. Tutors
onCourse Terms and Definitions
Working with Tutors
Tutor Record Tabs
Creating Tutors
Contacting tutors by email or SMS
Contacts and Attachments
To add an attachment to a contact
To open or view an attachment
8. Creating Courses
onCourse Terms and Definitions
Working with Courses
The onCourse list view
The course cogwheel
Creating a new course
Editing and Updating Courses
Writing course descriptions for the web
What does a good course description include?
What is SEO and why is it important?
Tips for writing SEO copy
VET Courses
Courses which are complete qualifications
Partial qualifications
9. Creating Classes
onCourse Terms and Definitions
Working with Classes
Special Class Functions
Class Record Tabs
General tab
Tutor tab
Budget tab
Timetable tab
VET tab
Web tab
Notes tab
Enrolments tab
Attendance tab
Outcomes tab
Creating Classes
Adding RTO and VET data to class records
Publishing classes online
Working with classes that have enrolments
Marking Student and Tutor attendance
II. Enrolments
10. Processing Enrolments
Terms and Definitions
Working with Quick Enrol
Creating an enrolment with Quick Enrol
Simple enrolments
Discounting the enrolment fee
Adding a promotional code
Adding information to invoices
Adding a 3rd party payer
Enrolling multiple students in multiple classes
Enrolling a student in credit or debt
Quick Enrol payment options
Reviewing the invoice
Using a voucher for payment
Recording a cash payment
Recording a cheque payment
Recording an EFT payment
Processing a credit card payment
Managing cancelled and failed credit card transactions
Processing payments outside of Quick Enrol
Processing a Payment In
Sending invoices and confirmations
Quick Enrol FAQ
How do I manage an overpayment made by a student?
What do I do if I have recorded a payment (money) without any payment actually being made or I recorded the wrong amount?
How do I change part of an enrolment fee to a business, and part to a student?
How do I provide an student with a discount after they have already enrolled?
How do I check to see if a student has been enrolled?
What happens if a student doesn't meet the class age restrictions?
11. Cancellations, Transfers and Refunds
Cancelling a single enrolment
Creating a manual credit note
Manual discounts after enrolment
Using the credited amount as credit towards another enrolment
Payment reversals within the payment in window
Refunding a student via Payment Out
A few notes on onCourse credit card reversals
Cancelling A Class
Student Transfers
What if the value of the new enrolment is more expensive than the old class or less expensive?
Why can't I just edit the existing enrolment?
How can I fix a mistake I made where I charged the student the wrong amount or credited a credit note in error?
How can I use one contact's credit to pay for another student's enrolment?
12. Private Bookings and Custom Classes
Creating and Enrolling Students in a Custom Class
13. Enrolments by Application
An overview of applications and enrolments
Setting the course to Enrol by Application
Navigating the application window
Creating applications
Approving and rejecting applications
Applications on the web
Applying online
Enrolling after application approval
Application records in the portal
III. Marketing and sales
14. Tags and Tag Groups
Using Tags
Subjects Tag Group
Tags as Filtering Tool within onCourse Client
Tags on your onCourse Website
Tagging as it relates to the Website URL
Utilizing Tag Web Descriptions
A flexible way to add classification and structure to your data
Creating a filter in advanced search to make tagging more powerful.
Tagging and Untagging multiple records
15. Concessions and Memberships
What is a concession?
What is a membership?
Creating concession types
Adding a concession to a student record
Creating a membership
Purchasing a membership
Redeeming a membership
Searching for students with concessions or memberships
16. Discounts
Introduction to discounts
Creating effective discount strategies
How to create a discount
Defining the discount value
Defining the eligible students
Defining the eligible classes
Accessing discounts during enrolment
Accessing discounts through Quick Enrol
Accessing promotional code discounts in onCourse through Quick Enrol
Membership discounts during Quick Enrol
Manual discounts in Quick Enrol
Accessing discounts on the web
Promotional codes on the web
Membership discounts for online enrolments
Financial aspects of discounts
Discounts in the class budget
Accounts and discounts
Understanding GST and rounding in discounts
Example discount campaigns
Reporting on discount use
17. Mailing lists
Why use mailing lists
Creating a mailing list
Sending Emails and SMS Messages to Clients on your Mailing List
Student self subscriptions
Signing up to Mailing Lists via the Website
Managing your mailing lists via the Skills onCourse Student Portal
Unsubscribing from Mailing Lists via a Link within an email
Manually adding or removing students from a mailing list
Unsubscribing a contact from a mailing list
18. Waiting Lists
Enabling waiting lists
Student web subscription to waiting lists
Managing waiting lists within onCourse
Advising students on waiting lists that a class is available
Enrolling students on waiting lists
19. CorporatePass
When to Use a CorporatePass
Controlling Usage
Setting up your CorporatePass within onCourse
Using the Corporate Pass to Enrol Online
Monitoring the Use of CorporatePasses within onCourse
20. Vouchers
onCourse Terms and Definitions
Creating a voucher type
Navigating around the Voucher Type window
Purchasing a voucher
Purchasing a voucher on the web
Redeeming a voucher
Redeeming a voucher on the web
Navigating the Voucher list window
Cancelling a Voucher
21. Other products
Navigating around the Product window
Adding a new product
Relating a product to a course
Purchasing a product
22. Sending messages
Selecting people to contact
From contact, tutor or student lists
From classes
From waiting lists
From mailing lists
Sending an integrated mail message
Understanding email messaging
Understanding SMS Messaging
Postal mail
Exporting contact details for other messaging tools
Messaging opt in and opt out
Message permissions and message history
Automatic messages in onCourse
IV. Record management
23. Document Management
Adding new documents
Attaching existing documents
Editing an existing document
Special documents
Access rights
24. Reporting
Using reports
Printing Reports in onCourse
Financial Reports
Course and class management reports
Marketing reports
Information for students
Information for tutors
Existing reports in onCourse
Budget Details
Budget Summary by Subject
Class Invoice Record
onCourse Banking Report
Payslip Report
Class Tutor List Report
Class Tutor Pay Schedule Report
Debtors and Creditors Report
Class Prepaid Fees Liability Report
Invoice Report
Corporate Pass List Report
Corporate Pass Detailed Report
Payment-in Report
Transaction Detail
Transaction Summary
Reconciliation Report
Statement Report
Certificate Attendance
Student Academic Transcript Report
Class by Subject Report
Funding Hours Report
Class Hours Report
Sales Report
Sales by Course Location
Cancelled Classes Count Report
Discounts by Class
Classes Report
Courses Report
All Class Details
Student Special Needs
Class By Site
Rooms List
Room Timetable Report
Class Tutor List
Site List
Site Details
Tutor Details Report
Tutors List Report
State Based Enrolment Summary
Class Roll - Age
Class Roll - USI
Class Sign
Mailing List Export
Wait List Report
Total Discounts
Class Details Report
Course Details Report
Enrolment Confirmation Report
Class Information Report
Class Roll
Class Roll - Single Session
Simple Class Roll
Class Timetable Report
Class Timetable Planning Report
Class Contact Sheet
Student Contact List
Student Details
Class Roll Contact Number
Assessment Outcome Report
Qualifications Report
Certificate - Statement of Attainment
Certificate - Qualification
Training Packages Report
Traineeship Training Plan
Training Plan Report
Trial Balance Report
25. Creating custom reports
Getting started with custom reports
Exporting report templates from onCourse
Editing reports in JasperSoft Studio
Importing a report
The structure of a report
Report Properties
SQL Reporting with a JDBC connector
Using an SQL client with onCourse to write queries
Setting DBeaver with the right JDBC to talk to onCourse
Creating SQL queries
26. Importing and exporting
From the list view
Direct access to the SQL database
Sending messages
Exporting to Adobe Indesign
Custom export templates
Writing XSL
Exporting to MYOB
Generating the Export via the Financial Summary Extract Menu
Generating the Export via the Transaction Window
XML import
V. RTO Features
27. RTO Guide
Understanding how outcomes are attached to enrolments
Creating Class Training Plans
Setting and modifying outcomes
What are outcomes?
CSWE courses, classes and outcomes
Setting up Certificate in Spoken and Written English (CSWE) courses
VET delivery hours
VET data in the class window
VET Qualifications and other Certificates
Certificate creation and validation process
Examples of default Certificate layouts
Customising the layout of your VET Certificate template
Creating Certificates for a class group
Creating Certificates from Enrolment records
Creating manual Certificate records
Creating Certificates of Attendance for non-VET courses
Creating a Certificate of Attendance for a VET class student
Courses by Cluster
Creating the Qualification
Creating the clusters
Enrolments and Payment
Traineeships and Custom Training
28. Unique Student Identifier (USI)
What is the USI?
Requirements and limitations
The onCourse USI process
How onCourse automates the USI process
What you need to do enable the USI validation service in onCourse
Student self-service
Capturing the USI in onCourse
Creating a USI for a student
Manual entry of a USI
Editing a locked student record
Certificate printing and the USI
29. AVETMISS Reporting
What do I have to lodge?
Training Organisation (NAT00010) file
Training Organisation Delivery Location (NAT00020) File
Course (NAT00030) File and Module/Unit of Competency (NAT00060) File
Client (NAT00080) File and Client Postal Details (NAT00085) File and Disability (NAT00090) File and Prior Educational Achievement (NAT00100) File
Enrolment (NAT00120) File
State Specific NAT000120 fields
Qualification Completed (NAT000130) File
Competency Completion Online System (CCOS)
Validation Rules and State Variations in AVETMISS Reporting
How to give your AVETMISS data to the people who want to pay you
Can I stop a class and all it's students being exported for AVETMISS?
How can I get my State Accredited Modules added to onCourse?
Where do I enter the State Funding Codes in onCourse for the state where I am reporting to?
How do I record a student's outcome who has completed a different elective from the rest of class?
How do I record information about a clients traineeship?
Why do some outcomes in the NAT000120 export with start and end dates of 00000000?
Why, in the AVETMISS 7 export, do my non-VET courses have codes like ISH123?
Creating a VET FEE-HELP Class
Setting the Student's VET FEE-HELP eligibility
Student VET FEE-HELP Loan requests
Exporting VET FEE-HELP data
VI. Financial
31. Invoices and Payment Plans
Creating an invoice
Link invoice lines to classes
Payment plans
Invoice due dates
Class payment plan template
Quick Enrol
Automating payment plans with scripts
32. Budgets
Budget overview
Adding and Editing Budget Items
Budget as calculation tool
Tracking Discounts via the Budget tab
Linking manual invoices income to the class budget
33. Accounting
Relationship between the Student and the Debtor within onCourse
Principles of Accrual Accounting
Explanation of Financial Transactions Generated by the System
Financial Transactions generated by Enrolment and Payment Process
Financial Transactions Generated by Enrolment Cancellation Process
Vouchers and Financial Transactions
Contra Payment Types for Refunds
Deferred Income
How Deferred Incomes Works
What Happens If I have to Cancel or Add a Session to a Class?
What if I want all funds to be transferred at the commencement of the Class?
Assigning Account Codes within onCourse
Accessing Financial Information from onCourse
Locating data using related records
Printed Financial Reports
Copying info within list view windows to Excel
CSV Exports
Exporting to MYOB
Running Queries Directly from the Database
Banking and Reconciliation
34. Tutor pay
Setting standard pay rates
Types of pay rates available in onCourse
Class budget with Tutor pay
Unavailability bookings
Confirming Attendance and exceptions
Generating Tutor pay
Creating payroll through the class window
Payroll Questions and Answers
VII. Advanced topics
35. General Preferences
General Preferences Terms and Definitions
Setting your General Preferences
Linking your credit card merchant ID
Enabling the credit card gateway in onCourse
Handing bounced emails (VERP)
Class Defaults
36. Advanced Setup and Configuration
Financial Setup
Finances and Accounting
Custom fields
Concession types
Contact relation types
Export templates
Email Templates and Scripts
Tutor Roles
Enabling advanced onCourse Features
Access Control (authorisation)
Setting up Active Directory (AD) authentication and authorisation.
AD Authorisation
Server configuration file
Using an external database
Server Memory Allocation
Help, Support and Log files
37. Email Templates
Email Templates
Editing an existing message template
Email headers and footers
Creating new templates
Sending a manual message using a template
Default templates
38. onCourse scripts and custom workflow
What can you do with scripts?
Script permissions
onCourse default scripts
Script triggers
Time based events
Record change events
Script content
Default scripts
Send application decision
Send enrolment
Send invoice
Send payment receipt
Send refund advice
Send student class commencement notice
Send tutor class commencement notice
Send usi reminder
Send voucher
Send application received notification

List of Tables

9.1. Web availability rules
38.1. Examples

List of Examples

2.1. How to access the onCourse Cloud
3.1. How to cancel a class using the cogwheel
3.2. How to duplicate a class
3.3. How to use the cogwheel to contact tutors and students
3.4. How to create a certificate of attendance
5.1. How to set up a new site
5.2. How to set up a new Room
7.1. How to create a new tutor
8.1. How to create a new course
8.2. How to "remove" a unit of competency from a class
8.3. Creating a VET Course
9.1. How to create a new class
9.2. How to create sessions
9.3. Setting the VET information for a class
10.1. How to process a payment in
11.1. How to cancel a single enrolment
11.2. How to create a manual credit note
11.3. How to refund a student
14.1. How to create a Filter using Advanced Search:
14.2. How to bulk tag
15.1. How to create a concession type
16.1. Creating a 10% discount for seniors card holders
16.2. How to create a marketing campaign with a promotional code
16.3. How to create a membership discount
16.4. How to create a private discount for your college staff
20.1. Voucher Use Cases
26.1. Exporting Class Information
26.2. Exporting Invoice Information
27.1. How to create a class training plan
29.1. How to export date range AVETMISS data
29.2. How to export AVETMISS for one or more classes
29.3. How to export AVETMISS for one or more enrolments
32.1. How to create a Class budget
34.1. How to create Tutor pay rates
34.2. Assigning a Tutor and payrate to a class in one step
34.3. Editing a tutors wage after they have been added to the class
34.4. How to record a Tutor as being unavailable
34.5. Setting Tutor attendance for Tutor pay
34.6. Generating, editing and finalising Tutor pay
36.1. How to create a concession type