Tecnología en Sistematización de Datos
URI permanente para esta colecciónhttp://hdl.handle.net/11349/1914
Examinar
Envíos recientes
Ítem Desarrollo de un sitio web para servicios de captura y visualización de datos para la fundación pares(Universidad Distrital Francisco José de Caldas) Rodríguez Restrepo, Jefferson Yassell; Mosquera Sánchez, Arnold Nicolás; Navarro Mejia, William EnriqueThis internship project focuses on the design and implementation of a digital data management system for Fundación PARES, aimed at optimizing the collection, validation, and visualization of information through automated forms. The solution integrates a React.js and TypeScript frontend, a Laravel–MySQL backend, and Power BI dashboards, achieving centralized and secure data handling. Using the Kanban methodology, the system streamlines workflows, includes administrative approval processes, and applies AES-256 encryption for security. Results show a 60% reduction in data collection time, 90% fewer transcription errors, and a 20-hour weekly efficiency gain, enhancing decision-making through reliable and real-time analytics.Ítem Sistema para la gestión de los procesos administrativos en un gimnasio(Universidad Distrital Francisco José De Caldas) Hurtado Roa, Christian Andrés; Lasso Chavarro, Luz Nidian; Lasso Chavarro Luz Nidian; Wanumen Silva, Luis Felipe; Wanumen Silva Luis Felipe [0000-0002-8877-5681]The purpose of this project is to develop a management system for the administration of a gym, aimed at optimizing processes related to employee payroll, equipment inventory, class scheduling, and membership management. The system was designed using Flask as the backend framework, MySQL as the database management system, and HTML, CSS, and JavaScript for the visual and interactive layers of the application. Among its main features are user management by roles: administrator, trainer, member, technician, and receptionist as well as check-in control, assignment of training plans, equipment maintenance management, and visualization of machine availability. This project seeks to provide a practical and accessible tool that facilitates the administration of gym resources and improves the efficiency of daily operations. In addition, it contributes to the strengthening of academic and technical training in web application development through the use of modern and open-source technologies.Ítem Integración de un sistema de visualización de grafos para la representación estadística de trayectorias de aprendizaje de juegos matemáticos(Universidad Distrital Francisco José de Caldas) Gonzalez Rubiano , Quiles; Novoa Torres, Norberto; Novoa Torres, Norberto [0000-0003-3374-7760]Within the context of the emphasis on mathematics education of the Interinstitutional Doctorate in Education (DIE), a web application for mathematical games has been developed. This application currently captures data about players, including general information and moves made in the games. However, this data is stored in CSV format, which limits its usefulness and understanding by users. Continuing, when addressing the problem of data storage using the CSV format, the use of databases through the SQL (Structured Query Language) language is proposed. Using a database will make data storage easier and, in addition, obtaining it more efficiently. Furthermore, using the SQL language will make it easier to manipulate when the amount of data is very large. When using something like the CSV format, it is observed that data manipulation becomes problematic as the data increases, so the use of SQL will greatly aid. Currently, the website developed by DIE's mathematics education emphasis teachers takes CSV data and uses it for analysis and interpretation processes through the use of graphs. However, data analysis and interpretation are inefficient. When creating a graph with the collected data, the CSV must be downloaded and then read with a specific MATLAB program that interprets the data. These data will be visible in a graph generated by the program. This allows for the observation of each node, which will represent each data item collected, and then, through this, the behavior of users, or in this case, players, can be observed.Ítem Sistema de gestion del conocimiento para el curso de analisis de sistemas(Universidad Distrital Francisco José de Caldas) Clavijo Perez, Dayanna Alejandra; Mogollon Villalba, Kevin Santiago; Guevara Bolaños, Juan CarlosThis undergraduate thesis presents the development of a Knowledge Management System (KMS) designed for the Systems Analysis course at the Faculty of Technology of Universidad Distrital Francisco José de Caldas. The project addresses the lack of a platform to centralize, organize, and facilitate access to structured academic content, which hinders knowledge reuse and autonomous learning. The system allows both students and administrators to register, manage profiles, access a resource repository, receive notifications, and participate in validation processes. Rapid Literature Review, SCRUM, and TAM methodologies were applied for the design, development, and validation of the prototype. The implementation was carried out using free and open-source web technologies, ensuring technical, economic, and legal feasibility. Results show that the platform improves the availability and organization of content, fosters user interaction, and strengthens academic competencies in the subject.Ítem Sistema de gestion de indicadores para la maestría en gestión de la seguridad de la información (udguard)(Universidad Distrital Francisco José de Caldas) Guerrero Piñeros, Carlos Iván; Guevara Álvarez, Andrés Eduardo; Rodriguez Guerrero, RocíoThe Master’s program in Information Security Management at Universidad Distrital required a reliable, traceable mechanism for high-quality accreditation self-assessment (CNA). This work introduces UdGuard, an indicators-and-evidence management system that embeds the CNA hierarchical model (factors→characteristics→aspects), automates calculations, centralizes evidence, and delivers monitoring dashboards. The study followed a mixed approach combining applied research and agile development (Scrum), including semi-structured interviews (with Professor Manuel), documentary analysis, and iterative prototyping. The architecture (MVC + REST API) and data model enable configurable calculation rules, evidence versioning, and full change traceability. In pilots with representative datasets, UdGuard reduced consolidation time by ~62%, decreased data-inconsistency incidents by ~72%, and increased indicator-evidence coverage from 68% to 94%. Qualitatively, it improved executive visibility, audit readiness, and a data-driven improvement culture. Functionally, the system aligns with ISO 9001:2015 (4.4, 7.5, 8.3, 9.1, 9.3, 10.2–10.3) by reinforcing process orientation, documented information, measurement, and continual improvement. Recommendations and future work include integrated improvement plans and internal audit modules.Ítem Sistema de gestión web para la visualización y análisis del nuevo pénsum de las carreras sistematización de datos e ingeniería telemática de la Universidad Distrital Francisco José de Caldas(Universidad Distrital Francisco José de Caldas) Salazar Cruz, Malfaida Nicol; Leyton Montiel, Heider Sait; Wanumen Silva, Luis Felipe; Wanumen Silva Luis Felipe [0000-0002-8877-5681]The Curricular Projects of Technology in Data Systematization and Telematics Engineering currently lack a tool to aid in the modification and updating of their respective curricula, considering that the second program is a continuation of the first. This has led to the proposal of a software model aimed at reducing the time required for decision-making regarding curriculum modifications. This project focuses on developing a web-based management system model for the visualization and analysis of the updated curriculum for the aforementioned programs. The system is divided into five sections, including courses and principles, featuring multiple charts and tables that provide a clear view of the various elements upon which the curriculum depends. The tables allow for a more detailed examination of the corresponding information, as well as modifications, enabling users to visualize the potential results of changes to the curriculum. Currently, this system remains a prototype, as its implementation has not yet been carried out due to pending approval and validation as a decision-making aid. The proposed software is based on data provided by the director of the Technology in Data Systematization curricular project, as well as an open-source system that allows for adaptation to the specific needs and requirements of the project.Ítem Sistema de autenticación para Instituciones Educativas basado en un modelo no multifactor(Universidad Distrital Francisco José de Caldas) Triana Larrota, Cristian Santiago; Sayas Carmona, Joel Andrés; Pinzón Nuñéz, Sonia Alexandra; Pinzón Nuñéz, Sonia Alexandra [0000-0003-0746-0598]This project proposes the design of a digital authentication system for educational institutions, based on a non-multifactor model. The solution replicates essential Active Directory (AD) services to host a proprietary application with a validation framework that includes device verification, geolocation, and risk analysis, in compliance with security standards such as ISO/IEC 27001. The proposed solution incorporates a robust authentication system that, while not considered multifactor, integrates multiple validators that increase security without requiring additional steps for the user. These validators include: • Device verification: Validation of the device’s IMEI or MAC address. • Geolocation: Use of geofencing techniques to validate the user’s location. • Risk analysis: To assess anomalous behavior or suspicious access. • Compliance with ISO/IEC 27001: Referring to information security management. • Secure protocols: Use of HTTPS for encryption. • Secure transmission media: such as Ethernet, WPA3 Wi-Fi, and VPN.Ítem Sistema de monitoreo para macetas de albahaca(Universidad Distrital Francisco José de Caldas) Monsalve Gómez, Duvan; Saavedra Gutiérrez, Jimmy; Guevara Bolaños, Juan CarlosThe project involves the design and implementation of an IoT-based monitoring system for a potted basil crop, with the goal of recording and visualizing temperature, humidity, and pH variables in real time during its growth. To this end, appropriate sensors were selected and configured to ensure accurate measurements and their proper integration with the monitoring platform. A data storage and analysis system was also developed to process the information obtained and generate alerts when parameters exceeded established optimal thresholds. Finally, the system was validated under real-world growing conditions, demonstrating its functionality and providing a useful tool for the efficient monitoring and management of basil growth.Ítem Desarrollo de una aplicación móvil de control parental(Universidad Distrital Francisco José de Caldas) Beltran Guañarita, Ianjaner Alfonso; Guasca Bulla, Camilo Andrés; Rodríguez Guerrero, RocíoThis document proposes the development of a mobile application focused on parental control, which aims to provide parents with a tool to monitor and regulate children's use of mobile applications. This solution seeks to support digital parenting by enabling time supervision, generating alerts, and displaying usage reports.Ítem Tutorial educativo para apoyar el aprendizaje del lenguaje de programación Java(Universidad Distrital Francisco José de Caldas) Morales Vanegas, Jennifer Alejandra; Herrera Bejarano, Sara Viviana; Guevara Bolaños, Juan CarlosThis project addresses the challenges of learning Java in introductory programming courses, where students often struggle due to the transition from languages such as C++, the abstract concepts of object-oriented programming, and traditional teaching methods that lead to demotivation and high failure rates. As a solution, the project proposes the design and implementation of an educational tutorial in the form of an interactive website, based on the constructivist model and developed using the SCRUM methodology. The tutorial, aimed at students of the Data Systematization Technology program, includes lessons, activities, and assessments on basic Java concepts, using teaching strategies and technological resources to promote active and dynamic learning. Its validation through the TAM model demonstrated high acceptance and perceived usefulness among users.Ítem Aplicación web para evaluación y generación de contraseñas seguras “SecureGen”(Universidad Distrital Francisco José de Caldas) Rincón Cuervo, William Stevan; Pinzón Nuñez, Sonia Alexandra; Pinzón Nuñez, Sonia Alexandra [0000-0003-0746-0598]In today's digital world, many individuals continue to use weak, repetitive, or easily predictable passwords to protect their online accounts and information. This, combined with a lack of awareness regarding good cybersecurity practices, poses a significant threat in an environment where exposure to cyberattacks is increasingly common. While there are online tools available for generating and evaluating passwords, many fail to provide clear insights into the actual security level or educate the user on how to improve it. The development of secure passwords and evaluation based on technical criteria such as entropy is crucial for ensuring proper protection. Additionally, guiding users on how to create robust and secure passwords fosters a better culture of digital security. Therefore, there is a clear need for an integrated tool that not only generates and evaluates secure passwords but also educates users in the process. This document presents the development of a web application designed to promote the creation and evaluation of secure passwords, outlining the design process, challenges encountered, and decisions made to ensure an effective and functional solution. It also discusses the project’s justification, the importance of the addressed issue, and how the proposal aims to enhance digital security in the current landscape.Ítem Implementación de tableros de control financiero con una herramienta de inteligencia de negocios para la visualización de la gestión contable.(Universidad Distrital Francisco José de Caldas) Daza Bejarano, Juan Pablo; Espejo Mojica, Oscar Gabriel; Espejo Mojica; Oscar Gabriel [0000-0002-0920-4531]This final report documents the development and implementation of a comprehensive Business Intelligence solution for the visualization and analysis of the accounting management of the client Mawii – Tech Facturación Electrónica, carried out within the framework of a corporate internship. Throughout the document, the context and initial problems of the organization, the objectives, the applied methodology, the design and construction of financial control dashboards, as well as the results obtained and their impact on strategic decision-making, are presented. The project was developed under an agile methodology approach, specifically using eXtreme Programming (XP) and the Kimball approach for the construction of the data warehouse. These methodologies allowed for short iterations, facilitating incremental delivery of functionalities, continuous feedback, and adaptation to changes in client requirements. Thanks to this iterative work scheme, it was possible to identify necessary improvements early, optimize resources, and ensure that the final solution effectively addressed the organization's financial information needs.Ítem Aplicación móvil para la gestión de eventos curriculares y extracurriculares en entornos universitarios(Universidad Distrital Francisco José de Caldas) Moreno Olaya, Miguel Ángel; Castro Chia , Karol Yandi; Zabala Alvarez, John Fredy; Zabala Alvarez; John Fredy [0000-0001-7795-6471]University events, whether within or outside the curriculum, were shown to be an integral part of students' social, academic and personal growth. However, conducting and managing these activities presents a challenge due to poor organization and lack of proper tools. Most educational centers use outdated tools such as boards to inform about upcoming events or other non-optimized platforms aimed at displaying upcoming events from large venues. This results in poor communication, inefficiency and bureaucracy in organizing such activities. This work seeks to offer a solution through a mobile application designed to optimize the management of university events. The application will allow to display events, coordinate with administrators, manage registrations, logistics and facilitate communication between organizers and students. Our goal is to transform the way events are organized in the university environment, improving the experience of both students and organizers and students. Putting these measures together, this work will not only help manage the organization of these types of events in a more efficient way, but will also increase student participation which in turn will generate an improvement in the means of communication. Through this application, we aim to completely transform the way university events are managed, offering both students and organizers a significantly improved experience. With the implementation of this measure, it is hoped to greatly impact the academic and social life of the university population, strengthening the link between them, learning and cooperation.Ítem GitCo-learning: aplicación interactiva para el dominio de git(Universidad Distrital Francisco José de Caldas) Sepulveda Sanchez, Danna He; Lopez Zuñiga, Jafet Stiven; Rodríguez Guerrero, Rocío; Rodríguez Guerrero Rocío [0000-0002-2956-9650]As part of the technology training program at Francisco José de Caldas District University, a lack of practical resources to support learning Git, one of the most important tools in modern software development, was identified. The aim of this project is to design and develop an educational web application called GitCo-Learning, which will enable students to acquire essential knowledge about version control through guided and interactive exercises. To execute the project, the agile Scrum methodology was adopted, dividing the work into sprints ranging from goal planning to system implementation and validation. Development was carried out using technologies such as HTML, JavaScript, Node.js, Firebase, and Socket.IO, which allowed for the creation of a dynamic, interactive, real-time web experience. The application has two main modes: individual and collaborative, designed to adapt to different learning styles. It also includes a system of practical challenges, interactive tutorials, and authentication through external accounts, all with the aim of facilitating the acquisition of fundamental knowledge in Git. The result is a technological solution that promotes autonomous learning and prepares students to face real challenges in collaborative work environments.Ítem Sistema de monitoreo para un cultivo hidropónico de tomates(Universidad Distrital Francisco José de Caldas) Milquez Reyes, Ariana Alejandra; Guevara Bolaños, Juan CarlosThis thesis presents the design and implementation of a monitoring system based on Internet of Things (IoT) technologies for a hydroponic tomato crop, aimed at optimizing agricultural productivity and sustainability through the precise control of critical variables such as pH, humidity, and temperature. The study begins with the identification of common challenges in hydroponic farming, including nutrient imbalances, pest proliferation, and water contamination, which affect both the quality and quantity of the harvest, increase costs, and compromise profitability and food security. Based on a rapid literature review and recent background studies on monitoring systems applied to precision agriculture, an integrated model was designed combining specialized sensors (PH-4502C, DHT11), an ESP32 microcontroller, and a MySQL database for structured data management. The technological solution includes a software prototype implemented in WordPress at a local level, structured into modules that enable the capture, transmission, analysis, and real-time visualization of environmental variables, as well as the generation of alerts and recommendations to support decision-making. The methodological development was carried out using the agile Scrum framework, which facilitated an iterative and incremental management of requirements, ensuring flexibility in implementation and progressive validation of the system. The research results highlight the potential of IoT to reduce water consumption by up to 30%, improve nutrient efficiency, and increase crop productivity by 20–35%, according to the analyzed studies. Likewise, challenges related to initial costs, energy dependence, and the need for technological standardization were identified, revealing future opportunities for the integration of artificial intelligence for pest prediction and the adoption of renewable energies. In conclusion, the developed system constitutes a support tool for the management of hydroponic tomato crops in both domestic and commercial contexts, contributing to smart agriculture, environmental sustainability, and resource optimization through the use of accessible, open-source technologies.Ítem Desarrollo e implementación de un sistema erp apoyado en una arquitectura de microservicios en aws para la gestión y centralización de la información en la empresa supermercado santa(Universidad Distrital Francisco José de Caldas) Pineda Duque, Faihd Enrique; William, Bautista HerreraThis project involved the design, development, and implementation of an integrated administrative system to manage sales, purchases, payments, clients, suppliers, inventory, data migration, expenses, notifications, and configuration. The solution was built on a distributed architecture that combines a local application for point-of-sale operations, a web application for centralized management, and an API deployed in AWS for real-time data integration and synchronization. This implementation optimized the company’s internal processes and strengthened operational efficiency across all levels.Ítem Sistematización y consultas automatizadas de datos académicos afines a los datos(Universidad Distrital Francisco José de Caldas) Avila Rosas, Andrés Felipe; Riaño Vargas, Santiago; Wanumen Silva, Luis Felipe; Wanumen Silva Luis Felipe [0000-0002-8877-5681]This project proposes the development of a web system for the systematization and automation of academic data queries managed by the Technology Coordination for data systematization of the Distrital University Francisco José de Caldas. Currently, the information is disorganized across multiple files and formats, primarily Excel spreadsheets, which hinders efficient editing, analysis, and consultation. The proposed system, through the integration of specific modules, seeks to facilitate access to accurate and up-to-date data on academic positions and the learning outcomes of the technology and engineering program. Furthermore, the project aims to develop an intuitive web interface for administrative users and implement the agile KANBAN methodology.Ítem Sistema para la visualización de indicadores para el Proyecto Curricular Sistematización de Datos(Universidad Distrital Francisco José de Caldas) Garzon López, David; Pérez Ochoa, Jhonatan; Wanumen Silva, Luis Felipe; Wanumen Silva, Luis Felipe [000-0002-8877-5681]In many situations, to make requests or in administrative processes, it is necessary to create and manage different documents, which requires a specific understanding of the data that is available in order to make a more effective decision. This is possible through an orderly display of the data to be able to obtain their understanding, on many occasions it is observed how mismanagement of data affects administrative performance, that is where having an organized management of them is essential. In the case of curricular projects in administrative processes, sometimes these data become tedious due to their considerable size and more specifically the lack of a method that organizes them so as not to generate incomplete processes, these are avoided if we have more exact and complete information at plain sight. To streamline these processes, it is proposed to create an index grapher where it specifically shows data of interest, where these data are graphed by different themes, where the indices that are available would be observed and generating greater efficiency when carrying out any process, to This would require the database using it as a reference point since it contains all the data of the project, but avoiding the manipulation of unauthorized persons, it is there where the data of this database would be observed but without compromising the database itself.Ítem sistema de gestion de conocimiento para el curso de analisis de sistemas(Universidad Distrital Francisco Jose de Caldas) Clavijo Perez, Dayanna Alejandra; Mogollon Villalba, Kevin Santiago; Guevara Bolaños, Juan Carlos; Guevara Bolaños, Juan Carlos [0000-0001-9580-0374]This undergraduate thesis presents the development of a Knowledge Management System (KMS) designed for the Systems Analysis course at the Faculty of Technology of Universidad Distrital Francisco José de Caldas. The project addresses the lack of a platform to centralize, organize, and facilitate access to structured academic content, which hinders knowledge reuse and autonomous learning. The system allows both students and administrators to register, manage profiles, access a resource repository, receive notifications, and participate in validation processes. Rapid Literature Review, SCRUM, and TAM methodologies were applied for the design, development, and validation of the prototype. The implementation was carried out using free and open-source web technologies, ensuring technical, economic, and legal feasibility. Results show that the platform improves the availability and organization of content, fosters user interaction, and strengthens academic competencies in the subject.Ítem Sistema de monitoreo del nivel de atención, meditación y retención de información en estudiantes de ingeniería de software(Universidad Distrital Francisco José de Caldas) González Díaz, Daniel Eduardo; Culma Villalobos, Miguel Angel; Guevara Bolaños, Juan Carlos; Guevara Bolaños Juan Carlos [0000-0001-9580-0374]The current global landscape is characterized by extraordinary technological evolution, with the Internet of Things (IoT) emerging as one of the most significant innovations. The IoT, which enables the interconnection of devices and the exchange of information in real time, has catalyzed the development of monitoring systems [8]. These tools, through the use of sensors and other devices, facilitate the observation, measurement, and recording of various conditions and parameters, providing crucial data for decision-making and improving efficiency in multiple processes and resource management. In the educational field, the integration of monitoring systems and IoT is redefining teaching and learning. These technologies open a range of opportunities to implement more dynamic and adaptive methodologies that can be precisely tailored to the individual needs of each student. By enabling detailed tracking of academic progress, they pave the way toward more personalized and effective education [3]. However, despite these advances, university students continue to face significant challenges that impact their performance. The inappropriate use of technology and electronic devices, while expanding learning possibilities, has also led to a considerable increase in distractions, affecting attention levels. Additionally, stress and anxiety—common phenomena in the university environment—can diminish the ability to concentrate, negatively influencing academic performance [2]. Therefore, the development of self-regulation skills becomes essential for students, allowing them to plan, evaluate, and adjust their own learning process, overcome technological distractions, and manage stress more effectively, resulting in better academic performance [2]. To address this complex issue, this document proposes the development of an innovative monitoring system that integrates an electroencephalographic (EEG) device. This system will capture data on attention, meditation (calmness and relaxation), different types of brain waves, and the level of information retention. The implementation of this technology will enable continuous and detailed tracking of these parameters during educational activities in software engineering courses. By obtaining precise information on students’ mental and emotional states, educators will be able to identify distractions or high stress levels early, facilitating the implementation of more effective pedagogical strategies to optimize the learning environment and support students’ academic performance. This document is structured to address the key aspects of this project. It begins with a clear formulation of the problem, followed by the presentation of the objectives and the justification of the study. Next, a review of the background is provided to contextualize the research, and the theoretical framework underpinning the project is explored, including concepts such as IoT, monitoring systems, and their application in education. The detailed methodology, which combines a rapid literature review and the SCRUM framework, is then described. Finally, the scope and feasibility of the project are addressed, including planning and cost estimation, and the document concludes with a mapping of objectives, an activity schedule, and the bibliographic references.