• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  • Level: GCSE
  • Subject: ICT
  • Word count: 2816

Joe Scott is the entrepreneur of a new company selling sports goods. He has been a successful trader in Newbury for 3 years now. He is now looking for a new system to help him with the Business'. Expenditures.

Extracts from this document...


Spreadsheet coursework Identify Joe Scott is the entrepreneur of a new company selling sports goods. He has been a successful trader in Newbury for 3 years now. He is now looking for a new system to help him with the Business'. Expenditures. Up to now, he has been doing it manually on a form and keeping it in a folder. Joes Business is starting to do increasingly well, and he is looking to save some time. He feels that making a computerised accounting system will decrease the time he spends every month writing out all the expenditures for the month. Really though, he wants to make a computerised cash flow for his business. His main objectives therefore are: * To save time. He wants a much faster way of doing this because he feels it is getting very tedious to write up a list of products and prices each month. * To improve presentation. He thinks it is getting too messy as he is writing is manually. * He feels that if this way of accounting continues, it will become very space consuming after a few years, which is where a computer can help. Therefore, he feels that a computerised system will help him solve these problems What I need in the software I will use: *A table needs to be constructed. Information needs to be stored in cells, organised either by columns or rows. *An easy way to enter lots of similar data. Like a copy & paste function. *A calculations function. This is so that time doesn't need to be spent with a calculator. ...read more.


He will mainly add up all the prices of the stock he buys. My system will therefore work like this when Joe's shop sells something: 1. This is the also simplest, but probably most time consuming job in the process. Basically, Joe collects all the receipts he gets when he buys or pays for something. 2. At the end of the month, he adds up all the totals on those receipts, and enters it into the cash flow. The two methods are nearly identical, seeing as all the data ends up in a Cash flow, this doesn't really matter. Input, Process, Output Input Process Output * Details of items sold and bought entered into their corresponding tables * At the end of the month, those details are taken and entered into the cash-flow forecast using formulas. * More formulas are entered to help calculate totals * Formulas calculate data from several different cells and process that data into an answer. * Answers, as calculated by specific formulae, are displayed on screen * Printers can print out a hard copy of all data displayed on-screen Design Spreadsheet Designs I have made my designs for the spreadsheet after consulting with my end user. It looks the same as the original table he drew up by hand, because we felt that this was a good way of storing the information, and I said that this will work equally as well on a computer, with all the extra benefits I discussed earlier. Formulae Formulae can help me do multiple calculations that would take a very long time if you were to do it with a calculator. ...read more.


of time, seeing as he does not have to spend time with a calculator, working out different individual calculations * The spreadsheet is done monthly, meaning that Joe will only have to enter data once a month, saving him a lot of time. My Spreadsheet is not perfect, and also contains some bad points. Although to this I must add, that these points are not actually serious at all, and does not affect the performance of my spreadsheet. * It is not very presentable. It does not contain colour or any edited buttons. Have I met all the objectives I have set? Objective What I have done: I need to speed up the process of entering data into the cells. I have crated a spreadsheet which will help speeding up the process of entering data into the cells I need to speed up the process of calculating different formulae and data for the spreadsheet. I have entered formulae into several different cells which will do all calculations automatically To make the information more presentable and eye-catching to himself and possibly a bank manager. The information is much more neat now than before. The computer provided a presentable way of showing the data. To make calculations made more accurate. Seeing as formulae are used, all calculations will be correct. Correct to a certain amount of decimal places. As you can see, I have met all the objectives I set earlier. This means that very little can be wrong with my spreadsheet. At the end of this project, my end user did not suggest any changes to me, and therefore I feel that the making of this presentation was a big success. ...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


    A backup copy must be made for each time the system is updated. There should be some password security on the computer so that people using the system cannot change any of the database structure. This can be done by protecting the database so that nothing can be changed except the data that the receptionist will input.

  2. Planning a spreadsheet database for a gun shop.

    and making a V-LOOKUP table this is a good method of calculation two separate sheets for stock control and invoices so they are on 2 different pages and it's easier for Mr Aden to see and understand this information without losing it or making mistakes I also made these documents

  1. What is a computer registry?

    String Value REG_SZ A fixed-length text string. Binary Value REG_RESOURCE_LIST A series of nested arrays that is designed to store a resource list that is used by a hardware device driver or one of the physical devices it controls. This data is detected and written in the \ResourceMap tree by the system and is displayed in Registry Editor in hexadecimal format as a Binary Value.

  2. AQA GCSE ICT Specification B

    Numbers Only - - - No Required If PaymentType= Credit Card 1234123412341234 . Query Design Query1 Query type: Select Tables included Table 1 Purpose of query: The basis for every other form, it contains all information. Field Table Sort Show Criteria Or Or Order ID Table 1 - Yes -

  1. Unit 4 Multimedia -Review for Product 1 KS3 Strategy Presentation

    I had mentioned earlier on, the slides aren't in the right order so it actually confuses the audience about what it what. If the slides were put in the right order and simple vocabulary was used, then everything would be clearly understood.

  2. Documentation of a database for a sports centre.

    buttons etc, and the real data fields or queries that are used. A database form can be used to ease database data entry and retrieval operations. A database developer usually designs a form which can then be used by individual without any specific database skills to perform repetitive tasks.

  1. GCSE IT Evaluation of word processing template documents for the Extreme Sports Club.

    Ideas for Improvements based on your own views * I could have added more colour to my homepage. If I added more colours to the documents it would have made the documents look more eye-catching and attractive. * I could have added more pictures to take up empty space Ideas

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

    Macros There will be 4 simple macros in the spreadsheet which allow the user to instead of inputting manually in the spreadsheet the seating will allow him to simply highlight the relevant cells and click on the button with words: "child", "adult", "concession", or "clear selected".

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