Employee Activity Verification Application

Build a small application that checks data.

Everytime an employee access the computer system, the system logs their employee number, name, terminal accessed, date, time, day of week.

The system exports an excel file per employee everyday with this data.

We check to see if the employee is accessing the computer systems while at work.

So I need the application to import this excel file, with the data the system generates.

The application should then ask what Assignment the employee was working.

The application then should ask the time zone I am currently in, as I want it to display my current time zone.

Then it should ask me the date and time the employee started work, and the date and time the employee finished work. This will be entered in my local time zone.

I want the application to then check the excel sheet imported data’s, date / time (adjusted to the selected time zone) against the employee start & end date / time.

It should highlight / display any times the employee is on duty and accessing the computer systems.

The application should then be able to export either an excel file of the findings, or a jpeg of the findings.