ATAR Notes: Forum
Archived Discussion => 2009 => End-of-year exams => Exam Discussion => Victoria => IT Applications => Topic started by: billz1508 on November 10, 2009, 05:19:26 pm
-
how did you all go? hope u all did well. or reasonable ok, cause i managed to stuff mine up and yeh, i studied for ltierally no reason, but ahwell lol, who knows wat is gonna be in an exam..
hopefully get some multiple quesiton answers up soon.
-
yer bro i stuffed it up as well..... =(
So many questions with steps!!
-
Hey guys,
Sucks to hear that. Dw about it too much! It's all over now!
I think I did alright, had enough time to read over my answers once or twice.
But, I have to say some of the multi choice made me think..
-
Yeah MC was fairly challenging, some questions.. grr..
Verdict : Harder or easier than last year?
-
I couldn't if get the milestone MC right....GG
-
i decided to leave half an hour i was so depressed. headache was massive haha. wat happened when u have a shit gym LOL ahwell.. yeh its all over now, lets hope when my exam gets marked 2nd time (no doubt it will lol)
-
u reckon it was easier than last year?? zomg.. lol. i wish
-
u reckon it was easier than last year?? zomg.. lol. i wish
The questions were a lot more straight forward then last years I think.
Personally, I liked the exam paper except for a couple of things.
Like...
That effectiveness question with Layout and relevance.
I didn't know what to write for the first line? I just made up some crap.
-
did we have to write something for first line.. it didnt ask for anything :S
-
Well it had..
Relevance _________________________________
So I thought we had to write something there..
-
For Layout I wrote: Clean and Simple
and for Relevance I wrote: Very Relevant due to current water crisis.
I was like, that is wayyy off but oh well
-
yer pretty sure it didn't ask for anything
-
yeah true potter. ahwell. im over it now lol.
-
But it was like
Relevance: _____________________
Justification:____________________
____________________
-
Yeah I defined it then provided examples, I assumed that's what it asked?
-
I thought the exam was pretty reasonable, I answered mostly everything confidently. I think that it could possibly be easier than last years. These are my answers to the multichoice questions, i checked with my teacher and hopefully only got 2-3 wrong.
1.D, 2A, 3D, 4A, 5C (this one is wrong), 6C, 7C, 8A, 9A, 10D, 11B (this one is wrong), 12B, 13D, 14C, 15A, 16D, 17B, 18B, 19A, 20B
-
pretty sure didnt have ':' didnt say justifys or explain did it? i thought it just said explain how it demonstrates and effect. or something..
-
Don't quote me on the ':'
I could be wayy off.
But oh well, the exam is over, we all did our best
-
For two hours of study throughout the whole year, Im pretty sure I just managed a pass.
-
Piss easy. Easiest exam I've done.
Mind you.. I work in IT ;-)
-
I'm pretty sure the A+ cutoff will be much lower for this exam.
-
i found it easier than 08
-
The exam was VERY average.....they put alot of questions about databases and excel, some of the M.C were crazy, WTF @ the Milestone question
-
Yeah I found that exam a lot harder then 07 and 08, was really pissed off. Some of those multiple choice question were fucked. I should get an A+ though, thats all I'm hoping.
Also, posting 'easy' is just arrogant, how would you like it if you fucked up and then someone came on here saying 'that was piss easy'
-
i feel bad.......
-
That one-to many relationship MCQ tripped me out..
-
i think it was too much common sense which ended up confusing me when trying to answer, as im like no that is too easy and not relating to much to i.t... ahwell.. best of luck :)
-
That one-to many relationship MCQ tripped me out..
pretty sure it was one field to many records, but im not sure, its a very weird question!
-
That one-to many relationship MCQ tripped me out..
pretty sure it was one field to many records
but the book said its record to record
-
yeah i think ur right!
what did people say for the question where the macro had the if statement in it. That one connfused me!
the design tool one?
-
For the milestone question in MC, isn't a milestone shown as circle on a Gantt chart?
correction: It is a diamond, and answer was C.
-
a milestone is shown as a diamond on a gantt chart...pretty sure the answer for that question was c, about being a stage where you can evaluate
-
Rohan I also did A for that one, a milestone isn't a task.
-
Yeah I found that exam a lot harder then 07 and 08, was really pissed off. Some of those multiple choice question were fucked. I should get an A+ though, thats all I'm hoping.
Also, posting 'easy' is just arrogant, how would you like it if you fucked up and then someone came on here saying 'that was piss easy'
happens quite often to me in maths xD
-
Rohan I also did A for that one, a milestone isn't a task.
Yeah for some reason I had it in my head they were circles, so it was between A and C for me..
I'm trying to check now, if they actually are diamonds then I'm guessing that one is wrong =/
edit: aahha and it looks to be a diamond, so I guess its C then xD
-
what were the ethical dilemmas for the email about gambling?
-
Rohan I also did A for that one, a milestone isn't a task.
It can't be A.
A milestone is not a circle in a Gantt chart, it's a diamond.
EDIT: can't
-
Rohan I also did A for that one, a milestone isn't a task.
It can be A.
A milestone is not a circle in a Gantt chart, it's a diamond.
i so totally agree
-
I hated that MC :(
-
Rohan I also did A for that one, a milestone isn't a task.
It can be A.
A milestone is not a circle in a Gantt chart, it's a diamond.
didnt A say it was a circle?
-
how did u guys draw the pert chart..
i didnt think that would be in the exam
-
Rohan I also did A for that one, a milestone isn't a task.
It can be A.
A milestone is not a circle in a Gantt chart, it's a diamond.
didnt A say it was a circle?
Yeah, so the answer can't be A. Must be C.
-
Rohan I also did A for that one, a milestone isn't a task.
It can be A.
A milestone is not a circle in a Gantt chart, it's a diamond.
didnt A say it was a circle?
Yeah, so the answer can't be A. Must be C.
I think he got confused with your "It can be A. " instead of "can't" typo
-
anyway...
what do you think the A+ cut off will be?
-
Rohan I also did A for that one, a milestone isn't a task.
It can be A.
A milestone is not a circle in a Gantt chart, it's a diamond.
didnt A say it was a circle?
Yeah, so the answer can't be A. Must be C.
I think he got confused with your "It can be A. " instead of "can't" typo
Yeah sorry for the mistake, my validation rules are malfunctioning
What did you guys get for the second last q? The one with the orders i think (Short answer)
-
I finished it in an hour :S, so did 3 other classmates. It wasn't that easy but it wasn't hard either...Here's hoping for an A
-
anyway...
what do you think the A+ cut off will be?
80 - 82
-
Piss easy. Easiest exam I've done.
Mind you.. I work in IT ;-)
you know what....how about u just shut up
-
what did u guys get for the slack time for the PERT chart we had to draw?
-
what did u guys get for the slack time for the PERT chart we had to draw?
Can anyone draw up the pert chart onto here? I don't think I did it right :S
-
what did u guys get for the slack time for the PERT chart we had to draw?
task Q with 5 days I think
-
same here rohan :)
-
[IMG]http://img35.imageshack.us/img35/9526/pertchart.png[/img]
That's what my pert chart looked like and critical path was P, R, S, T?
-
i remember mine having dotted lines from the end of q to the last one
-
i remember mine having dotted lines from the end of q to the last one
I had this too!
and yay vadnal XD
-
i remember mine having dotted lines from the end of q to the last one
yeah i had dots - it represented dummy activity (a dependency which has no task associated to it)
-
did we have to label the nodes cant we just writes the letters on the line liek it was in the question?
-
what did u guys get for the slack time for the PERT chart we had to draw?
task Q with 5 days I think
i wrote 4 - anyone confirm?
-
i didn't join them up as it was only part of a project, not the whole project. thats also why at the start they didn't give you a bubble or anything saying 'Start'
I don't know, it was risky on my behalf coz that looks dumb, however i figured that it was only part of the project and not the whole thing, so why would there be a finish at that stage?
I wrote the letters on the line like they did.
-
[IMG]http://img35.imageshack.us/img35/9526/pertchart.png[/img]
That's what my pert chart looked like and critical path was P, R, S, T?
Thanks Codykm. That's exactly what I had.
-
Rohan I also did A for that one, a milestone isn't a task.
YAY!!!!
It can be A.
A milestone is not a circle in a Gantt chart, it's a diamond.
didnt A say it was a circle?
Yeah, so the answer can't be A. Must be C.
YAY!!!
-
Sweet I put the dotted line dummy task too :) that's probably worth 1 mark :O
-
Omg I'm so frustrated with myself. The PERT question I read it as task Q only having 1 day of slack, but ohwell looking here it's only 1 - 2 marks off.
-
Sweet I put the dotted line dummy task too :) that's probably worth 1 mark :O
every mark is vital
-
I reckon the short answer was harder than the multi-choice
-
I guess we can only wait... when do the results come out ?
-
lol the multiple choice is like a warmup for the short answer :P
-
Has that Mark Kelly guy put up the solutions?
-
anyway...
what do you think the A+ cut off will be?
80 - 82
You think A+ will be 80-82 out of 90? Was it that much easier than previous years?
My friend thinks he lost 5-10 marks :|
-
i reckon it'll stay the same... since multi was okay and short answer was crazy
-
i put 1 day slack time as well. I'm hoping i get A+ for that exam, hopefully I do.. also you know that multiple choice question on the first page, about the privacy shit, what was the answer? I put D but i'm not sure
-
i got D for that
-
anyway...
what do you think the A+ cut off will be?
I meant percent
80 - 82
I meant percent
You think A+ will be 80-82 out of 90? Was it that much easier than previous years?
My friend thinks he lost 5-10 marks :|
-
Thats good, it seemed weird given 22.5 marks could be lost last year for A+.
-
For that query one
Supplier = Bunny Podcasts
-
For that query one
Supplier = Bunny Podcasts
isnt it Supplier = "Bunny Podcasts"
-
isnt the slack time 5? because it has 5 days untill the rest of the tasks were completed?
http://www.vcaa.vic.edu.au/vcaa/vce/statistics/2008/statssect3.html and then http://www.vcaa.vic.edu.au/vcaa/vce/statistics/2008/section3/vce_it_applications_ga08.pdf gets u last years stats
last year A+ was 135 - 180
i believe it will be same or less this year
-
For that query one
Supplier = Bunny Podcasts
'Tis what I did.
Where can I find the marks from last year i.e. the A+ cutoff?
isnt it Supplier = "Bunny Podcasts"
-
2008 - http://vcaa.vic.edu.au/vcaa/vce/statistics/2008/section3/vce_it_applications_ga08.pdf
2007 - http://vcaa.vic.edu.au/vce/statistics/2007/section3/vce_it_applications_ga07.pdf
-
yeah 67.5/90 for A+. lol. For the 2008 MC i got 19 and this year i probs dropped 2 or 3 more :( sucks.
btw ROHAN I SEE YOU haha.
-
wat was that one where we had to do:
?? <= ??
-
For question 1, part B in short answers - what did you guys write?
The 'backing up since the last backup' is?
they said 'last back' does 'last back' mean last FULL backup or last INCREMENTAL backup?
I think incremental was the answer they were looking for.
-
For that query one
Supplier = Bunny Podcasts
Fml. would i lose marks for not having the talkin marks
isnt it Supplier = "Bunny Podcasts"
-
For question 1, part B in short answers - what did you guys write?
The 'backing up since the last backup' is?
they said 'last back' does 'last back' mean last FULL backup or last INCREMENTAL backup?
I hope its incremental
I think incremental was the answer they were looking for.
-
For that query one
Supplier = Bunny Podcasts
you prob will coz the query wont work without them
Fml. would i lose marks for not having the talkin marks
isnt it Supplier = "Bunny Podcasts"
-
For question 1, part B in short answers - what did you guys write?
The 'backing up since the last backup' is?
they said 'last back' does 'last back' mean last FULL backup or last INCREMENTAL backup?
I hope its incremental
I think incremental was the answer they were looking for.
i said incremental
-
For that query one
Supplier = Bunny Podcasts
you prob will coz the query wont work without them
Fml. would i lose marks for not having the talkin marks
isnt it Supplier = "Bunny Podcasts"
Fml.. I wrote query= "Bunny Podcasts"
And for that referencing Q on the excel page..
I wrote =!pagenameCellref
instead of =Pagename!cellref
-
What did you guys get for the question about the transmission medium?
I got microwaves.
-
But why incremental?
It could have been differential as much as it could've been incremental?
Nothing specified otherwise,
I pointed out the ambgiouty of the question and said "well if this means this, then the answers is this" "but if this means this, the answer is this"
I went to a lecture by Rob Mercer, the I.T. guy behind many lectures held by Swinburne and he said dont ever be afraid to question the question, as its happened many times over the years, even last years. I guess they cant mark us wrong for either one :D
Yea i got differential as well.
It didn't really specify whether the "previous backup" was full, so it leans towards incremental slightly, but still, it could go either way.
-
What did you guys get for the question about the transmission medium?
I got microwaves.
easiest question in MC in my opinion yerp your right though
-
i rote Criteria = " Bunny Podcasts"
u rekon ill get marks
-
i rote Criteria = " Bunny Podcasts"
u rekon ill get marks
maybe one for identifying the appropriate reference
-
IT:A has always been rather ambiguous =/
-
IT:A has always been rather ambiguous =/
thats y i hate it
-
For that query one
Supplier = Bunny Podcasts
you prob will coz the query wont work without them
Fml. would i lose marks for not having the talkin marks
isnt it Supplier = "Bunny Podcasts"
Fml.. I wrote query= "Bunny Podcasts"
And for that referencing Q on the excel page..
I wrote =!pagenameCellref
instead of =Pagename!cellref
Lol not as bad as me. I wrote ="pagename"cellref
-
What did you guys get for the question about the transmission medium?
I got microwaves.
easiest question in MC in my opinion yerp your right though
TBH it did trip me a little, but the process of elimination told me that the other three options couldn't cover the distance. CAT5 is pushing it.
-
Also, the mc question about the different types of infosystems, what did you guys get?
-
For that query one
i might have earned marks,
i rote =!pagename!cellref
( 1 extra !, cmon man markers arent that tighht are they)
Supplier = Bunny Podcasts
you prob will coz the query wont work without them
Fml. would i lose marks for not having the talkin marks
isnt it Supplier = "Bunny Podcasts"
Fml.. I wrote query= "Bunny Podcasts"
And for that referencing Q on the excel page..
I wrote =!pagenameCellref
instead of =Pagename!cellref
Lol not as bad as me. I wrote ="pagename"cellref
-
decision support system
-
decision support system
i said that also!
-
decision support system
+1
-
But why incremental?
It could have been differential as much as it could've been incremental?
Nothing specified otherwise,
I pointed out the ambgiouty of the question and said "well if this means this, then the answers is this" "but if this means this, the answer is this"
I went to a lecture by Rob Mercer, the I.T. guy behind many lectures held by Swinburne and he said dont ever be afraid to question the question, as its happened many times over the years, even last years. I guess they cant mark us wrong for either one :D
Yea i got differential as well.
It didn't really specify whether the "previous backup" was full, so it leans towards incremental slightly, but still, it could go either way.
That's exactly right.
Another ambiguous question was the one with the IPO.
Input could be both quantity and cost, or just quantity depending on what set values are in the spreadsheet already.
-
other than some of the formulas i think the exam was relatively ok, what else did people find hard?
yes etherlite, i was very unsure about that
i just said quantity, was scared to add both lol, i assumed cost will already be inputted
-
other than some of the formulas i think the exam was relatively ok, what else did people find hard?
those ethical questions are very subjective to the marker.
-
other than some of the formulas i think the exam was relatively ok, what else did people find hard?
yes etherlite, i was very unsure about that
i just said quantity, was scared to add both lol, i assumed cost will already be inputted
yeah I actually made that point in red next to the question for the marker to see.
-
Also, how can you make a query an alert? For the podcasts Q.
I automatically thought an IF statement. But it said query?
Was a bit confused so I made up a line of crap.
-
Also, how can you make a query an alert? For the podcasts Q.
I automatically thought an IF statement. But it said query?
Was a bit confused so I made up a line of crap.
i made up an if statement also haha
-
Also, how can you make a query an alert? For the podcasts Q.
I automatically thought an IF statement. But it said query?
Was a bit confused so I made up a line of crap.
i made up an if statement also haha
same.
-
I agree with you majo, wasn't too bad.
Lets all pray for a nice marker :)
-
yeah i got A+ on VET IT last year, so i am hoping to replicate that so i can prove to the IT teacher that going on carsales during class wasnt a bad idea LOL
-
other than some of the formulas i think the exam was relatively ok, what else did people find hard?
yes etherlite, i was very unsure about that
i just said quantity, was scared to add both lol, i assumed cost will already be inputted
even though cost may have already been inputted, it had to inputted at one stage so for the ipo chart you should have included cost and quantity
-
Also, how can you make a query an alert? For the podcasts Q.
I automatically thought an IF statement. But it said query?
Was a bit confused so I made up a line of crap.
i made up an if statement also haha
same.
me too
-
decision support system
+1
haha lol +2
-
What did u guys write for that q about the guy not being able to edit the read-only document?
decision support system
+1
haha lol +2
+3
-
For question 1, part B in short answers - what did you guys write?
The 'backing up since the last backup' is?
they said 'last back' does 'last back' mean last FULL backup or last INCREMENTAL backup?
I hope its incremental
I think incremental was the answer they were looking for.
i said incremental
as did I
-
Emergency plan:
software supplier contact details and hardware shutdown?
anyone?
-
i said schedule time to put the stuff back on and backup data evacuation
-
i said schedule time to put the stuff back on and backup data evacuation
how can u evacuate data?
data should already be stored offsite...
-
What about that monthly income/expenses spreadsheet?
did u guys get HOORAY will come up?
(without quotations)
-
What about that monthly income/expenses spreadsheet?
did u guys get HOORAY will come up?
(without quotations)
+1
-
What about that monthly income/expenses spreadsheet?
did u guys get HOORAY will come up?
(without quotations)
+1
Good - cause i was about put "" as the sub totals were left empty, but then i had to manually calculate the totals (the 2nd time i had to do maths this year without a calculator)
+1
-
What about that monthly income/expenses spreadsheet?
did u guys get HOORAY will come up?
(without quotations)
+1
+1
-
What about that monthly income/expenses spreadsheet?
did u guys get HOORAY will come up?
(without quotations)
I got with quotations, as text within a field is usually insinuated using "" e.g. "HOORAY".
That's how it's been in past exams.
-
i said schedule time to put the stuff back on and backup data evacuation
how can u evacuate data?
data should already be stored offsite...
I said something about evacuating personnel and important data; can't remember.
-
use of conventions?
indicates completion of a task that allows evaluation of the project to date?
-
use of conventions?
indicates completion of a task that allows evaluation of the project to date?
Both correct I think.
-
i said schedule time to put the stuff back on and backup data evacuation
how can u evacuate data?
data should already be stored offsite...
I said something about evacuating personnel and important data; can't remember.
that's the thing, it did have anything to do with personel. Check Mark Kelly's Leading Edge
-
i said schedule time to put the stuff back on and backup data evacuation
how can u evacuate data?
data should already be stored offsite...
I said something about evacuating personnel and important data; can't remember.
page 249 of Potts - i think both answers would suffice
-
I'm sure the answer I put related to evacuating personnel and important data.
p249 Potts:
One point: Evacuation procedures for employees, including the removal of backup tapes of equipment
Another point: ...equipment shutdown or removal of files.
-
Now the HOORAY question:
Quotations or not?
-
Just Hooray, the message comes up from the that is contained inside the quotations.
-
I'm sure the answer I put related to evacuating personnel and important data.
p249 Potts:
One point: Evacuation procedures for employees, including the removal of backup tapes of equipment
Another point: ...equipment shutdown or removal of files.
it also says some shit about contact details
-
Just Hooray, the message comes up from the that is contained inside the quotations.
What I don't get is that both of the reference cells were blank. So therefore they equaled eachother?
Making the IF statement false? Hence ""
Or did we have to use the summing formula from the previous multi choice?
-
Huh? Income was like $2550 and expenses were like $2350 =S
you probably added them wrong?
I put just Hooray as well, no quotations as they are asking what would appear on the cell exactly. and quotations wouldn't appear.
Damn did they use the word exactly? missed that
-
Just Hooray, the message comes up from the that is contained inside the quotations.
What I don't get is that both of the reference cells were blank. So therefore they equaled eachother?
Making the IF statement false? Hence ""
Or did we have to use the summing formula from the previous multi choice?
That's what I did, as in used the values summed. Bloddy IT exams...they should be the ones studying how clarity can enhance a product!!!! Then maybe we'd know exactly what to answer more that 50% of the time.
-
Anyway the way I see this forum is a collection of highly motivated who really care about how they went in the subject, using a "nerdy" forum to discuss it which indicates we are all pretty IT savvy.
Based on that and the similarities in our results, despite a few people getting some right here, some wrong there, I would say we are all heading for the A, A+ region of marks for the exam, almost without a doubt.
Unless you really f***** the exam up, I'm going to say we all did well in this year's exam.
Well done everyone.
-
Huh? Income was like $2550 and expenses were like $2350 =S
you probably added them wrong?
I put just Hooray as well, no quotations as they are asking what would appear on the cell exactly. and quotations wouldn't appear.
Nah, but the screen shot of the spreadsheet didn't have any values in the reference cells.
The question was referring back to the screen shot, not from manual calculations if you get what I mean..
That's my interpretation of the question.. Is that shitty logic or what..?
-
Anyway the way I see this forum is a collection of highly motivated who really care about how they went in the subject, using a "nerdy" forum to discuss it which indicates we are all pretty IT savvy.
Based on that and the similarities in our results, despite a few people getting some right here, some wrong there, I would say we are all heading for the A, A+ region of marks for the exam, almost without a doubt.
Unless you really f***** the exam up, I'm going to say we all did well in this year's exam.
Well done everyone.
well done wooo!! haha
i believe that if you went out of ur way to even be apart of this forum, it shows that you truely do care about your score and you did your best!
best of luck to everyone for annymore upcoming exams!
-
Huh? Income was like $2550 and expenses were like $2350 =S
you probably added them wrong?
I put just Hooray as well, no quotations as they are asking what would appear on the cell exactly. and quotations wouldn't appear.
Nah, but the screen shot of the spreadsheet didn't have any values in the reference cells.
The question was referring back to the screen shot, not from manual calculations if you get what I mean..
That's my interpretation of the question.. Is that shitty logic or what..?
The way i did it was that even if it wasn't using the manual calculations we had to do it still wouldnt display " ", it would just display nothing. Ruling out the impossiable answers just left HOORAY... as far as my logic could desipher :S
-
Anyway the way I see this forum is a collection of highly motivated who really care about how they went in the subject, using a "nerdy" forum to discuss it which indicates we are all pretty IT savvy.
Based on that and the similarities in our results, despite a few people getting some right here, some wrong there, I would say we are all heading for the A, A+ region of marks for the exam, almost without a doubt.
Unless you really f***** the exam up, I'm going to say we all did well in this year's exam.
Well done everyone.
That's the spirit, good encouragement and I also agree.
All the best on your results for other exams guys.
-
Also, how can you make a query an alert? For the podcasts Q.
I automatically thought an IF statement. But it said query?
Was a bit confused so I made up a line of crap.
i made up an if statement also haha
same.
me too
I put:
Stock <= Reorder Stock, "Reorder Stock"
Which i think is probably wrong, but my logic was: if stock is less than or equal to reorder stock, then display message 'Reorder Stock'
I didn't use an IF statement as it said query :S
And also, its HOORAY with no quotations
-
(http://i466.photobucket.com/albums/rr30/p3t3rkn1f3/Excelscreen.jpg)
This is the same situation isn't it..?
-
(http://i466.photobucket.com/albums/rr30/p3t3rkn1f3/Excelscreen.jpg)
This is the same situation isn't it..?
If you're talking to me, no, because thats in a spreadsheet using spreadsheet formula, it was a database using queries
-
(http://i466.photobucket.com/albums/rr30/p3t3rkn1f3/Excelscreen.jpg)
This is the same situation isn't it..?
its what i did so i hope so lmao
cant databases use if statements?
-
I also put an if statement, however, i'm pretty sure that would be wrong as it's just a queiry.... hmm...
there were a few questions which weren't too clear i thought this year!
Does anyone know how long it takes for Mark Kelly to post his answers normally?
-
Don't know, I think you might be able to.. so the IF statements probably right.. lol
-
(http://i466.photobucket.com/albums/rr30/p3t3rkn1f3/Excelscreen.jpg)
This is the same situation isn't it..?
its what i did so i hope so lmao
cant databases use if statements?
I don't think they can..
Sorry, I'm referring back to that Hooray question.
-
(http://i466.photobucket.com/albums/rr30/p3t3rkn1f3/Excelscreen.jpg)
This is the same situation isn't it..?
its what i did so i hope so lmao
cant databases use if statements?
I don't think they can..
Sorry, I'm referring back to that Hooray question.
The else argument (after the second comma) was empty, otherwise, yes.
-
You guys put the $'s in for the VLOOKUP as well?
-
on a side note... did anyone manage to get a copy of the exam they can scan and post?
-
i went blank on queries during the exam... fuck
-
But you assumed that the spreadsheet was functional and with data right?
I mean why else would be analysing a information product that doesnt have the fundamental aspects of it (i.e. the income/expenses)
So, i assumed that it was with data in it. and the previous question actually discussed about the SUM Functions, so we can lean more towards a continuation than just a random empty cell - idont know, thats what i did :S
That is very true and I understand your logic.
But didn't the question refer back to the screen shot..? Not to assumed data...
I dunno.. Who cares! It's over! All the best to everyone =]. Good luck for the rest of your exams and enjoy the summer holiday! =D
And a yes to including $ in the vlookup formula.
-
Does anyone know how long it takes for Mark Kelly to post his answers normally?
About a day or so. It's a shame that there hasn't been a copy of the exam posted so that either myself or Excal could write up some solutions like last year, but Kelly's will be out soon enough.
I admire the discussion going on though. By the sounds of it, it seems like VCAA has put out yet another exam filled with ambiguity.
-
Does anyone know how long it takes for Mark Kelly to post his answers normally?
About a day or so. It's a shame that there hasn't been a copy of the exam posted so that either myself or Excal could write up some solutions like last year, but Kelly's will be out soon enough.
I admire the discussion going on though. By the sounds of it, it seems like VCAA has put out yet another exam filled with ambiguity.
oh ell.. it was fucked up
-
Ell, ambigous would be too revealing of a word to describe this exam T__T
ROFL, so true.
-
Haha, I hear you guys. At least there's some comfort in the fact that everyone had the same exam.
-
Haha, I hear you guys. At least there's some comfort in the fact that everyone had the same exam.
And in the end, if we all fuck up the same question, it really becomes obsolete anyway.
-
Was it a macro or a chart wizard for the last q?
-
Was it a macro or a chart wizard for the last q?
Yeha I said macro, but I did think of a chart wizard.
I think in the end I said a macro that AUTOMATES the chart wizard...wow!
-
Was it a macro or a chart wizard for the last q?
I think in the end I said a macro that AUTOMATES the chart wizard...wow!
that's possible yeah?
-
Was it a macro or a chart wizard for the last q?
I think in the end I said a macro that AUTOMATES the chart wizard...wow!
that's possible yeah?
to be honest I don't know, but I would say so.
like a print macro: formats and collates the data together