Lab 08 Report - Online Quiz System

Project Overview

• This project implements an online quiz management system using ASP.NET Web Forms.
• It allows teachers to create quizzes and add questions with multiple options.
• Students can attempt quizzes online and view their results instantly.
• Role-based authentication ensures proper access control.

User Roles

• Admin - Manages system and schedules quizzes.
• Teacher - Creates questions and builds quizzes.
• Student - Attempts quizzes and views results.

System Implementation

• Developed using ASP.NET Web Forms (VB.NET).
• Session-based authentication is used for login and role management.
• Separate dashboards are created for Admin, Teacher, and Student.
• Navigation is controlled using role-based redirection.

Teacher Module

• Teachers can add multiple choice and true/false questions.
• Each question contains options and one correct answer.
• Teachers can create quizzes by selecting questions.
• Quiz settings include time limit and randomization options.

Student Module

• Students can view available quizzes on dashboard.
• Questions are displayed one by one during attempt.
• Answers are saved in the database during quiz attempt.
• At the end, score is calculated automatically.
• Students can view their previous results.

Admin Module

• Admin can schedule quizzes by setting start and end time.
• Ensures quizzes are available only within scheduled duration.

Database & SQL Usage

• Tables include Users, Quiz, Questions, QuestionOptions, QuizAttempts, Answers.
• Uses JOIN operations to fetch quiz and result data.
• Score is calculated using correct answers from QuestionOptions.
• Stores attempt history for each student.

Test Cases Considered

• Student attempting quiz without login.
• Teacher adding incomplete question data.
• No questions selected while creating quiz.
• Student re-attempting already completed quiz.
• Empty quiz results scenario.