Calculated Columns

Modified on Mon, 23 Feb at 5:06 PM

TABLE OF CONTENTS

Link to workbook
Engage Package
What is the purpose of this course?
Who is the course aimed at?
What is the recommended course length?
Are there any prerequisites?

Link to workbook

Engage Package

Engage Teaching

What is the purpose of this course?

To train users in creating mark sheets and assessment data for assessment reports and class assessments, including calculations within a mark sheets and cross mark sheet calculations

Who is the course aimed at?

Director of Studies, Academic Head, Staff responsible for maintaining and analysing assessment data

What is the recommended course length?

½ day (3 hours)

Are there any prerequisites?

Users must have attended Assessments training

Please ensure you are running the latest version of Engage for full calculated column functionality

Examples of Markbooks and calculations required must be sent to the trainer prior to training

External Report Templates must be discussed during the session

Component/Screen	Purpose	Specific resources/ information required
System Preferences	Enable Calculated columns Set up weightings Set up decimal places	Details of weightings for calculations
Manage Assessment Columns	Create new calculated columns Look at available calculations and their purposes Edit existing calculated columns	Details of calculations to create Data to be included in the calculations
Class Marksheets in Engage	Look at calculation result columns on a marksheet
Class Marksheets in the Portal	Look at calculation result columns on a marksheet How to add/edit calculations in the Staff Portal