1 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76...

Transcribed Image Text:

1 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 A ID 63066 63066 63066 63066 63066 63066 63066 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 B Date 28/8/2016 29/8/2016 30/8/2016 31/8/2016 3/9/2016 4/9/2016 5/9/2016 5/6/2016 6/6/2016 7/6/2016 8/6/2016 11/6/2016 12/6/2016 13/6/2016 - 14/6/2016 15/6/2016 18/6/2016 19/6/2016 - 20/6/2016 21/6/2016 22/6/2016 25/6/2016 - 26/6/2016 In 9:55:00 10:27:32 9:44:36 9:34:51 9:36:51 9:00:17 9:29:50 - 13:26:26 13:06:18 7:49:37 8:19:24 12:45:08 12:04:08 9:58:14 9:25:52 12:24:00 11:01:08 9:43:26 10:44:00- D Out 23:11:32 16:27:56 15:54:17 20:20:42 18:01:07 18:58:20 19:06:23 19:04:09 15:49:58 15:08:40 18:56:34 19:07:17 16:19:51 16:08:31 18:24:59 18:56:45 16:39:09 The problem is that this log file is huge (around 50,000 lines for 700+ employees in a 3-months period). The data are stored inside an Excel File the client would like to keep it there so that they can add extra data later. 1.1. What is required? You are required write a program that visualizes the attendance data by allowing HR and department managers to view their employees. Currently what we would like to do is to have the list of employees in a list. Once the user clicks on one of the employees, it should show a visualization of their attendance in the entire period (3 months) 1.2.Programming Language? Since the user would like to store the data in an Excel file, he requested to have the program as an addon to Excel. You will be provided a starting VSTO project. You have to develop this project in Visual Studio using either C# or VB.NET. Task 1: Class Diagram The problem is not that difficult. You might end up with few class. However, remember that you are a "Designer" not only a programmer! You have to approach this problem having in mind that the requirements might get bigger (remember, you have 2 extra homeworks). Develop a class diagram that reflects this structure and make sure to follow the main principles we discussed in the class including: Abstraction and Encapsulation Single Responsibility Principle Open-Closed Principle You have to include all fields and methods in every class with proper access modifiers (private, public, etc.). If the relation between two classes is an association, specify the multiplicity, label and direction of the relationship. Make sure that your class diagram represents all needed components in this system. Task 2: Develop the application Develop your program to fulfill the following requirements: 1- When executed, it should parse the Excel file reading all of its contents. 2- You should construct Employee objects and Attendance objects separately. 3- The list of Employees should be presented in the program in a listbox a. Currently you only have employees ID's. This might change later. 4- When you click one of the employees in the list, you should visualize his/her attendance as shown in the following picture (This is only a sketch and you are welcome to enhance it according to your understanding of this domain) Visualization Specification (See the picture below) 1- Draw all days in a vertical mode 2- Draw hours horizontally 3- Drawing attendance: a. The attendance bar should depend on the Time-In and Time-Out (bar length should depend on the duration of employee attendance). b. After the bar, your should draw the duration of the visit in number (e.g. 8:30) C. The color of the is based on the status of that day: i. Present (8 hours or more): Green ii. Insufficient (less than 8 hours): Orange iii. Absent: Red (no bar) iv. Data Error: Blue (in case the Time-In or Time-Out is not available) 4- Draw a gray line indicating the week has started or ended Attendance Visualizer Employees 63066 05551 45255 77281 24489 65971 46046 85872 46452 63200 76882 22084 90574 72907 29788 74532 63516 23249 16843 00616 List of all employees Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10 Day 11 Day 12 Day 13 Day 14 Day 15 Day 16 Day 17 Day 18 Day 19 Day 20 Day 21 Day 22 Day 23 Day 24 Day 25 Day 26 Day 27 Day 28 Day 29 Day 30 Visualization 12AM 1AM 2AM 3AM 4AM 5AM 6AM 7AM 8AM 9AM 10AM 11AM 12PM 1PM 2PM 3PM 4PM 5PM 6PM 7PM 8PM 9PM 10PM 11PM 12AM 8:30 6:30 Absent Data Error Visualization of the attendance Note that the representation is different for present days, absent days, and insufficient days. X 1 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 A ID 63066 63066 63066 63066 63066 63066 63066 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 5551 B Date 28/8/2016 29/8/2016 30/8/2016 31/8/2016 3/9/2016 4/9/2016 5/9/2016 5/6/2016 6/6/2016 7/6/2016 8/6/2016 11/6/2016 12/6/2016 13/6/2016 - 14/6/2016 15/6/2016 18/6/2016 19/6/2016 - 20/6/2016 21/6/2016 22/6/2016 25/6/2016 - 26/6/2016 In 9:55:00 10:27:32 9:44:36 9:34:51 9:36:51 9:00:17 9:29:50 - 13:26:26 13:06:18 7:49:37 8:19:24 12:45:08 12:04:08 9:58:14 9:25:52 12:24:00 11:01:08 9:43:26 10:44:00- D Out 23:11:32 16:27:56 15:54:17 20:20:42 18:01:07 18:58:20 19:06:23 19:04:09 15:49:58 15:08:40 18:56:34 19:07:17 16:19:51 16:08:31 18:24:59 18:56:45 16:39:09 The problem is that this log file is huge (around 50,000 lines for 700+ employees in a 3-months period). The data are stored inside an Excel File the client would like to keep it there so that they can add extra data later. 1.1. What is required? You are required write a program that visualizes the attendance data by allowing HR and department managers to view their employees. Currently what we would like to do is to have the list of employees in a list. Once the user clicks on one of the employees, it should show a visualization of their attendance in the entire period (3 months) 1.2.Programming Language? Since the user would like to store the data in an Excel file, he requested to have the program as an addon to Excel. You will be provided a starting VSTO project. You have to develop this project in Visual Studio using either C# or VB.NET. Task 1: Class Diagram The problem is not that difficult. You might end up with few class. However, remember that you are a "Designer" not only a programmer! You have to approach this problem having in mind that the requirements might get bigger (remember, you have 2 extra homeworks). Develop a class diagram that reflects this structure and make sure to follow the main principles we discussed in the class including: Abstraction and Encapsulation Single Responsibility Principle Open-Closed Principle You have to include all fields and methods in every class with proper access modifiers (private, public, etc.). If the relation between two classes is an association, specify the multiplicity, label and direction of the relationship. Make sure that your class diagram represents all needed components in this system. Task 2: Develop the application Develop your program to fulfill the following requirements: 1- When executed, it should parse the Excel file reading all of its contents. 2- You should construct Employee objects and Attendance objects separately. 3- The list of Employees should be presented in the program in a listbox a. Currently you only have employees ID's. This might change later. 4- When you click one of the employees in the list, you should visualize his/her attendance as shown in the following picture (This is only a sketch and you are welcome to enhance it according to your understanding of this domain) Visualization Specification (See the picture below) 1- Draw all days in a vertical mode 2- Draw hours horizontally 3- Drawing attendance: a. The attendance bar should depend on the Time-In and Time-Out (bar length should depend on the duration of employee attendance). b. After the bar, your should draw the duration of the visit in number (e.g. 8:30) C. The color of the is based on the status of that day: i. Present (8 hours or more): Green ii. Insufficient (less than 8 hours): Orange iii. Absent: Red (no bar) iv. Data Error: Blue (in case the Time-In or Time-Out is not available) 4- Draw a gray line indicating the week has started or ended Attendance Visualizer Employees 63066 05551 45255 77281 24489 65971 46046 85872 46452 63200 76882 22084 90574 72907 29788 74532 63516 23249 16843 00616 List of all employees Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10 Day 11 Day 12 Day 13 Day 14 Day 15 Day 16 Day 17 Day 18 Day 19 Day 20 Day 21 Day 22 Day 23 Day 24 Day 25 Day 26 Day 27 Day 28 Day 29 Day 30 Visualization 12AM 1AM 2AM 3AM 4AM 5AM 6AM 7AM 8AM 9AM 10AM 11AM 12PM 1PM 2PM 3PM 4PM 5PM 6PM 7PM 8PM 9PM 10PM 11PM 12AM 8:30 6:30 Absent Data Error Visualization of the attendance Note that the representation is different for present days, absent days, and insufficient days. X

Answer rating: 100% (QA)

Solutions Step 1 To address the requirements youve outlined for visualizing attendance data stored in an Excel file as an addon to Excel using either C or VBNET in a VSTO project you can follow these ... View the full answer