GCSE Coursework

Authors Avatar

Hemang Udani 10B

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 know how much money they have saved up for them to know how much more money they need to save up to be able to buy the new car they want. They can record all their spending (Groceries, Tax’s) which will then will be deducted from their combined salaries. This will allow them to easily keep track of how much their spending and how much money they have left (Profit).

Users

The users of this Excel Spreadsheet are Deepak Udani and Jemeni Udani, these people are the users of this Spreadsheet because they are the ones that earn the money and who deal with the families financial issues.  

Alternative Solution 1

A log book could be used to record all my users’ expenses as they went along the year, they at the end of each week could deduct the amount they spent each week from their salaries. The problem with doing this is that it would not be accurate; there would be many errors like when deducting the amount of money they spent from their salaries etc. This pen and paper system would also be very time consuming because you would have to calculate all the sums yourself.

Alternative solution 2

A complicated financial programme designed for dealing with people’s finances and expenses could be used with this issue.  

This may be a very good programme to deal with this issue but there could be a problem, it may not fit to my users needs since it wasn’t designed specifically for them, it also would mean spending money on buying the programme.

Join now!

Why Microsoft Excel is a sensible way of solving this problem

Microsoft Excel is a sensible way of solving this problem because it is much more accurate, faster then doing a log book (all the calculations are done for you etc) and it is much cheaper then buying a complicated financial programme. Microsoft Excel is easier in many ways, here are some of them. If you decide to create back ups of all the data in a log book, you would have to scan the whole lot and print them out, but even scanning all the data from a log ...

This is a preview of the whole essay