x Turn on thread page Beta
 You are Here: Home

# Edexcel Applied ICT Unit 3 June 2013 watch

• View Poll Results: How ready are you for the exam?
Awesome, gonna kill it
4
11.76%
Great
2
5.88%
Ok
7
20.59%
Satisfied
4
11.76%
Help me!!
6
17.65%
11
32.35%

1. (Original post by ak96)
Hi guys, I have my exam tomorrow but last minute panic has set in.

On Stage Builder sheet, in cells I12:N12, there is a dropwdown that appears saying 'Normal' and 'Length'. Does anyone know how these are meant to be used? Or what do they mean?

In the formulas that my teacher gave us to use these cells, she said to use =countif(I12:N12,"Climb") to be used in cell I17 and a similar one in I19, but they basically seem useless.

Any ideas? Thanks in advance!!
The criteria is as follows

climb - EITHER cat 1 and a cat 2 climb OR just a cat 1 climb
sprint - under 5% average (values can't go over 5%)

Assuming all your other formulas are correct, meaning the climbs are calculating correctly, all that's happening is you haven't got a climb or a sprint stage for that stage, therefore normal is the one to select.
2. (Original post by Taz1838)
The criteria is as follows

climb - EITHER cat 1 and a cat 2 climb OR just a cat 1 climb
sprint - under 5% average (values can't go over 5%)

Assuming all your other formulas are correct, meaning the climbs are calculating correctly, all that's happening is you haven't got a climb or a sprint stage for that stage, therefore normal is the one to select.
What u said is correct apart from one thing:
a climb is either A cat1 and A cat ORRR 2 Cat 1 climbs
3. Not just a cat1 climb
4. (Original post by the math freak)
What u said is correct apart from one thing:
a climb is either A cat1 and A cat ORRR 2 Cat 1 climbs
Ahh!! Looks like I'll have to look back at my formulas...
5. Looks like the second formula is wrong if teachers are telling to make it =2. That doesn't test that there can be either cat1 and cat 2 or 2 cat2's
6. does anyone have any improvements or faults that we could use in task 2 if they ask for them?
7. Wait, in cells I8:N8 I'm confused as to what the criteria is, is it Two cat 1 climbs or two cat 2 climbs? Or, is it two cat1 climbs or one cat2 climb?
8. (Original post by pessimist)
Wait, in cells I8:N8 I'm confused as to what the criteria is, is it Two cat 1 climbs or two cat 2 climbs? Or, is it two cat1 climbs or one cat2 climb?
It means 2 cat 1 climbs or 2 cat 2 climbs
9. (Original post by theo3335796)
It means 2 cat 1 climbs or 2 cat 2 climbs
thanks, would +rep you but, I'm out for today
10. (Original post by theo3335796)
It means 2 cat 1 climbs or 2 cat 2 climbs
If you read the scenario it clear states either 1 cat 1 or cat 1 and a cat 2. Ignore the spreadsheet if it contradicts the scenario. There doesn't need to be 2 cat 1's so why would it ask that?
11. (Original post by Taz1838)
If you read the scenario it clear states either 1 cat 1 or cat 1 and a cat 2. Ignore the spreadsheet if it contradicts the scenario. There doesn't need to be 2 cat 1's so why would it ask that?

The scenario states either two cat 1's or a cat 1 and a cat 2 actually, and I don't know why it would ask it but it's their fault for wording it stupidly

12. On the spread sheet it is saying 2 cat1 or cat 2. Meaning 2 cat 1 and a cat 2 I.e 1 cat 2
hope this helps
13. (Original post by MPharm 123)
On the spread sheet it is saying 2 cat1 or cat 2. Meaning 2 cat 1 and a cat 2 I.e 1 cat 2
hope this helps
So is this formula correct?

=IF(OR('Climb Calculation'!J52=2,'Climb Calculation'!J53>=1),"Yes","No")
14. (Original post by theo3335796)
So is this formula correct?

=IF(OR('Climb Calculation'!J52=2,'Climb Calculation'!J53>=1),"Yes","No")
I used an and or instead
15. can someone please tell me a few recommendation for activity 2.
16. Anyone know what data to use when creating a graph?
17. (Original post by theo3335796)
So is this formula correct?

=IF(OR('Climb Calculation'!J52=2,'Climb Calculation'!J53>=1),"Yes","No")
It's not an IFOR formula. It's an ordinary IF Formula because the spreadsheet can't differentiate between cat1 and cat2 climbs. Ie cat 2 climbs include cat1. But check this on the actual one in the exam
18. the spread sheet consist of IF functions and COUNTIF functions also plus an unseen formula that is a surprise on he examination
19. (Original post by MPharm 123)
It's not an IFOR formula. It's an ordinary IF Formula because the spreadsheet can't differentiate between cat1 and cat2 climbs. Ie cat 2 climbs include cat1. But check this on the actual one in the exam
So what is the correct formula using a regular if statement?
20. (Original post by Jayqwe)
Anyone know what data to use when creating a graph?
I would like to know this also

Turn on thread page Beta
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: January 7, 2014
Today on TSR

### Is uni even worth it?

Does anyone use their degree?

Poll
Useful resources

## Make your revision easier

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