• 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 where all the letters are sorted out into piles so they could g be sent off to the right departments or to the right person. Tesco keep their records in a variety of ways. Paper based records are kept neatly and clearly so it can be easily found in the future.

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

    Communication Example of a Use Case Diagram (Example adapted from Prudential-Bache market research) Each of the actors would be defined within the UML documentation, including a description of what the role is. Each of the use cases would be expanded into separate documents, which consists of a "happy days" basic

  1. Report for StGeorges School computer system

    in the school as well would it be more efficient and save money if only one was given to one family? As the school has many young pupils they may loose them or leave them on the bus or even drop them on the playground.

  2. Business Venture - Dance Club

    so our customers would enjoy themselves. We will offer different music choices and variety DJ's in order to keep the club fresh and to be interesting place for the customers. However we will keep our main style: techno/house /progressive. We will provide high-energy dance music at Dance Club Plazma.

  1. The Entourage System: A Feasibility Study

    This must be able to handle pictures, text details and other types of data the castting director and agents require. It should be possible for the users to upload information themselves. * Content being saved for further reference should be checked for updates in order to ensure consistency of representation.

  2. Blue Water Estate Agent (BWEA) - design a computer based system

    They should know the details of the customer and the property owners so they can update the users on any further information. They can do this by sending out information through letters when either a suitable house is found or a person is interested in their property.

  1. Design a computerised system for a newsagents account system

    Performance Indicators The computerised system will make it easy to store documents and searching for relevant information will be made a lot easier. Floppy disks can save lots of information compared to files of paper and also it should work out more cost-effective.

  2. The history behind the Boots.

    used for vital expansion in order that the company to take a new route in business or gain capital it needs to ever have a chance of making a break. In selling shares it means that the business has limited liability, meaning that they can not loose any more money than that invested.

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