• 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
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  • Level: GCSE
  • Subject: ICT
  • Word count: 5152

Excel report - ICT.

Extracts from this document...

Introduction

Description of the task to be attempted Heath Mount school is located in the beautiful grounds of watton-at-stone. It is roughly halfway between Hertford and Stevenage. Below you can see a picture of the school, its logo and a map of where it is situated. Heath Mount School is a very well known boarding school for girls and holds 250 students. There are 45 day girls but the rest are either weekly or fully boarders. The fees for daygirls are �3,000 but for boarders it is �5,000. There are many extra activities available and extra teaching as well. Obviously because of this every pupil's bill will be different accordingly. The school offers a balanced Curriculum based around about 15 or so subjects. The sport, music, and art are exceptionally good and many students leave with a talent for either of these subjects. Each department has its own budget, which helps them work out how much money is spent over a twelve-month period. The school employs cleaners; laundry staff, gardeners, and maintenance for help in making the school look good and keeping it tidy. Every school or business must have some form of gathering and keeping information stored either on paper or computer (however a computer is a much better and quicker way of doing this). At the moment the school uses what's known as a ledger system. The ledger looks like a big book of paper with a spreadsheet written down in it by hand. As you can see this way of keeping track of the schools information is very time consuming and human error can occur regularly. The loss of data would occur regularly as pages will get lost, and data will be constantly altered. A calculator would have to be used to work out all the calculations, and every bit of information must be hand written. As you can see the school I am working for is getting rather fed up with this method of keeping specific information so, I have ...read more.

Middle

The bold text makes the important data stand out, and the dotted lines look neat, but also are there for a rough guideline on where to write down the information. Above I have used the schools logo, and down loaded from the web (http://dgl.microsoft.com/?CAG=1) different letters for the beginning of the schools name. This looks smart and proficient. I have also added the schools address, telephone number, and e-mail address. Most professional letters from companies or big businesses would look something like this, and I wanted to try and get this effect with my data capture sheet. Data Validation Data validation checks that the data of the right type. The computer can perform validation automatically whilst the data is being entered. There are four main validation techniques. Range check: This checks that the data is within specified range e.g a person's month of birth should be a number between 1 and 12 Presence Check: This makes sure that important information has actually been entered. Check Digit: This checks that numerical data has been entered accurately. The final digit of a number is determined by a formula that uses all the previous digits. So if the numbers been entered incorrectly, the digit will be wrong. Data type check: This checks that text hasn't been put where numbers are needed, as an example. Above you can see that where I have typed in the formula for cell d7 it has come up with #NAME? This shows me that the data I have used is not correct. Instead of typing =SUM(B7multiplyC7) I should have put =SUM(B7*C7). The spreadsheet recognises that "multiply" is incorrect, but if I used "*" then it will understand that I am asking it to multiply B7 by C7 and will calculate the data and give me a numerical answer. Below you can see that I have corrected my mistake and replaced it with the correct formula and it has given me a correct answer. I have also shown another type of mistake below. ...read more.

Conclusion

I have liked the way I used the random generator, so that I know if my spreadsheet is working and also so it will give me random numbers so that my balance will change. I like the way I have set out my spreadsheet by having four different tabs each containing a different worksheet with dissimular data. See fig below. Money school Money school spends Money school gains or loses graphical representation gains of balance All of the data wont actually fit onto one sheet any way but by using different sheets for specific data it makes it much clearer and more organized. I set a time limit to complete my task, which was 2 weeks and I did it in about a week and a half, which I am pleased about because it didn't take me as long as I thought. I didn't waste any time completing my task but got the data that I needed quickly and efficiently. I have also included three different spreadsheets only the data is slightly altered in two of them making the balances and the graph change. This helps me see that my spreadsheet is working. I am pleased with the Excel programme in which I have used because it is very well known and training people to use it will hopefully not take too much time. It is an updated version so there is plenty of memory for all the data needed and for much more. There are a few disadvantages with my spreadsheet and that is I didn't include my "outings or Internet fees" in my expenditure as well as my Income. With both of these examples, the parents are paying for them, however the money for it is also going out in expenditure as the school pays for the Internet connections to the company etc... I could have also had more worksheets, which would separate my data out further into categories making it even more organized. In general I am pleased with my spreadsheet. If I could go back and change a few minor details I would however they are not completely relevant. ...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

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    do something elongated such as going to a bank to withdraw a simple amount of money. If you forget some money you need, you can simply go to one of the easily accessible ATMs which are located in a wide area.

  2. Different types of technology How I use ICT at home and at school

    via Micro SD cards whereas a direct competitor like the iPhone has fixed memory * Lots of apps such as MSN, Facebook, Skype * Apps can be extremely useful, such as an eReader Summary of disadvantages * Distractive * Expensive * Easy target for theft * Takes a lot of

  1. Use of IT in schools

    of ICT in Education and UK" Found a study done in Holland about whether using ICT in education actually improves students' performance. 16th September 2002 Also found the website www.becta.org.uk which is dedicated to ICT in education. Found some information, but nothing extremely useful.

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

    This avoids collisions with other planes or other objects which are disrupting there flight path. Ground radar stations are located across the u.k and throughout Europe. The different European countries have agreed on a standard format for this data so that it can be exchanged across country boundaries.

  1. ICT Report 2b: ICT in Organisations

    Employees in France would most probably be accustomed to this layout, and so Boots must take this into account. Other countries that Boots Plc has spread to, but also have a varied keyboard layout is Germany, where the QWERTZ layout is widely used.

  2. Database Design Guideline

    Common fields in my database are surname, forename, doctor ID, address, gender and phone number. Field is what you store the information in e.g. doctor ID will go under that particle field making it separated from other information/fields. Doctor's table: This is how my doctor's table will look like when

  1. This report I will be writing, will be on the way I do activities ...

    who has access to a computer and has their own personal e-mail address. Examples of messengers are: yahoo messenger, windows live hotmail, g-mail. In an e-mail you can send notes, letters and most kinds of files - music, image video, word processing and others.

  2. ICT Specification for a spreadsheet for the Hairdressing business.

    The testing that we had previously carried out helped to improve my system and the evaluation has helped to make sure that all the criteria of the specification points have been met. The specification points have helped me to carry out the task as a whole more efficiently and to

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