Assessfy Foundation Projects Lab Beginner 5 milestones 100 marks

Create a Simple Employee Attendance Dashboard in Excel

Discipline: HR & People Analytics Level: Foundation Industry: Human Resources Function: Human Resources Team: up to 3 Assessment: 5 milestones (100 marks)

Real-world project · AICTE-aligned · AI-graded · Audit-ready certificate

Enroll as Student Mentor this project

Milestones

Available mentors

Enrolled students

Core skills

About this project

What you'll build: You'll create a basic dashboard in Excel that shows employee attendance and leave patterns using sample HR data. This dashboard will let users easily see who attended work, who took leave, and simple trends over time.

Why it's a good starter: This project is perfect for beginners because it uses familiar tools (Excel) and simple steps. You'll get hands-on practice with real HR data and see immediate visual results, without needing advanced programming or statistics.

What you'll learn: You'll learn how to organize attendance data, use Excel to make charts and tables, and create a clear dashboard. You'll also practice basic data analysis and presenting findings in a way managers can understand.

Milestones

1. Setup & Project Plan

10 marks 5d

Submit a short plan outlining your dashboard idea, what sample data you will use, and the main dashboard features. Show you have sourced or created a small employee attendance dataset (at least 20 records).

2. Core Build: Data Preparation & Basic Layout

30 marks 10d

Submit your cleaned attendance dataset and a basic Excel sheet with organized data. Show use of simple formulas (SUM, COUNTIF) and a draft dashboard layout (tables or placeholders for charts).

3. Core Build: Charts & Dashboard Features

30 marks 10d

Submit your Excel dashboard with at least two charts (e.g., attendance trends, leave types) and summary tables. Ensure the dashboard is visually clear, labels are accurate, and features work as described.

4. Testing & Polish

15 marks 5d

Test the dashboard for accuracy and usability. Submit your polished Excel file, fixing any errors and improving layout/clarity. Include a brief checklist of what you tested and improved.

5. Demo & Short Report

15 marks 5d

Submit a brief (1-2 page) report explaining your dashboard, key findings, and how it can help HR managers. Present your dashboard in a short recorded screen demo (2-3 min, phone or computer).

Open internships using this project -->

Skills you'll learn

HR & People AnalyticsOrganizing and cleaning attendance dataBasic Excel formulas (SUMCOUNTIF)Creating charts and tables in ExcelDesigning a simple dashboard layoutSummarizing trends in plain language

Tools used

Microsoft Excel (or Google Sheets)Sample HR attendance data (CSV/XLS)Free online tutorials (YouTubeExcel guides)

Prerequisites

Basic Excel skills (openingediting files)School-level mathematicsAbility to follow step-by-step instructions

Available mentors

No mentors have signed up for this project yet.

Be the first to mentor

You'll earn — Certificate (PDF)

AICTE-aligned Project Completion Certificate

A formal, audit-ready PDF certificate issued by Assessfy + your institute on successful completion. Includes AICTE credit hours, your evaluator's signature, and a QR code for third-party verification.

AICTE-aligned

Certificate of Project Completion

This is to certify that

has successfully completed the project

Create a Simple Employee Attendance Dashboard in Excel

Scan to Verify

Date

Signature

Auto-issued on completion QR-verifiable

You'll earn — Digital Badge

Shareable LinkedIn / Resume Skill Badge

A compact, verifiable Open-Badges-2.0-compliant digital credential. Add to your LinkedIn profile, GitHub README, or resume in one click. Recruiters can validate authenticity via a unique URL.

Beginner

Create a Simple Employee Attendance D…

Assessfy

Auto-issued on completion One-click LinkedIn add