S3 Computing Science – Week 10 Work

Concepts covered:- SQL – SELECT & INSERT
Read pages 9 & 10 of the theory notes and watch the recorded lesson.
Complete the following questions from the homework booklet:-
Q8c 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 Thursday at 10am.

S1 & S2 ICT – Week 10 Work

This week you should:
  1. Watch the theory video for “Writing Pseudocode With Loops”. This is in the FIles tab in the General Channel, then in our new Computational Theory folder.
  2. Complete the practical lesson “6. Loops with Rey and BB-8” and “7. Sticker Art with Loops” 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 “10. WritingPseudocodeWithLoops.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 9 Work

Concepts covered:- Implications
Read pages 11-13 of the theory notes and watch the recorded lesson.
Complete the following questions from the homework booklet:-
Section I
Q4 on page 3
Q10 on page 5
Q11 on page 5
Section II
Q1 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. You can also join the weekly tutorial if you wish on Thursday at 11am.

S4 Nat 5 Computing Science – Week 9 Work

New Topic – Computer Systems!!!

Concepts covered:- Representing Whole Numbers in Binary
Read pages 1 & 2 of the theory notes and watch the recorded lesson.
Complete the following questions from the homework booklet:-
Q1-4 on page 1
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 at 9am.

S3 Computing Science – Week 9 Work

Relational Databases

Concepts covered:- SQL Designs
Read pages 9 & 10 of the theory notes and watch the recorded lesson.
Complete the following questions from the homework booklet:-
Q2e on page 5
Q6c on page 15
Q8d on page 22
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 10am.

S1 & S2 ICT – Week 9 Work

Writing Pseudocode

This week you should:
  1. Watch the theory video for “Writing Pseudocode”. This is in the Files tab in the General Channel, then in our new Computational Theory folder.
  2. Complete the practical lesson “2. Programming with Angry Birds” and “3. Debugging with Scrat” 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 “8. WritingPseudocode.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.

S1/2 ICT – Week 8 Work

Welcome to our new Computational Thinking unit!
There are plenty of new videos to make sure you’re on the right track.
This week you should:
  1. Watch the theory video for “Introduction To Programming”. This is in the Files tab in the General Channel, then in our new Computational Theory folder.
  2. Complete the practical lesson “1. Dance Party” 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 “8. IntroductionToProgramming.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.

S3 Computing Science – Week 8 Work

Concepts covered:- Structured Query Language, (SQL)
Watch the recorded lesson which explains what SQL is and then it shows you how to create an account on Codecademy, (Codecademy.com). NOT CODECADEMY PRO
Create an account
Work through the SQL exercises
Upload a photo of your progress once you’ve completed the exercises
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 10am.

S4 Nat 5 Computing Science – Week 8 Work

Concepts covered:- Documentation, Evaluation & Maintenance
Read pages 12 & 13 of the theory notes and watch the recorded lesson.
Then complete then following questions from the homework booklet:-
Q7a & b on page 4
Q12 on page 6
Q16 on page 8
Q22ci & cii on page 19
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 at 9am.

Higher Computing Science – Week 8 Work

Read the systems theory notes, watch the recorded lessons then try the following questions from the homework booklet.
Topics Covered:- Computer Structure & The Fetch Execute Cycle
Complete the following questions
Section I
Question 2 on page 2
Question 6 on page 3
Question 8a on page 4
Question 8b on page 5
Question 9 on page 5
Question 14 on page 6
Section II
Question 2ai on page 7
Question 2aii on page 8
Question 3 on page 8
Question 4 on page 9
Question 5a on page 10
Question 5c on page 11
Question 5d on page 12
Question 6a on page 12
Any issues please don’t hesitate to contact me via MSTeams, email or during the weekly tutorial on Thursday at 11.