• 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: 1880

Planning a spreadsheet database for a gun shop.

Extracts from this document...

Introduction

Name: Haseeb Ali Choudary Candidate number: 3038 Center number: 11043 GCSE ICT spreadsheet coursework IDENTIFY Identifying the problem: My sister Lisa is the new manager of a small independent Gun shop located in Brighton, which is called BOOMtings it has been running for 10 years now and is a thriving business as any other shop in the market. This shop sells the latest guns at reasonable prices. BOOMtings have an acceptable amount of customers and the shop is earning a reasonable amount of money. Problem: The current system is manual and makes life difficult for my sister so I will be trying to fix it. As my Sister hired me to help out with the accounts, I have found some problems which are: finding the calculations of how many Guns they have, how many they sell over a period of time and the amount of profit or loss that was made weekly or monthly This problem is caused because my sister Lisa is completely unorganised and is always losing important files and scraps of paper, which means she has no idea of what is going on with the company's financial situation. Suggestions: As I am very advanced in software designing and accountancy, I am the best man for the job. I would say the best way to solve this problem is to get a laptop for my sister Lisa, so that we can get Microsoft excel or Microsoft access. ...read more.

Middle

* Paint for designing the logo. I have decided to go for Microsoft Excel due to the fact it stands out from the other, it is much more reliable and faster. The other software does not have the ability to story and calculate data unlike using the spreadsheet. Specification: A list of qualities that I want the final solution to have: * Fast. * Easy to us. * User friendly. * Accurate. * Tell the user if the stock is running out of items. * Tell the user about stock control such as items and prices. Security: The security on this system is that it should have and administrator account only for my sister Lisa to use. It should have another account for each member of the staff and all of these accounts should be password protected, password should have al least six letter and one numerical for security purposes. The security in the shop is tight and only staff members can get access to the room with the computer. Also for other reasons all information should be backed up on a USB every time system is updated. Data Flow Diagram: DESIGN Design: Test number Reason Data to be used in the test Expected results 1 Grammar Should all be corrected No grammar mistakes 2 Layout Should be according to plan Should be according to plan 3 Spelling check Running spell checker No spelling mistakes 4 Formulas All formulas work and make sense To make sure all the formulas work e.g. ...read more.

Conclusion

In general we are happy with the final product and found it easy to use. Thank you, you have been magnificent. Kind regards Ms Lisa Comments on Future Development and User Feedback I have considered the feedback I received from the user and after further research would recommend the following development of the system in the future. I have found that in the Tools, Options facility of Excel, it is possible to tick an option box which stops all 0 values from being shown within the Workbook. If I were to shade the cells where data is to be entered using conditional formatting, the user could see those students who had not sat a particular assessment instead of seeing lots of zeros. If a student scored 0 in an assessment the cell would remain blank but no longer be shaded. I would like to develop the formulas within the workbook further, incorporating more 'If' and 'Iserror' functions so that cells would stay blank unless the formula within them was being used to perform an actual calculation. I have also realised since completing the project, that student details could be entered into other worksheets simply by targeting the cells where there details are already held. This would reduce the number of times the data would have to be entered. In future, it would be good if the students' details could be entered electronically from other records being kept within the school. I will suggest this to the end user. ?? ?? ?? ?? Haseeb Ali Choudary ICT GCSE SPREADSHEET COURSEWORK 2010 ...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 Software 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 Software essays

  1. Design a spreadsheet that can be used by a school tuck shop.

    number of packets bought cost per packet cost of order 5 9.96 =G3*F3 6 9.87 =G4*F4 5 9.35 =G5*F5 5 9.24 =G6*F6 3 9.12 =G7*F7 4 8.24 =G8*F8 4 8.99 =G9*F9 5 7.87 =G10*F10 6 8.99 =G11*F11 5 7.99 =G12*F12 4 5.55 =G13*F13 5 5 =G14*F14 4 7.99 =G15*F15 7

  2. Designing a leaflet to advertise an electronics shop.

    about done the task I set you have unfortunately I am writing to you to let you know that it is not up to the highest standard that you can achieve. Firstly there is far too less colour, a leaflet is supposed to be bright and colourful, who would be interested in a dull leaflet.

  1. My final report - Spreadsheets.

    A problem that occurred while I was producing the spreadsheet very commonly was error messages appearing on the screen. At one point this happened without me saving my work, and the work that I was producing at the time was lost.

  2. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    I then formatted the colour of the cell if the condition were to be met by clicking on the 'Format icon. 4. Advanced/Nested 'IF' Functions =IF(R6=0,"N/A",IF(R6=1,"2nd",IF(R6=2,"3rd",IF(R6=3,"4th",IF(R6=4,"5th",IF(R6=5,"6th",IF(R6=6,"Finished"))))))) Above is a Nested IF Function which was used in the 'Training' section of the'Staff' sheet to determine the present module of each employee depending on the number of modules completed.

  1. What is a computer registry?

    The Group Policy MMC snap-in lets administrators define policy settings that are applied to computers or users. You can implement Group Policy on local computers by using the local Group Policy MMC snap-in, Gpedit.msc. You can implement Group Policy in Active Directory by using the Active Directory Users and Computers MMC snap-in.

  2. AQA GCSE ICT Specification B

    Name, Logo and Address Projected Dispatch Date Customer Title, Initial and Surname Delivery Address Date of Order Order Details Name to be printed on product Projected Dispatch Date = Date of order + two weeks Output 3: List of Customers and Orders Between Two Dates Information on Output Inputs Required

  1. The aim of my project is to make the task of the allocation of ...

    a later date which can be done easily using Excels "save as" feature. Mr. Brown can also print out the spreadsheet to keep a safe copy of the information, or to store it for future reference, but it is usually easier to save it to a floppy disk.

  2. Youth Club Database Solution

    # symbol being a wildcard for the columns, and the same formula appears in the columns L and N to W. There is a different formula that appears in Column M, and is for working out the average attendance of all the Youth Club members throughout the term or year.

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