Year 9 OCR Nationals Database Lesson

By 11/05/2011PGCE, POT 3, Teaching

What we did & Learning objectives!

We where having a look at databases and how to create a simple query that filters for a YES in the criteria. The table was for people attending a music festival. We also where creating a report for the bands that where playing and the order of their events they created.

What went well?

I had created a good lesson plan for this lesson and it was very thorough and I was able to really get to grips with Microsoft access before using it.

I found I was able to assert my authority and lay down so ground rule although these where not respected as well as I would have liked. I was able to

Students Learning 

What could have been done better and what will I do about it?

I accidentally started creating a query in the wizard view rather than design view which threw me but I was able to reel it back in.

Behaviour wise I found there was little mutual respect dispite the clear guidelines being issued which meants that next lesson the first person that steps out of line will be in Time out the sanction area. I was able to issue two time out warning to pupils demonstating my high expectations and standards.

Students Learning 

Pupils where actively not egaging with the content and not listening. This is because of the nature of the OCR nationals and it is quite a mundane topic.

 Feelings

Not the greatest lesson which I will need to work hard on next lesson to pull them back in. I will need to just be short and sweet as far as sanctions and warnings and not be afraid to use the time outs. I will also need to look at how to make it more interesting.

After the lesson i asked my subject mentor for some advice on how to best impliment the policies and practices for behaviour in the classroom . On Speaking with him we identified that the reason why it was initially due to the fact that the demonstration did not go well and from then on I had lost them. He also said that if i would like to i could on the whiteboard write down who is causing truouble in the lesson and give them a warning or a merit for doing wel. This way they know if they are needing to be quiet or to offer more.

Please use this link to view my full lesson plan >> 

https://docs.google.com/document/d/1z4oZSUqSpyCrlbE0wo8OEo1zwIqoEvZkaP3wLxL0P74/edit?hl=en

https://docs.google.com/leaf?id=0B7AadLDLtxQLNzJiNzgzNWUtZTBmOS00NDY3LWJiNWMtODNjY2Q1ODlkNmRi&hl=en