Get Latest Final Year Projects in your Email

Your Email ID:
PA Subs

Electronic Student Academic System (E-SAS) For Secondary School in Excel (Computer Project)

Download Project:

Fields with * are mandatory

ABSTRACT

Nowadays computers are used to manage daily works. School management uses computer to process academic assessments. For example, teachers store students mark and grades in computer software such as Microsoft Office. However computers are merely used to store students assessments and there are no systematic place for analyzing and turning that data into information and knowledge.

Therefore, Electronic Student Academic System (E-SAS) is developed to facilitate teachers and administration staffs in managing students’ profile and academic assessments. Two types of assessments are included in E-SAS which are mid-term test and final year test. E-SAS which follows Rational Unified Process is implemented using Hypertext Pre-Processor (PHP) and MySQL software. As a result, users find that E-SAS is capable of displaying and searching student information. It also can calculate and produce assessments reports for each type of tests.

CONCEPTS OF THE SYSTEM 

This section presents the concepts behind E-SAS.

Smart School

The smart school concept is one of the seven flag ship application that are part of Malaysia’s Multimedia Super Corridor (MSC) project. The purpose of smart school is to develop skilled workers for the Information Age and to fulfill the goals of the National Philosophy of Education. It is means that the teaching and learning practices and school management must be systematically reinvented.

Academic System

Malaysian school uses written based assessment to evaluate student academic performance. There are two categories of written assessments which are school level assessment and national level assessment. National level assessments for secondary school are Penilaian Menengah Rendah (PMR) and Sijil Pelajaran Malaysia (SPM).

Data Management

Organizations today operate in a highly global, fast-paced and competitive environment. One of the key resources they need to perform their tasks effectively and efficiently is data management. Data management is a terminology that usually use for referring to the system, which provide the interface that able to hide specifically physical file operation, hence they can fully concentrate to the data logical.

METHODOLOGY

Fig 1. Use Case diagram for E-SAS

Fig 1. Use Case diagram for E-SAS

E-SAS applies three fact-finding techniques in gathering functional requirements. These techniques are interviews, sampling of existing documentation, forms and files, and observation of work environment. The requirements are then analyzed and designed using Unified Modelling Language (UML). Two outputs are designed in this stage which are use case and sequence diagrams.

Fig 2. Sequence diagram for Add Student Profile

Fig 2. Sequence diagram for Add Student Profile

Fig 4 Interface for super admin (school clerk)

Fig 4 Interface for super admin (school clerk)

The sequence diagrams for E-SAS are shown in Fig 2 and Fig 3 respectively. The sequence diagram in Fig 2 shows interaction for super admin to add student profile. Super admin is responsible to enter information of the students. The interaction that occurs is as follows: First, super admin must select add student profile menu that display at main page. Then he can key in student info into student profile form and click the ‘save’ button to submit it into the database. After that, student profile will be saved in database.

SYSTEM OUTPUT AND RESULT

This section presents the output and result from the implementation of E-SAS. E-SAS has three types of users which are school principal, clerk and class teacher. The system is capable of:

(i) Adding student profile and academic information for future reference and enhancement.

(ii) Updating and searching student information including personal information and student result.

(iii) Providing the security of information about student profile and academic result that are kept in database.

(iv) Adding student marks and calculating total marks of all subjects.

(v) Arranging the ranking of student in class.

CONCLUSION

E-SAS has been developed to replace the manual system in managing student profile and assessments evaluation. E-SAS saves teacher’s time to manage student assessment process compared to the manual practices. The computerized records provide better management and manipulation of data, through searching of student profile and generating of class ranking. Student profile is stored in a secured database compared to the traditional file based system. Future enhancement to the E-SAS functionality includes adding another interface module specifically for subject teacher to key in student mark and automatically submits them to the class teacher.

Source: Putra University
Authors: Junaida Sulaiman | Roziatul Hasmat Mat Yamin | Noorhuzaimi Karimah Mohd Noor

Download Project

>> List of Final Year B.E/B.TECH Student DBMS Projects using Excel

Download Project:

Fields with * are mandatory