Diff for "EnteringMarks"

Differences between revisions 8 and 9

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 8 as of 2020-06-16 08:46:48 → 
  Size: 1785
  Editor: MeichengWhale
  Comment:
+   ← Revision 9 as of 2020-06-17 20:57:59 → ⇥
  Size: 1789
  Editor: MeichengWhale
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 9:
-Line 11:
+Line 12:
-     ~- 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 21:
-Line 21:
+Line 23:
-     ~- 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 30:
-     ~- 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 36:
-Line 35:
+Line 38:
-   . `% cp file.csv $SMSDB/update_recs`
   . `% cp file.upd $SMSDB/update_recs`
+   . ~+`% cp file.csv $SMSDB/update_recs`+~
   . ~+`% cp file.upd $SMSDB/update_recs`+~
-Line 40:
+Line 44: