Computer Science LearnITWithMrC ⛯ Year 7 Year 8 Year 9 GCSE
Responsive image

Assessment

What am I Learning today?

I have completed the Assessment

Knowledge Organiser

×

Lesson

Task 1 - Getting Organised - Excel Click to see more

  1. Set your Learning Objectives to red.

  2. We are going to answer the questions for the assesment in the Excel Workbook below.

    3. To download the Workbook click on the image below


  3. Save your Excel as "your name" in the shared area folder for your class

    .

Task 2 - Task 1 Click to see more

Crack the code

  • Go to the sheet called Task 1 like the image below and try and decrypt the coded message.

    • Use the Ceaser Cipher tool, click below.

    Ceaser Cipher Tool

    Task 3 - Task 2 Click to see more

    Crack the code

  • Go to the sheet called Task 2 like the image below and try and decrypt the coded message.

    • Use the Ceaser Cipher again.

    Ceaser Cipher Tool

    Task 4 - Task 3 Click to see more

    Crack the code

  • Go to the sheet called Task 3 like the image below and try and decrypt the coded message.

    • Remember to use the Key over and over until all the letters are decoded

    Task 5 - Task 4 Click to see more

    Crack the code

  • Go to the sheet called Task 4 like the image below and try and decrypt the coded message.

    • Click on the button above to use the Frequency analysis tool from lesson 4 to help you.

    Task 6 - Lesson review Click to see more

  • Go to the sheet called Final like the image below and check your score and type in your username.

  • Make sure you have saved your Excel as "your name" in the shared area folder for your class

    .

    • Summing it all up

    Lets look at the learning outcomes and decide which one best describes our current level of understanding :

    Tick the one you feel is closest to your level

    Learning Outcomes I have completed the Assessment

    • I have a basic understanding of how I have completed the Assessment with a little help from my teacher
    • I can show my teacher that I have completed the Assessment without their help.
    • I have completed the Assessment independently and I can also explain it to others and can complete any extension tasks I am given.

    🠜 Now update your learning objectivesClick on the Assessment image

    My Notes: cryptography

    Student_Comment_5 not found

    Task Notes/Comments - Add here Click to see more

    Comments/Notes

    Copyright © 2013 - 2025 LearnITwithMrC