Thoughts on exam?

[LaternBall]

How did you get B for 17? I chose C because I thought completeness was to do with effectiveness

Yes. It is C, all the other answers are related to efficiency.

[lala1911]

Also does anyone know how to do 19 and 20? I neglected database study.. funnily enough Q12 was all databases -sadface-. Also, Q12, was the answer to use a filter in a query?

[darvell]

Also does anyone know how to do 19 and 20? I neglected database study.. funnily enough Q12 was all databases -sadface-. Also, Q12, was the answer to use a filter in a query?

/Could be wrong but pretty sure/

19. Is C, W.
Notice how there is one eclipse on each entity that is a different colour? Primary keys have to be unique.

20. (I screwed this one up but someone told me later)
Is B, - The diamonds reprent the relationships between the entities, so I guess it shows the 3 way relationship between doctor, patient and medication.
I didn't realise you could have a 3 way relationship so I picked C, but oh well, can't change it now!

edit: I just read the Q12 thing.
The thing with the chapterrs?
I wrote that she should format the chapter names so that instead of ebing 'chapter1' it would be chapter 01 (Is this what you're talking about or??)
Wait you're talking about the gif thing LOL ignore me Im so with it
Yah Query/filter would have been fine!

[lala1911]

/Could be wrong but pretty sure/

19. Is C, W.
Notice how there is one eclipse on each entity that is a different colour? Primary keys have to be unique.

20. (I screwed this one up but someone told me later)
Is B, - The diamonds reprent the relationships between the entities, so I guess it shows the 3 way relationship between doctor, patient and medication.
I didn't realise you could have a 3 way relationship so I picked C, but oh well, can't change it now!

Damn. Funnily enough, I had C and B written down, but I changed them to A and C last minute. Oh well, same, cant change it.. unless I broke into where VCAA store the exams. First we'll need to find their 'physical' swipe card to get access.

[Ruzzah112]

How did you get B for 17? I chose C because I thought completeness was to do with effectiveness

Went to a lecture where the guy said a criterion is usually measurable by a number or percentage, haha I changed my answer from C to B, trusting the guy. Seeing all the changes and dumbing down they've done, C is probably right.

[darvell]

Damn. Funnily enough, I had C and B written down, but I changed them to A and C last minute. Oh well, same, cant change it.. unless I broke into where VCAA store the exams. First we'll need to find their 'physical' swipe card to get access.

hahahahahahahha I literally read that question and died a little inside.
You should always stick to your instincts with MC I reckon, unless you're changing it because you definitely have misinterpreted the Q.
Always ends up being right the first time and then you just have a crying party when you realise you doubted yourself

[LaternBall]

Also, Q12, was the answer to use a filter in a query?

If you're speaking about Q12C, I would argue so, as that is one way to show the data that is wanted. Not sure if there are any other more efficient ways though.

What procedures did everyone else get for Q12b? I got so confused on that one. Ended up writing 'grouping chapters', for example: Chapter 1 and 9 would be called Chapter A-1 and Chapter A-9 respectively, and Chapter 10 and 12 would be called Chapter B-1 and B-3 respectively. I had no clue.

[lala1911]

If you're speaking about Q12C, I would argue so, as that is one way to show the data that is wanted. Not sure if there are any other more efficient ways though.

What procedures did everyone else get for Q12b? I got so confused on that one. Ended up writing 'grouping chapters', for example: Chapter 1 and 9 would be called Chapter A-1 and Chapter A-9 respectively, and Chapter 10 and 12 would be called Chapter B-1 and B-3 respectively. I had no clue.

Had no clue.. I don't think many people would get it right. I won't even bother saying what I wrote, but I 'may' get one mark for testing.

[Ruzzah112]

If you're speaking about Q12C, I would argue so, as that is one way to show the data that is wanted. Not sure if there are any other more efficient ways though.

What procedures did everyone else get for Q12b? I got so confused on that one. Ended up writing 'grouping chapters', for example: Chapter 1 and 9 would be called Chapter A-1 and Chapter A-9 respectively, and Chapter 10 and 12 would be called Chapter B-1 and B-3 respectively. I had no clue.

For Q12b I said for Kelly to remove the redundant "Chapter" from each entry and change the data type of numerical and use the sort function again to test if it worked.

I totally misread Q12c I didn't see if ask for a list... I just simply said a formula she could use is IF(FileSize<50, "true", "false") fuck.

[lala1911]

For Q12b I said for Kelly to remove the redundant "Chapter" from each entry and change the data type of numerical and use the sort function again to test if it worked.

I totally misread Q12c I didn't see if ask for a list... I just simply said a formula she could use is IF(FileSize<50, "true", "false") fuck.

I don't think you could use spreadsheet formulas? I thought it was database only, because with spreadsheets when i sort from lowest to highest it always comes up with the lowest, even when its 1,6,8,120.

[Ruzzah112]

I don't think you could use spreadsheet formulas? I thought it was database only, because with spreadsheets when i sort from lowest to highest it always comes up with the lowest, even when its 1,6,8,120.

When you sort from lowest it always come up lowest? That made no sense :s

[lala1911]

When you sort from lowest it always come up lowest? That made no sense :s

With databases, when you sort from lowest to highest it comes up as 1,120,6,8 but with spreadsheets when I do it from lowest to highest it comes up as 1,6,8,120. So I think the question was relating to databases, because if she used a spreadsheet it would've worked correctly.

didnt make myself clear sorry

[Ruzzah112]

With databases, when you sort from lowest to highest it comes up as 1,120,6,8 but with spreadsheets when I do it from lowest to highest it comes up as 1,6,8,120. So I think the question was relating to databases, because if she used a spreadsheet it would've worked correctly.

didnt make myself clear sorry

It shows first digit as sorted because your data type is text, must be numerical.

[lala1911]

Oh, right, didn't think about that. Anyway it specifies that it is a data table. I was hesitant to write a spreadsheet formula, even though I was dying to..

did you like the sketch/annotation question? I thought it was good.
For dotpoint two I had payments through secure payment systems e.g PayPal and through https, and dotpoint three as members need to register to be part of the community which would reduce phishing/spamming bots.

[nosuperstar]

Reckon anybody will post up the solutions for the multiple choice?