Index: /main/kofacustom.unidel/trunk/src/kofacustom/unidel/interfaces.py
===================================================================
--- /main/kofacustom.unidel/trunk/src/kofacustom/unidel/interfaces.py	(revision 18312)
+++ /main/kofacustom.unidel/trunk/src/kofacustom/unidel/interfaces.py	(revision 18313)
@@ -21,7 +21,13 @@
 from zc.sourcefactory.basic import BasicSourceFactory
 from waeup.kofa.interfaces import (SimpleKofaVocabulary,
-    ISessionConfiguration, academic_sessions_vocab)
+    ISessionConfiguration, academic_sessions_vocab,
+    ContextualDictSourceFactoryBase)
 
 _ = MessageFactory = zope.i18nmessageid.MessageFactory('kofacustom.unidel')
+
+class EnableScoreEditingGroupSource(ContextualDictSourceFactoryBase):
+    """A source for filtering groups of students
+    """
+    DICT_NAME = 'ENABLE_SCORE_EDITING_GROUP_DICT'
 
 class ICustomSessionConfiguration(ISessionConfiguration):
@@ -190,4 +196,13 @@
         default = 0.0,
         required = False,
+        )
+
+    score_editing_enabled = schema.List(
+        title = _(u'Score editing enabled'),
+        value_type = schema.Choice(
+            source = EnableScoreEditingGroupSource(),
+            ),
+        required = False,
+        defaultFactory=list,
         )
 
Index: /main/kofacustom.unidel/trunk/src/kofacustom/unidel/locales/en/LC_MESSAGES/waeup.kofa.po
===================================================================
--- /main/kofacustom.unidel/trunk/src/kofacustom/unidel/locales/en/LC_MESSAGES/waeup.kofa.po	(revision 18312)
+++ /main/kofacustom.unidel/trunk/src/kofacustom/unidel/locales/en/LC_MESSAGES/waeup.kofa.po	(revision 18313)
@@ -28,2 +28,5 @@
 msgid "Custom Float 1 (not used)"
 msgstr "Minimum Graduation Credit Units"
+
+msgid "Remark"
+msgstr "Remark / Class of Degree (Grad.)"
Index: /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/batching.py
===================================================================
--- /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/batching.py	(revision 18312)
+++ /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/batching.py	(revision 18313)
@@ -68,5 +68,5 @@
             'level_session', 'outstanding', 'course_category',
             'title', 'credits', 'passmark', 'semester', 'ticket_session',
-            'unlock_score', 'previous'
+            'imported_ts', 'unlock_score', 'previous'
             ] + self.additional_fields
         return sorted(fields)
Index: /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/browser.py
===================================================================
--- /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/browser.py	(revision 18312)
+++ /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/browser.py	(revision 18313)
@@ -17,11 +17,16 @@
 ##
 import grok
+import csv
+import textwrap
+from cStringIO import StringIO
 from zope.i18n import translate
 from zope.schema.interfaces import ConstraintNotSatisfied
-from zope.component import getUtility
+from zope.component import getUtility, queryUtility
+from zope.catalog.interfaces import ICatalog
 from zope.security import checkPermission
 from zope.formlib.textwidgets import BytesDisplayWidget
 from hurry.workflow.interfaces import IWorkflowInfo
-from waeup.kofa.interfaces import REQUESTED, IExtFileStore, IKofaUtils
+from waeup.kofa.interfaces import (
+    REQUESTED, IExtFileStore, IKofaUtils, academic_sessions_vocab)
 from waeup.kofa.widgets.datewidget import FriendlyDatetimeDisplayWidget
 from waeup.kofa.browser.layout import KofaEditFormPage
@@ -30,15 +35,31 @@
     CLEARANCE, REQUESTED, RETURNING, CLEARED, REGISTERED, VALIDATED,
     GRADUATED, TRANSREQ, TRANSVAL, TRANSREL, FORBIDDEN_POSTGRAD_TRANS)
-from waeup.kofa.students.browser import (
-    StudyLevelEditFormPage, StudyLevelDisplayFormPage, StudyLevelManageFormPage,
-    StudentBasePDFFormPage, ExportPDFCourseRegistrationSlip,
-    CourseTicketDisplayFormPage, CourseTicketManageFormPage,
-    StudentTriggerTransitionFormPage,
-    ExportPDFAdmissionSlip,
-    ExportAttendanceSlip,
-    ExportPDFTranscriptSlip,
-    PaymentsManageFormPage, msave, emit_lock_message)
 from waeup.kofa.students.interfaces import IStudentsUtils, ICourseTicket, IStudentBase
 from waeup.kofa.students.workflow import FORBIDDEN_POSTGRAD_TRANS
+from waeup.kofa.students.browser import (
+    StartClearancePage,
+    StudentBasePDFFormPage,
+    CourseTicketAddFormPage,
+    StudyLevelDisplayFormPage,
+    StudyLevelManageFormPage,
+    StudyLevelEditFormPage,
+    ExportPDFTranscriptSlip,
+    ExportPDFAdmissionSlip,
+    StudentFilesUploadPage,
+    PaymentsManageFormPage,
+    CourseTicketDisplayFormPage,
+    CourseTicketManageFormPage,
+    EditScoresPage,
+    ExportPDFScoresSlip,
+    StudyCourseTranscriptPage,
+    DownloadScoresView,
+    StudentRequestPasswordPage,
+    StudyCourseManageFormPage,
+    UnregisterCoursesView,
+    addCourseTicket,
+    AddStudyLevelFormPage,
+    ExportPDFCourseRegistrationSlip,
+    ExportAttendanceSlip,
+    emit_lock_message,)
 from kofacustom.nigeria.students.browser import (
     NigeriaOnlinePaymentDisplayFormPage,
@@ -66,4 +87,36 @@
 from kofacustom.unidel.interfaces import MessageFactory as _
 
+
+def translated_values(view):
+    """Translate course ticket attribute values to be displayed on
+    studylevel pages.
+    """
+    lang = view.request.cookies.get('kofa.language')
+    for value in view.context.values():
+        value._p_activate()
+        value_dict = dict([i for i in value.__dict__.items()])
+        value_dict['url'] = view.url(value)
+        value_dict['removable_by_student'] = value.removable_by_student
+        value_dict['mandatory'] = translate(str(value.mandatory), 'zope',
+            target_language=lang)
+        value_dict['carry_over'] = translate(str(value.carry_over), 'zope',
+            target_language=lang)
+        value_dict['outstanding'] = translate(str(value.outstanding), 'zope',
+            target_language=lang)
+        value_dict['automatic'] = translate(str(value.automatic), 'zope',
+            target_language=lang)
+        value_dict['grade'] = value.grade
+        value_dict['weight'] = value.weight
+        value_dict['course_category'] = value.course_category
+        value_dict['total_score'] = value.total_score
+        semester_dict = getUtility(IKofaUtils).SEMESTER_DICT
+        value_dict['semester'] = semester_dict[
+            value.semester].replace('mester', 'm.')
+        # Unidel specific
+        value_dict['formatted_total_score'] = value.total_score
+        if getattr(value, 'imported_ts', None):
+            value_dict['formatted_total_score'] = "<strong>%s</strong>" % value.imported_ts
+        yield value_dict
+
 class CustomStudentBaseDisplayFormPage(NigeriaStudentBaseDisplayFormPage):
     """ Page to display student base data
@@ -235,4 +288,19 @@
     form_fields['payment_date'].custom_widget = FriendlyDatetimeDisplayWidget('le')
 
+class CustomStudyCourseManageFormPage(StudyCourseManageFormPage):
+    """ Page to edit the student study course data
+    """
+    grok.context(ICustomStudentStudyCourse)
+
+    @property
+    def form_fields(self):
+        if self.context.is_postgrad:
+            form_fields = grok.AutoFields(ICustomStudentStudyCourse).omit(
+                'previous_verdict')
+        else:
+            form_fields = grok.AutoFields(ICustomStudentStudyCourse)
+        form_fields['imported_cgpa'].for_display = True
+        return form_fields
+
 class CustomStudyLevelDisplayFormPage(StudyLevelDisplayFormPage):
     """ Page to display student study levels
@@ -242,5 +310,5 @@
 
     form_fields = grok.AutoFields(ICustomStudentStudyLevel).omit(
-        'level',)
+        'level','imported_gpa', 'imported_cgpa')
     form_fields[
         'validation_date'].custom_widget = FriendlyDatetimeDisplayWidget('le')
@@ -254,4 +322,6 @@
         'validation_date', 'validated_by', 'total_credits', 'gpa', 'level',
         'total_credits_s1', 'total_credits_s2')
+    form_fields['imported_gpa'].for_display = True
+    form_fields['imported_cgpa'].for_display = True
 
 class CustomExportPDFCourseRegistrationSlip(ExportPDFCourseRegistrationSlip):
@@ -267,5 +337,5 @@
         'password', 'suspended', 'phone', 'date_of_birth',
         'adm_code', 'sex', 'suspended_comment', 'current_level',
-        'flash_notice')
+        'flash_notice', 'imported_gpa', 'imported_cgpa',)
 
     def _signatures(self):
@@ -348,4 +418,5 @@
     form_fields['carry_over'].for_display = True
     form_fields['ticket_session'].for_display = True
+    form_fields['imported_ts'].for_display = True
 
 
@@ -519,2 +590,254 @@
             return
         return pdfstream
+
+class CustomEditScoresPage(EditScoresPage):
+    """Page that filters and lists students.
+    """
+    grok.template('editscorespage')
+
+    def _searchCatalog(self, session):
+        cat = queryUtility(ICatalog, name='coursetickets_catalog')
+        coursetickets = cat.searchResults(
+            session=(session, session),
+            code=(self.context.code, self.context.code)
+            )
+        try:
+            score_editing_enabled = grok.getSite()[
+                'configuration'][str(session)].score_editing_enabled
+        except KeyError:
+            return []
+        coursetickets_list = [courseticket for courseticket in coursetickets
+            if courseticket.student.current_mode in score_editing_enabled]
+        return coursetickets_list
+
+    def _extract_uploadfile(self, uploadfile):
+        """Get a mapping of student-ids to scores.
+
+        The mapping is constructed by reading contents from `uploadfile`.
+
+        We expect uploadfile to be a regular CSV file with columns
+        ``student_id``, ``score``, ``imported_ts``
+        and ``ca`` (other cols are ignored).
+        """
+        result = dict()
+        data = StringIO(uploadfile.read())  # ensure we have something seekable
+        reader = csv.DictReader(data)
+        for row in reader:
+            if not ('student_id' in row and 'score' in row and 'ca' in row and
+                'imported_ts' in row):
+                continue
+            result[row['student_id']] = (
+                row['score'], row['ca'], row['imported_ts'])
+        return result
+
+    def _update_scores(self, form):
+        ob_class = self.__implemented__.__name__.replace('waeup.kofa.', '')
+        error = ''
+        if 'UPDATE_FILE' in form:
+            if form['uploadfile']:
+                try:
+                    formvals = self._extract_uploadfile(form['uploadfile'])
+                except:
+                    self.flash(
+                        _('Uploaded file contains illegal data. Ignored'),
+                        type="danger")
+                    return False
+            else:
+                self.flash(
+                    _('No file provided.'), type="danger")
+                return False
+        else:
+            formvals = dict(zip(form['sids'], zip(
+                form['scores'], form['cas'], form['imported_ts'])))
+        for ticket in self.editable_tickets:
+            ticket_error = False
+            score = ticket.score
+            ca = ticket.ca
+            imported_ts = ticket.imported_ts
+            sid = ticket.student.student_id
+            if sid not in formvals:
+                continue
+            if formvals[sid][0] == '':
+                score = None
+            if formvals[sid][1] == '':
+                ca = None
+            if formvals[sid][2] == '':
+                imported_ts = None
+            try:
+                if formvals[sid][0]:
+                    score = int(formvals[sid][0])
+                if formvals[sid][1]:
+                    ca = int(formvals[sid][1])
+                if formvals[sid][2]:
+                    imported_ts = int(formvals[sid][2])
+            except ValueError:
+                error += '%s, ' % ticket.student.display_fullname
+                ticket_error = True
+            if score and ca and not ticket_error and score + ca > 100:
+                error += '%s, ' % ticket.student.display_fullname
+                ticket_error = True
+            if not ticket_error and ticket.score != score:
+                try:
+                    ticket.score = score
+                except TooBig:
+                    error += '%s, ' % ticket.student.display_fullname
+                    ticket_error = True
+                    pass
+                ticket.student.__parent__.logger.info(
+                    '%s - %s %s/%s score updated (%s)' %
+                    (ob_class, ticket.student.student_id,
+                     ticket.level, ticket.code, score))
+            if not ticket_error and ticket.ca != ca:
+                try:
+                    ticket.ca = ca
+                except TooBig:
+                    error += '%s, ' % ticket.student.display_fullname
+                    pass
+                ticket.student.__parent__.logger.info(
+                    '%s - %s %s/%s ca updated (%s)' %
+                    (ob_class, ticket.student.student_id,
+                     ticket.level, ticket.code, ca))
+            if not ticket_error and ticket.imported_ts != imported_ts:
+                try:
+                    ticket.imported_ts = imported_ts
+                except TooBig:
+                    error += '%s, ' % ticket.student.display_fullname
+                    pass
+                ticket.student.__parent__.logger.info(
+                    '%s - %s %s/%s imported_ts updated (%s)' %
+                    (ob_class, ticket.student.student_id,
+                     ticket.level, ticket.code, imported_ts))
+        if error:
+            self.flash(_('Error: Score(s), CA(s) and Imported TS(s) of %s have not be updated. '
+              % error.strip(', ')), type="danger")
+        return True
+
+class CustomExportPDFScoresSlip(ExportPDFScoresSlip):
+    """Deliver a PDF slip of course tickets for a lecturer.
+    """
+
+    note = u'\nUpgraded scores are with asterisks.'
+
+    def data(self, session):
+        #site = grok.getSite()
+        cat = queryUtility(ICatalog, name='coursetickets_catalog')
+        coursetickets = cat.searchResults(
+            session=(session, session),
+            code=(self.context.code, self.context.code)
+            )
+        # Apply filter
+        try:
+            score_editing_enabled = grok.getSite()[
+                'configuration'][str(session)].score_editing_enabled
+            if checkPermission('waeup.manageAcademics', self.context):
+                score_editing_enabled = True
+            coursetickets_filtered = [courseticket
+                for courseticket in coursetickets
+                if (checkPermission('waeup.manageAcademics', self.context)
+                    or (courseticket.student.current_mode in
+                        score_editing_enabled))
+                and courseticket.total_score is not None
+                and courseticket.__parent__.__parent__.is_current]
+        except KeyError:
+            coursetickets_filtered = coursetickets
+        # In AAUE only editable tickets can be printed (deactivated on 02/10/19)
+        #editable_tickets = [
+        #    ticket for ticket in coursetickets_filtered
+        #    if ticket.editable_by_lecturer]
+        header = [[_(''),
+                   _('Student Id'),
+                   _('Matric No.'),
+                   #_('Reg. No.'),
+                   #_('Fullname'),
+                   #_('Status'),
+                   #_('Course of\nStudies'),
+                   _('Department'),
+                   _('Level'),
+                   _(' CA  '),
+                   _('Exam\nScore'),
+                   _('Total '),
+                   _('Grade'),
+                   ],]
+        sorted_tickets = sorted(coursetickets_filtered, # editable_tickets,
+            key=lambda ticket: str(ticket.student.depcode)
+                               + str(ticket.student.faccode)
+                               + str(ticket.student.matric_number)
+                               )
+        no = 1
+        tickets = []
+        passed = 0
+        failed = 0
+        with_ca = False
+        grade_stats = {'A':0, 'B':0, 'C':0, 'D':0, 'E':0, 'F':0, }
+        for ticket in sorted_tickets:
+            if ticket.ca > 0:
+                with_ca = True
+            total = ticket.total_score
+            if getattr(ticket, 'imported_ts', None):
+                total = "**%s**" % ticket.imported_ts
+            grade = ticket._getGradeWeightFromScore[0]
+            if grade in grade_stats.keys():
+                grade_stats[grade] += 1
+            if grade in ('F', '-'):
+                failed += 1
+            else:
+                passed += 1
+            fullname = textwrap.fill(ticket.student.display_fullname, 30)
+            #deptitle = site['faculties'][ticket.student.faccode][
+            #    ticket.student.depcode].longtitle
+            row = [str(no),
+                  ticket.student.student_id,
+                  ticket.student.matric_number,
+                  #ticket.student.reg_number,
+                  #fullname,
+                  #ticket.student.translated_state,
+                  #ticket.student.certcode,
+                  str(ticket.student.faccode) + ' / ' + str(ticket.student.depcode),
+                  ticket.level,
+                  ticket.ca,
+                  ticket.score,
+                  total,
+                  grade,
+                  ]
+            tickets.append(row)
+            no += 1
+        total = passed + failed
+        passed_perc = 0
+        failed_perc = 0
+        if total:
+            passed_perc = round(100.0 * passed / total)
+            failed_perc = round(100.0 * failed / total)
+        dep = self.context.__parent__.__parent__.longtitle
+        fac = self.context.__parent__.__parent__.__parent__.longtitle
+        # remove CA column if not necessary
+        if not with_ca:
+            header = [[_(''),
+                       _('Student Id'),
+                       _('Matric No.'),
+                       #_('Reg. No.'),
+                       #_('Fullname'),
+                       #_('Status'),
+                       #_('Course of\nStudies'),
+                       _('Department'),
+                       _('Level'),
+                       #_(' CA  '),
+                       _('Exam\nScore'),
+                       _('Total '),
+                       _('Grade'),
+                       ],]
+            for ticket in tickets:
+                del(ticket[5])
+        return header + tickets, [
+            dep, fac, total, passed, passed_perc, failed, failed_perc, grade_stats]
+
+    def render(self):
+        session = grok.getSite()['configuration'].current_academic_session
+        lecturers = [i['user_title'] for i in self.getUsersWithLocalRoles()
+                     if i['local_role'] == 'waeup.local.Lecturer']
+        lecturers = sorted(lecturers)
+        lecturers =  ', '.join(lecturers)
+        students_utils = getUtility(IStudentsUtils)
+        # only orientation is different
+        return students_utils.renderPDFCourseticketsOverview(
+            self, 'coursetickets',
+            session, self.data(session), lecturers, '', 45, self.note)
Index: /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/browser_templates/editscorespage.pt
===================================================================
--- /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/browser_templates/editscorespage.pt	(revision 18313)
+++ /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/browser_templates/editscorespage.pt	(revision 18313)
@@ -0,0 +1,121 @@
+<p i18n:domain="waeup.kofa" i18n:translate="edit_scores_info">
+  This page helps you to update your students' course results.
+  You can either update Scores, CAs and Imported Total Scores by importing a csv file
+  (press 'Help' for further information) or by
+  changing Score, CA or Imported Total Score values in the table below.
+  Only course results of students in current session
+  <span  i18n:name="current_academic_session"
+         tal:replace="view/session_title"></span>
+  can be modified.
+</p>
+
+<form  i18n:domain="waeup.kofa"  method="POST" enctype="multipart/form-data">
+  <br />
+  <div class="input-group">
+    <div class="input-group-btn">
+      <div class="btn btn-default btn-file" i18n:translate="">
+        Select csv file&hellip;
+        <input type="file" name="uploadfile:file" i18n:name="input_file"/>
+      </div>
+    </div>
+    <input type="text" class="form-control" readonly>
+    <div class="input-group-btn">
+      <input type="submit" name="UPDATE_FILE" i18n:translate=""
+             value="Update editable scores from csv file"
+             class="btn btn-primary" />
+      <button class="btn btn-warning" data-toggle="modal"
+              data-target="#myModal" i18n:translate="">
+        Help
+      </button>
+    </div>
+  </div>
+
+  <!-- Modal -->
+  <div class="modal fade" id="myModal" tabindex="-1" role="dialog"
+       aria-labelledby="myModalLabel" aria-hidden="true">
+    <div class="modal-dialog">
+      <div class="modal-content">
+        <div class="modal-header">
+          <button type="button" class="close" data-dismiss="modal"
+                  aria-hidden="true">&times;</button>
+          <h4 class="modal-title" id="myModalLabel" i18n:translate="">
+            Step-by-step instructions
+          </h4>
+        </div>
+        <div class="modal-body" i18n:translate="lecturer_help">
+          <ol>
+            <li>Download csv file.</li>
+            <li>Open csv file in a text editor or in a spreadsheet
+                programme (Excel or Calc).</li>
+            <li>Edit course results only. Do not modify other entries.
+                Do not remove or add columns. Do not add rows.</li>
+            <li>Save file in same format (csv).
+                Do not switch to any other format (xls, xlsx or ods).</li>
+            <li>Select same file for upload and press the blue 'Update ...'
+                button.</li>
+            <li>The values in the table will be updated. Spot-check if
+                the values in the table correspond with the values in
+                your file.</li>
+            <li>Ready</li>
+          </ol>
+          <strong>Note:</strong>
+          Only course results of students which are in
+          academic session
+          <span  i18n:name="current_academic_session"
+            tal:replace="view/session_title"></span>
+          can be modified. Additional data will just be ignored.
+        </div>
+      </div><!-- /.modal-content -->
+    </div><!-- /.modal-dialog -->
+  </div><!-- /.modal -->
+
+  <br /><br />
+
+  <table class="kofa-data-table dataTable">
+    <thead>
+    <tr>
+      <th i18n:translate="">Matric No.</th>
+      <th i18n:translate="">Reg. No.</th>
+      <th i18n:translate="">Fullname</th>
+      <th i18n:translate="">Status</th>
+      <th i18n:translate="">Course of Studies</th>
+      <th i18n:translate="">Level</th>
+      <th i18n:translate="">Score</th>
+      <th i18n:translate="">CA</th>
+      <th i18n:translate="">Imp. Total Score</th>
+    </tr>
+    </thead>
+    <tbody>
+    <tr tal:repeat="ticket view/editable_tickets">
+      <td tal:content="ticket/student/matric_number">MATRIC_NUMBER</td>
+      <td tal:content="ticket/student/reg_number">REG_NUMBER</td>
+      <td tal:content="ticket/student/display_fullname">FULLNAME</td>
+      <td tal:content="ticket/student/translated_state">STATE</td>
+      <td tal:content="ticket/student/certcode">CERTCODE</td>
+      <td tal:content="ticket/level">LEVEL</td>
+      <td style="width: 65px;">
+          <input type="text" name="scores:list" class="form-control"
+                 tal:attributes="value ticket/score" />
+          <input type="hidden" name="sids:list"
+                 tal:attributes="value ticket/student/student_id" />
+      </td>
+      <td style="width: 65px;">
+          <input type="text" name="cas:list" class="form-control"
+                 tal:attributes="value ticket/ca" />
+      </td>
+      <td style="width: 65px;">
+          <input type="text" name="imported_ts:list" class="form-control"
+                 tal:attributes="value ticket/imported_ts" />
+      </td>
+    </tr>
+    </tbody>
+  </table>
+
+  <input type="submit" name="UPDATE_TABLE" i18n:translate=""
+         value="Update scores from table" class="btn btn-primary"
+         />
+
+  <input type="submit" name="VALIDATE_RESULTS" i18n:translate=""
+         value="Validate course results" class="btn btn-primary"
+         />
+</form>
Index: /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/export.py
===================================================================
--- /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/export.py	(revision 18312)
+++ /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/export.py	(revision 18313)
@@ -98,7 +98,9 @@
     """
 
-    fields = ('matric_number', 'student_id', 'display_fullname',
-              'faccode', 'certcode', 'state',
-              'level', 'code', 'level_session', 'score')
+    fields = ('matric_number', 'student_id','display_fullname',
+              'depcode', 'faccode', 'certcode', 'state',
+              'level', 'code', 'level_session', 'ca', 'score',
+              'total_score', 'grade', 'imported_ts')
+
 
     def mangle_value(self, value, name, context=None):
Index: /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/interfaces.py
===================================================================
--- /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/interfaces.py	(revision 18312)
+++ /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/interfaces.py	(revision 18313)
@@ -116,4 +116,9 @@
     """
 
+    imported_cgpa = schema.Float(
+        title = _(u'Imported Cumulative GPA'),
+        required = False,
+        )
+
 class ICustomStudentStudyLevel(INigeriaStudentStudyLevel):
     """A container for course tickets.
@@ -135,4 +140,15 @@
         required = False,
         )
+
+    imported_gpa = schema.Float(
+        title = _(u'Imported Level GPA'),
+        required = False,
+        )
+
+    imported_cgpa = schema.Float(
+        title = _(u'Imported Cumulative GPA'),
+        required = False,
+        )
+
 
 class ICustomStudentOnlinePayment(ICustomOnlinePayment):
@@ -178,4 +194,12 @@
         )
 
+    imported_ts = schema.Int(
+        title = _(u'Imported Total Score'),
+        default = None,
+        required = False,
+        missing_value = None,
+        max = 100,
+        )
+
 ICustomCourseTicket['score'].order = INigeriaCourseTicket['score'].order
 ICustomCourseTicket['ca'].order = ICustomCourseTicket['score'].order
Index: /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/reports/level_report.py
===================================================================
--- /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/reports/level_report.py	(revision 18312)
+++ /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/reports/level_report.py	(revision 18313)
@@ -62,5 +62,5 @@
             TTR('Cum. Credits Required'),
             TTR('CGPA'),
-            TTR('Remark'))
+            TTR('Remark / Class of Degree (Grad.)'))
     table = [col_names]
     sn = 1
@@ -85,4 +85,6 @@
     """
     """
+
+    title = 'Summary of Results'
 
     def _get_students(self, faccode, depcode, certcode, session, level):
@@ -217,5 +219,5 @@
     """
 
-    title = 'Level Report (Graduating Students only)'
+    title = 'Summary of Results (Graduating Students only)'
 
     @property
Index: /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/tests/test_browser.py
===================================================================
--- /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/tests/test_browser.py	(revision 18312)
+++ /main/kofacustom.unidel/trunk/src/kofacustom/unidel/students/tests/test_browser.py	(revision 18313)
@@ -19,4 +19,5 @@
 import shutil
 import tempfile
+import grok
 from StringIO import StringIO
 from hurry.workflow.interfaces import IWorkflowState, IWorkflowInfo
@@ -24,7 +25,8 @@
 from zope.securitypolicy.interfaces import IPrincipalRoleManager
 from zope.component.hooks import setSite, clearSite
-from zope.component import getUtility, createObject
+from zope.component import getUtility, createObject, queryUtility
 from zope.interface import verify
 from zope.event import notify
+from zope.catalog.interfaces import ICatalog
 from waeup.kofa.authentication import LocalRoleSetEvent
 from waeup.kofa.app import University
@@ -40,4 +42,8 @@
 from kofacustom.unidel.testing import FunctionalLayer
 
+UPLOAD_CSV_TEMPLATE = (
+    'matric_number,student_id,display_fullname,level,code,level_session,'
+    'score,ca,imported_ts\r\n'
+    '234,D1000000,Anna Tester,100,COURSE1,2004,%s,%s,%s\r\n')
 
 class StudentsContainerUITests(StudentsFullSetup):
@@ -122,2 +128,180 @@
         open(path, 'wb').write(self.browser.contents)
         print "Sample PDF attendance.pdf written to %s" % path
+
+class OfficerUITests(StudentsFullSetup):
+    # Tests for Student class views and pages
+
+    layer = FunctionalLayer
+
+    def setUp(self):
+        super(OfficerUITests, self).setUp()
+        self.app['faculties']['fac1']['dep1'].certificates[
+            'CERT1']['COURSE1_100'].course_category = 'C'
+
+    def login_as_lecturer(self):
+        self.app['users'].addUser('mrslecturer', 'mrslecturerSecret1')
+        self.app['users']['mrslecturer'].email = 'mrslecturer@foo.ng'
+        self.app['users']['mrslecturer'].title = u'Mercedes Benz'
+        # Add course ticket
+        studylevel = createObject(u'waeup.StudentStudyLevel')
+        studylevel.level = 100
+        studylevel.level_session = 2004
+        self.student['studycourse'].addStudentStudyLevel(
+            self.certificate, studylevel)
+        # Assign local Lecturer role for a certificate.
+        course = self.app['faculties']['fac1']['dep1'].courses['COURSE1']
+        prmlocal = IPrincipalRoleManager(course)
+        prmlocal.assignRoleToPrincipal('waeup.local.Lecturer', 'mrslecturer')
+        notify(LocalRoleSetEvent(
+            course, 'waeup.local.Lecturer', 'mrslecturer', granted=True))
+        # Login as lecturer.
+        self.browser.open(self.login_path)
+        self.browser.getControl(name="form.login").value = 'mrslecturer'
+        self.browser.getControl(
+            name="form.password").value = 'mrslecturerSecret1'
+        self.browser.getControl("Login").click()
+        # Store reused urls/paths
+        self.course_url = (
+            'http://localhost/app/faculties/fac1/dep1/courses/COURSE1')
+        self.edit_scores_url = '%s/edit_scores' % self.course_url
+        self.edit_prev_scores_url = '%s/edit_prev_scores' % self.course_url
+        # Set standard parameters
+        self.app['configuration'].current_academic_session = 2004
+        self.app['faculties']['fac1']['dep1'].score_editing_disabled = False
+        IWorkflowState(self.student).setState(VALIDATED)
+
+
+    def test_gpa_calculation(self):
+        studylevel = createObject(u'waeup.StudentStudyLevel')
+        studylevel.level = 100
+        studylevel.level_session = 2005
+        self.student['studycourse'].entry_mode = 'ug_ft'
+        self.student['studycourse'].addStudentStudyLevel(
+            self.certificate, studylevel)
+        # First course has been added automatically.
+        # Set score.
+        studylevel['COURSE1'].score = 35
+        studylevel['COURSE1'].ca = 20
+        # GPA is 3.0.
+        self.assertEqual(studylevel.gpa_params[0], 3.0)
+        courseticket = createObject('waeup.CourseTicket')
+        courseticket.code = 'ANYCODE'
+        courseticket.title = u'Any TITLE'
+        courseticket.credits = 13
+        courseticket.score = 44
+        courseticket.ca = 22
+        courseticket.semester = 1
+        courseticket.dcode = u'ANYDCODE'
+        courseticket.fcode = u'ANYFCODE'
+        studylevel['COURSE2'] = courseticket
+        # total credits
+        self.assertEqual(self.student['studycourse']['100'].gpa_params[1], 23)
+        # weigheted credits = 3 * 10 + 4 * 13
+        self.assertEqual(self.student['studycourse']['100'].gpa_params[2], 82.0)
+        # sgpa = 82 / 23
+        self.assertEqual(
+            self.student['studycourse']['100'].gpa_params[0], 3.5652173913043477)
+        # imported gpa values override calculated values
+        studylevel.imported_gpa = 4.3
+        studylevel.imported_cgpa = 5.4
+        self.assertEqual(self.student['studycourse']['100'].gpa_params[0], 4.3)
+        self.assertEqual(
+            self.student['studycourse']['100'].cumulative_params[0], 5.4)
+        self.assertEqual(self.student['studycourse']['100'].gpa, '4.30')
+        self.student['studycourse'].imported_cgpa = 6.6
+        self.assertEqual(
+            self.student['studycourse'].getTranscriptData()[1], 6.6)
+        return
+
+    def test_scores_csv_upload_available(self):
+        # lecturers can upload a CSV file to set values.
+        self.login_as_lecturer()
+        # set value to change from
+        self.student['studycourse']['100']['COURSE1'].score = 55
+        self.app['configuration']['2004'].score_editing_enabled = ['ug_ft']
+        self.browser.open(self.edit_scores_url)
+        upload_ctrl = self.browser.getControl(name='uploadfile:file')
+        upload_file = StringIO(UPLOAD_CSV_TEMPLATE % ('65','52','77'))
+        upload_ctrl.add_file(upload_file, 'text/csv', 'myscores.csv')
+        self.browser.getControl("Update editable scores from").click()
+        self.assertTrue('Anna Tester have not be updated' in self.browser.contents)
+        # values have not been changed
+        self.assertEqual(
+            self.student['studycourse']['100']['COURSE1'].score, 55)
+        self.assertEqual(
+            self.student['studycourse']['100']['COURSE1'].ca, None)
+        self.assertEqual(
+            self.student['studycourse']['100']['COURSE1'].imported_ts, None)
+        self.browser.open(self.edit_scores_url)
+        upload_ctrl = self.browser.getControl(name='uploadfile:file')
+        upload_file = StringIO(UPLOAD_CSV_TEMPLATE % ('65','22','77'))
+        upload_ctrl.add_file(upload_file, 'text/csv', 'myscores.csv')
+        self.browser.getControl("Update editable scores from").click()
+        # values changed
+        self.assertEqual(
+            self.student['studycourse']['100']['COURSE1'].score, 65)
+        self.assertEqual(
+            self.student['studycourse']['100']['COURSE1'].ca, 22)
+        self.assertEqual(
+            self.student['studycourse']['100']['COURSE1'].imported_ts, 77)
+
+    def test_lecturers_can_download_course_tickets(self):
+        # A course ticket slip can be downloaded
+        self.login_as_lecturer()
+        self.course.title = (u'Lorem ipsum dolor sit amet, consectetur '
+                            u'adipisici elit, sed eiusmod tempor incidunt')
+        self.student['studycourse']['100']['COURSE1'].score = 55
+        self.student['studycourse']['100']['COURSE1'].ca = 11
+        self.student.matric_number = u'CMS/FBM/NSG/16/28838'
+        self.app['configuration']['2004'].score_editing_enabled = ['ug_ft']
+        pdf_url = '%s/coursetickets.pdf' % self.course_url
+        self.browser.open(pdf_url)
+        self.assertEqual(self.browser.headers['Status'], '200 Ok')
+        self.assertEqual(
+            self.browser.headers['Content-Type'], 'application/pdf')
+        path = os.path.join(samples_dir(), 'coursetickets.pdf')
+        open(path, 'wb').write(self.browser.contents)
+        print "Sample PDF coursetickets.pdf written to %s" % path
+        # The CA column is not shown if CA is not used
+        self.student['studycourse']['100']['COURSE1'].ca = 0
+        self.browser.open(pdf_url)
+        path = os.path.join(samples_dir(), 'coursetickets_wo_ca.pdf')
+        open(path, 'wb').write(self.browser.contents)
+        print "Sample PDF coursetickets_wo_ca.pdf written to %s" % path
+
+    def test_lecturers_do_only_see_selected_students(self):
+        # A course ticket slip can be downloaded
+        self.login_as_lecturer()
+        self.student['studycourse']['100']['COURSE1'].score = 55
+        self.student['studycourse']['100']['COURSE1'].ca = 11
+        self.browser.open(self.edit_scores_url)
+        self.assertTrue('No student found' in self.browser.contents)
+        pdf_url = '%s/coursetickets.pdf' % self.course_url
+        self.browser.open(pdf_url)
+        self.assertEqual(self.browser.headers['Status'], '200 Ok')
+        self.assertEqual(
+            self.browser.headers['Content-Type'], 'application/pdf')
+        path = os.path.join(samples_dir(), 'coursetickets_filtered.pdf')
+        open(path, 'wb').write(self.browser.contents)
+        print "Sample PDF coursetickets_filtered.pdf written to %s" % path
+        self.app['configuration']['2004'].score_editing_enabled = ['ug_ft']
+        self.browser.open(self.edit_scores_url)
+        self.assertFalse('No student found' in self.browser.contents)
+        self.assertTrue('Anna Tester' in self.browser.contents)
+
+    def test_lecturers_can_download_attendance_sheet(self):
+        # A course ticket slip can be downloaded
+        self.course.title = (u'Lorem ipsum     dolor sit amet, consectetur     adipisici, '
+                             u'sed         eiusmod tempor    incidunt ut  labore et dolore')
+        self.student.firstname = u'Emmanuella Woyengifigha Mercy Onosemudiana'
+        self.student.lastname = u'OYAKEMIEGBEGHA'
+        self.student.matric_number = u'CMS/FBM/NSG/17/38186'
+        self.login_as_lecturer()
+        pdf_url = '%s/attendance.pdf' % self.course_url
+        self.browser.open(pdf_url)
+        self.assertEqual(self.browser.headers['Status'], '200 Ok')
+        self.assertEqual(
+            self.browser.headers['Content-Type'], 'application/pdf')
+        path = os.path.join(samples_dir(), 'attendance.pdf')
+        open(path, 'wb').write(self.browser.contents)
+        print "Sample PDF attendance.pdf written to %s" % path
Index: /main/kofacustom.unidel/trunk/src/kofacustom/unidel/utils/utils.py
===================================================================
--- /main/kofacustom.unidel/trunk/src/kofacustom/unidel/utils/utils.py	(revision 18312)
+++ /main/kofacustom.unidel/trunk/src/kofacustom/unidel/utils/utils.py	(revision 18313)
@@ -125,4 +125,6 @@
         }
 
+    ENABLE_SCORE_EDITING_GROUP_DICT = STUDY_MODES_DICT
+
     APP_CATS_DICT = {
         'basic': 'UAS, PUTME, PCE, PRENCE',
