• 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

  1. Planning a spreadsheet database for a gun shop.

    password protected Burma Road Birmingham Bra 4bb Tel: 06531234321 Dear Mr Butt I am very impressed with the work that you have produced for our company and I would like to thank you for your time, effort, the computer you brought me and producing the spreadsheet.

  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.

    Walcott's comments I have made the required changes. Final design I have to redesign the forms, I have made some adjustments after the comments of the user. Here are the changes from the initial design: Field name Data type description Membership id Auto number Unique primary key Title Text Title if member First name Text Game information Last

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

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

    Overall, If JEM bookshop, used spreadsheets, it would help them to calculate their profit and loss account, budget, gross profit margin, net profit margin etc.

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

  1. Reviewing different multimedia presentations.

    click the section that you want to so to and it is quite self explanatory what to do and how to make your way through the Multimedia Presentation. 5. Improvements to the multimedia website/product to help meet the product's aims.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    I completed the following steps to do this: 1) I high-lighted the area I wanted a border round. 2) I then clicked on the arrow next to the icon which showed a picture of a box cut up into 4 pieces.

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