• 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...


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.


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.


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

    From the Microsoft Office Fluent user interface to the new graphics and formatting capabilities, Microsoft PowerPoint 2007 puts the control in the hands of the staff to create great-looking presentations. Microsoft Publisher 2007 will allow the staff within the Perfect Pie Company to create, personalize, and share a wide range of publications and marketing materials in-house.

  2. ICT 3b evaluation

    A mobile allows him to phone or text anyone he wants. He can use the calculator, currency converter, calendar, alarm, time, security, tools, text messaging, accessing to web and more. A mobile uses a charger to be charges and it uses a sim card, a sim card has its own

  1. System Analysis and Design Assignment

    Books are only stored by Title, therefore locating a book by author would be an almost impossible task and very time consuming. * How a Member Finds a Book In order to find a specific book in the learning centre library, the member has a number of choices available to him.

  2. Database Analysis & Design

    team can make any decision; this saves time as staff do not have to wait for approval from higher levels. Development is iterative and driven by the users of the end product. Feedback helps an effective business solution All changes within the development in this methodology are reversible The high

  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. Website Design, Creation and Evaluation

    This will require the creation of a Maintenance Plan. 1.2 Action Plan For this assignment I am going to create an action plan which will help me organise the progress of the project. This will allow me to easily manage my time much more efficiently and ultimately benefit the project.

  1. 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.

  2. ICT revision notes - IT project management

    so they will sometimes change the project plan to take into account these problems. Introduction âWhen a new computer-based system is introduced by a business, it is usually to replace an old system which may be a manual system or an outdated, computer-based system.

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