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

    Topic 5: Communication Question 1: What features are available on this type of online service? Source Information * Gmail www.gmail.com * Face book www.facebook.com Gmail in Germany and united kingdom is a free web-based e-mail service provided by Google. Face book is a social networking web site.

  1. Marked by a teacher

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

    This would prevent any errors through using their current paper based system. Computerising allows for data to be backed up easily improving efficiency and accessibility. In terms of the user of the solution, a user is someone who will use the system designed by me ? (The manufacturer/ creator)

  2. According to Weber, what makes bureaucracies efficient? Do you agree?

    Thus, it could be seen that instead of "simple means, procedural regulations become ends in themselves."15 In a sense, the formal aspects of bureaucracy is more important than the substantive ones (serving the client well), and the effectiveness of the whole system suffers accordingly.

  1. A2 ICT CouseWork

    platforms, specifically on the most frequently used platforms by the general public when browsing on the web. As if my website where to not work on one of these platform's I could be excluding up to 40% of my customer base who could of potentially wanted to use our services

  2. ict as level coursework

    Lets start of with shampoo, I have to click on the shampoo combo box, Go to row source At this point the catalogue should be referred to so you can see what cells are needed. For shampoo it is cell A4 to A6.

  1. Crisis Management.

    This is only one reason to stress the importance of training the persons who will be involved in resolving a crisis. The use of a crisis plan decreases quickly when the tasks and procedures described are not tested form time to time for their operational value.

  2. ICT revision notes - IT project management

    Programs are coded, tested and documented. âFiles must be converted into a form suitable for the new system. âHardware must be installed and thoroughly tested as the installation may require extensive cabling and alteration of buildings. Testing âTesting is a crucial stage of the development.

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