search

TRMN / medusa

Project Medusa. The source for the RMN Database.
GNU Affero General Public License v3.0
6 stars 5 forks source link

Bi-Monthly BuTrain Reporting Tool #108

Open eplossl opened 8 years ago

eplossl commented 8 years ago

With the movement to in-database grading of exams, BuTrain has requested that we build them a report interface which they can use to generate reports based upon the data available.

BuTrain has the following requirements for this report:

  1. It must be broken out by reporting period. The reporting periods are as follows: January 1st to February 28/29th March 1st to April 30th May 1st to June 30th July 1st to August 31st September 1st to October 31st November 1st to December 31st
  2. The report must be broken down into School/Academy/Department/Course (e.g. SIA/Enlisted/Academy/SIA-RMN-0005, SIA/TSC/Command department/(a/c/d/w exam)). Each of those divisions should roll up the exams below it. Thus, the SIA should have a count of all exams taken anywhere within SIA, whereas the Command department should have a count of all exams taken within the Command department.
  3. The report needs to be expanded as new exams are added.
  4. The report needs to be available to the 6SL and D6SL. (This is the permissions requirement)
  5. Where there are no exams of that type in the grading period, the report should show 0 exams graded, rather than a blank space.
  6. The report should show historical data from past grading periods for trend analysis.
  7. If possible, they would like the report to be exportable to Excel.

I'm attaching the requirements document below where there is somewhat more detail on these and some example reports.

Bolthole BuTrain Bimonthly report request.pdf

Motye commented 7 years ago

Rob to do design document

Motye commented 7 years ago

Might not make sense, as we are looking at using Moodle at the system of record for the grades; it may make better sense to have it generated from there.

eplossl commented 7 years ago

This was intended as a stopgap while we were working on getting Moodle up and running. Once Moodle is up, this feature is no longer necessary. If we can get Moodle up relatively quickly, then this can be scrapped.