Evaluation of my ICT Database, Spreadsheet and Newsletter

Health and SafetyI followed the school rules, and didnt fix nearlywhat(prenominal) food/drink into any computer rooms that could be damaging the electrical appliances if any beverages split on it. I didnt bring my bag or coat into the classroom to reduce jeopardize of some nonpareil tripping over, and I do surely that all wires were safely under my desk so that no-one could trip over them. When it was sunny and I was sit facing a computer I made sure that the blinds were closed in(p) so that I didnt get a headache. When I had a double lesson we had a 5minute break between the 2 periods. This was to reduce chances of acquire a headache, poor circulation or even backache.I adjusted my operates height so that my eyes were at the same aim as the screen to reduce eye strain. I watched out for any trailing cables from the mouse or headphones and I employ wrist rests to forbid RSI.SecurityI made sure that I never told anyone my password, or that I didnt write it deal so tha t no one could alter my work in any way, or delete it. I had no internet access so no viruses could be downloaded. I saved my work regularly just in case of a power cut, or if I knocked the wires, or if some other(a) intimacy happened. My work was regularly backed up, e truly night, and saved on an foreign hard-drive. I followed safe, healthy and secure working times at all times. I can load software and save work in folders without help. I can also print, and use the computer network without aid.Database military rankFieldsFirstly, I thrust 13 fields in my entropybase, only when to improve I could add more than Yes/No fields such(prenominal) as free flight meal, room service, etcetera Also, the lengths of fields, in the table view, were not restricted. This leads to memory loss which could be a vital aspect later on. To cultivate improvements I made sure that I used a field restriction from 255 to 75. A obedient point of the fields in my database is that Date/Time (dep arture, arrival) fields used a NN/NN/NN format. (N meaning second) This saves the user from having to write out the date, this could also lead to human error.Data EntryI subscribe to many attributes of data main course, such as Currency, Text, Date/Time, exit, Yes/No. I have used all the data entry parts that I think fit this task.ValidationI used a range check on my Number of People, Reference Number, etc. To make sure that only a certain number can be entered.FormsMy colourise scheme for my database is colourful, but not in like manner bright. I fagt feel the need to improve my colour scheme as its very basic. The font I used is easier to read and is adequately sized. There are advantages in using a form, for example you tangle witht need to scroll down to view all the table, this could rule out RSI, because they isnt a need to scroll down/up.SortsI take my holiday dates in order to make it easier to go on holidays closer to the rate of flow date.SearchesI did depe ndes on holidays with cruises. By using a search, it was quicker and easier to follow the holidays that catered for my specific holiday. The searches would be very useful to a working phoner as it would be much quicker to fin d a holiday to a certain specification. I also did advanced search to find specific words to do with my holiday.ReportsMy report was organised into the type of country, then the destination. The size of the fields allowed all, if not the majority, of info to be displayed and the education is set out quite simply. The report is much easier to read than in a table because you dont have to scroll down or anything. However, some of the fields have being cut of the edge. I could do other reports based on the prices of holidays, etc.Spread stable gear EvaluationLayout and DataThe labels of my contrastive fields are clear and considerably understandable. The data I have included in realistic and I know this because I used a proceed website as a guideline so t hat it was easier for me to do mine. And I also went to a travel agency and they showed me theyre website and some of the features I could use in mine. The stall merging was used when starting how many in a group. I have used grids to separate each bit of the spread winding-sheet, so people dont get confused rough where the information is supposed to be. I could have used extra labels such as the type of holiday each is or whether there are disable facilities.FormulasIn my spread sheet, there is automatic recalculation if data changes, as shown in my What If Investigations. This is helpful if there is a sudden change in hotel be as it automatically recalculates the total terms. The calculations are also accurate and do not need checking. To improve, I could use other formulas such as a count or use a 3d cell reference.Realistic Data and OutcomesAll my prices, including the cost of the hotel extras and the cost of the various travel options, were realistic. I know this becau se I used a number of websites to get ideas for the right price and averaged the cost. To make the data more realistic, I should use the same website to find out all the guide prices. normal Advantages or DisadvantagesUsing a spread sheet saves time when trenchant for data. The prices of my holidays are clear to find and realistic. The graphs I used make the different data for the different holidays come together in one easy to find place. The information that needs to be found can be found quickly with no hassle.Future DevelopmentsThere are other spreadsheets that could be useful to the company. There could be a spread sheet that shows the different costs of different airline companies or train companies to find out the cheapest way to get to your destination.I could also add in other sheets to the spreadsheet I have already, like a sheet displaying the discounts procurable of each holiday or a sheet showing the cost of a holiday to each destination for one adult, two adults, t erce adults etc.Newsletter EvaluationGood PointsI agree with some of the points given, but I disagree with others. I agree that the use of my potpourri of fonts and use of techniques such as centred, underlining, bold which added empathy to my information. I have displayed the prices in an appropriate manner, with techniques such as bold, underlining. I think the theme I used for my newssheet fits well with the Holiday theme because its not dark. My newsletter is more appealing to Adults, because of the cruise.Bad PointsThere are some bad points, or points that I think need improving about my newsletter. I could of used more auto shapes to add more discretion to my newsletter, it looks plain. The pictures I added to my master page are a little too small, although they are set of in a safe way. Also the authorship size I have chosen is too small to read. The color I have used do not over-whelm the reviewer, its very plain and easily read despite the size of the font.Improveme ntsTo improve my newsletter I need to do the following- I could change the colour of my existing tables so that they fit the colour scheme throughout my pages in my newsletter. I could make the font bigger so that the read wouldnt have any trouble in reading the information I have put in my newsletter. I could increase the size of my master-page images so that they are easily viewed, since that is one of the main features of my newsletter. I could use different customized bullet points, since I havent added any bullet points in my newsletter.PowerPoint EvaluationGood PointsI agree with some points made and, again, I disagree with some. I agree that the colour scheme I have used is appropriate to the target audience, its quite sophisticated. I have not used headers and footers this would of being easier to give the powerpoint slides specific titles so the reader could easily identify the holiday they want to look at. My pictures are a adequate size, and the positioning is good. I us ed different fonts and techniques to make my powerpoint more interesting to the reader.Bad PointsOn the other hand, there are some bad points about my powerpoint- I didnt use coloured text, which would of made it more interesting. I havent used headers and footers (explained in good points.)ImprovementsTo improve my powerpoint I could- Put colour on my text, to make the readers more interested. I could put headers and footers so the reader knows straight away what type of holiday this is.