Used alongside the students' text, Higher National Computing 2nd edition , this pack offers a complete suite of lecturer resource material and photocopiable handouts for the compulsory core units of the new BTEC Higher Nationals in Computing and IT, including the four core units for HNC, the two additional core units required at HND, and the Core Specialist Unit 'Quality Systems', common to both certificate and diploma level. The authors provide all the resources needed by a busy lecturer, as well as a bank of student-centred practical work and revision material, which will enable students to gain the skills, knowledge and understanding they require. Also available as a web download for adopters, this pack will save a course team many hours' work preparing handouts and assignments, and is freely photocopiable within the purchasing institution. The pack includes: * Exercises to support and develop work in the accompanying student text * Planned projects which will enable students to display a wide range of skills and use their own initiative * Assessment materials * Reference material for use as hand-outs * Background on running the new HNC / HND courses * Tutor's notes supporting activities in the students' book and resource pack * All the essential material for running a course in the 2003 Higher National Computing qualification from Edexcel * Full coverage of the compulsory core units for both the HNC and HND * Freely photocopiable within the purchasing institution with electronic files available to download from the web, this pack will save a course team many hours' work preparing handouts and assignments
Author(s): Howard Anderson, Sharon Yull, Bruce Hellingsworth
Edition: 2
Publisher: Newnes
Year: 2004
Language: English
Pages: 270
Higher National Computing Tutor Resource Pack......Page 4
Contents......Page 6
Introduction......Page 8
Internet, the main search engines......Page 9
Effective searching of the Internet......Page 11
Searching the Internet......Page 12
Moore’s law......Page 14
Logic and logic gates......Page 15
Arithmetic with circuits......Page 17
Address decoder......Page 18
Circuits with memory: flip-flops......Page 19
HEX, binary and other number bases......Page 20
Conversion using successive division......Page 22
1.4 ASCII and Unicode......Page 24
Concepts of data storage: integer type......Page 26
Little endian numbers......Page 27
Worksheet Units 1.1 to 1.10 Stored numbers, integers......Page 28
Concepts of data storage: floating point type......Page 38
Worksheet Unit 1.11 Floating point fractional numbers......Page 39
Worksheet Units 1.12 to 1.17 Number bases......Page 40
Worksheet Unit 1.18 to 1.23 Storage of data, bitmaps......Page 49
Answers to worksheets......Page 55
Hierarchy of design......Page 61
Layered architecture......Page 62
Suggested solution......Page 64
*descriptive......Page 65
Suggested solution......Page 66
Solution to Exercise 2.2.1 – Bess and Bailey Dog Kennels......Page 67
Suggested solution to Exercise 2.2.2 – College MIS System......Page 75
SSADM® Analysis and Design......Page 81
Suggested solution to Exercise 2.2.3 – Bess and Bailey Department Store......Page 83
Suggested solution to Exercise 2.2.4 – Seminar Organization......Page 85
Unified Modelling Language (UML)......Page 87
Suggested solution for Exercise 2.2.5 – Bernese College......Page 88
Suggested solution for Exercise 2.3.1 – College Management Information......Page 94
Requirements analysis additional exercise 1......Page 95
Requirements analysis additional exercise 2......Page 96
Solution to Exercise 2.4.1 – Fiddle VAT Company currency exchanger......Page 97
Data models......Page 101
Solution to Exercise 2.4.2 – Morgan Software House......Page 103
Solution to Exercise 2.4.3 – Extract from a College Management System......Page 104
Data Modelling – additional exercise 1......Page 111
Data modelling – additional exercise 2......Page 115
Worksheet Units 3.1 to 3.8 Pascal......Page 122
Answers to worksheets......Page 130
4.1 Activity One – File-based systems......Page 142
4.5 Activity Five – Database design and editing......Page 143
4.6 Activity Six – Case study: The Organic Food Company......Page 144
4.8 Activity Eight – SQL exercises......Page 149
4.9 Activity Nine – Data mining......Page 150
5.3 Possible solutions......Page 152
Effect on the LAN topology......Page 153
Security and its effect on the LAN topology......Page 154
6.1 Activity One – Planning and review......Page 156
6.3 Activity Three – SWOT analysis......Page 157
6.4 Activity Four – Team roles......Page 158
6.5 Activity Five – Verbal communication......Page 159
6.6 Activity Six – Creating a CV......Page 160
6.8 Activity Eight – Producing written documents......Page 161
Report content......Page 162
Sample letter......Page 163
Sample memo......Page 164
Sample report......Page 165
6.10 Activity Ten – Presentations......Page 166
6.12 Activity Twelve – Freestyle presentation......Page 168
Further information......Page 170
Total quality management (TQM)......Page 171
ISO standards update and exercise solution......Page 172
Patriot missile......Page 174
The London Ambulance Service Computer Aided Dispatch Service......Page 175
Software maintenance......Page 181
Version control......Page 182
Suggested solution to Exercise 7.2.1 – version control......Page 183
A test plan in action......Page 186
Introduction......Page 188
Critical path analysis – additional exercise......Page 190
Microsoft Project......Page 191
@BNF syntax......Page 201
Data dictionaries – additional student exercise......Page 203
Suggested solution to Exercise 7.4.1 – Bailey Comfortable Room Company......Page 205
Additional example – control aspects......Page 207
Coupling and cohesion......Page 209
College Admission System......Page 210
Object-oriented analysis and design......Page 211
Suggested solution – airline booking system......Page 216
Software metrics......Page 225
McCabe’s Cyclomatic Complexity metrics......Page 226
Impact matrices......Page 228
ASCII text characters......Page 232
How to obtain a hex dump with DEBUG......Page 234
