< Back to A Level ICT
G062 Task 3 Spreadsheet 2011-2012. Queues carrying over to next hour?
Task 3 P8 Part B : "There is an assumption that visitors queuing will wait as long as necessary to access an attraction"
If queues rollover to the next hour and so on...can it be clarified how we work out the allocation of visitors across all attractions in subsequent hours once the 1st queue develops?
Or do we reset after each hour and use the % age of total visitors in the park for each attraction for each hour as given in table 3.1?
Many thanks in advance.
- 14625 views
- 7 replies
Share
Replies
although i think doing it on top of the initial formula consisting of roundup, multiplication and subtraction may be extreme, but i have no idea whether there's a function or formula that might do a cumulative value...
Doing it either way is not a problem (or there are several other possibilities I can think of), what's required is full clarification of what OCR expects to happen once the 1st queue develops. If queues are rolled over for as long as it takes, one possible method could be : Total all people queuing at the end of the hour in question, subtract this value from the total visitors on the park for the next hour, then allocate the remaining visitors across all attractions as per the % in 3.1, adding on each outstanding queue to each attraction as required...and so on for each hour. However, without some guideance, its difficult to understand the correct method, which could produce answers not allowed for on the mark scheme.
Doing it either way is not a problem (or there are several other possibilities I can think of), what's required is full clarification of what OCR expects to happen once the 1st queue develops. ...
Doing it either way is not a problem (or there are several other possibilities I can think of), what's required is full clarification of what OCR expects to happen once the 1st queue develops. If queues are rolled over for as long as it takes, one possible method could be : Total all people queuing at the end of the hour in question, subtract this value from the total visitors on the park for the next hour, then allocate the remaining visitors across all attractions as per the % in 3.1, adding on each outstanding queue to each attraction as required...and so on for each hour. However, without some guideance, its difficult to understand the correct method, which could produce answers not allowed for on the mark scheme.
OCR have produced FAQs that can be found here http://www.ocr.org.uk/download/prm/ocr_51765_prm_gce_faq.pdf
Questions 5 and 6 under Task 3 should clarify these issues.
Thanks
Karen
Thanks for the FAQ’s; unfortunately they don't answer my questions.
In the FAQ's : "The number of visitor using the ride between 10am and 11am is 10% of 1200"...surely this is incorrect?
It would in fact be 10% of 1200-50 (50 is the people still queuing at Ghost Train). In effect 1150 would be the total number of visitors free to go to other attractions who weren't already in a queue (Ghost Train). In other words the total visitors on the park that hour – the total already queuing.
Applying the logic you’ve given in the example across all attractions would result in 100% allocation of all visitors in the park across all rides + additional (incorrect) visitors on all the rides with roll over queues, equal to the total number queuing across all rides at the end of the last hour. So you would have more people on the park than is possible.
If additional wording said something like “Percentage of visitors on the park free to go to the next attraction i.e. those not already queuing”, it would make much more sense.
Please could you clarify?
what is the formula for working out the visitor queue? anyone please.
It has been answered above within the FAQ. I was stuck but now I have a clearer idea as to what is required. The only issue I have is that my answers do not tally with what was shown in the 2011 training course in Manchester