• 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. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    of the staff members, I have found out that he has considerable experience working with computerised systems in the past. The other members have less experience with ICT than the manager, but they do have a rudimentary understanding of how computer systems work.

  2. Feasibility Report

    Rapid pulse updates every 5 to 15 minutes-provides up-to-the-minute protection so the chance is slim that the Perfect Pie's computerised system will become infected. Prevents virus-infected emails and instant messages from spreading-Feel secure while you keep in touch. And lastly blocks browser exploits and protects against infected Web sites-Surf the Internet with confidence.

  1. A2 ICT CouseWork

    clumps of text"- Pass "To be honest I thought that the web site content's where reasonably spread out, and that the text was put into easy to read small clumps." I would hope that you would consider people with eyesight problems and that you will make the Text as clear

  2. Database Analysis & Design

    The deliverables for this stage are a Functional Model and a Functional Prototype that together represent the functionalities that could be realised in this iteration, ready for testing by users. Next to this, the Requirements List is updated, deleting the items that have been realised and rethinking the prioritisation of the remaining requirements.

  1. Data Processing Task. Mr Peters, the man who runs this particular Samsung store ...

    After the Ok button has been pressed the macro will run the four queries which will first put the data from the main form and the sub form into two make tables. The macro will then run the two update queries which will transfer this data into the main form table and the sub form table Test Plan Test No.

  2. User Guide to my minibus hire database.

    field is already in currency form so you will only need to type in the numbers. - Beside the "Number of seats" label there will be a data entry box, type in the number of seats the bus has in this box.

  1. ICT revision notes - IT project management

    âInevitably, changes will need to be made to the systems. These changes are known as system maintenance. âMore hours are spent on programming these tasks than creating new systems. âIt is also to evaluate the success of the project and review its effectiveness.

  2. Features of database design

    The database is set in a way where data can be accessed or changed in different ways and not be duplicated. Relationships ? Relationships in a relational database are used to prevent data that is not needed and also prevents you from putting the same data in twice.

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