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

Design and create a computerized system that will assist Jack for his business as he currently uses a paper based system for his calculations.

Extracts from this document...

Introduction

ANALYSIS 3 Introduction 3 Current System 3 Identifying the system 3 Weaknesses 3 What a computerized system will do - (Strengths) 3 Objectives of new system 3 Data Flow Diagram 4 Performance Indicators 5 Hardware and Software 5 User's Skill Level 5 DESIGN 6 Choice of software 6 Worksheet Design System overview 6 Brief Design 7 Sheet 1 - Main Menu 7 Sheet 2 - Price List 7 Sheet 3 - Order form 8 Sheet 4 - Cash Flow 9 Detailed Design 10 Main Menu 10 PriceList 11 Orderform 12 Cashflow 13 Data entry and Validation 14 Macros 15 Security 15 ANALYSIS Introduction The aim of this assignment is to design and create a computerized system that will assist Jack for his business as he currently uses a paper based system for his calculations. My initiative is to design a system so Jack can monitor his profit and cumulative profit every month to see whether he has enough income every month to pay for his over heads and continue his business. Current System Identifying the system Jack currently works out his calculations on a paper based system. ...read more.

Middle

User's Skill Level The user will be Jack. He has rudimentary knowledge of Microsoft Excel, but the system will be user friendly and will be very easy to use. It will be impossible for him to enter incorrect data as I will be using data validation. He or any other user will not be allowed to accidentally delete/edit headings, formulas, images etc. DESIGN Choice of software The system will be implemented using Microsoft Excel 2000. This software is idyllic as it includes many basic as well as advanced features which can be used in customizing the program. I have listed some below. * Can create a blank template * The capability to link price details entered in one workbook with another workbook through a lookup table. * The ability to format text, alter page margins/layout, add logo's etc. * Formatting, to help make the user clear, where to enter data. * Can use charting facilities * Macros to automate various functions within the workbook. * Auditing tools to help ensure that there are no errors in the workbook. * Ability to protect worksheets and workbooks so that the user cannot accidentally destroy formulas or headings; * Customized menus and toolbars. ...read more.

Conclusion

Each cell for vegetables for each month has been validated. A minimum value has to be 0.01 or more and the maximum value has been set to 99.9. Cash flow sheet In the cash flow sheet the user can enter data into most cells with the exception of cells with formulas, they cannot be edited. This also makes a 100% accurate cashflow. Macros The following macros will be used: Main Menu - clicking this button will take you to the Mainmenu worksheet Price List - clicking this button will take you to the Pricelist worksheet Cashflow - clicking this button will take you to the Cashflow worksheet Orderform -clicking this button will take you to the orderform worksheet Exit - Saves and closes all open workbooks Sales Figures - Clicking this will take you to the Sales Figures graph on the charts/graphs sheet Total sales - Clicking this will take you to the TotalSales graph on the charts/graphs sheet Security All the worksheets will be protected so that data can be only entered into unlocked cells. However I will not attach a password to the workbook or worksheets incase Jack forgets it. Therefore the workbook can be unprotected using Tools > unprotect. ?? ?? ?? ?? Karrar shah - 1 - 5/9/2007 ...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. Difference between computerized and manual systems.

    It would more costly than a logo created by hand as money has to be paid for buying the computer system and the software. Writing reports It is much easier to add screenshots of every step of the user guide so that the user can understand it easily and properly.

  2. System requirements analysis

    * In particular, explain any limitations presented by the software that you used to build your system. 6.3 Improvements to your system, and what you have learnt (A02.29, A02.30, A02.32, A03.15, A03.13, A03.14) * List and explain the main changes you have made to your system during its development.

  1. ICT car insurance quotation System Coursework

    The IF sections of the formula , makes the cell blank when the Clearscreen macro is pressed. So consequently #N/A will not appear. =IF(D8="","",H10*H11*H12*H13*H15) The formula below multiplies the figure value worked out in cell H21 by the no claims discount t in cell F30.

  2. Database design.

    After the original database creation, a new data category can be added without requiring that all existing applications be modified. Employee Employee Address Telephone Number Name Number 100001 Freely IP 23, Everglade Terrace 725181 100002 Grew TG 24, Everglade Terrace 725981 100003 Strap AJ 8, Bum Town 727389 Each of

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

    you can use the Pencil to draw difficult shapes. * If you click on the Fill with Colour tool then you can paint your logo by selecting a colour of your choice. * If you click onto the Text tool then you can insert text into your logo. Saving * First, you click on File.

  2. Database Design Guideline

    It only allows cretin data to be entered. This helps make my work easier because if I type something else by mistake a sign will come up telling me that I can't type anything else apart from what I wrote on my validation rules for that field. '' Techniques used to ensure that the data is input into

  1. Developing a Spreadsheet to assist Sparks five-a-side league.

    Sparkhill Forum group write up all the results and update the tables and then post them down to each captains home who can then check up the latest scores. This is done every two game weeks two limit the amount of work that the organisational team would have to do.

  2. Computer Studies Past paper definitions

    buffer temporary storage area/memory to compensate for speed difference of device with CPU for data being transferred between components of a computer system allows other functions to take place while waiting e.g. printer, keyboard, disk drive [2] (b) gateway link between systems that uses telecommunications/telephones and converts data passing

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