Ingeniería de Sistemas

Permanent URI for this collection

https://usc.scimago.es/handle/20.500.12421/51

Browse

Now showing 1 - 20 of 113

TDM: dispositivo educativo para aprendizaje de las tablas de multiplicar en 3ro de primaria caso de estudio: colegio bilingüe san José campestre
(Universidad Santiago de Cali, 2019) Pitto Giraldo, Johann Fernando; Cuero Cortés, Alex; Saint-Priest, Yana Elida
Learning the multiplication tables in some elementary school children has always been a pedagogical problem for third grade primary school students. This has motivated several researchers to look for alternatives to find the right solution, this being the aim of the present project. It is proposed to include TIC in the teaching of multiplication tables through a technological tool focused on autonomous and dynamic learning in a didactic and entertaining way; using an interactive web resource that includes a candy dispenser that will reward the good results obtained by motivating children in learning. It is a hardware component, device, and software tailored to the students' taste and to the teachers' requirements to facilitate learning. The TDM device was designed with a layered architecture and uses a controller view model as a design pattern, allowing it to be adaptable to changes, improvements and expansions that are generated over time. The resulting design became an important tool for teaching multiplication tables in the school, being novel and didactic as a methodological system
Software de gestión administrativa de seguridad social para cooperativas de trabajo asociados y empresas afines
(Universidad Santiago de Cali, 2019) Valencia Bonilla, Walter; Lozada Gutiérrez, John Jairo; Dinas, Simena
The Associated Labor Cooperatives (CTA), are defined as “non-profit associative companies, which link the personal work of their associates and their economic contributions for the production of goods, execution of works, or the provision of services in a self-managed way” (Farné, 2008, p, 262). Within the framework of Law 100, they are the means by which independents make contributions to the Comprehensive Social Security System, which is done manually, which generates errors in the individual liquidation of each contributor, such as errors of personal data, double payments for the same user, user payments without receiving the respective advance collection, making user contributions to the wrong EPS and AFP and making payments for greater value or less value. The article consists of the development of an Integral Social Security Management and Administration System for the adequate liquidation of social security contributions called “SISSI” “Information System on Integral Social Security”. The methodology used for the development of “SISSI” is “XP” (Extreme Programming), it is a software development discipline based on simplicity, communication, feedback and continuous refactoring of code, which involves the end and maximum user Group work. Before the implementation of “SISSI” when evaluating 3 companies with a monthly average of 100 affiliated contributors, an average of 13% of errors in individual settlements were presented, generating cost overruns and administrative reprocesses, then reduced the margin of error to 2% in its operations, with a benefit of 92% for the use of the “SISSI”.
Desarrollo de un aplicativo web para asignar salones de clase en la Universidad Santiago de Cali
(Universidad Santiago de Cali, 2019) Sánchez Quirama, Eulises; España Urrea, Jhonattan; Ospina López, Orlando
At present the assignment of classrooms in institutions of higher education presents a very serious problem, because it is usually done manually. At the Santiago de Cali University, this assignment is done based on the office Excel tool, this process is carried out by the University Services Department and it takes a long time to make an acceptable assignment to each academic program. After this, each academic program uploads the information to the university system and this means that the process is not as efficient. In this project a web application was designed and developed that allows a more efficient allocation to be made directly by each academic program, using an entire programming model taking into account certain restrictions by means of a calendar assignment, allowing consultations, create rooms, generate reports, minimize errors and crossings of schedules between different courses.
Inteligencia de negocios como apoyo a la gestión del transporte masivo en la ciudad de Cali-Mio
(Universidad Santiago de Cali, 2019) Vásquez Ramírez, Neider; Dinas, Simena
Organizations use technology as a solution to improve efficiency and optimize their operational processes. One of its greatest inefficiencies and opportunities for improvement is hidden in the ability to manage and present the data stored in its databases. Mobility in the city of Cali has as one of its axes the integrated mass transport systems, these systems are applied to a series of means of transport, to move people in short times. They are composed of Mio Cable and Mio. This document describes how through the systems of Business Intelligence and the analysis of large volumes of data in the fields of mass public transport, efficiency in data management and analysis can be improved to make better decisions regarding the operation and service provision. The central focus of the work was to consult various academic articles on the aspects of implementation of a Business Intelligence system in the processes and activities of providing the mass transport service and how to improve their competitiveness to make better decisions through analytical reports, strategic and operational dashboards, designed to visualize and transmit the information to the directives of the entity and users that require it.
Transformación Digital aplicando E-Marketing al proceso de ventas de la empresa Mikino Moda Fashion
(Universidad Santiago de Cali, 2019) Belalcázar Hurtado, Magda Cecilia; Cubillos Mena, Andrés Felipe; Alzate Sánchez, Juan Camilo
The use of mobile applications has become part of the daily life of people, in this era where digital transformation is necessary for businesses that want to remain in force, as customers who are digital, use their mobile devices every day to see videos, request food or transportation, listen to music, pay bills, etc. In this article, you can find a comparison of other applications of digital electronic commerce (m-commerce) that has become a new economic mode, especially with the increase in online shopping [9]. The agile Scrum methodology was used to obtain the development of a mobile application prototype for the Mikino Moda Fashion store sales process, in the planning phase, which allows the product owner to have a functional version of the product that adds value.
Diseño de un prototipo para el Control de Acceso y Seguridad usando IoT
(Universidad Santiago de Cali, 2019) Gallego Angulo, Larry Jhoan; Tavera Romero, Carlos Andrés
This article presents the prototype design of a system for access control and security using IoT (Internet of Things), taking into account the case study of the Santiago de Cali University laboratory of block 4 floor 3. This design is It consists of a web portal hosted on a web server for administration, two readers, the central and an input module and a web server. The objective was to design a system that allows us to control the entrance and exit of the laboratories through the UUID (universal unique identifier) of the Tag or RFID Card (radio frequency identification), this is consulted from the reader or by the EEPROM memory or in MySQL database. EEPROM memory guarantees the operation of the system, if the reader is not connected to the network to authenticate in the database hosted on the server, the input readers are made with an Arduino card and the central reader with a board Nodemcu; The central reader has nodemcu board and RFID reader, the door reader has an Arduino card, RFID reader, RGB LED, Reset button. The communication of this system is via Wi-Fi, achieving productivity in the execution of the processes. This article will show the operation of the modules connected to the server via Wi-Fi and the input module in the EEPROM, to design the web portal it was necessary to create an Apache server on a Raspberry PI board and, the web portal was programmed with PHP and HTML5, CSS in a Bootstrap 4 Framework to have a Dashboard.
Desarrollo de una plataforma web para la gestión de proyectos de grado para la Universidad
(Universidad Santiago de Cali, 2019) Albarracín Arroyave, Andrés Felipe; Peña Soto, Alejandro; Loaiza Buitrago, Diego Fernando
This Project aims to develop a web platform to management of degree projects taking into account the identified need of the Faculty of Engineering of the University of Santiago de Cali, as it does not have a control or management of the degree workers developed within the program in terms of process agility, evaluation, systematization and automation; therefore, an analysis of the process and current state of the university is executed, obtaining as a result the need to develop software using artifacts from the agile methodology of development "Scrum" that allows to go directly to the fulfillment of the objectives. To do this, comparative tables are initially exposed in which the main characteristics of each of the models / tools are visible and why the software with which the research is carried out is chosen. It also shows the phases of development executed in the program, the advantages, qualities, contributions and developments that the university can access with the use and implementation of the platform.
Pharos - desarrollo de una herramienta web para el diseño y ejecución de exámenes basados en la evaluación por competencias para el 5° grado de la Institución Educativa Julio Caicedo Tellez
(Universidad Santiago de Cali, 2019) Córdoba Santamaría, Rodolfo; Cardozo Agredo, Luis Eduardo
Currently, the national board of education (MEN) has a goal which name is “Colombia the best-educated for the year 2025” with the purpose of enhancing the quality of the undergraduate preparation. The ICFES assesses the official Educational Institutions (IEO) through a test known as SABER available for 3rd,5th,9th and 11th graders. The official Educational Institution Julio Caicedo and Tellez from Cali, Colombia has not met the desired requirements for such test in the 5th grade, where weakness in the area of language and math are evident. Therefore, they have decided to implement the use of Technologies of Information and Communication (TIC) as a strategy to trace the academic process. The following article shows the analysis, design, and development of a web tool that creates and executes tests based on competencies for students in the 5th grade of basic primary education. In order to fulfill the objective, an analysis was performed to verify the need for implementation of a tool in the institution that allowed to finally start its development using an Agile Unified Process (AUP) methodology and some SCRUM elements, giving as a result, a modern architectural design that allowed the development of a functional prototype which was perceived positively by the institutions faculty by meeting the principal functionalities required and the market required standards.
Nutricom: aplicación que recomienda alimentos saludables a partir de reconocimiento de alimentos en imágenes para evitar enfermedades
(Universidad Santiago de Cali, 2019) Manyoma Navia, Javier Andres; Priest Velásquez, Yana Saint
The poor nutrition and feeding has become one of the great problems of modern life, causing a number of diseases and accelerating the transformation process. It is proposed to solve the problem with the implementation of a mobile application, based on artificial intelligence, which employs visual recognition of images suggested food intake or not, according to the user's profile including diseases, eating habits. The objective of the project was to classify the foods present in an image and calculate their caloric value to suggest healthy and nutritious foods. The methodology used was in cascade or life cycle, since it is the most common and oldest software development, and is widely used. The NUTRICOM mobile application can be integrated with the Watson API, visual recognition of food images, taking advantage of its ability to recognize more than 2,000 foods and "train" with it. Through the application, people can learn to eat well according to their profile. In conclusion, it can be said that for the visual image recognition API to have a correct operation, you must carry out a training or learning of at least 50 images per food
Diseño y desarrollo de la app salsacali
(Universidad Santiago de Cali, 2019) Buelvas Caceres, Liseth Biviana; Segura Angulo, Yennyfer Alexandra; Tavera Romero, Carlos Andres
Cali is internationally recognized as the world capital of salsa, however, despite this recognition, this musical genre has lost strength in the city. There are currently many people who are unaware of the cultural, social and economic value that salsa represents for Cali as well as all the development and evolution that this musical genre has had in the city. The emergence of new musical rhythms such as merengue, bachata and reggaeton, salsa in Cali has been overshadowed: through contact with youth it results in many young people not considering or not seeing in the sauce more than just one more genre, or even not important to attend such events. In order to carry out this research, the problem was studied based on the analysis of real and direct data (collecting user opinions) and some believe that this fact has degenerated the salsa identity and this has happened in the background. In order to contribute a little to the fact that the Salsa culture is still valid, “Salsa Cali” is an application oriented to mobile devices, the development of this one was raised to achieve greater dissemination of salsa events in Cali, and contribute a little to that the salsa culture remains in force in a striking way such as a mobile app. It was initially developed for Android mobile devices, a viable medium where development of this type of applications is generally started. It is usable in Smartphone, maintaining usability and aesthetics. Considering the portability, availability and use of mobile Apps, it allows organizers to socialize activities first hand, gives the user the opportunity to consult information about events and places related to salsa events, learn about the history of salsa and songs emblematic Users within the application have access, among other functions, to the creation of a user, information on scheduled events (place, price, public and time), you can also know in advance the details of the site where the event will take place, the people capacity and reservation
Aplicación móvil para promover el deporte en los gimnasios públicos y senderos de Cali, (GymGo! Cali)
(Universidad Santiago de Cali, 2019) Salgado Blanco, Wilson Stiven; Vásquez Estrada, Diego Fernando; Zúñiga Cañón, Claudia Liliana
The trails and bioparks are free spaces designed for the use of population in physical activities and welfare; however, there is ignorance of the proper use and location of them. GymGo! Cali is a mobile application to promote recreation and sports, contributing in this way to the improvement of the quality of life of the people of Cali. Through interactive components, GymGo! Cali allows locating and knowing the outdoor spaces arranged by the municipality for recreational and sports activities. The application requires user registration, which includes some basic aspects of their physical condition and provides a series of routines appropriate to the body mass index of each user, accompanied by an instruction for the proper use of exercise machines. Additionally, it has a space for social interaction where you can share training routines, create sports groups or simply interact with people who are close to the user. This application will be free to use and accessible to all citizens who have a smart mobile device with Android operating system, regardless of age and socioeconomic limitations, but taking into account that any physical activity that you make using the instructions. This will be under the responsibility of each user and should always be accompanied by good nutrition and hydration to obtain satisfactory results.
Estado de implementación de la ley de protección de datos en 100 empresas representativas de los sectores público y privado de Cali
(Universidad Santiago de Cali, 2019) Alcalde Mejía, Cristhian; Dussán Clavijo, Ciro Antonio
Currently, due to the technological era, information has become a very important asset for companies due to the benefits that can be obtained from its analysis, due to the large amount of personal, private and sensitive data that may affect the fundamental rights of people, the governments of the world have taken the initiative to create laws aimed at protecting this information, known as the data protection law. In this article we will talk about the data protection law of Colombia (Law 1581 of 2012) and about the state of its implementation in 100 representative companies of the city of Cali, from which it was concluded that 82% of the sample complies with the implementation of this law, demonstrating a considerable implementation regarding the data protection law on the representative sample taken from Cali, Colombia
Análisis y diseño de sistemas de información para la gestión, seguimiento y control en tiempo real de las ventas realizadas en microempresas
(Universidad Santiago de Cali, 2019) Zambrano Castillo, Jhorman Alexis; Loaiza Buitrago, Diego Fernando
One of the main disadvantages for Micro-entrepreneurs is not having a tool that allows them to keep themselves well informed about the fundamental activities of their business in a timely manner, which allows them to make sound decisions that add value to their business. The purpose of this article is to present the analysis and design of an integrated web information system coupled with a mobile application for an application (APP) cell phone and tablet compatible which will allow the entrepreneur to manage, track and control information in real time (24/7); providing management indicators for decision making. To achieve these results, an agile methodology of Scrum projects was used through the process of collecting information pertaining to the needs and new ideas of the small companies, which then was used to design the system. This will ensure that micro-entrepreneurs have immediate access to minute-by-minute information of all critical processes, decrease loss of sales when viewing products to replace, or existing in warehouse, to exercise control over existing inventories, increase sales closing rates through managing potential customer’s point of contact, in addition to having a powerful tool to generate proper reports and queries of vital information of the company
Implementación del modelo disaster recovery as a service - draas para la infraestructura it en servicios backoffice: caso estudio empresa sector giros postales
(Universidad Santiago de Cali, 2019) Gutiérrez Campos, Anderson; Ramírez Giraldo, Jethferson; Dussán Clavijo, Ciro Antonio
The purpose of a DRaaS solution is to provide efficient and low-cost tools to technology departments based on providing availability to critical services of organizations that may be affected by disaster interruptions; At present, the DRP implementation initiative has a high priority and is a strategic need for companies; The present investigation tries to demonstrate that the implementation of the DRaaS allows to determine the indicators of compliance of the technology, as well as the fulfillment of the objective time of recovery and the objective point of recovery before incidents or catastrophes. A research methodology built from the measurement of the application availability indicator at critical time is implemented; Based on the analysis of the current state of the technological infrastructure, inventory of servers and critical services for BackOffice processes, evaluation of supplier proposals and cost evaluation of a DRaaS solution compared to a traditional DRP solution. Once the previous data has been collected, the risk assessment and the business impact analysis are carried out. The technical requirements that must be implemented in the DRaaS solution will be evaluated in order to meet the efficient operation of IT services. Finally, the implementation of the DRaaS generates significant savings in the renovation plan of the technological infrastructure equipment for the organization, as well as a model oriented towards the fulfillment of the strategic indicators.
Auditoria de TI Basada en estándares mínimos de COBIT 2019: Caso de Estudio Empresa de Servicios del Valle del Cauca
(Universidad Santiago de Cali, 2019) Díaz Artunduaga, Milton Fabián; Dinas, Simena
An Audit is an evaluation of a specific area of an organization with the objective of knowing the veracity of the results and generate useful indicators to improve the processes of a company. The audit is specialized according to the area and disciplines; in the case of IT audits, they are responsible for conducting a review of IT resources in order to identify the situation in which they are developed based on current regulations. They are classified in internal and external audits; however, this kind of audit is characterized by the implementation of an information governance framework with the aim of facilitating the information management process and reliability to generate a clear methodology. COBIT, 2019 is then proposed as the most recent version of the Framework for users, administrators and auditors of information systems, regulating good practices, providing standards for the compliance of information and communication processes are part of the most widely used control methodologies at the international level exposed by the Information Systems Security Association (ISSAI). This article presents the results of the evaluation of the company's IT control environment in order to measure the security of the applications and identify improvement options that allow optimizing processes, controls and security in general in the technology area. The audit was conducted according to best market practices; and the reference framework for Government and IT Management: COBIT 2019, with the objective of evaluating compliance with the minimum standards implemented in the company, also exposes the results of meetings, the process of compilation and validation of supports, the findings found during the generation of the report of recommendations according to the methodology implemented.
Diseño e implementación de un dispensador remoto de alimento y agua para perros en la plataforma Arduino
(Universidad Santiago de Cali, 2019) Quintero Chocue, Wilder; Torres Stuar, Eric Steven; Dussán Clavijo, Ciro Antonio
This project aims to ensure the feeding of our dogs, through a mobile device that remotely controls a dispenser, supplying water and food regularly according to the need. It has a food capacity corresponding to 3kg, the water is provided by the house by connecting the device to a tap and will be controlled by the user according to the need of the can, these specifications give us autonomy for 2 days of food supplies if the dog is of medium race. The project is executed under the cascade model, guaranteeing an orderly and sequential approach, rigorously following each of its stages. The device provides total freedom and tranquility to the owners of the dog allowing them to feed at a distance for several days, ensuring adequate nutrition and welfare of the pet with a product that is easy to use, provides services and is friendly to the environment his composition.
Automatización robótica de proceso, aplicada al proceso de cierre de seguros soat usando automation anywhere enterprise
(Universidad Santiago de Cali, 2019) Fajardo Mayor, Jhonnathan Steven; Alomia Angulo, Dogildo Klinio; Rojas Montes, Javier Salvador
In the present work, the development of a robotic process automation for the improvement of the Closing process will be presented, in which the total registered daily sales of Compulsory Insurance for vehicles that were loaded to the CSIS systems in the Morning Hours are concluded, which is made up of a routine that is executed daily, which can be executed on demand or programmed to be executed automatically, in the private company's service area. In addition, to perform automation, a robotic process automation (RPA) tool, called Automation Anywhere Enterprise (AAE), is used. Also, to determine the results of this process with the proposed technology, the concepts that cover this automation technology, the Cascade methodology and analysis that were applied for the development and implementation will be presented in order to obtain the best cycle time of the process and minimize errors by validation and manual information registration
Sistematización de la asignación del recurso humano ingenieril y técnico, para proyectos de tecnología. Caso de Estudio: Spectra Ingeniería Ltda
(Universidad Santiago de Cali, 2019) Potes Buenaventura, Diego Javier; Priest Velásquez, Yana Saint
The activity of associate task to the employees of a company or human resource allocation, for organizations that base their operation on projects, could be more agile if their having tools that allows centralize the information, to get access to the information to a practice way, getting that the management of the allocation of the resources be optimal and become efficient during the execution of the required projects. It is proposed then, the development of a software tool that allow make the assignment of the human resource to the projects, having in a count the capabilities or knowledges of the staff, getting too a control of the times and activities, to finally get an adequate management of the human resource assignment to the projects. Through the application of the prototype methodology, is achieve systematize the assignment of the engineering and technical human resource, to the projects of the Spectra Ingeniería Ltda. company, obtaining as a result an application that allow give fluidity to the process of the personal assignment. The tests performed on the application through the management of 25 projects, including the respective assignment of activities and personnel to each one, produced the expected results during the investigation. The development of the application allowed to identify additional processes that affect the times of the projects and that could be included as modules that will offer development improvements
Modelo de plan de continuidad para un sistema de almacenamiento y comunicación de imágenes diagnósticas
(Universidad Santiago de Cali, 2019) Aquite Bedoya, Jorge Armando; Nañez Encalada, Isaac Hernán; Loaiza Buitrago, Diego Fernando
Currently the most efficient and safe way to have control and record large volumes of diagnostic images that are performed in a health institution is through a picture archiving and communication system known as PACS (Picture Archiving and Communication System). Being this a system that is supported in the technological infrastructures, it is necessary to have procedures that allow to continue the normal flow of the operation of the service, preventing or mitigating the adverse events that may occur and also allowing a recovery of the normal state of the operation. These procedures will be consigned in a continuity plan that will be designed based on some of the subprocesses of Risk Management and Continuity Management, both processes from Service Design from ITIL V3. Under this methodology, the risks were evaluated according to their level of impact and probability of occurrence, achieving to develop a more concise plan focused on the containment, management and recovery of an adverse event.
Aplicación móvil para seguimiento, monitoreo y control de rutas de vehículos. Caso de estudio: empresa línea comunicaciones S.A
(Universidad Santiago de Cali, 2019) Landazuri Diaz, Diego Alexander; Priest Velásquez, Yana Saint
That companies of telecommunications subcontract persons who vehicles for the mobilization of its personnel and material of work, nevertheless, this situation does not allow to have a strict control on what really it happens with the vehicles and the material. There is proposed then the development of a technological program that tackles the subject-matter of intelligent labor mobility from the perspective of as the mobile programming and the systems of telecommunications, they allow the collection of data in real-time of factors such as: Distance travelled, Location of the mobile and route management. The structure of the application, named GeoLinea, it was developed from two ambiences coherently linked: In first stay and using the Java Programming Language the app was designed in the Android Studio environment. Currently the application is in the test with the staff of the company.

Browse

Browsing Ingeniería de Sistemas by Issue Date

Results Per Page

Sort Options