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

    This can also work with fake ATM machines to steal a lot of money from people. ATM machines are located in a lot of different places so it'd be hard to tell if an ATM machine is fake or real. People can easily be taken advantage of in this way.

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

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

    EFT- Is where money is transferred electronically. Credit card fraud- When a card is reported stolen or lost the details of this card can be broadcast electronically to cash machines and point of sale terminals in shops, so the card can no longer be used.Smart cards are made so that the information is virtually impossible to copy.Cheque

  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. System requirements analysis

    The receptionist has 2 macros on the appointments page that print the appointment and to post an appointment. Output devices The information will need to be viewed by the receptionist, the doctor and the patients. The receptionist will need to see the data that she/he has inputted; she will see the data via the monitor.

  1. ICT Report 2b: ICT in Organisations

    Input Devices An input device: devices that are used for entering data into a machine, typically a computer. Keyboard Earlier computer keyboards had been based either on teletype machines or keypunches. There were many electromechanical steps in transmitting data between the keyboard and the computer that slowed things down.

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

    I am able to do this due to the services provided by a mobile phone, it lets you make calls and send SMSs. My friends would call me to ask if I am able to come to certain arrangements, just as I would call or use SMS to see whether or not they are allowed to come to some events.

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