• 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)

    You can find any current events or news that happen in the borough via the site. You can keep up to date with anything that happens. This beats the need for newspapers and makes sure people don't miss any community events.

  2. GCSE Excel Project ICT

    it saves (in a separate file), prints the order (to be given to Alex), resets the forms, saves and closes. The file is going to be reused repeatedly for multiple customers. At least 3 Quantitative objectives THESE MUST BE CHECKED BY YOUR TEACHER.

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

    All cheques are sent to a clearing house in London. The cheques are sorted into bank sorting code numbers. The details of the transactions are sent on magnetic disks to the Bank of England. The bank then transfers the amount on the disk from the customers bank to the companies

  2. Computerised accounting

    unauthorised hackers however total security is almost impossible and some failures must be expected. The right level of expenditure on security measures will minimize the sum of the cost of the expected loss.

  1. Design an advertisement or a web site for the cinema. Your advertisement or web ...

    * At current, the site is very simple, but another benefit, as it is web based and designed to be easily updated, I will be able to update the film reviews very quickly and easily. This is a benefit for the user as they are getting the latest reviews, and prices as soon as they come out.

  2. How is ICT used in schools and what are the effects?

    or magnets because they could destroy the disk. 8aGHwW Visit coursework ce in ce fo ce for ce more project ce Do ce not ce redistribute 8aGHwW What rules and regulations need to be put into place to use ICT?

  1. How is ICT used in schools and what are the effects?

    This prevents them from being shown to students. The Internet can be useful for students work and revision, e.g. finding past exam papers. Although using copyright material is illegal, security is not always good on the Internet because people can hack into the Internet and find anything. Using computers for a long period of time can have health risk: radiation, backache, wrist pain and eyesight.

  2. Use of IT in schools

    approach that must be considered in order to create a coherent and reason account of what I have found. These can be sorted into the following categories: * Why is ICT used in education? * What is the current situation?

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