StudentShare solutions
Triangle menu

Information Systems - Essay Example

Not dowloaded yet

Extract of sample
Information Systems

There are various ways of adding and counting data (Microsoft Corporation 2006), the most appropriate are simple addition and addition with one or more criteria.
Subtotals by quarter for all persons are shown in the Sales Summary for 2005 in(000's) in Table 1. For example, Subtotal 815 means that all salespersons together have sold office furniture on 815,000 in the first quarter in Commercial sector. Then, Sector subtotals (sales volumes by sector) are added. For example, Sector subtotal 3429 means that all salespersons together have sold office furniture on 3,429,000 in Commercial sector in the 2005. Then, 6,555,000 is annual sales result in 2005.
Then formatting should be applied to the report to make it easy to read and understand. There are many basic formatting options available at the cell and worksheet level. Most are available on the Format Menu located on the Standard Excel toolbar. (Sandhills Publishing Company 2005)
Pie charts and bar charts are very useful for analysis and easy to interpret. Peltier (2006) concludes that pie charts are good when you are showing the relative proportion of numbers that add up to a total, for a single series of data and when there are not too many wedges, particularly too many small ones. They show a good qualitative view of the data. Bar charts are good for quantitative displays, at showing progress toward a goal, especially if you've exceeded that goal (for this you should use a bar chart with a horizontal line at the goal).
Table 1. Sales Summary for 2005 in(000's)

Sector: Commercial
Sector: Education
Sector: Health
Person
Q1
Q2
Q3
Q4
Q1
Q2
Q3
Q4
Q1
Q2
Q3
Q4
Dave Able
145
144
122
198
24
14
14
11




Andrea Corry
162
166






82
85


Rhani Choudhury


188
190






94
101
Betty Everett
25
33
31
26
104
123
164
115
34
32
42
53
Fred Fin lay
130
132
100
137


32
14
60
71
33
67
Sheila Herbert
138
166
162
185

22


12
10
14
8
Donald Jenkins
19
12
20
7
184
191
192
144
26
33
45
23
Sharuk Khan
172
169
145
187




32
43
44
46
Mary Manson
24
27
31
36
170
142
176
181


7
12
Subtotals
815
849
799
966
482
492
578
465
246
274
279
310
Sector subtotals



3429



2017



1109
Total Sales
6555

Sales by sector chart (Figure 1) shows the dynamic of sales of office furniture by quarter in each sector. It shows that sales in Commercial sector are 815,000 in the 1st quarter, then they grow to 849,000 in the 2nd quarter, then they decline to 799,000 in the 3rd quarter, and then they grow again to 966,000 in the 4th quarter. Sales in Commercial sector are higher then sales in other sectors in each quarter.
As you can see, sales in Education sector are 482,000 in the 1st quarter, then they grow to 492,000 in the 2nd quarter, then they grow again to 578,000 in the 3rd quarter, and then they decline to 465,000 in the 4th quarter. Sales in Health sector are constantly growing from 246,000 in the 1st quarter to 310,000 in the 4th quarter.

Figure 1. Sales by sector
Total sales by sector chart (Figure 2) shows the share of sales of office furniture in each sector. It shows that sales in Commercial sector are 52% of all sales, while sales in Education sector are 31% of all sales and sales in Health sector are 17% of all sales. So Commercial sector makes up more than half of the market of office furniture.

Figure 2. Total sales by sector
Another information, useful for analysis is efficiency of ...Show more

Summary

The Report is created using Microsoft Excel that is now the World's leading spreadsheet program and is written and distributed by Microsoft Corporation. It features an intuitive interface and capable calculation and graphing tools, so it can be used even by a person without strong computer background…
Author : volkmannatalia
Information Systems Essay essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the essay on your topic
"Information Systems Essay"
with a personal 20% discount.
Grab the best paper

Related Essays

Module: Information Systems Essay topic: Information systems have changed the way we collaborate and work in significant ways
On the example of Taylorism and ERP Systems implementation in the modern context the issues of the modern management are considered. Key words: information system, technology, Taylorism, ERP Systems, scientific management, system of control. Introduction Imagine that your workers are robots.
8 pages (2000 words) Essay
Information Systems. Essay topic: Read Thomas Friedman's article 'It's a Flat World, After All' (available on http://www
The article started with the mention of Columbus and his visit to India. When he returned back to his kingdom, he declared that the world was round. After 500 years, when the author visited India again, and the serious of interactions and observations led him think that world had become flat.
8 pages (2000 words) Essay
Management of Information Systems Essay
(Dunshee, ERPN, 2001, p. 2-3 and Upadhyaya, 2005, p.4-11). This paper presents strategies & methodologies of planning & implementing Business Information Systems and their impact in the overall Organizational Change and Governance of Business pertaining to the case study of Blue Rhino.
16 pages (4000 words) Essay
Strategic Analysis and Selection of Information Systems Essay
In contrast, however, if the initiatives fail, companies then utilize that information in order to learn from their mistakes. It is natural for managers to look back on what they have done in the past and wish they would have done something differently, but important lessons can be learned when one analyzes strategies that failed once they were implemented.
4 pages (1000 words) Essay
Business Information Systems Essay
The case under review reflects the demerits of not having an integrated technological facility in business operations. 1.3 The current system is designed in a way that causes unnecessary delays at many intermediate points in the process flow due to sequential processing of tasks; although parallel processing can be undertaken, yet the management is reluctant to employ it.
6 pages (1500 words) Essay
Geographical information systems Essay
And yet GIS is not without its critics, who argue that it glorifies technology over theory, reducing geography to a ' whiz'vel of description that 'le visually engaging -- provides no substantive analysis. This paper defines GIS, looks at its limitations as well as its strengths, and seeks to predict what the future of GIS may be.
2 pages (500 words) Essay
Information Systems Master Essay
HSBC Bank plc's registered VAT Number is GB 365684514 and its Company Register Number is 14259. HSBC Bank plc is one of the major clearing banks in the United Kingdom. The business ranges from the traditional High Street roles of personal finance and commercial banking, to private banking, consumer finance as well as corporate and investment banking.
8 pages (2000 words) Essay
Essay about Strategic Information Systems
On closer analysis, we find that they are all inter related and have noticeable dependencies between them. All these factors are analyzed and presented in the following essay. Information Management Strategy is the plan to organize and maintain information of the company for the benefit of the users.
8 pages (2000 words) Essay
Managing Information Systems Essay
These environmental changes have placed demands on there IS departments to support product innovation, new production techniques and changing organizational designs and to provide timely, high-quality information. Identifying and handling key issues in the management of IS is essential for executives to support and run their organizations efficiently and effectively.
9 pages (2250 words) Essay
Module: Information Systems Essay topic: Information systems have changed the way we collaborate and work in significant ways. Critically discuss this statement using two concepts from the course
On the example of Taylorism and ERP Systems implementation in the modern context the issues of the modern management are considered. Imagine that your workers are robots. They do not have their maternity leaves and they are not getting ill. This is a perfect cyber
8 pages (2000 words) Essay
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Rate this paper:
Thank you! Your comment has been sent and will be posted after moderation