• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 2417

Spreadsheet Project Identify - A couple of months ago my friends and me formed a band called "MISK". As we are new to the field of accountancy, we are finding it hard to keep track of our spendings and savings.

Extracts from this document...

Introduction

Spreadsheet Project Identify A couple of months ago my friends and me formed a band called "MISK". As we are new to the field of accountancy, we are finding it hard to keep track of our spendings and savings. We also find it hard and time consuming to evenly share out the money between different funds (we have different funds for different things e.g. Drums, Amps etc and they all need different amounts of money) and ideally we need to share out the money proportionally between each fund. So we have all decided that we need something to help us easily manage our finances. I am therefore going to design and make a spreadsheet that will help us keep track and organize any of the little money that we are able to save, and how we should spend it. As our needs and funds will be continuously changing, a spreadsheet is the best solution as it is able to change and react when information is inserted and is able to perform complex equations automatically. A lot of data is to be stored, so a database could be used, but a spreadsheet package is better because complicated calculations will be performed on some of the input data and this can be done on a spreadsheet but not on a database. ...read more.

Middle

. To make it easier to keep track of our spendings and savings on the next page we have included an "Amount of money Raised/Spent" column as shown below. To use the Rating Bar, First you type in the Artist and Name of the song and then press the up and down buttons to change the rating out of 10. This can be changed as often as you want but you have to save for the Spreadsheet to remember. Processing Making increasing and decreasing buttons Go into the "Forms Tool Bar" and select the "Spinner" options. Then select the area that you want the Spinner to be. Now the Spinner should have appeared in the area that you selected. Right click on the Spinner and press the option, now this Box should appear on the screen. This kind of button is also used on the Rating Column on the second sheet using the same method, but changing the incremental change to 1 and the min to 0 and the max to 10, so it only shows a mark out of 10. The Amount Raised Column To make sure the system works I will get a member of the band to test that every aspect of the spreadsheet works. I will then personally check myself to see if there is anything that I missed. ...read more.

Conclusion

2. Be easy and clear to use - Completed - Band could all use it and explanatory as it has comments to explain how to use. 3. Work out how much money we have and need - Completed - Calculator page evidence. 4. Automatically work out how much each fund has and show how much more we need until the target amount is reached - Completed - Amount Raised/Amount Still Needed and status columns evidence. 5. Personalized - Completed - Pictures evidence 6. Small enough to be e-mailed yet hold all the information we need - Completed - Only 50.5kb (Small enough to fit on a floppy disk or be e-mailed) 7. Proportionally divide the money that we have between different funds depending on how much is needed - Completed - Amount Raised column evidence 8. Imput in Pounds only, as loose change will be used for Travel and Phone Calls - Completed - All entries to nearest Pound, no pence. I also think that there are ways in which I could improve my spreadsheet, I would like to make my spreadsheet automatically record the date and the amount of money credited/withdrawn. Another thing that I want to include are HyperLinks to Tabs for the individual (tabs are another word for music) so on the rating column you can click on the song name and the tab would open. I would also like to personalize it further by adding sounds and links to other files that may be useful. This could be included in a new version. ...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. Design a spreadsheet that can be used by a school tuck shop.

    Creating the totals page spreadsheet Creating the popularity spreadsheet In my analysis I explained that I would test my spreadsheet to check that is was working and that I could use it to predict what would happen if: * If VAT rose to 20% on one week * If Electricity

  2. ICT PROJECT PRESENTATION

    Last check up= 01/02/2006 Ascending Linked query to show all patients visited after 22/01/2006 General checkups from January Medical Information Surname Order date >= 22/01/2006 Ascending Report Design Description Report name Table/query Type of report All patients data from search for patients table Patients Patients table Tabular autoreport All patients

  1. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    Advanced Macros (Auto_Open, Auto_Close, print) Auto_Open Above shows the result of the Auto_Open macro. It means that a dialogue box, displaying a welcome message, will always appear when the user opens the spreadsheet. I created this macro in visual basic, a section of which is shown below.

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

    All other aspects are protected. In the event of a change in billing or cost to put on a show the user must simply click on Tools | Protection | Unprotect Sheet. After this has been done it will allow the user to edit it.

  1. computerised spreadsheet for pupil attendance data

    I will need to find out the dates of the lessons. I will finally need to find out the grade boundaries for the results, for e.g. in order to get an A the total mark will need to be more than 104 but less than 120.

  2. database project

    The consolation of my decision that Microsoft Access is the best application that suite the company need because this system will reduce the need of carried out some task manually such as producing invoices, tracking customer's orders, and all financial information System equipment * Needs to run on existing PC.

  1. Database Hajj&Umrah travel agency

    Customer: Yes, my family and I were outraged. THE END USERS The manager (Mr. Osman Yusuf) will be the main user for the system but the staff will obviously have to sell the packages. The worksheets will then be stored in a filing cabinet, but this time they will be every month or week instead of one every day.

  2. A new IT system in a Dubai Marauders Rugby Football Club

    I will first have to scan the logo that the club already has using a scanner. I will then enhance the picture if need be. This will be the logo and should be saved as either a graphic interchange format (gif)

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