• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  • Level: GCSE
  • Subject: ICT
  • Word count: 3904

Now that I have completed my analysis of the current working of Emirates National School I will now have to suggest the solutions, which I will have to implement using the new system, which I have proposed.

Extracts from this document...

Introduction

Now that I have completed my analysis of the current working of EMIRATES NATIONAL SCHOOL I will now have to suggest the solutions, which I will have to implement using the new system, which I have proposed. After I have installed and configured the new hardware and software for the newly purchased computers I would next have to make a list of data, which I will require if I am creating a new database for EMIRATES NATIONAL SCHOOL. This data would include all the files, which contain all the student details, teacher details, staff details and the list of books at the library. This data remains relatively fixed throughout the year as very rarely does the school admit new students in the middle of the school year and it often doesn't introduce books in the middle of a scholastic year. This data is currently being stored in a filing cabinet in the school office and there are different files for each category. I would have to obtain the headmaster's permission to go through these files. However besides these data items of student and teacher details and the list of books at the library there are other forms of data, which are added on continuously through the scholastic year. This would include the marks of each student for each subject, a student's attendance and a student's medical record, which is maintained by the school. Since my aim to carry out a complete revamp of the school's data handling methods this data too will have to be obtained on a weekly basis once the school year begins. I have to consult all the teachers for the marks for each of their students, the attendance of the students, I would also have to go to the nurse and request her for all the student's medical records. I would then have to obtain the headmaster's permission to handle all this data. ...read more.

Middle

Preciously all of these operations were done by hand and so this took a long time. By using MS Access I am providing EMIRATES NATIONAL SCHOOL with something, which will instantly improve all the time taken for referencing and drawing up of reports and that is automation. With MS Access I don't have to keep opening and closing tables to meet a query, which the headmaster requires. Or I do not have to have a pen and paper ready to scribble down values from MS Access' tables to produce a monthly report of the performances of student's for a particular month. MS Access does this all and much more and all I have to do is click the mouse a few times and enter a few simple commands. These reports, which can be created using the MS Access, report Wizard can be customized according the user's needs. The report function gives the user the flexibility of customizing the report and at the same time the report can be presented in a professional outlook. However besides creating reports and entering data the most vital segment in any database is the ability to have fast access to data at any given moment. This would depend on how well the data is categorised and also the method used to access this data also plays a role in how the data is accessed. In the case of EMIRATES NATIONAL SCHOOL the data which is being stored manually takes along time to refer too since for example of the headmaster requires a particular item of data like all those students who have not received the Polio vaccination this would take a long time as the secretary would have to go through each and very student record in the medical file and note down the names and classes of all those students who have not received the polio vaccine. However with the use of MS Access I can use the query feature to automatically show up the desired results based on the conditions, which have been given by the headmaster. ...read more.

Conclusion

The mark register, which I will be creating, will have the basic fields of the student's name and roll number, gender. Besides these fields the subject names would be entered as the remaining fields. It will be under these fields that the marks will be entered. However the subjects for the juniors vary. Therefore I will have to create two different mark registers. One mark register will be for seniors where the only change will be in the field names for the subjects. Another mark register would be created for junior students. Also to simplify things I may even divide the senior and junior mark registers into Senior Boys and Girls and Junior Boys and Girls Mark register. By dividing the mark register in this manner I will be simplifying the entering the data and also makes it easier for reference. After creating these tables I can then merge the Boys and Girls Senior Mark registers so as to form one Senior mark register. The same will be done with the Junior Mark Register to form a final Junior Mark Register. These are the main outputs, which I will be creating. However all of these outputs involve only the entry of data. I will have to manipulate this data to create actual outputs, which will be used to present this data. Therefore after entering this data I would create reports, which would be used for presentation. Besides creating reports I would also have to constantly refer to data according the school's wishes. To carry out this reference efficiently I would run a query, which is not an actual output but more of a display of records based on a given condition. I have now decided on what I will be doing to implement my new system using the new computer system. After deciding on what I will be doing I have mentioned the outputs I will be creating using MS Access. In the next section of my coursework I will decide on the features I will be using in MS Access to create these outputs. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. The Advantages of Using ICT Over Manual Meethods. Using Paint and Access.

    Using criteria's ([Enter], <>, Yes) Firstly you select on Queries, then the query you already created then you right click and select design view. After that you select criteria at the bottom and you put in [ENTER ID PLEASE]. This is how you use criteria.

  2. Different types of technology How I use ICT at home and at school

    While it can enlighten you, engage you and interest you, it just gives negative effects, influence your mind with negative thoughts and in general, give bad long-term health. But If you're in control, then television can be quite the useful thing.

  1. ICT PROJECT

    As expected Grade boundary Test and data used Purpose for test Expected result Results after testing 45. Try delete a value in the comment table To check if write protection works Should ask for a password As expected 46. Click on the any of the values in the comment table

  2. This project is designed to help non-computerized library to easily keep track of their ...

    OUTPUT * The output shown is the date each shipment is received in the Blain City Library, the overall price, a checklist of each order to cross off received ones, and the resultant balance after the transaction has gone through.

  1. This report I will be writing, will be on the way I do activities ...

    * It's free to use. * It can be sent to anyone around the world so long as they have an Internet connection. * You can send messages to large numbers of people Disadvantages Along with the advantages there are also disadvantages to e-mail such as: * You can't ensure

  2. Database Analysis and Database Design Project - DVD library for moving images.

    TEXT (5) PRIMARY KEY (P.K) CATEGORY TABLE ENTITY NAME ATTRIBUTE NAME ATTRIBUTE DESCRIPTION FIELD SIZE DEFAULT MODE CONSTRAINS CATEGORY CATEGORY_ DESCRIPTION CATEGORY OF THE MOVIE TEXT (15) PRIMARY KEY (P.K) RATING TABLE ENTITY NAME ATTRIBUTE NAME ATTRIBUTE DESCRIPTION FIELD SIZE DEFAULT MODE CONSTRAINS RATING RATING MOVIE RATING TEXT(2)

  1. Business Requirement Analysis - On my paper, I will be discussing the analysis of ...

    What General Electric has done in the past was they would keep a large sales staff to help customers with their purchase of General Electric products. With the introduction of the internet and General Electric new e-business, the sales staff had become worried that they might lose their jobs because of the internet and they feeling not needed.

  2. Benefits of using my IT system in the Travel Agents.

    * Finally you click on Save. * If you want to save the same document again next time, you don't have to go on Save As again and again. All you have to do is to click on File and then simply click Save.

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