Diff for "EnteringMarks"

Differences between revisions 1 and 10 (spanning 9 versions)

Ways to enter marks into sms

Interactively
- Under Student Menu, choose Modify Student.
- If you have several marks to enter, a faster way is to use Bulk Entry.
From a file - Two types of file are accepted (.upd and .csv).
- Format for .upd file
  - Example 1: Using StudentID (primary key in sms) as the key First column is student ids, second column is mark field and third column is marks.
```
3123456|examA|18|
3121212|examA|10|
3123456|examB|15|
3121212|examB|8|
3123456|examC|6|
3121212|examC|3|
```
  - Example 2: Using other fields as the key First column is the key sms field name, second column is the key values.
```
ass2grp|123|ass2|20|
ass2grp|456|ass2|18|
```
- Format for .csv file, example:
  - First line in the file must be comma separated sms field names.
```
StudentID,examA,examB,examC
3123456,18,15,6
3121212,10,8,3
```
- The files must be copied to update_recs directory under $SMSDB, examples:
- % cp file.csv $SMSDB/update_recs
- % cp file.upd $SMSDB/update_recs
- Instruct sms to import the marks
  - interatively: select Student Menu → Update Student
  - commandline: smsupdate file.csv or smsupdate file.upd
From WebCMS3
- Fields must be Open to be editable by tutors in WebCMS3
- Setup/transfer marks from/to WebCMS3 with this command /home/webcms3/sms/sms_webcms3.sh
- Create a cronjob for the transfer every day with this command /home/give/stable/bin/gencronwebcms.sh

-  ⇤ ← Revision 1 as of 2018-07-21 11:51:32 → 
  Size: 1086
  Editor: MeichengWhale
  Comment:
+   ← Revision 10 as of 2020-06-17 20:59:16 → ⇥
  Size: 1787
  Editor: MeichengWhale
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 1:
+#acl All:read
-Line 2:
+Line 3:
- * Interactively
+== Ways to enter marks into sms ==
 * '''Interactively'''
-Line 6:
+Line 8:
- * From a file - Two types of file are accepted (''.upd'' and ''.csv'').
+ * '''From a file''' - Two types of file are accepted (''.upd'' and ''.csv'').
-Line 8:
+Line 10:
-   * Format for ''.upd'' file, example:
+   * Format for ''.upd'' file

     * Example 1: Using StudentID (primary key in sms) as the key
     First column is student ids, second column is mark field and third column is marks.
-Line 17:
+Line 22:
-     ~- where first column is studentID, second column is mark field and third column is mark. -~
+     * Example 2: Using other fields as the key
     First column is the key sms field name, second column is the key values.
     {{{
ass2grp|123|ass2|20|
ass2grp|456|ass2|18|
     }}}
-Line 20:
+Line 31:
+     First line in the file must be comma separated sms field names.
-Line 25:
+Line 37:
-     ~- where the first line in the file must be comma separated sms field names. -~
-Line 27:
+Line 39:
-     . `% cp file.csv $SMSDB/update_recs`
     . `% cp file.upd $SMSDB/update_recs`
   * Tell sms to import the marks, select ''Student Menu'' &rarr; '''''Update Student'''''.
+   . ~+`% cp file.csv $SMSDB/update_recs`+~
   . ~+`% cp file.upd $SMSDB/update_recs`+~

   * Instruct sms to import the marks
     * interatively: select ''Student Menu'' &rarr; '''''Update Student'''''
     * commandline: ~+`smsupdate file.csv`+~ or ~+`smsupdate file.upd`+~

 * '''From WebCMS3'''
   * Fields must be ''Open'' to be editable by tutors in WebCMS3
   * Setup/transfer marks from/to WebCMS3 with this command ~+`/home/webcms3/sms/sms_webcms3.sh`+~
   * Create a cronjob for the transfer every day with this command ~+`/home/give/stable/bin/gencronwebcms.sh`+~