COMPUTERIZED EXAM SYSTEM S1 CREATED IN EXCEL – SUITABLE FOR STUDENTS, EDUCATORS, TRAINERS AND HR PER

System Overview

The Computerized Exam System S1 (Excel VBA-Based) is a fully
automated examination platform designed for student, educators, trainers, HR
personnel, and institutions that need a simple yet powerful solution for
computer-based testing.

Developed entirely in Microsoft Excel with VBA, the system
transforms the familiar Excel environment into a structured testing tool
capable of handling multiple-choice exams, scoring, and detailed reporting.

The system automatically loads exam questions, displays them
one at a time with optional images, records examinee details, tracks timing,
computes results, and generates a summary sheet for easy evaluation. It is
designed to be lightweight, offline-ready, and extremely user-friendly even for
non-technical users.

Key Features

1. Examinee Information Capture

The system collects and records essential examinee details:

• Name of Examinee

• Contact Information

• Date of Examination

• Time Started & Time Finished

• Total Time Consumed

• All information is automatically saved and logged for
future reference.

2. Automated Question Handling

• Pulls questions from a structured database using:

o Question ID

o Image Name (optional)

o Question Text

o Choices A–D

o Correct Answer

• Supports embedded photos or picture-based questions.

• Displays questions in sequential order.

3. Real-Time Answer Processing

• Allows examinees to select their answers through
user-friendly form controls.

• Automatically checks answers against the correct answer
key.

• Computes:

o Score

o Total Questions

o Total Mistakes

4. Automatic Scoring & Result Summary

At the end of the exam, the system automatically generates:

• Final Score

• Mistake Count

• Time Spent

A summary record is saved for administrative tracking and
analysis.

5. Timing and Monitoring

• Built-in timer that starts when the exam begins.

• Tracks:

o Time Started

o Time Finished

o Time Consumed

• Can be configured for timed or untimed exams.

6. Image-Supported Questions

• Supports question images through the Image Name field.

• Automatically loads and displays the image next to the
question, useful for:

o Identification-type questions

o Visual reasoning tests

7. Secure and Controlled Exam Environment

• Optional password protection for settings and question
sheets

• Prevents switching between sheets if configured

• Minimizes cheating risks in local/computerized exams

8. Results Logging & Export

• Generates a complete examination log for every examinee.

• Saves data in an organized, easy-to-review format.

• Results can be exported or forwarded for:

o HR evaluations

o Student grading

o Audit and compliance

9. Customizable and Easy to Update

• Questions can be edited directly inside Excel.

• Flexible enough for:

o Academic exams

o Employment tests

o Certification assessments

o Training evaluations

CONTACT / ORDER
INFORMATION

Product Name: Computerized Exam System S1

Developer: ELJ

Inclusions: System file, UserForm, Database Table, Technical
Support

Email: vbafan2000@gmail.com

Contact: 09274741927