Creating a Travel Planning ICT System Essay Example for Free

Creating a Travel Planning ICT System Es sound outIn this project I pass on be creating a governance to help plan the be, amount of raft and which concourse are going on the long locomote.Here you pull up stakes be taking the type of Sana, who is helping her French teacher (Mr Campbell) work verboten the constitutes of the week long French set off as he was experiencing some difficulty.On a day to day basis Mr Campbell has to have a letter ab bulge parent even outings for the spark off, permission instances, dietary and medical requirements and remaining specie. He also c whole for to work out the thorough in goings and essence outgoings and determine sure that the school doesnt get at a loss moreover doesnt need to make a profit. He resulting also need to build a record of selective information about which pupils are going and arent going and how we will put this in and expend this to help gain lettersAs Mr Campbell was experiencing some difficulty w orking out the hails employ a calculator and paper and you had suggested that you would cause a strategy that helps him work out the cost very easily and is a very use upr friendly design (maybe a user suck up to help those who find this system hard and need some help) and you should ensure that any(prenominal)body with little knowledge of computers is fitted to salmagundi certain amounts e.g. amount of tribe to see how this affects the overall costs. Sana has also offered to pee-pee a system in which Mr Campbell crapper enter a pupils data, how some(prenominal) they have paid ( desexualise and some other monies) and if he/her has brought in the reply slip, this system moldiness(prenominal) also be equal to(p) search inwardly this data and plank out what you are asking to see. As well as creating a system that does this you must create a system that links to the list of names and apply the education that you have searched for I should be adapted to create a let ter to be sent to parents about reply slips, remaining money etc.My user for this system is Mr Campbell and Mrs Mccloud and could be the deputy head, head teacher etc. As anyone who need to know how many mint will be missing school and how long for, other teachers will need this information to ensure that all important work is transgressn before and after (this information could be presented in queries or reports). Many passel will need to access this record or receive information about the trip so I should be commensurate to send out pieces to teachers e.g. form, lesson etc about which figures will be missed.At the moment the business is run by Mr Campbell and he runs it by collecting information from letters and from pupils then writing it down into a log book simply this way is too long and too hard so I will be creating a system which will signifi whoremastertly decrease the amount of quantify wasted by sifting with handwritten data.Sub hassles involvedIn this delegat e there are 4 different crampfish-problems within the system they are instaln on the adjoining page in the diagram with the problem being at the top and the qualifyingmarine problems being shown below and also how these sub problems are linked shown on the diagram.My world-class sub problem is my costing sheet which will work out all the separate and gibe costs of the trip. For this sub problem I could use Microsoft news and Microsoft excel. There are advantages and disadvantages of all of these problems and there are all listed below these will all help me to decide which would be the trump out mode of working out these costs. I have chosen these two political platforms because in each one I atomic minute 50 create t up to(p)s.Different methods of tackling the problemIn Microsoft excogitate I can* Create a t sufficient* Merge cells* lurch the page layout (portrait and landscape)* Change the circumstance coloring material of the cells* Change the school schoolb ookbook edition deform of the cells* Change the justification of the cells* Make cells bold, italic or underlined* Auto fit the cells* I can grade the data* I can add formulas* apply a t adequate auto format simply using Microsoft word also has its disadvantages* Harder to shift formulas* Harder to use* If some affaire needed to be changed if would be harder for the userI mobilise that Microsoft word isnt a very good course to use because even though you can do a lot of things with making the t fit and changing things within the table I dont sense that this is the right weapons platform to use as I would like a program specifically intentional to do things like costing sheets as I have more experience with those so I am able to make them more user friendly and use more features on it.In Microsoft excel I can* Create a table* Merge cells* Change the page layout (portrait and landscape)* Change the desktop colour of the cells* Change the text colour of the cells* Change the justification of the cells* Make cells bold, italic or underlined* Auto fit the cells* I can phase the data* I can add formulas* rehearse a table auto format* Create graphs with data* Do auto sum* Use conditional formattingI can also do many other things that would be efficacious to the sub problem. The disadvantages of this is* it might seem hard to usethe only problem I have with this program is that it could look hard top use scarcely with a user guide and a colour coded system I think that that is over come easily and because I am able to do many different things with this package as I am more familiar to it and I think that that would benefit the user.Any methods of doing this would be break in than handwriting it because then I would have to work everything out for each little change and keep writing out the results and this can be very cartridge holder consuming so the best option is to use a computer with maybe a program that is able to create costing sheetsFor my seco nd sub problem I am creating a bank bill to advertise this trip to France I am going to use Microsoft word, publisher or paint. I will be listing there advantages and disadvantages to help me to decide which one is more appropriate and suited to this task.Microsoft word is good because* can insert picture* can insert text* can make text boxes* can change colour, background and type and coat and justification of text* can change act upon etc of background* can insert tables to display data* can insert diagramsYou can also do many other things with Microsoft word sop it would be a good program to use but I dont have as frequently freedom with the text etc then what I would have with another(prenominal) program in which I am able to do many more things.Paint is a good program to use because* I have a lot of freedom within this program* Can create my own lines and shapes and copy and paste parts easily* Can insert text boxesMicrosoft paint also has many other good points but I still think I that this program isnt the most ideal because* I dont now how to make it fit the whole page* hawk use word art, would have to copy and paste itThere are also more problems with it and they wouldnt really influence my decision as I think that using paint is already to tedious from the above two problems so it isnt the most desirable solution.Microsoft publisher is good because* I have freedom* can insert picture* can insert text* can make text boxes* can change colour, background and type and surface and justification of text* can change colours etc of background* can insert tables to display data* can insert diagramsI can also do other things with Microsoft publisher but they do not need to be stated as I dont emotional state that that has any tedious or major problems with it so feel that for this task it is the best piece of software system to use.Using a computer and its software to tackle this sub problem rather than using a computer because it would take me a long prison term as well as designing it I would them need to draw and stick anything on then I would need to colour each rough drawing in staying within the lines and making sure the colour is even this isnt a very good thing because it would take vary long time and wouldnt look professional so for this task it is better to use a computer.For my third sub problem I am creating a record to store all the details about pupils and teachers going on this trip I will be using any of these two programs as I can use tables in both Mycroft access and Microsoft word.Microsoft word would be good to use because* I can make a table* I can sort the data* I can give the data titlesThe rest of what I can do with Microsoft word is irrelevant and there are too many problems to list with it because I count do much with this program and there is no use in listing it but I know for definable that I will not need to used this program as I cant even make forms or use queries.Microsoft access would be good to use because* I can create queries* Create forms* Search for and sort data* Create definite world headings for the record* Be able to mail merge this dataThere are also many other good points but I do not need to state them because of what is above and concerning this sub problem there arent any bad points of using this piece of software for this sub problem.Using a computer is much better than using a hand made system because in a hand made system you would have to write each one out and if any changes needed to be made I would have to re-write the whole sheet and finding data and taking parts of that data would also be very hard as I wouldnt be able to do it in a short(p) period of time so using a computer would save time and frustration.For my fourth sub problem I am creating a letter which will need to be mail merged so I can do this quickly and efficiently. I can use two programs for this task Microsoft word stamp pad and Microsoft word. They bother have there advantages and disadvantages and stating them will help me to decide which program is better. notwithstanding I already know as I cannot mail merge in word pad and retyping this letter would take too long so I already know that Microsoft word is the best option as I can mail merge here.Using computer I much better than writing this letter out again and again or writing it out and going gaps for details because it is less time consuming if I do it this way sop using a computer is the much better option.ReusabilityEach of my sub problems can be used again. The first sub problem (costing sheet) is recyclable because it is not just for one year because it can be used for subsequent French trips or even other overnight trips because if anything needs to be changed like a cost for any one thing you can without changing any of the formulas as this costing sheet will be totally user friendly. The second sub problem (poster) will also be reusable because if you just change maybe the title and date s you will have a poster for another overnight trip or a poster for the same trip for a different year. The third sub problem (record) will also be reusable because if you were to delete the surveys you would be able to utilise the system for a new year. The last sub problem (letter) will be reusable because if you were to use the record system to do this you would just need to delete previous records and put the new ones in and use it for next years and the years after trip.TestingFor sub problem 1 (costing sheet) testing is needed. For sub problem 3 (record) testing is needed. For sub problem 4 (letter) testing is needed. surgical procedure criterias proceeding criteria sub problem 1moldiness be able to merge cells essential be able to use formulas must be able to do auto sum mustiness be able to do conditional formatting must(prenominal) be brightmoldiness be colourful mustiness have an interesting but easy to read font mustiness be able to make IF statementsMust use absolute cell referencesMust be able to work out total incomeMust be able top work out total outgoingsMust be able to work out the balanceAll the text will be aligned leftIt will be in times new romanIt will have a font size of 12In the title there will be a picture of the Eiffel towerThe text must be in blueThe title will have a blue background and white text.All titles must start with a capital letter.I will be using this to decide on the venue depending on how the transport costsIt has to tell me if the trip can go ahead using an if statementIt should fit onto one pageI should ensure that there isnt a loss madeI should be able to work out the minimum amount of people and use this in conditional formattingI should be able to limit the amount of people by using data validationI must be able to make a complicated IF statementMust be able to work out total costsMust be able to work out single costs e.g. travel, hotel, food, etcPerformance criteria for sub problem 2Must be bright and colourful Must use interesting fontsMust attract solicitudeMust give dates of tripMust give price of tripMust give edge procedureMust give teachers namePerformance criteria for sub problem 3I must be able to link the tablesMust be able to use these links to insert this data into the linked tableMust be bale to create queriesMust be bale to create reportsMust be bale to create formsI musty be able to give a description of the fieldsI must be able to limit the field sizeI must be able to assign a key fieldI must be able to have a foreign keyI must be able to change the data type to* Text* Number* Auto number* Currency* Yes/no* Date and timeI must be able to create a permanent field nameMust be able to store data about each pupil and teacher attending the tripMust have a surname fieldMust have a forename fieldMust have an address fieldMust have a home phone number fieldMust have first deposit, second and third yes/ no fieldsMust be able to use this data to mail mergePerformance criteria for s ub problem fourMust be able to mail merge in dataMust be able to express which deposit has gone unpaidMust be able to say if we havent had a permission slipMust be able to give money remainingMust be able to give dateMust be able to give total cost of tripMust say when next parents evening for the trip isBelow I am stating the performance criteria for the whole system with headings to show which it is for so there will be no confusionPerformance criteria for the whole systemPerformance criteria for first sub problemMust be able to merge cellsMust be able to use formulasMust be able to do auto sumMust be able to do conditional formattingMust be brightMust be colourfulMust have an interesting but easy to read fontMust be able to make IF statementsMust use absolute cell referencesMust be able to work out total incomeMust be able top work out total outgoingsMust be able to work out the balanceAll the text will be aligned leftIt will be in times new romanIt will have a font size of 12In the title there will be a picture of the Eiffel towerThe text must be in blueThe title will have a blue background and white text.All titles must start with a capital letter.I will be using this to decide on the venue depending on how the transport costsIt has to tell me if the trip can go ahead using an if statementIt should fit onto one pageI should ensure that there isnt a loss madeI should be able to work out the minimum amount of people and use this in conditional formattingI should be able to limit the amount of people by using data validationI must be able to make a complicated IF statementMust be able to work out total costsMust be able to work out single costs e.g. travel, hotel, food, etcPerformance criteria for second sub problemMust be bright and colourfulMust use interesting fontsMust attract managementMust give dates of tripMust give price of tripMust give touch numberMust give teachers namePerformance criteria for the third sub problemI must be able to link the tab lesMust be able to use these links to insert this data into the linked tableMust be bale to create queriesMust be bale to create reportsMust be bale to create formsI musty be able to give a description of the fieldsI must be able to limit the field sizeI must be able to assign a key fieldI must be able to have a foreign keyI must be able to change the data type to* Text* Number* Auto number* Currency* Yes/no* Date and timeI must be able to create a permanent field nameMust be able to store data about each pupil and teacher attending the tripMust have a surname fieldMust have a forename fieldMust have an address fieldMust have a home phone number fieldMust have first deposit, second and third yes/ no fieldsMust be able to use this data to mail mergePerformance criteria for the last problemMust be able to mail merge in dataMust be able to say which deposit has gone unpaidMust be able to say if we havent had a permission slipMust be able to give money remainingMust be able to give date Must be able to give total cost of tripMust say when next parents evening for the trip is