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

ICT project - record system.

Extracts from this document...


GCSE ICT PROJECT MICROSOFT ACCESS STUDENT MARK RECORED SYSTEM WRITTEN BY SUBHAN ALI IDENTIFY Identify the User There is a geography teacher known as Mrs Knight and she works at Kingswood Primary School. Since she has been there, Mrs Knight has kept a record of all her pupils' marks in a register starting from years 7 up to 11. But the problem is that she cannot gain enough information about them, however, accurate and organised the records are. E.g. if a student receives a mark for his exam in a percentage it would also be helpful if the mark they actually received, was visible on the records, this would allow Mrs Knight to observe if a student is progressing or actually getting on with his/her work. Also she would like to see a particular students grades individually without other students marks being visible e.g. on a parents evening she would like to show the students mark but without having to see any other students marks in the record book. Manual Solution Considered One solution Mrs Knight could use is by manually adding a few more columns to her record book, and work out the pupils average by hand and note them down, she would then be able to make a list of the average grades and keep an individuals grades private from being visible to other students. ...read more.


and class] ASSIGNMENT - Contains information on the assignments set [AssignmentID, Type, Date, Description and MaxMark] STUDENTMARK - Contain information on what marks the students have achieved for each assignment and will consist of [StudentID, AssignmentID, and Mark] Two reports will need to be produced for the database. The first report will be the report for individual grades. To create the individual grades report, a query will run in the system to combine data from all three. This will produce the report. The user will then be able to specify a particular students name and then the query will be used to calculate the percentage grade for each assignment. This query that will need to be produced will be the source of the individual grade reports for each of the students. This report needed to find the average mark for a particular student using the summary function. The second report will print a particular class's grades, for each assignment covered. In order to do this the user will be asked to enter the assignment code and class name. Alternative methods of Output Methods Considered In order to view the reports or print them an on-screen monitor and printer will be required for the system. When Mrs Knight arranges a Parents Evening, she will need to print a report of an individuals grades and the class list of grades for a particular assignment. ...read more.


To do this it will need to include an extra report. Subtasks Identified The implemented final design will need to be broken down to manageable sub-tasks to make it easier to understand. I will need to 1. Create three tables and classify the particular default validations and values. 2. Create relationships between each of the tables. 3. Create the data entry form so that students can be entered into the system. 4. Create the data entry form including the sub form so that assignments and grades can be added. 5. Create the three queries so the user, can specify a particular pupils details such as first name, surname, and class to attain information about them. 6. Create the three reports to display the assignments and grades for each pupil in a certain class. 7. Finally, create the menu, so that the user can access the option they want e.g. assignments and grades on a particular pupil, individual grade reports etc. The menu will also need an exit button, so that you can exit the database. The implementation section, gives evidence to show that the program has actually been created. I may find some errors in the program when implementing it, and any errors discovered will be described into why it has appeared as an error, and then gradually be corrected, to give the perfect result. Test Results The test plsns I created in the design section of the prject, can now be implemented ...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 Software 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 Software essays

  1. Analysis section for database project based on a hotel booking system

    Finally, I will have to design a new Logo for Luxury Hotel to boost the image of the Hotel and to give it a professional feel. This logo will be used on all letterheads to members. I will use paint/fireworks (Choose only one software you are already familiar with pls.)

  2. The aim of my project is to make the task of the allocation of ...

    We will then put 1 adult, child and concession in each section of the seating, which should show on the table beside that there is one person sitting in that area and its income relevant to the price of doing so.

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    the average, max, min etc providing the calculations are correct, therefore making the process easier for the teacher, as she doesn't have to change them herself. Furthermore, data can easily be formatted creating attractive, readable tables, charts or text, which is an advantage for the teacher as it allows her

  2. AQA GCSE ICT Specification B

    The money for the item is received, and a receipt is written by hand and sent. 6. The item is produced and sent to the customer. Problems with the current system The current system is complicated with many opportunities for human error to occur.

  1. Project 1a. ICT

    I will talk about Boolean searches later on in the project. This picture from my ICT source is found on my 2nd, 3rd and last slides. Secondly I am going to show you my Non ICT sources, as I found one source which I could fit into my Presentation perfectly.


    studio is a much updated piece of software and everything within the program is of high standard although there is some room for improvement such as DVD authoring and automatic movie generation. One advantage to Ulead video studio is that it is very quick and easy to use as its layout is simple and very clear.

  1. Spreadsheet Report

    Here is some screen shot Here is an example of Patterns:colour I did this so that all my cells would be correctly formatted for there place. Meaning that a cell containing the Limo Name should be in General format, it wouldn't make sense for it to be in a date format.

  2. Powerpoint review project

    Presentation graphics uses colours and drawings to get the attention of the audience. People use custom animations to make entrances and exits to slides effective to any object. Slide transitions are used to make your timing and how you want to go to the next slide by clicking or running automatically.

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