Another calculation of the load on the department
After reading the Calculation of the load on the department decided to share his experience creating a similar program. I apologize for the fact that the topic may be a twin of the above, but the programs are really very similar. The system was developed by me, the customer was the head of the department.
The main window contains tabs in which you can edit the main database tables. I will give only the main ones.
Tab "Curriculum" contains data about objects and hours that come to the department and which are subject to further distribution.
Further, on the “Subjects in the semester” tab, the “refresh” button allows you to calculate the number of hours according to the entered information about students and the standards of hours. Standards hours come to the department from the outside, as well as the curriculum.
')
The distribution of the formed hours is carried out on the next tab, one subject can be divided among several teachers, in case the lectures and practice are conducted by different teachers. Initially, it was not envisaged to conduct large stream lectures on several specialties / faculties, since there is no such thing in our department until this problem is solved.
In a separate window, you can see the statistics of hours among teachers, according to the head. The chair is very comfortable.
At the moment, the program creates 2 types of reports:
There is also an opportunity to create a special card of study assignments “Jobs”, in which all academic hours not distributed to teachers will appear.
The report is formed in the xlsx file, a library on c ++ without reference to Excel.
A third-party library was also used to create multi-level headers in the QTableView class.
The program was used in this academic year, there are customer wishes for its improvement, most likely they will be realized after the holidays are over.
The program is laid out in svn on Google Code under the GNU GPL v3 license, you can see it here .
The compiled version of Windows XP can be downloaded here .
Description
The main window contains tabs in which you can edit the main database tables. I will give only the main ones.
Tab "Curriculum" contains data about objects and hours that come to the department and which are subject to further distribution.
Further, on the “Subjects in the semester” tab, the “refresh” button allows you to calculate the number of hours according to the entered information about students and the standards of hours. Standards hours come to the department from the outside, as well as the curriculum.
')
The distribution of the formed hours is carried out on the next tab, one subject can be divided among several teachers, in case the lectures and practice are conducted by different teachers. Initially, it was not envisaged to conduct large stream lectures on several specialties / faculties, since there is no such thing in our department until this problem is solved.
In a separate window, you can see the statistics of hours among teachers, according to the head. The chair is very comfortable.
At the moment, the program creates 2 types of reports:
- Total department load
- Study cards
There is also an opportunity to create a special card of study assignments “Jobs”, in which all academic hours not distributed to teachers will appear.
The report is formed in the xlsx file, a library on c ++ without reference to Excel.
Technical details
- Sqlite DBMS
- GUI Qt
- C ++ language
- library for generating reports xlsx on c ++ was taken here , the author did not mind
A third-party library was also used to create multi-level headers in the QTableView class.
Conclusion
The program was used in this academic year, there are customer wishes for its improvement, most likely they will be realized after the holidays are over.
The program is laid out in svn on Google Code under the GNU GPL v3 license, you can see it here .
The compiled version of Windows XP can be downloaded here .
Source: https://habr.com/ru/post/148532/
All Articles