Mini Project for Excel: Student Attendance Register
Create a beginner-friendly Excel mini project to manage a student attendance register using manual data entry and basic sheet management features. Perfect for students and Excel learners.
🎯 Goal:
Practice clean data entry and basic sheet formatting/organization in Excel.
📄 Sheet 1: “Class Info”
- Columns:
- Roll Number
- Student Name
- Gender
- Grade
- Contact Number
📌 Tasks:
- Enter data for at least 15–20 students.
- Apply:
- Bold headers
- Borders around data
- Adjust column widths for readability
- Use “Center” alignment for Roll Number and Grade
📄 Sheet 2: “April Attendance”
- First Column: Dates (01-Apr to 30-Apr)
- Top Row (Row 1): Student names (copy from Sheet 1)
📌 Tasks:
- Manually enter attendance using:
- “P” for Present
- “A” for Absent
- “L” for Late
- Use:
- Bold and center-aligned headers
- Light fill colors for headers
- Alternating row colors to improve readability (manually)
🗂️ Sheet Management Tasks:
- Rename sheets:
- “Sheet1” → “Class Info”
- “Sheet2” → “April Attendance”
- Apply tab colors:
- Blue for “Class Info”
- Green for “April Attendance”
- Reorder sheets so “Class Info” comes first
✅ Skills Practiced:
- Manual Data Entry
- Cell Formatting (bold, color, alignment, borders)
- Sheet Renaming
- Sheet Tab Coloring
- Reordering Sheets
🧠 Practice & Progress
Explore More Topics
Microsoft Excel Fundamentals
Microsoft Excel More ...