IGCSE/GCSE/O & A Level/IB/University Student Forum

Qualification => Subject Doubts => GCE AS & A2 Level => Miscellaneous => Topic started by: annie_angel on March 17, 2011, 06:07:46 pm

Title: Applied ICT paper 2 nov 2009
Post by: annie_angel on March 17, 2011, 06:07:46 pm

plz plz urgently help with step 27 and 32.......!!!!!!!!!!!!!!!!!!!!!
 :'(

Title: Re: Applied ICT paper 2 nov 2009
Post by: annie_angel on March 17, 2011, 06:15:51 pm

plzzz anyyoneeee .....!!!!:(

Title: Re: Applied ICT paper 2 nov 2009
Post by: Saavya on March 17, 2011, 08:26:21 pm

*phew* just finished with it :)

well in step 27

- in a new column (J) you have to insert the formula " =IF(I6>10,I6,0) " to find only the flights more than 10 minutes late , for All the flights in that sheet.

- then go to the new sheet you created (in which you copied and pasted all the airline names from cell a2 to a32)

-in column C , enter the formula " =SUMIF(N9Flight!$C$6:$C$131,A2,N9Flight!$J$6:$J$131) " (where the J column range was that extra column you created in N9flight worksheet)

in step 32 ? thats simple

-filter the number of flights greater than 6, ooh By the way place labels in a1 ( Airlines) b1 (No. of flights) and c1 (time delayed, or just
delayed) to make it clear for you !

-then u can continue with making a stacked bar chart !  using the chart wizard  ;D

Title: Re: Applied ICT paper 2 nov 2009
Post by: Saavya on March 17, 2011, 08:30:31 pm

if anyone knows any other simpler way of doing step 27 please do post the way of doing it here !

Title: Re: Applied ICT paper 2 nov 2009
Post by: annie_angel on March 18, 2011, 08:45:24 am

omgosh!!!!!
thnak you soo soo much!!!:D :D :D
i really really appriciate tht!! :D

Title: Re: Applied ICT paper 2 nov 2009
Post by: annie_angel on March 19, 2011, 02:36:08 pm

hey can u help wid da graph too?
 :'(
i dont know how to do it :'( :'(