THS Technologies Faculty

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.

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.

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.

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.

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.