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

    However, a lot of ATM machines in unsecure locations may put you at the risk of credit card fraud. So, while using them might be useful in terms of saving time and practicality, you are also put at the risk of being a target of criminals.

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

    use complex applications or programs used usually on a computer and its ability to use the e-mail service. However, it fades in comparison to more luxury smart phones. Its power is nothing to brag about and it runs quite weak compared to something like the iPhone.

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

    The is where the plastic card is inserted and must be inserted the right way round. The amount of cash that the customer required is released here.ATM Used by many people when banks or closed or there are queues inside.ATM's allow people to;Get Cash outFind out balance in their account, Change PIN, Make Deposits e.g.

  2. GCSE Excel Project ICT

    Mail Merge is also available but can be quite had to control and set up. Also with excel formulae can be inserted to control and manipulate the data inserted. Links and macros to other workbooks and sheets increase versatility of this program.

  1. 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.

  2. 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.

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

    While it does have a ramp, the ramp can be tedious to use, especially as to how often Sarah uses it. It takes a lot of strain on her power chair to bring herself unto the platform of the stair lift.

  2. System requirements analysis

    The concatenate function is made use in the diary slots. When you click on any of the diary slots a drop down menu is present, with a list of the patients names. Instead of using this function, a VB code could be used, but I have used a concatenate function.

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