1. Consider a scenario of PathWay Logistics Company. The company uses customized software,
Empsolution, to store the details of the employees. The software is designed in such a manner
that the data exchange is done in CSV file format. Linda, the HR Manager, wants to find the
number of leaves taken by the employees so that she can prepare the payroll. For this purpose,
she retrieves the employee details using the software tool, which gives the employee details in a
text file format. Linda wants these details in the Microsoft Excel worksheet in order to find the
number of leaves taken by employees. Help Linda to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbN3luTWdYT2FFMTA
2. Consider a scenario of FCC Technology, which provides software services to large number of client organizations. Marlon, the Marketing Manager of the company, works for business development by making new clients. He is required to visit offices of other organization to present the working of the company and the software products that they have made. For this purpose, he collects the software products details from the respective departments. These details are stored in the Microsoft Excel worksheet. He is required to transfer the details to Microsoft PowerPoint, so that he can prepare the presentation for the company. Help Marlon to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbYlduWW8zUjNUcmM
3. Consider a scenario of Ultraglobal Company, which provides audit services to its clients in different countries. Presently, the company is working on audits for one of its client Park Hotel in England. The Ultraglobal Company prepares the audit reports for the client using the Microsoft Excel worksheet. However, the Park Hotel uses a legacy Information System to maintain its company transaction details. This legacy information system can accept only text files as input. Therefore, the Ultraglobal Company has to send the summary of the audit reports to the client in a text file format. Help the Ultraglobal Company to accomplish the required task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbZ2xEQzVvUmdpeE0
4. Diaz Telecom Inc. provides telecom services across North Garland. Stephaney, the Support Manager, maintains customer information in an Excel workbook. She needs to send this information to the Verification division. However, she wants that the Verification Executives are only able to open the workbook. In addition, she wants only the Senior Executive to change the information, if required. Help Stephaney to accomplish the required task.
Ans. https://drive.google.com/open?id=0B-yL1mP3zqTbbGVhV3VnYThVVDQ
5.
Acme Publishers is a publishing house for fashion magazines. Maria is the Purchase Manager at Acme Publishers, and is responsible for the procurement of all the stationary supplies required at Acme. The company needs to buy a new printer for which they have published a procurement tender in the daily newspaper.
After much deliberation, Maria could finalize two of the tenders having the following details: A proposal by Seco Printer offering a scheme for one-time payment of $ 11,000, payable at the time of delivery of the product. A proposal by Mesa Printers offering a scheme for installment payments of $ 3000, spread over a period of 5 years. Assuming that the rate of interest/cost of capital is 12%, help Maria to evaluate the best deal from among the shortlisted tenders. In addition, Maria needs to share this file in an encrypted format with Jacob Ballas, an executive from the Finance Department. How will Maria accomplish the given task?
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbb0x3NkZuQnNJa0k
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbN3luTWdYT2FFMTA
2. Consider a scenario of FCC Technology, which provides software services to large number of client organizations. Marlon, the Marketing Manager of the company, works for business development by making new clients. He is required to visit offices of other organization to present the working of the company and the software products that they have made. For this purpose, he collects the software products details from the respective departments. These details are stored in the Microsoft Excel worksheet. He is required to transfer the details to Microsoft PowerPoint, so that he can prepare the presentation for the company. Help Marlon to accomplish the task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbYlduWW8zUjNUcmM
3. Consider a scenario of Ultraglobal Company, which provides audit services to its clients in different countries. Presently, the company is working on audits for one of its client Park Hotel in England. The Ultraglobal Company prepares the audit reports for the client using the Microsoft Excel worksheet. However, the Park Hotel uses a legacy Information System to maintain its company transaction details. This legacy information system can accept only text files as input. Therefore, the Ultraglobal Company has to send the summary of the audit reports to the client in a text file format. Help the Ultraglobal Company to accomplish the required task.
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbZ2xEQzVvUmdpeE0
4. Diaz Telecom Inc. provides telecom services across North Garland. Stephaney, the Support Manager, maintains customer information in an Excel workbook. She needs to send this information to the Verification division. However, she wants that the Verification Executives are only able to open the workbook. In addition, she wants only the Senior Executive to change the information, if required. Help Stephaney to accomplish the required task.
Ans. https://drive.google.com/open?id=0B-yL1mP3zqTbbGVhV3VnYThVVDQ
5.
Acme Publishers is a publishing house for fashion magazines. Maria is the Purchase Manager at Acme Publishers, and is responsible for the procurement of all the stationary supplies required at Acme. The company needs to buy a new printer for which they have published a procurement tender in the daily newspaper.
After much deliberation, Maria could finalize two of the tenders having the following details: A proposal by Seco Printer offering a scheme for one-time payment of $ 11,000, payable at the time of delivery of the product. A proposal by Mesa Printers offering a scheme for installment payments of $ 3000, spread over a period of 5 years. Assuming that the rate of interest/cost of capital is 12%, help Maria to evaluate the best deal from among the shortlisted tenders. In addition, Maria needs to share this file in an encrypted format with Jacob Ballas, an executive from the Finance Department. How will Maria accomplish the given task?
Ans https://drive.google.com/open?id=0B-yL1mP3zqTbb0x3NkZuQnNJa0k
No comments:
Post a Comment