• 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
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  • Level: GCSE
  • Subject: ICT
  • Word count: 4159

Planning a system to handle school records.

Extracts from this document...

Introduction

Identification: Real user: The examination department of CAMS School has to maintain the student progress record. Part of the education process requires the examination department need to assess the students at regular intervals throughout the school year and keep a record of achievement for each student at the end of the year. The examination record should build up over the duration of the course to allow the staff, students and parents to see how the students' are progressing. The examination officer Mr.Ahmed has asked if I can help them with a particular project to satisfy their need. The examination department and the examination officer Mr.Ahmed will be my end user. The problem and how I discover it: My friend Asad study in CAMS school. In May 2008 he gave his year 10 exams and left for his holiday without taking his result. On his return when he went to collect his result with me he found lots of mistake in the report card. The term marks of history and literature were written incorrect. He marked absent in mathematics. We informed the examination department about this blunder and asked them to rechecked and correct it. After two weeks the examination department could not done anything about the history and literature result as they had lost the record while they marked present him on mathematics paper. My friend was very upset with his result. Why Has This Problem Arisen? Cams school is keeping and making their school results manually, the manual files are prepared for each class and course and class teacher prepare result in register, from where they were shifted to big result sheet and then to report cards. there is no system in place at present to record assessment results efficiently and allow the staff to monitor the students' progress throughout the year. Resultantly, the staff must find the time to meet these needs and are finding it difficult and time consuming to record and collate the assessment marks using a manual system. ...read more.

Middle

When communicating with the staff of the ICT department I will use the school's e-mail Microsoft outlook. Input of data As most of the data like mark allocation, grade boundaries, courses names etc will be collected through prospectus and questionnaire and personal interview .the required information will be placed on hard copy and then I will use a keyboard and mouse to input `this data. In order to reduce typographical errors and improve the automation of the system some data will be input using drop down lists and other data will be generated automatically using Look Up Tables. . The school logo will be imported into my documents from Paint Shop Pro. Data process: To identify the processes that need to be carried out on the data i need to consider the user objectives. * Graphics - The school Logo may need to be edited and resized. * Headings - A design will have to be produced incorporating all the necessary Row and Column headings, to allow the data to be laid out in a way that makes it easy to use. * Data - All calculations need to be automated. This will be done using formulas to sum marks and calculate totals and averages. Totals should also be automatically transferred to the summary data sheets so that they can build up a progressive picture of the students' progress throughout the course. Filters will be applied to view different sets of results. * Hard Copy - All worksheets containing summary data that are to be produced as hard copy must be formatted in a way that allows them to be printed out on one page. * Graphs - These should ideally be able to be produced for each student to show how that student is performing in each of the units and in their projects. If possible the class average should also be graphed so that the student can be compared to their peer group in terms of overall performance and overall class performance viewed for all units. ...read more.

Conclusion

---- GRADE ALLOCATE GRADES ACCORDING TO PERCENTAGE SELECT GRDADE FROM LOOK UP TABLES ---- Summary result sheet could not prepare as found error in transferring data from selected sheets. CORRECTION OF ERROR: I correct the formula and now the data is transferring to sheet. DETAILS TEST EXPECTED RESULT ACTUAL RESULT STUENT NAME COPY AND PASTE SELECTED FROM SHEET 1 DONE CUMLATIVE MARKS OF ALL COURSES CORRECTLY COPIED MARKS OF ALL CORSES FROM DIFFERENT SHEETS MARKS ENTERED CORRECTLY FROM SELECTED SHHETS DONE TOTAL MARKS OF ALL COURCES SUM OF COURSES CUMLATIVE MARKS TOTAL CORRECTLY DONE PERCENTAGE OF CUMLATIVEMARKS CALCULATE PERCENTAGE OF CUMLATIVE MARKS CORRECTLY CALCULATE DONE GRADE ALLOCATE GRADES ACCORDING TO PERCENTAGE SELECT GRDADE FROM LOOK UP TABLES DONE It was user requirement to that performance of student in each course must be present graphically. I need to prepare graph sheet for each course and summary result as well. I found it very difficult to solve it. Steps: Select sheet. Select data from any sheet(business or English) Select name and cumulative marks Select graph TEST TABLE DETAILS TEST EXPECTED RESULT ACTUAL RESULT Y -AXIS HEADING AND TITLE AXIS PRESENT AND CLEAR ERROR X- AXIS HEADING AND AXIS TITLE FORMATED CLEARLY ERROR CHART COLUMN GRAPH PRODUCE DATA CORRECTLY TRANSFERRED FROM OTHER SHHETS AND PRODUCE GRAPH ERROR I found error in preparing graphs. CORRECTION OF ERROR: Select the data from required sheet. Copy Student name and Marks. Select another sheet Select graph press enter and select paste option. DETAILS TEST EXPECTED RESULT ACTUAL RESULT Y -AXIS HEADING AND TITLE AXIS PRESENT AND CLEAR DONE X- AXIS HEADING AND AXIS TITLE FORMATED CLEARLY DONE CHART COLUMN GRAPH PRODUCE DATA CORRECTLY TRANSFERRED FROM OTHER SHHETS AND PRODUCE GRAPH DONE I need to create user interface so the user can easily and quickly access to the required sheet. Steps: Select sheet. Select shape of button from toolbar. Make hyperlink. TEST TABLE DETAILS TEST EXPECTED RESULT ACTUAL RESULT USER INTERFACE LINK TO REQUIRED SHHET/HYPERLINKS CORRECTLY LINK TO APPROPRIATE WORKSHEET DONE 1 ...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. Different types of technology How I use ICT at home and at school

    It makes people addicted and that's how Facebook has become so popular and why I have taken so long to successfully finish 3A. Summary of advantages * I can have a social life despite being a closeted internet geek * I can keep in contact with old/new friends without having

  2. ICT PROJECT

    Select add new student details macro button To check if the macro and write protection work properly Macro should take the user to the student list sheet 14. Select enter marks macro button To check if the macro works properly Should go to the enter mark sheet 15.

  1. Creating a computer system for a video rental shop

    date of reservation Domain Domain value ID number Integer Names Character Date Date values Currency Sterling List of all attribute and its domain values Attributes Domain Member ID ID number Surname Names First Name Names Member address Names Date of borrowing Date Date of returning Date Author name Names Reserving number ID number Transaction number.

  2. GCSE Excel Project ICT

    As you can see, the addition in the formula states a specific sheet and cell (a cell on sheet1). This is to prevent confusion within the formula with the cell B16 on the current sheet (sheet7). With this addition in place, the sheet should look like this: Printouts of each report, with screenshots of each worksheet and showing formulas used.

  1. ICT Coursework (MarcoS)

    * To change the color of the text you can change color befor start typing in, or once you have type in the text you can select the cell with the text you want to change and then change color.

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

    Finally I am going to click on criteria and type in [Enter your "ADDRESS"] etc. The method for using criteria's worked really well. The only change should be that it would be easier if there was screenshots or images. Creating Forms I will open Microsoft access then I will click on create and select form wizard.

  1. Computer project Alevels

    To enter fields from the tables you have to click on the 'Field List' button and then you can drag and drop the fields that you want to use on the form, on to the form. * EDITING THE SWITCHBOARD - Here it can be edited in the same way as a usual form.

  2. Computer Studies Past paper definitions

    download transfer/copy a file/data/program from a central computer/host computer/server to a smaller computer/remote station/user's computer [2] 2009 Explain, using examples where appropriate, the meaning of these computer terms. (a)

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