Diff for "EnteringMarks"

Differences between revisions 7 and 10 (spanning 3 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 7 as of 2020-06-16 08:44:36 → 
  Size: 1785
  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 9:
-Line 10:
+Line 11:
-Line 11:
+Line 13:
-     ~- first column is student ids, second column is mark field and third column is marks. -~
+     First column is student ids, second column is mark field and third column is marks.
-Line 20:
+Line 22:
-Line 21:
+Line 24:
-     ~- First column is the key sms field name, second column is the key values. -~
+     First column is the key sms field name, second column is the key values.
-Line 28:
+Line 31:
-     ~- First line in the file must be comma separated sms field names. -~
+     First line in the file must be comma separated sms field names.
-Line 34:
+Line 37:
-Line 35:
+Line 39:
-     . `% 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`+~