• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 6584

Creating a computer system.

Extracts from this document...

Introduction

TABLE OF CONTENTS ANALYSIS 3 Problem Statement 3 The Systems Lifecycle 3 The Company's current system 4 The Input, Output and Processing of the Current System 5 Data Flow Diagrams of the current system 6 The Problem with the existing system 7 What the new system has to do to satisfy the user's requirements? 7 The New System 8 Objectives of the new system 13 Performance Indicators 14 The resource requirements 14 User's skill level 14 DESIGN 15 System Design 15 Conclusion 16 Comparing a database package and an excel package 17 The final package for the system 17 Features of Excel 18 Overview of the System 19 Data Flow Diagram of the proposed new system 19 Manual Designs of Worksheets 22 Manual Designs of forms 28 Explanation of Worksheets in the system 31 Macros for each workbook 31 Security 31 Test Strategy 31 Test Plan 31 Test Data 31 Schedule of Activities 31 What Data Needs to be stored 31 Analysis Problem Statement I have been asked to investigate a problem by Mr. and Mrs. Bains. I will develop a computerized system for Surinder and Pinder Bains who own an off license wine shop, called 'The Wine Barrel' on Victoria Street in Englefield Green. In their shop they sell various types of wine and alcohol. In addition to this they sell crisps, sweets and chocolates and non-alcoholic drinks. They have been running this wine shop for 15 years now. When customer purchase goods from the wine barrel, they are given an invoice, (produced by hand) showing the totals of the goods bought. All invoices are written in a book by hand. The book contains carbon copies, so when they write invoices, they give the original to the customer, and keep the carbon copy of the invoice themselves. The business then keeps a copy of this invoice and files it away. At the end of each week, Mr. and Mrs. Bains count the invoice totals manually, to work out the total Gross Profit. ...read more.

Middle

There will be a heading for the graph. > There will be macros to print the charts, return to the main menu, and create a new graph with the new months figures. User > The user will need to click on the macros, which print the charts, create new charts and return to the main menu. PROCESSES User > There will be macros to print the monthly charts, create new charts and return to the main menu. OUTPUTS User > Screen output of the charts > A hard copy of the chart for the business. > The main menu form The Stock List INPUTS Designer > Various headings and sub-headings for the stock lists will be: o Product Code o Product Name o Description o Amount in stock o Unit Price o Stock Status > There will be macros to print the stock list, update the stock list, return to the main menu, edit products and add products to the stock list. > There will be a form to add product details > There will be an IF Statement in the stock status cells. This will tell the user if the stock levels are low or high. For example if the level of stock is lower than 15 the cell should say 'Low'. User > Entering or editing products. > They will also need to click on the macros, which will print the stock list, add stock, update stock and return to the main menu. PROCESSES User > When the user clicks on the add or edit product buttons, forms will appear so the user can enter the correct details. When they have finished adding in the details the details will go into the stock list. > There will be macros to print the stock lists, add new products, update the stock table and edit products. > There will be formula under the stock status column. ...read more.

Conclusion

This will allow them to go to the worksheet that they require. They will also be able to print off each worksheet, using a macro. There will be a number of macros on each worksheet, which will make it easier for the user to complete tasks on the system, for example, printing the sheet. Data Flow Diagram of the proposed new system Below is a data flow chart. A data flow chart shoes how data flows through a system. Here is the data flow chart for my system. Below is the data flow chart for the Stocks sheet Below is the data flow chart for the invoice sheet Below is the data flow chart for the Balance sheet Below is the data flow chart for the Charts Worksheet Manual Designs of Worksheets Below are the manual designs, of the worksheets in my system Manual Designs of forms Below is the design of my main menu form, which will appear when the user opens the system. There is also a macro on each worksheet, which allows the user to go back to the main menu, and go to another worksheet. Below is the design of my Add products form. This will appear when the user clicks on the add product macro in the stocks form. Below are the designs of the forms, which will be in the invoice sheet. This particular form is the first part of three forms, which allows the user to choose whether the customer is an existing or new customer. This is the second form, which allows the user enter the Customer ID. It appears when the user clicks on the form above, on the existing customer button. This is the third form, which allows the user enter the new customer details. It appears when the user clicks on the first form, on the new customer button. This is the third form, which allows the user enter the new customer details. It appears when the user clicks on the first form, on the new customer button. Kam Bains 8010 Page 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 GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Different types of technology How I use ICT at home and at school

    While the school can't afford an expensive anti-virus for all the school computers, they don't have any extremely good anti-virus software as of date. However, they are heavily protected by firewall which is sufficient enough, seeing as how the entryways viruses would usually come in with are blocked.

  2. Creating a computer system for a video rental shop

    * The hardware suppliers gave a vague specification for Tower Case, motherboard and the ATX power supply * Only 20GB of hard disk space, this my not be enough * Win 98 keyboard, this is a old keyboard which does not take advantage of windows ME keys such as logoff .

  1. Introduction to information skills and system. An information system is a system that accepts ...

    However it uses sequential memory access, which takes a lot of time. e.g. video tape. Good for back up. Magnetic disk works the same as magnetic tape, but with a circular piece of plastic/metal. E.g. hard disk / floppy disk.

  2. Database design.

    After you complete the above window click ok and the following window will appear this window is for grouping your report choose one and click next Then this window will appear which is for sorting your field's e.g. in alphabetical order or by numeric order.

  1. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    Our first and most important problem is that it takes too long. When someone wants to take a game out we have to have to take the card out of the games case. Then we write all the appropriate information on it and store it away.

  2. Database advantages and disadvantages for a user.

    Space required is much less With Space efficient, database system is required less space because database you can have more than one database on one computer but with the cards they have to have all the records with lots of different cards and it can takes ages and valuable time to find.

  1. Benefits of using my IT system in the Travel Agents.

    * After that, you should select the amount of Copies you want and then you choose the Printer that you want the file to be printed from. * Finally, click on Print. Testing my User guide My friend tested my user guide 1 and according to his experience over my user guide he filled in this table.

  2. I am now going to analyse my clients current system in order to get ...

    I hope that no problems escape my eye. I chose these and decided not to observe their workplace and not to take part in a group discussion because I do not think that these are reliable enough. With the interview, I will be able to find most problems without them

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