CSS Project Zambia Consolidating support

raspgiantsneckΔιακομιστές

9 Δεκ 2013 (πριν από 3 χρόνια και 8 μήνες)

205 εμφανίσεις

1


CSS Project Zambia


Consolidating support

Author
:


Monique in het Veld

(ICT Specialist, University of Nijmegen)

Date last modified:


13
-
0
6
-
201
2




MILESTONE

3.4
.



Overview of Requirements for the SIS

at UNZA and CBU

Final package of

functionality for t
he Opus Student Administration System


2


CONTENT


CSS Project Zambia


Consolidating support
................................
................................
...................

1

MILESTONE 3.4.

................................
................................
................................
...............................

1

3.4.1. Extensions to the Opus College kernel

................................
................................
..................

3

Security

................................
................................
................................
................................
....

3

Layout

................................
................................
................................
................................
......

3

Curriculum

................................
................................
................................
...............................

3

Students & Staffmembers

................................
................................
................................
.......

4

Studyplans

................................
................................
................................
...............................

4

Results

................................
................................
................................
................................
.....

5

Continued Registration

................................
................................
................................
............

6

Roles / privileges

................................
................................
................................
.....................

8

Admin functions

................................
................................
................................
......................

9

Technical changes and issues

................................
................................
................................

10

Configuration & General & Testing

................................
................................
.......................

11

3.4.2. Extensions to Mozambique module

................................
................................
....................

11

3.4.3. Extensions to Zambia Module

................................
................................
.............................

12

3
.4.4. Extensions to UNZA Module

................................
................................
................................

12

Security

................................
................................
................................
................................
..

12

Financial module

................................
................................
................................
...................

12

Interfaces/Exports

................................
................................
................................
.................

13

Configuration & General & Testing

................................
................................
.......................

14

3.4.5. Extensions to CBU Module

................................
................................
................................
..

14

Security

................................
................................
................................
................................
..

14

Interfaces

................................
................................
................................
...............................

14

3.4.6. Extensions to Admission Module

................................
................................
........................

14

3.4.7. Extensions to Fee Module

................................
................................
................................
...

15

3.4.8. Extensions for Scholarship Module

................................
................................
.....................

15

3.4.9. Extens
ions to Report Module

................................
................................
..............................

16

3.4.10. Extensions to Accommodation Module

................................
................................
............

20




3


3.4.1. Extensions to the Opus College kernel


Security



b. Configure debug
-
logging l
og4j
-

continued


Now when log is set to d
ebug

in

log4j (
opus
.log)
, the

user / pw
can be found in
plain
text in log
. The password is anyway transmitted in plain text, which is insecure. This
should be altered.

See also:
http://www.informit.com/articles/a
rticle.aspx?p=24253&seqNum=5


c. hashed storage results in database

preven
t direct access to the database


d. Code
-
check with OpenFortify


Fortify is a company that is specialized in checking code for security
-
issues. For open
source projects they have th
e option of OpenFortify, which is free.

A consultation of Fortify may be part of the project.


Layout



b
. Extend footer with Zambia

Now only RU and MEC mentioned.


Curriculum

a.
Do not show discipline groups for bachelor studygradetypes

D
iscipline groups
only belong to masters / postgraduates


b
. Curriculum transition preview: make "select all" for each group
(sgts, subjects, blocks)


Make a "select all" check box on top of each of the groups, so that e.g. all subjects
can be independently selected from al
l other items. Currently, there is one "select
all" button that selects everything at once.


4


c
. Edit study
-
> add subject block: no subject blocks available


S
tudygradetypesubjectblock.view: no subject blocks can be selected, subjectblock
combo always emp
ty.


d
. Subject blocks overview: search field does not work

Search field value is ignored.
-
> Should filter code / name.


e
. Error
-
check on too few secondary school subjects for bachelor
studygradetype

Check if there are enough secondary school subjects fi
lled in at creation of a
bachelor studygradetype (minimum 5, init parameter). Otherwise: show error.


f
.
Remove subjects from studygradetype: allow if only repeating
subjects of subject blocks

Allow to delete subjectstudygradetype records even if there are

studyplandetails
pointing to the subject in the case when the subject is part of a subject block and
the students failed the subject and have to repeat it.


g.
Duplicate studyplancardinaltimeunit when changing nr of cardinal
time units

In study grade t
ype edit screen, it can happen that a studyplancardinaltimeunit is
created for the same ctunr that already exists. If e.g. only the 2nd ctunr exists, but
not the first one, then after changing the number of ctus, no
studyplancardinaltimeunit is created

for the first, but two studyplancardinaltimeunits
exist for the 2nd.

This situation should probably not ever happen, but we had some students with only
2nd studyplancardinaltimeunit.


Students & Staffmembers

a.
Finetune
unique
student
identification


Che
ck the uniqueness of a student depends on NUIC, birthdate, name. These are (or
should be) the discriminatory attributes.


Studyplans

a. studyplancardinaltimeunit.view doesn't show studyplandetails
from other academic years

When changing the study / grade t
ype in studyplancardinaltimeunit.view to another
academic year, then study plan details are not visible anymore (see screenshots
before and after changing study / grade type)


5


The Total number of Subjects is still correctly displayed, but the studyplandeta
ils are
not listed.


Instead of not displaying them, there could be a warning that the academic year of
the studyplan details do not correspond with the academic year of the study / grade
type.

b. Fast student input: Only pre
-
select mandatory subject (bloc
ks) for
selected time unit


Only pre
-
select subject (blocks) if they are in the same time unit as the study grade
type selected in the filters. Currently, both evening and daytime subjects and blocks
are pre
-
selected, which easily results in too many stud
yplandetails.

c. Unsuccessful delete of study plan does not show error message

In the student
-
subscription.view, when trying to delete a study plan, and it does not
succeed, there is no error message shown, why the intended deletion did not work.

Maybe an
effect of the separation of student.jsp into the 5 different jsps.


e.
studyplan.view: maxNumberOfCardinalTimeUnits = 0 instead of
init parameter

When maxNumberOfCardinalTimeUnits of studygrade type is 0, then after creating a
studyplanCTU, the applicatio
n init parameter should be used. There is a bug that
prevents that.


f.
studyplancardinaltimeunit.view: studyplandetails not visible from
other academic years

If studyplandetails exist that are from a different academic year than the
studyplancardinaltime
unit, then they are not shown.

This situation of having studyplandetails in a different academic year should
normally not happen, but in case it happens, they need to be visible, in order to
resolve the problematic situation.

In our case
(UCM, Markus)
sh
own in the screenshots, two studyplandetails are
present, one in the same academic year than the studyplancardinaltimeunit (2009),
one in another academic year (2010). The one from 2009 is shown in
studyplancardinaltimeunit.view, the other one not. But
then, results were entered
for the subjects from 2010 (see studyplancardinaltimeunitresults.view). So this is
quite a mess.


Results


a
. button 'generate all' course results, examination results

+ increase
/ decrease results at once

Show a button to gene
rate all course results (and examination results) in the subject
results overview and lower levels.


6


Moreover: the ability to change all course results with a positive or negative number
at once, e.g.:

All students score too bad, therefore the senate makes

a decision to increase all
results with 10 (percentage). This number can be filled in in the screen and
effectuated.


c
. studyplanresult.view: consumes too much time and memory

Memory:


javax.servlet.ServletException: java.lang.OutOfMemoryError: Java heap

space


d.
Invalidate subjectresults while carrying all subjects to next CTU

When carrying="A" (repeating all subjects in the next CTU, even the passed ones),
then the passed subject results should be in some form invalidated.


Because otherwise there wi
ll be two different subject results for the same subject
that are both passed. Then, it is not clear which subject result is the one to be taken
when e.g. creating the student certificate at the end of the study program.


In the subject results for the
first CTU set the "active" flag to "N", so that the
subject results will not be used anymore for calculations.


Continued Registration


b
. Cardinal time
-
unit calculation of progress status


The exam
-
calculations should be extended with an end
-
grade (= gra
duation) and a
progress status for all subject
-
results within one cardinal time
-
unit with following
parameters:



study
-
gradetype



student
-
type



cardinal time
-
unit


To be able to do this there are generic rules concerning passing / not passing a
cardinal time
-
unit. The number of subjects within a cardinal time can vary depending
on the measured cardinal time
-
unit and the study
-
gradetype. Therefore has to be an
attribute ‘maxnumberoffailedsubjects per cardinaltimeunit’ on the level of
studygradetype. These stat
uses are called ‘progressStatus’, a new domain table:




Progression / Clear pass: If all subjects within the cardinal time
-
unit are
succeeded. Student is automatically forwarded to the next cardinal time
-
unit
of the current study
-
gradetype.



Compensatory pas
s (P) / Proceed and repeat: If less than the maxnumber of
failed subjects within the cardinal time
-
unit for full
-
time are not succeeded
(depending on student
-
type) and the lowest grade of the other subjects
within the cardinal time
-
unit is not lower than D
+ and the student meets the
following:

o

has not failed more than less than the maxnumber of failed in a
cardinal time
-
unit

7


o

has taken more than half of the number of subjects in this cardinal
time
-
unit

o

has obtained an average grade of C+ or higher for the p
assed subjects
in this cardinal time
-
unit

Student is automatically forwarded to the next cardinal time
-
unit of the
current study
-
gradetype, including the less than max. failed subjects. Note: a
possible overload of the maxnumber of repeated subjects has to

be manually
approved by dean of the school.



To Part
-
time: If only one more than the maxnumber of failed subjects within
the cardinal time
-
unit are not succeeded and the lowest grade is not lower
than D+ or if a full
-
time student fails one or more repeat s
ubjects. Student
takes the failed subjects automatically in the next cardinal time
-
unit.



At Part
-
time: If not all (repeated) subjects within the cardinal time
-
unit at
part
-
time are succeeded and the lowest grade is not lower than D+. Student
takes the fai
led subjects again automatically in the next cardinal time
-
unit in
part
-
time.



To Full
-
time: if all (repeated) subjects within the cardinal time
-
unit at part
-
time are succeeded and the student wishes to continue to full
-
time. Student is
automatically forwar
ded to the next cardinal time
-
unit of the current study
-

gradetype for full
-
time.



Repeat: If only one more than the maxnumber of failed subjects within the
cardinal time
-
unit are not succeeded and the lowest grade is not lower than
D+ and the student is in

the final cardinal time
-
unit of his study
-
gradetype.
Student is automatically forwarded to the current cardinal time
-
unit of the
current study
-

gradetype for only the failed subject(s).



Exclude study
-
gradetype: If only one more than the maxnumber of faile
d
subjects within the cardinal time
-
unit are not succeeded and the lowest grade
is lower than D. Student is blocked only from the study
-
gradetype of this
school. Other study
-
gradetypes of this school and other schools may still be
an option.



Exclude school
: If more than one of the maxnumber of failed subjects within
the cardinal time
-
unit are not succeeded and the lowest grade is lower than
D. Student is blocked from all study
-

gradetypes of this school.



Withdrawn with permission



Graduate: if all subjects f
rom the study
-

gradetype are succeeded. An end
-
grade for the study
-

gradetype will be calculated.


Note: when a student fails in the last cardinal time
-
unit of a study
-
gradetype on a
level that allows Repeat or Proceed and repeat, he / she is transferred t
o the next
(non
-
existing) time
-
unit for this study
-
gradetype as part
-
time student to redo the
failed subjects.


Based on the graduation comment that this calculation delivers the graduation grade
is made up. (See paragraph ‘Subject / Graduation / Degree ca
lculation’ for the
correct matrix)


Note: The number of allowed failed subjects per cardinal time
-
unit should be
configurable per study
-
gradetype, since the cardinal time
-
unit can differ amongst
study
-
gradetypes, universities and countries.


Note: the deci
sion to give a student a certain graduation comment / grade for a
cardinal time
-
unit must have the option to be manually overridden by a specific role
(Academic Office / Dean / Asst. Dean).


8


Note: the prerequisites for access to a certain subject are not p
art of this logic.


Note: see also: document from the CBU
-
calendar
-

‘Rules of progression’.



Roles / privileges


b
. Finetune audit privileges

Views on:


Fees:


Student’s payment information


Payment receipts per school and study
-
gradetype


The Internal Aud
it
of
UNZA

would like to have summaries on a variety of data:

-

student per semester, year, programme

-

history trail of changes in sensitive information:

o

student information

o

student results

o

fees

o

scholarships

Also the IA needs to have archive information on th
is same sensitive data (
see:
audit
trail).

Furthermore the IA would like to have views on
the fees module:

-

the banking / accounting information

-

the billing:

-

reports per student, per study

programme, per semester, etc.

-

reports on the installments a stud
ent has done for the tuition fees

-

reports on sponsor information


A wish of IA is to have access to SAGE (accounting system). At the moment there is
no relation between the online registration system and SAGE. Everything is
transferred through print outs.
The Online Registration has an interface in which
information from the bank is imported, but that information is delivered only on print
to the SAGE system (owned by the bursary).

Ms. Katoyo claims that there is a module in SAGE to connect / interface with

a
student system, but this module is not effectuated yet. SAGE was build by
consultants from Zimbabwe and they would have to be involved if an interface would
be made.

Note: this concerns new information. We take notice of this, but cannot assure that
thi
s can be done in this project.


See for the requested reports from internal audit at
CBU

the reports for bursary /
financial officers. They include the wishes from UNZA.



d.
Finetune
Bursar/Financial Officer

privileges

Views on:


Financial Interface:

9



Expor
t
-
screen for export of student
-
data to financial / accounting system (see
also: interface to financial / accounting system)


Fees:


Student / fees reports (see chapter ‘Reports’ for all fee reports for financial
officers)


Add / edit / delete student’s
fees

r
elated data manually

(payments)


Print payment receipts


Study plans:


View student’s study
-
plan


Examinations & Results:


View examination subscriptions of student


View student’s results so far (also in XLS) (see: Chapter 9


Reports)


View
Senate Examinations

Report per school

(see: Chapter 9


Reports)


Scholarships:


Add / edit / delete student’s sponsor related data manually


Sponsor reports (see chapter ‘Reports’ for all sponsorship reports for financial
officers)


e
. Finetune
teacher

privileges

See if a tea
cher has ability to see subscription data and finetune further.


f.
Role dropdown shows roles twice

The same role is shown twice in the combo box on the top of the screen.

T
o make the roles language independent, we're not showing 'role.role' anymore, but
'
role.description'. And apparently you have 2 language options for role in your
database ?

It should be the description from the preferred language one then.


g.
Edit role: wrong branch is shown in dropdown

The branch dropdown always shows the branch to whi
ch the logged in user belongs,
not the branch that the chosen organizational unit belongs to.

In the example, the org.unit "Extensao de Cuamba" belongs to Faculdade de
Educacao, not to Faculdade de Agricultura.


h. Edit role: if branch combo not visible,

show branch non
-
editable

If the branch combo box is not visible in the edit role screen, then the branch should
nevertheless be shown simply as a non
-
editable text, because otherwise it is unclear
to which the organizational unit belongs to.



Admin funct
ions

a.
Create admin function for add / edit / delete secondary school
subjects


b. Create admin function for logRequestError

10



Create the same functionality as for logMailError.


c. Clean up edit
-
structure for lookuptables under admin menu

The lookup table

admin structure is not clear anymore.

E.g. when I’m looking at the Zambian situation, in which you have the languages
English and Zambian to your disposal:

If you are having lookup table records for English, then it’s impossible to edit the
screen to add
English
-
zambian values for the same code.

You can only add a ‘loose’ English
-
zambian record.

In any case it’s a bit unclear why there should be a select dropdown with all 4
options (English, English
-
zambian, English / English
-
zambian, English
-
zambian /
Eng
lish).


The ideal situation is where you have one edit
-
screen in which all descriptions for all
possible languages for a certain configuration can be edited at once, based on their
shared 'code'.

This means:

a. no language filter in the top, but calculat
ion of that based on the init parameters.

b. click on edit shows the code and a number of editable description fields, as much
as there are languages.

a. click on add shows the code and a number of editable description fields, as much
as there are language
s.


Note: The code is editable or non
-
editable depending on the status of the
lookuptable in the table lookuptable: if it is active 'N', it means it cannot be editable
and the records are not deleteable. If it is active 'Y', it means it is editable.

Note:
Works for multiple languages (first entry in all language the same; afterwards
you can edit it), but not for existing lookups: if the lookup is missing in a language,
you can't enter it anymore.


Technical changes and issues


a
.
Problems with en
-
zm languag
e files


Due to a
server /
translation problem the system sometimes shows the english
names instead of the english Zambian names.


c.
G
eneral opus email address on startpage


Instead of

current specific address:
m.inhetveld @uci.ru.nl


d. server memory le
aks & choice which environment to use

Platform choice: CentOS or Ubuntu/Debian
-
> setup with production and backup
server !


11


Configuration & General & Testing


a.
Document explaining app config attributes and roles
&

privileges


b. Stress Test with OpenST
A

The application should be resistant to peaks during admission and continued
registration. Test this with multiple sessions through openSTA or a likewise testing
tool.


c. Switching language can lead to exception

Sometimes, an exception occurs:


java.lang
.NullPointerException at

org.uci.opus.college.web.flow.StartController.handleRequestInternal(StartController.j
ava:203) at

org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractCon
troller.java:153)



3.4.2. Extensions to Mozambique mo
dule


a. If no thesis present, the calculations break

The result calculation basically works. There seems to be a small issue with
the thesis result: if there is no thesis, then there is an error message about
missing scales. Temporarily I commented out th
e check for this error,
because it prevents the otherwise successful result calculation (see lines 435
f. in ResultsCalculationsForMozambique).


b. Result calculations not based on studyplanctu’s, but directly on
subjects

Btw: Probably we'll have to change

the calculation of the studyplan result for
Mozambique, so that it is calculated directly from the subject results, without
studyplancardinaltimeunit results. There are no results used on a CTU, i.e.
yearly, basis. And the rules say that the final result
is calculated from
subjects. This is at least the case at UCM. But this should be easy to change
this calculation if necessary.


c. Check if Mozambican result generation still works

Check if when endgrades table is empty, the mozambican endgrade calculatio
ns
work, provided there are brsPassingSubject, etc. defined.


Markus:

We don't use any automatic generation of (letter) grades such as A, B, C. We use the
automatic calculation of the study plan result, but again not the grade calculation.

12


I tried a bit in

the beginning after migrating to the 3.2 DB structure to use a simple
setup for grades with passed / failed, but there were some issues, e.g. if you look at
Resultmanager lines 2650 ff: Only if no end grades are defined then the
brsPassingSubject is used.

When I tried using the end grades instead of
brsPassingSubject, then it didn't work well (but I don't remember well what the
problem was
-

maybe only a configuration issue in the endgrade table). On a few
more occasions in the source code makes distinctio
ns in case the end grade table is
empty (with comments indicating that this is the Mozambican case). Because of
these distinctions my impression was also that you intended that in Mozambique we
use an empty endgrade table.


d. Results calculation for Mozam
bique: identify identical subjects

identification based on the assumption that subjectCode stays the same

3.4.3. Extensions to Zambia Module


b. Change names of roles to Zambian logic


change the names of Admin
-
C, admin
-
B, admin
-
D to logical names (academi
c office,
dean / asst. dean, hod). And alter teacher to lecturer.


c. Description of privileges is language
-
sensitive : make en
-
ZM
version



e. Do not show housing percentage for scholarships

In Zambia the scholarship for housing is separated from other sc
holarships . E.g.
table scholarship, attribute housingcosts.



3.4.4. Extensions to UNZA Module


Security


a. https configuration


Financial module


a.
C
onfigure

UNZA bankrequest and bankresponse URL from Zanaco

13


use appconfig to set these values


b. White
list I.P.
-
address ZANACO bank

A d
ecision must be made where to catch and check this i.p.
-
address: on the server
or within the application.


c. Test environment Financial Interface

UNZA will arrange for a test
-
environment for the financial interface module,

which
will mock requests from ZANACO.


d
. extra filters
and attributes
financial request / transaction screens

A number of extra filters must be possible:

-

Status

-

Errorcode

-

Range of dates

-

Studentid

-

Transactionnumber

-

Students who have not paid 75 % tuition
fees

Furthermore the columns studentid and amount must be shown in the screens.



f
. automate steps from financial request
-
> transaction
-
> student
balance

These steps can be automated (e.g. valid transactions pushed through without
human interaction), bu
t the decision on this must be made by the DVC / Mgt CICT.
This decision is pending.


g
. balance must be pushed forward to current study programme and
year

The balance for a student is always pushed forward to the most actual study
programma and cardinal t
ime unit. This balance is the first that must be paid upon a
payment by the student. After that the normal business rules apply (other fees,
minimum 75 % of tuition fees).



Interfaces/Exports


a
.
P
ending issues data conversion



Pending issues data conversi
on (a.o. student grades)



extra data conversion financial information: confirmation with DVC on how far
back and what exact information



problem data conversion accommodation module (extra level blocks UNZA)
-
> check with Ben

Mazyopa (CBU)

14




testruns data conv
ersion


b.
Export (Excel
-
report) for Accounting system SAGE

This is a new specific report
.


Configuration & General & Testing


a.
Extra lines web.xml for https / ssl UNZA


3.4.5. Extensions to CBU Module


Security


a. https configuration



Interfaces



a
.
Interface Financial Information (Dimensions
-
> Opus)

see separate functional design document


b
. Export student information Opus
-
> Dimensions

see separate functional design document


3.4.6. Extensions to
Admission

Module


a. extra cut
-
off points for stude
nts from rural areas

implement in the same way as relative extra points cut
-
offpoint


b. Exception in request_admission.view after selecting gradetype

Exception in request_admission.view after selecting gradetype

15



3.4.7. Extensions to Fee Module


a
. Add op
tion to add student balances manually


Ad option to manually add a studentbalance for a student, for instance for fees that
were created after the creation of the studyplancardinaltimeunit of a student.

For now students without studentbalances are not clic
kable in the fees
-
overview
already.

b
.
If fee module not used, exception on
deleteSubjectBlockStudyGradeType
,


org.postgresql.util.PSQLException: ERROR: relation
"opuscollege.fee_fee" does not exist

SubjectManager
.deleteSubjectBlockStudyGradeType calls
feeManager.deleteFeesForSubjectBlockStudyGradeType(), which
cannot work if the fee module is not present


c
.
If fee module not used, exc
e
ption on deleteStudyGradeType


Cause: org
.postgresql.util.PSQLException: ERROR: relation "opuscollege.fee_fee"
does not exist


d
. If fee module not used, exception on
deleteSubjectStudyGradeType

Cause: org.postgresql.util.PSQLException: ERROR: relation "opuscollege.fee_fee"
does not exist


e. Set

academic year fees on school level, not central

Fees on academic year level differ per school, must be set a level below central.




3.4.8. Extensions for Scholar
s
hip Module


a
. Zambian changes scholarship when moving to parttime


S
cholarship applications

can only be done for fulltime students (Zambia), other
countries all studyIntensity types


16


Scholarship application
-

Keep track of changes at CTU; When a student who is on
bursary (i.e 100%, 75%, 50%, or 25%) is sent to Parttime or fails the final exams,
the system should automatically be put that student on self sponsored in the next
CTU, can this be configured in the system?


b.
Effectuate privileges on scholarship module

c.

B
illing: create design and build (by UNZA)

UNZA developers will write design on
extra features and
(in the followup project)
will
build
these features, coached by the dutch team


3.4.9. Extensions to Report Module


a. Student card

The authorization to print the student cards is held by specific roles
: Librarian /
Academic Affairs Offi
ce.


b. Diplomas / Certificates of graduation

The authorization to print the diplomas / certificates of graduation is held by specific
roles
: Dean / Asst. Dean / Asst. Registrar / Academic Affairs Office.


c. Fees reports for Bursar / Academic affairs offi
ce / Internal Audit


Several reports required by the bursar:



billing students: create / adjust invoices per individual student and in bulk



summary statement
: a filtered group of students within a certain time period



student statement of account/ individual

student balance
: collection of all
payments and outstanding fees for one student



past dues report: all student balances that have outstanding fees



receipts list report
: to enable generation of the cash book instead of relying
on the bank statements



debtor
’s age analysis report: to help management make decisions on writing
off bad debts



unregistered students reports
: overview of students who have accessed the
system, but not completed the registration process



total fees received per cardinal time
-
unit per s
chool



reports on all postings : backlog


Note: all reports should be viewable and editable for the financial officers. The
underlined reports should also be viewable for the academic affairs office.


Required filters:



student
-
number



person.housingoncampus
(Y / N)



student category



study programme



sponsors (divided by sponsor
-
type or self
-
sponsored)

17




An important feature is to be able to make reports for a certain time period
(e.g. from year
-
month
-
date A to year
-
month
-
date B).


Note: all reports have to be mad
e available also in XLS.


Important issues to know / view from Opus for
Internal Audit of CBU

are:

-

right numbers and lists of students from the system

-

correct data on each student

-

complete list of registrations

-

fees information on each student: the current

system does not provide
accurate information on the student fees / payments. Wish for track on
payments of all tuition fees installments and other fee payments

-

information on the social environment of a student (regarding scholarships)

-

information on the
results of students and on the grades of secondary school
(admission information)

-

authorization and audit trail on changes and amendments of fees etc.

-

view on the roles of users in Opus and the changes in roles

-

information on scholarships


d. Admission sli
ps & Continued Registration Slips


Print of the following stages in the admission process:


account creation / waiting for payment : admission slip !


approved / rejected by dean (before choosing exact study
-
gradetype for next
cardinal time
-
unit) : letter of

acceptance


The possibility to print the admission slips is within a limited period after the
admission process (second
level unit is the entity that stores
admission

period)
: for
one month long.


A
fter
registration

period is over the option to 'print con
firmation slip' for all
studygradetypes

under this department (second
level unit is the entity that stores
registration period) must become visible (for one month long )


Print of the following stages in the continued registration process:



waiting for paym
ent : confirmation slip



Note: the authorization for these print
-
options should be with the individual student
through his own login and with the academic office role and assistant dean role
within the system.


e. Result slips


See: printed results slip C
BU for example.


Print of passed examinations of students.


Note: the authorization for this print
-
option should be with the individual student
through his own login and with the dean / asst. dean role within the system.


18


f. Sponsor reports for Bursar / Ac
ademic affairs office / Internal
Audit


Several reports required by the financial officers and the academic affairs office:



Sponsor per school



Sponsor per gender


g. Student reports for Academic affairs office / Internal Audit


Several reports required by
the academic affairs office:



Registered students by school, gender and year of study



Origin of students indicating secondary school, town, province and nationality



Graduating students per school, study
-
gradetype and gender



Final comment per school, study
-
g
radetype and gender



Sponsor per gender



Age distribution of students per school, study
-
gradetype and gender



Senate Examinations Report per school



Staff / student ratio per academic year



Attrition per school and grand totals (attrition = number of dropouts b
etween
beginning and end of cardinal time
-
unit)



All students and studyplans by studyplan
-
status



All students by student
-
status


h. Student reports for Dean of Students


The DOS wishes a view on / list from all the changes in student information.
Furthermo
re a view on the penalties that are imposed on a student by other
authorities (like librarian, etc.).

And a list with all students per study programme and year of study, graduated
students, excluded and new moved
-
to
-
part
-
time students, so that the DOS can
make
a schema for the accommodation.


i
. Several Report overviews: for non
-
admin roles filters don't get
refreshed

When selecting academic year, filters and table don't get refreshed:

-

Students Progress Status

-

Subjects passed

-

Student profile sheet

-

S
tudent Certificate


j. Progress Report for Senate Committee

Important report is to catch the proposed progress statuses for students in the
‘transfer students’ overview.

Typically the right authorizations will impose progress statuses on the students, but
not do the actual transfer yet. And in this inbetween phase a report must be
generated with the proposed progress statuses.


k
.
Student profile sheet report: Order by academic year

19


Currently academic years appear in random order


l. Subjects passed Report
overview: Cardinalt time unit filter has no
effect

Whatever is chosen in the Cardinalt time unit filter, always the same
list of students is shown.


m. Student certificate report overview: Clicking on a student does not
create report

When clicking on a st
udent, no report is created (only when clicking
the "create report" button)


n. Continued registration: report error when selecting
cardinaltimeunitnumber

org.postgresql.util.PSQLException: ERROR: column
subjectblock.cardinaltimeunitnumber does not exist


o. Custom reports per university: StudyGradeTypeReportController

Report unit: studyGradeType

Make a controller that can be configured with Spring applicationContext.xml to
integrate reports into Opus

Example reports:


-

Graduating students per school, s
tudy
-
gradetype and gender


-

Final comment per school, study
-
gradetype and gender


-

All students (and studyplans) by studyplan
-
status


-

List of applicants.


-

Successful application for admission and readmission.


-

Accepted but not registered.


-

List o
f Students straight from Secondary School.

E
xtension point designed to reuse existing controllers for Zambian reports
.

2 reports configured in application context .xml one missing report: progress status
report
.


p. Custom reports per university: Subject

Report unit: subject

Make a controller that can be configured with Spring applicationContext.xml to
integrate reports into Opus

Example reports:


-

List of students per subject (course)


-

Prerequisite courses or subjects.


q. Custom reports per universit
y: study grade type / CTU

Report unit: (study grade type / CTU)

20


Make a controller that can be configured with Spring applicationContext.xml to
integrate reports into Opus

Example reports:


-

Lists of students per semester/year


-

Students' progress status


-

Board of examiners report


r. Student certificate report overview: show name of study plan

In the table, show name of study plan (to distinguish if a student has two study
plans for the same study program).


s.
Graduated students report

As an example
of a "student report per study grade type



t.
Curriculum per year report: nothing happens on create report

In the curriculum per year report overview, nothing happens (no report is


created) when clicking on the "create report" button or when clicking on

the link for
a report for a particular year.


3.4.10. Extensions to Accommodation Module


a.
Design and develop


b.
Layout


c.
Test / unit test


d. S
et accommodation fee in process of assigning room

Set accommodation fee at process 'assign room' in fees
module
-
> set is done in
accommodation module
.

Ben is making a first setup. Check afterwards
.


e
. High and low prices for Acommodation fees

During vacations there are lower prices for accommodation then during the school
season.


f.
Do not change controlle
rs' formView outside constructor

Never change the controller's formView value outside the constructor (or the
eventual setter method on bean creation).

21




I've corrected this in the AccommodationRoomController (using a local variable
within the processSub
mit() method) and committed to SVN.
--
> Please also correct
the other affected controllers:


-

AccommodationApplicationController


-

AccommodationFeeController


-

AccommodationFeesController


-

AccommodationRoomsController


-

AccommodationsHostelBlockCont
roller


-

AccommodationsHostelController


-

RoomAllocationController


g. Extra features concerning students selection in accommodation

• Selecting of fully paid
-
up students to whom rooms can be assign (The module
select all the student who applied for acco
mmodation. This is due to the fact that
when the student logs in can apply for accommodation and will be ‘considered’ for
room allocation. The decision of either to allocate a room or not depends on the
user’s decision)

• Restricting the selection or filte
ring of students to those who are on full time in the
current academic year and have been on fulltime in the last academic year. This
leaves out those who are currently on part
-
time, who were on part
-
time and were on
exclude (The module is able select thos
e who are either on full time or part time in
the selected academic year)

• The role and functionality for the wardens to allocate materials and resource to the
student who has been allocated the room.


h. adding fee gives error

Adding fee gives error: red
irect to non
-
existing
o
pus/accommodation/fees/fees.view.
Fee itself is added


i. overview of students shows nothing

No overview of students is displayable : No Records Have Been Found