Post your AICT doubts here

[abdulqawi]

I need some help in the paper 9713 w09 qp4. in question no 8(menu) and screen shots kindly guide as to how and what to show in the code.

 

[afshinsalim]

source file plz..?

4m d qn ppr, i could ony say dis:
in d sheet wid all ur data, mk a new column n add d formula =IF(A4>=5,{respective-route-cell-reference},0)

if u dnt get it, plz post d src files n i'll try iA.
u can also post ur qns in d link given if u want

Thanx a lot I got it

 

[daviruss]

in o/n 2011 number 8 why did he use hlookup?

 

[Student of the year]

Because the table array is in horizontal, the data needed for q8 is placed row wise in N11TRACKS.csv.
Hlookup is used when the table array is horizontal rows;
and Vlookup is used when table array is in vertical columns.

 

[Student of the year]

Can someone give me the source files for s08.
Plz its urgent....

 

[AAnsarii]

Can someone give me the source files for s08.
Plz its urgent....

ppr? i have 4 p2

 

[Minion]

Can someone help me with J10 Paper 4 Step 3.

 

[Student of the year]

ppr? i have 4 p2

JazakAllah....

 

[AAnsarii]

JazakAllah....

wa iyyakum

 

[Alla' Abu-Sultaneh]

How do you do Q9 from June 2010? Help please! paper 2

 

[ZainH]

You

How do you do Q9 from June 2010? Help please! paper 2

Use MS Access to create a report. You should know how to make a report by now.
After that, it's asking for the average so you have to use an average formula remember to put in the FOOTER OF THE REPORT.
And use a text box.

 

[madara uchia]

Assalamu alaikum wa rahmatullahi wa barakatuhu

No thread was designated for this purpose, so I thought I'd make one. Contribution would be very highly appreciated

May Allah help us. Aameen
Assalamu alaikum wa rahmatullahi wa barakatuhu

plz i got a question on may/june 2012 number 11 how to calculate the number of drivers and on the mark scheme its written divided by 300....my point is from where 300 came.......another question number 9 part two why should we divide F2/400 for the IF function?

 

[AAnsarii]

plz i got a question on may/june 2012 number 11 how to calculate the number of drivers and on the mark scheme its written divided by 300....my point is from where 300 came.......another question number 9 part two why should we divide F2/400 for the IF function?

just give me d venue table on rockict website, iA i'll try 2 answer u....sorry 4 d delay

 

[Alla' Abu-Sultaneh]

You

Use MS Access to create a report. You should know how to make a report by now.
After that, it's asking for the average so you have to use an average formula remember to put in the FOOTER OF THE REPORT.
And use a text box.

How do I group all the business customers together and all the personal customers together??

 

[madara uchia]

do i have to visit the website to get the required information......man now its been looked

 

[Navid Saqib]

Can someone help me with J10 Paper 4 Step 3.

Beta follow these steps

1. create a model same like its given in paper in Ms excel
2. in C4 use a vlookup formula to locate the surname from student file
3. =VLOOKUP($A$2,Students.csv!$A$2:$L$21,3,FALSE)
4. in textbook required column used this formula using book orders file
5. =IF(INDEX('Book orders.csv'!$C$2:$K$21,MATCH($A$2,'Book orders.csv'!$A$2:$A$21,0),MATCH(B2,'Book orders.csv'!$C$1:$K$1,0))<1,"N","Y")
6. in text book cost use this formula
7. =IF(C2="N",0,VLOOKUP(B2,'Book list.csv'!$B$2:$D$10,3,FALSE))
8. now put the ids stated by the examiner
9. and produced the report

hope this answer the question

 

[Student of the year]

Does someone have the source files for 9713_s12_qp2?
PLZ give me...I need it for practice.
Have my exams just the next week.
JazakAllah.

 

[Farhan Chowdhury]

Beta follow these steps

1. create a model same like its given in paper in Ms excel
2. in C4 use a vlookup formula to locate the surname from student file
3. =VLOOKUP($A$2,Students.csv!$A$2:$L$21,3,FALSE)
4. in textbook required column used this formula using book orders file
5. =IF(INDEX('Book orders.csv'!$C$2:$K$21,MATCH($A$2,'Book orders.csv'!$A$2:$A$21,0),MATCH(B2,'Book orders.csv'!$C$1:$K$1,0))<1,"N","Y")
6. in text book cost use this formula
7. =IF(C2="N",0,VLOOKUP(B2,'Book list.csv'!$B$2:$D$10,3,FALSE))
8. now put the ids stated by the examiner
9. and produced the report

hope this answer the question

Sir, could you please explain the formula used to find whether textbook is required or not, ie, this formula: =IF(INDEX('Book orders.csv'!$C$2:$K$21,MATCH($A$2,'Book orders.csv'!$A$2:$A$21,0),MATCH(B2,'Book orders.csv'!$C$1:$K$1,0))<1,"N","Y")

 

[ak_arabia]

why do we use (1+) in functions.
Is it used to calculate 'each'/1 thing?
Like in june 12 the step 11 it was used.
Also could anyone please tell me why we use value before a mid function? thanks in advance

 

[ZainH]

How do I group all the business customers together and all the personal customers together??

I beleive you do that in the report wizard, while grouping.