Name of the Information System
Creating a data set that allows for access to the essential information about airlines is crucial as it will help increase the rates of customer satisfaction, provide passengers with more opportunities, and define the key companies in the designated market (Stair & Reynolds, 2015). Herein lies the necessity to introduce an information system incorporating a range of characteristics of airlines. The name of the IS in question, therefore, is “Airlines: Everything a User Needs to Know.”
General Purpose of the Information System
The purpose of the IS is to shed light on the target market and show what the company can be deemed as the most credible. There are several data sets that help identify the current leaders in the airline business based on several parameters. However, these lists are typically aimed at identifying the economic aspects of the firms. The lack of focus on the data that a customer needs to choose the appropriate company, therefore, has prompted the creation of the IS.
Information System Components
Hardware
To run the IS in question, one will have to use the hardware similar to the one required for MS Office 2013:
Computer and processor
- 1 gigahertz (GHz) or faster x86- or x64-bit processor with SSE2 instruction set
- Memory (RAM);
- 1 gigabyte (GB) RAM (32-bit); 2 gigabytes (GB) RAM (64-bit);
- Hard Disk:
- 3.0 gigabytes (GB) available;
Display
Graphics hardware acceleration requires a DirectX10 graphics card and a 1024 x 576 or higher resolution monitor. (System requirements for Office 2013, 2013)
Software
Emergent technology
The emergent technology used to produce the IS can be defined as a data network created with the help of the Microsoft Excel 2010 program.
Purpose
The purpose of technology concerns the provision of tools for efficient data management. Particularly, the opportunities for sorting and combining data deserve to be mentioned.
Description
The technology in question can be described as the environment in which users are encouraged to acquire the necessary information by using various operators.
Capabilities
The capabilities of the technology under analysis include the opportunities related to a detailed analysis of the data, the identification of the best solutions possible, and the evaluation of the existing risks.
Sector
The airline sector is most likely to benefit from the technology under analysis as it will prompt customers’ enthusiasm for learning more about the options that airlines provide.
Implementation in the UAE
The specified approach can be implemented in the UAE setting by creating a network for the customers of the UAE airlines (Emirates Airlines turns 30: Just as it has changed the world, now Emirates faces its own changes, 2015).
Promoting growth
The increasing necessity to travel abroad and to use airlines as the fastest transportation mode is the key external factor promoting the growth of the technology.
Limiting growth
The financial issues related to the funding of the technology are likely to impede its development.
Data
The data entered in the information system will be primarily numerical, excluding the information related to the types of companies and the quality of the services provided. The information retrieved from the output, in its turn, is expected to be qualitative as it will inform the user on whether to consider the company as an efficient service or not.
Procedures
The IS ranks the companies included based on their characteristics and helps select the one with desirable parameters.
Network
A network is required so that the data could be updated on a regular basis.
People’s Role
The role of people is rather important as the process of sorting needs to be completed in several steps that have to be carried out manually (i.e., providing an input parameter).
Spreadsheet Structure
The IS will incorporate a range of information pieces about the target companies. First and most obvious, the name of each entrepreneurship will be listed in the IS. The type of airline will also be mentioned as an essential fact that will help customers choose an appropriate company. The quality of the services provided by the organizations will be listed in the spreadsheet so that the corresponding data could be ranked appropriately. In addition, the data set will indicate the location of each airline so that the customers could pick the ones that are in the vicinity. The number of aircraft is another crucial parameter that helps identify whether the services can be viewed as trustworthy.
Combined with the quality-related characteristics, it will show if the organization is capable of maintaining its equipment in a proper condition and whether it is safe to fly the airplanes of the chosen organization. The load factor is another important piece of information that will help figure out whether the service is popular and how comfortable one will feel using it. The annual revenue of the entrepreneurship will permit identifying whether the firm can afford the provision of services at the required quality level. Correlated with the price of the tickets, it will help the target customer make a choice. Finally, the number of accidents per year will show whether the company is safe enough (Stah, 2014).
Functionalities of the Information System
The IS will provide users with an opportunity to analyze the data easily. For these purposes, the IF function, sorting, filtering, and charts were incorporated into the framework (Course Technology, 2010).
System Testing: The Framework that Works
The preliminary tests have shown that the system provides solid opportunities for analyzing data efficiently. For instance, the information can be retrieved by using the IF function (see Appendix B), the sorting one (see Appendix C), and filtering (see Appendix D). Moreover, the framework invites opportunities for creating a range of charts (see Appendix E).
Appendix A
Appendix B
Formula: =If(E2>=30;”Suitable”;”Unsuitable”) (“Characteristics”)
Appendix C
Sorted by the company name
Appendix D
Filtered (by location (“{Location” = “Abu Dhabi”)):
Appendix E
Revenue-quality correlation
Reference List
Course Technology. (2010). Microsoft Excel 2010 coursenotes. Boston, MA: Cengage Learning.
Emirates Airline turns 30: Just as it has changed the world, now Emirates faces its own changes. (2015). Web.
Stah, R. (2014). Leadership style analysis within two corporate icons: Continental Airlines and Fletcher Jones. Berlin: GRIN Verlag.
Stair, R., & Reynolds, G. (2015). Principles of information systems. Boston, MA: Cengage Learning.
System requirements for Office 2013. (2013). Web.