• 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. GCSE Excel Project ICT

    D4 Pass Drop Down Boxes Expected Result Predicted Result Actual Result None Present Medusa Present XP Home Edition SP3 Present Vista Ultimate Present Vista Premium Present Vista Basic Present Mackintosh Present IF Formula Expected Result Predicted Result Actual Result IF: None Produce: None Present IF: Medusa WarlordTF Present IF:XP Home

  2. Tennis Tournament UNIT 1 GCSE ICT coursework

    Microsoft Word is good at handling texts. A desk top publishing piece of software for example Microsoft Publisher is good at making any form of letters, posters or flyers. Access is a data base package which is very good at managing large amounts of similar data for example, children in a school, or how much stock being kept in storage.

  1. Analysis Spreadsheet Coursework

    Interview Do you find the current system easy to use? Why? No because it takes too long to find data that is in the filing cabinets. What will you need in the new system I am creating for you? I will need the spreadsheet to calculate the predicted profit/loss and easy to access quickly and efficiently.

  2. ICT car insurance quotation System Coursework

    1 First line of user address Address 2 Second line of address continued Postcode Area code/postal code Sex Option of Male/Female (option boxes) Car make Name of car Car model Model/reference of car to make Age Select from option boxes i.e.: 17to25 etc...

  1. GSCE ICT Microsoft Excel Coursework

    club fight day before Southend he was challenged, and beat by the last person in the table, the fighter who had been consistently at the top would be knocked off and would not represent the club at south-end. If a points system was to be put in place then a

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

    secondary database by the manager at the end of every week, he will also delete waste data and non wanted data .the manager will move and back up all of the data he wants to keep to the Final database once a month .The person in charge to make sure

  1. System requirements analysis

    The purpose of this function is to fill in any taken appointments on the appointments page with the patients' names. The formula for this function is, (as an example) =CONCATENATE (C2, D2). This is used to join the two names and is on the appointments page I the form of a drop-down menu.

  2. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    When someone returns a game they bring back the game to the counter. We then ask for their name and look through all of the cards till we find theirs. Seeing as there are approximately seventy cards in at all time, it takes a long time to find it.

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