Teaching materials

About these teaching resources

All the files on this page have been supplied by members of the A Level ICT Network. They are offered for downloading either as simple files or as 16 bit self-extracting zip files. Many thanks to all of you who have sent contributions. All materials are offered on a freeshare basis. Edexcel materials Visual Basic tutorials Student learning materials Coursework support

Edexcel materials

Coursework Guide Support from Edexcel for all the coursework tasks. Sample coursework and marking schemes Available from Edexcel.

AS Learning Tasks These invaluable tasks and questions were developed by Brian Jackson and Sue Taylor for the pilot course. They have now been restructured to match Units 1 and 2 in the new specification. Contains essential resource kits for : 1. Systems Administration 2. The Generation of Applications Student version and separate solutions included for each unit. Format : Word97 141k zipped file unzipping to 4 files, totalling 627k Download the file here : learning.exe

Visual Basic Tutorials

Visual Basic for Windows 2000 Introduction to Visual Basic with ADO Contributed by Sue Taylor, Havering Sixth Form College Format : Access 2000 62k zipped file unzipping to 6 files, totalling 390k Download the file here : bank.exe Learning Visual Basic Introduction to Visual Basic data controls for Access 7 (using same scenario as the previous item) Contributed by Sue Taylor, Havering Sixth Form College Format : Word97 63k zipped file unzipping to 6 files, totalling 244k Download the file here : vbdata.exe

Student learning materials

Software Introduction to a wide range of software types Contributed by Sue Taylor, Havering Sixth Form College Format : Word97 29k file Download the file here : software.doc AS Technical knowledge Teaching notes for sections 1.1, 1.2, 1.3 of the pilot (which correspond to T 1.1, T 1.2 and T 2.1 in the new specification) Contributed by Sue Taylor, Havering Sixth Form College Format : Word97 161k zipped file unzipping to 6 files, totalling 677k Download the file here : astechk.exe Systems administration Teaching notes for sections 2.1 to 2.8 of the pilot (which correspond roughly to LO 1.1 to LO 1.7 in the new specification) Contributed by Sue Taylor, Havering Sixth Form College Format : Word97 91k zipped file unzipping to 10 files, totalling 303k Download the file here : sysadmin.exe Learning Access Extensive self-teaching materials for learning Access, with full teacher and student notes - includes a large Access database with built in active lessons Contributed by Andy Statham, Island School, Hong Kong Format : Word97 and Access 7 688k zipped file unzipping to 3 files, totalling 2683k Download the file here : getrich.exe

Coursework support

Project guidelines Designed for Unit 6 in the AQA specification, but with lots of useful advice that can be adapted for Edexcel's Unit 3 in particular. Contributed by Paul Burgess, Wilmslow High School Format : Word2000 77k zipped file unzipping to 223k Download the file here : ict6.exe AS Coursework Guidelines for Tasks 1 and 2 in the pilot. (Note that the coursework requirements are unchanged in the new specification, except that Task 1 becomes Task 2 and vice versa) Contributed by Havering, Yale and Kingston Colleges. The Kingston and Havering guidelines are suitable for projects developed in Access. The Yale guidelines (based on the Kingston model) are designed for projects in Excel; Yale also supplies some detailed Excel project ideas, partly derived from Heathcote. Format : Word97 170k zipped file unzipping to 6 files, totalling 573k Download the file here : coursewk.exe AS Coursework assessment sheets Assessment grids for Tasks 1 and 2. Contributed by Jacqueline Woodgate, The Ridgeway School Format : Excel 30k zipped file unzipping to 2 files, totalling 45k Download the files here : taskassess.exe A2 Coursework Guidelines for Tasks 3 and 4 in the pilot. (Note that the coursework requirements are unchanged in the new specification, except that Task 3 becomes Task 4 and vice versa) Contributed by Kingston College. Format : Word97 37k zipped file unzipping to 2 files, totalling 77k Download the file here : coursewk2.exe Practical case study Case study, which has been used as a specification for Task 2. (This has already been used by a number of centres on the pilot so we suggest you use it as an exemplar rather than as a student-ready scenario.) Contributed by Mary Reid, Kingston College Format : Word97 and Publisher97 387k zipped file unzipping to 3 files, totalling 609k Download the file here : keiss.exe