• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Converting a Formerly Paper Based System to Excel

Extracts from this document...


Converting a Formerly Paper Based System to Excel BRIEF Design a system using Microsoft excel, on which a small business can run, which is presently paper based. The system should simplify the day to day running of the business and be relatively easy to use. A simple set of instructions must be supplied for the user and a set of detailed instructions in case the system needs to be upgraded. SITUATION The small business I have chosen is a Bagel Bar in Romford (Essex). My Aunt, Mrs Helen Hardy, owns the bar. She has agreed to supply me with any information to help in my project, and give interviews to determine what she wants from the system. INTRODUCTION (Background) Just Bagels is a Bagel bar in Romford (Essex). The bar aside from selling Bagels sells soft drinks, crisps and other snack food and refreshments. It is a small, yet thriving business and has two methods of selling its commodities. 1. Via customers entering the bar and purchasing over the counter. 2. There is an ordering service, whereby offices can make large orders for their buildings, to be delivered or collected. ...read more.


Mrs Hardy would also like the finances transferred over to the computer. SOURCE DOCUMENTS * SOURCE DOCUMENT 1: Order Form The filling out of this order form takes up lots of valuable time, and also keeps the customer placing the order waiting. However everything required of the order form is present. The only data that will have to be entered into the new system will be the assigned item number. When more than one of an item is required it will be entered twice, as this will be quicker. The rest of the information will be worked out by the system * SOURCE DOCUMENT 2: Bagel and Filling stock take I was provided with the stocktaking sheet for 'Bagels and Fillings' there are two more sheets one for 'Drinks' and the other for 'Snacks'. The Stocktaking sheet also has to be filled out by hand, and takes roughly half an hour. The new system should only require data on OBJECTIVES OF THE NEW SYSTEM I also discussed with Mrs Hardy want she wants from the new system, and I came up with a list of objectives, which she approved. * Ordering The orders should be entered directly onto the system. ...read more.


Loaded onto the computer are Windows '98 and Microsoft Excel '97. Mrs Hardy also owns a Desk Jet printer, for hard copy. The development of the system will be split between the school network, and my own stand alone PC, with similar specifications to that of Mrs Hardy's. To transport files between home and school I will be using 3.5" floppy disks. Therefore the files must fit onto them. The school network ____________________________________ ______________ _____________________________. The schools PC's offer user areas for each student, so files will also be stored on the schools PC's. * USERS SKILL LEVEL As the owner of Just Bagels Mrs Hardy will be the main user of the system. She has owned a PC for a number of years and is familiar with its basic use. She has used excel in the past to produce simple charts and graphs. However I will be giving Mrs Hardy a demonstration and be providing her with a user manual. * The daily taking of orders and stocktaking will be carried out by each of the employees at some time, all of the employees have a basic knowledge of computers, although the stocktaking and ordering, should be simple enough for them to handle. * * * * ?? ?? ?? ?? Michael Constantino ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level ICT in Business essays

  1. Business Aims and Objectives.

    This is very important for a business such as Tesco, so they can compare their profit and loss account for each year and they could see what years they have made the most profit and what years they have made a loss.

  2. The business I am going to set up is a snooker club,

    The sales figures for the arcade machines are based on sales forecasts from the snooker and pool tables. The sales came to 3000 units per month, for the arcade machines. I added 2000 units to this figure because people are likely to play two or three games when they play

  1. The Entourage System: A Feasibility Study

    profiles that a casting director may have saved). It will also ensure all actors are represented in the same way for easy comparison and allow data updates to occur wherever and whenever needed with changes appearing immediately. Further to the data aspects, search facilities will dramatically speed up the process

  2. The purpose of this document is to define the Context of Cain Motors Information ...

    Thus increasing business revenue. Change Costs: Staff will have to be trained to used the new systems time will need to be allocated to that either through paying overtime or during staff normal working hours, removing them form their work.

  1. Business Venture - Dance Club

    Once you paid the last payment (usually is 12 moths ) the company might sell it to you back, that how they will make profit, you can walk away and not pay them but also and not taking the equipment, but you can also keep paying back to the company

  2. The history behind the Boots.

    There is only a small aspect of the objective system that it appears the financial function touches on. This is the objective to act towards modernization. Boots keeps its financial records in the form of computer files as apposed to storing them manually.

  1. Fab Food Pix I.T. System

    Assessment Strengths of the present system: * Manual systems can be efficient, if a certain amount of details are known about the desired documentation. - E.g. if the surname and address of a person is known, their telephone number can easily be found in a telephone directory.

  2. Report for StGeorges School computer system

    printed onto a letterhead that the school has printed for them from a local printing firm, one solution that I would suggest to improve this would be to get the school to print their own letterheads saving money which could be better spent.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work