Free Essay

Business Infomation Systems

In:

Submitted By ronnie666
Words 562
Pages 3
For part B

Question 1

For this question we had to calculate the average, median, maximum and minimum values for Duration of Visit, Bandwidth, and Viewed Page.

To calculate the average, you first need to select the cell where by which you want the average to be put into then the formula for example “=AVERAGE(J6:J98)” is typed in the formula text box, after the formula is typed then you click enter. Then the average will be calculated and place in the cell which you selected.

To calculate the median, the process is the same only that you change the formula that you type into the formula text box. The formula typed is “=MEDIAN(J6:J98)”. In the formula, the numbers in the brackets are the names of cell from which the median needs to be calculated. For the above median, the median was calculated from the numbers that existed from cell number J6:J98.

To calculate the Maximum value, it’s the same process only that the formula changes to “=MAX(J6:J98)”. This formula will be used to calculate the maximum value existing between cells J6:J98.

From calculating the minimum value it is also the same process only that the formula typed into the formula text box changes to “=MIN(J6:J98)”. This formula will be used to calculate the minimum value existing between cell J6:J98.

Question 2 For this question we have to calculate and display the mode for Bandwidth and Viewed Page.

To calculate the mode, you first select the cell in which you want the mode to be written in then the formula “=MODE(K6:98)” is typed into the formula text box. This formula will calculate the mode of numbers existing from cell K6 to cell K98.

Question 3 For question 3 we had to prepare an appropriate chart for Donnie to compare the number of pages viewed in “January”, “February”, and “March”. First before we draw the chart, we had to calculate the total amount of people who viewed the web-sites in January, February and March. To calculate the websites view in January, the formula “=SUM(L6:L35)” is put into the formula text box. Then for February, the formula “=SUM(L36:L72)” is typed into the formula box. As for March the formula “=SUM(L73:L98)” is typed. Then after the table for web-sites viewed has been got then this tables can be used to draw the charts.

Question 4 For this question we had to find how many times the web-site connection link were used to connect to Donnie’s web-site. For example to find the “hotbot” link the formula “=COUNTIF($F$6:$F$35,B125)” is used. The formula is the same for the rest of the links, only that the cell numbers in the formulas will change.

Question 5 For this question we have to show the percentage of visitors that added Donnie’s website to their favorite links. Display the result by using appropriate chart and to calculate the percentage the count if function can be used. For example to count visitors who added the web-site to their favorite list then the formula “=COUNTIF(G6:G98,C140)” is used. While for the visitors who did not add the link to their favorite then the formula “=COUNTIF(G6:G98,D140)” is used.

Similar Documents

Premium Essay

Clarifying Business Strategy Through Database Analysis

...|Title |IT205 Smart Scenario - Clarifying Business Strategy Through Database Analysis | |Event Coordinator | |What are the current problems that the Event Coordinator is having? (multiple choice, multi-select) | | | |☐  System is disconnected from other departments. | |☑  Too much manual intervention in the business process. | |☐  Required information is not always available. | |☐  Information retention is inefficient or non-existent. | |☐  Poor use of available information technology resources. | |☑  Insufficient use of database technology or tools. | |☐  Poor communication. ...

Words: 861 - Pages: 4

Premium Essay

Paper

...Organzitonal structure is very importnat when it comes to many organizations from day to day business. Withougt a organization structure there the company itself will not run properly, and the company may become in danger of staying open. Organizational structure will help mangers make decisons, based on the comopany needs. When the organzitonal plans are in affect using the organizonatl structure no matter how large or how small the company is the company itself will determine the structure. The company that I choose to discuss in this paper will be Best Buy. In this paper I will compare and contrast Best Buy to other compnaies structure, and also I will eveluate the company marketing, finance, human resources, and operations etc. I will also explain the company designs such as geographic, functional, customer-based, product, service, hybrid, matrix, marketing channels, and departmentalization. Best Buy Structure Best Buy was founded in 1966 by Richard M. Schulz and Gary Smoliak. The store itself started out being the name Audio Speciality store, and when the company itself expanded the company switched ober to Best Buy in 1983. Best Buy is multi business that has expanded throughout the entire world. Best Buy has designed to have maximzed the business by providing different business situations, for different individulas and different businesses. The indivudlas who help run the organizational structure are President, Vice Presidents, Board of Directors etc. Over 2000...

Words: 749 - Pages: 3

Premium Essay

Information Technology

...Chapter 1 1. How can information technology support a company’s business processes and decision making and give it a competitive advantage? Give examples to illustrate your answer. The term information technology refers to the various hardware, software, networking, and data management parts that are a necessity for the system to function (pg. 8). Businesses regularly utilize computer-based information systems in order to record customer purchases, keep track of inventory, pay employees, buy new merchandise, and evaluate sales trends. Without the support of information technology, businesses would ultimately fall apart. For example if a business did not choose to use computer-based information systems, they wouldn't be able to evaluate what items were selling better than others and ultimately lose valuable information for future success. Information technology can also aid in decision making for a business. Decisions are made based on analysis provided by computer-based information systems. For example a store manager may make the decision whether to discontinue an item for sale or keep it on the floor due to analysis of sales trends provided by computer-based systems. Lastly information technology helps business gain a competitive advantage. A competitive advantage is gained through computer-based information systems by applying innovative application of information technologies (pg. 9). For example a store manager installing touch screen kiosks throughout the organization...

Words: 1404 - Pages: 6

Free Essay

Afety Andsecurity System:

...Safety andsecurity system: a)fire detection and alarm. B)close circuit television. (A) safe and secured electical wiring is requring forfire alarm system. At the time of fire broke up in an building the fire alarm wiring and accessories must have the capacity to stand forcertain timeso that alarm etc. For fire alarm there are various system like manual automatic bellpaging telephone etc. In automatic alarm system sensorsare instaled in floor or a strategic locations . all control are being done in the centrally located control panel. (B.) close circuit television: most ofsecurity surveillance system coordinating latest inforation technology use cctv system normaly used in banks supormarketstop secured offces labaratoris industries and so on conventional cctv system use video cassetes for recording and playing images . with igh technology video recording can be stored into personal computer.captured videos will be digitally compresed and stored in to the hard diskof personal computer without the use of video cassette.type of switches: a single pole sinhle throw switch is two terminal elements. Its function is to connect the two terminals by shorting them or to disconnect the terminals by opening the path between them. We are familiar with use of such a switch in operating the electical appliances we use in our homes and offices. There are others switches with more terminals . however in...

Words: 722 - Pages: 3

Premium Essay

Effects of Technology on the Accounting Profession

...Effects of Technology on the Accounting Profession University of Phoenix ACC/340 Accounting Information Systems Effects of Technology on the Accounting Profession Businesses have become more competitive, consumers are more informed, and technology has changed the way the world communicates. Information technology (IT) and the resulting ‘information age’ are continuously impacting every facet of accounting. (Bagranoff, Simkin, & Strand-Norman, 2006) This paper will examine how accounting information systems (AIS) are bringing about changes within the accounting profession. Additionally, a variety of technologies and how they affect accounting practices at Exclusively Yours Salon will be discussed. Accounting Information Systems and the Accounting Profession Today’s business environment is marked by increased competition and the need for better and faster information for decision making. According to Bagranoff, Simkin, and Strand-Norman, 2006: Because IT now captures transactions, AISs can produce financial statements almost in real time. Of course, some of the adjustments that accountants must make to the records are not done minute-by-minute, but a business can certainly track sales and many of its expenses continually. (p. 15) Additionally, large amounts of accounting records are increasingly presented only in an electronic fashion. Companies are reporting their financial outcome quarterly and an increasing number of companies are transferring their financial...

Words: 1072 - Pages: 5

Premium Essay

Week 3 Reflection

...software * * “Common Hardware technologies used in business include: Desktop computers, laptops, mainframes, MS Windows, Mac OS, Unix, Linux, servers, web servers, and blade servers. Common Software technologies used in business include: enterprise applications, productivity and Office Applications, communication and information-sharing software, and entertainment and Media development software.” (Management Information Systems, 2013). * * The most popular software that is used amongst businesses are Accounting software called Intuit QuickBooks Pro, Backup and recovery software called Mozy, Blogging Software called WordPress, Calendar software called Sunbird, Collaboration software called Vyew, Collaboration and Office Suite software called Google Docs, CRM software called Salesforce.com, and Database software called FileMaker Pro. For the popular hardware used in business are servers, workstations, laptop and desktop computers, network switches, routers, cell phones, blackberries, PDA’s, GPS devices and many more. * * Use of databases and data communication technologies * * Besides the high importance of software and hardware that is used in virtually every business, databases and data communication technologies is just as important. There are main elements that make up databases and data communication for all three of these business: * Database Processing: is the system of collecting, storing, and processing data for the purpose of...

Words: 1523 - Pages: 7

Premium Essay

Amazon Value Chain

...We can identify different Strategic Business Units in the pharmaceutical market : - Ethical drugs - Generic drugs - Biotechnological drugs - OTC drugs - Vaccine drugs PESTEL : Political : - In the Pharmaceutical market, the government has a huge impact concerning the existence of an universal coverage system in some countries like France (which is concerned as the country with the most efficient health system in the world), this unable to introduce latest treatments but share benefits with people giving the chance to poor people to have access to treatments. The US government is thinking about instoring a system like that. - Stringent government regulation, the government can control the prices, for example in the European Maket. That led to create parallele trade, thanks to the free trade agreement and with with the principle of free move of goods, the distributors can ship low-price drugs in low-price market in order to sell them in high-price market. - There is no formal government price control in the US which create a complete paradoxe with Canada, where the same drugs are cheaper than in the United States. In Canada there’s a stric regulation control, prices are inflexible and Canada has reimbursement criteria. - After the thalidomid tragedy which caused birth defects, the governments had to regulate the market and that led to the increasing of controls on trials. - Limit for the duration of patent protection...

Words: 1693 - Pages: 7

Premium Essay

Gap the Up and Coming

...A. Provide twelve business terms and definitins that are new to you that are used by this company. Franshisee- Aperosn who buys a franchise Profit- revenue minus expenses Mission statement- outlines the organization's fundamental purposes. Importing- buying products from other countrie Exporting- selling products to another country Contract manufacturing- foreign company produces private label goods to which a domestic company then attaches its own brand name or trademark. Integrity based ethics code- define the organizations guiding alues, create an environment taht supports ethically sound behavoir Corporate social initiaves - enhanced forms of corporate philanthropy directly related to the company's competencies. Insider trading- uses private company infomation to further insers own fortuenes or those of their family and friends. Unified system- this happes after managers have decided a course of action now they need to organize the fimr to accomplish their goals. Middle management- this includes gernal managers, division managers, and branch and plant managers. B. Discuss the organizationl structure of the business relative to these five functinal areas: Marketing - The different forms of marketig, sales, and adverting for Gap are television, radio, credit card discounts, mail, and email. Gap spends a certain amount of money on advertising everymonth, and if they do not feel as though they are getting the response they hoped for they will pull the plug...

Words: 1651 - Pages: 7

Free Essay

Chapter 3

...4. The implementation of networking technology has created more risk for businesses that useinformation technology because business networks are now connected to the internet andother networks external to the organization. This has made it easier for people to gainunauthorized access to the organizations networks. 5.Information extortion occurs when an attacker steals information from a computer system anddemands compensation for its return or for an agreement not to disclose it. For example, if a hacker gains unauthorized access to a celebrity’s computer and discovers embarrassing photosor videos of the star, he could then blackmail the star into giving him money in exchange forkeeping the photos quiet. This causes not only a monetary loss for the celebrity, but also a loss of privacy . 6. Employees constitute one of the greatest threats to information security because employeemistakes can lead to the revelation of classified data, entry of erroneous data, accidentaldeletion or modification of data, the storage of data in unprotected areas, or they could fail to follow procedures to protect data. 7. The first, most basic step is to set up the computer so that the screen and keyboard are not visible to persons passing by. If you have an LCD monitor, adjust the viewing angle to makew it as difficult as possible for anybody else to read your screen. Also, be aware of all people near the computer; frequently look and verify that no one is watching your screen or keyboard. If someone...

Words: 2053 - Pages: 9

Premium Essay

Growth of Non-Profit Marketing

... Non-profit marketing it is activities and strategies that are used by a non-profit organization. Non-profit marketing plan is a part of an organization strategic plan. It requires organization target, competitors and programmers. Non-profit organization helps to give the message of the organization. It is also donation and call for volunteers. It exposes the organization to an outside audience by creation of logos, slogans, copy and development of media campaign. Non-profit marketing is using to build the organization’s image and reputation in society. Non-profit marketing is use of marketing tactics to the goals and objectives of non-profit organization. It is important because it provides services that would not be provided by the business society. Many services cannot get the profit but it helps to provide good services to the society. Non-profit marketing is growing all over the world. Organizations increase competition for potentially scare donation resources. Early in the history non-profits meets the worlds inhabits such as humans and animals, to provide help and support as a part of religious reasons, social tasks or political reasons. Today it spreads in areas covering needs, which government or any private sectors cannot meet. In today’s world nonprofits acts as a major role by providing various changes to the organizational sectors as well as social behaviors. For example, they provide large scale of employments, bringing education, provide health care and curing...

Words: 2529 - Pages: 11

Free Essay

Communication

...QUESTION 1 Explain in details how development in communication technology has improved business communication with particular reference to * Computers * Internet * Networks * Email * Telefax * Video conference ANSWER Computers Computers have affected the business world in a very significant way; they have enabled business people to be able to communicate more efficiently. Nowadays we rely on computers in every aspect of our life’s, to make bank transactions, to run automobiles and even at home. Most business people use computers to communicate since it is much faster and effective. Advantages of computers 1. Computers are used as a tool for fast communication, one can send emails or scanned documents to another person and the message is received by within some few minutes. 2.a business man can use a computer for the purpose of record keeping one can store a lot of information in a computer ,it eliminates the use of files which can use a lot of space for storage. 3.it is easier to find a specific file if you want to share the information with the use of Search an application that allows the user to find documents very easily. 4. People can communicate across the globe, one can send an email to a person who is miles away and it is cheaper than a phone call. 5. People can work at home, with a computer one can work at the comfort of their house since you can submit your work via emails and a boss can also give instructions to employees with the use...

Words: 1955 - Pages: 8

Premium Essay

Fraud Control

...ACCOUNTING INFOMRATION SYSTEM TABLE OF CONTENT INTRODUCTION ............................................................................................................................................. 2 FRAUD ........................................................................................................................................................... 3 Internal Fraud ........................................................................................................................................... 3 Procurement fraud.................................................................................................................................... 4 Online safety ............................................................................................................................................. 5 Cheque Fraud ............................................................................................................................................ 5 INTRODUCTION OF COMPUTER VIRUS TO THE SYSTEM .............................................................................. 7 UNINTENTIONAL ACTS/MISTAKES. ............................................................................................................... 7 CONCLUSION................................................................................................................................................. 8 REFERENCES ......................................................................

Words: 2181 - Pages: 9

Free Essay

Important

...significant interchanges player in Asia and Africa through our key ventures in five local versatile administrators, in particular Telkomsel (Indonesia), Globe Telecom (the Philippines), Progressed Information Administration (Thailand) and PBTL (Bangladesh).(About us, n.d.) The Gathering likewise has speculations in Bharti Airtel (India), which has critical vicinity in Sri Lanka, Africa and Bangladesh.As a key financial specialist, they work nearly with their members to develop the business, by leveraging their scale in frameworks, customer touch base at and broad operational experience .Singtel's offshoots profit not just from the association with Singtel PESTEL 2.1 Political factor Singapore is a political stable venture nation . The ministry of Trade and Industry and the ministry of Finanance are accountable for developing the economy in Singapore, encouraging genius endeavor enviroment and joint effort with industry masters will help manage it as a world class money related and business center point (political factor, 2010) 2.2 Economic factor Despite the fact that globalization has...

Words: 2455 - Pages: 10

Premium Essay

Walmart Internal Environment Analysis

...Internal Environment Walmart: 1.Company Profile : * History : Walmart is a well known American company that operates retail stores including grocery stores, discount stores,wearhouse , clubs and combination of general merchandise store. It was founded in 1962 by Sam Walton along with his brother Bud in Rogers Arkansas. At the beginning he opened more stores in Arkansas but later he expanded walmart to Oklahoma and Missouri in 1968. In 1972 the company listed in the Newyork Stock Exchange. Walton group also introduced the Sam's Club Warehous store in Iowa ,Nibrasca ,Indianna in 1983. During 1980's the company rises considerably by reaching 25.8 billion dollars sales with almost 1,525 stores and 271,000 workers at the end of the decade. In 1990's walmart considered as a largest retailer of the nation and it continued the acheivement by opening more stores within an outside country. The company entered in Japan by buying 36% stake of Seiyu in 2002 and Walmart increased its stake about 67% in 2007.According to the fiscal year sale of Walmart is about 469.2 Billion in 2013 with 2.2 million workers worldwide and 11 thousand stores under 69 banners in 27 countries. * Scale of Operation: The strong market position is the main strength of Walmart with more then 400 billion dollars revenue and almost 11 thousand stores worldwide and consumer trust that differentiate walmart from its competitors. Walmart can also acheive higher profit because of its huge size and it has a strong...

Words: 3457 - Pages: 14

Premium Essay

Nestle Erp

...2010 INFORMATION MANAGEMENT PBSA 823 Chicken Run Group Assignment Lecturer: Mr. J. C. Coetzee 9/18/2010 Nestlé struggles with Enterprise Systems CRITERIA FOR MARKING MBA-ASSIGNMENTS 1 | Meeting the objectives of the assignmentThe extent to which: | 60 | | *1.1 | the assignment was understood and answered comprehensively | 10 | | *1.2 | independent (own) thought is reflected | 10 | | 1.3 | insight in the topic was demonstrated | 10 | | 1.4 | logical, systematic thought and reasoning is demonstrated | 10 | | 1.5 | quality research (literature study and / or empirical work) was done | 10 | | 1.6 | conclusions are logic, meaningful and substantiated | 10 | | 2 | Presentation and technical aspectsThe extent to which: | 30 | | 2.1 | the content shows a logical andintegrateddevelopment and forms a balancedholisticwhole | 15 | | 2.2 | the executivesummary reflects the content comprehensively and meaningfully | 5 | | 2.3 | the table of contents, references and list of sources are noted correctly | 5 | | 2.4 | the style and language (grammar) meet the requirements | 5 | | 3 | General quality rating | 10 | | | Evaluator’s general evaluation mark of the assignment’s quality - taking into consideration the above and other factors | | | | TOTAL | 100 | | Assignment Word Count: Chicken Run Group Members “There is nothing more determined than poultry with a plan…” Bezuidenhout, P.J. 1224 6093 Botha...

Words: 4468 - Pages: 18