As PureAssignment official, we help students from all around the world with their Excel projects. Orthographic Dashboard Assignment is only one of them! If you need help with a similar project, Click HERE to opt to our Excel homework help webpage.
To analyze and report on employment data for the Human Resources department at Orthographic
| FIELD | DESCRIPTION | DATA TYPE | NOTES |
| ID | Employee ID number (unique) | text | ID is written in format “e###-###” |
| FIRST | Employee first name | text | Do not include middle initials |
| LAST | Employee last name | text | Do not include middle initials |
| DEPT | Employee department | text | Accounting, Administration, Customer Support, Human Resources, Finance, Marketing, IT, R&D, or Sales |
| HIRE DATE | Date of employee hire | date | Use the date format mm/dd/yyyy |
| OFFICE | Location of the employee office | text | Boston, Chicago, Dallas, Denver, or San Francisco |
| STATE | Employee office state | text | Use two-letter abbreviation in capital letters (MA, IL, TX, CO, or CA) |
| BASE SALARY | Employee base salary | number | Use currency format; do not include bonuses or commission fees |
| BONUS | Employee end-of-year bonus | number | Use currency format; do not include base salary or commission fees |
| COMMISSION | Employee commission fee | number | Use currency format; do not include base salary or bonuses |
| PERSONAL DAYS | Days excused from work with pay | number | The number of days taken by the employee for personal days |
| SICK DAYS | Sick days with pay | number | The number of days in which the employee received sick-day benefits |
| EVAL SCORE | Year-end employee evaluation | number | Evaluation scores range from 1 (poor) to 5 (excellent) |
Calculated Fields Related with Orthographic Dashboard Assignment
| FIELD | DESCRIPTION | DATA TYPE | NOTES |
| FULL NAME | Employee first and last name | text | Calculate by combining the FIRST and LAST field separated by a single space |
| HIRE YEAR | Year of employee hire | number | Calculate by extracting the year value from the HIRE DATE field |
| WAGES | Total employee wage compensation | number | Calculate by adding the BASE SALARY, BONUS, and COMMISSION fields |
Where to start to get The Best Excel Homework Help Service?
Choose PureAssignment for reliable, secure, and high-accuracy online Excel help services that guarantee your academic success. If you need help with a similar project, Click HERE to opt to our Excel homework help webpage.
Hi,
My name is Engin. I am the founder of pureassignment, a traveller, fitness lover and a cat person.