Y5 Spreadsheets 3 – Party budget

May 152023
 
  1. Finish party budget
  2. Multiplication square
  3. Conditional formatting pixel art

The task

  • Imagine you are organising a class party.
  • You need to buy the food but also cups, plates and serviettes
  • You have a budget of £60
  • Design a spreadsheet which will help you work out the costs and experiment to see what you could buy

Steps to success

  1. Set up your spreadsheet
    • Columns: Item, link, pack size, number, cost, total cost,
    • Rows: headings, a row for each item, Grand total, Money left to spend
    • Formulae: total cost and Grand total, money left
    • ** Add more columns/worksheets to compare different supermarkets
  2. Search for items and enter item, links, pack size and costs in your spreadsheet
  3. Experiment by putting different values in the number cells to see what you can afford
  4. Decide on your shopping list and explain your choices.

How did using a spreadsheet make this easier?

Y5 Spreadsheets – investigations

May 022023
 

1 Going up the wall

  1. Open the Going up the wall spreadsheet
  2. Follow the instructions under the wall and write your answers in the boxes

2 Giant multiplication grid

  1. Start a new Google Sheets
  2. In A1 put an X
  3. In A2 to A11 put the numbers 1 to 10
  4. In B1 to K1 put the numbers 1 to 10
  5. You could format your spreadsheet – change text size, change column widths, colour column A and row 1, add grid lines
  6. In B2 put this formula: =A2*B1 (this does 1 X 1 and shows the answer 1)
  7. Copy the formula by selecting it and dragging the corner down
  8. This should give the 1 times table. Is it right?
  9. Can you work out what has gone wrong with the formulae?
  10. Change the formula in B2 to: =$A2*B$1
  11. The $ symbol means that when we copy it doesn;t change the A or the 1
  12. Now copy again to get the 1 times table
  13. Now drag across to get the other times tables
  14. Can you extend your mutliplication grid to be 25 x 25? Even bigger?

Giant multipication grid video

Conditional formatting

  1. Select the range of answers
  2. Conditional formatting:
    • custon formula is
    • =iseven(B2)
    • choose a cell colour
  3. This shoud highlight even numbers

3 1-100 grid

  1. Set up a 1-100 grid
    • Put 1 in the top corner cell A1
    • Put =a1+1 next to it in cell B1
    • Drag this cell to the right up to 10 (cell J1)
    • Put =a1+10 underneath in cell A2
    • Drag this to the right up to J2
    • Then drag this row down
  2. Use conditional formatting to highlight different multiples
    • custon formula is
    • =mod(b2,2)=0 should hightlight multiples of 2
    • choose a cell colour
  3. Screenshot the patterns and paste onto a j2e5 page

Y5 Spreadsheets: Pixel art 2 – conditional formatting

Apr 262023
 
  1. Go to Google Drive
  2. Open the spreadsheet from last week
  3. Scroll down to a clear area
  4. Highlight a whole rectangle for your picture
    • Put a border around it
  5. Whith the area still selected:
    • Click on “Format” – “Conditional formatting”
    • Select the range
    • “Text contains”
    • Type in “r” (for red)
    • Change the fill colour to red
  6. Repeat for “b” (for blue)
  7. Make a Union Jack flag by typing “r” and “b” in the cells

Y5 LF: Edit a spreadsheet in Google Sheets

May 182022
 
  • Go to https://www.ilearn2.co.uk/signin-html/
  • Enter the code on the whiteboard
  • Watch the videos (for Chromebooks/Googe Sheets)
  • Follow the instructions
    • Activity 1 Pixelart
    • Activity 2 Tour de France project
  • At the end of the lesson: Fill out the “How did that go?” form

Y5 LF: Networks and the Internet

Mar 302022
 

http://code-it.co.uk/netintsearch

Lesson 1 – How search works (Planning)

  1. Watch the video about what happens when (and even before) you search
  2. Web spider activity
    1. Pick a common household item, for example: pen
    2. Do a search and make a list including these things (you could use a sheet like this to help you Search sheets):
      1. exactly where you find each item
      2. how many were there (1-5   1= one ….5= lots)
      3. how easy to find (1-5  1= well hidden….5= obvious)
      4. how good quality (1-5  1= not good….5= excellent)
    3. Add up the scores to give each place a total
    4. Put the places in order of their score.
    5. This is now your search index for that item
    6. Who is best at finding things in your house?  Ask them where the best place to find a pen is – do they come up with the same place as your top place on your search index? Why? Why not?  Are there other factors that make a good place to find this item?

Lesson 2 – What is a network? (Planning)

  1. Watch one or both of the videos
  2. A network is a group or system of interconnected prople of things.
  3. What different networks are you part of as a person?
  4. What different networks of things can you think of? (transport, utilities, buildings. body…think of what you could draw a map of)
  5. Choice of activity
    1. In j2e5, create a poster about different types of networks with pictures, text and information – you could draw diagram, insert audio explanations…
    2. Choose two examples of networks and complete a double-bubble map exploring their similarities and differences.  Double bubble map template
    3. Pick three examples of networks and complete an odd one out diagram exploring thier similarities and differences.  Odd one out template
    4. Pick two examples of networks.  Use bridge maps to compare aspects of the networks.

  • What are the things that are connected?
  • Are there different types of things?
  • How are they connected?
  • Are there different types of connections?
  • Who is responsible for the network?
  • Are there rules for the network?
  • Is it free?
  • What can go wrong with the network?
  • What are the consequences?
  • Has the network changed over time?

Lesson 3 – Mapping the school network  (Planning)

Lesson 4 – Connecting the Internet (Planning)

Lesson 5 – Packet game (Planning)

Thanks to Phil Bagge for these great resources!
www.code-it.co.uk

Y5 LF Planning a game – decomposition (2)

May 142018
 
  1. Finish your game plan (Google drive – classroom)
  2. Decomposition means breaking a problem or situation down into simple pieces.  When we are programming, we need to break the game down into simple bits that we program one at a time.
  3. Start with one part of your plan, eg how the main character moves.
  4. Break it down:
    1. Animation, eg walking
      1. Draw two or more costumes
      2. Example walking animation
      3. Make them swap all of the time when the greem flag is pressed.
    2. Controls
      1. Arrow keys
        1. Left – change x by -5
        2. Right – change x by 5
        3. Up – change y by 5
        4. Down- change y by -5
      2. Point int the right direction
        1. Left – point in direction – left
        2. Right – point in direction – right
      3. Rotation style: Left-right
  5. Now choose another element of your plan to work on
    1. Break it down…

Y5 LF Planning a game (1)

May 082018
 

Think…

  1. We are going to plan and create a Greek themed game using Scratch.
  2. Think about some of the stories you have learned about –  Greek gods or heroes.
  3. What stories could you make a game about?
  4. Games could include
    1. Action – running,  jumping,  fighting,  climbing, flying
    2. Questions
    3. Choices
    4. Mazes
  5. Characters (sprites)
    1. Animated (costumes)
    2. Variables – lives, strength
    3. Controls
    4. Main character
    5. Other characters
    6. Other sprites
  6. Screens (Backgrounds)
    1. Title
    2. Instructions
    3. Level 1
    4. More levels

Tasks

  1. Go to Google classroom to find the planning sheet
  2. Start filling it in
  3. Include sketches of characters using drawings
  4. Go to Scratch to remind yourself of how it works
    1. Comment any “How do I …?” questions on Google Classroom

LF Understanding the Internet

May 012018
 
  1. Prezi
    1. http://prezi.com/v7mm9_wuxizf/?utm_campaign=share&utm_medium=copy&rc=ex0share
  2. Packet’s tale
    1. http://viewpure.com/ewrBalT_eBM?start=0&end=0
  3. Mysterious cables
    1. https://www.theguardian.com/technology/2009/oct/23/mysterious-cable-uk-us
  4. Submarine cable map
    1. https://www.submarinecablemap.com/
  5. http://viewpure.com/H9R4tznCNB0?start=0&end=0
  6. Packet game
  7. How do search engines work?
    1. http://www.bbc.co.uk/guides/ztbjq6f#zqdfyrd
  8. BBC KS2 Computer Science
    1. https://www.bbc.com/education/topics/zs7s4wx