• 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
  16. 16
  17. 17
  • Level: GCSE
  • Subject: ICT
  • Word count: 2540

GCSE Coursework

Extracts from this document...


GCSE ICT- Spreadsheet Coursework Hemang Udani 11C Contents PAGE 3 - Section 1:- Identify PAGE 4 - Section 1:- Identify/Section 2:- Analyse PAGE 5 - Section 2:- Analyse PAGE 6 - Section 2:- Analyse PAGE 7 - Section 2:- Analyse PAGE 8 - Section 2:- Analyse/Section 3:- Design PAGE 9 - Section 3:- Design PAGE 10 - Section 3:- Design PAGE 11 - Section 3:- Design PAGE 12 - Section 3:- Design PAGE 13 - Section 3:- Design PAGE 14 - Section 4:- Implement PAGE 15 - Section 4:- Implement PAGE 16 - Section 4:- Implement PAGE 17 - Section 4:- Implement PAGE 18 - Section 5:- Evaluation PAGE 19 - PAGE 20 - Section 1: Identify Introduction For my ICT GCSE Coursework I will be creating a spreadsheet that helps my parents calculate their finances to show them how much money their spending, what their spending it on and how much they have left etc. They need this information because they want to buy a new car and they need to know how much money they have saved up in a certain amount of time, an Excel Spreadsheet will give them the information they need. The problem There are many problems some of which include loosing track of your financial status, finding out that you are over spending etc. So by creating this Microsoft Excel spreadsheet, it will help my end users by letting them know exactly how much money they have left and how much they have spent so they ...read more.


The text will be for the Headings, Subheadings etc. The Numbers will be used as Currency, Quantity etc, calcuations done in the spreadsheet will also be displayed in Numbers. The spreadsheet will create graphs for the data to be easy to understand. Graphs will also be made for comparison, many diffenet graphs will be created for comparision to be made eaiser eg Line Graphs, Bar Charts. The data will be backed up in several ways , the user can have a hard copy (Print out) and file it somewhere safe. The data is going to saved onto the computers hard drive but the problem with this is that if the computer is infected with a virus, all the data in the Hard Drive will be wiped out. So just incase this does happen, the data will be saved externally onto CD-ROMs, Flash Disks, Floopy Disks. To demonstrate how good Microsoft Excel is, I will help a mother of two children both aged 13 and 12. She needed help in keeping track of how much money she gave them, so by using Excel this is how it could be done. This only shows one of the functions of a formula but there are far more options than this that Excel provides. Excel allows you to use formulas that will: add, subtract, divide and multiply. Outside of formulas Excel allows you to create things such as drop down bars, graphs, spinners and macros. ...read more.


7) Run a spell check to validate all letter data is spelt correctly. 8) Save spreadsheet as 'PARENTS SAVINGS AFTER ENDS OF MONTHS' And then Close Microsoft excel. Task 3 Objective: To create graphs for spreadsheets 'PARENTS FINANCES' and 'PARENTS SAVINGS AFTER ENDS OF MONTHS' SUBTASKS Explain the procedures and steps you will undertake to complete the task 1) Open up saved spreadsheets PARENTS FINANCES 2005 and PARENTS SAVINGS AFTER ENDS OF MONTHS 2) First highlight all data in PARENTS FINANCES 2005 and then click on chart wizard. 3) Select graph type and preview graph to see if it looks ok. 4) Go through the setup; enter chart title, category X axis category Y axis etc. Place chart as a new sheet. 5) Save the graph. 6) Do all the same for PARENTS SAVINGS AFTER ENDS OF MONTHS. 7) Go through the setup and place the chart as a new sheet. 8) Save the graph. Test No. Purpose of test Test data Excepted result Actual result 1 To check that all the data is in the right place and that all spellings are correct Written data. All data should be in the right place. Will find a couple of spelling mistakes. 2 To test all formulas in both spreadsheets first by making sure that all formulas are in their correct places and secondly by checking all calculations done by the formula. formulas Computers do not make mistakes hence all calculations will be guaranteed to be correct if only the formulas are correct and are in the right place. 3 4 5 Section 4: Implementation ?? ?? ?? ?? Hemang Udani 10B 1 ...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. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    This is costing the company a lot of money to pay for all these lost games. Sometimes when a staff member has messy hand writing then it is hard for anyone else use information that he/she has written down.

  2. Ict Powerpoint Coursework

    This is actually the fastest computer in the world that anyone has the license to buy. S.A. Foods needs a reliable computer and this is it and there's no reason not to as the specifications of the desktop pc could ever let anyone down. The computer costs �3500 but Mr.

  1. Database coursework

    * Can be done by everyone * No ICT skills needed * Cheap * Takes long time * Data can't be copied * Is not accurate * Needs storage place? * Very difficult to work with * Hard to update Web- Page * Easy to access * More graphics *

  2. Producing documents for a company. Spreadsheet, Invoice and Website.

    Physical The company will use electronic locks. The second thing the company will use is Id-cards as part of the electronic locks. These id-cards will be used to access offices or the company's documents. The company will also use some kind of Monitoring as part of the data securing.

  1. Database Coursework

    I plan on improving this system by making one that is very easy to use for the receptionist as she is the one who gets the information in the first place. It will also be quick, and won't occupy too much time when writing down all the details of the customers.

  2. IT coursework.

    customer and it may involve the company having to repay the price of his shoes that P.Y.S have done incorrectly. Background to the company Company name and location The company name is Pimp Your Shoe(c) and the address is 748 High Road Tottenham London N17 0AP Nature of business Pimp

  1. GCSE IT Coursework

    Records of paper round delivery will be more convenient to use, and at one glance all the information can be found, and if a paper is not delivered, it will be easy to see and rectify. Section B: Analysis (Refer to questionnaire in Appendix 1)

  2. Ict coursework full

    and a computer to run it on. * The system must have a user-friendly interface, and a company logo atop each page. * The system must be able to invoice the user's bank account, and print off a receipt as proof of purchase.

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