• 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

    the illusion of socialising when, in reality, you are simply sitting on your backside 'spying' on other people * Extremely distractive and addicting in some cases * Stalking is much easier to do * Can lead to harassment * Facebook provides a base for procrastination which stops me from finishing

  2. ICT PROJECT

    Select any of the records in the form To check if Vlooups are working accurately The report should change according to details 44. Select the grade boundary sheet and change the A to 80% To test the conditional formatting on the report sheet work correctly The conditional formatting feature should turn the A grade to green 45.

  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. Benefits of using my IT system in the Travel Agents.

    Finally I will create my switchboard. The switchboard was created successfully. The only change should be that it would be easier if there was screenshots or images and besides that it doesn't need any changes. Saving First I am going to click on File then I will select save as.

  1. Computer project Alevels

    * EMPLOYEE DETAILS When you click on the button "EMPLOYEE DETAILS" under the section member details on the MAIN MENU a screen appears as shown below. This contains all the information about the all the registered employees at MediCare Hospital System.

  2. IT Project Evaluation. The design part of my wages system, data capture form, letterhead ...

    Validation is checking done by the computer. It prevents typing errors and mistakes in data entry. This is in the form of a spellchecker that automatically identifies incorrect spelling and grammar to the user, allowing them to correct it. It also offers some suggestions as to what you may have

  1. Database Coursework

    7 Delete Melvin Record Deleted Record Deleted Printout 7 8 Delete Luke Record Deleted Record Deleted Printout 8 Printout 1 Printout 2 Printout 3 Printout 4 Printout 5 Printout 6 Printout 7 Printout 8 Evaluation In this section, I'll look at all of my objectives that I had planned to achieve, in my Specification section.

  2. Computer Studies Past paper definitions

    virus program/software which copies itself/replicates created to corrupt/do damage to files/system/boot sector/data spread through email attachments/floppy disks/CDs/USB drives [2] 1 Explain, using examples where appropriate, the meaning of these computer terms. (a) interrupt signal sent from a device.... temporary break ......

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