Author Topic: Applied ICT paper 2 nov 2009  (Read 1903 times)

Offline annie_angel

  • i m not an artist; just a painter...[ths is so random]
  • SF Geek
  • ****
  • Posts: 475
  • Reputation: 352
  • Gender: Female
  • --->>>Time is nothing but a Precious Enemy<<<---
Applied ICT paper 2 nov 2009
« on: March 17, 2011, 06:07:46 pm »
plz plz urgently help with step 27 and 32.......!!!!!!!!!!!!!!!!!!!!!
 :'(
Dont tell God how BIG your storm is...;tell your storm how BIG your GOD is.^_^

Offline annie_angel

  • i m not an artist; just a painter...[ths is so random]
  • SF Geek
  • ****
  • Posts: 475
  • Reputation: 352
  • Gender: Female
  • --->>>Time is nothing but a Precious Enemy<<<---
Re: Applied ICT paper 2 nov 2009
« Reply #1 on: March 17, 2011, 06:15:51 pm »
plzzz anyyoneeee .....!!!!:(
Dont tell God how BIG your storm is...;tell your storm how BIG your GOD is.^_^

Saavya

  • Guest
Re: Applied ICT paper 2 nov 2009
« Reply #2 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

Saavya

  • Guest
Re: Applied ICT paper 2 nov 2009
« Reply #3 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 !


Offline annie_angel

  • i m not an artist; just a painter...[ths is so random]
  • SF Geek
  • ****
  • Posts: 475
  • Reputation: 352
  • Gender: Female
  • --->>>Time is nothing but a Precious Enemy<<<---
Re: Applied ICT paper 2 nov 2009
« Reply #4 on: March 18, 2011, 08:45:24 am »
omgosh!!!!!
thnak you soo soo much!!!:D :D :D
i really really appriciate tht!! :D
Dont tell God how BIG your storm is...;tell your storm how BIG your GOD is.^_^

Offline annie_angel

  • i m not an artist; just a painter...[ths is so random]
  • SF Geek
  • ****
  • Posts: 475
  • Reputation: 352
  • Gender: Female
  • --->>>Time is nothing but a Precious Enemy<<<---
Re: Applied ICT paper 2 nov 2009
« Reply #5 on: March 19, 2011, 02:36:08 pm »
hey can u help wid da graph too?
 :'(
i dont know how to do it :'( :'(
Dont tell God how BIG your storm is...;tell your storm how BIG your GOD is.^_^