• 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. The use of ict has changed the way in which people work. Explain the ...

    European wide network for the distribution of radar data is called radar data distribution network (radnet). As the radar scanner rotates, data is collected continuously a feed through a computer network to all air traffic control centres. This common exchange format is called all purpose structured euro control radar information exchange (asterix).

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

    This makes it hard to work efficiently. Summary of advantages * Allows you to send and receive texts and calls from all over the world * Comes with a track pad * Send and receive files * Browse the internet * View/take pictures and videos with a 2 MP camera * Allows you to listen to music

  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. ICT Report 2b: ICT in Organisations

    The motion of these two rollers causes two disc-like encoder wheels to rotate, interrupting optical beams to generate electrical signals. The mouse sends these signals to the com puter system by means of connecting wires. The driver software in the system converts the signals into motion of the mouse pointer along X and Y axes on the screen.

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

    time of the day and it will be sent to the preferred destination. * It is much quicker than by post - snail mail and you can ensure that it doesn't get lost because it doesn't have to go through the process of sorting.

  1. GCSE Excel Project ICT

    The archive sheets could be sorted by date limits (such as monthly of weekly folders). However, that could be again thrown off if Alex has to order components and there are delays, which could throw timing off completely, also specific customer details are hard to attain, as it would

  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

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