Education, Education, Education
As a trainee teacher, at the moment, I have a few files that may be of interest to students. When I become a qualified teacher of IT/Computing and am teaching regularly, this page will increase in size and content.
The material on this webpage is for the Access/IPS course at Walsall College of Arts and Technology. The topics covered iclude E-R modelling and Data Flow Diagrams. If you are not a student of this course, I have no problem with you downloading this stuff, as a teacher it is my job to help others learn, whether they are in the classroom or not. How pretentious is that?!
Anyway, click on the links below to view the material:
| A Data Flow Diagram Exercise | Microsoft Word Document | An exercise to practice using the SSADM method of Data Flow diagrams. The solution is available on this site, just below. | |
| DFD Solution | Microsoft Word Document | The answers! Or, at least, I hope so! This is what I came up with, but you may go into more detail, as long as you understand the diagram when you next look at it! | |
| E-R modelling | Microsoft PowerPoint Presentation | A set of slides giving a brief introduction to databses, their uses and E-R modelling. Also includes a quick practice of E-R diagrams. | |
| E-R Exercise | Microsoft Word Document | An exercise to practice E-R modelling, the solution is also avaliable | |
| E-R Solution | Microsoft Word Document | The Solution, or my version of it anyway! This is whatI came up with when I had a go at the exercise" | |
| Keys and Link tables | Microsoft PowerPoint Presentation | The Notes for the lesson on Keys and link tables | |
| NEW!Another DFD Exercise | Microsoft Word Document | Another DFD Exercise, have a look at this if you want some more practice! | |
| Interface Design | Microsoft PowerPoint Presentation | The Notes for the lesson on Interface Design | |
| Testing Notes | MicrosoftPowerPoint Presentation | The Notes for the lesson on Testing | |
| The sample Database | Microsoft Access Database | A sample database for testing | |
| Design Doc for Sample Database | Microsoft Word Document | The Design document for the sample database |
That's all for the moment, more will be added as and when required