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?

Y6 LF Create a database

May 162022
 
  1. Typing
  2. What is a Thunderstorm?
    1. https://www.bbc.co.uk/bitesize/topics/z6hv9j6/articles/zcx7dp3
    2. https://www.lightningmaps.org/
  3. Lunar eclipse
    1. https://www.bbc.co.uk/newsround/49000228
    2. https://www.earthspacelab.com/app/eclipse/
  4. Make a database
  5. Go to j2launch
  6. Decide on a topic:
    • animals, endagered animals, african animals, British birds,…..
    • countries, rivers, cities,
    • sportspeople
  7. Define tab – set up your fields
    1. Must have
      1. at least 2 number fields
      2. Picture field
    2. Could have
      1. Boolean = tick box
      2. Website link to more info (in a text field)
      3. Sound
  8. At least 5 records completed today
    1. 5 = ready to learn
    2. 10 = good job
    3. 15 = superstar

Y6 LF Code a Scratch game (3)

Apr 252019
 
  1. Darkness
    1. variable counting down
    2. Background brightness effect
  2. Movement
    1. follow mouse?
    2. arrow keys?
    3. left-right-jump? (+ platforms?)
  3. Lights out
  4. Disable movement at 0

Computational thinking

  1. Don’t panic! Understand the problem
    1. Game brief
    2. Q and A
  2. Simplify! (decomposition)
    1. Pick ONE part at a time
      1. Sky going dark
      2. Sprite moving UDLR
      3. Turn off lights when touched by sprite
  3. De ja vu?
    1. Have we done anything similar before?
    2. What Scratch blocks do you remember?
  4. Create a plan – algorithm
  5. Have a go…!

Game brief

A game company would like you to make a WW2 blackout themed computer game featuring, the landscape of a UK city threatened by the Blitz.  The aim is to put up blackout curtains in the daytime before nightfall so that the bombers will pass harmlessly overhead during the night.  Successive screen will become harder with more windows to cover and bigger buildings.  Wardens will be patrolling.  You may have to find or buy blackout material.  Depending on how completely you blackout the city, bombs will fall.  How long can you keep your city from being destroyed – a percentage score could drop after each night of bombing….

 

Y6: LF: Create a Google form (1)

May 182018
 

LF: Explore Google Forms

  1. Go to Google Drive
  2. Click NEW, More then Google forms
  3. Explore as many tools and options as you can, including:
    1. Naming the form
    2. Changing the theme
    3. Trying each question type
    4. Adding sections and titles

LF: Plan your research project

  1. Think about what you would be interested in finding out by doing a survey.  I can get children in Year 6 to complete the surveys.
  2. Think carefully about:
    1. What questions to ask
    2. Which type of question
    3. What data you want – words, sentences, numbers,…
    4. Do you need names?
  3. Design your form

Looking after data – by doing a survey, you have a responsibility to look after people’s information safely.  How do you think you should do this?

LF: Share your form

  • Allow anyone at St Mark’s to view your form
  • Find and copy the share link for your form
  • Fill out this form to share your form information

Y6 Yearbook and Music Survey

May 112018
 
  1. Fill out the Y6 Yearbook Form
  2. Please fill out this survey to help Wiltshire Council provide better services for music education (especially for those in Y7 next year…).
  3. Typing practice
  4. If you have time, practice some Maths or English skills