Tecnología en Sistematización de Datos
URI permanente para esta colecciónhttp://hdl.handle.net/11349/1914
Examinar
Envíos recientes
Ítem Sistema web de homologaciones(Universidad Distrital Francisco José de Caldas) Bautista Clavijo, Juan Pablo; Orozco Montoya, Andrey Felipe; Wuanumen Silva, Luis Felipe; Wuanumen Silva, Luis Felipe [0000-0002-8877-5681]The present project addresses the construction of a web homologation system for thecurricular project “tecnología en sistematización de datos” at Universidad Distrital Francisco José de Caldas. This system has the objective of automating and streamline the process of student homologation internally for the students looking to change their curricular project. For the development of the project, we implemented various technologies such as React.js and Node.js, complemented by technologies like Express.js and Sass.Ítem Prototipo de red neuronal convolucional artificial para la detección del cáncer de mama por medio del analisis de imágenes diagnosticas(Universidad Distrital Francisco José de Caldas) Argumero Contreras, Daniel Felipe; Moreno Rojas, Carlos Alfredo; Becerra Correa, Nelson ReynaldoThis study addresses a significant asymmetry in the education of medical professionals responsible for detecting breast cancer through imaging compared to the increasing number of new cases in Colombia. The resulting disproportionate workload for these doctors restricts access to timely diagnoses, leading to the loss of crucial benefits associated with early detection. Emphasizing the importance of improving the diagnostic process, this research aims to classify individuals as healthy or sick, enabling appropriate measures based on cancer stages. However, the slow pace of educating expert doctors in patient classification poses challenges in keeping up with the growing population requiring evaluation. Implementing a capable diagnostic system may extend access to early cancer detection benefits. The proposed application offers a tool for doctors to delegate tasks to less specialized medical personnel, increasing coverage. Nonetheless, it does not replace doctors' work, given unknown error rates. The project also aims to raise awareness of AI's potential in education and healthcare in Colombia. The upcoming prototype involves building a neural network from scratch using Python, including a relationship between models to train and test image classification.Ítem Aplicativo web de encuestas con análisis de datos (ANALY-SURVEY)(Universidad Distrital Francisco José de Caldas) Cuervo Galeano, Carlos Andrés; Beltran Barrios, Daniel Steven; Rodríguez Guerrero, RocioCurrently, the use of surveys and data analysis is becoming increasingly relevant in the educational field, but its effectiveness depends on the proper processing of information. Given the need for students to have efficient tools, the development of an application that integrates surveys and data analysis techniques specific to the educational environment is proposed. This tool would facilitate informed decision-making by identifying patterns, trends, and relationships in the collected information, allowing for improvements in processes such as student performance evaluation and academic research. Additionally, by leveraging real-time data collection, personalized interventions can be implemented that enhance understanding for students, teachers, and administrators.Ítem Aplicación móvil para reducir el estrés académico(Universidad Francisco Jose de Caldas) Rubio Urrego, Yenser Stif; Umaña Peña, Diego Camilo; Rodriguez Guerrero, RocioThe Curriculum Project for Data Systematization at the Universidad Distrital Francisco José de Caldas faces a significant challenge due to the academic stress experienced by its students, which negatively impacts their well-being and academic performance. This research project addresses this issue by developing a mobile application designed to reduce stress caused by academic activities and improve student performance. To carry out this development, an agile methodology based on Kanban was employed, complemented by entity-relationship data modeling for system analysis and design. The structure of this research is organized into the following chapters: Chapter 1 introduces the issue of academic stress in the university context and specifically in the Curriculum Project for Data Systematization. Chapter 2 defines the scope and limitations of the research project. Chapter 3 establishes the general and specific objectives sought with the development of the application. Chapter 4 justifies the relevance and necessity of addressing the problem of academic stress in this specific context. Chapter 5 presents the theoretical and conceptual framework supporting the research, reviewing relevant literature on academic stress, agile development methodologies, and information system design. Chapter 6 details the methodology employed, including the description of the Kanban application and the entity-relationship modeling process. Chapter 7 analyzes the technical, economic, and operational feasibility of the development and implementation of the proposed solution. Chapter 8 presents the planned activity schedule for project execution. Chapter 9 describes the implementation and development process of the mobile application. Finally, Chapter 10 presents the project conclusions, discussing the results obtained and offering recommendations for future research or implementations. This approach aims to enhance control, security, and, fundamentally, the well-being of students involved in the academic and administrative activities of the project.Ítem Asp tool: generador de procedimientos almacenados para cruds de bases de datos(Universidad Distrital Francisco José de Caldas) Miranda Diaz, David Fernando; Ortega Cruz, Felipe; Pinzón Nuñez, Sonia Alexandra; Pinzón Nuñez, Sonia Alexandra [0000-0003-0746-0598]How has the academic field dealt with learning complex processes on databases as stored procedures so far? Immediately, the answer is the theory as base of knowledge and learning source, where dynamism and interactive tools lack has decreased the scope and impact to the knowledge around the stored procedures on academic – labor field. Focused as a prototype project, his focus is to implement an automatic CRUD stored procedure tool on PostgreSQL databases, being process automation a mandatory step to improve the syntaxis quality, avoiding the usual manual CRUD syntax faults and being a manual that provides the knowledge of creation, structure and implementation of stored procedures on databases through a practical and interactive environment that allows the application of these concepts in some future corporative challenges.Ítem Lion.py: tutorial educativo para el aprendizaje de programacion en Python con base en las etapas del pensamiento computacionalMoreno Caldas, Gabriela Sofia; Cardenas Villalobos, Wendy Caroline; Guevara Bolaños , Juan Carlos; Guevara Bolaños, Juan Carlos [0000-0001-9580-0374]Nowadays, technology has become known as the central axis of the great changes in the labor field and the main responsible for the various industrial revolutions, since these types of revolutions are driven by different technological innovations [1]; for this reason it is undeniable that the basic mastery of technologies has become indispensable in almost all known labor fields, such as education, medicine, entertainment, engineering, architecture, and many more which have resorted to the technological field and this has become a fundamental element for their development. However, there is the idea that such knowledge presents a very high difficulty to learn, which causes a general rejection by the young population and even the resignation that they are not capable of achieving it. The automation of processes has driven the need to hire professionals with extensive knowledge in programming, which highlights the need to create educational tools that support and encourage the learning of it, in order to solve this problem, digital educational tools arise to facilitate understanding and accelerate the learning of programming. Although there are various programming languages with very complete tools and functions, Python has managed to stand out as one of the most important languages because, although it is a simple language, it can contain a wide variety of functions, tools, and controllers that make it one of the best options to start learning programming at any age. Taking into account the above, it can be understood that although programming is fashionable and is necessary in many fields, not only in work, but in everyday life, it presents various problems in the learning process, since it is difficult to find accessible tools and a good teaching method. Some universities do not have an updated methodology guided by theory and practice, which makes the process tedious and by focusing on the development of very complex programs, academic desertion ends up being evident because from the beginning there were no clear bases. Although theoretical knowledge is very important and marks the parameters that must be followed in the area of programming, practice is vital, because from the correction of errors the student strengthens his skills and knowledge to be able to develop programs with different levels of complexity. In search of a technological solution to the problems that initially appear, Lion.PY emerges as an educational tutorial focused on teaching and learning the Python programming language, initially aimed at people who do not have extensive knowledge of programming and for this reason a theoretical-practical teaching methodology is used where priority is given to the four stages of computational thinking that will be implicit in each lesson of the tutorial, as they contain theory, video, examples and certain activities all with the objective of acquiring knowledge progressively starting from What is Python?, how it can handle the development environment, basic syntax and other thematic content up to the creation of object-oriented functions. For the development of this tutorial, WordPress will be used as the main platform, taking advantage of its great versatility and variety in the plugins available to implement specific functions that facilitate the development of a user-friendly tutorial environment, allowing the viewing and navigation of the different modules that contain a learning structure, level map, frequently asked questions, validation surveys and profile modification in the information that is managed in the database with the aim of providing a personalized experience from the editing of name or nickname and avatar. Regarding the construction of theoretical lessons, an exhaustive search is carried out in different bibliographic managers and certified information bases with the aim of ensuring the quality and relevance of the content to be taught; from the search carried out, the differences and the state of the art in the field of programming are also highlighted from a broader view of the tutorials that are already in operation. In addition, for each lesson, explanatory videos are created where the theory is broken down and with clear examples a guide is given on how to solve different situations based on computational thinking that allows a deep understanding of the topics covered, complementing everything with practical activities that allow reinforcing what has been learned. Below, this document shows in detail all the aspects included in the different stages of planning, development and validation of the educational tutorial. First, the problem, technological solution, justification, background, state of the art and different methodologies used throughout the construction process are presented. Likewise, the development of the tutorial is broken down from the creation of a schedule, evaluation of economic, technological or technical feasibility, accompanied by the different Sprints or deliverables of the progress based on the SCRUM methodology and how the validation process was carried out. This broken down information will allow obtaining a complete view of the project at each of the stages until achieving the successful implementation of Lion.PY educational tutorial in Python programming.Ítem Desarrollo de componentes de software orientados a la web y apoyo en la implementación de herramientas para la gestión documental en la coordinación general del Comité Institucional Laboratorios de la Universidad Distrital Francisco José de Caldas(Universidad Distrital Francisco José de Caldas) González Cárdenas, Julián David; Ventura Vanegas, Johan Stiven; Wanumen Silva, Luis Felipe; Wanumen Silva, Luis Felipe [0000-0002-8877-5681]The internship at the General Coordination of the Institutional Laboratory Committee focused on improving operational efficiency and document management through software development and the implementation of technological solutions. Specific objectives were established to develop software components, conduct operation tests, support API development, and enhance document management. Significant progress was made in each of these areas throughout the internship, which will contribute to improving the efficiency and effectiveness of the coordination in its daily operations. This report details the activities carried out, the results obtained, and recommendations for future actions, with the aim of providing a comprehensive overview of the internship and its contributions to the continuous improvement of the General Coordination of the Institutional Laboratory Committee.Ítem Sistema web de adopción felina para hogares de paso en Bogotá - PurrMinder(Universidad Distrital Francisco José de Caldas) Sánchez Torres, Paula Andrea; Hernández Rodríguez , Jorge Eduardo; Jorge Eduardo [0000-0002-7129-7919]The current crisis in animal abandonment is evident. Various factors, whether economic, behavioral or other, have led to many pets being in street conditions. In addition, there are notable preferences on the part of different households regarding canine adoption. This problem has given rise to the creation of foster homes, with the aim of mitigating animal abandonment and providing new home opportunities for these animals. Due to the work of these homes, they are constantly collecting data that, in the long term, become large volumes of information. This, together with other factors related to publication and adoption management, has led to the recognition of the need to propose the creation of an application. This application would aim to make felids, one of the least favored species in this situation, more visible. In addition, it would streamline certain processes within the foster homes and guarantee the correct storage of information. The project is expected to have a great impact at the Bogotá level, seeking to minimize the steps (time) and allow the organized management of information. This will positively influence the improvement of information visualization and decision making.Ítem Pasantía contrato interadministrativo 1579 de 2023 entre la Universidad Distrital Francisco José de Caldas (UD) y la Unidad Nacional de Protección (UNP) como apoyo técnico y administrativo en el proyecto tecnológico de ciberseguridadFranco Rodríguez, Valentina; Escobar Díaz , AndrésThis document addresses and analyzes the cybersecurity process within the National Protection Unit (UNP) in agreement with the Universidad distrital francisco José de caldas, in the whole process of digital transformation, a key effort to improve the provision of its services both to the State and to the people who require protection. The main challenges in terms of cyber attacks and the defense strategies implemented are highlighted. Throughout the document, the most common types of attacks, such as phishing, DDoS and malware, are detailed and the technological solutions used to combat them are described. The project highlights the importance of ensuring the security of the UNP's technological infrastructure, especially given the sensitive nature of the data it handles. To this end, tools such as firewalls, WAFs (web application firewalls) and specialized Fortinet devices such as FortiSandbox, FortiWeb, FortiMail and FortiDDoS have been implemented. These devices are designed to protect the information handled by the UNP from a variety of ways of stealing information or attacking the entity's security. Another important aspect addressed in the document is cybersecurity incident management, which is carried out through continuous monitoring systems that generate alerts and reports on possible threats. This allows for proactive intervention and rapid response to security incidents. The integration of these systems, together with the constant evaluation and adjustment of security conditions, ensures that the UNP maintains a high level of protection.Ítem Aplicación móvil para el seguimiento emocional de la comunidad de la Universidad Distrital Francisco José de caldas denominada OurHive – Emotional Diary(Universidad Distrital Francisco José de Caldas) García Romero, Daniel; Olmos Pérez, Yohan Nicolás; Hernández Rodríguez, Jorge Eduardo; Hernández Rodríguez,Jorge Eduardo [0000-0002-7129-7919]Mental health becomes vital for quality of life, and emotional intelligence emerges as an essential tool for its management. This document aims to promote emotionalliteracy and the tracking of emotions in response to the growing concern for mentalhealth, particularly following the COVID pandemic.Highlighting the significance of emotional intelligence, especially among youngindividuals, in comprehending, managing, and effectively employing emotions, this document focuses on developing a mobile application for the Universidad DistritalFrancisco José de Caldas. The concern for mental health, exacerbated during thepandemic, underscores the need to promote emotional literacy and emotional tracking.Building upon the above, the document poses the fundamental question: How toaddress emotion management through a mobile application? The objectives arecentered around promoting emotional intelligence and understanding emotions.Ítem Videojuego para el fortalecimiento del desarrollo de la lógica de programación: una experiencia interactiva de aprendizaje, Fuzzy TrailTellez Plazas, Cristian Giovanny; Rodríguez Guerrero, RocíoThis project proposes the development of an educational video game aimed at strengthening programming skills in first-year students in technology programs, as well as programming enthusiasts. It addresses the challenge of difficulty in understanding fundamental programming concepts and their impact on students' academic performance. The video game is designed as a practical and interactive tool that enables users to enhance their algorithmic skills through solving mazes and other challenges that require the application of programming logic. The project involves the creation of an algorithm generation system using Depth-First Search (DFS), interactive graphical interfaces, and a theoretical module that provides essential information on algorithms. Alpha and beta tests were conducted to evaluate user experience, and detailed feedback was collected to make necessary improvements in the game's design and functionality. The development of the project was completed within a 4-month period, and it will be freely available through web and PC platforms, aiming to facilitate access and use as a learning tool. Finally, the video game is expected to contribute significantly to improving the understanding of fundamental programming concepts and serve as a useful tool to complement formal education in this field.Ítem Plataforma web para el manejo de archivos del sitema de gestión de resultados(Universidad Distrital Francisco José de Caldas) Cruz Casallas, Maria Paula; Barrera Ciprian, Henry Ferney; Wanumen Silva , Luis Felipe; Wanumen Silva, Luis Felipe [0000-0002-8877-5681]Uploading and downloading files to and from the web has multiple functions, including improving file management in information systems to facilitate tasks such as uploading, downloading and reading on different devices. It is important to take into account the security of the files. In the case of this module, we will seek to implement security measures, such as prior identification for uploading and downloading files, and authorization to access them, as well as the use of encryption tools such as MD5, which protect files from unauthorized access and maintain the confidentiality of the information. With regard to availability, it is important to bear in mind that in an information system, availability refers to the system's capacity to be always available and accessible to users who need it. To ensure the availability of the system, different techniques and tools can be used, such as the implementation of an architecture that allows scalability and redundancy, for example, the use of a web server in the cloud or an FTP server. Also looking for an implementation of file search aids for searching files by title or keywords, techniques such as regular expressions can be used, which allow searching for specific text patterns in a file database. These searches can be faster and more accurate than full-text searches and can help users find relevant files more efficiently.Ítem Aplicación web para determinar el nivel de las competencias de inglés en estudiantes universitarios(Universidad Distrital Francisco José de Caldas) Vaca Rodríguez , Sneider Orlando; Cristancho Ipuchima , Shalom Angelica; Guevara Bolaños, Juan CarlosThe document addresses the growing importance of English proficiency in Colombia, where the government has implemented a National English Plan to improve students' language skills. Despite these efforts, the country occupies low positions in the ranking of language proficiency. The research proposes the development of a web application that helps users prepare for certification exams in English, offering varied exercises and familiarization with exam formats. A mixed methods approach is used to collect data on the acceptance and effectiveness of the application, with the goal of improving the reliability of English assessments in university students by addressing external factors that may hinder accurate assessments.Ítem Aplicación web para la negociación de la manufactura agraria a través de pago electrónico “MANUFACTURA AGRARIA”Rojas Guatavita, Glehison Wuhilder; Romero García, MariluzIn Colombia, one of the main economic branches is agriculture, which makes it important to provide tools that allow to potentialize agriculture in Colombia and leave aside traditional solutions by applying techniques based on the globalized world. Currently, the commercialization of agricultural products is done in a traditional way, making it a difficult and expensive process where direct communication between producer and final consumer is not allowed. Although in the globalized world, technologies have been designed that allow the market to expand in a more efficient way. Currently in Colombia there is a shortage of digital tools that allow to speed up the process of commercialization and negotiation of agricultural products, which leads to a low participation of the agricultural sector in the digital market, associated with the fact that there is a digital gap in knowledge and management of ICT in rural areas compared to other areas of the country. In order to solve the problem, in order to provide technological tools in the commercial and agricultural sector through a vision of implementing the knowledge acquired by the curricular project, the creation of a web application is implemented that provides electronic commerce for agricultural manufacturing, facilitating marketing and negotiation through direct communication between producer and final consumer, where an adaptive and interactive design is implemented for all types of users. The application will be developed using tools, technologies and languages such as Java, JSP, HTML, CSS and MySQL, which provide stability and solidity to the project for its execution.Ítem Desarrollo de aplicativo para integración de información de planeamiento de tráfico.Paloma Barrera, Brandon Andres; Rodriguez, RocioEfficient urban traffic management is a critical challenge faced by the District Mobility Department. Currently, key information for traffic planning is dispersed across multiple systems and formats, complicating its integration and comprehensive analysis. This lack of data consolidation significantly limits the Department's ability to make informed strategic decisions, resulting in recurring issues like vehicle congestion and prolonged travel times. Despite technological advances in data management, there is no centralized platform that allows for the efficient collection, processing, and visualization of traffic information. This shortfall represents a fundamental barrier to improving urban mobility, as it hinders effective coordination and data-driven decision-making based on integrated information. To address this issue, it is essential to develop a specialized application that facilitates the integration of dispersed information and offers advanced tools for strategic decision-making in urban transportation. This development would not only solve the current data fragmentation but also enable more effective route planning, promote public transportation usage, and support the adoption of more sustainable mobility solutions.Ítem Aplicacion web para fortalecer el pensamiento computacional programando con software y hardwareVargas Álvarez, José Luis; Méndez Ramírez , Harold Sneyder; Rodríguez Guerrero, RocioThe project arises from the need to address the difficulties faced by first-semester students of the Data Systematization program at the Universidad Distrital Francisco José de Caldas in learning programming and electronics. The lack of adequate didactic resources and the traditional separation between software and hardware complicate the teaching-learning process. To solve this problem, the development of an educational web application is proposed, with the main objective of supporting and strengthening students' computational thinking through the joint programming of software and hardware. This tool not only aims to facilitate the understanding of complex concepts but also to foster highly valued practical and theoretical skills in the job market. For the implementation of this project, the agile methodology SCRUM was adopted, which allows for efficient and flexible software development management. SCRUM is characterized by dividing the work into iterations called sprints, which usually last between two to four weeks. Each sprint includes various phases: planning, development, review, and retrospective. This approach enables adaptation to possible changes and emerging needs, assigning clear and measurable tasks to the development team in short cycles. The development of the project followed a series of structured steps. First, an initial analysis was conducted to define the modules of information, experimentation, and practice that would make up the web application. Based on this analysis, the necessary graphic pieces were designed, including code blocks, images, videos, graphics, icons, and visual styles that would facilitate user interaction. Subsequently, laboratory practices were developed integrating hardware and software, ensuring that each exercise provided a complete learning experience. Finally, interaction mechanisms between users were implemented, such as the creation of "posts," to promote collaboration and knowledge exchange among students. Each of these stages was periodically reviewed and adjusted through the sprints, thus ensuring that the final product met the outlined educational objectives.Ítem Sistema de información para asignación de recursos lúdicos(Universidad Distrital Francisco José de Caldas) Vargas Tibambre, John Edison; Guerrero Rodríguez , RocíoThere are different billing systems that incorporate recreational or gamification elements to do more the billing experience is attractive. These systems seek to motivate users through rewards, challenges, games and other interactive elements that make the process more interesting and stimulating. Some companies and developers have integrated these features into their billing systems to improve user participation and encourage more efficient and effective financial practices. The objective of this work is to create a web information system for a leisure establishment that allows and facilitate the administrator to effectively and efficiently manage the daily operations of the business, including customer management, reservations, inventory, personnel and reports. To have a comprehensive information system that meets the requirements for a leisure establishment, it is. They need the following registration modules, one as a Client, if you require the resource rental loan recreational activities, and/or a registration as a User where you can manage the web information system provided for the administrator, tools that facilitate its use and understanding such as the creation of an electronic invoice, where reports that meet certain conditions or specific criteria are displayed within a largest data set. The client has set up some filters that allow the invoices to be viewed generated. This project was developed with the RUP methodology and applying the knowledge acquired in our career. as a degree project.Ítem Desarrollo de una aplicación móvil para apoyar el aprendizaje de la notación musical. (NOTENBLATT)Duarte Polo, Gian Franco; Tejero Gómez, María Fernanda; Rodríguez Guerrero, Rocío; 0000-0002-2956-9650This document presents the mobile application NOTENBLATT, designed to support the learning of musical notation, which will be available for mobile devices with Android 8.0 ("Oreo") operating system. The project development will be guided by the SCRUM methodology. The objective is to provide students and/or individuals interested in learning this system up to a basic level, allowing users to acquire the relevant skills to interpret a musical score. The NOTENBLATT application has the following functions: • Register users who wish to enter the application. • Allow access to users previously registered in the application. • View and modify user information. • View available achievements. • Display the user's progress according to their advancement within the application, as well as their responses to quizzes. • Access lessons to consult their information. • Access quizzes to validate the learning developed in each lesson. • Implement notifications to make navigation within the application more enjoyable, providing an explanation of the available functions on each window to the user.Ítem Aplicacion movil para la generación de alertas frente a situaciones de acosoRios Matta, David Santiago; Ayala Clavijo, Nicol Estefanny; Vanegas, Carlos AlbertoThe application was developed with the aim of helping entities manage the safety of their employees or students in cases of harassment or emergency in real time. It allows entities to create or grant control of the app to the area they consider relevant. This application allows users to send an alert with a single touch, thus sharing the real-time location with the entity and allowing it to take the necessary measures instantly. It has functionalities such as the panic button, which allows the user to send the alert. In addition, user management includes secure Firebase authentication, thus differentiating roles between users and entities. The incident history allows viewing of incidents reported to the entity with the username. Real-time notifications ensure a timely response. This solution offers a preventive approach and a better response to dangerous situations.Ítem Aplicación web para la administración de recursos empresariales en la empresa Crazy BarberyMoreno Ruiz, Deybid Santiago; Vanegas, Carlos AlbertoIn this internship, the creation of a web application for the management of business resources in the Crazy Barbery company was proposed. Through the different modules of the application, the necessary operations for the company could be incorporated, resulting in a web application with user validations. complete navigability and functionality. Thus helping the Crazy Barbery company to improve its operation from IT.