Autumn 1: Consider changing your password - is it secure? Clear your workarea (P Drive), but keep your best 2 example of work for every program used.
Autumn 2: Introduction to processing Lists (What lists can you think of Shopping, Address, CDs, Mammals....) What lists do you know of on the Internet?
Using a Form in Access to Search... Read How to then download the Questions(1) and databases Cars Cds Holidays Castles to your Documents (P Drive) When these databases are started you must change the security warning > Options to "enable this content". Attempt as many questions as you can. Now try these additional Questions(2).
^Now watch the Access 2007 (1a) lessons that cover creating a Query and copying to Word in Access...
Create your own queries for all of the Questions (2) above.
^Watch the next 2 lessons. You can now download a third set of Questions(3), you will need these extra databases ClothesHire Placenames Cities Food and Weather to there is also a How to file for you to read.
There are numerous uses for (relational) databases in real life whether on the Internet (Tesco / ebay / Amazon / Maplin / Ebuyer) or not (Payroll, Stock Control, Air Traffic Control, Timetables). Make a list of any databases that use "lists" on the Internet. Social networking sites are essentially a series of databases with a website as the "front end"!
Excel
& Access - why both programs? Well they both enable us in varying ways to process Information in a System like way, though Access has a far greater range of useful tools, whilst Excel is used by less experienced users.
The First Assessment will be based on all of the Access work with problems similar to Questions 3, that is queries, totalling queries and export to Excel for the creation of bar charts. You will need to download the Assessment Questions and the database during the Assessment only! You may watch the lessons or read the files during the assessment though this will be at the expensive of time!
Autumn 3: Website design work ie Dreamweaver / Flash / Photoshop / Premiere Pro / Movie Maker / Soundbooth / Audition.
1. Preparation Planning a project Components and Learning Dreamweaver.
*** Whilst technical problems with Dreamweaver CS5 are resolved you can create 4 jpg's and store them in P:\MyWeb They should be called top (1000x100), bottom (1000x100), left (200x600), right (200,600) and can be viewed in ie with a green framework page. ***
Watch each lesson in Dreamweaver1, attempt to build the webpage exactly as shown. Near to the end it should now look like this!
Now create a website of your own choice. Place it in a seperate folder. The First file must be called index.html < all in lower case! This will then be uploaded.... See others below! |
