==============  THE UG DEPARTMENTAL DATABASE  ==============

 AVAILABLE PROGRAMS:  (in ~teach/bin)

 * most programs have on-line documentation,
   which is displayed by typing the program's name

 * try to use these programs from CANTOR,
   if you are on the network, type: ssh cantor

 * if a program is `not found', type its full pathname 
   e.g., ~teach/bin/Mail_students (then ask sysman 
   to change your configuration file)


---------------------------- GENERAL INFO
  Show_course_data           analysis of coursework/test marks 
  Students                   display basic students' parameters
  EM                         Essential Mathematics exam data

---------------------------- COLLECTIVE MAILERS
  Mail_students              mailer from any list of student Ids
  Warn_lazy_students         mailer from a mark file

---------------------------- FILE MANAGEMENT
  C                          convert blank to/from comma-separated
  Intersect                  intersection of two student files
  Remove                     remove records from a student file

---------------------------- OTHER
  Questionnaires             statistics of courses' questionnaires
  List                       attendance list from mark file 


=============================================== ALIASES ===========

To save typing, create your own aliases for the above program names. 
To do so, edit the file  ~/.cshrc, inserting lines such as

alias cmf     Check_mark_file
alias ms      Mail_students
alias s       Students
alias wls     Warn_lazy_students 

then type:  source ~/.cshrc  (or log out).

=============================================== ADDITIONAL INFO ===

------------------------------- FILE MANAGEMENT

> C: 

  All-purpose conversion of data files between comma 
  and blank-separated format.

> Intersect:
> Remove:

  Intersection and difference of two files, each containing
  student Id, specified in various formats. For instance, to
  create a mailing list, one may need to eliminate from a list 
  of students doing poorly in coursework, those who do well in tests.
 
------------------------------- COLLECTIVE MAILERS
> Mail_students:

  E-mail a group of students with optional Cc to advisors; 
  it also e-mail advisors about students. The student id. 
  is specified in a file in various formats.

> Warn_lazy_students:

  This program identifies the students in a course who have 
  missed the last coursework and a specified number of previous coursework.
  It then sends them an e-mail message, with optional Cc to advisors.

------------------------------- INFO
> Show_course_data:

  List of students who have failed to submit a specified
  number of courseworks.
 
  Sorted list of students with average performance
  below a given threshold. (If the threshold is set 
  to 100, the program lists all students in order 
  of increasing performance.)
 
  Coursework statistics: average mark and submission
  rate in each coursework, submission frequency, etc.

> Students:

  Basic information about individual or groups of students
  (number, surname, first name(s), code, advisor, year, e-mail).
  A group of students is determined by advisor, study programme,
  year, etc., or a combination of them.

------------------------------- OTHER
> Questionnaires:

  Statistics of course questionnaires, requiring questionnaires
  data to be stored in a file. Useful for large classes.