• 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
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49
  50. 50
    50
  51. 51
    51
  52. 52
    52
  53. 53
    53
  54. 54
    54
  55. 55
    55
  56. 56
    56
  57. 57
    57
  58. 58
    58
  59. 59
    59
  60. 60
    60
  61. 61
    61
  62. 62
    62
  63. 63
    63
  64. 64
    64
  65. 65
    65
  66. 66
    66
  67. 67
    67
  68. 68
    68
  69. 69
    69
  70. 70
    70
  71. 71
    71
  72. 72
    72
  73. 73
    73
  74. 74
    74
  75. 75
    75
  76. 76
    76
  77. 77
    77
  78. 78
    78
  79. 79
    79
  80. 80
    80
  81. 81
    81
  82. 82
    82
  83. 83
    83
  84. 84
    84
  85. 85
    85
  86. 86
    86
  87. 87
    87
  88. 88
    88
  89. 89
    89
  90. 90
    90
  91. 91
    91
  92. 92
    92
  93. 93
    93
  94. 94
    94
  95. 95
    95
  96. 96
    96
  97. 97
    97
  98. 98
    98
  99. 99
    99
  100. 100
    100
  101. 101
    101
  102. 102
    102
  103. 103
    103
  104. 104
    104
  105. 105
    105
  106. 106
    106
  107. 107
    107
  108. 108
    108
  109. 109
    109
  110. 110
    110
  111. 111
    111
  112. 112
    112
  113. 113
    113
  114. 114
    114
  115. 115
    115
  116. 116
    116
  117. 117
    117
  118. 118
    118
  119. 119
    119
  120. 120
    120
  121. 121
    121
  122. 122
    122
  123. 123
    123
  124. 124
    124
  125. 125
    125
  126. 126
    126
  127. 127
    127
  128. 128
    128
  129. 129
    129
  130. 130
    130
  131. 131
    131
  132. 132
    132
  133. 133
    133
  134. 134
    134
  135. 135
    135
  136. 136
    136
  137. 137
    137
  138. 138
    138
  139. 139
    139
  140. 140
    140
  141. 141
    141
  142. 142
    142
  143. 143
    143
  • Level: GCSE
  • Subject: ICT
  • Word count: 14603

ICT PROJECT

Extracts from this document...

Introduction

AS ICT Project: Electronic Marks Tracker Analysis 4 Introduction 4 Description of the Current System 5 Problems with Current System 6 Interviewed Questions 6 Statement of User Requirements 8 Input 9 Output 9 Processing 9 Storage 9 Source Documents 10 Data Flow Diagram (level 1) 12 Objectives of the new system 14 User Skill Level 14 Project Constraints 15 Performance Criteria 15 Design 17 Choice of Software 17 Statement of Input, Processing & Output requirement 18 Data Set 19 Detailed Design: Worksheet Storyboards 21 Detailed Design: Storyboard Commentary 23 Macro Designs 27 Test Strategy and Testing Plan 31 Test Strategy 31 Testing Plan 32 Testing 41 Implementation 65 Choice of project 65 Initial design 65 Front end Menu 66 Enter Marks 72 User Form 1(Exit System) 78 User Form 2(Add New Student) 80 Data Form (Edit/Delete Student Details) 85 Class Boundary 85 Marking Archive 86 Pivot Table A 87 Chart 88 All Student 90 Pivot B 99 Parent Report 99 Auto open and auto close macro 101 Student List 106 Sheet protection 107 Evaluation 109 Performance Criteria 109 User Manual 122 System Requirements 122 Opening the System 122 Using the system 124 Enter Mark 125 Add New Student 127 Chart Summaries 133 Exit System 134 Troubleshooting 136 Analysis Introduction Ms Gammon is my user. She belongs to Sir John Cass Secondary School. She is a deputy head teacher and also teaches mathematics. As a deputy head teacher she makes sure that all students get to lesson on time. My user has a lot of work and responsibilities: * As a maths teacher she makes sure that her group come to class regularly. * She gives her students coursework to do and gives marks to each student. She will then record their marks into her mark book to make sure that all students have done their work to the required level. These marks are needed to help her come out with predicted grades. ...read more.

Middle

Select student list box To check that list box is working correctly When each student is selected from the list box, student roll number should appear in cell B22 As expected 31. Try to delete list box To test sheet protection User should not be able to delete list box As expected 32. Test that student list box is updated To check that list box correctly updates when new student is added to student list New student should added to student list sheet and should appear in list box As expected showed on the next page Before After a new student is added (Smith Janet) User form 2: Add new student Test and data used Purpose for test Expected result Results after testing 33. Select add new student macro button To check if the user form loads without problem A user form should be open, new line should then be insert at row two. When user click ok button the number will be sorted in ascending order and then return to main menu As expected 34. Click on add new student and then click on 'cancel' button To make sure macro behind cancel button works correctly. Inserted row should be deleted and user taken back to front end menu As expected 35. Delete all names in student list and try to enter a new record To ensure macro works when there are no records in the student list Data should be entered correctly, and user taken back to front end menu As expected, showed in the next page 36. Delete all names in student list and go to list box on "enter marks", "parent report sheet Tests that changes ink the student list are reflected in the list box The list box should contain no data. As expected Repeat testing Add names in student list and go to list box Test that changes link the student list are reflected in the list box The list box should contain data As expected show on the next page 37. ...read more.

Conclusion

Q5. What if none of the buttons work? Ans. Ensure that that you selected enable macros when the system starts up. If not close the system and re-open the system and click on enable macros. Q6.What if the roll number (linked Cell) is deleted? Ans. Click on the list box and select a student and the roll number will appear again. Q7.What if you want to delete all students records and start over again. Ans. Firstly you must enable sheet tabs to do this you go to tools then options on the menu bar. Check the option for sheet tabs and click OK First you must go to the student list Once you are in the student list you select A2 and press Ctrl Shift and down arrow. This would select all the records there are. You then you delete. You must not delete the first row, as these are necessary Also you must delete all the data in the marking Archive. To do this you must be in the marking archive sheet Once you are in the archive you select A2 and press Ctrl Shift and down arrow. This would select all the records there are. You then you delete. You must not delete the first row, as these are necessary Q8. What if I cannot see the change I made on student list Ans. You must always have to save your work before you exit as any changes would be lost if you do not do so. Q9. What if I cannot type data into the cell? Ans. That cell may be protected, meaning that it is locked. You are unable to type any data into these cells, as there is no reason for you to do so. You should refrain from changing data in protected cells. However if you feel that you must type data into cells you unlock it by going to tools then protection then unprotect sheet ?? ?? ?? ?? 12AS4 ...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. ICT Project - Statement of the Problem

    * Create mail merge to existing club members informing them of any promotions or changes to the club. * Hold an order sheet for the order of more drinks, glasses etc which will be printed out when necessary and sent to one or both of the suppliers.

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

    They can find out possibly where you live, what you do and how you act. Some people even forget to put up privacy options so a lot of people can stalk and find out all this without having to go through confirmation as a 'Facebook friend'.

  1. Explain the difference between primary and secondary sources of data, with examples.

    No interviewer bias is involved because there is no interviewer present. The only person there could be there would be the person handing out the questionnaire. Analysing the results on a large scale might be very time consuming and could be out of date when the results are ready.

  2. GCSE Calculator Project

    Why is the ICT solution the ideal solution? The ICT solution is the ideal solution because if you wanted to edit the calculator interface for the different person using it, it can be done easily and quickly without any cost. Another reason of which the ICT solution is the ideal solution is because when you upload the calculator

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

    There should be a system designed which will instantly show that the book is about to be steeled from the library. * The system will carry out mundane routines automatically. This will save time. * Streamlining the system through the elimination of unnecessary or duplicated steps.

  2. The use of ict has changed the way in which people work. Explain the ...

    This is the kind of person who you would talk to,Someone who speaks clearly , Someone polite, Some one with confidents, Someone who knows what there doing. You need someone who is useful on computer and understands what to do if somebody calls a call centre.

  1. ICT Report 2b: ICT in Organisations

    For instance, a Logitech mouse would come with its standard SetPoint software, which enables the user to vary the pointer acceleration, and its overall speed. Functions such as SmartMove are available to the user, for the pointers to auto-move to nearby dialog-boxes and onto OK buttons, to increase speed.

  2. Write up an Analysis for an ICT solution for an organisation that has a ...

    All of this has to be done before the client can go home. The client also at the end of each week has to write a list of the items that he has used and get a total for the week (for the tax man).

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