• 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 heavy amounts of paperwork involved, the employees sometimes make typographical errors during the recording or editing of data, which can merely be something as innocuous as a mis-spelt name but can on occasion result in something a little more serious such as an incorrect telephone number or

  2. Marked by a teacher

    Information Age

    3 star(s)

    * The video might not have fulfilled the law of legislation. * Sources: Question 4: Are the examples seen seem to be fit for purpose? (i.e. They meet the needs of clients and customers?) Source Information Yes the customers are wanting you tube site to be slightly privatised, as issues with harassment videos seemed to heard.

  1. Feasibility Report

    Microsoft Access is a piece of database software; Microsoft Access will allow staff within the Perfect Pie Company to add their customer base, i.e. contact/address details, in return they can use the database they create as part of the mail merge within Microsoft Word.

  2. ICT 3b evaluation

    It also allows him to choose a route, which could allow him to direct his way away from traffic, camera's or congestion charge Zones. The Sat-Nav can also allow Tom to find the longest route to a destination, which could mean that he would be getting more money, as he will be charging the customer an extra amount of money.

  1. Using ICT to communicate

    The text should be spaced out more so that it doesn't look so crowded this would make the leaflet appear tidier. House style It is very hard to keep a house style running through these documents as they are totally different one is a letter and the other is a

  2. ict as level coursework

    Next the buttons have to be added and the text boxes. The customers 'title' will be selected via combo box. This is because there are only 5 options and it inhibits the chance of human error. In order to add the textboxes and the combo box the toolbox will have to be allocated.

  1. Applied ICT in business scenario answers

    Using the results of the analysis of the current system the analyst will need to design the new system. Once the system has been designed and developed, user and technical documentation will need to be produced. 1. (a) Other than observation, describe the methods that the systems analyst could use to research the current systems.

  2. ICT revision notes - IT project management

    Testing âTesting is a crucial stage of the development. Test data should test that all branches of the program perform to specification. Data should be used to test extreme cases. âTesting should also include invalid data to ensure it is rejected. âAny results of testing should be compared with the expected result and any discrepancies should be investigated and corrected.

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