Upload CCA Schedule
This function allows the users to upload CCA Schedule. CCA Timetable are created using CCA Template: CCA Schedule Upload File - Sample.CSV.. Detailed instructions can also be downloaded: CCA Schedule Instructions v0.5.pdf..
Upload CCA Schedule
Roles Involved: School CCA head
Navigate to Main menu > Curriculum Management > Schedule of Classes > Upload CCA Schedule
Click Add a New Value tab
Fill in Run Control ID field and click Add button. Format are as followed: (School Code)_Term (Term Code). E.g 1006_Term1510.
Enter value on Institution, Acad Career, Campus, Term, Session
Tick on Upload full term data checkbox
Click Upload File button and upload the file with .CSV format
Click View File button to view uploaded file
The upload data file should be filled in as shown in the image.
Click Run button to run the process
A Message will pop out to prompt for user confirmation. Click OK button.
Click OK button at the process scheduler request page
Click Process Monitor
Click on Refresh button to refresh the process monitor status
Click on Details link when the Run status has changed to “Success” and Distribution Status = “Posted”
Click View Log/Trace link to display any corresponding error messages if the process fails.
Click MOE_CCA_UPL.log file to check the result of the uploaded data files
Result of MOE_CCA_UPL.log
Note:
Acad career should be CCA related only.
The data in each column should follow the below format. The column separator is semicolon ‘;’.
| Column Header | Example | Remarks |
|---|---|---|
| Subject | 001204/1/PRA | Retrieved from query ‘subject list’ – subject code |
| Subject Description | Basketball | Retrieved from query ‘subject list’ – subject description |
| Class Section | G01 | No more than 4 characters |
| Date | 07/05/2014 | Format: DD/MM/YYYY |
| Start Time | 09:00 | 24HR format HH:MM |
| End Time | 10:00 | 24HR format HH:MM |
| Mon | N | If the activity is scheduled on this day of week, specify as ‘Y’; Otherwise specify ‘N’. |
| Tue | N | If the activity is scheduled on this day of week, specify as ‘Y’; Otherwise specify ‘N’. |
| Wed | N | If the activity is scheduled on this day of week, specify as ‘Y’; Otherwise specify ‘N’. |
| Thu | N | If the activity is scheduled on this day of week, specify as ‘Y’; Otherwise specify ‘N’. |
| Fri | N | If the activity is scheduled on this day of week, specify as ‘Y’; Otherwise specify ‘N’. |
| Sat | Y | If the activity is scheduled on this day of week, specify as ‘Y’; Otherwise specify ‘N’. |
| Sun | N | If the activity is scheduled on this day of week, specify as ‘Y’; Otherwise specify ‘N’. |
| Facility ID | 3001_Basket01 | Retrieved from query ‘facility list’ – facility ID |
| Facility Description | Basketball Field | Retrieved from query ‘facility list’ – facility description |
| Instructor | 10078 | Retrieved from query ‘instructor list’ – instructor ID |
| Instructor Name | Mohd Yusof Hj Matrais | Retrieved from query ‘instructor list’ – facility name |
Note:
You can also Delete File to delete uploaded file
Note:↑ Back to Top
Any corresponding error messages will be displayed in this log file
Re-upload CCA Schedule
Roles Involved: School CCA head
Note:
This process should be run only when major change is needed in CCA schedule. Otherwise please execute the steps in ‘Update CCA schedule’.
Navigate to Main menu > Curriculum Management > Schedule of Classes > Upload CCA Schedule
Click on Add a New Value tab
Fill in Run Control ID field and click Add button . Format are as followed: (School Code)_Term (Term Code)_Rerun. E.g 1006_Term1510_Rerun.
Enter value on Institution, Acad Career, Campus, Term, Session
Specify Start Date & End Date for CCA re-upload schedule range
Click Upload File button and upload the file with .CSV format
Click View File button to view uploaded file
Click Delete File to delete uploaded file
Click Run button to run the process
A Message will pop out to prompt for user confirmation. Click OK button.
Click OK button at the process scheduler request page
Click Process Monitor
Click on Refresh button to refresh the process monitor status
Click on Details link when the Run status has changed to “Success” and Distribution Status = “Posted”
Click View Log/Trace link to display any corresponding error messages if the process fails.
Click MOE_CCA_UPL.log file to check the result of the uploaded data files
Result of MOE_CCA_UPL.log
Note:
Start Date should not be early than today date. End date should match with term End Date. There is also no need to tick on “Upload Full term data” Check Box
Verify Class Scheduling
Role Involved: School CCA Head
Navigate to Main menu > Curriculum Management > Schedule of Classes > Maintain Schedule of Classes
In the Find an Existing Value tab, enter the values in the Term, Subject Area and Campus fields.
Click on the Search button to obtain the result based on the values you entered.
Click on one class in search results.
In the Basic Data page, you can verify if the class section matches class code in the school timetable file.
In the Meetings tab, under the Meeting Pattern section, verify if Facility ID, Mtg Start, Mtg End and Start/End Date and instructors matches school timetable file.
Note:
You may click on ‘View All’ if there is more than one row under the same code in school timetable file.
You can see all meeting patterns.
Note:↑ Back to Top
For reupload case, all existing meeting patterns within reupload date range will be deleted, and replaced by the meeting patterns in the reupload file.
E.g.
Existing Class Dates: 05/01/2015, 14/01/2015, 21/01/2015
Re-uploaded Class Schedule Date Range: 10/01/2015 – 12/03/2015
Re-upload file dates: 16/01/2015
Expected Outcome:
- Falling between reupload date range 10/01/2015 and 12/03/2015, the existing class meeting patterns on 14/01/2015 and 21/01/2015 are deleted.
- Reupload meeting pattern on 16/01/2015 is inserted.
- Falling outside reupload date range, the existing meeting on 05/01/2015 still remains after reupload.
For the case where reupload class schedule with same or longer date range, all existing class meeting pattern will be replaced.
