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?

T5 Y6 Creating a database in j2e

Apr 192023
 

Activity 1 – explore a database

  • In j2launch, click on j2data  
  • The database 
  • Then examples 
  • Look at some of the different databases: dinosaurs, Titanic passengers, countries or minibeasts.
  • Look at the different tabs:
    • Define – how it is set up – each category of information is called a field
    • Form – is like a record car or top trump that contains all of the information for one record – this is how you add a new tiem in the database.  You can order and search the records.
    • Table – you guessed it – lists the information in a table – good if you want to see it all at a glance.  You can sort the data by clicking on column headings.
    • Chart  – allows you to draw graphs comparing the data of all the items.  Only useful if records have numerical (number) data.   You can alse use the search to restrict results to items containing that search word.
    • Options
  • What can you find out from searching, ordering or drawing graphs of the data?  Have a go at answering these questions: enter your answers in theis Google form

 Countries

  • Which is the smallest country? (Form tab, Sort by area)
  • Which has the second lowest population (Form tab, sort by population)
  • What is the 10th country  in alphabetical order (Table tab, sort by name row by clicking on Country Name)
  • Do big countries have big populations (Chart tab, options below with scatter chart)
  • Ask and answer your own question

Dinosaurs

      • What is the longest dinorsaur?
      • Which are the first dinosaurs?
      • What proportion were carnivores? (pie chart)
      • Ask and answer your own question.

Minibeasts

      • How many have more than 6 legs?
      • Ask and answer your own question.

Titanic passengers

      • How many people survived?
      • Who was the youngest survivor? (I’ve met her!)
      • Roughly what fraction of men survived?  What fraction of women survived?  (chart – see options below)
      • Ask and snawer two questions of your own.

Activity 2 – Plan your database

  • Think of a topic that you could make a database about:
  • Good examples are
    • animals from a particular habitat or family, eg birds of prey, whales, Amazon animals
    • sportspeople eg from a partiular sport
    • geographical – countries, cities, rivers, mountains
    • engineering – buildings, bridges, ships, cars
    • It may involve research – reading books, searching for information – find one good website
    • You will need at least 20 records and 5 fields (pieces of information) – 3 of them numbers/dates
    • Something you could find interesting informations, patterns by asking questions of your database.
  • What fields will you need?

  • Start a new database
  • Add fields in the Define tab
  • Don’t forget to save frequently.

Activity 3 – Populate your database

  • Add new records and fill them in.
  • Read up or research to find more records and inforamtion.
  • Try and get as wide a range of items on the topic as you can.
  • Don’t forget to save frequently.

Activity 4 – interrogate your database

  • Think about some questions you could find out about your database.
  • Create a j2e5 page with questions and the answers that you found from your database.
  • Can you copy graphs and charts from your database to j2e?

Y6 LF Populate your database

Jun 062022
 
  • Define tab
    • check you have all the fields that you need
    • make sure you have included units
  • Add records
    • add as many records to your database as possible
    • target 20 – 30

Next steps

  • What questions could you answer using your database, eg putting things in order, finding biggest/smallest/oldest….?
  • What graphs could you draw to show information from your database?
  • Can you show links between fields eg age and number of goals?

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

Y4T5 Mindmaps

May 092022
 

Activity 1 – Video: What is a mindmap?

Activity 2 – Explore Coggle tools

  • Explore the tools on Coggle by making a mind map called The World
    1. Go to Google Drive
    2. New – more – Coggle
    3. Name the central idea: The World
    4. Add main branches for the continents
    5. Add two countires as next branches for each continent (apart from Antarctica)
    6. Add some more branches – maybe cities or famous things about each country

Video instructions for activity 2

Activity 3 – Mind map from a text

  • Create a mindmap about…

Antarctica

Acrivity 4 – talk it through

The tes of a good min map is if you can use it to tell someone else about the subject or even better use it to remember the facts without having to look at it.

  1. Read your mind map several times
  2. Tell someone about Antarctica including all of the facts using your minmpa as a prompt.
  3. Turn your mind map over and see if you can remember the facts.
  4. Try again in a few days time – can you still remember the facts?

Activity 5 – beautify your mindmap

  1. Tidy up your mind map by dragging branches
  2. Try to make it
    1. compact – no big gaps
    2. fit the screen in a rectangle
  3. Add symbols
  4. Add pictures
    1. In Google
      1. Search for a simple picture – should be very simple, use the word “icon” or “clipart” in your search
      2. Save image as…
    2. In Coggle
      1. When typing, click the picture icon and find your picture on your computer
      2. Change the code at the end to 50×50 so your picture is small
  5. Look at a WAGOLL

Activity 6 – Success criteria

  • Information in correct branches – read your mind map to check it makes sense
  • Branches growing in one direction – not toopy
  • Branching/splitting – not one long line
  • Compact – fits the screen
  • Simple pictures – not photos

Activity 7 – Saving to j2e

  • Click download – image
  • Right hand click – copyvimage
  • Go to a new j2e5 page
  • Make it landscape and 50%
  • Paste – Ctrl-v
  • Make your mindmap as big as possible on your page , crop any spare
  • Save as “Antartica mind map”

Other topics:

The planets

Why are rivers important?

Follow on activities

  1. Add more information, pictures and symbols to you mind map
  2. Create a new mind mpa about another topic
  3. How many of these Coggle tools did you use?
    1. Resize text by dragging
    2. Add and delete branches
    3. Add a picture
    4. Add symbols
    5. RH-click to get branch options

15 Creative Mind Map Examples for Students

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

Y4 LF How can I use j2Data – Branch to classify items scientifically?

Jun 062021
 

101 things to do with j2e – #10 Create a branching database in JIT

Teacher demo

We will use Branch, part of JIT to make branching keys.

  • Log into j2e
  • Go to “my files” then “shared files”.  Open River Animals
  • Click “sort” then make up Yes/No questions to sort the animals.
  • Adding more animals
    • When it tells you that your diagram is complete:
      • Play it to test it out
      • Add a new animal
        • Think of a new animal – you could use this website to help find new animals: A spotter’s guide to waterway wildlife 
        • Play the game and answer the questions
        • At the end say “no” then “yes” (you want to add it to the list)
        • Search using the world button and drag a picture into the box (use .png in your search to get a picture without a backgound)

  • Woodland Animals
  • Make sure you are in “advanced” mode
    • Click “sort” then make up Yes/No questions to sort the animals.
    • You could use this information sheet or fact sheets to help you or more detailed information from the Woodland Trust
    • Adding more animals
      • When it tells you that your diagram is complete:
        • Play it to test it out
        • Add a new animal
          • Think of a new animal and play the game and answer the questions
          • At the end say “no” then “yes” (you want to add it to the list)
          • Search using the world button and drag a picture into the box
  • Birds of Prey 
    • Use the RSPB website to find a fact about each bird and enter it into the description box.
    • Now make up Yes/No questions to classify the birds in a branching key.
    • Follow the instructions in the Woodland Animals above, to add more birds.
  • What else apart from animals could you classify using Branch?

Greek Gods

Use the fact cards on your desk to

  • find out about the Greek Gods
  • use yes/no questions to split them into groups

Make a branching key in j2branch to sort the 12 Greek gods.

  • Is a brancing key a good way to learn about the Greek Gods?  Why?  Why not?
  • What would be a better way?
 Older Entries