• 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.

    In Tesco, security guards are located at the main entrance to the site to keep the store secure and to make sure nothing gets stolen. Tesco has to have constant security as there are some very expensive items in the store.

  2. Report for StGeorges School computer system

    why this is a problem to the users or for the system in general * The first computer in the system was introduced back in the 1990's and so it doesn't have the more up to date features as the other computers Operating systems and cant benefit from the technology the other computers can because of its compatibility.

  1. Business Venture - Dance Club

    music, and this shows that the hip hop music is making a huge impact on people's tastes. Because of that fact I want to do something different, a nightclub playing different sound. Of course we will have one of two nights playing hip-hop but the main sound would be Techno/ House/ Trance and Progressive mixed with club and dance music.

  2. The Entourage System: A Feasibility Study

    The display of the pictures of matching actor's profile will be randomize for every search and refresh irrespective of, if the same search criteria are used or not and the user will be able to click on any of the pictures to view the actor's profile.

  1. 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.

  2. 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.

  1. The history behind the Boots.

    The main disadvantage is the possibility of loosing control to shareholders. This is a possibility but at the end of the day both parties want the profits to increase and the business managers have the businesses best interest at heart.

  2. Mind Tools Memory System Grades.

    * The setting sun shines down onto a field of CORN (Cornwall). * The CORN is so dry it is beginning to WILT (Wiltshire). * The Wilting stalks slowly fall onto the tail of the sleeping DEVil (Devon). * On the Devil's horn a woman has impailed a Glossy (Gloucestershire)

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