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

Introduction

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.

Middle

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.

Conclusion

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

  1. Planning a spreadsheet database for a gun shop.

    that flash phones were facing and how I helped them and the manager out. The problem brother john was facing was: * Finding the calculations of how many phones they have, * Calculating how many they sell over a period of time * The amount of profit or loss that

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

    Test the spreadsheet. g. Correct errors. 28th November 2003 Epsom Playhouse High street 56 Epsom KT17 9HW Dear Michael Pittas I have reviewed your design and I am overall pleased with the result of the first draft. There are, however some things in which I wish you to add:

  1. Selecting the best software for a theatre business.

    you buy your computer and you ask for it, if you buy the excel package or if you pay for it on the internet. This is a program that is worth the money because once Bob has it he will not stop using it until he gives up his shop.

  2. Documentation of a database for a sports centre.

    Add New Member On click New form appears in order to create a new member. Membership Types On click Opens the different types of memberships available to members. Delete Member On click Take you to the spreadsheet and allows you to delete a member.

  1. Database design for a games shop.

    Thank you for your help and look forward to hearing from you soon. You're sincerely Mr. Walcott Final designs On the following pages are my final designs after taking into account Mr. Walcott's comments I have made the required changes.

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

    for Improvements based on End User feedback Homepage * It was suggested by the end user that I could decrease the size of the font because it looks too bold and large * It was also suggested by the end user that I could make the picture of the manager

  1. Evaluate the benefits of a particular spreadsheet solution and describe potential refinements to improve ...

    JEM Bookshop could use these methods to be more organized and sort by Alphabet; Price; Name or Surname, to find something with a certain criteria. Disadvantage of using spreadsheet to JEM bookshop: - If you insert the wrong data or figures in the cell, all the calculations or other things, will lead to a wrong result.

  2. What is a computer registry?

    The HKEY_CLASSES_ROOT key provides a view of the registry that merges the information from these two sources. HKEY_CLASSES_ROOT also provides this merged view for programs that are designed for earlier versions of Windows. To change the settings for the interactive user, changes must be made under HKEY_CURRENT_USER\Software\Classes instead of under HKEY_CLASSES_ROOT.

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