Software Engineering Predictions/Thoughts (1 Viewer)

[rgh]

No clue how to do the sql problem though

I think it was like this:

SELECT Category, Status, Count(*)
FROM Issues
WHERE Status != "Resolved"
GROUP BY Category, Status
ORDER BY Count(*) DESC;

 

[Socialism]

I'm completely fucked
I like flopped everything

What were you even supposed to write for the virtual personal assistant question?? They literally told you how NN assists it tf am I supposed to write about

And the SQL question fucked me over
And the 2d array one
And I couldn't understand what session management had to do with speed of code execution for a user

 

[Superstitic]

flipping sql rip like 3 marks
also did not know what to write about data mining for the stupid live broadcasting thing
apart from that was okay, all the python stuff was so free

 

[splatcat]

I'm completely fucked
I like flopped everything

What were you even supposed to write for the virtual personal assistant question?? They literally told you how NN assists it tf am I supposed to write about

And the SQL question fucked me over
And the 2d array one
And I couldn't understand what session management had to do with speed of code execution for a user

For the VPA I wrote about how it benefits as it can be trained to understand requests, thus reducing human effort. And for negative I wrote about how NN are basically black boxes so you can't 100% predict the output will be correct, wasting customer time.

2D array python was fine, I just generated 15 pairs of coordinates and then did 2 for loops to display the grid with either spaces or Xs where they matched my coordinates

 

[Isit_actually?]

For the VPA I wrote about how it benefits as it can be trained to understand requests, thus reducing human effort. And for negative I wrote about how NN are basically black boxes so you can't 100% predict the output will be correct, wasting customer time.

Yeah I did something similar to that. Otherwise it was fine tho.

 

[sillilouyje]

I think it was like this:

SELECT Category, Status, Count(*) as Total
FROM Issues
WHERE Status != "Resolved"
GROUP BY Category, Status
ORDER BY Count(*) DESC;

I did

SELECT Category, Status, Count(Status) AS Total
FROM Issues
WHERE Status != "Resolved"
GROUP BY Category, Status
ORDER BY Total DESC;

Did anyone else get it in the exam?

 

[splatcat]

I did

SELECT Category, Status, Count(Status) AS Total
FROM Issues
WHERE Status != "Resolved"
GROUP BY Category, Status
ORDER BY Total DESC;

Hmm i do wonder what the marking criteria is for that question, considering its 4 marks

 

[sillilouyje]

For the VPA I wrote about how it benefits as it can be trained to understand requests, thus reducing human effort. And for negative I wrote about how NN are basically black boxes so you can't 100% predict the output will be correct, wasting customer time.

2D array python was fine, I just generated 15 pairs of coordinates and then did 2 for loops to display the grid with either spaces or Xs where they matched my coordinates

Thats exactly what I wrote about for VPAs

 

[sillilouyje]

Hmm i do wonder what the marking criteria is for that question, considering its 4 marks

Yeah I was getting a bit worried in the exam. I spent a good 45min on that sql quesion. Youd get some marks for some SQL, maybe for WHERE , maybe for ORDER BY too but the last mark is if you use the group by correctly

 

[Autobot6908]

does anyone have any clue on how this and enterprise r gonna scale this year?

 

[sillilouyje]

flipping sql rip like 3 marks
also did not know what to write about data mining for the stupid live broadcasting thing
apart from that was okay, all the python stuff was so free

Im not sure but the data mining one I put they can use data mining on the video stream coming from the broadcast to detect corrupt and malicious data within the video stream to ultimately try and stop technical difficulties etc.

 

[Socialism]

Im not sure but the data mining one I put they can use data mining on the video stream coming from the broadcast to detect corrupt and malicious data within the video stream to ultimately try and stop technical difficulties etc.

Damn, rlly?
I wrote some stuff about how they can use the data they get to 1. see where the majority of users are located (allocation of resources etc) and 2. If a certain kind of device was always experiencing an issue
But I don't think that was right

 

[splatcat]

Damn, rlly?
I wrote some stuff about how they can use the data they get to 1. see where the majority of users are located (allocation of resources etc) and 2. If a certain kind of device was always experiencing an issue
But I don't think that was right

That's what i put too so i hope its right

 

[Isit_actually?]

Are we talking about the same sample exam? Marking guidelines here say its 80 https://curriculum.nsw.edu.au/file/...ngineering-sample-exam-marking-guidelines.pdf

familiarisation

 

[sillilouyje]

That's what i put too so i hope its right

Damn, rlly?
I wrote some stuff about how they can use the data they get to 1. see where the majority of users are located (allocation of resources etc) and 2. If a certain kind of device was always experiencing an issue
But I don't think that was right

Sounds like pretty much any proactive analysis is data mining so we should be good.

 

[b4_youknow]

im so glad its over - the exam wasnt bad tho

 

[Socialism]

does anyone remember which options they picked for the logistic regression? was the political party option logistic because i had an inkling it might've been linear?

i think i only picked two

 

[sillilouyje]

Logistic is categorical probabilities so like 80% this party etc. I said yes to that.

 

[Socialism]

Logistic is categorical probabilities so like 80% this party etc. I said yes to that.

damn

 

[b4_youknow]

Logistic is categorical probabilities so like 80% this party etc. I said yes to that.

yeah for me it was anything that was classifying smth was a yes but i dont remember exactly which ones i picked