Author: gw09lewisdavid@glow

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.