• 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

    So while it may be a bit too extreme and limiting, it helps a lot in keeping the computers safe. Internet censoring stops people from being distracted from games when they should honestly be working. I'm a person who is easily distracted by any little thing so the inability to

  2. Creating a computer system for a video rental shop

    Also it does not have a palm rest. * 128MB SDRAM this may not be enough memory for some applications the leisure centre may use. Software: Office XP which includes word excel, access and PowerPoint. Member requirements Purpose of process The purpose of the process is to record all information

  1. GCSE Excel Project ICT

    comparing actual results with expected results Macro Name Expected Result Predicted Result Actual Result Aixam Go to sheet1 select insert value '1' in D4 Pass AlienWARE Go to sheet1 select insert value '3' in D4 Pass Back Go to sheet 1 Pass Button123_Click Go to sheet 7 Pass Corsair1 Go

  2. IT system for local video store.

    Add New Film Details Form When a new film is brought into the store its details must be put into the system, on this form. Edit/Open All Film Details Form and Find Specific Film Details Form This is so any film details can be edited or deleted as and when necessary.

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

    Creating Queries I am going to open Microsoft access then I will open a blank database after that I will click on create. Then I am going to query design and finally I will start creating my query. The queries were created successfully.

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

    Diagram of data inputs / process / outputs Design Designs for the solution I intend to have two workbooks, one for income and one for expenditure. The expenditure workbook will generate an annual profit and loss statement. Income The income workbook will be divided into monthly worksheets, starting in the new financial year.

  1. Design and create a computerized system that will assist Jack for his business as ...

    This will be completed via macros, this is for easier navigation. Brief Design Sheet 1 - Main Menu This sheet will act as the front end and will be selected automatically using Autoexec macro when the workbook is loaded. It will have 4 options and an image as follows: There

  2. Design a relation database for a company that is currently using a manual or ...

    the designs remains unaltered throughout the data collection * It must be ensured that a large number will reply to a selected sample * It may be hard for users to recall information if it is after the event * It could be that the user may feel uncomfortable giving

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