You are Here: Home

# AS OCR Applied ICT PRE-RELEASE watch

1. This is all of the Pre-Release data, this can be found on the OCR website however I thought i'd post here to provide some for you all! This is the Data, Pre release scenario and the practice spreadsheet that we have been provided from OCR themselves.

Have a lot of fun with this Pre-Release data and I wish everyone good luck for the exam this summer! I will be taking the exam my very self so I hope it is all a good exam!!
Attached Images
2. PreRelease W46574A GCE APPLIED ICT 6953 June 2016.pdf (226.4 KB, 224 views)
3. Attached Files
4. july_tides_practice.txt (2.9 KB, 88 views)
5. LML_practice.xlsx (235.6 KB, 123 views)
6. Do you have any idea of the formulas needed for the spreadsheet? - my teachers and all the students have been struggling to work it all out. If you do, can you please send me them
Thanks
7. Sure! Basically the data has to be inserted into the large area of the spreadsheet (as usual) then you go on over to the selection worksheet. Here on the right you see lots of pink. In the visits, it will be a count if, the statistic tide start is a vlookup of the tide start and end on the same sheet. For example the first one for tide start is: =VLOOKUP(H14,'Data'!A12:O20,9,FA LSE) (You may wanna cell reference st some point) if you tell that to your teacher, you will probably set their mind going. However if not, I will be able to go into more depth when home from college tonight
8. You're a lifesaver, we are still struggling as there seems to be an error with the vlookup which we are doing, would you please go into more detail just so I can test this out and hand the spreadsheet to my teacher (as well as your information)

Thank you
9. Also, one quick question, if the tide start and end on the selection sheet is sheet referenced to the data worksheet, why would we need a vlookup sheet reference to the data sheet? I have used this formula and have come up with the same answer =vlookup (H14,\$A\$14E\$19,4,FALSE)
10. How about we create a whatsapp group..it will be easy to communicate
People who wants to be in the group..send their numbers plz😂👍🏿
11. Okay sorry or this late reply. Attached I have provided my current spreadsheet that I have completed for the pre-release. You will notice that for the depth in/out and clearance in/out I have entered <= and >=. This is because if you look in the scenario you will notice that for each attraction (or most) there will be a depth limitation and height limitation. For seal flats the sea level must be below 3.8m. If you look in the sights worksheet you will notice the heights each attraction has. The depth will be the lower number and the clearance will be the higher number. Take a little look of this spreadsheet I am providing here and it will show you what I mean. For reference, we have also found that the worksheet has been purposely jeopardised to ensure that you are unable to get the correct solution, meaning that you will have to find it during the exam.
That's just a little bit of help for you!
Enjoy!
Anything else I will be available until Tuesday, then from Thursday to Monday and then I will be available Wednesday because I exam for IT is on the Thursday.
Attached Files
12. LML_practice.xlsx (243.8 KB, 101 views)

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: May 10, 2016
Today on TSR

### Life lessons uni will teach you

Questionable decision-making and constant surprises

### University open days

1. Loughborough University
Fri, 21 Sep '18
2. University of Cambridge
Fri, 21 Sep '18
3. Richmond, The American International University in London
Fri, 21 Sep '18
Poll
Useful resources

Can you help? Study Help unanswered threadsStudy Help rules and posting guidelines

## Groups associated with this forum:

View associated groups

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE