Task
Find one real example of an industrial dispute in India (e.g., Maruti Suzuki Manesar strike 2012). Summarize in 150 words: cause of dispute, actions taken, and final settlement.
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
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
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
Enter 5 dummy employees with CTC, allowances, and perks.Calculate gross salary, taxable income, TDS, and net pay.Generate a sample payroll register.
Task
Design a salary breakup for a ₹10 LPA CTC, including allowances: HRA, DA, LTA, Medical, Conveyance.
Task
For an employee earning ₹30,000 Basic, paying ₹15,000 rent in Bangalore, calculate HRA exemption.
Task
Calculate the basic salary for a CTC of ₹6,00,000 per annum
Task
Prepare a sample HR budget for one function (Recruitment or L&D).
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.