• 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. Different types of technology How I use ICT at home and at school

    Disadvantages (How it does not meet my needs) However, Facebook can be quite deceiving. While it may make me think I have a social life. It simply gives the illusion. The social life it makes me think I have is simply created online and it doesn't mean I have a social life in real life.

  2. ICT Project - Statement of the Problem

    is done manually and the member's information is not kept on a database. So for example the members fill out a form on paper that is then place alphabetically the members file ling cabinet. Additionally the restaurant bookings are also done manually on pieces of paper., which has consistently lead

  1. GCSE Database Project ICT

    This is repeated for all of the above making sure the tables are joined in the direction displayed in the design and the final product will look like this: This is then checked to see if the relationships are logical: One member of staff can have many patients, one patient

  2. ICT Project 1A

    And here is how it appeared on my Website. Tokio hotel are very famous in their homeland and many of their singles have reached number 1 in Germany and the surrounding countries. But they have broken into England too! So far they have released 3 singles in English, 2 of them getting into the top 100 in the UK!

  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. GCSE Excel Project ICT

    Recalling Information From Archive When a customer returns Alex checks through the archive to see their previous order and purchase, this happens occasionally but mainly with the companies. Alex then gets his 'Archive' folder and searches through for the relevant sheets of paper however, this could potentially take a long

  1. Introduction to information skills and system. An information system is a system that accepts ...

    Data are accessed directly without going through other things. Cache is another example of primary storage. It has the same functions are RAM, but is temporary storage for quick access. ROM read only memory, permanent memory where instructions are stored. These instructions are not to be edited or it may distract the processing of the computer.

  2. This report I will be writing, will be on the way I do activities ...

    By allowing you to send a whole file at once it saves much more time and hassle. USB Pen Drive - Flash Memory USB Pen Drives are portable, external mass storage devices with a USB plug which can transfer files from one USB supporting machine to another.

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