-
Essay / Automating the semester summary of a course
ABSTRACTExcel is one of the most common input data management programs. Depending on the size of the organization and strategic operations, Excel may not be the best solution because its limitations are very defined. Since effective operations rely on legitimate and clear reporting summaries from business tasks, it is necessary to have automated database systems that will be used to capture data to improve performance. Say no to plagiarism. Get a tailor-made essay on “Why Violent Video Games Should Not Be Banned”? Get the original essay The Department of Computer Science at the Namibia University of Science and Technology currently captures students' semester results summary in a flat file. The number of students increasing rapidly in the department over the past two years. The department is having difficulty analyzing student results. The process of developing summaries from a flat file is now time-consuming and has a negative impact on departmental performance. The Department of Computer Science at the Namibia University of Science and Technology is seeking a software solution that automates the summarization of a course's semester results. ScopeThe system will enable the automation of the summary of the semester results of a course. It will make the department's activities more efficient. covering the most important disadvantages of the manual system, namely speed, precision and simplicity. This document contains a minimum set of features/functionality that the system must provide and a set of non-functional requirements that the system must meet. GOALS AND OBJECTIVES. To save time in processing the student's results summary report.II. Design a system that will minimize the amount of manual entry required to process student results.III. Facilitate student course summaries with fewer errors.IV. To enable accurate data capture by users.FUNCTIONAL REQUIREMENTSSI. Allow users to add, update and delete information regarding each student information II. View information about a specific student III. Show the number of students who took or did not take the exam for a specific courseIV. Allow the user to view the number of students enrolled in the courseV. View summary information about courses offered in different semesters based on student grades VI. Calculate average percentages for semester, exam, and final grades for a certain course based on redefined ranges.VII. Capturing semester, exam, and final gradesVIII. Generation of the success rate reportIX. Draw a graphical representation of the average percentages for the semester, exam, and final grades for a certain course based on redefined ranges.Non-Functional RequirementsI. DeploymentThe system must be able to operate on Windows and IOS platforms.II. SecurityIt should be ensured that only users with specific rights can access the data. Users must be given the password by the administrator.III. BackupThe database can crash at any time due to a virus or operating system crash. Therefore, it is necessary to perform a database backup. Hardware Requirements I. Intel CORE i3 processor with a minimum speed of 2.9 GHz.II. RAM: 4 GB minimum III. Hard disk: min 30 GBSoftware requirementsI. Operating system: Windows 7/8/10 and all IOSII. Microsoft SQL Server 2014 or latest.: _____/_______/_______