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.