Coit12208 Ict Project Management For Assessment Answers

Answer:

Introduction

The report aims to provide an ICT solution for Joe and Sandy. Joe and Sandy has been operating SanJoe Ski hire and they are providing with huge range of ski as well as snowboarding gear available for the rental services. The business’s success is dependent on the condition of snow. The business is hoping to implement an ICT solution such as spreadsheet application in their business so that it helps to enter customer as well as gear data, calculate bills and print invoices for the customers.

Project proposal

With use of spreadsheet application, Joe and Sandy can make their billing calculations easier and there are no chances of errors while entering the customer’s data. This application allows the business employees to combine data reporting as well as electronic calculations. It eliminates the manual process of entering the bills of customers. Therefore, the spreadsheet calculation can maximize their profit of their business.

Project management plan

The project plan consists of some activities. At first, there is creation of project plan, and then the project activities are identified. Secondly, the project management plan is created and then final report is prepared (Bonino and Corno 2012). Fourthly, research is done and design of the ICT solution is prepared. Finally, report writing and presentation are done to put entire details of the project proposal into it.

Problem and research

While conducting work on the project proposal, there are problems regarding project planning. It is critical to develop the plan and provide details regarding the ICT solution. As the users have capability to change programming statements for the spreadsheet application, therefore it causes lot of problems. By examining suitability of the spreadsheet application, the problems are mitigated. Protection of the source code is also a problem as security is the most important (Tang and Gedik 2013). Therefore, excel consists of tools that can secure the source code used in the spreadsheet application. Further, secondary research on the project is done from the case studies, journal articles and newspaper. The research is based on various spreadsheet applications, which would be suitable for the business of Joe and Sandy.

Recommended solution and justification

Spreadsheet application is selected for the business of Joe and Sandy as use of formulas as well as functions within the spreadsheets which save time as well as improve over the occurrence of errors (Oyamada, Kawashima and Kitagawa 2013). It will enter the customer’s details such as name, address, driver license, ski board number and other details into the excel fields. It will also enable to enter the customer’s data, calculate of bills and print of invoices for the customers. The recommended solutions for spreadsheet application are as follows:

Microsoft Excel: It is spreadsheet software that is easy to use and it is suitable to use for the business due to its versatility as well as functionality. The Microsoft Excel fits the customer’s bill, which also helps them to track the data for the future reference. It can filter the data as per requirements of the ski business. It is mostly used office spreadsheet solution (Cobb 2013). With use of OneDrive, the employees can share as well as access of spreadsheets within the cloud from anywhere. Most of the file formats are well-suited with the excel files; it leads to maximize the profits.

Open office: It is a free data analysis tool that is used among the business, and it is an alternative to the Microsoft excel. The most benefit of this software application is that after downloading of this software, it cannot require any internet connection in order to use it further (Hummer, Satzger and Dustdar 2013). This particular excel alternative consists of open source code, by use of which the programs are improved as well as adapted to business requirements. It is used as an open excel documents that can make switching among two tools effortless.

Excel web application: It allows the users to store the documents within the cloud as well as share with other users such as project members as well as other colleagues. It allows for unlimited share of documents.

Among the recommended solutions, Microsoft excel is the best spreadsheet application for the business requirements of Joe and Sandy. It will also help to improve productivity of the business and maximize their profits (Gupta and Bajpai 2014). It will also make most of resources as well as maximize the return of investments. It is mostly used among the business organization to display of financial information as well as data, which are relevant to run the business. It is a vital tool for the administration for effective running of the business. It is best used software for analysis as well as decision making.

Explanation of design of the solution

A design is created as well as once the design of the system is agreed and the system is created to enter the customer’ data (Fatolahi and Some 2014). The system is created with use of advanced formula, formatting of techniques as well as macro programming. In order to minimize the downtime, a clear emphasis is developed for the system. An experimental design is done for the excel designing with use of factor effect design. With use of ANOVA, experiments are done to analyze the Microsoft Excel design (Cugola and Margara 2012). After the design of the application software, the system is implemented in the business so that Joe and Sandy can make success as well as become competitive in the market. The manual billing process is now changed into automatic billing process by use of Microsoft Excel.

Conclusion

It is concluded that with utilization of spreadsheet application, Joe and Sandy can make their charging billing process more efficient and there are no odds of mistakes while entering the client's information. This application permits the business representatives to join information detailing and electronic estimations. It dispenses with the manual procedure of entering the bills of clients. In this way, the spreadsheet count can boost their benefit of their business. Among the recommended solutions, Microsoft Excel is the best solution for the ski business as it will fit with the billing process of customers and help them to track the data. It can filter the data as per requirements of the ski business.

References

Bonino, D. and Corno, F., 2012. spchains: A declarative framework for data stream processing in pervasive applications. Procedia Computer Science, 10, pp.316-323.

Cobb, B.R., 2013. Spreadsheet modeling of (Q, R) inventory policies. Decision Sciences Journal of Innovative Education, 11(2), pp.175-184.

Cugola, G. and Margara, A., 2012. Processing flows of information: From data stream to complex event processing. ACM Computing Surveys (CSUR), 44(3), p.15.

Fatolahi, A. and Somé, S.S., 2014. Assessing a Model-Driven Web-Application Engineering Approach. Journal of Software Engineering and Applications, 7(5), p.360.

Gupta, R. and Bajpai, N., 2014. A Keyword-Driven Tool for Testing Web Applications (KeyDriver). IEEE Potentials, 33(5), pp.35-42.

Hummer, W., Satzger, B. and Dustdar, S., 2013. Elastic stream processing in the cloud. Wiley Interdisciplinary Reviews: Data Mining and Knowledge Discovery, 3(5), pp.333-345.

Oyamada, M., Kawashima, H. and Kitagawa, H., 2013. Data stream processing with concurrency control. ACM SIGAPP Applied Computing Review, 13(2), pp.54-65.

Tang, Y. and Gedik, B., 2013. Autopipelining for data stream processing. IEEE Transactions on Parallel and Distributed Systems, 24(12), pp.2344-2354.