Is there any advice on how we should prepare students for the 10-hour supervised working time?
Please refer to the ICE document on the GCE Applied ICT page.
How do we notify Edexcel of our schedule within the window for candidates sitting the exam?
Centres must produce a schedule showing the date and time of each examination session to be held within the window. An examination schedule pro forma for this can be found in the ICE document. This schedule must be submitted in writing to the Compliance and Business Assurance Group at Edexcel, 190 High Holborn, London WC1V 7BH at least three working weeks before the window begins.
The Unit 7 SAMs have three csv files that are then split into five tables in the database in the worked example. The only way that I can think to do this is to import the bookings table into Excel, then split the data up into the four tables (booking, car, session, driver). This is very time-consuming. Is there a more efficient method? I cannot get the table analyser in Access to perform this task.
1. Import them as temporary tables into Access
2. Use append queries to load the relevant data into the tables.
In the 'Instructions for the Conduct of Examinations' (ICE) for Unit 7 - Using database software, it states that candidates are allowed manufacturer's computer manuals. Can these be any Access-specific manuals?
Yes - the idea is that if they do not know how to do something, they can look it up.
We have been working through the database on last year’s exam (as provided online). The design is fine, and we have built the tables and imported the data. Where we are stuck is how to get the database to find the 'rejected records.' Our input masks/ validation rules work when we are manually entering data, but will not eliminate records when we are appending from the main tables into the new tables.
Input masks only work on the input of data and are therefore not classed as a form of validation. To do a format check in Access, the ‘Like’ function has to be used in the validation rule - for example, Like [A-Z][A-Z]### will require two characters followed by three numbers.
That input masks do not work on import is a Microsoft decision. When the SAMs were originally written, input masks did appear to work on import. Because they no longer do, the way we test validation has changed slightly, and the exams will require test data to be input.
Validation rules should work on import, and if they do not then there is something wrong with the version of Access being used.
In the ICE document, it says that there should be a 10:1 student-to-printer ratio. Is this recommended or mandatory?
The 10:1 ratio is a recommendation as to how many candidates would be appropriate for each printer. Having fewer candidates is not a problem. However, having more could slow down the exam and cause queues at the printer.
The length of session for the 6957 exam is ten hours. The ICE document says a minimum of one hour is required per session. Can these be 50-minute sessions, or must it be one hour? Our lessons are 50 minutes long.
A minimum of one hour is recommended to give candidates sufficient time to complete the task. Just keep a record of how long you spend overall, and be sure that each candidate has no less than 10 hours in total time for the exam.
Please refer to the ICE document on the GCE Applied ICT page.
How do we notify Edexcel of our schedule within the window for candidates sitting the exam?
Centres must produce a schedule showing the date and time of each examination session to be held within the window. An examination schedule pro forma for this can be found in the ICE document. This schedule must be submitted in writing to the Compliance and Business Assurance Group at Edexcel, 190 High Holborn, London WC1V 7BH at least three working weeks before the window begins.
The Unit 7 SAMs have three csv files that are then split into five tables in the database in the worked example. The only way that I can think to do this is to import the bookings table into Excel, then split the data up into the four tables (booking, car, session, driver). This is very time-consuming. Is there a more efficient method? I cannot get the table analyser in Access to perform this task.
1. Import them as temporary tables into Access
2. Use append queries to load the relevant data into the tables.
In the 'Instructions for the Conduct of Examinations' (ICE) for Unit 7 - Using database software, it states that candidates are allowed manufacturer's computer manuals. Can these be any Access-specific manuals?
Yes - the idea is that if they do not know how to do something, they can look it up.
We have been working through the database on last year’s exam (as provided online). The design is fine, and we have built the tables and imported the data. Where we are stuck is how to get the database to find the 'rejected records.' Our input masks/ validation rules work when we are manually entering data, but will not eliminate records when we are appending from the main tables into the new tables.
Input masks only work on the input of data and are therefore not classed as a form of validation. To do a format check in Access, the ‘Like’ function has to be used in the validation rule - for example, Like [A-Z][A-Z]### will require two characters followed by three numbers.
That input masks do not work on import is a Microsoft decision. When the SAMs were originally written, input masks did appear to work on import. Because they no longer do, the way we test validation has changed slightly, and the exams will require test data to be input.
Validation rules should work on import, and if they do not then there is something wrong with the version of Access being used.
In the ICE document, it says that there should be a 10:1 student-to-printer ratio. Is this recommended or mandatory?
The 10:1 ratio is a recommendation as to how many candidates would be appropriate for each printer. Having fewer candidates is not a problem. However, having more could slow down the exam and cause queues at the printer.
The length of session for the 6957 exam is ten hours. The ICE document says a minimum of one hour is required per session. Can these be 50-minute sessions, or must it be one hour? Our lessons are 50 minutes long.
A minimum of one hour is recommended to give candidates sufficient time to complete the task. Just keep a record of how long you spend overall, and be sure that each candidate has no less than 10 hours in total time for the exam.
No comments:
Post a Comment