• 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
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  • Level: GCSE
  • Subject: ICT
  • Word count: 2744

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.

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. Marked by a teacher

    Evaluation of my ICT Database, Spreadsheet and Newsletter

    3 star(s)

    I don?t feel the need to improve my colour scheme as it?s very basic. The font I used is easier to read and is adequately sized. There are advantages in using a form, for example ? you don?t need to scroll down to view all the table, this could prevent RSI, because they isn?t a need to scroll down/up.

  2. Impact of the ICT on the way you do things at home and at ...

    WAP plays a big part in my life as I don't need a computer to send emails all I need is my mobile phone. Pc technology- Microsoft word Microsoft word is a program which enables you to type different documents with the help of templates and is very fast.

  1. GCSE Excel Project ICT

    Now, click enter on the cell and check the value within: This is not the value we wanted, this is because the active formula within the cell was: =VLOOKUP($D$4,Shells,1). The logical assumption would be an error in the properties of the formula, which would be the correct assumption the specific

  2. The use of ict has changed the way in which people work. Explain the ...

    The worker or specialist in the call centre can use their monitors to help track the customers and help solve the problem from start to finish. These are just some of the things what a person at a call centre needs, Telephone/headset, computer, pen and paper to write there details down inorder to fix there problem.

  1. The Advantages of Using ICT Over Manual Meethods. Using Paint and Access.

    Printing For printing you have to go on again the top left hand corner and click on file then go to print then you choose how many copies do you want then you print. Open Access To open Microsoft access first you click on start then you click on all

  2. a level ict project

    Address Line 1, to get the full benefits of this function, the exact address must be entered, partial entries won't give the proper information 4. Telephone number, once again the full 11 digits must be entered correctly, since it is a relatively large entry, errors are more likely Note: upon

  1. System requirements analysis

    they leave it as it is and a technician fixes the problem. The software that I have created reduces the errors made as all the necessary data and the receptionist will only need to insert the patients' details in the menu page and click on the macro that prints out the appointment.

  2. The impact of ICT on a person with special/particular needs

    However, the simple pushing of a joy stick or a switch to move up and down works perfectly for Sarah. Sarah can use it without much ease, strength or dexterity in her actions. The high weight limit of 200kg is also extremely efficient for Sarah.

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