Work for Mr. Jones - Friday 24 March

Year 12

You may either continue work on spreadsheets, such as finishing off any work Mrs Lunn has set or using the Thomas Telford materials to improve your spreadsheet skills

or complete the database assignment documentation needed for Unit 2 . The completed e-portfolio needs to be handed in to me on Friday 7 April, 2006.

All work must be available to copy to the school network from your laptop, pendrive or a CD. There are no excuses for hardware or system failures.

Year 13

The April 7th deadline is looming ever closer. On this day you must be able to give me a full copy of your documentation and website. Continue with this work today, but remember that the testing, feedback and evaluation sections are every bit as importnat as the website itself.

All work must be available to copy to the school network from your laptop, pendrive or a CD. There are no excuses for hardware or system failures.

U6 AVCE ICT Website Management Deadline

The FINAL deadline for the Upper 6 AVCE ICT Website Management Unit is Friday 7 April 2006. The work to be handed in includes a fully working website on CDR or copied to the 6th form shared area on the school network and full documentation including analysis, design, implementation, testing, and evaluation. The documentation will include screenshots and a User Guide all presented in a bound folder. Full details are in the syllabus and mark scheme available through this blog.

No excuses, if it's not handed in on or before April 7th, it won't get marked.

Mr. M.P.Jones
Head of IT

Mr Jones - Year 12 GCE Applied ICT - Monday 6 March

Refer back to my work set for last lesson (Friday)

'Make a copy of the csv datafile from the 6th Form folder in the shared documents area. Load this into Excel to analyse the fieldnames and data structures present. Then decide on two or more table names for your database and create appropriate fieldnames, datatypes, field lengths, data formats and validation rules for each field. Finally, import the relevant data from the datafile into each table and make a relationship between each of your tables.'

This work is to be completed by Monday 6 March 2006. If this part has been finished, use the example weblink shown below to get some idea about how you will create and use this database to meet the requirements for the project:

http://www1.edexcel.org.uk/gceict-eportfolio2/DataBase.htm

6th form work for Mr. Jones on Friday 3rd March

Day: Friday
Date: 3 March 2006

Period 1 - Year 12 GCE Applied ICT
As specified in Mr Slater's Wednesday's lesson, make a copy of the csv datafile from the 6th Form folder in the shared documents area. Load this into Excel to analyse the fieldnames and data structures present. Then decide on two or more table names for your database and create appropriate fieldnames, datatypes, field lengths, data formats and validation rules for each field. Finally, import the relevant data from the datafile into each table and make a suitable relationship between each of your tables. You may need to add extra field(s) to make the relationships.

This work is to be done by Monday 6 March 2006. More work will be given here on Monday.

Period 3 - Year 13 AVCE ICT
Continue work on your website documentation, using the syllabus and mark scheme provided on this blog for help.

L6 Applied GCE ICT - Mr. Jones - Database project

Following the recent publication of a datafile (the 'given set of data') on the new Edxecel GCE site, I am revising the nature of the work we are currently doing. This csv format datafile is called Unit 2 CD Orders and it is in the 6th form folder in the shared area.

You must get a copy of this csv file and import it into a database structure that you have set up with validation. You will need to examine the structure of the data (it is a csv file and can be viewed in Excel) in the file before you create your structure and import it.

All the data is in a single file, and so it will need to be split into two or more tables to create a relational database - so only some of the data will be imported into each table. You may also need to create some extra fields to make the database relational.

The links to the website and example projects have been added to the menu on the right of this screen. You are strongly advised to visit the new website in order to appreciate what is required for this project. In particular, have a look at the example student portfolio for this unit - yours will be very similar but hopefully much better!

Here is an extract of the Mark Band 3 (the highest) criteria from the syllabus to help you understand what needs to be done:

You, the learner
• creates a database structure that is customised to take account of the characteristics of the given set of data and includes some data validation
• carries out extensive testing to ensure that the database functions correctly and efficiently
• imports the data into the database
• uses the facilities of the software to extract valid and meaningful information and identify some significant trends, interpreting output and making recommendations based on it.

The leaner fully evaluates
• the performance of the database
• their own performance, incorporating feedback from others and makes realistic recommendations for improvements.

More details will follow as is necessary. I will be absent from school on Friday and Monday next, and so details of the work to be done in my lessons will be posted here.