Diff for "EnteringMarks"

Differences between revisions 2 and 8 (spanning 6 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 2 as of 2018-07-21 11:55:33 → 
  Size: 1166
  Editor: MeichengWhale
  Comment:
+   ← Revision 8 as of 2020-06-16 08:46:48 → ⇥
  Size: 1785
  Editor: MeichengWhale
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 1:
- * Interactively
+#acl All:read

== Ways to enter marks into sms ==
 * '''Interactively'''
-Line 5:
+Line 8:
- * From a file - Two types of file are accepted (''.upd'' and ''.csv''). 

   * Format for ''.upd'' file, example:
+ * '''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. -~
-Line 16:
+Line 20:
-     ~- 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 19:
+Line 28:
+     ~- First line in the file must be comma separated sms field names. -~
-Line 24:
+Line 34:
-     ~- where the first line in the file must be comma separated sms field names. -~
-Line 26:
+Line 35:
-     . `% cp file.csv $SMSDB/update_recs`
     . `% cp file.upd $SMSDB/update_recs`
   * Tell sms to import the marks
     . interatively: select ''Student Menu'' &rarr; '''''Update Student'''''
     . commandline: smsupdate file.csv or smsupdate file.upd
+   . `% 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`+~