How was AICT P2?

[sohaib26]

how was the paper and what do you guys think of the grade threshold?

 

[Bibz Suleman]

The paper was intense, in my opinion the grade threshold will be in the 90's

 

[mistique_bee]

thresholds will be higher.....now depends on p1

 

[ZuhairNadeem98]

i found it pretty difficult. it reminded me of october/nvember 2015 which was awful to begin with
i hope the thresholds are low but depends on how others performed now

 

[mistique_bee]

i found it pretty difficult. it reminded me of october/nvember 2015 which was awful to begin with
i hope the thresholds are low but depends on how others performed now

What was difficult in it? Whixh question?

 

[ZuhairNadeem98]

What was difficult in it? Whixh question?

in one step where we had to extract only the numbers from the given code
and another where we needed to calculate the crew required

 

[mistique_bee]

in one step where we had to extract only the numbers from the given code
and another where we needed to calculate the crew required

It wasnt nmbrs... We had to extract letters in put them in dfrnt order.. For tht u have to concatenate the MID function...
N for crew u have to put up nested if function with time

 

[ZuhairNadeem98]

how did you attempt these two steps though?

 

[ZuhairNadeem98]

It wasnt nmbrs... We had to extract letters in put them in dfrnt order.. For tht u have to concatenate the MID function...
N for crew u have to put up nested if function with time

I know that step was easy
but im talking abt task 4
you are talking abt task 3 and task 8

 

[mistique_bee]

how did you attempt these two steps though?

To extract the alphabets....
The example was given ABCD00000 n we have to extract the alphabets n chng thm to CDBA
So use the formula
MID(A2,3,1) & MID(A2,4,1) & MID(A2,2,1) & MID(A2,1,1).. Here to concatenate u could also use CONCATENATE n thn insert MID formula in it

 

[mistique_bee]

I know that step was easy
but im talking abt task 4
you are talking abt task 3 and task 8

No.. Im talking abt 4 only...

 

[ZuhairNadeem98]

To extract the alphabets....
The example was given ABCD00000 n we have to extract the alphabets n chng thm to CDBA
So use the formula
MID(A2,3,1) & MID(A2,4,1) & MID(A2,2,1) & MID(A2,1,1).. Here to concatenate u could also use CONCATENATE n thn insert MID formula in it

there were 3 tasks whose screen shots we had to take : task 3 which is the one you mentioned and was 9 marks , task 4 which is the one where we had to extract the numbers only and put them in a coloumn named Code was 16 marks , task 5 was simply just naming ranges and that was like 8 marks

 

[mistique_bee]

there were 3 tasks whose screen shots we had to take : task 3 which is the one you mentioned and was 9 marks , task 4 which is the one where we had to extract the numbers only and put them in a coloumn named Code was 16 marks , task 5 was simply just naming ranges and that was like 8 marks

wht was xctly task 3....? i dnt remember it...cn u plz tell ..

 

[mistique_bee]

Dark Destination what was task 3?

 

[Dark Destination]

Dark Destination what was task 3?

Task 1 was creating evidence document.
Task 2 was examining the files and saving as spreadsheet.
Task 3 was Concatenate to create venue codes in j16_venues.csv
Task 4 was extracting numbers from code to give Capacity.
Task 5 was named ranges.
Task 6 was saving the j16_tourguide.csv file as spreadsheet and inserting header.
Task 7 was vlookup with named ranges to give venue name, location and capacity.
Task 8 was calculating crew by using conditions.
Task 9 was making a graph.
Task 10 was making three new fields: sound, light, general.
Task 11 was another bar graph comparing sound, light and general crew members.

 

[Dark Destination]

Might have missed a step or two, but those were the main steps I guess..

 

[ZuhairNadeem98]

Dark Destination what was task 3?

like i said before
in task 3 you had to extract the letters while in 4 you had to extract the numbers
taks 3 was very easy hence the 9 marks but the next one was tricky and i couldnt do it which let me obviously bum cuz it was one of the main steps and had a lot of marks to it (16 marks) and the other steps in the futuer kinda depended on it

 

[ZuhairNadeem98]

you didnt miss it did you?
it was worth alot of marks

 

[Dark Destination]

I used the following formula for step 4:

= VALUE(IF(RIGHT(A3,1)="X", MID(A3,5,LEN(A3)-5), RIGHT(A3, LEN(A3)-4)))

And for step 8, to calculate crew:

= 5 + ROUNDUP(F3/500,0) + IF(TIME(HOUR(E3),MINUTE(E3),SECOND(E3)<TIME(20,0,0), 2, 0)

 

[ZuhairNadeem98]

I used the following formula for step 4:

= VALUE(IF(RIGHT(A3,1)="X", MID(A3,5,LEN(A3)-5), RIGHT(A3, LEN(A3)-4)))

And for step 8, to calculate crew:

= 5 + ROUNDUP(F3/500,0) + IF(TIME(HOUR(E3),MINUTE(E3),SECOND(E3)<TIME(20,0,0), 2, 0)

well great.........
couldnt get both right ......
now i doubt if the grade boundaries would be low