Lower Key Stage 2 - Databases by oneforseven

VIEWS: 0 PAGES: 8

									                                                                        Lower Key Stage 2– Databases
Lower Key Stage 2 - Databases

  About the Unit
  In this unit, children learn to collect and store information involving more than two variables. They
  will use a database to answer simple questions by sorting and finding the top or bottom and
  searching in a single field.
  Children will be introduced to files, records and fields by exploring and comparing computer-based
  data and paper-based information. They will use a computer database, add to it, carry out simple
  searches and produce bar charts.
  Children will apply what they have learnt in this unit when using ICT to handle and present
  information in geography, science, design and technology, and history.
  Prior knowledge:                      Technical vocabulary               Resources
  This unit assumes that children  database                                measuring equipment such
  can:                                   field                               as scales, height measures
   Measure in centimetres with  record                                      and rulers.
      some accuracy and                  file                              a set of paper-based record
      reliability.                       sort                                cards.
   Use different units to               classify                          a computer database with
      measure weight, height and  order                                      the information from the
      other body measurements.           bar                                 record cards
  This unit will be built on in          chart
  Upper Key Stage 2 where:
   electronic databases will be
      used to support study in
      other curriculum areas.
  Expectations

  At the end of this unit

  Most children will: enter data into database with a predetermined structure and use it to answer
  straightforward questions and produce bar charts.

  Some children will not have made so much progress and will: enter data into a database with a
  predetermined structure and find information in it by matching the query to the question.

  Some children will have progressed further and will: enter data into a database with a
  predetermined structure and use it to answer straightforward questions and produce bar charts; turn
  questions into search criteria.




Bristol LEA ICT Scheme of Work
                                                Page 1 of 8
                                                                                                        Lower Key Stage 2– Databases



                    WALT                  WILF                                    Possible Teaching Activities
                 We are              A database        Suggested Lesson
                  learning to          checked for        Recap on previous learning.
                  collect own          plausible data.    Prepare a database (with errors) containing information on some fictional
                  data and enter                           pupils in the class.
                  it into a                               Recap on how to enter the program and select the correct file. Remind the
                  database.                                class how to move through the records.
                 We are                                  Teach the children to add a record to the database. Give the children some
                  learning to                              information and ask them to add a record to the database.
                  check data for                          When the children have completed this, tell them that there might be some
                  accuracy.                                errors in some of the prepared records.
   Lesson 1




                                                          Show the children a few examples of records with incorrect spellings,
                                                           implausible data (e.g. Sam is 130m tall!) and incorrect field types (e.g. „girl‟)
                                                           in a field where „f‟ for female is required).
                                                          Give the class time to locate the errors, show them as a class and edit the
                                                           record where appropriate. Discuss which data cannot be changed (e.g.
                                                           shoe size, height).
                                                         Your Lesson




Bristol LEA ICT Scheme of Work
                                                                 Page 2 of 8
                                                                                                    Lower Key Stage 2– Databases



                    WALT                    WILF                                 Possible Teaching Activities
                 We are                Questions        Suggested Lesson
                  learning to sort       answered from     Recap on previous learning.
                  records in a           information in    Show the children a prepared database and teach them how to sort them
                  database.              the database.      into different fields.
                 Remind the                               Show the children how to sort on different fields.
                  children how to                          Ask the children to sort on different fields to answer questions such as
   Lesson 2




                  answer                                    “what is the heaviest bird?”, “which are the three smallest birds?”
                  questions by                             Remind the class how to turn questions, such as which animals are green?;
                  matching the                              which animal has the most legs?, into appropriate search criteria, such
                  contents of a                             colour field = green or order by field legs.
                  single field.




Bristol LEA ICT Scheme of Work
                                                                 Page 3 of 8
                                                                                               Lower Key Stage 2– Databases



                    WALT                WILF                                Possible Teaching Activities
                                                      Your Lesson




                 We are            Questions        Suggested Lesson
                  learning to        answered          Show the class how to answer questions such as “which houses have 5
                  search a           using specific     rooms or less?” or “which mini beasts have four legs or more?” by
                  database using     searching          searching for records using =< or =>.
                  =< and =>          tools.
   Lesson 3




                  functions.                          Your Lesson




Bristol LEA ICT Scheme of Work
                                                             Page 4 of 8
                                                                                                      Lower Key Stage 2– Databases



                    WALT                   WILF                                   Possible Teaching Activities
                 We are               Questions         Suggested Lesson
                  learning to           answered           Show the class how to use „AND‟ in a search. Ask the children to work in
                  search a              using the           groups to convert questions into search criteria using „AND‟. Ask them to
                  database using        appropriate         check their answers by searching on each criterion separately.
                  „AND‟.                searching tool.    Show the class how to use „OR‟ in a search. Ask the children to work in
                 We are                                    groups to convert questions into search criteria using „OR‟.
   Lesson 4




                  learning to
                  search a                                Your Lesson
                  database using
                  ‟OR‟.




                 We are               A bar that        Suggested Lesson
                                                           Demonstrate how to use the computer database to produce bar charts.
   Lesson 5




                  learning to use       shows findings
                  a database to         clearly.            Discuss the advantages of using ICT to draw graphs, such as accuracy and
                  produce bar                               speed. Divide the children into groups and ask them to create their own bar
                  charts.                                   chart. Ask them to print their bar chart and to write about it. Ask them to
                                                            think of three questions to ask other children about the graph.




Bristol LEA ICT Scheme of Work
                                                                  Page 5 of 8
                                                                                                        Lower Key Stage 2– Databases



                      WALT                   WILF                                  Possible Teaching Activities
                                                           Your Lesson




                   We are               A line graph     Suggested Lesson
                    learning to use       shows findings    Use a set of record cards to demonstrate how a database can produce line
                    a database to         clearly.           graphs. Use data which includes a variable such as time or temperature,
                    produce a line       Talk about         e.g. length of a shadow over time, growth of a child over time.
                    graph.                what the graph    Divide the children into groups and ask them to create their own line graph.
                                          is showing.        Ask them to print their line graph and to write about it. Ask them to think of
     Lesson 6




                                                             three questions to ask other children about the graph.
                                                           Your Lesson




Bristol LEA ICT Scheme of Work
                                                                   Page 6 of 8
                                                                                                 Lower Key Stage 2– Databases



                WALT                   WILF                                    Possible Teaching Activities
           End of Unit Task:                        Suggested Lesson
            Children will use the skills they have  Tell the class that they are going to create a database containing
             learnt in this unit.                     information on each child in the class. Ask them to think of some questions
                                                      they would like to ask, such as: how many children have brown eyes?; who
                                                      is the tallest in the class? Encourage them to think of questions which
                                                      require numerical and non-numerical data.
                                                     Divide the children into pairs and discuss the specific information that they
                                                      need to collect. Explain the structure and ask the children to measure and
                                                      record their personal information on a record card. Then ask each pair to
                                                      add their information to the computer data file. Once all pairs have added
                                                      their information, create a class list of questions and discuss how they can
                                                      be translated into search criteria. Allocate questions and give each pair
                                                      some time to work out and print their answers. Discuss and summarise the
                                                      information with the class.
                                                     Children who find the work difficult could be given simple questions, such
                                                      as: who is the tallest in the class? More able children could be asked
                                                      questions which require them to produce bar charts illustrating the numbers
                                                      with particular eye colours, show sizes or favourite sports.

                                                    Your Lesson




Bristol LEA ICT Scheme of Work
                                                            Page 7 of 8
                                               Lower Key Stage 2– Databases




Bristol LEA ICT Scheme of Work
                                 Page 8 of 8

								
To top