Creation and manipulation of worksheets

Authors Avatar

         

Name:  

Grade:

Subject: Creation and manipulation of worksheets

Date of Submission:

IDENTIFY

  The National Bank of Dubai was established in 1963 with one branch on the other side of the creek, which was usually reached by abra. And this was how the paperwork and the money reached head office every day!

The Bank was an immediate success, and before long, in 1971, a new Headquarters inaugurated by H. H. Sheikh Rashid, opened beside the creek.

The Bank has kept pace with every stage of Dubai's development, from its foundation as a simple trading harbour in the Middle East, through its years of expansion as an importer and exporter, to its position today as one of the premier cities between Europe and Asia.

In this enterprise oriented business environment, National Bank of Dubai established a very conservative image with total dedication to sound banking practices, efficient service and a protective attitude towards depositors.

Over the years, this prudent approach has proved to be successful for both shareholders and customers alike.

Soon after the Headquarters opened, Dubai joined forces with the other emirates and was on its way to becoming one of the world's most vibrant cities.

Today, the association between the oil business, the port, the merchants and the Bank is as strong as ever. The Bank's involvement now stretches to virtually every sector of the business community.

The ancient creek-based industry of trading silk, spices and gold has now been enhanced by textiles, electronics, furniture and machinery as Dubai expands its trading links. Due to its pivotal role in the past and present prosperity of Dubai, the creek, exemplifies in microcosm the whole of Dubai as an industrious, multi-cultural society.

The philosophy of the Bank has always been to protect valuable traditions whilst embracing the best contemporary business practices.  This spirit has been the inspiration behind the design and layout of the new creek side Headquarters building. We hope this building reflects the good fortune of Dubai, as we continue to provide banking for this ever-changing world.

Descriptions of the current system

 

     

      The system the bank uses is of the loan department which deals with clients requesting a loan. This part of the bank is very important because it brings a lot of profits to the bank.

       

      Loan department

  • Data collection:

The client requests a loan from the Accounts Manager who will carry out a study of the client’s company, profits and cash flows to insure that the loan will be repaid at the right time. Other information such as the size of the loan, the time, purpose, etc are recorded and stored. This information is needed so that when the client wants to withdraw an amount, the transaction is recorded for easy access later. This includes the client’s name, address & phone number as well as the amount and the rate of interest.

  • Processing

 

The accountants make calculations using calculators. The assistants help by checking if any errors are made which are then corrected. These calculations take a lot of time errors are made very often. Rate of interest is calculated.

  • Output

Clerks fill out files with the information given to them by the accountants. These forms are then required to be checked for errors of output.

  • Storage

The forms are then given to book keepers who bind them together and store. A lot of store room is required for the files.

Deposits Department:

  • Data collection:

Information about client is taken like his/her name, telephone no., PO Box and the amount.

  • Processing

This information is then given to accountants who apply the rate of interest and make the required calculations.

  • Output

The files with information are written down by the assistants.

  • Storage

The amount deposited as well as the file are sorted and stored by the book keepers.

Problems faced

       

      The problem this bank is facing is that data is recorded manually which allows errors in calculations and processing to occur.

The employees have to fill out forms, draw charts calculate the rate of interest and do all those tasks required manually so it’s tiresome.

Because of this lots of errors occur and files have to be rechecked after every fill out. This wastes a lot of time which is very important in a business of such type. Another problem is file maintenance. Searching for a particular file takes a lot of time so clients have to wait which means there is lack of client service. These files take up a lot of room and can easily get lost which will be a big problem for business. Because of many tasks employees get very tired during a working day which causes some of them to leave the bank and work somewhere else so that’s another problem because the bank has to waste it’s time looking for an employee and before they hire 1 many clients will be lost. Calculations are done very slowly to ensure that no errors have been made. Any mistake in calculations will cause the client to lose money so there are clients who are unhappy with the service and so withdraw their money from the bank. This bank seems to have many disadvantages which are our task to solve.

Possible solutions

   The possible solutions to improve client service and solve the problem of manual file keeping are:

•Hiring more staff so that employees will be at work

•Computerization which includes packages like

      By hiring more workers calculations can be done more quickly but there are many disadvantages too.

 The first one is that more staff means more costs for the bank. This means that even though service has improved the bank has to still waste money on wages. Then, more employees need more office space so even more money must be spent on additional office space.

Another disadvantage is that if there are many employees there might be difficulties in solving problems because more people mean more opinions.

      The bank will most likely consider the second solution – computerization. Computers added to the business will ensure efficiency in calculations and less errors. Files stored on the computer are more reliable and access to them is fast. Microsoft Excel can be used as a spreadsheet program to fill out forms and make accurate calculations. Other packages like MS Access and MS Word are not likely to be used because they aren’t as sophisticated as Excel is. Just basic training is needed to follow Excel because it’s user friendly and has many functions which make the work of employees much easier and helps them to avoid repetition. The bank might use software like 3S, etc used for Business Accounting but those need highly qualified training which costs a lot of money.

User objectives

The main user objectives are:

  • The system should be user friendly.
  • The system should have less errors
  • It should include graphs and charts showing the bank’s progress and monthly profits.
  • To provide a better service and make clients happy.
  • To cut costs like wages, etc.
  • To insure that employees are happy with their work.
  • To make more accurate calculations and make files more easily accessible.
  • To attract more customers from around the world.

                                   

OPERATING SYSTEM

Microsoft office XP pro is a good software package which includes all kinds of software for a business as well as a home user. It has packages like Word, Excel, Access and PowerPoint which are well known around for their reliability. Microsoft Word can be used for Word processing which includes powerful functions like auto spelling correction and auto formatting. It also includes speech recognition system which is great technology but still has many errors. Microsoft Excel is a spreadsheet package which is well known for its functions. It has many functions that avoid repetition of input and faster processing. Other packages like Access and PowerPoint are used for Database and Desktop publishing.

Join now!

Windows is one of the best operating system used around. This is because most of programs are made for Windows and Windows XP is the best choice because it has the reliability of windows 2000 and a very user friendly interface which makes it the best choice for a business.

Linux is another operating system that is the most reliable OS and a choice for professional users and developers around the world. It is based on a command-line interface and has many shells (Graphical User Interface) which makes it look no worse than and Windows or Mac. The only ...

This is a preview of the whole essay