• 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. Different types of technology How I use ICT at home and at school

    If you have something important to do, expecting a phone call or something else, you'd have to wait for the phone to turn on thus possibly wasting time or missing an important phone call. The amount of programs available can also slow down the blackberry.

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

    call centre is a place where peoples questions and problems are aswered. Inside a company to help support different departments, for example, an ICT support center. For a local council that needs to provide help on a range of issues, from questions on refuse collections to council tax payment.

  1. GCSE Excel Project ICT

    However there is an immediate problem, as it is covered by the button the user is not able to input the value, however the idea of the scheme is that the user will not input the value but the buttons (attached to macros)

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

    done this you select design view and a table should appear and then you click on post code and where it says input mask near the bottom you type in (LL0\ 0LL). Using Validation rules and text (gender) The way you use this is by first go on Microsoft Access

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

    So, she uses television to keep in touch with real life. There are two types of television: analogue and digital. Analogue television systems are now out-dated and soon to become obsolete. Analogue television, as the name states, use analogue signals to transmit and receive a TV broadcast.

  2. System requirements analysis

    To check that your data is accurate you can do the following: - Re-entering data - Index formula & Combo box - Proof reading - Another person to proof read. When the patient records are imported, it is important to check: - The first and last entries in the text

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