• 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


    Line Address - 2nd Line User Feedback on Initial Designs I asked the workers at surgery who will be working on the database of what they thought of the design. Here are the results of opinions: Most agreed when asked that nothing was missing and the system looked complete.


    Xsite Pro makes it boring when the user is outsourcing a lot of websites updating to a virtual assistant. This web designer is by far the best out of all the programs reviewed here. COMPUTER SYSTEMS In the following table is two computer systems that I have made up using

  1. AQA GCSE ICT Specification B

    to use. Space is used to store documents. More staff are needed to man the system. There is a high risk of human error. Exporting and importing data is difficult. Solution 2 - Spreadsheet Based Solution Pros Cons Software The spreadsheet is simple to use. Imputing data is fairly easy. Many people can use the system at once.

  2. spreadsheet project

    The main disadvantages of using a computer is that it could crash and you could lose all of your data, however if you create backup files on a memory stick or CD this won't be a problem. Using a computer regularly strains your eyes so it is a good idea to take regular breaks to prevent this.

  1. Evaluating a relational database solution

    With reports I could easily designed the way they looked my going into design view. In this I had three sections, header, footer and main section. I could put information in all three sections. The results were automatically put into the main section.

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

    Output via a laser printer would probably be of better quality and faster, but costs are a lot higher, a normal ink jet printer for Mr. Brown would easily suffice. The visual appearance of a model is important as it will contribute to Mr.

  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.

  2. computerised spreadsheet for pupil attendance data

    and behind the scenes of the database will be the administrator of the school. The system will have a password, which prevents the user from changing the design or appearance of forms. As a backup I could send the spreadsheet to my email account regularly to prevent breached access.

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