• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Evaluation of the database

Extracts from this document...

Introduction

Twelve weeks ago I met with the Principal and began to draw up a design specification for a spreadsheet which would be able to meet all his needs and the needs of all the administrative staff. He made it clear that the spreadsheet had to be very easy to use as many of the teachers already in the school were not confident in using a computer. The objectives I had to meet are listed and evaluated below: * Student names must be stored on the database with a unique admission number for each pupil. Student details must also be stored on the system along with report notes. The system must also allow for comments to be stored beside a pupil's name. Through carefully designing the spreadsheet in a user-friendly way I was able to store all the student names and details on one page. I also designed and implemented a method for recording report notes, which would allow the user to incorporate them all onto one report page automatically along with the students' results. I believe I met and optimised this objective to its full functionality. * Classes and pupils to be stored on a separate database/sheet, so class marks can be recorded. I created a separate page for every subject and created a method for teachers recording four class tests per year with the ability to record more if required. ...read more.

Middle

I did not include forms as I found in was quite easy to put in data the manual way and in order for list boxes to be used forms could not. I also reviewed the benefits and disadvantages to including forms and came to the conclusion that they would confuse staff too much, so I did not include them. I believe that through closely working to meet the original objectives, I have created a spreadsheet that is fully functional, easy to use and meets all the Principal's requirements. Through closely sticking to my design specification and my original plans I was able to constantly keep the design process progressing. Although when I actually came to including some of my original plans they caused issues and I even left some out such as the forms. Throughout my designing of the spreadsheet I encountered many problems and difficulties which I had to quickly overcome to keep on schedule. I concentrated on all the tasks and eventually successfully overcame all the problems and kept on schedule. As the Principal also had a lot of free time on his hands and it is quite a small school I was able to work closely with him throughout the process and we were both constantly adding and removing new functions. In total I had 6 weeks to design a fully functional spreadsheet and I found this the major disadvantage in the designing process. ...read more.

Conclusion

This also meant there was a lack of time due to the fact that the spreadsheet could only be worked on within the school. Also although constant meetings with the Principal helped me ensure the spreadsheet was best designed he was constantly making amendments which were very time consuming. I also still had to make an appointment with the Principal each time I met him which also wasted vital time. Also the fact that I was not able to get the rank order function to function properly is also a major weakness. I believe the key to designing a successful spreadsheet is working to a detailed specification, therefore if I was to undertake a similar project I would spend more time on the design specification. I also believe that good time management skills are vital to ensure targets are met on time. I believe that I have met the objectives I set out to do and my solution is easy to use. If doing this project again I would like more time. I realise now that the time spent on planning and design was invaluable to me. I would also test every single function and user aid used. I also got some feedback from the Principal and his staff. Their comments are useful and I would certainly use them if doing this again. Overall I am pleased with my finished project. ?? ?? ?? ?? Unit 10 ICT: Numerical Modelling using spreadsheets Candidate Name: Shane McCudden Centre Name: St. Eugene's College Candidate Number: 5032 Centre Number: 71979 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Information Systems and Communication 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 AS and A Level Information Systems and Communication essays

  1. Feasibility Report

    Microsoft Word 2007 will help staff within the Perfect Pie Company; create professional-looking content more quickly than ever before. With a host of new tools, the staff, can quickly construct documents from predefined parts and styles, as well as compose and publish blogs directly from within Word.

  2. User Guide to my minibus hire database.

    The record will then be completely deleted from the database. If a message like this appears (shown in the above screenshot), then you will need to delete the records before hand from the "minibusoriginal" table.

  1. A2 ICT CouseWork

    then we would take a screenshot of doing so and explain how this is good. It is important we test our HTML and PHP code for any errors, as our website could be appear to be fine on some browsers; as these browser's may ignore the problem but other browser's

  2. PC comparison and Specification

    Operating System: The OS is brand new and its the latest one out for windows, its simple and basic so even beginners in the computer world can find it easy to use. this operating system is a 64bit type instead of the normal default 32bit and the reason for 64bit

  1. Task G Final Evaluation

    The software I have created includes three songs as the brief asks for. My product includes a navigation system to allow the user to select a song they wish to practise and the difficulty setting out of beginner and expert.

  2. Communication & Employability Skills for IT. OCR Cambridge Technicals Unit 1 LO1-P1

    Independent Worker 8 I think that this is the least important skills for an IT manager because most of the decisions that the manager does are mainly researched and done by other employees. The manger has to make decisions through teamwork.

  1. Features of database design

    book was published then there is another table that has information about publishers which could have the publishers phone number and address. So the relationship for this database is when a book has been selected the publishers details are shown and not duplicated on more than one table.

  2. ICT revision notes - IT project management

    Programs are coded, tested and documented. âFiles must be converted into a form suitable for the new system. âHardware must be installed and thoroughly tested as the installation may require extensive cabling and alteration of buildings. Testing âTesting is a crucial stage of the development.

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