Higher Computing Science – Week 12 Work

Past Paper Practice

Complete the following questions from the exam paper on Teams:-
Section II
Q12 on pages 14 – 16
Remember of you are stuck, please contact your teacher using the channel in teams or via email.

S4 Computing Science – Week 12 Work

Computer Systems

Concepts covered:- Translators
Read page 9 of the theory notes and watch the recorded lesson.
Complete the following questions from the homework booklet:-
Q18b & 19 on page 7
As always, if you are stuck with anything then get in touch with your teacher via the class channel in MSTeams or contact them directly via email.

S3 Computing Science – Week 12 Work

Databases
Concepts covered:- SQL EQUI-JOIN, Search Engines, Testing & Evaluation
Read page 9-11 of the theory notes and watch the recorded lesson.
Complete the following questions from the homework booklet:-
Q2f on page 7
Q6di on page 15
Q6dii on page 16
As always, if you are stuck with anything then get in touch with your teacher via the class channel in MSTeams or contact them directly via email.

S1/2 ICT – Week 12 Work

Computational Thinking Revision

The assignment this week should be submitted by Thursday the 1st of April. It is a VERY quick assignment to get done!
This week you should:
  1. Watch the theory video for “Computational Thinking Revision”. This is in the Files tab in the General Channel, then in our new Computational Theory folder.
  2. Complete a practical lesson of your choice from the groups “Sequencing”, “Loops” or “Conditionals” at https://studio.code.org/s/express-2020 . There is also a video in the Computational Theory folder to help you do this. Make sure you have proof that you have finished (this can be a screenshot, photo from a phone or sharing link)! Choose whichever ones you’d like, I’d recommend the Minecraft ones!
  3. Complete the worksheet below “12. ComputationalThinkingRevision.pdf”.
  4. Submit the proof of your code.org task and the worksheet for this Assignment.
Please let your class teacher know as soon as you have any questions, they will be able to help you.
Remember also that we have our weekly drop-in, where you can get help too.

Higher Computing Science – Week 11 Work

Complete the following questions from the exam paper:-
Section II
Q10 & 11 on pages 8 – 13
Remember of you are stuck, please contact your teacher using the channel in teams or via email. The weekly tutorial is cancelled this week as you are expected to attend school periods 3 & 4 to continue with essential practical work practice.

S4 Nat 5 Computing Science – Week 11 Work

Concepts covered:- Representing Text & Graphics in Binary
Read pages 4 – 8 of the theory notes and watch the recorded lesson.
Complete the following questions from the homework booklet:-
Q6 & 7 on page 3
Q9 & 10 on page 4
As always, if you are stuck with anything then get in touch with your teacher via the class channel in MSTeams or contact them directly via email. You can also join the weekly tutorial if you wish on Friday period 1.

S3 Computing Science – Week 11 Work

Concepts covered:- SQL – UPDATE & DELETE
Read pages ( & 10 of the theory notes and watch the recorded lesson.
Complete the following questions from the homework booklet:-
Q1di & dii on page 3
Q1e on page 4
Q3a & b on page 8
Q3d on page 9
Q8ai on page 19
Q8aii & 8bi on page 20
Q8bii on page 21
As always, if you are stuck with anything then get in touch with your teacher via the class channel in MSTeams or contact them directly via email. You can also join the weekly tutorial if you wish on Friday period 2.

S1 & S2 ICT – Week 11 Work

This week you should:
  1. Watch the theory video for “Writing Pseudocode With IF Statements”. This is in the Files tab in the General Channel, then in our new Computational Theory folder.
  2. Complete the practical lesson “11. IF/Else with Bee” and “12. While Loops with the Farmer” at https://studio.code.org/s/express-2020 . There is also a video in the Computational Theory folder to help you do this. Make sure you have proof that you have finished (this can be a screenshot, photo from a phone or sharing link)!
  3. Complete the worksheet below “11. WritingPseudocodeWithIFStatements.pdf”.
  4. Submit the proof of your code.org task and the worksheet for this Assignment.
Please let your class teacher know as soon as you have any questions, they will be able to help you.
Remember also that we have our weekly drop-in, where you can get help too.

Higher Computing Science – Week 10 Work

Complete the following questions from the mock exam paper provided in MSTeams:-
Section I
Q1 – 3 on page 2
Q5 – 6 on page 4
Q7 – 8 on page 5
Q9 on page 6
Remember of you are stuck, please contact your teacher using the channel in teams or via email. The weekly tutorial on Thursdays at 11 can also be used to obtain assistance.

S4 National 5 Computing Science – Week 10 Work

Concepts covered:- Representing Real Numbers in Binary
Read page 3 of the theory notes and watch the recorded lesson.
Complete the following questions from the homework booklet:-
Q5 on page 2
As always, if you are stuck with anything then get in touch with your teacher via the class channel in MSTeams or contact them directly via email. You can also join the weekly tutorial if you wish on Thursday at 9am.