Export RSCOT file (RSCOT)

Modified on Sun, 19 Apr at 11:56 PM

Mandatory

Report values

Column

Heading

Description

Record Type

Export file code.

Note: This value is always "RSCOT".

Provider Code

Provider code of the school or organisation authorised to offer the Western Australian Certificate of Education.

Key configuration details

Mandatory

This value is defined using the CurriculumCouncil_SchoolCode configuration setting. See WASCSA_SchoolCode configuration setting.
This value has a maximum field length of 10 characters.

Course Code

Course code.

Note: The third to the fifth characters of the Board Studies Code are used for the Course Code.

Key configuration details

Mandatory

This value is defined using the Board Studies Code on the General tab of Class Maintenance. See Class Maintenance - General tab.
The values of the Board Studies Code field are defined using the luBoardStudiesSubjects lookup table. See luBoardStudiesSubjects lookup table.
This field has a maximum field length of 10 characters.

Western Australian Student Number (WASN)

Candidate number allocated to the student by the School Curriculum and Standards Authority.

Key configuration details

Mandatory

The value is defined using the Studies Code field on the Codes tab of Current Student Maintenance. See Current Student Maintenance - Codes tab.
This value has a maximum field length of 15 characters.

Student Family Name

Surname of the student taking the class.

Key configuration details

Mandatory

This value is defined using the community member information stored on the Student tab of Class Maintenance. See Class Maintenance - Students tab.
This value has a maximum field length of 30 characters.

Student Given Name

Given name of the student taking the class.

Key configuration details

Mandatory

This value is defined using the community member information stored on the Student tab of Class Maintenance. See Class Maintenance - Students tab.
This value has a maximum field length of 30 characters.

Calendar Year

Calendar year.

Key configuration details

Mandatory

This value is defined using the Year field on the WA SCSA tab of Import/Export Student Data window. See Import_Export Student Data - WA SCSA tab.
This value has a maximum field length of 4 characters.
This value has the format YYYY.

Academic Year

Academic year.

Key configuration details

Mandatory

This value is defined using the Year Level field on the School tab of Current Student Maintenance. See Current Student Maintenance - School tab.
The values of the Year Level field are defined using the luYearLevel lookup table. See luYearLevel lookup table.
This value must be either 10, 11 or 12.

Note: SCSA requires this value to be either 10, 11 or 12. This is not enforced in Synergetic, so you must check the export file to ensure no students prior to Year 10 are included.

COAT Criterion 1 Mark

Mark received by the student for COAT Criterion 1.

Key configuration details

Mandatory (if not absent)

Synergetic must be configured to correctly populate this data. See the configuration details below.
Once configuration is complete, you can report the Criterion 1 mark for each student by marking classes using Student Results Maintenance. See Student Results Maintenance - All Students tab.
This field has a maximum length of 2 characters.

Note: Marks must be entered for all four Criterion results as well as the Absent result.

Note: This field must be blank if the COAT Absent Flag (see Column M) is Y.

View configuration details

You can complete the following configuration steps to:

load the CCWACOAT curriculum framework into Synergetic
load the CCWACOAT result types into Synergetic
link the CCWACOAT learning areas to subject assessments.

Loading the CCWACOAT curriculum framework

First, we need to load the CCWACOAT curriculum framework to import the learning area data that will be linked to the subject assessment areas.

Note: You may have already loaded the CCWACOAT curriculum framework.

To load the CCWACOAT Curriculum framework:

Select Module > Assessments > Subject Assessment Other Definition Maintenance.
The Subject Assessment Other Definition Maintenance window is displayed.
Click .
The Load/Add Curriculum Framework window is displayed.
Select CCWACOAT using the Framework drop-down list.
Click .
The curriculum framework is populated. The Code values must remain as loaded, or RSCOT will fail.

Loading the CCWACOAT result types

To load the CCWACOAT result types:

Select Module > System > Lookup Table Maintenance from the Main menu.
The Lookup Table Maintenance window is displayed.
Search for the luReportResultType lookup table.
Click .
The Load Lookup Table Data from External Reference Table window is displayed.
Select CCWACOAT using the External Reference Set drop-down list.
Click .
Check that the following rows are present:

Code	Description	ShortDescription	NumericFlag	Mask	ExternalSystemType	ExternalSystemCode
COATCRITERIA	SCSA COAT Criteria	COAT Mark	True	,0-8	CCWACOAT	COATCRITERIA
COATABSENT	SCSA COAT Absent	COAT Absent	False	, N, Y	CCWACOAT	COATABSENT

Note: The DefaultValue, SynergyMeaning, ResultTypeSort and MaskAutoExpandFlag columns are intentionally blank.

Linking CCWACOAT learning areas to subject assessments

Lastly, we need to link CCWACOAT learning areas to COAT subject assessment areas.

Once subject assessment areas are linked, the Criterion (columns I to L) and Absent (column M) results can be entered using the All Students tab of Student Results Maintenance. See Student Results Maintenance - All Students tab.

To link CCWACOAT learning areas to subject assessments:

Select Module > Assessments > Subject Assessment Area Maintenance.
The Set Subject Assessment Area Search Criteria window is displayed.
Click .
Select the subject assessment using the Subject Assessment Selector.

Note: Schools are required to report COAT marks for all Year 12 English as an Additional Language or Dialect (EAL/D) subject assessments.
Select the subject assessment area to be linked using the Subject Assessment Selector.

Note: If necessary, you can create a new subject assessment area by right-clicking in the grid area and selecting New... from the displayed menu.
Click the Area tab.
Select the correct result type using the Result Type drop-down list:

Note: The following options are available:

- SCSA COAT Criteria: Used to link Criterion 1 to 4 learning areas
- SCSA COAT Absent: Used to link the Absent learning area.
Click next to the External Link field.
The CCWA COAT Curriculum Search window is displayed.
Select the required learning area. In this example, Criterion 1.
Click .
Repeat steps 4 to 9 for the remaining subject assessment areas.
Repeat steps 3 to 10 for the remaining subject assessments.

Note: You can mark classes in Student Results Maintenance. See Student Results Maintenance - All Students tab.

COAT Criterion 2 Mark

Mark received by the student for COAT Criterion 2.

Key configuration details

Mandatory (if not absent)

Synergetic must be configured to correctly populate this data. See the configuration details below.
Once configuration is complete, you can report the Criterion 2 mark for each student by marking classes using Student Results Maintenance. See Student Results Maintenance - All Students tab.
This field has a maximum length of 2 characters.

Note: Marks must be entered for all four Criterion results as well as the Absent result.

Note: This field must be blank if the COAT Absent Flag (see Column M) is Y.

View configuration details

You can complete the following configuration steps to:

load the CCWACOAT curriculum framework into Synergetic
load the CCWACOAT result types into Synergetic
link the CCWACOAT learning areas to subject assessments.

Loading the CCWACOAT curriculum framework

First, we need to load the CCWACOAT curriculum framework to import the learning area data that will be linked to the subject assessment areas.

Note: You may have already loaded the CCWACOAT curriculum framework.

To load the CCWACOAT Curriculum framework:

Select Module > Assessments > Subject Assessment Other Definition Maintenance.
The Subject Assessment Other Definition Maintenance window is displayed.
Click .
The Load/Add Curriculum Framework window is displayed.
Select CCWACOAT using the Framework drop-down list.
Click .
The curriculum framework is populated. The Code values must remain as loaded, or RSCOT will fail.

Loading the CCWACOAT result types

To load the CCWACOAT result types:

Select Module > System > Lookup Table Maintenance from the Main menu.
The Lookup Table Maintenance window is displayed.
Search for the luReportResultType lookup table.
Click .
The Load Lookup Table Data from External Reference Table window is displayed.
Select CCWACOAT using the External Reference Set drop-down list.
Click .
Check that the following rows are present:

Code	Description	ShortDescription	NumericFlag	Mask	ExternalSystemType	ExternalSystemCode
COATCRITERIA	SCSA COAT Criteria	COAT Mark	True	,0-8	CCWACOAT	COATCRITERIA
COATABSENT	SCSA COAT Absent	COAT Absent	False	, N, Y	CCWACOAT	COATABSENT

Note: The DefaultValue, SynergyMeaning, ResultTypeSort and MaskAutoExpandFlag columns are intentionally blank.

Linking CCWACOAT learning areas to subject assessments

Lastly, we need to link CCWACOAT learning areas to COAT subject assessment areas.

To link CCWACOAT learning areas to subject assessments:

Select Module > Assessments > Subject Assessment Area Maintenance.
The Set Subject Assessment Area Search Criteria window is displayed.
Click .
Select the subject assessment using the Subject Assessment Selector.

Note: Schools are required to report COAT marks for all Year 12 English as an Additional Language or Dialect (EAL/D) subject assessments.
Select the subject assessment area to be linked using the Subject Assessment Selector.

Note: If necessary, you can create a new subject assessment area by right-clicking in the grid area and selecting New... from the displayed menu.
Click the Area tab.
Select the correct result type using the Result Type drop-down list:

Note: The following options are available:

- SCSA COAT Criteria: Used to link Criterion 1 to 4 learning areas
- SCSA COAT Absent: Used to link the Absent learning area.
Click next to the External Link field.
The CCWA COAT Curriculum Search window is displayed.
Select the required learning area. In this example, Criterion 2.
Click .
Repeat steps 4 to 9 for the remaining subject assessment areas.
Repeat steps 3 to 10 for the remaining subject assessments.

Note: You can mark classes in Student Results Maintenance. See Student Results Maintenance - All Students tab.

COAT Criterion 3 Mark

Mark received by the student for COAT Criterion 3.

Key configuration details

Mandatory (if not absent)

Synergetic must be configured to correctly populate this data. See the configuration details below.
Once configuration is complete, you can report the Criterion 3 mark for each student by marking classes using Student Results Maintenance. See Student Results Maintenance - All Students tab.
This field has a maximum length of 2 characters.

Note: Marks must be entered for all four Criterion results as well as the Absent result.

Note: This field must be blank if the COAT Absent Flag (see Column M) is Y.

View configuration details

You can complete the following configuration steps to:

load the CCWACOAT curriculum framework into Synergetic
load the CCWACOAT result types into Synergetic
link the CCWACOAT learning areas to subject assessments.

Loading the CCWACOAT curriculum framework

First, we need to load the CCWACOAT curriculum framework to import the learning area data that will be linked to the subject assessment areas.

Note: You may have already loaded the CCWACOAT curriculum framework.

To load the CCWACOAT Curriculum framework:

Select Module > Assessments > Subject Assessment Other Definition Maintenance.
The Subject Assessment Other Definition Maintenance window is displayed.
Click .
The Load/Add Curriculum Framework window is displayed.
Select CCWACOAT using the Framework drop-down list.
Click .
The curriculum framework is populated. The Code values must remain as loaded, or RSCOT will fail.

Loading the CCWACOAT result types

To load the CCWACOAT result types:

Select Module > System > Lookup Table Maintenance from the Main menu.
The Lookup Table Maintenance window is displayed.
Search for the luReportResultType lookup table.
Click .
The Load Lookup Table Data from External Reference Table window is displayed.
Select CCWACOAT using the External Reference Set drop-down list.
Click .
Check that the following rows are present:

Code	Description	ShortDescription	NumericFlag	Mask	ExternalSystemType	ExternalSystemCode
COATCRITERIA	SCSA COAT Criteria	COAT Mark	True	,0-8	CCWACOAT	COATCRITERIA
COATABSENT	SCSA COAT Absent	COAT Absent	False	, N, Y	CCWACOAT	COATABSENT

Note: The DefaultValue, SynergyMeaning, ResultTypeSort and MaskAutoExpandFlag columns are intentionally blank.

Linking CCWACOAT learning areas to subject assessments

Lastly, we need to link CCWACOAT learning areas to COAT subject assessment areas.

To link CCWACOAT learning areas to subject assessments:

Select Module > Assessments > Subject Assessment Area Maintenance.
The Set Subject Assessment Area Search Criteria window is displayed.
Click .
Select the subject assessment using the Subject Assessment Selector.

Note: Schools are required to report COAT marks for all Year 12 English as an Additional Language or Dialect (EAL/D) subject assessments.
Select the subject assessment area to be linked using the Subject Assessment Selector.

Note: If necessary, you can create a new subject assessment area by right-clicking in the grid area and selecting New... from the displayed menu.
Click the Area tab.
Select the correct result type using the Result Type drop-down list:

Note: The following options are available:

- SCSA COAT Criteria: Used to link Criterion 1 to 4 learning areas
- SCSA COAT Absent: Used to link the Absent learning area.
Click next to the External Link field.
The CCWA COAT Curriculum Search window is displayed.
Select the required learning area. In this example, Criterion 3.
Click .
Repeat steps 4 to 9 for the remaining subject assessment areas.
Repeat steps 3 to 10 for the remaining subject assessments.

Note: You can mark classes in Student Results Maintenance. See Student Results Maintenance - All Students tab.

COAT Absent Flag

Whether the student was absent during the reporting period.

Key configuration details

Mandatory

Synergetic must be configured to correctly populate this data. See the configuration details below. Specifically, the Absent Criteria Code must exist.
Once configuration is complete, you can report the Absent Status for each student by marking classes using Student Results Maintenance. See Student Results Maintenance - All Students tab.
This field has a value of:

- Y when the student was absent
- N when the student was not absent.

Note: Criterion 1 to 3 fields must be blank if the COAT Absent Flag is Y.

View configuration details

You can complete the following configuration steps to:

load the CCWACOAT curriculum framework into Synergetic
load the CCWACOAT result types into Synergetic
link the CCWACOAT learning areas to subject assessments.

Loading the CCWACOAT curriculum framework

First, we need to load the CCWACOAT curriculum framework to import the learning area data that will be linked to the subject assessment areas.

Note: You may have already loaded the CCWACOAT curriculum framework.

To load the CCWACOAT Curriculum framework:

Select Module > Assessments > Subject Assessment Other Definition Maintenance.
The Subject Assessment Other Definition Maintenance window is displayed.
Click .
The Load/Add Curriculum Framework window is displayed.
Select CCWACOAT using the Framework drop-down list.
Click .
The curriculum framework is populated. The Code values must remain as loaded, or RSCOT will fail.

Loading the CCWACOAT result types

To load the CCWACOAT result types:

Select Module > System > Lookup Table Maintenance from the Main menu.
The Lookup Table Maintenance window is displayed.
Search for the luReportResultType lookup table.
Click .
The Load Lookup Table Data from External Reference Table window is displayed.
Select CCWACOAT using the External Reference Set drop-down list.
Click .
Check that the following rows are present:

Code	Description	ShortDescription	NumericFlag	Mask	ExternalSystemType	ExternalSystemCode
COATCRITERIA	SCSA COAT Criteria	COAT Mark	True	,0-8	CCWACOAT	COATCRITERIA
COATABSENT	SCSA COAT Absent	COAT Absent	False	, N, Y	CCWACOAT	COATABSENT

Note: The DefaultValue, SynergyMeaning, ResultTypeSort and MaskAutoExpandFlag columns are intentionally blank.

Linking CCWACOAT learning areas to subject assessments

Lastly, we need to link CCWACOAT learning areas to COAT subject assessment areas.

To link CCWACOAT learning areas to subject assessments:

Select Module > Assessments > Subject Assessment Area Maintenance.
The Set Subject Assessment Area Search Criteria window is displayed.
Click .
Select the subject assessment using the Subject Assessment Selector.

Note: Schools are required to report COAT marks for all Year 12 English as an Additional Language or Dialect (EAL/D) subject assessments.
Select the subject assessment area to be linked using the Subject Assessment Selector.

Note: If necessary, you can create a new subject assessment area by right-clicking in the grid area and selecting New... from the displayed menu.
Click the Area tab.
Select the correct result type using the Result Type drop-down list:

Note: The following options are available:

- SCSA COAT Criteria: Used to link Criterion 1 to 3 learning areas
- SCSA COAT Absent: Used to link the Absent learning area.
Click next to the External Link field.
The CCWA COAT Curriculum Search window is displayed.
Select the required learning area. In this example, Criterion 3.
Click .
Repeat steps 4 to 9 for the remaining subject assessment areas.
Repeat steps 3 to 10 for the remaining subject assessments.

Note: You can mark classes in Student Results Maintenance. See Student Results Maintenance - All Students tab.

Attachments (43)

WASCSA_P-10_Curriculum_Search_window.png
51.3 KB

External_Link_field_(find_button_highlighted).png
2.16 KB

Find_(ellipses)_button.png
1.3 KB

RSLAS_(selecting_result_type).png
14.7 KB

Subject_Assessment_Selector_window_(area_selected).png
7.39 KB

Subject_Assessment_Selector_window_(assessment_selected).png
8.91 KB

Set_Subject_Assessment_Search_Criteria.png
14.8 KB

Subject_Assessment_Other_Definition_Maintenance_(WASCSA).png
56.1 KB

Load-Add._Curriculum_Framework_window_(blank)png.png
13 KB

Subject_Assessment_Other_Definition_Maintenance_(blank).png
36.6 KB

image2022-10-25_11-22-48.png
27.9 KB

Results_Maintenance_(Marking_SCSA).png
386 KB

bn_ok_action_(Creditor_Invoice_Entry).png
1.09 KB

Add-Load_button.png
896 Bytes

luReportResultType_lookup_table_(RSLAS).png
9.13 KB

Subject_Assessment_Maintenance_-_Area_tab_-_Area_sub-tab.png
261 KB

Goto_Area_button.png
1.52 KB

Go_to_Summary_button.png
3.38 KB

Create_New_Subject_Assessment_Area_window.png
75.4 KB

Creating_new_subject_assessment_areas_(result).png
473 KB

Finish_button.png
691 Bytes

worddavac651030c561a9ca7efc3eae6ab9c314.png
1.02 KB

Load_(ellipsis)_button_(lookup_table_maintenance_window).png
681 Bytes

image2023-5-10_23-45-15.png
7.42 KB

Selecting_COAT_Subject_Assessment_area_C1.png
5.43 KB

Selecting_COAT_Subject_Assessment_area_C2.png
5.46 KB

Selecting_COAT_Subject_Assessment_area_C3.png
5.5 KB

Selecting_COAT_Subject_Assessment_area_C4.png
5.53 KB

Selecting_COAT_Subject_Assessment_area_CA.png
5.51 KB

DSY-23433_-_RSCOT_SAAOD.jpg
133 KB

69e1ef44cb8f9.Subject_20Assessment_20Other_20Definition_20Maintenance_20(blank).png
36.6 KB

69e1ef44cb8fb.Add-Load_20button.png
896 Bytes

69e1ef44cb8fc.Load-Add._20Curriculum_20Framework_20window_20(blank)png.png
13 KB

69e1ef44cb8fd.bn_ok_20action_20(Creditor_20Invoice_20Entry).png
1.09 KB

69e1ef44cb8fe.DSY-23433_20-_20RSCOT_20SAAOD.jpeg
133 KB

69e1ef44cb8ff.Load_20(ellipsis)_20button_20(lookup_20table_20maintenance_20window).png
681 Bytes

69e1ef44cb900.Set_20Subject_20Assessment_20Search_20Criteria.png
14.8 KB

69e1ef44cb901.image2023-5-10_23-45-15.png
7.42 KB

69e1ef44cb902.Selecting_20COAT_20Subject_20Assessment_20area_20C1.png
5.43 KB

69e1ef44cb903.Find_20(ellipses)_20button.png
1.3 KB

69e1ef44cb904.Selecting_20COAT_20Subject_20Assessment_20area_20C2.png
5.46 KB

69e1ef44cb905.Selecting_20COAT_20Subject_20Assessment_20area_20C3.png
5.5 KB

69e1ef44cb906.Selecting_20COAT_20Subject_20Assessment_20area_20CA.png
5.51 KB