• 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. GCSE Excel Project ICT

    If the formula completes successfully then the formula lets the mathematical function continue and complete: Evaluate (5 marks) Each original objective fully evaluated. Comments on how well the objectives are fulfilled. Objective 1 The aim of this objective was 'The user wants an electronic archive, which will stay separate from

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

    Test for total payments * Use a calculator * Check the formula I predict that the payments for April will increase to 6600 when the wages is increased to 3000 and the rent will be increased to 300 It works the answer was 6600 Test for Net Cash flow *

  1. 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.

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

    Implementation The implementation shows how I have added a separate column which breaks down the monthly total into transaction types. This screen shot also shows a graph of income by transaction type. Yearly Income Worksheet Design Rental Sales Late Fines Food Sales Total April May June Implementation Annual Profit and

  1. System requirements analysis

    LCD's stand for liquid crystal displays and it is made up of two polarizing transparent panels and a liquid crystal surface sandwiched in between. Voltage is applied to certain areas, causing the crystal to turn dark. A light source behind the panel transmits through transparent crystals and is mostly blocked by dark crystals.

  2. Creating a computer system for a video rental shop

    * DVD-ROM drive is included so CD/DVD can be played on the computer. Disadvantages * User may struggle with new software as it does not have high processing power and memory. * The windows ME operating system is for home use only, it has a lot of bugs, and may cause the computer to crash or stop working.

  1. Ict Unit 2b

    Networked computers usually print to a printer through the network card. The most crucial printer measurement is its dots per inch rating. Printers are used in hospitals to print out important information or documents. Like the patient's results and other important papers, so the information in kept safe and can be shown to other people easily e.g.

  2. ICT car insurance quotation System Coursework

    Setting up the VLOOKUP functions on the quotes worksheet. This is the part of my system, which looks up the numbers in column E and produces the relevant information data. I used VLOOKUP functions, shown on top. If I take the formula in cell G8 for example. I typed in VLOOKUP and then in brackets the cell I want

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