Free Essay

Sample of Pivot Table

In:

Submitted By parves190
Words 3420
Pages 14
[pic]

A REPORT ON
BUSINESS COMMUNICATION PROCESS
OF
BASIC BANK LIMITED

MGT 242: Business Communication

Prepared for

Afrins Farid

Faculty, School of Business

Prepared by

Syed Wahidur Rahman 10310423
Sabiqun Nahar 10310432
Nasrin Akter 08410021 Parvez Ahmed 10310371
MD. Mahtab Hossain 10310388 Kazi Arif Hossen 10310439

University of Information Technology & Sciences (UITS)
April 09th, 2011

Acknowledgement:
I would like to give thanks to those people who helped us to prepare this report and we are very much grateful to them for their cordial assistance, helpful co-operation and essential suggestion.
At first we would like to express deep gratitude to our honorable course instructor Afrins Farid , Faculty, School of Business, University of Information Technology & Sciences (UITS), for her sincere guideline and valuable remarks, thoughtful comments and essential suggestions. She inspired us and gave us encouragement to complete this report.
We would also like to express our gratitude to the all managers and employees of the organization, where we have gone to collect information for preparing my report. We are really grateful to them.
All of the persons stated above played a great role by helping us to make this report a successful one. So again, a special thanks to all of them.

IV

Letter of Transmittal:

April 09th, 2011

Afrins Farid
Faculty, School of Business
University of Information Technology & Sciences (UITS).

Dear Madam,

Here is a report on “BASIC BANK LIMITED”, which you asked us to prepare on the January 31st, 2011. To know about the communication process we have gone to the Gulshan branch of the bank, which we observed as relevant to the topic of the report. The information provided by you in your class lectures was also helpful to us.
In this report, we have tried our best to know about the different communication process played by the bank. Also we have collected information about the background and recent activities of the bank.

Therefore, I hope that our report will fulfill the need to understand the basic communication process that BASIC bank performs. We assure you that the report is totally self- explanatory.

We will be available anytime if you face any difficulty to translate any meaning of this report. Sincerely yours,

1. ………………. 4. …………………
Syed Wahidur Rahman Nasrin Akter
ID: 10310423 ID: 08410021

2. ………………. 5. …………………
Sabiqun Nahar Parvez Ahmed
ID: 10310432 ID: 10310371

3. ………………. 6. …………………
MD. Mahtab Hossain Kazi Arif Hossen
ID: 10310388 ID: 10310439 III

TABLE OF CONTENTS:

|Content |Page |

|A. Introduction | 1-6 |
|Origin of the report |2 |
| 2. Purpose of the report |2 |
| 3. Scope of the report |3 |
| 4. Limitations |3 |
| 4.1. Branch problem |3 |
| 4.2. Shortage of time |3 |
| 4.3. Other problem |3 |
| 5. Background |4 |
|6.Methodology |5 |
|7. Method of collecting data |5 |
|8. Report preview |6 |
|B. Report body |7-17 |
|1.Basic bank and its communication process |7-17 |
|2.Internal communication |9-13 |
|2.1. Formal communication |10-11 |
|2.1.a. Vertical communication |11 |
|2.1.b. Horizontal communication |11 |
|2.2. Informal communication |12 |
|3.Grapevine |13 |
|4. External communication |14-16 |
|4.1. Clients/ Accounts holder |14 |
|4.2.Correspondent banks |14-15 |
|4.3. NGO |16 |
|4.4. Regulatory Authority |16 |
|4.5. Share holder |16 |
|4.6. Financial institution |16 |
|5. Barrier |17 |
|C. Report Ending |18-19 |
|1. Conclusion |18 |
|Content |Page |
|2. Recommendation |19 |
|D. Appended parts |20- |
|1.Appendix |20-23 |
|1.1. Visiting Card |20 |
|1.2. Account opening form |21-22 |
|1.3. Business Letter |23 |
|2.Bibliography |24 |
| | |
|E. Figures | |
|1.Chain of command |8 |
|2. Internal communication forms |9 |
| | |

Executive Summary: the Report
BASIC Bank Limited started its business in 1991 and their goal was to reach banking system more closely to the general people. And this made this bank up to this time. Now BASIC Bank Limited is an improved and modernized bank where the banking system has been easier than the continuing banking system.
Basically BASIC Bank Limited performs major four types of functions – Term Loans to Industries, Full-fledged commercial banking service, Technical Support to Small Scale Industries (SSIs), and Micro-credit to urban poor.

In this report we have discussed in detail about the communication process of BASIC Bank Limited. For this purpose we contacted with Muhammad Kabir Hossain, Assistant Manager, BASIC Bank Limited and we used our text books as references.

1 A. Introduction: 1. Origin of the report:
Afrins Farid , Faculty, School of Business, University of Information Technology & Sciences (UITS), the honorable course instructors of ‘Business Communication’, assigned us to prepare a report on January 31st , 2011 about the “Communication Process of BASIC BANK LIMITED”. The date of submission of this report is April 09th, 2011.
PURPOSE OF THE REPORT:II
2. Purpose of the report:
We are very much passionate to be an executive of the coming days. So, we have to gather more experience beside our study. We do not want to concentrate our lessons only in classroom but to implement it in my practical life that will help me in my professional life. The purposes of preparing of this report are-

-To relate my theoretical report writing knowledge with the practical working experience. -To know about the functions played by the bank.

-To know about the Communication Process of the bank.

-To gather experience of working as a group.

-To get good grades in particular course.

2
3. Scope of the report:
We have collected data from the Gulshan branch of BASIC Bank in Dhaka ; we have mainly tried to cover all the information needed to know about the communication process followed by the bank as well as the various functions played by the bank. We are benefited by working with such an organization which will help us not only to get good grades but also to gather practical experience . The entire interviews are taken from the Managers or various upper level officers of the bank.TIONS
OF THE REPORT
4. Limitations of the report:
Though we are lucky to get the chance to prepare this report but unfortunately we have faced some difficulties. We tried to overcome the difficulties and gave our best effort. When preparing this report, some difficulties we faced a. Branch problem: Some employees of the bank told us that they are not authorized to tell anything about the matter. They also told that only the head office can provide information about this. So it becomes a problem working within branch office. The managers are also very busy, so it was hard to bring their concentration on the matter. b. Shortage of time: This extensive type of report needs too much time to prepare it. But we had to prepare this report within a very short span of time; moreover we had other term paper submission to do. c. Other problem: Some other problems like,
-Traffic jam delayed us in road. -Load shedding caused trouble to work flawlessly. -Non sufficient information in website made the job more difficult. -Being student bearing the related expenditures were tough. 3
5. Background:
BASIC Bank Limited (Bangladesh Small Industries and Commerce Bank Limited) registered under the Companies Act 1913 on the 2nd of August, 1988, started its operations from the 21st of January, 1989. It is governed by the Banking Companies Act 1991. The Bank was established as the policy makers of the country felt the urgency for a bank in the private sector for financing small scale Industries (SSIs). At the outset, the Bank started as a joint venture enterprise of the BCC Foundation with 70 percent shares and the Government of Bangladesh (GOB) with the remaining 30 percent shares. The BCC Foundation being nonfunctional following the closure of the BCCI, the Government of Bangladesh took over 100 percent ownership of the bank on 4th June 1992. Thus the Bank is state-owned. However, the Bank is not nationalized; it operates like a private bank as before.
BASIC Bank Limited is unique in its objectives. It is a blend of development and commercial banks. The Memorandum and Articles of Association of the Bank stipulate that 50 percent of loan able funds shall be invested in small and cottage industries sector.

4

6. Methodology:

-Sources of collecting data:

The report is based on data & information, which have been collected from various sources. They are stated below: a) Primary source
- Interview
- Search through the internet
b) Secondary sources
- Various books related with Business Communication. - Various website.
-Method of collecting data:
7. Method of collecting data:
To do this report first we have gone to the Gulshan branch of the bank. We have also collected information about the banks past history on the internet. Then we have related all those information with the currently studying course “Business Communication.”

5
8. Report preview:

6 B. Report Body:

BASIC Bank and its business communication process:

Communication is a process of interrelated elements working together to achieve a desired outcome or goal. Since communication is a process this means it is dynamic ever changing and unending.
Business communication is the communications which happen in business.

BASIC Bank Limited (Bangladesh Small Industries and Commerce Bank Limited) is a business organization which is a bank in criteria but owned by government of Bangladesh. It is a state owned scheduled bank which works for the progress of Small Scale Industries. Each branch has four departments of Basic Bank such as 1. Foreign exchange 2. General Banking 3. Credit division 4. Desk pass.

Organizational goals:

-To employ funds for profitable purposes in various fields with special emphasis on small scale industries.
-To undertake project promotion on identify profitable areas of investment.
-To search for newer avenues for investment and develop new products to suit such needs.
-To establish linkage with other institutions which are engaged in financing micro-enterprises.
-To cooperate and collaborate with institutions entrusted with the responsibility of promoting and aiding SSI sector.

Chain of Command: BASIC Bank Limited

C=Chairman, BD=Board of Director, MD=Managing Director, GM=General Manager, AGM=Assistant General Manager, M=Manager, DM=Departmental manager, AM=Assistant Manager, OFFICER, AO=Assistant Officer. 7
[pic]8

According to these departments communication happens in two ways: 1. Internal Communication 2. External Communication In below the whole communication process is described:

1. Internal Communication: Communication occurring within the same organizational structure is called internal communication. The internal communications of BASIC bank happen between the branches and within the branch.

[pic] Figure: Flow of Internal Communication
Internal Communication are of two types: a. Formal Communication b. Informal Communication 9
a. Formal Communication: The formal communication in Basic Bank occurs within the organizational framework to maintain the formal rules of communication. The formal communication are given below which is followed by Basic Bank.
** Memos: A memo provides a format for a concise message. It reflects information, makes request and provides responses and presents informal reports of the Basic Bank Limited.
** Interview: sometimes the management of Basic Bank resort to an interview or conversation to exchange their views on different issues.
** Telephone: The size, scope and nature of Basic Bank affect the use of telephone for formal communication.
** Report: The Basic Bank creates a report based on investigation is sent to the authority concerned.
** Notice board: Such a board is used by head office of Basic Bank to send messages to the branches. It must be kept up-to-date and attractive and should be placed where employees make assembly.
** Face to face discussion: Executive officers and employees of Basic Bank many times call for a discussion and interchange views regarding the current problems. This discussion may be regular or irregular and formal or informal depending on the situation.

** Questionnaire and survey: Information about employee attitude, moral and relationship between management and subordinates etc. may be collected by the Basic Bank through the use of questionnaire and surveys.

** Fax: When departments, branches of Basic Bank are scattered in different places then fax is used for communication.

10
** Internet: To create effective and fast communication Basic Bank uses internet.

There are two parts of formal communication
1. Vertical communication
2. Horizontal communication

a.1: Vertical communication:

The vertical communication of BASIC bank exists between supervisors to subordinates.
There are two parts of vertical communication…
-Upward communication
-Downward communication

When the vertical communication of BASIC bank flows from downward to upward (from subordinate to superior ) it is called upward communication.

When the vertical communication of BASIC bank flows from upward to downward (from superior to subordinate) it is called downward communication.

a.2: Horizontal communication: Information exchange between departments or functional units, as means of coordinating their activities.
BASIC Bank maintains horizontal communications between its employees.

11

2. Informal Communication: The informal communication in Basic Bank occurs within the organizational framework to maintain the informal rules of communication. The informal communication are given below which is followed by Basic Bank :

Complaint and suggestion boxes: At some convenient places in the branch complaint and suggestion boxes are kept so that employees can drop their complaint and suggestions, if any, into the box.
Participation in praying: The authority of BASIC bank give opportunity to the officers and employee for praying. Where they get the chance to informal communication.
Informal gathering: On different occasion BASIC bank arranges `informal gathering or tea meeting where employees are encouraged to talk freely about their day to day concerns.
Idea hunt: The BASIC bank limited such even is organized to allow employee participation for creative ideas for betterment of services offered to clients.

12
Grapevine:

[pic]

It is an informal channel of communication. In other word when communication uses in informal or unofficial network, it is termed as Grapevine.
BASIC Bank conducts this communication process in internal communication. If any employee needs to deliver or receive any information or message they directly conduct with the particular employee.

13

External Communication:
Communication occurring within the different organizational structure is called external communication. The external communications of BASIC bank happen between the clients, suppliers, investor, competitor etc.
In below the external communication perform by BASIC bank are given:

Clients/Account Holder: BASIC bank generally deals with Small- Scale Enterprises as well as full fledge commercial banking service including collection of deposit, short term trade finance, working capital finance in processing and manufacturing units and financing and facilitating international trade. For this purpose they 1. Provide accounts opening for different saving scheme. 2. Loan to develop small industries of the country.
Correspondent Banks: BASIC Bank has correspondence with several banks through which they communicate in foreign trades.

List of Banks:

|Bank of Ceylon | |Banque de Commerce et de Placements SA |
|COLOMBO | |GENEVA |
|SRILANKA | |SWITZERLAND |
|SWIFT NO.: BCEYLKLX | |SWIFT NO.: BPCPCHGG |
|ACCOUNT NO.: 1977950 | |ACCOUNT NO.: 10.601998-0-100-CHF-0 |
|CCY: LKR | |CCY: CHF |
| | | |
|Citibank NA | |Citibank NA |
|MUMBAI | |NEW YORK |
|INDIA | |U.S.A. |
|SWIFT NO.: CITIINBX | |SWIFT NO.: CITIUS33 |
|ACCOUNT NO.: 11507018 | |ACCOUNT NO.: 36022105 |
|CCY: ACU | |CCY: USD |

14
| |
| |
| |
|MashreqBank PSC |
|MUMBAI |
|INDIA |
|SWIFT NO.: MSHQINBB |
|ACCOUNT NO.: 61049778 |
|CCY: INR |
| |
| |
| |
| |
|Sonali Bank Limited |
|KOLKATA (CALCUTTA) |
|INDIA |
|SWIFT NO.: BSONINCC |
|ACCOUNT NO.: CIO2ACUD07 |
|CCY: ACU |
| |
|Sonali Bank Limited |
|KOLKATA (CALCUTTA) |
|INDIA |
|SWIFT NO.: BSONINCC |
|ACCOUNT NO.: C102EUR03 |
|CCY: ACU |
| |
|Sonali Bank (UK) Limited |
|LONDON |
|U.K. |
|SWIFT NO.: BSONGB2L |
|ACCOUNT NO.: 0100000424700 |
|CCY: GBP |
| |
|Sonali Bank (UK) Limited |
|LONDON |
|U.K. |
|SWIFT NO.: BSONGB2L |
|ACCOUNT NO.: 0600000424701 |
|CCY: EUR |
| |
|Standard Chartered Bank |
|FRANKFURT AM MAIN |
|GERMANY |
|SWIFT NO.: SCBLDEFX |
|ACCOUNT NO.: 018105510 |
|CCY: EUR |
| |
| |
| |
| |
| |
|Standard Chartered Bank |
|MUMBAI |
|INDIA |
|SWIFT NO.: SCBLINBB |
|ACCOUNT NO.: 22205243254 |
|CCY: ACU |
| |
|Standard Chartered Bank |
|NEW YORK |
|U.S.A. |
|SWIFT NO.: SCBLUS33 |
|ACCOUNT NO.: 3582040650001 |
|CCY: USD |
| |
| |
| |
| |
| |
|Summit Bank Limited |
|KARACHI |
|PAKISTAN |
|SWIFT NO.: AHRBPKKA |
|ACCOUNT NO.: 1-2-1-20315-931-120524 |
|CCY: ACU |
| |
|The Bank of Tokyo-Mitsubishi UFJ Ltd |
|LONDON |
|U.K. |
|SWIFT NO.: BOTKGB2L |
|ACCOUNT NO.: 3301GBPDTF027508 |
|CCY: GBP |
| |
| |
| |
| |
| |

15

NGO: The bank help different Non- Government Organizations(NGOs) to provide SME and Micro-credit loan to the small entrepreneurs of Bangladesh.

Regulatory Authority: The Board of Directors and Central Bank of Bangladesh are the regulatory authority of BASIC bank.The bank provides accurate financial reports, research papers, other documets to them.

Share holder: As BASIC Bank’s 100% share is owned by government of Bangladesh it has no responsibility to distribute the profits but it works for govt. for the development of people and general economy.

Financial Institutions: BASIC Bank maintains communication with different types of financial organizations. In this process it carry on with proper communication skills.

16

Barriers of BASIC Bank:

Communication barriers are the problems that arise at every stage of the communication process and have the potential to create misunderstanding and confusion.

Different barriers to communication of BASIC Bank are described below:

Government interruption: As BASIC Bank is a state hold organization, the govt. interrupts in its banking process.

Complex organizational structure: The more complex structure that BASIC Bank has, the more problem it faces in communication.

Excessive layering of administration: The administrative level of this bank has more layers which creates communication gap between employees and management.

Conservativeness of executive officers: Sometimes officers of this bank are very conservative and ignore to communicate with the employees. This causes barrier to communication.

Low internet speed: Low internet speed occurs when the employees of this bank try to send or receive information through internet.

Facilities: Basic bank offers less facility to the client that’s why the clients are not interested to communicate with this bank.

ATM: BASIC Bank has few ATM booths that are not enough for the clients to fulfill their needs. For this reason clients are not interested to deal with this bank, which acts as a barrier of communication.

Advertisement Problem: BASIC Bank doesn’t promote itself through advertisement. That’s why this bank is not well known to the public of the country.

Geographical barrier: Geographical distance creates communication gap. Sometimes BASIC Bank communicates with other countries. It creates a huge distance to communicate which acts as a barrier of communication. There are time differences are also one major fact of this.

17 C. Report Ending:

Conclusion: BASIC Bank was established as the policy makers of the country felt the urgency for a bank in the private sector for financing small scale Industries (SSIs). BASIC Bank Limited is unique in its objectives. It is a blend of development and commercial banks. The Memorandum and Articles of Association of the Bank stipulate that 50 percent of loan able funds shall be invested in small and cottage industries sector.

BASIC Bank's services are directed towards the entrepreneurs in the small industries sector. A small industry, as per Industrial policy 1999 approved by the Cabinet, has been defined as an industrial undertaking whose total fixed investment is less than Tk.100 million.
The Bank also supports development of trade, business and other commercial activities in the country. It covers the full range of services to the exporters and importers extending various facilities such as cash credit, export cash credit, packing credit, short term loans, local and foreign bills purchase facilities.
BASIC Bank launched a Micro Credit Scheme in 1994. Micro Credit Scheme provides for the poor for generation of employment and income on a sustainable basis particularly in urban and suburban areas.
The bank also provides funds to investment and leasing companies. The Bank has recently created a venture capital fund for equity support to innovative but risky projects.

BASIC Bank runs its communication process in various ways. Such are Internal Communication, External Communication, Grapevine, etc. By using these different forms of communication BASIC Bank communicates with its employees (upper, middle & lower), clients, regulatory authority, and suppliers. In this report we tried to present the basic communication that has been played by BASIC Bank.

18

Recommendation:

1. Being state hold organization it faces difficulty in administrative communication. 2. Customer focus should be emphasized. 3. Advanced training facilities for employees should be arranged. 4. General banking activities needs to be more developed to attract general people (ATM service increase, different savings scheme, easy information facilities, etc.). 5. More advertisement should be promoted to make the bank familier. 6. New technological improvisation should be installed with the existing

19
D. Appendix:

20

21

20

20

rganizational Goals

Organizational Structure
-----------------------
Upward Communication

Downward Communication

Horizontal Communication

Vertical Communication

Informal Communication

Formal Communication

Internal Communication

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

AO

OFFICER

OFFICER

OFFICER

OFFICER

OFFICER

OFFICER

OFFICER

OFFICER

AM

AM

AM

AM

DM

DM

DM

DM

M

AGM

GM

BD

BD

BD

BD

BD

BD

BD(MD)

C

Similar Documents

Premium Essay

Data Analysis

...behavior of 50 couples who are selected from a sample size of 194 couples. 1. Descriptive statistics 2.Histograms 3.Pivot tables 4.Multiple Regression In this model , a scrutiny of the above statistical data will give the tendency to invest in retirement plans and the type of couples who invest and take advantage of the attractive investments in order to avail tax exemption. This report also elaborates on how the different independent variables - Number of children, Salary, Mortgage and Debt- have an effect on the dependent variable, i.e. the percentage of salary invested. Consequently the below tasks will be fulfilled. Step 1-Extracting a sample of 50 couples Step 2-Constructing histograms and point estimates with given confidence intervals Step 3-Inference from pivot tables to explain the preferences of different couples on investments based on independent variables Step 4-Performing multivariate regression and conducting significance tests on beta coefficients R^2 and F-tests and hence establish a correlation of different variables and ensuing effect on investments made. Dataset We have a sample of 194 couples whose financial data along with number of children belonging to each couple have been listed. The financial data includes the following: 1. combined annual salary of husband and wife 2.current mortgage on home 3.average amount of other debt 4.percentage of income invested in retirement plans Step1- Sample extraction In this step, in order to carry...

Words: 1895 - Pages: 8

Free Essay

Business Analytics Handout

...QTM 3650 – Prof. Rick Cleary Class #9–Mon. 2/24/14 I.) Logistics - Return and discuss homework problems 12-14; notes below. Collect problems 15-16. - Final exam time for our class: Wednesday 5/7, 3:30 – 5:30 PM, Gerber 103. - Review schedule for upcoming two weeks: 10Weds. 2/26 | Classification and Regression TreesProject 1 dueTake home part of Exam #1 assigned | Text Chapter 9 | 11Mon. 3/3 | Finish Chapter 9Catch up/review/special topics/Visualization tools | - | 12Weds. 3/5 | EXAM #1In class portion and take home due | - | - A note on ground rules for the in-class exam: Each student may bring one 8.5” by 11” review sheet to the exam with them; OK to write on both sides. The sheet will be turned in with the exam. No electronic devices of any kind except for a calculator that can do simple arithmetic. It’s OK to use a hand-held device (not a laptop) as a calculator as long as it is used only for that purpose. If students don’t have a calculator, Prof. Cleary will have a couple on hand, or students may use the podium computer to do calculations only in Excel. Any connection to the internet or communication to others (texting, etc.) during the exam will be considered an academic integrity violation. - Today’s topics: Finish Chapter 8 on the naïve Bayes estimator and review the Chi-Squared test of independence. II.) Comments on homework problems 12-14. Problem 12.) While we reviewed this last...

Words: 2010 - Pages: 9

Premium Essay

Statistics

...Project Title: Employee retention at D&Y consulting firm Section E: Group 2:Anshul Garg (11FN-015)-Finance Gokul Sudhakaran(11DM-039)-Marketing Kaviya .A. (11DM-057)- Marketing Nikhil Gagrani(11DM-089)- Marketing Sheth Dharmil Nirupam(11DM-147)-Marketing Taru(11IB-061)-International Business Submission Date:- 9th September,2011 TABLE OF CONTENTS 1. Case 2. Objective of the problem 3. Methodology used 4. Analysis 5. Excel output 6. Conclusion 7. Managerial implications CASE: EMPLOYEE RETENTION AT D&Y CONSULTING FIRM Demand for systems analysts in the consulting industry is very strong.  Graduates with experience in the consulting business and those who have extensive computer knowledge are getting great offers from consulting companies.  Once these people are hired, they frequently switch from one company to another as competing companies lure them away with even better offers.  One consulting company, D&Y, has collected data on a sample of system analysts they hired with an undergraduate degree several years ago.  Following are the variables in the attached excel file:  StartSal:  Employee's starting salary at D&Y.  OnRoadPct:  Percentage of time employee has spent on the road with clients.  StateU:  Whether the employees graduated from the State University.  CISDegree:  Whether the employee majored in computer Information Systems or a similar program...

Words: 1889 - Pages: 8

Premium Essay

Opre 6301 Note

...About a population based on sample data Population: all items of interest Sample: a subset of a population Population: all items of interest Measures of reliability: built into statistical processes (p5) two kinds: confidence level & significance level 1. confidence level proportion of times an estimation procedure will be correct90%-99% 2. Significance level: how frequently a conclusion will be incorrect, in the long run. 1%-10% Types of Data and Information hierarchy of data traingel base nominal: lable, catagoty numerical values represent categories…”coding data” how to count =countif(A1:A11)1 (数1 有多少个) =AVERAGE(a2:a11) counting the frequency of the numbers used as codes top :interval middle ordinal data: order distances are not equal, eg. records in marathon values must represent the ranked order of data interval data: all calculations are permissible random variable: numerical alue random outcome determined by chance upon conducting an experiment numerical data:v qualitative (categorical) quantitative (numerical) qualitative data 1. nominal labels, coding, assigned values 2. ordinal order important quantitative data 1. interval differences are meaningfull/usually equal distances 2. ratio differences are meaningfull zero starting point EX p17 2.3 a. interval b. nominal c. ordinal d.interval e.interval 2.4 a.interval b.interval c.nominal d.interval e nominal CHAPTER 2 Pivot table chapter 2 eg.10 p32 Xm...

Words: 627 - Pages: 3

Free Essay

Bae Project

...Homework #2 – Excel Charts and Pivot Tables Overview and Learning Objectives This homework assignment asks you to use Microsoft Excel to use the VLookup function in a report, and also to generate charts and pivot tables. These are all useful skills. VLookup simplifies spreadsheet logic in many situations, and charts offer a visual perspective that can help people to see trends and data relationships. And once you get the idea of pivot tables, they are extremely useful in summarizing data “on the fly” in a variety of formats. This assignment is related to course objective #4 (“Design and implement Microsoft Excel spreadsheets and Microsoft Access databases to support business decision making”). Quality Furniture Enterprises, Continued This homework assignment continues the scenario from Homework #1, about Quality Furniture Enterprises. Caitlin’s uncle (and boss) was pleased with the sales forecast report she created. “I guess I should learn Excel,” he says. “I’ve been using the calculator on my laptop to compute the totals, and then copying and pasting things into a Word document.” Caitlin did her best not to appear smug, but it was nice to be appreciated, especially since this was still her first month on the job. But before she had any time to bask in her success, her uncle said, “And since you did so well on that report, I have another project for you.” So much for taking an early lunch break today. “Sure,” she said. “What do you need?” “First off, remember how I told...

Words: 1904 - Pages: 8

Premium Essay

Learning Organization

...Learning organization For more information about SPSS Inc. software products, please visit our Web site at http://www.spss.com or contact SPSS Inc. 233 South Wacker Drive, 11th Floor Chicago, IL 60606-6412 Tel: (312) 651-3000 Fax: (312) 651-3668 SPSS is a registered trademark and the other product names are the trademarks of SPSS Inc. for its proprietary computer software. No material describing such software may be produced or distributed without the written permission of the owners of the trademark and license rights in the software and the copyrights in the published materials. The SOFTWARE and documentation are provided with RESTRICTED RIGHTS. Use, duplication, or disclosure by the Government is subject to restrictions as set forth in subdivision (c) (1) (ii) of The Rights in Technical Data and Computer Software clause at 52.227-7013. Contractor/manufacturer is SPSS Inc., 233 South Wacker Drive, 11th Floor, Chicago, IL 60606-6412. Patent No. 7,023,453 General notice: Other product names mentioned herein are used for identification purposes only and may be trademarks of their respective companies. Windows is a registered trademark of Microsoft Corporation. Apple, Mac, and the Mac logo are trademarks of Apple Computer, Inc., registered in the U.S. and other countries. This product uses WinWrap Basic, Copyright 1993-2007, Polar Engineering and Consulting, http://www.winwrap.com. Printed in the United States of America. No part of this publication may be reproduced, stored...

Words: 24142 - Pages: 97

Premium Essay

Accounting Information Systems

...| Course Design Guide School of Business ACC/542 Version 3 Accounting Information Systems | Copyright © 2012, 2009, 2007 by University of Phoenix. All rights reserved. Course Description In this course, students examine the fundamentals of accounting systems design. Topics include business information systems, business processes and data flows, database concepts and tools, internal control and risks, auditing the information system, and using the information system to perform audit functions. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality.   Course Materials   Bagranoff, N. A., Simkin, M. G., & Strand Norman, C. (2008). Core concepts of accounting information systems (10th ed.). New York, NY: Wiley.   Hunton, J. E., Bryant, S. M., & Bagranoff, N. A. (2004). Core concepts of information technology auditing. Hoboken, NJ: Wiley.   O’Brien, J. A. & Marakas, G. M. (2008). Management information...

Words: 2104 - Pages: 9

Premium Essay

System

...• System Integrity/Validation and Final Project Summary o Project Summary o Over the past six weeks, our firm has analyzed the accounting information systems of Kudler Fine Foods. We have discussed their current computer system and evaluated the possibility of threats to it and recommend integrated software solutions. The T3 line at Kudler is clearly more data transmission than is necessary for the company, so it was recommended they switch to T1 dedicated line to reduce costs. Due to the importance of inventory control, we showed management how to take their current inventory data tables and construct pivot tables to improve decision making on inventory. Internal controls were reviewed on payroll, accounts payable, accounts receivable, and inventory processes to ensure the accuracy and validity of data. The review determined that if Kudler does not implement the recommended internal controls system suggested, the business could be under serious threats. Information Technology (IT) auditing is another important improvement that Kudlers should make since our analysis showed that there are risks and vulnerabilities in the AIS process. Our final recommendation will be in the way that the audit process is improved by using computer assisted auditing techniques. This will complete the firm’s analysis and recommendations for Kudler Fine Foods. o Our firm last week analyzed and recommended different types of Information Technology (IT) audits that Kudler Fine...

Words: 1144 - Pages: 5

Premium Essay

Linear Programming and Simplex Method

...LINEAR PROGRAMING AND SIMPLEX METHOD Devharajan Rangarajan Department of Electronic Engineering National University of Ireland, Maynooth devharajan.rangarajan.2016@mumail.ie Abstract— An optimization problem consists of maximizing or minimizing a real function by systematically choosing input values from within an allowed set and computing the value of the function. This pays way to a new world of constrained optimization. This paper focuses on one such optimization technique known as Linear programming and one of its method known as Simplex method in detail with examples. cTx = c1x1 + · · · + cnxn The subject of linear programming can be defined quite concisely. It is concerned with the problem of maximizing or minimizing a linear function whose variables are required to satisfy a system of linear constraints, a constraint being a linear equation or inequality. The subject might more appropriately be called linear optimization. Problems of this sort come up in a natural and quite elementary way in many contexts but especially in problems of economic planning. (or Ax ≤ b) I. INTRODUCTION Linear programming is the process of taking various linear inequalities relating to some situation, and finding the "best" value obtainable under those conditions. A typical example would be taking the limitations of materials and labour, and then determining the "best" production levels for maximal profits under those conditions. In "real life", linear...

Words: 1927 - Pages: 8

Premium Essay

Acc 542

...|[pic] |Course Syllabus | | |School of Business | | |ACC/542 Version 2 | | |Accounting Information Systems | Copyright © 2009, 2007 by University of Phoenix. All rights reserved. Course Description In this course, students examine the fundamentals of accounting systems design. Topics include business information systems, business processes and data flows, database concepts and tools, internal control and risks, auditing the information system, and using the information system to perform audit functions. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must be logged into the student website to view this document. • Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending...

Words: 2534 - Pages: 11

Premium Essay

The Impact of Ict in Organization

...1.0 INTRODUCTION 1. Background of the Study: The research investigates the impacts of social networking websites on undergraduate students’ performance at Technology College Sarawak. The variables identified are age, gender, education, social influence and academic performance. Questionnaire will be design based on the requirement to determine the reasons and factors that affect the students’ performance and will be distributed to 30 correspondents, which consist of students in Technology College Sarawak. Social networking is the grouping of individuals into specific groups, like small rural communities or a neighborhood subdivision, if one’s will.  Although social networking is possible in person, especially in the workplace, universities, and high schools, it is most popular online. An online social networking is a place where people build social relations by sharing information’s, interests, activities, or their real lives connections too. It allows users to communicate with each other without limits and boundaries. When it comes to online social networking, websites are commonly used. These websites are known as social sites. Social networking websites function like an online community of internet users. Depending on the website in question, many of these online community members share common interests in hobbies, religion, politics and alternative lifestyles. Once the user is granted access to a social networking website they can begin to socialize...

Words: 6596 - Pages: 27

Free Essay

Aurora Textile Company

...data series homogenous? b) Summarize the data in an appropriate number of classes. Construct the frequency distribution. c) Calculate and interpret for the frequency distribution the average, standard deviation and coefficient of variance. Compare with the results from point a). Explain the differences. d) Construct a histogram and describe the shape of the distribution based on the histogram. e) In which interval is expected that about 95% of the data will fall? Is this assumption true for this data? II. Using the “Pivot Table Wizard” in EXCEL, build a pivot table on your spreadsheet (using also the second variable). You may have to change the order of the rows (You should define the intervals first using VLookup function. III. Calculate the regression line and interpret and test the regression coefficients, coefficient of determination and coefficient of correlation. Interpret the results. Introduction: We chose for analysis a sample of 41 countries, considering the relationship between the following two variables: the Human Development Index(HDI) and the Gross Product per Capita (GDP)[1]. The values...

Words: 1590 - Pages: 7

Free Essay

Impact Jet

...Impact Of a Water Jet • Introduction: Over the years, engineers have found many ways to utilize the force that can be imparted by a jet of fluid on a surface diverting the flow. For example, the pelt on wheel has been used to make flour. Further more, the impulse turbine is still used in the first and sometimes in the second stages of steam turbine. Firemen make use of the kinetic energy stored in a jet to deliver water above the level in the nozzle to extinguish fires in high-rise buildings. Fluid jets are also used in industry for cutting metals and debarring. Many other applications of fluid jets can be cited which reveals their technological importance. This experiment aims at assessing the different forces exerted by the same water jet on a variety of geometrical different plates. The results obtained experimentally are to be compared with the ones inferred from theory through utilizing the applicable versions of the Bernoulli and momentum equations. • Objectives: 1. To determine the force produced by a water jet when it strikes a flat vane and a hemispherical cup. 2. To compare the results measured with the theoretical values calculated from the momentum flux in the jet. • Theory: For the general case shown in figure (1) the momentum flux in the jet is (muo) Where: m is the mass flow rate Uo is the jet velocity just upstream of the vane. After being deflected through...

Words: 2110 - Pages: 9

Premium Essay

Exel 2010 Formulas

...Excel 2010 Microsoft ® ® ® Formulas John Walkenbach BONUS CD-ROM! Includes all Excel workbook files used in the book, plus the complete book in a searchable PDF file Excel® 2010 Formulas by John Walkenbach Excel® 2010 Formulas Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2010 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 7486011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions. Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, and related trade dress are trademarks...

Words: 49651 - Pages: 199

Premium Essay

Business Analytics

...Business Analytics- * Exploring data to find new patterns and relationships (data mining) * Explaining why a certain result occurred (statistical analysis, quantitative analysis) * Experimenting to test previous decisions (A/B testing, multivariate testing) * Forecasting future results (predictive modeling, predictive analytics) Answers the Important Questions Such As: -Why did it happen? Will it happen again? What will happen if we change x? What else does the data tell us that never thought to ask? By Using: Statistical/Quantitative Analysis Data Mining Predictive Modeling Multivariate Testing Microsoft Excell- Microsoft Excel is a spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms,  SAS- SAS is a software suite developed by SAS Institute for advanced analytics, business intelligence, data management, and predictive analytics. It is the largest market-share holder for advanced analytics. SAS is a software suite that can mine, alter, manage and retrieve data from a variety of sources and perform statistical analysis on it. It is widely used in insurance, public health, scientific research, finance, human resources, IT, utilities, and retail, and is used for operations research, project management, quality improvement, forecasting and decision-making. JMP Pro- JMP is used...

Words: 495 - Pages: 2