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 Leavers – what happens to my school accounts when I leave?

Jul 092020
 

When  you leave, your Google and j2e accounts will be removed.

Want to keep using Google and j2e?

  • If you still want to use these great tools, then you can set up your own accounts (with your parents’ permission).
  • For j2e, go to j2e.com and sign up for a free trial or “sign in with Google” if you have a Google account.  Last time I checked with j2e, they said that it carries on after the “free trial”

Want to keep some of your work?

  • You might want to print or download some of your favourite work from Google or j2e before the end of term.  Please don’t download or print anything involving other people, just your own work.

Questions?

Please use the comments below if you have any questions.

Y3 LF: Bar chart in j2e5 (1) – Around the World

Apr 202020
 

Activity 1 – Make a table

  1. Start a new j2e5 page
  2. Make a new table   with 1 column and 7 rows
  3. Copy this information into your table
    1. (Continent)            Million people
    2. Africa                        1276
    3. Antarctica                0.002
    4. Asia                           4561
    5. Europe                       746
    6. North America          583
    7. Oceania                        42
    8. South America           424
  4. Save the page as:  World information

Figures from Wikipedia

**Why might the numbers be different from the ones I have given above?

** Look at this live World Population Counter

 Video instructions for Activity 1

Activity 2 – create a bar chart

  1. Create a bar chart from your table by selecting it (click on top left box) and clicking the graph button 
  2. Move the table and bar chart next to each other.
  3. Add the following title:

  4. A bar chart to show how many million people live in each continent.

Video instructions for Activity 2

Activity 3 – Make a poster

  1. Add a picture of  the world’s continents
    1. I have shared a blank one that you could label
  2. Add a title: The continents of the world
  3. Add some facts, for example from these websites:
    1. https://www.q-files.com/geography/
    2. https://www.kids-world-travel-guide.com/continent-facts.html

Video instructions for Activity 3

Activity 4 – Finish your poster

  1. Make the page into an attractive poster – fill the page, addnore pictures and information.
  2. Success criteria
    1. Fill the page
    2. Graph and chart together
    3. Fact box
    4. Big title
    5. Even spacing – no big gaps or squashed items

Follow on activities

1 Cool text

When you have checked the success criteria, then you could do this extension task to make a more interesting title.

  1. Go to https://cooltext.com/
  2. Choose a suitable style
  3. Type “Continents of the World”
  4. Change settings – you can choose a better font here too
  5. Drag onto your j2e5 page instead of your title

Activity 5 Perfecting your poster

For a perfect poster, make sure:

  • lots of pictures and information filling the page
  • things are spread evenly – no big gaps or squashed bits
  • gaps between things the same

More pages

Add a page to your file by clicking on the  in the bottom right corner of your page. You could make a page about:

  • one of the continents
  • the land area of the continents including another table and graph
  • information about the sea and oceans
  • a table and chart of highest mountains of the world, longest rivers, etc

Day 1 challenge

Mar 232020
 
  • Use any drawing tools in j2e5 to make a picture out of this scribble
  • Rules
    • Only take 5 minutes
    • Scribble must be still visible
    • Scribble must be part of the picture
    • Put your first name on your picture if you are happy for it to be shared

If you have an iPad, you could use the free j2launch app.

Well done to those that had a go – here are the pictures!

Y3 Create a mix page in JIT5

Jul 012019
 
  1. Look at the Autumn Days words below – can we come up with some lines for a Summer Days song?
  2. In JIT5
    1. Create an Animate page and Save
    2. Create a Mix page – select animation and text below
    3. Load animation into mix page

Animation

  • Make a simple background
  • Characters
    • Draw a character (big) – create a stamp
    • OR use a picture from the list
  • Animate

Autumn Days

Autumn days when the grass is jewelled
And the silk inside a chestnut shell.
Jetplanes meeting in the air to be refuelled.
All these thing I love so well

So I mustn’t forget
No, I mustn’t forget.
To say a great big
Thank You
I mustn’t forget

Clouds that look like familiar faces
And the winters moon with frosted rings.
Smell of bacon as I fasten up my laces
And the song the milkman sings

Whipped-up spray that is rainbow-scattered
And a swallow curving in the sky
Shoes so comfy though they’re worn out and they’re battered
And the taste of apple pie.

Scent of gardens when the rain’s been falling
And a minnow darting down a stream
Picked-up engine that’s been stuttering and stalling
And a win for my home team.