ICT - St Catherine's school budget using a database.
Extracts from this document...
Introduction
G.C.S.E Information Communication Technology Katherine Pool A description of the task to be attempted St Catherine's school is located in summerset in a small town called Longville. It has twenty acres of amazing ground, very well kept. These some paintings by George Mills - 1900 St Catherine's in a boring school with 338 girls from the age of eleven to eighteen. We have 52 day girls and 189 full boarders and 65 weekly boarders. We also have 32 girls with scholarships, 20 with full and 12 on signal subject. The fees are charged termly, �4000 for day girls and �6000 and �5000 for weekly boarders, because of the scholars, pay �1000 for a full scholarship and �4000 for a single subject scholarship. There are also extra actives available such as yoga, riding, jazz dance and street dance, and music lessons. These are all added as extras to the girls bills. The school offers a balance curriculum based around 15 main Academic Department. In these each department they each are responsible for its own budget and determines how this money is spent over twelve mouths. We also have employees (cleaners and laundry staff who look after the domestic arrangements for the girls. The maintenance department look after the running of the school repairs , heating , lighting and every thing electrical, etc. As their account system at the moment is simply using pen and paper, I have been asked to design a new one I have decided to use excel as it is very quick and easy to use. ...read more.
Middle
Microsoft Excel In order for the bursar, to use this system it must be easy to run and very quick. The good thing about excel it that it automatically adds up your sums for you. Microsoft Access This was not use to set up my school, but it is also very good as it can store and huge amount of information from text to currency. Microsoft Word Word can be use in many ways, the great thing is if you do not no how to spell a word than you can take a guess at it, then right click and a multiple chose of word will come up for you to select one from. If you are doing a title then, it can make the it look better and more exciting if it is in colour or in bold or even in a different font. By using word this can very easily be done simply by highlighting the text and selecting the necessary icon on the menu bar. Windows xp I have used this when design our system, as it more up dated than windows millennium or 2000 there for it is the quickest and easy to use. Data Collection Department ........................................................................... Name................................................................................... (Estimating year from 1 September 2003 - 31 August 2004 ) Number of Textbooks.................................................................. Files ........................................................................ Paper...................................................................... Videos/Cassettes......................................................... Board pens............................................................... Budget on item........................................................................ Delivery Time........................................................................ Contact Number...................................................................... Any other Requirements............................................................. Signature � The reason I designed this kind of data collection sheet is because it is very easy to understand and it has all of the information that it needs on it. ...read more.
Conclusion
This is a screen dump of the number of students at the moment. This is a screen dump with an increase of students this shows how much money has been made. User Documentation This screen dump shows how to use excel. When you click on excel this spread sheet will come up. Using the open file tool this will allow you to open the St Catherine's school accounts. The amounts will be kept on a CD in order to put these accounts on the computer, you have to in stole the program to do this you simply follow the instructions. Evaluation We reached our aim and got the system up and running with in the space of three and a half weeks which was our specified time limit. This also includes time for testing the new system. My system has also proved to be easy to use, my spreadsheet is easily and clear to understand. The end user which is the bursar he didn't need much training to understand the system, but there could have been a for modifications such as, there could have been more detail. For example the food instead of just putting food I could have put:- FOOD Breakfast Break Lunch Super Also the fact that break costs less than lunch super and breakfast because the pupils only have two biscuits and a mug of hot chocolate. The same goes for school trips etc. Another thing that I could have done is to change Dep to Dept which is a better way of shortening this word. 1 Katherine Pool ...read more.
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