This discussion is now closed.
Check out other Related discussions
- IAL repeats cash in.
- How many GCSEs are you getting?
- edexcel IGCSE qualifications
- How to Prepare for Level 3 Applied Science?
- GCSE Exam Discussions 2024
- 24th January 2022 BTEC IT Level 3 Unit 1 (Information Technology Systems)
- A-level Exam Discussions 2024
- Switching from A level to IAL
- Getting an A* in IAL edexcel
- Edexcel AS level unit-1 and unit-2 business notes
- A-level Economics Study Group 2022-2023
- AQA Environmental Studies AS Level Revision Notes Here
- Economic's AS + A2 Notes (ALL BOARDS)
- Help Edexcel IAL Cash in
- Help Edexcel IAL Cash in.
- maths question help
- Edexcel IAL results
- How does UAL grade?
- Warwick University vs Bristol University Scholarships
- Predict Your gcse Grades!
A2 Applied ICT Edexcel Unit 7 Summer 2014
Scroll to see replies
The teacher and myself feel that we have cracked this scenario and that we have linked it to a scenario which has been previously used by the exam board. They are of a very similar nature and this link would be logical.
4 tables - Student
Performance
Productions
Characters
This will give the Primary Keys of Performance ID - Student ID and Character ID.
We are also expecting a duplication somewhere (which will mean an append query is to be used) but we haven't figrued out where yet.
What do you think??
4 tables - Student
Performance
Productions
Characters
This will give the Primary Keys of Performance ID - Student ID and Character ID.
We are also expecting a duplication somewhere (which will mean an append query is to be used) but we haven't figrued out where yet.
What do you think??
Hi, we're trying to figure out possible data but we're having problems with macros and formulas that could turn up and how they work- anyone got any advice? Also how is everyone revising for this exam? 
Original post by BinaSchmidt
Hi, we're trying to figure out possible data but we're having problems with macros and formulas that could turn up and how they work- anyone got any advice? Also how is everyone revising for this exam?
With Great Difficulty!
As well as the tables, does anyone have any ideas about the forms that we are going to have to make? By the looks of the scenario it seems as though we only need to make two forms. Although the allocation form seems extremely complicated and that it will have a lot of elements on it. Has anyone had any thoughts about the forms?
Original post by joshhpalmer
As well as the tables, does anyone have any ideas about the forms that we are going to have to make? By the looks of the scenario it seems as though we only need to make two forms. Although the allocation form seems extremely complicated and that it will have a lot of elements on it. Has anyone had any thoughts about the forms?
I have been looking intently on this and I have thought of a couple however they are loose and would not really work entirely.
It will involve some sort of embedded table inside a form which will contain the student and their details - I just need to figure out how to get this too work. If I crack it then I'll let you know.
Original post by hartb
I have been looking intently on this and I have thought of a couple however they are loose and would not really work entirely.
It will involve some sort of embedded table inside a form which will contain the student and their details - I just need to figure out how to get this too work. If I crack it then I'll let you know.
It will involve some sort of embedded table inside a form which will contain the student and their details - I just need to figure out how to get this too work. If I crack it then I'll let you know.
Perhaps you are thinking of a subform? When you add it to your master form, you can configure the subform to retrieve fields from the Students table.
I agree with the subform. It almost seems that you have to select a student and a production job and depending on what is chosen (actor or production role) then the sub form will change accordingly. But that seems like so much work to do aha!
Original post by shaanlone
Anyone got any ideas of what data we might get?
As well as the tables discussed that will be coming up- I'm thinking some sort of payment data may well turn up..seeing as performances take place at different times in the year- they may sell tickets for the performance? Maybe a payment type of selling tickets could turn up? What do you guys think?
Hard to say! I personally think that the students and whether they are an 'a-level' student or just doing the performances for 'fun' may also come up in the questions. I doubt they would have put that in the scenario for no reason, perhaps it may be used to validation later on so maybe only A-Level students can take title roles
Posted from TSR Mobile
Posted from TSR Mobile
Help me on as ict
Original post by hartb
The teacher and myself feel that we have cracked this scenario and that we have linked it to a scenario which has been previously used by the exam board. They are of a very similar nature and this link would be logical.
4 tables - Student
Performance
Productions
Characters
This will give the Primary Keys of Performance ID - Student ID and Character ID.
We are also expecting a duplication somewhere (which will mean an append query is to be used) but we haven't figrued out where yet.
What do you think??
4 tables - Student
Performance
Productions
Characters
This will give the Primary Keys of Performance ID - Student ID and Character ID.
We are also expecting a duplication somewhere (which will mean an append query is to be used) but we haven't figrued out where yet.
What do you think??
Which years scenario did you find links to this years scenario?
Original post by sophiesmart
Which years scenario did you find links to this years scenario?
Hey which scenario did you find that links to it?
Those of you who don't have the scenario here is the link (thank me later): http://www.ais.lk/wp-content/uploads/2013/10/June-2014-U7-Pre-Release.pdf
: http://www.ais.lk/wp-content/uploads/2013/10/June-2014-U7-Pre-Release.pdfHow exactly is everyone going to revise for this exam, a part from guessing what the tables are because since we haven't got the data. Unless your ict teacher has created a prototype already ?
Has anyone got any good tutorials in regards to the tasks they're going to give us in the exam?
Thank you in advance x
Has anyone got any good tutorials in regards to the tasks they're going to give us in the exam?
Thank you in advance x
Hi all, I have the following tables for this scenario
Production, Student, Characters, CrewJobs
Production contains details of each production including number of characters (actors needed)
Student table will have name, ID, gender, preferred job
Characters will have a foreign key to Production and Student with detail of that character
CrewJobs will also have a foreign key to Production and Student.
I think these should cover it
Production, Student, Characters, CrewJobs
Production contains details of each production including number of characters (actors needed)
Student table will have name, ID, gender, preferred job
Characters will have a foreign key to Production and Student with detail of that character
CrewJobs will also have a foreign key to Production and Student.
I think these should cover it
Original post by 012858
Those of you who don't have the scenario here is the link (thank me later): http://www.ais.lk/wp-content/uploads/2013/10/June-2014-U7-Pre-Release.pdf
: http://www.ais.lk/wp-content/uploads/2013/10/June-2014-U7-Pre-Release.pdfHii, would you be able to message me the pre release spreadsheet and notepad documents pleasee? My school hasnt provided them to us yet! Thanks
Apparently they get released to colleges this Saturday so they can get the exam computers ready but someone in my class said that the text files have leaked online before prior to the exam so keep your eyes out! haha
Posted from TSR Mobile
Posted from TSR Mobile
Related discussions
- IAL repeats cash in.
- How many GCSEs are you getting?
- edexcel IGCSE qualifications
- How to Prepare for Level 3 Applied Science?
- GCSE Exam Discussions 2024
- 24th January 2022 BTEC IT Level 3 Unit 1 (Information Technology Systems)
- A-level Exam Discussions 2024
- Switching from A level to IAL
- Getting an A* in IAL edexcel
- Edexcel AS level unit-1 and unit-2 business notes
- A-level Economics Study Group 2022-2023
- AQA Environmental Studies AS Level Revision Notes Here
- Economic's AS + A2 Notes (ALL BOARDS)
- Help Edexcel IAL Cash in
- Help Edexcel IAL Cash in.
- maths question help
- Edexcel IAL results
- How does UAL grade?
- Warwick University vs Bristol University Scholarships
- Predict Your gcse Grades!
Latest
Trending
Last reply 1 day ago
Edexcel A Level Politics Paper 1 (9PL0 01) - 21st May 2024 [Exam Chat]A-levels
10
Trending
Last reply 1 day ago
Edexcel A Level Politics Paper 1 (9PL0 01) - 21st May 2024 [Exam Chat]A-levels
10
