+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 22
General Chat Thread, Any good Database lesson plans? in General; I'v been asked by several teachers to plan some database lessons for Year 5 classes (as the ones they have ...
  1. #1
    Pete10141748's Avatar
    Join Date
    Nov 2007
    Posts
    1,365
    Thank Post
    106
    Thanked 220 Times in 130 Posts
    Rep Power
    86

    Any good Database lesson plans?

    I'v been asked by several teachers to plan some database lessons for Year 5 classes (as the ones they have been given are crap).

    The kids have already searched simple + complex databases, set up thier own class database, and completed a worksheet based on that class database.

    Aside from setting them loose on the 'Net, I'm out of ideas; there are 2 lessons left on Databases; anyone have any ideas of what I can get them to do?

    Pete

  2. #2
    PEO
    PEO is offline
    PEO's Avatar
    Join Date
    Oct 2007
    Posts
    2,093
    Thank Post
    457
    Thanked 150 Times in 95 Posts
    Rep Power
    71

    Re: Any good Database lesson plans?

    Yeh. Its the teachers job to plan lessons not yours.

  3. #3

    Join Date
    May 2006
    Location
    Leicestershire
    Posts
    345
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Any good Database lesson plans?

    im out of touch with what year, year 5 is but have you thought about simple SQL queries,

    so select all rows, and then add some conditions in, using where. Just so they get an idea on how to filter results

  4. #4

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,622
    Thank Post
    1,240
    Thanked 777 Times in 674 Posts
    Rep Power
    235

    Re: Any good Database lesson plans?

    Have they done anything about data types yet - did their class database maybe contain different types of data? It's probably worth going over it again for a lesson, just so they defiantly get the idea. You could give them a largish database of some kind containing some data formatting errors and ask them to fix them.

    --
    David Hicks

  5. #5

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,622
    Thank Post
    1,240
    Thanked 777 Times in 674 Posts
    Rep Power
    235

    Re: Any good Database lesson plans?

    > im out of touch with what year, year 5 is but have you thought about
    > simple SQL queries,

    Year 5 is 9/10 years old. SQL is probably overdoing it a bit, but "filtering" sounds like an excellent idea. You could set up an exercise where they act as the computer sorting a database - write them a "program" in the form of a worksheet with branching if/then statements, then get them to put each record through that "program" and sort the data.

    --
    David Hicks

  6. #6

    Join Date
    Jul 2007
    Location
    Middle-Wales
    Posts
    368
    Thank Post
    2
    Thanked 4 Times in 4 Posts
    Rep Power
    15

    Re: Any good Database lesson plans?

    Input validation is always a good one

  7. #7
    tomscaper's Avatar
    Join Date
    Jul 2006
    Posts
    814
    Thank Post
    118
    Thanked 29 Times in 15 Posts
    Rep Power
    22

    Re: Any good Database lesson plans?

    As Mr Happy said, Get the teachers to plan there own lessons, if they do not understand how to use databases why are they teaching it, and if they dont understand then it can be up to you to teach the teachers.

  8. #8
    PEO
    PEO is offline
    PEO's Avatar
    Join Date
    Oct 2007
    Posts
    2,093
    Thank Post
    457
    Thanked 150 Times in 95 Posts
    Rep Power
    71

    Re: Any good Database lesson plans?

    @ tom did you recieve my invite on skype?

  9. #9
    tomscaper's Avatar
    Join Date
    Jul 2006
    Posts
    814
    Thank Post
    118
    Thanked 29 Times in 15 Posts
    Rep Power
    22

    Re: Any good Database lesson plans?

    Quote Originally Posted by MrHappy
    @ tom did you recieve my invite on skype?
    havn't been on skype since monday, have been round my lasses house all week. Will check tonight when i get in.

  10. #10
    Pete10141748's Avatar
    Join Date
    Nov 2007
    Posts
    1,365
    Thank Post
    106
    Thanked 220 Times in 130 Posts
    Rep Power
    86

    Re: Any good Database lesson plans?

    Cheers for the input guys. Problem around here is that none of the teachers actually ever planned ICT lessons really, and at the moment are using LCP plans which are, frankly, quite bad IMO. Using Excel to teach Databases? C'mon

    Pete

  11. #11
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    33

    Re: Any good Database lesson plans?

    ...to go with websites made in Publisher like so many secondaries. Ungh!

  12. #12
    TechSupp's Avatar
    Join Date
    Mar 2007
    Location
    South Yorkshire
    Posts
    1,876
    Thank Post
    295
    Thanked 120 Times in 101 Posts
    Rep Power
    40

    Re: Any good Database lesson plans?

    Year 5 need to cover errors in databases, how they can spot them i.e. using graphs to highlight posible errors etc. Maybe set them a database which has errors, and ask them to highlight the errors, then use the internet (searching a large databse) to correct the errors. Collect and record their findings highlighting how they spotted the errors and what the data should have been. Were there any checks they could have been made to stop these errors. (Unit 5C evaluating information)

    You could also expand into search skills on the internet (searching a large database etc) Its something kids seem to miss out on, how to enetr an efficient search criteria and then be able to scan the results to find suitable data.

    http://www.lgfl.net/lgfl/leas/greenw...f%20work/menu/

    You may want to look at greenwich LgfL website for other ideas. Can be quite useful.

  13. Thanks to TechSupp from:

    speckytecky (3rd May 2010)

  14. #13


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,384
    Thank Post
    1,417
    Thanked 871 Times in 560 Posts
    Rep Power
    643

    Re: Any good Database lesson plans?

    Quote Originally Posted by sahmeepee
    ...to go with websites made in Publisher like so many secondaries. Ungh!
    Our website is made with Publisher just to piss off people with non MS browsers. I'm forced to change the rationale though because it no longer works correctly with IE :? (assuming it ever did)

  15. #14
    Friez's Avatar
    Join Date
    Dec 2006
    Posts
    839
    Thank Post
    22
    Thanked 22 Times in 21 Posts
    Rep Power
    23

    Re: Any good Database lesson plans?

    Quote Originally Posted by MrHappy
    Yeh. Its the teachers job to plan lessons not yours.
    I couldn't agree more with this sentence. They need to go do some IT TRAINING tbh. If they can't tell you how to normalise a database or what a primary key is for then they're NOT QUALIFIED FOR THE JOB (in my books).

    Maybe you should do their job and earn their salary too hmm?

    You wouldn't have a maths teacher that has trouble doing multiplication teaching maths would you? Why is IT different?

  16. #15

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,403
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319

    Re: Any good Database lesson plans?

    Quote Originally Posted by sahmeepee
    ...to go with websites made in Publisher like so many secondaries. Ungh!
    No, no... PowerPoint! :P

    Quote Originally Posted by laserblazer
    Our website is made with Publisher just to piss off people with non MS browsers.
    Way to piss off people with disabilities, too!

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Lesson Plans
    By kerrymoralee9280 in forum General Chat
    Replies: 5
    Last Post: 11th June 2007, 10:12 AM
  2. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  3. Scrap vehicle tracking plans
    By Dos_Box in forum General Chat
    Replies: 26
    Last Post: 13th February 2007, 12:19 PM
  4. Lesson Monitor for pe
    By Jamie_a in forum Educational Software
    Replies: 7
    Last Post: 23rd January 2007, 03:17 PM
  5. History Lesson
    By mighty.grey.eagle in forum General Chat
    Replies: 8
    Last Post: 10th January 2007, 11:52 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •