An Excel-based tool to track and evaluate employee performance, compliance, and skills assessments with summary statistics and visual charts
This repository contains an Excel workbook designed to track and evaluate employee performance and compliance with various company policies and skills assessments. It includes individual scores for multiple tests, an analysis of overall performance, and identification of employees who need to be terminated based on specific criteria.
- GradeBook Sheet: Raw data for each employee's test scores and compliance results.
- Summary Statistics: Calculated statistics such as the maximum, minimum, and average scores for each test.
- Charts: Visual representations of performance in the Safety Test, Company Philosophy Test, and Financial Skills Test.
-
Employee Information:
- Last Name
- First Name
-
Test Scores:
- Safety Test (10 points)
- Company Philosophy Test (20 points)
- Financial Skills Test (100 points)
- Drug Test (Pass/Fail)
-
Performance Percentages:
- Safety Test (%)
- Company Philosophy Test (%)
- Financial Skills Test (%)
- Drug Test (%)
-
Employment Status:
- Fire Employee (Boolean value indicating termination status)
- Max: Highest score achieved for each test.
- Min: Lowest score achieved for each test.
- Average: Average score across all employees for each test.
- Safety Test: Bar chart of individual scores.
- Company Philosophy Test: Bar chart of individual scores.
- Financial Skills Test: Bar chart of individual scores.
-
Monitor and improve employee performance.
-
Identify training needs.
-
Ensure compliance with company policies.
-
Make informed decisions about employment status.
*.xlsx *.xls
*.tmp *.log .DS_Store
Thumbs.db
This project is licensed under the MIT License - see the LICENSE file for details.