Applied ICT 9713- May/June 2012 Series

[madara uchia]

plz in may/june 2012 paper 2 in quetion 9 for IF function why we should divide it by 400 and for qustion 11 how to calculate the number of drivers i saw the markscheme but i didnt understand it

 

[yash patel]

plz in may/june 2012 paper 2 in quetion 9 for IF function why we should divide it by 400 and for qustion 11 how to calculate the number of drivers i saw the markscheme but i didnt understand it

okay. In question 9
you divide by 400 since in the question it says 1 truck for every 400 seats. so we have the capacity. so to calculate we divide the capacity by 400 since it says "1 truck for every 400 seats'' and the question is asking us to find the amount of trucks required. also we use the roundup function when determining this.

for question 11
okay in this question you have to find the amount of drivers. so first of all you calculate how many drivers will be required for 1 truck during the trip.
since it says that a driver can only drive for 5 hours we convert that into minutes since our driving time we calculated was also in minutes.

so to do that we use the equation round(1+i2/300)
* 1 - it stand for 1 truck
*i2 - driving time
*300 - capacity of driving time for 1 driver in minutes.

this equation will give us the amound of drivers required for 1 truck.
now just muliply this by G2 which is the amount of trucks required.
thus we get the amount of drivers required in total.

 

[AAnsarii]

plz..in may/june 2012 paper 2 in question 9 for the IF function why we should divide by 400 and qustion 9 can u explain how to calculate the number of drivers i saw the mark scheme and i didnt understand it

9. "1 truck for every 400 seats". eg. if i ask u: hw many 2's r dere in 10? u'll say: 5. n hw did u get dat? 10/5. so if u wanna find hw many 400's r dere in a cell, u'll divide by 400.
11. "each driver cn only drive for 5 hrs" n d Driving tym is in mins, so u'll put {time in mins}/{5*60}. nw u get hw many drivers r 2 b present. bt u get it in decimals, eg 1.099, n d driver can drive 4 no more dan 5 hrs, so u +1 driver (n xtra driver 4 d decimal pts). wt will cm now? 2.099. u dnt want dat, so u 4mat it as integer.

hope it helped, by Allah's Will. May He help us all. aameen

 

[syed1995]

http://papers.xtremepapers.com/CIE/...unication Technology (9713)/9713_s08_qp_2.pdf

Question No. 25 Please.

 

[AAnsarii]

http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s08_qp_2.pdf
Question No. 25 Please.

"count the number of buses that are.." <--Count wid a criteria is countif. "5 or more mins late"<--criteria

 

[syed1995]

"count the number of buses that are.." <--Count wid a criteria is countif. "5 or more mins late"<--criteria

How ? what would be the formulae.. I counted the buses with route 1, route 2 fine with " =COUNTIF(J8BUS!$F$6:$F$131,"1") " .. but getting stuck in this one.

 

[ZAYYYY]

Use the formula: =COUNTIF(J8BUS!$E$6:$E$14,">=5")
As the route column in J8BUS is sorted in ascending order, all you need to do is just select the cell range for each route separately.

 

[syed1995]

Use the formula: =COUNTIF(J8BUS!$E$6:$E$14,">=5")
As the route column in J8BUS is sorted in ascending order, all you need to do is just select the cell range for each route separately.

JazakAllah

 

[syed1995]

Use the formula: =COUNTIF(J8BUS!$E$6:$E$14,">=5")
As the route column in J8BUS is sorted in ascending order, all you need to do is just select the cell range for each route separately.

Isn't there a more concrete way? there must be .. cuz I mean the routes might change in the future..

 

[AAnsarii]

How ? what would be the formulae.. I counted the buses with route 1, route 2 fine with " =COUNTIF(J8BUS!$F$6:$F$131,"1") " .. but getting stuck in this one.

c: u sorted d data in2 route order, so u do =Countif(J8BUS.xls!$E$6:$E$14,">5") this coz u need 2 count d no. of minutes late and this coz u need 2 count d no. of buses dat wr more dan 5 mins late
did u get it?

 

[syed1995]

c: u sorted d data in2 route order, so u do =Countif(J8BUS.xls!$E$6:$E$14,">5") this coz u need 2 count d no. of minutes late and this coz u need 2 count d no. of buses dat wr more dan 5 mins late
did u get it?

Yea I got it .. Thanks it's kinda lengthy though.

 

[AAnsarii]

Yea I got it .. Thanks it's kinda lengthy though.

sm things r lengthier... though, yes

 

[syed1995]

Use the formula: =COUNTIF(J8BUS!$E$6:$E$14,">=5")
As the route column in J8BUS is sorted in ascending order, all you need to do is just select the cell range for each route separately.

sm things r lengthier... though, yes

I found a even better and easier way for this! I was just going through the functions and found a countifs function!

It accepts =COUNIFS(Range1,Criteria1,Range2,Criteria2,Range3..... and so on )


=COUNTIFS(J8BUS!$E$6:$E$131,">=5",J8BUS!$F$6:$F$131, "1")
=COUNTIFS(J8BUS!$E$6:$E$131,">=5",J8BUS!$F$6:$F$131, "2")
=COUNTIFS(J8BUS!$E$6:$E$131,">=5",J8BUS!$F$6:$F$131, "3")

and so on .. and getting the right answer

Cheers

 

[syed1995]

http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s08_qp_2.pdf

This is how my data looks like currently:

Question No 32-33 .. Please explain it as well .. what kind of graph will I choose? and what cell range will I choose?

Thanks in advance for the help!

 

[ZAYYYY]

Y

I found a even better and easier way for this! I was just going through the functions and found a countifs function!

It accepts =COUNIFS(Range1,Criteria1,Range2,Criteria2,Range3..... and so on )


=COUNTIFS(J8BUS!$E$6:$E$131,">=5",J8BUS!$F$6:$F$131, "1")
=COUNTIFS(J8BUS!$E$6:$E$131,">=5",J8BUS!$F$6:$F$131, "2")
=COUNTIFS(J8BUS!$E$6:$E$131,">=5",J8BUS!$F$6:$F$131, "3")

and so on .. and getting the right answer

Cheers

Yes. I know. Countifs and Sumifs can be used in these situations. But i used countif cuz the ranges weren't that long.

 

[ZAYYYY]

Here is how the graph looks.

 

[syed1995]

Here is how the graph looks.

How did you create the graph? And what graph type is that graph?

explain to me step by step please.

 

[ZAYYYY]

It is a line graph. In the marking scheme there were just points so I clicked on the lines between the 'points' and made them white so that they are not seen. Plus, you need to double click on one of the series on the graph and choose the plot on secondary axis option. Select all three columns for the data btw.

 

[syed1995]

It is a line graph. In the marking scheme there were just points so I clicked on the lines between the 'points' and made them white so that they are not seen. Plus, you need to double click on one of the series on the graph and choose the plot on secondary axis option. Select all three columns for the data btw.

Seem good enough?

 

[ZAYYYY]

Yeah. Although your points look different from the marking scheme. Wrong data?