Help for Applied ICT paper 4 May/June 2014

[TimBluesWin]

Hello everyone...

Sorry for the inconvenience, but can anyone help me to do no 4 for paper 4 Summer 2014? Especially the first part where we need to display the marks for each student for each question? I have tried several formulas, like:
IF([VB1_Responses.xlsx]Sheet1!B3=VLOOKUP(A3; [Module_VB1.xlsx]Sheet1!$A$3:$C$22;2; FALSE); VLOOKUP(A3; [Module_VB1.xlsx]Sheet1!$A$3:$C$22;3; FALSE);0)

But it doesn't work... So any help would be so appreciated. Thanks a lot!

 

[aryyaa]

does anyone knows macros pls rply fast

 

[InnocentLoser!!]

I used this formula to find the score =HLOOKUP(A13,'D:\Studies\ICT\P4\Summer''14\Tasks\Source Files\[JS1_Scores.csv]JS1_Scores'!$B$2:$R$23,22,FALSE)
and this to find the result =IF(AND(G2>=0, G2<=14), $B$26, IF(AND(G2>=15, G2<=20), $B$25, IF(AND(G2>=21, G2<=32), $B$24, IF(AND(G2>=33, G2<=39), $B$23, IF(G2>=40,$B$22)))))

B22 to B26 are the different results - Distinctiom, Credit, etc.

 

[kimdh996]

Hello there, you asked for task 4, right?

I used this formula to solve it...

=IF(VLOOKUP($A3,VB1_Responses.csv!$A$3:$R$22,COLUMN(B3),FALSE)=Module_VB1.csv!$B3,Module_VB1.csv!$C3,"0")

Hope I am correct and this helps you!

 

[shnaker]

How did Paper 4 go ppl..?

 

[TimBluesWin]

How did Paper 4 go ppl..?

It was harddd..... First 30 minutes I literally just experimenting with the database.... At least I finished every question; not sure how much would I get from cambridge though....