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

Intro - Spreadsheets

What am I Learning today?

I am learning how to identify the different parts of a spreadsheet eg. row, cells, and cell references
I am learning how to use formatting techniques in a spreadsheet

Knowledge Organiser

×

Lesson

Task 1 - Getting Started - Starter Activity Click to see more

  • Fill out the Starter Avtivity sheet' 'Olympic medals' you have been given..

    To download a copy of the sheet click on the image below


  • Task 2 - Learning Journal Click to see more

    To download the Learning Journal for this terms topic click on the image below


  • Now save your Journal into your One Drive account with the title

    'Your Name - Information Systems'

    to a folder called - Information Systems


  • Task 3 - Spreadsheet Basics Click to see more

    How spreadsheets work


    A spreadsheet appears as a grid - each row has its own number and each column its own letter. This labelling of rows and columns is used to give each cell a unique cell reference

    e.g. C5 means column C, row 5.

    It is also possible to refer to a range of cells collectively, ie E4:E12 includes E4, E12 and all of the cells in-between.

    Cells can contain numbers, text or formulae.

    Click on the image above to download the Keyword definition presentation.


    Complete the keyword definitions in your Learning Journal


    Task 4 - Modifying Cells Click to see more

    Pixel Art

    1. You will need to create a new spreadsheet file
    2. Click on the image below to download the Pixel Art Flag challenge


    Task 5 - Extension Task Modifying Cells Click to see more

    Pixel Art

    See if you can create your own flags in your spreadsheet worksheet

    Try making some of the Spreadsheet friendly flags



    Task 6 - 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 identify the different parts of a spreadsheet eg. row, cells, and cell references

    • I have a basic understanding of how I can identify the different parts of a spreadsheet eg. row, cells, and cell references with a little help from my teacher
    • I can show my teacher that I can identify the different parts of a spreadsheet eg. row, cells, and cell references without their help.
    • I can identify the different parts of a spreadsheet eg. row, cells, and cell references 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