• 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

    to problems such as over booking and bookings being lost With the restaurant expanding as fast as it is me and Mrs Elone have both agreed that that the best thing to do is create a data base system for restaurant so that data retrieval would be made be a

  2. 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.

  1. ICT Report 2b: ICT in Organisations

    Wireless mice are also on the rise in the market today, and as with the wireless keyboard, provides much more freedom in terms of comfort; the user can sit and type/navigate from up to 2 metres away. The two wireless peripherals (keyboard and mouse)

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

    to send any number of files but it has to be done all separately, this is very time consuming as I have to upload each individual file into an attachment and then I have to download each file onto the computer when I get home .

  1. 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).

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

    more Ranking: The respondent can rank things or order of what they like the best or least. E.g. Indicate your preference for what you look for in as good home. (1very important and 4 least important) Good neighbours Big garden Close to the shops Four or more bedrooms Attitude scales:

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

    software excel, calculator Saving and retrieving: Saving and retrieving is important because it allows edited data to be stored and edited later on. Most information systems have a primary storage and a secondary storage. Primary storage is used to store data/information that needs to be instantly accessible to the CPU.

  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

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