CHMSC Binalbagan IT Freshmen Admission System Document Chapter V

CHMSC Binalbagan IT Freshmen Admission System Document Chapter V

The main purpose of this study Admission System Document Chapter V is to develop a Chmsc-bin IT freshmen Admission System that help registration easier and for taking the qualification exam more easily it is also preserve all the information of the students or reports.

Objective 1 

The general objective of this study is to develop a CHMSC-bin IT freshman to help manage registration and have their reports instantly, effectively and efficiently.

Conclusion 1 

Based on the objective, the main point is to develop the feature of the system and enhance the work that can make fast and accurate registration in processing.

Recommendation 1 

Based on the result, the researcher could therefore conclude that the system was an effective registering system for the CHMSC-bin for it provided reports needed by the admin.

Objective 2 

The first specific objective of the study is to design the recommended features of the system.

Conclusion 2 

Therefore, based on the result of the evaluation, the designed is much appealing to the user and it was easy to use. The user could easily familiarize how the system works.

Recommendation 2 

The researchers recommended that this kind of design was better for making a system. The design must be simple and must be easy to use.

INTERNET REFERENCES

[1]. Mane (2000) “monitoring record” where in the Philippines. Retrieved from http://thesisbook.readthedocs.io/en/latest/Chapter%20II.html

[2]. Forman (2007) “Web based Enrollment System(WBES). Retrieved from http://thesisbook.readthedocs.io/en/latest/Chapter%20II.html

[3]. Lovelock, wirtz Chew (2009) “Enrollment computerized” retrieved from https://www.academia.edu/20047798/Web_based_Enrollment_and_Billing_System_Chapter_II

[4]. Graysail (2010) “Schedulingretrieved from https://www.academia.edu/20047798/Web_based_Enrollment_and_Billing_System_Chapter_II

[5]. (2011-2012) “The schedule system of john Hop kin’s university” retrieved from https://www.academia.edu/9162628/Chapter_2_Review_of_Related_Literature_and_Studies

[6]. Lopez (2005) “registration” retrieved from http://thesisbook.readthedocs.io/en/latest/Chapter%20II.html

APPENDICES

Appendix A

Relevant Source Code

STUDENT LOGIN
<!-- wp:paragraph -->
<p>&lt;?php</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>session_start();</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>// define variables and set to empty values</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>$Message = $Erroremail = $Errorpass = "";</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;if(isset($_POST['user'])){</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>if ($_SERVER["REQUEST_METHOD"] == "POST") {</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;$email = check_input($_POST["user"]);</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;if (!preg_match("/^[a-zA-Z0-9_]*$/",$email)) {</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$Erroremail = "";&nbsp;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;}</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;else{</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;$femail=$email;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;}</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;$fpass = check_input($_POST["pass"]);</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;if ($Erroremail!=""){</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;$Message = "Login failed! Errors found";</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;}</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;else{</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;include "include/connect.php";</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;$query=mysqli_query($db,"select * from `student` where username='$email' &amp;&amp; password=sha1('$fpass')");</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;$num_rows=mysqli_num_rows($query);</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;$row=mysqli_fetch_array($query);</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;if ($num_rows&gt;0){</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;$Message = "Login Successful!";</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;}</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;else{</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;$Message = "Login Failed! User not found";</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;$_SESSION['message']=$Message;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;unset($_SESSION['fname']);</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;unset($_SESSION['lname']);</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;session_destroy();</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;include "login.php";</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;}</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;}</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>}</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>}</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>function check_input($data) {</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;$data = trim($data);</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;$data = stripslashes($data);</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;$data = htmlspecialchars($data);</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;return $data;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>}</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>?&gt;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&lt;center&gt;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&lt;?php</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;if ($Message=="Login Successful!"){</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;$_SESSION["fname"]=$row['fname'];</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;$_SESSION["lname"]=$row['lname'];</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;$_SESSION["id"]=$row['stud_id'];</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;$_SESSION["code"]=$row['examinee_code'];</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;// echo $Message;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;// include "index.php";</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;//include "footer.php";</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;?&gt;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&lt;script type="text/javascript"&gt;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;alert("Login Successfull.");</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;window.location = "index.php";</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;&lt;/script&gt;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;&lt;?php</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;}</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;else{</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;&nbsp;&nbsp;echo $Message;</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>&nbsp;&nbsp;}</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>?&gt;</p>
<!-- /wp:paragraph -->

STUDENT REGISTRATION
<?php
include "include/connect.php";
session_start();
if (isset($_POST['submit'])) {
  if($_POST['pass']!=$_POST['rpass']){
                         ?>
    <script type="text/javascript">
      alert("Password Doesnt Match!.");
      window.location = "register.php";
    </script>
                         <?php
  }
    $fileName = date("Y").date("m").date("d").$_FILES['PICTURE']['name'];
    $errofile = $_FILES['PICTURE']['error'];
    $type = $_FILES['PICTURE']['type'];
    $temp = $_FILES['PICTURE']['tmp_name'];
    $myfile =preg_replace('#[^a-z.0-9]#i', '', $fileName); 
    $location=$myfile;
        @$file=$_FILES['PICTURE']['tmp_name'];
        @$image= addslashes(file_get_contents($_FILES['PICTURE']['tmp_name']));
        @$image_name= addslashes($_FILES['PICTURE']['name']); 
        @$image_size= getimagesize($_FILES['PICTURE']['tmp_name']);

          //uploading the file
          move_uploaded_file($temp,"images/" . $myfile);

SET EXAM SCHEDULE
<?php
       include('include/connect.php');
       include('include/header.php');
       include('include/sidebar1.php')
       
        ?>
<div id="content-wrapper">
<?php
$query = "SELECT * FROM `exam_schedule` WHERE stud_id = '".$_SESSION['id']."'";
  $result = mysqli_query($db, $query) or die (mysqli_error($db));
                  
  $row = mysqli_fetch_assoc($result);
if($row==0){
  ?>
        <div class="container-fluid">
 <h2>Add Schedule</h2> 
            <div class="card-body">
                          <form method="POST" action="#"> 
                        <div class="row">
                          <div class="col-md-4">
                            <div class="form-group">
                            <div class="form-label-group">
                            <input type="text" id="inputdate3" class="form-control" value="<?php echo $_SESSION['code']; ?>" readonly placeholder="Examinnee ID#" name="code" required>
                            <label for="inputdate3">Examinnee ID#</label>
                            </div>
                            </div>
                          </div>
                          <div class="col-md-4">
                            <div class="form-group">
                            <div class="form-label-group">

REGISTERED EXAMINEES
<?php
       include('include/connect.php');
       include('include/header.php');
       include('include/sidebar1.php')
        ?>
<div id="content-wrapper">
        <div class="container-fluid">
 <h2>List of Examinee(s)</h2> 
            <div class="card-body">
              <div class="table-responsive">
                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                  <thead>
                    <tr>
                      <th>Examinee</th>
                      <th>Examinee ID #</th>
                      <th>Gender</th>
                      <th>Date Of Birth</th>
                      <th>Email</th>
                      <th>Username</th>
                      <th>Date OF Entrance Exam</th>
                      <th>Raw Score</th>
                      <th>Stanine Score</th>
                      <th>Options</th>
                    </tr>
                  </thead>
              <?php
$query = "SELECT s.stud_id,concat(s.fname,' ',s.lname) as 'name',s.examinee_code,s.gender,s.b_date,s.email,s.username,s.dateoftest,s.raw_score,s.stanine,sum.qualifying_result FROM student s left join summary sum on sum.stud_id = s.stud_id";
                    $result = mysqli_query($db, $query) or die (mysqli_error($db));
                        while ($row = mysqli_fetch_assoc($result)) {                 
                            echo '<tr>';
                             echo '<td>'. $row['name'].'</td>';
                             echo '<td>'. $row['examinee_code'].'</td>';
                              echo '<td>'. $row['gender'].'</td>';
                               echo '<td>'. $row['b_date'].'</td>';
                               echo '<td>'. $row['email'].'</td>';
                             echo '<td>'. $row['username'].'</td>';
                              echo '<td>'. $row['dateoftest'].'</td>';
                               echo '<td>'. $row['raw_score'].'</td>';
                               echo '<td>'. $row['stanine'].'</td>';
                               echo " ";
                               echo '<td><a type="button" class="btn btn-sm btn-warning fas fa-pencil-alt" href="#" data-toggle="modal" data-target="#AddRes'.$row['stud_id'].'">Add Result</a>'; ?>
 <div id="AddRes<?php echo $row['stud_id'];?>" class="modal fade" role="dialog">
              <div class="modal-dialog">
                <!-- Modal content-->
                <div class="modal-content" style="width: 130%">
                  <div class="modal-header"><h3>Add Result</h3>
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                  </div>
                  <div class="modal-body">                 
                          <form method="POST" action="#">
                            <div class="form-group">
                            <div class="form-label-group">
                            <input type="text" readonly="" id="inputName1" class="form-control" placeholder="Name" name="name" value="<?php echo $row['name']; ?>" autofocus="autofocus" required>
                            <input type="hidden" id="inputName1" class="form-control" name="id" value="<?php echo $row['stud_id']; ?>" autofocus="autofocus" required>
                            <label for="inputName1">Name</label>
                            </div>
                            </div>
                            <div class="form-group">
                            <div class="form-label-group">
                            <input type="number" id="inputAge1" class="form-control" placeholder="Age" readonly="" name="entrance" value="<?php echo $row['raw_score']; ?>" required>
                            <label for="inputAge1">Entrance Score</label>
                            </div>
                            </div>
                            <div class="form-group">
                            <div class="form-label-group">
                            <input type="number" id="inputAddress1<?php echo $row['stud_id']; ?>" class="form-control" placeholder="Address" name="gen_av" required>
                            <label for="inputAddress1<?php echo $row['stud_id']; ?>">General Average</label>
                            </div>
                            </div>
                            <div class="form-group">
                            <div class="form-label-group">
                            <input type="text" id="inputContact1<?php echo $row['stud_id']; ?>" class="form-control" placeholder="Contact Number" readonly="" value="<?php echo $row['qualifying_result']; ?>" name="contact" required>
                            <label for="inputContact1<?php echo $row['stud_id']; ?>">Qualifying Result</label>
                            </div>
                            </div>
                            <div class="form-group">
                            <div class="form-label-group">
                            <input type="number" id="inputContact2<?php echo $row['stud_id']; ?>" class="form-control" placeholder="Contact Number" name="interview" required>
                            <label for="inputContact2<?php echo $row['stud_id']; ?>">Interview Result</label>
                            </div>
                            </div>                 
                  <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">
                      Close
                      <span class="glyphicon glyphicon-remove-sign"></span>
                    </button>
                    <input type="submit" name="update" value="Submit Result" class="btn btn-success">
                  </div>
                  </form>
</div>
</div>
              </div>
            </div>
            <?php
            if(isset($_POST['update'])){
              $id = $_POST['id'];
  $sql = "SELECT creteria FROM criteria WHERE title='Entrance Score' AND is_default = 'Yes'";
  $results = mysqli_query($db, $sql) or die (mysqli_error($db));
  $rows = mysqli_fetch_assoc($results); 
  $entrance = ($_POST['entrance'] + 50) * $rows['creteria'];

  $sql2 = "SELECT creteria FROM criteria WHERE title='General Average' AND is_default = 'Yes'";
  $results2 = mysqli_query($db, $sql2) or die (mysqli_error($db));
  $rows2 = mysqli_fetch_assoc($results2);
  $gen_av = $_POST['gen_av'] * $rows2['creteria'];
  $sql3 = "SELECT creteria FROM criteria WHERE title='Interview' AND is_default = 'Yes'";
  $results3 = mysqli_query($db, $sql3) or die (mysqli_error($db));
  $rows3 = mysqli_fetch_assoc($results3);
  $interview = $_POST['interview'] * $rows3['creteria'];
  $total = $entrance + $gen_av + $interview;
$sql4 = "SELECT sy_id FROM schoolyear WHERE is_default='Yes'";
  $results4 = mysqli_query($db, $sql4) or die (mysqli_error($db));
  $rows4 = mysqli_fetch_assoc($results4);
  $query = "UPDATE `summary` SET `entrance_score`='$entrance',`general_ave`='$gen_av',`interview`='$interview',`total`='$total',sy_id = '".$rows4['sy_id']."' WHERE `stud_id`='$id'";
                mysqli_query($db,$query)or die (mysqli_error($db)); ?>
                <script type="text/javascript">
      alert("Results Updated Successfully!.");
      window.location = "summary.php";
    </script> <?php  }
echo '</td> ';  echo '</tr> ';
}
?> 
</table>
              </div>
              </div>         <?php
              include('include/scripts.php');
       include('include/footer.php'); ?>

Appendix B

System Evaluation Questionnaire

Instruction: This survey will assist the proponents to evaluate the system effectiveness for the operation of the proposed project. Using the scale below, please encircle each of the items which indicate the performance of the Chmsc-bin IT freshmen admission system.

  1. 2.19 very useful
  2. 3.39 useful

3.40-4.59 moderately useful

4.60-5.79 less useful

5.80-7.00 less useful

Evaluator’s Name: _______________________

Date Evaluated: ____________ 

Instruction: The evaluation will assess the efficiency of chmsc-bin IT freshmen admission system. Using the scale below please reflects your assessment of the developed system in terms of the given criterion. 

POST-STUDY SYSTEM USABILITY QUESTIONNAIRE
1. Overall, I am satisfied with how easy it is to use this system.        
2. It was simple to use this system.        
3. I was able to complete the tasks and scenarios quickly using this system.        
4. I felt comfortable using this system.        
5. It was easy to learn to use this system.        
6. I believe I could become productive quickly using this system.        
7. The system gave error messages that clearly told me how to fix problems.        
8. Whenever I made a mistake using the system, I could recover easily and quickly.        
9. The information (such as online help, on-screen messages, and other documentation) provided with this system was clear.        
10. It was easy to find the information I needed.
11. The information was effective in helping me complete the tasks and scenarios.
12. The organization of information on the system screens was clear.
13. The interface of this system was pleasant.
14. I liked using the interface of this system.
15. This system has all the functions and capabilities I expect it to have.
16. Overall, I am satisfied with this system.

Table 18 Post Study System Usability Questionnaire

Appendix C 

Sample InputS

Student Registration

Figure 20 sample input of student registration

Figure 20 Shows the sample input of student registration.

Exam Result 

Figure 21 sample input of exam result

Figure 21 sample input of exam result for qualifying exam.

APPENDIX D

Sample Output

Figure 22 sample of output result

Appendix E

Sample report

Figure 23 sample report

Figure 23: shows the list of examinee’s result  where in can be ranked and print for reports on chmsc-Bin IT Freshmen Admission System.

Appendix F

Users Guide

Figure 24 student registration

Figure 24 Shows the student registration where the student will fill in their credentials for registration on CHMSC-Bin IT Freshmen Admission System.

Figure 25 Student Log In

Figure 25 After the student register he/she proceed to log in an account.

Figure 26 Exam Schedule

Figure 26 Shows the student set their desire schedule.

Figure 27 Admin Side List of Examinees

Figure 27 Shows the list of examines that the admin must view details and confirm student schedule request.

Figure 28 Summary and ReportsFigure 28 This system shows that will get the all the list of examinees where it can be rank and printed.

Related Article

  1. CHMSC Binalbagan IT Freshmen Admission System Thesis Chapter 1
  2. CHMSC Binalbagan IT Freshmen Admission System Thesis Chapter 2
  3. CHMSC Binalbagan IT Freshmen Admission System Thesis Chapter 3
  4. CHMSC Binalbagan IT Freshmen Admission System Thesis Chapter 4
  5. Attendance Monitoring System Thesis Documentation |Chapter 5
  6. Sales and Inventory System Documentation Chapter 5
  7. CRANE Thesis Documentation Chapter 5

Inquiries

if you have any questions or suggestions about  IT Freshmen Admission System Thesis Project Chapter 5, please let’s me know by dropping your comment below.

Leave a Comment