The Virtual Presence of Clive E Morley

AS and A2 ICT - Teaching resources

Recommended reading for AS and A2 ICT.
Theory books will be loaned by the department to all students studying ICT. These books will remain the property of the department of ICT at HNC and should be bought to all ICT lessons.
AS Project support Book. Julian Mott and Ian Rendell. Spreadsheet Projects in Excel for Advanced Level. London. Hodder & Stoughton. ISBN 0-340-80007-0.
A2 Project support book. Julian Mott and Ian Rendell. Database Projects in Access for Advanced Level. London. Hodder & Stoughton. ISBN 0-340-73805-7.
Please Note. Class sets of the project books will be available for use within lessons. However students will benefit from purchasing their own copies as this will afford further opportunities to work on the project outside of class contact.
Please Note: In general I have no objections to anyone using resources found on this site providing copyright is acknowledged and they are used for non-profit educational purposes. The intellectual copyright for the majority of materials on this site resides with me. Copyright of materials not created by me resides with the author and has as far as possible been acknowledged. I would appreciate having any oversights bought to my attention. Intellectual copyright is maintained on some files by password protection this is indicated by (pp©). Students at HNC should approach me and relevant passwords will be provided.
AS ICT
A2 ICT
Links / Other
IT03 Minor Project Timetable for 2002 -2003. Excel calendar with comments giving all deadlines associated with project. 67k.
IT06 Major Project Timetable for 2002 -2003. Excel calendar with comments giving all deadlines associated with project. 66k.
Link to AQA the examinations authority for the AS & A-level ICT program.
IT03 Mark Scheme / assessment. AQA Spec converted from PDF to Word format. 108k.
IT06 Specification and Criteria for assessement. AQA Spec converted from PDF to Word formant. 133k
Link to Fat Max. A great site that provides support for AS and A2 ICT. Past exam papers, mark schemes ect.

IT03 Minor Project Guidelines. An overview giving an indication of what to include in each section of the minor project. 228k (pp©)

NEW
IT03 Minor Project Guidelines (Revised 2003).
Full documentation advising students what to consider for each of the sections. Specification, Implementation, User Testing, Evaluation & User Documentation. Warning Large File size - 15 pages - 915k (pp©)

IT06 Major Project [Analysis] Support Notes. An introduction to what is required in the Analyis section of the Major Project. 142k (pp©)

NEW
IT06 major Project Full Guidelines. (Revised 2003)
Full documentation advising student what to consider for each of the sections. Analysis, Design, Implementation, Testing, User Docs, Evaluation & Presentation. 26 pages - 283k (pp
©)

Test your ICT Knowledge with this self-marking Crossword. Easy Version 22k. So Simple

Test your ICT Knowledge with this self-marking Crossword. Intermediate Version 25k About Average

Test your ICT Knowledge with this self marking Crossword. Advanced Version 24k My Brain Hurts

Link to mcubbin site providing help to support students studying AS ICT. A good site for theory source resources. (Thanks to Jayne for Link)

IT06 Major Project [General] Support Notes 1 91k (pp©)

IT06 Major Project [General] Support Notes 2 151k (pp©)

Database Answers. NEW A well-resourced site for those students requiring help with their Database Projects.
I recommend the section giving many Entity Relationship examples.
Link to excellent site for VBA code junkies. www.excel-vba-access.com Provides code solutions suitable for both AS and A2 Excel and Access projects. (Thanks to Pirthi for Link)
Link to Access Web. Treasure-trove of info on Access.
Happy Computer Manuals. Downloadable user guides to MS applications (Excel for AS Students) (fill in the form to download free manual - amazing site!)
Data Normalisation Class notes. 121k
Link to Advanced ICT in a Nutshell Excellent generic resources. Site name says it all -Nuff Said.
Entity Relationships Class notes. 103k

Link to University of Bradford. A short downloadable guide to using MS Excel. This course is designed to take you from absolute novice to confident journeyman in about 12 hours of study.

Effective Team Development Class Notes. 90k
Link to histman. A superb web site that has much to offer student of AS and A2 ICT. Contains full documentation for an A2 Major Project. Well worth a visit!
Project Management Class Notes 139k
Human Computer Interaction Class Notes 473k
Exam preparation v 4 You will find exam questions from previous A, AS and Computing papers categorised under various headings. 210k.
Human Computer Interface Class Notes 505k
Legal Aspects Class Notes 184k
Payne-Gallway Publishers Ltd The web site for the publishers of the Heathcote textbooks. Contains some useful resources
The Management of Change Class Notes 211k
Webopedia. One of the best online dictionary and search engine for computer and Internet technology.
Management Information Systems Class Notes 87k
Link to VBA TUTOR. Shows how to use VBA [Visual Basic for Applications] with OFFICE 97 applications [Word 97, Excel and Access]. Designed for those who have had no previous computer programming experience.
The Success of Management Information Systems Class Notes 81k
What do Managers do? Class Notes 128k
Happy Computer Manuals. Downloadable user guides to MS applications (Access for A2 Students) (fill in the form to download free manual - amazing site!)
User Support and Training Class Notes 97k
A link to the University of Newcastle's on-line tutorial about designing and creating a relational database.
Link to American Information Components Site about incorporating Visual Basic into Microsoft Access. Good gentle introduction to VBA concepts
     

 

Hosted by www.Geocities.ws

1