Enterprise Computing Predictions/Thoughts (2 Viewers)

[ffernn]

does anyone have any resources for ec question practice? if so where bcos the only one i have is the one our teacher gave as a sample on studentsonline but i need a bit more practice

According to my old Software teacher who did consulting for the new curriculum, there's quite a lot of new content compared to IPT but old exams should still be helpful-ish.
There's a "Familiarisation" exam online if you haven't done it yet, link is at the bottom of the "Enterprise Computing Year 11-12 Syllabus" page on the curriculum website (I don't have link perms )

 

[Socialism]

does anyone have any resources for ec question practice? if so where bcos the only one i have is the one our teacher gave as a sample on studentsonline but i need a bit more practice

According to my old Software teacher who did consulting for the new curriculum, there's quite a lot of new content compared to IPT but old exams should still be helpful-ish.
There's a "Familiarisation" exam online if you haven't done it yet, link is at the bottom of the "Enterprise Computing Year 11-12 Syllabus" page on the curriculum website (I don't have link perms )

Familiarisation page:
https://fam.hsconline.nesa.nsw.edu.au/

I'd also highly recommend the course specs
https://curriculum.nsw.edu.au/file/01e8fca3-59d7-4c5e-900b-1db5d36e4198/enterprise-computing-11-12-higher-school-certificate-course-specifications.pdf

Find all of these resources on NESA's syllabus, teaching and learning page @
https://curriculum.nsw.edu.au/learning-areas/tas/enterprise-computing-11-12-2022/teaching-and-learning

 

[lolcti]

does 6'2 work

yaveen that is too short!!!

 

[en1411]

anyone have tips on system flow chart🫠🫠 cant seem to grasp onto them for the life of me

 

[Socialism]

anyone have tips on system flow chart🫠🫠 cant seem to grasp onto them for the life of me

i would be able to help but they removed them from the software syllabus when they jumped from sdd to se
have you seen the course specifications?

Familiarisation page:
https://fam.hsconline.nesa.nsw.edu.au/

I'd also highly recommend the course specs
https://curriculum.nsw.edu.au/file/01e8fca3-59d7-4c5e-900b-1db5d36e4198/enterprise-computing-11-12-higher-school-certificate-course-specifications.pdf

Find all of these resources on NESA's syllabus, teaching and learning page @
https://curriculum.nsw.edu.au/learning-areas/tas/enterprise-computing-11-12-2022/teaching-and-learning

 

[Tony Stark]

@Tony Stark @bigupsanky @yaveen @Holdtlv @aryan12543 @aykayz07

greetings

Hello!

There will certainly be excel questions, with cell substitution in functions. Probably a UI/UX question, either designing some sort of flowchart or labelling a diagram. I dread the definition questions, but that is just memorisation. I think it will be basically like the familiarisation and the trials, so that makes excellent study material in terms of past papers.

Apparently the textbook is out, so if you have $$$ maybe that could also work (upload to bos pls pls).

 

[alphxreturns]

Hello!

There will certainly be excel questions, with cell substitution in functions. Probably a UI/UX question, either designing some sort of flowchart or labelling a diagram. I dread the definition questions, but that is just memorisation. I think it will be basically like the familiarisation and the trials, so that makes excellent study material in terms of past papers.

Apparently the textbook is out, so if you have $$$ maybe that could also work (upload to bos pls pls).

i got the physical but not pdf... sorry

 

[yaveen]

anyone have tips on system flow chart🫠🫠 cant seem to grasp onto them for the life of me

system flow charts?

ive never learnt them
im sooooooo cooked for them
so so cooked
sooooooooooooooooooooooooooo cooked
deep fried
kfc level
burnt
carbon
sun

 

[bigupsanky]

i just gots to memorise the defos of terms and i should be fine. diagrams arent too big of a problem. Also when do i use absolute referencing stuff in excel (like for e.g. $E5 or E$5) such as in the familiarisation question

 

[alphxreturns]

Also when do i use absolute referencing stuff in excel (like for e.g. $E5 or E$5) such as in the familiarisation question

was this a question or just a note for u to memorise

 

[bigupsanky]

was this a question or just a note for u to memorise

a question bro

 

[en1411]

i just gots to memorise the defos of terms and i should be fine. diagrams arent too big of a problem. Also when do i use absolute referencing stuff in excel (like for e.g. $E5 or E$5) such as in the familiarisation question

when theres likes a separate table on that sheet asking you to use the values in it. its like to "lock in" the values because if you use the values from that separate table in your formula and you drag it down to see if the formula works the numbers will change or it'll be an error

sorry if explanation is off, lowk hard. its a lot easier when you actually do it. i find excel exercises online to practice excel formulas

by separate table i mean this, the wage is in a different section to the rest of the stuff

$A1 Column is locked, row moves
A$1 row is locked, column moves
$A$1 whole cell is locked

 

[bigupsanky]

yea ik how the cells/rows/columns get locked, i just have a doubt like you know in the ss when ur multiplying b5 and d2, why cant b5 be locked like d2 or have its column locked. something like that.

when theres likes a separate table on that sheet asking you to use the values in it. its like to "lock in" the values because if you use the values from that separate table in your formula and you drag it down to see if the formula works the numbers will change or it'll be an error

sorry if explanation is off, lowk hard. its a lot easier when you actually do it. i find excel exercises online to practice excel formulas

by separate table i mean this, the wage is in a different section to the rest of the stuff View attachment 49929

$A1 Column is locked, row moves
A$1 row is locked, column moves
$A$1 whole cell is locked

 

[en1411]

yea ik how the cells/rows/columns get locked, i just have a doubt like you know in the ss when ur multiplying b5 and d2, why cant b5 be locked like d2 or have its column locked. something like that.

if you lock B5, excel would always use monday’s hours for every row instead of changing to the next day’s hours, so only D2 is locked since that value stays the same for all rows

 

[bigupsanky]

and what about locking the column, that would be most efficient right? i remember once when i was using these formulas and i didnt lock one of the cell in the particular column and copied the formula down, it multiplied the locked cell with C6, D7 and so on if you get what im saying

if you lock B5, excel would always use monday’s hours for every row instead of changing to the next day’s hours, so only D2 is locked since that value stays the same for all rows

 

[Tony Stark]

and what about locking the column, that would be most efficient right? i remember once when i was using these formulas and i didnt lock one of the cell in the particular column and copied the formula down, it multiplied the locked cell with C6, D7 and so on if you get what im saying

Just think about what needs to stay the same and what needs to change. If I'm referencing, say, a fixed cost, then I will have to use absolute reference for both column and row. If I'm using different pay rates for different days, then the day column needs to change, and the row stays the same (the day changes, but nothing else). Does that make sense? This may be a bad explanation.

See here for reference: https://edu.gcfglobal.org/en/excel/

 

[bigupsanky]

Just think about what needs to stay the same and what needs to change. If I'm referencing, say, a fixed cost, then I will have to use absolute reference for both column and row. If I'm using different pay rates for different days, then the day column needs to change, and the row stays the same (the day changes, but nothing else). Does that make sense? This may be a bad explanation.

See here for reference: https://edu.gcfglobal.org/en/excel/

thanks that helps