Task
Design a salary breakup for a ₹10 LPA CTC, including allowances: HRA, DA, LTA, Medical, Conveyance.
Task
Enter 5 dummy employees with CTC, allowances, and perks.Calculate gross salary, taxable income, TDS, and net pay.Generate a sample payroll register.
Task
Build an Excel dashboard for 20 employees, showing:Recruitment source mix,Offer-to-join ratio,Attrition rate,Average training hours.Use at least one formula (COUNTIF/AVERAGEIF) and one chart
Task
Import a dataset of 30 employees (dummy HR data – Name, Department, DOJ, Salary, Attrition status).Create a Power BI dashboard with visuals showing:Attrition by department,Gender diversity,Average salary by role.Add at least two slicers (e.g., by Department, by Gender)
Task
Draft an onboarding journey map for a new employee in your organization (or a hypothetical one). Include pre-boarding → first day → first week → first 30/90 days. Indicate key milestones, stakeholders (HR, manager, buddy, IT, etc.), communication points, and engagement activities.Create a short pulse survey (5–7 questions) to gauge early satisfaction & sentiment of […]
Task
Create a sample L&D heat map (even with dummy data) showing skill gaps for 3 functions (e.g., Sales, IT, HR).
Task
List 3 core competencies and identify possible training interventions for each.Place 2 employees (real/dummy) into the Skill-Will Matrix and suggest L&D actions.
Task
Draft a succession plan for one critical role (e.g., Project Manager) and list 3 L&D initiatives to prepare future successors.Pick a recent training (real/dummy) and evaluate it using Kirkpatrick’s 4 levels.Design a training outline (5–6 steps) applying Gagné’s events (e.g., gain attention, provide feedback, enhance retention).
Task
Create an outline of a Remote Work Policy (bullet points only).List 5 cost heads you would include in an HR budget for a 500-employee company.
Task
Prepare a sample HR budget for one function (Recruitment or L&D).