• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30

ICT Spreadsheet System

Extracts from this document...

Introduction

Introduction about the organisation The business I have selected is a grocery shop called A S Toor. At present they operate in a paper-based system. The owner of the grocery would like to have a system whereby he can have computerised ordering system and stock control. This will help the owner of the shop to be more organised and keep track of when and how many products are sold. Also, how many customers are attending the shop and what time of day the business is doing well in. This will replace the old paper-based method. This will make it more efficient and therefore will have fewer errors. Finally, making the business aware when stock needs replenishing I will investigate the possibility of customising standard application software before the implementation of the system. The current system The current system is paper based. The stock details and deliveries are listed on a piece of document. This is long and strenuous procedure and could lead to mistakes. As it is a paper based system, this means the information on it can be easy lost of altered. To order replacement stock, the owner places bulk orders over the phone with a number of suppliers. The supplier's details are kept on piece of document. When stock arrives, the suppliers send an invoice, which the owner keeps in a filing cabinet. The invoices are separated into different copies. A copy is made for the owner and one for the supplier. This makes it even more complicated and is more of a manual procedure. There are part-time workers, which stock the shelves with the new stock. The people involved The people involved are the main proprietors who run the organisation. They keep all tracks of the businesses going on; how much stock is needed is done manually and can lead to errors. This is because they might run out of stock and there might be customer needing the product. ...read more.

Middle

As it is a computer based system - this would be safer for storage. This is because it can't be damaged, if it is, and then there will be a back up with no cost at all. Sheet Name Process Skill Below is a list of skills that I will learn and going to have to learn during the project. Spreadsheet Application * the 'IF' statement * lookup tables * sorting data out * general sorting * linking worksheets * produce graphs and formulas * naming of cells * Validation * The use of macros 7. Similarities/Differences in Old and Proposed Systems The major similarity is that they have the same data to be inputted. The shop has the same stock and items that they sell. They will be on different formats, where it is proposed in the new system. * Similarities o Same Input Data o Same figures o Items o Prices of Stock * Differences o The data will be stored digitally o The information can be encrypted o Up-to-date stock listing o Instant cash turnover by sales reporting 8. General System Objectives * The new system should user friendly, easy to use interface. Making inputting easy by touch-screen, but can have optional keyboard. * The proposed system should be automated as possible, without any intrusion. * The should not crash and be reliable for its purpose * Finally, the system should secure, not to have unauthorised access to gain personal details and other information. * To Have 100% accuracy in calculations 7.1 Quantitative Indicator * The system should keep over 40 items and 3 suppliers. * The level of stock available or needed should be identified immediately, upon request. * ????? * ???? 7.2 Qualitative Indicator * The proposed system should calculate current stock levels, after sales. * The system should be clear and easy to view. * The new system should have accurate figures, regarding cash registers. ...read more.

Conclusion

It will defiantly make their business much more efficient and professional looking. It will provide fast and easier transactions. Performance indicators o The system should be able to store at least 40 items of stock. - The system does store more than 40 items. o The system should allow the user to input details of customer in 2 minutes maximum, (it currently takes 5 minutes in the paper based system). - The system allows the first time user to enter customer details less than 1 minute. This is better than the previous set indicators set earlier in the project. o The system should be able to cope with 46 customer details. - The system deals with at least 46 customers and it has been very successful. User Documentation CONTENTS 1. Before you install 2. Getting Started 3. General Features 4. Navigation 5. How to do Transactions (Step-by-Step Instructions) 1. This section displays the hardware requirements when using the program. The faster the processor and/or extra memory may increase the performance. Windows Operating system Windows 98 Second Edition Windows Millennium Edition Windows NT 4.0 Windows 2000 Windows XP Processor Pentium 233 MHz (or faster) RAM 64 MB Free hard disk space 26 MB Macintosh Operating system Mac OS X (10.1 or later preferred) Processor PowerPC processor 266 MHz (or faster) RAM 64 MB Free hard disk space 36 MB Additional QuickTime 2. * In order to use the program you will need the MS office package, more specifically MS Excel. Once the package is installed on your computer, you can access the program. * Click on the icon ASTMS * It will load and start on the Main Menu. 3. This package is excellent for making your business much more profession and makes you more money, quicker. This is the complete package from stock management to printing a receipt for a customer. It is very user friendly. This will carry out all the account in the business. 4. 5. Step-by-Step Instructions 5. Continued ?? ?? ?? ?? Outline portfolio - incomplete but can be looked at as Exemplar 1 ...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 Information Systems and Communication 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 Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    Due to the messiness and illegibility of the handwriting on the customer's record, the employee that was trying to contact the customer read one of the digits wrongly on the telephone number, and thus it turned out was dialling the wrong telephone number the whole time!

  2. Marked by a teacher

    I have been asked to create an ICT solution for a local events and ...

    And the last form of data capture that I will use is, I will analyse previous paperwork and documents. I will look at previous forms of data produced by the user and see what type of data they produce. This will allow me to see what they are dealing with on a daily basis similar to observations.

  1. Applied ICT - How Comet Stores could use ICT and a CCTV system.

    If a firm is able to increase its market share, it shows that it is winning customers from its competitors; so many businesses have increasing market share as one of their key aims 6. objectives can be met with the current resources available to the business, as long as it

  2. From the e-commerce strategy you gave me earlier I understand that by having a ...

    If the veracity of the information is called into question you should ensure it accurate and correct and if not you should amend or delete it. The individual could provide documentary evidence, such as birth certificates and paper invoices. When the integrity of the information in dispute it is good

  1. A2 ICT CouseWork

    It will inform the user about the company and our history, we know this kind of information is good for the business and perhaps even more so for the customer's; as it give's customer's an insight into the business and lets them feel much more secure in their purchase, as their know who they're buying from.

  2. Feasibility Report

    hard drive, printers, and lastly a scanner to insure that their company is fully computerised. Firstly the Perfect Pie Company will need a monitor to display their actions on screen, a keyboard will allow the Perfect Pie staff to type letters, functions, information for PowerPoint's and calculations into Spreadsheets; a

  1. This report examines a detailed action research process, Soft Systems Methodology (SSM) and discusses ...

    the activities relating to thoughts about the problem situation are shown below the dotted line. To allow a better understanding of the complexities of the situation, the method allows the problem situation to be suited from many points of view.

  2. Communication & Employability Skills for IT. OCR Cambridge Technicals Unit 1 LO1-P1

    The IT technicians need to make sure that data has been properly formatted to prevent others from accessing their data. This also comes under the data protection act because this is all about the personal data held about individuals. RSI RSI stands for repetitive strain injury: this happens when you

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