• 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

    play games helps me as much as possible in allowing me to do my work. It also stops people from going on 'dirty' sites, something which is strictly forbidden in school. This keeps our school clean and quiet. Disadvantages (How it does not meet my needs)

  2. GCSE Excel Project ICT

    stage, however I shall outline the errors themselves, which lead me to make adjustments to the construction. FINALFINALFINAL Macro There is a slight error of the transference of formulae. As the formulae are transferred the values are transported too, but if the 'Backup.xls' is open at the same time as

  1. Produce a net cash flow for an Italian restaurant called The Pizza Palace.

    3b) Here is an example of my spreadsheet. I have used the guidelines and have managed to end up with this. It shows that all of the months are 'OK' meaning the company is not in any deep losses. Task 4: I will now complete the Test Plan that I made earlier in Task 3: TEST DESCRIPTION/PREDICTION OUTCOME/RESULTS

  2. Database advantages and disadvantages for a user.

    If they used database error can be controlled by validation rules in each field when created a table to prevent wrong data being entered. Database Disadvantages Would these be a problem for Steve Jones and his staff? Database software can be quite expensive, complex to understand and difficult to learn how to use.

  1. Spreadsheet Project - computer system for a video hire shop.

    number is input unless the transaction is food Do not input membership number but input rental/purchase/ late (no membership no) and : rental food late Validation error No error message Validation error Rental Total Test that the rental total is increased when a rental is made Input a rental transaction

  2. System requirements analysis

    The size is measured diagonally in inches and a typical PC monitor is about 17 inches. Laptop screens are 12 inches. The resolution is measured in pixels or dots and the main sizes are (800x600) medium or a low (640x480)

  1. Ict Unit 2b

    Output devices > A printer outputs data that is seen on the computer screen. Most printers are used through a parallel port, but some newer ones use USB connections. USB is somewhat faster, but there's not much of a difference for printers.

  2. Creating a computer system for a video rental shop

    The weakness of Windows ME is that some software programs will not function properly and some of the new software would not run on it at all. It will suit home user only and does not suit business organisation. 12 months Collect and return warranty(up gradable to 3 years)

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