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

Spreadsheet Project - computer system for a video hire shop.

Extracts from this document...

Introduction

Spreadsheet Project Identification 2 Description of the problem 2 Evidence that the problem exists 2 Identification of the Users 2 Alternative Solutions 2 Justification of Chosen Solution 3 Objectives / User Requirements 4 Analysis 5 Evidence of path followed in solution approach 5 Source of the Information 5 Implications of data types 5 Diagram of data inputs / process / outputs 6 Design 7 Designs for the solution 7 Solution broken down into sub tasks 8 User comments recorded 9 Validation / Verification / Backup / Security 9 Test plan 9 Test data identified 10 Use and Implementation 11 Relevance to design 11 Errors corrected 12 Annotated evidence of implementation 14 Details of implementation process 15 Evidence of testing 16 Annotated copy of testing 17 Evaluation 19 Evaluation against the objectives 19 User comments 19 Suggested improvements / changes in the future 19 Identification Description of the problem A friend of the family has approached me with the following problem. His name is Jack Challis and he is the owner and manager of a small video shop in East London. The name of the shop is Video Plus and it has been open for about eight months. At present, Jack does all his accounts by hand on paper, but it is proving to be quite a problem. Jack needs to work out many calculations, for example, how much he earns each week from rentals, purchases etc. There are many reasons why using a computer would be more efficient than using pen and paper. One reason is speed. Typing is quicker than writing and when a mistake is made, it can be deleted and correcting quickly and easily. Another benefit is security. Accounting work on the computer can be saved and back-up files made so important information will not be lost. Another advantage is that Jack can find out information that could help him run his business, eg: what is the most popular purchase etc. ...read more.

Middle

The financial columns would be automatically totalled for the month using a =sum formulae. The totals for each of these 12 worksheets would be reflected in a final worksheet which would give an annual account of the business. This workbook will be able to produce graphs showing percentages of income (video, DVD, rental, sales, food sales, late fines). Reports will also be generated showing which videos are the most popular, when is peak time for sales, who are good/bad customers. Some of this information can then be used to target specific customers and to make purchasing decisions. The general layout of the monthly income worksheet will be: Date Membership No Video Number Cost Total Formulae and functions that I am going to use include: > Date This column will have a formulae to generate the current day's date: =TODAY() > Cost This column will be formatted for currency to two decimal places. The column finishes with a monthly total. The formulae for this is =SUM(E2:E14). The final figure in the formulae will alter depending on how many transactions have been made. The general layout of the yearly income worksheet will be: Rental Sales Late Fines Food Sales Total April May June Expenditure The expenditure workbook will also be divided into monthly worksheets, starting in the new financial year. This worksheet will cover all expenses such as premises rental, maintenance, purchasing stock, advertising, services (gas, electricity, phone etc). This workbook will be connected to the final worksheet on the income workbook so that a total net income can be reached. This workbook will be able to produce graphs and reports showing expenditure. The general layout of the expenditure worksheet will be: Month A M J J A S O N D J F M Income Video Sales Video Rental Food Total Less Cost of goods sold Videos Food Total Gross Profit Expenditure Wages Premises Power Insurance Advertising Other Total Net Profit I intend to use Arial font and use a minimum of colours. ...read more.

Conclusion

I spelt 'April' as 'Aprl' and the system produced a 'File Not Found' box. Evaluation Evaluation against the objectives The objectives from the Identification section are: > Automatically calculate and produce monthly sales figures for: o Video rentals o Video purchases o Late fines o Food purchases > Automatically calculate and produce yearly sales figures (and a running total) for: o Video rentals o Video purchases o Late fines o food purchases > Produce an annual profit and loss statement I think that the system I have implemented meets each of the objectives identified. The Monthly and Yearly worksheets cover all the objectives covered under the first two main objectives and the Annual Profit and Loss Spreadsheet covers the third objective. User comments After testing the workbooks thoroughly, I showed the final system to Jack Challis. He was pleased with the system and said that it meets all of his requirements. I have attached a copy of the questionnaire that I gave to the shop owner after he had tried the system for one month (Appendix B). Suggested improvements / changes in the future Although my system meets all of the objectives and requirements of the end user, there is still room for improvements and expansion. An area that I would improve would be the user interface. If I had more time to further increase my knowledge of Excel, I would have designed a more user friendly interface in the layout of a form. This form would have buttons to carry out such functions as: add new transaction, view current day's accounts etc. Jack Challis is currently considering installing a photo development service to his business. If this plan goes ahead, it would mean that the system would need to be expanded to include this type of transaction. Appendix A Appendix B Tom Brown Chislehurst and Sidcup Page 1 Grammar School, Centre Number: 14115 ...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. ICT Project - Statement of the Problem

    about the new Black Lady Night Club Volume Of Data There will initially be in the range of 19 staff members: 3 people behind the bar, 5 waiters, 4 members of security, 2 cooks, 1 booker/receptionist 3 cleaners 1 assistant manager and 1 manager.

  2. GCSE Excel Project ICT

    Data input explained with details of validation. The information about the products sold will be written into tables, which will then be inserted into a respective spreadsheet. The table will have the product name, the Features, Size (be it physical or data storage), speed (if needed)

  1. Evaluation of my website creation project

    Therefore overcoming the problem and satisfying the objective. Objective 6 'Include 3 links to major aviation related sites' this was relatively easy to solve and faced no problems. I created a links page in which I listed more than 3 sites that were aviation related and receive in excess of 1000 hits per day.

  2. Computerised accounting

    Inaccurate data may be due to typing errors and mistakes in programming. There can be loss of data or change of data due to fraud which is becoming more and more popular however this can be prevented by the use of strict firewalls and antivirus software which prevents access to

  1. a level ict project

    Paperwork time will be doubled by copying it out and increasing amounts of cash will be spent on photocopying. A further solution is to use generic database software to develop a database containing information containing numerous entities, which will illustrate their characteristics by using selected field names.

  2. System requirements analysis

    I think a 14.1" XGA ( 1024x768) TFT monitor with built in Ethernet capability and 56Kbps built in v.90 modem with I. LINK (IEEE1394) PORT. This has 800 MHz Mobile AMD Duron Processor with 128MB SDRAM and a huge 10 GB hard disk drive to save all the information about the hospital it's patients and it's doctors.

  1. Creating a computer system for a video rental shop

    Also I contacted Abdullah by telephone and e-mail to pick up certain points. Topics for discussion: * The reasons for requiring the new information system * The problems with the current manual system * The methods currently used to record data * The information that needs to be kept in

  2. The Design Brief - The company is a car hire company called Citicar.

    I made any improvements they though needed making and this feedback really helped me to improve my design. The people who tested the design all felt that a user guide was necessary. They didn't want a user guide that was too long because they said they didn't have the time.

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