QC & Admin Work

In this Technological era, it is an obligation for all companies and services providers to transform towards Digitalization and Automation to cope with surrounding advancements and to make use of new technologies to minimize efforts, time, costs, human error and improve overall procedural and work flow efficiency. In this context many projects have been applied using Python programming language used for data analytics and automation of different processes to improve Quality control procedures and Admin work system admitted to Institute of Maritime Upgrading Studies in the Arab Academy for Science Technology and Maritime Transport

Project 1

Report on the progress of the educational process

Aim: This project improves procedures of lecturers questionnaire. The main aim of this project is to change the procedures to paperless, minimizing time, effort and costs and solve some problems related to external part-timers.

Functionality: This script download signature images from google drive through shared links stored in one column inside excel sheet as a response from the senders. so it parse each cell, download image into external folder and insert path of this image file into corresponding cell inside the same excel sheet to be ready for mail merge.

Tools / libraries: Google drive - google forms - Python Programming language - Excel sheets - Word Documents / Pandas-  Gdown - PIL - OpenPyXl

Github link: https://github.com/Ahmad-Moussa1/Report-on-the-progress-of-the-educational-process 

Project 2

Automating and Digitalizing Students Questionnaire

Aim: This project improves procedures of student questionnaire. The main aim of this project is to change the procedures to paperless saving time, effort and costs and minimize human errors. Moreover, Analyze data and extract reports regarding students opinions to improve educational processes through determining weak points and recommending corrective action plans to overcome problems.

Functionality: The script parse excel temporary files that contain Questionnaire responses from the students and map the qualitative values into quantitative values to be ready for analysis. the outputs are stored in separate excel sheet that is linked to  another analysis sheets.

Tools / libraries: Google drive - google forms - Python Programming language - Excel sheets. / OpenPyXl

Github link: https://github.com/Ahmad-Moussa1/Automating-and-Digitalizing-Students-Questionnaire 

Project 3

Student Attendance Management System

Aim: Transform digitally from paper procedures to paperless procedures for recording attendance of students, which will help in reducing costs and minimizing human errors. this system will enable for continuous monitor and more analysis capabilities that gives more control measures to management level and help them make decisions based on real data.

Functionality: it is windows console application developed  python 

Tools / libraries: Google drive - google forms - Python Programming language - Excel sheets. / Tkinter - openpyxl - xlsxwriter- pandas

Other Projects are under developing and continuous monitoring for applied projects are situated in a user friendly dashboard to enable the management level to monitor current status and make decisions for future concerns.