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

Using Data

What am I Learning today?

I am learning how to use a speadsheet to create a Graphical User interface
I am learning how to use one parameter function e.g. MIN, MAX
I am learning how to use SUM and/or the Autosum feature

Knowledge Organiser

×

Lesson

Task 0 - Hand in your Powerpoint Click to see more

  • Open the PowerPoint that you were using for the last three last weeks lessons

  • Save it into the following folder

  • -> Year 8 Common Area

    -> You can only Save here

    -> Computer Science

    -> Your Class folder e.g. 8G...

    -> Unit 1 - Spreadsheets

  • Save it as your Username e.g. 22ChallenorL


  • Task 1 - Practicing Charts Click to see more

  • Lets practice creating a chart like we did in last weeks lesson

  • Click on the image below and complete the hogwarks 1st Year O.W.L.S results speadsheet

  • Make sure you save a copy of this as you will need a copy of this worksheet to put into into your user interface workbook?


  • Task 2 - Practicing Formulae Click to see more

  • Lets practice using some formaulae and functions

  • Click on the image below and complete the hogwarks shopping list formula speadsheet

  • Instructions


    Task 3 - More Practice Click to see more

  • Lets extend our learning for formaulae and functions

  • Click on the image below and complete the Hogwalks Express Worksheet


  • Task 4 - Creating a User Interface Click to see more

    Creating a User Interface using images and hyperlinks

  • We are going to create a worksheet called 'menu' in a new workbook. The first thing we must do is make sure we rename our worksheet called 'Sheet1' to 'menu'

  • Now we can start formatting our menu page so that is looks like a proper User Interface.


  • Task 5 - 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 speadsheet to create a Graphical User interface

    • I have a basic understanding of how I can use a speadsheet to create a Graphical User interface with a little help from my teacher
    • I can show my teacher that I can use a speadsheet to create a Graphical User interface without their help.
    • I can use a speadsheet to create a Graphical User interface 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: modelling

    Student_Comment_1 not found

    Task Notes/Comments - Add here Click to see more

    Comments/Notes

    Copyright © 2013 - 2025 LearnITwithMrC