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

Making profit

What am I Learning today?

I am learning how to use a spreadsheet to model a variety of outcomes

Knowledge Organiser

×

Lesson

Task 1 - Test Preperation Click to see more

    Click on the image below to open the test preperation task


  • Can you copy this worksheet into your user interface workbook?


  • Task 2 - Understanding filtering Click to see more

  • Click on the image below to open the 'Filtering Practice document'.


  • Follow the instructions in the video


  • Task 3 - Hogwarts Challenge Click to see more

  • Complete the Hogwarts HousePoint challenge


  • When you are ready click on the image below to face your final challenge


    Task 4 - Reviewing it all Click to see more


    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 need to learn how to use a spreadsheet to model a variety of outcomes

    • I have a basic understanding of how I can use a spreadsheet to model a variety of outcomes with a little help from my teacher
    • I can show my teacher that I can use a spreadsheet to model a variety of outcomes without their help.
    • I can use a spreadsheet to model a variety of outcomes 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


    Task 5 - Extension Challenge Click to see more

    Complete the Challenge below using the challenge sheet of your filttering document.

    1. Click the Challenge tab in the bottom-left of the workbook.
    2. Apply a filter to show only Electronics and Instruments.
    3. Use the Search feature to filter item descriptions that contain the word Sansei. After you do this, you should have six entries showing.
    4. Clear the Item Description filter.
    5. Using a number filter, show loan amounts greater than or equal to $100.
    6. Filter to show only items that have deadlines in 2016.
    7. When you're finished, your workbook should look like this:

    My Notes: modelling

    Student_Comment_1 not found

    Task Notes/Comments - Add here Click to see more

    Comments/Notes

    Copyright © 2013 - 2025 LearnITwithMrC