We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

ICT – St Catherine’s School Budget Using a Database Essay Sample

essay
The whole doc is available only for registered users OPEN DOC
  • Pages:
  • Word count: 1313
  • Category: School

Get Full Essay

Get access to this section to get all help you need with your essay and educational issues.

Get Access

ICT – St Catherine’s School Budget Using a Database Essay Sample

There are also extra actives available such as yoga, riding, jazz dance and street dance, and music lessons. These are all added as extras to the girls bills.

The school offers a balance curriculum based around 15 main Academic Department. In these each department they each are responsible for its own budget and determines how this money is spent over twelve mouths.

We also have employees (cleaners and laundry staff who look after the domestic arrangements for the girls. The maintenance department look after the running of the school repairs , heating , lighting and every thing electrical, etc.

As their account system at the moment is simply using pen and paper, I have been asked to design a new one I have decided to use excel as it is very quick and easy to use.

This system will allow it to solve the following problems.

Order goods service for the school

Keep accounts of the school Finances (fees and salaries etc)

Order books and teaching materials

Department Budgets

Lettings etc.

Analysis

At the moment the system is not very good as it is very good as it is still on paper. This is not great because every time the data needs to be changed then all the calculation need to be changed as well then everything would have to be tippex out and gradually it would get very messy. Also it would take ages to find the data, and to file it and makes copes of everything. The data will easily be lost and there is no back up.

So I came up with the idea of using excel, this would make everything a lot easier, the files would be quicker to access and the data would atomically change when another piece of data is altered. Also the data can easily be copied, if you want to make a piece of data stand out then you can simply highlight it than go up to the tool bar and select the colour of your choice. There a sorts of advantages of using excel rather then paper, for example :

Quick and easy access

Back up

Automatic up date

The calculation are done for you

Most of the teaches that work at St Catherine’s are quite computer wise. Also excel is very quick and easy to work, so this is why we are going to use it for our accounts. As it is easy to use then it will not take much training for the teacher to learn how to use it. We hope the system will be up and running in three and a half weeks.

Specification

This way will be far better then using the paper, as excel changes my data as I go.

If the budgets are to high then I can sac a few staff but there are also down sides to this from example parents will get cross because they’re paying so much and the lesson have to many pupils in. An other way to gain money would be to increase the amount of students then that would also unset parents as they are paying so much and not getting what they are paying for.

We decided to use to use a computerised system using Microsoft excel. We chose excel because it is very quick and easy to use. It can store a huge amount of data and can be very quick to access. If one piece of data is change for some reason, then by using excel it will automatically add up the sums and do the calculations for you. Also if you use colour than it can be very useful for making things stand out and make it clear.

This is my excel spreadsheet using colour to make things stand out.

This is the formula for adding the fees together. If I decide to change any number above the highlighted cell the total will automatically change.

Also using excel you can highlight the data of your chose and make it into a chart. Which shows the data at a glance

Design of the ICT system

yes

No

No

Yes

The top diagram is called a top-down diagram this looks at the whole system by braking down the main tasks into smaller tasks. This diagram shows what has to happen but not how things will happen.

The second diagram is called a system flow chart it shows how the data moves.

Hardware resources required

To put the accounting system into place the school will require, two pc’s and printer and a server, a route and a hub.

The reason I would suggest this printer is because it is very quick and efficient. It also increase the productivity of your workgroup with the high-performance HP LaserJet 4300 series printers. These printers offer faster, more powerful printing and a higher duty cycle. Use any printer in the series to print even your largest volume jobs quickly with

Print speed of 45ppm. Customize the printer to fit your ever-change business needs by adding networking and a variety of paper-handling and finishing accessories.

An Hp robust and built to last, HP Pavilion PCs offer a price and performance range to suit every school budget. Backed by HP brand quality and reliability,

HP Pavilion PCs complement HP’s school of imaging products, offering customers a complete home computing solution.

All HP Pavilion PCs are Internet – ready and come with special ISP

(Internet Service Provider) offers.

Industry leading power-efficient performance for front-end applications The ProLiant BL e-Class power-efficient server blades, called ProLiant BL10e, integrate a server-class chipset, power-efficient processor, and other power-saving components in an ultra-dense design that reduces power and cooling costs and saves space. With the ProLiant BL e-Class, customers can install up 280 ProLiant BL10e server blades in a standard 42U rack for better utilization of valuable data centre.

I suggest they have a router is because it gives multiple access to the Internet. The sever is than connected hub and all the other computers are connected to that.

Software Resources Required

Software

Microsoft outlook

Microsoft PowerPoint

Microsoft Excel

Microsoft Access

Microsoft word

Windows XP

Microsoft Outlook

This program allows the bursar to write memos, diary’s calendars and it is even possible to write reports on it. This would help the bursar a lot as he can use them a lot, so by having the finance sheet on the computer it allows us to have all these programs.

Microsoft Power Point

It is presentation package, which may or may not be necessary.

Microsoft Excel

In order for the bursar, to use this system it must be easy to run and very quick. The good thing about excel it that it automatically adds up your sums for you.

Microsoft Access

This was not use to set up my school, but it is also very good as it can store and huge amount of information from text to currency.

Microsoft Word

Word can be use in many ways, the great thing is if you do not no how to spell a word than you can take a guess at it, then right click and a multiple chose of word will come up for you to select one from. If you are doing a title then, it can make the it look better and more exciting if it is in colour or in bold or even in a different font. By using word this can very easily be done simply by highlighting the text and selecting the necessary icon on the menu bar.

We can write a custom essay

According to Your Specific Requirements

Order an essay

You May Also Find These Documents Helpful

The theory of “teaching to the test”

Standardized testing is one of the controversial subjects in any school, college, or household. They were created to determine a student’s intelligence, critical thinking, and problem solving skills. Do these standardized test scores truly asses and inform of us of the performance of a student? One argument of standardized tests is that they are fair and measure the ability of students, and they also make...

Racism - social issues

Racism is something we have all witnessed and perhaps experienced. In “The Kind of Light That Shines on Texas,” Reginald McKnight creates a storyline where the main character, Clint, is living in a predominately white culture and experiences discrimination among many of his white peers. They question him on his characteristics, such as his hair and why/how he combs it. As a result, Clint feels...

Honors classes in high school

High school is one of the most important parts of an average teen’s academic and social life in the United States. It is where many people find themselves, including discovering what they want, what they're good at, and sometimes even who they are and who they think they’re destined to be. High school can be considered a great experience, however, our high school years are...

List of School Policies

This assignment deals with displays in the school. It will first describe the school’s policy for displays 1.1 Describe the school policy for displays In my work placement the guidelines and procedures for putting together displays were given verbally since there isn\'t any written policy about the school displays. In verbal discussion it was explained that displays in school are the first impressions to parents, visitors, children...

Experience Changed My Life Forever

There are number of people who has prominently exchanged my life. I thank to my sister who rescued me from being an only child to siblinghood. My 4th grade teacher also had a huge impact on me because he motivated me to have a great passion for studying and working hard. But I must say, my mother has had the most significant influence on me...

Get Access To The Full Essay
icon
300+
Materials Daily
icon
100,000+ Subjects
2000+ Topics
icon
Free Plagiarism
Checker
icon
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.

Your Answer Is Very Helpful For Us
Thank You A Lot!

logo

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?