Aplicaciones de software de gestión administrativa : aplicación de gestión de carga académica de profesores para el DETRI.

Abstract

This Curricular Integration Work proposes the development of a software prototype that allows the DETRI department of the National Polytechnic School to correctly manage the academic loads of the teachers belonging to this department. The first chapter explores the three-layer software development approach: Data, Business and Presentation. The appropriate tools to implement in the prototype under development are analyzed. Finally, this chapter selects the Kanban methodology, which allows a visual and agile management of the pending tasks necessary for the development of the Curricular Integration Work. The second chapter covers the different points of view regarding the design and implementation of the project. In the design phase, the planning of the initial Kanban board is detailed, and the functional and non-functional requirements are established. In addition, a use case diagram is presented, and the design of the data, business and presentation layers is described. In the implementation phase, the concrete steps to carry out the project are addressed. The update of the Kanban board and the installation of the necessary tools for the development of the prototype where SQL is used as database engine and Visual Studio Code as development environment are mentioned. The coding of the database, the business layer and the presentation layer is detailed. In the latter, use is made of the Windows desktop application development framework known as Windows Forms. In the third chapter, the prototype tests are executed within a controlled scenario where it is also analyzed whether the prototype meets the objectives and requirements set forth. Finally, chapter four examines the results that emerged from the development of this Curricular Integration Work, with the purpose of obtaining the respective conclusions and recommendations.