1 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Posted Date:
Students also viewed these programming questions
-
Ayayai Company prepares its statement of cash flows using the direct method for operating activities. For the year ended December 31, 2024, Ayayai Company reports the following: Sales on account...
-
Rewrite Listing 30.1 to display the output in a text area, as shown in Figure 30.30. Listing a 1b2b3b 4b 5 b6bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb 7 8bbbbbbbbbbbbbbbbbbbb 9bb10 16 11 12 13 14...
-
The diagonals of a quadrilateral ABCD intersect each other at the point O such that AO/BO=CO/DO. Show that ABCD is a trapezium.
-
Modify BST to add a method rangeSearch () that takes two keys as arguments and returns an iterable over all keys that are between the two given keys. The running time should be proportional to the...
-
You are optimizing coaxial cable design for a major manufacturer. Show that for a given outer conductor radius b, maximum potential difference capability is attained when the radius of the inner...
-
A scuba diver has an air tank with a volume of 0.010 m3. The air in the tank is initially at a pressure of 1.0 107 Pa. Assuming that the diver breathes 0.500 L/s of air, find how long the tank will...
-
For the manufacture of di-tertiary-butyl peroxide in Example 9.7 synthesize an alternative process and show the flow rate and composition of each stream. Data From Example 9.7:- This example involves...
-
For diagrams (a)-(d), compute the unknown values: B, C, V, x, respectively, using the minimum number of compound interest factors. 200 200 200 200 100 100 100 -:- -2-3- -4 -2-3-4- i- 10% i= 10% (h)...
-
Weller Company's budgeted unit sales for next year are provided below: Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 26,000 27,000 19,000 24,000 The company's variable selling...
-
An alphabetical list of the adjusted trial balance accounts for North Country Rentals after its first year of operations ending March 31, 2020, is shown below: Required 1. Calculate the capital...
-
The Academy of Orthopedic Surgeons gives a survey result that 80% of women wear shoes that are too small for their feet. A researcher wants to be 99% confident that his proportion is within 4% of the...
-
The SEC brought a civil case against May, alleging violations of Section 10(b) of the Exchange Act and Rule 10b-5. May consented to settle the matter and was forced to pay a disgorgement of $437,050...
-
To be a case manager provide a detailed short summary including your intentions and goals and the type of opportunities that are helpful for securing a position as a case manager. Write it in the...
-
Q=6004P where Q = days. MC= $50 per customer. the store is paying a rent of $2,000 per day. a) What is the profit-maximizing number of customers the store should have each day, and what price should...
-
As you continue to explore different tools to help you succeed, think about this question: How do you define success? Answering this question may be easy for some of you and more difficult for...
-
A 4.00 cm object is placed 30.0 cm from a diverging lens that has a focal length of -15.0 cm. (a) Determine the approximate distance between the object and the image. (b) What is the magnification of...
-
A subcontractor must carry out the following: 1. Shop drawing preparation; 2. Framing & drywall installation; and 3. Drywall finish and paint. Assuming the total scope of work is 200m2 and the...
-
One of the significant and relevant accounts for this cycle is equipment. For this account, what would typically be the most relevant assertions for the auditor to consider? Why is it important for...
-
The potential for a mass hanging from a spring is V (y) = ky2/2+mgy, where y = 0 corresponds to the position of the spring when nothing is hanging from it. Find the frequency of small oscillations...
-
An object moves at speed v1 with respect to frame S. Frame S moves at speed v2 with respect to frame S. (in the same direction as the motion of the object). What is the speed, u, of the object with...
-
Consider a stick that moves in the direction in which it points. Does its length contraction depend on whether this direction is across your vision or directly away from you?
-
To cool water for drinking during summer, \(1 \mathrm{~kg}\) of ice at \(-2^{\circ} \mathrm{C}\) is mixed with \(5 \mathrm{~kg}\) of water at \(27^{\circ} \mathrm{C}\) in an insulated container...
-
In a cyclic process, heat transfers are \(+14.7 \mathrm{~kJ},-25.2 \mathrm{~kJ},-3.56 \mathrm{~kJ}\) and \(+31.5 \mathrm{~kJ}\). What is the net work for this cyclic process?
-
A heat pump operates between two identical bodies of specific heat \(C\) at \(T_{1}\). The operation of the pump cools down one of the bodies to \(T_{2}\). Show that for the operation of pump the...
Study smarter with the SolutionInn App