KS3 – Year 7

We run a series of short project based schemes which each last half a term. We currently teach units on Powerpoint, Publisher, Scratch, Spreadsheets, Databases, and Crocodile.

Feel free to use any of these resources, but please send me a quick comment if you do so. Any feedback or suggestions are appreciated!


We use a tracking spreadsheet that each students has in their documents. At the start and end of each unit they can record their knowledge and then make comparisons throughout the  year. Please note – these levels are specific to the units we teach, and do not always coincide with the old national curriculum levels.

Year 7 Levels 2013


The spreadsheets unit is a bit of a mish mash at the moment, and needs to have some time spent on it. The scheme is designed for year 7 students, however a lot of differentiation will be necessary in order to make it appropriate for lower ability students.


  1. Lesson 1- Intro to spreadsheets
    1. Lesson 1 workbook
  2. Lesson 2 – Graphs.ppt
    1. Lesson 2 – Graphs.xlsx
  3. Lesson 3 – Formatting and formulas
    1. Lesson 3 – Games
    2. Lesson 3 – Susie’s Sweet Shop
  4. Lesson 4 – CountIFvlookup
    1. Lesson 4 – Counting
    2. Lesson 4 – Vlookup Countif
    3. Lesson 4 – Vlookup Demo
  5. Lesson 5 and 6
    1. Lesson 5 and 6 – Quiz Template
    2. Lesson 5 and 6 -Example Quiz


The following scheme is designed to teach students the fundamentals of databases using Access.

Link to full set of resources here

Database SOL

Database Workbook

  1. DB Lesson 1
    1. Lesson 1 – Video Club Fields.doc
  2. DB Lesson 2
  3. DB Lesson 3
  4. DB Lesson 4
  5. DB Lesson 5
    1. Lesson 5 – CSI Crime 1 – results handout
  6. DB Lesson 6


This 7 lesson SOL allows students to experiment with basic programming through games making. The lessons progress in difficulty and complexity and allow students to develop programming, planning and problem solving skills

Scratch SOL

  1. Lesson 1: Disco
    1. Lesson 1- Disco.ppt
    2. Lesson 1 – Disco
  2. Lesson 2: Maze
    1.  Lesson 2 – Maze.ppt
    2. Lesson 2 – Maze
    3.  Lesson 2 – Maze Higher
  3. Lesson 3: Ping Pong
    1. Lesson 3 – PingPong
    2. Lesson 3 – Ping Pong.ppt
    3. Lesson 3 – PingPong Higher
  4. Lesson 4: Snake
    1. Lesson 4 – Snake
    2.   Lesson 4 – Snake Higher
    3. Lesson 4 – Snake.ppt
  5. Lesson 5: Space Invaders
    1. Lesson 5 – Space Invaders
    2.  Lesson 5 – Space Invaders Higher
    3. Lesson 5 – Space Invaders
  6. Lesson 6: Making games better
    1. Lesson 6 – Improvements
    2. Peer-Self Assessment
    3.  Lesson 6 – Improvements Higher
    4. Lesson 6 – Improvements.ppt


This unit is based around the creation of a newspaper. Students work in groups to create one cohesive newspaper for a desired target audience. The focus is on specific publisher skills, and being able to design for a sepcific audience and purpose.

Publisher SOL

  1. Lesson 1 – Intro to publisher
    1. Publisher – What do you already know?
  2. Lesson 2 – Copyright
    1. Newspaper Planning
  3. Lesson 3
  4. Lesson 4


We use the powerpoint unit to introduce students to the school systems when they join us in year 7. The scheme is therefore only 4 lessons in length and covers cyberbullying and e-safety.

Powerpoint SOL

  1. Lesson 3 – Cyber Bullying
    1. Character questions
    2. Let’sFightItTogether-guide
  2. Lesson 4 – Powerpoint 1
  3. Lesson 5 – Powerpoint
  4. Lesson 6 -feedback
    1. Peer-Self Assessment


Crocodile is used as an introduction to control systems. Students learn about basic flow diagrams, variables, inputs/outputs and processed.

Crocodile Clips SOL

  1. Tutorial dance routine lesson 1
  2. Variables – Lesson 2
    1. Tutorial flowchart lesson 2
  3. Tutorial on button press lesson 3
  4. Tutorial setting parts properties lesson 4
    1. extension l4
  5. extension lesson 5
    1. Tutorial on the lift lesson 5

42 Responses to KS3 – Year 7

  1. Patricia West says:

    The Spreadsheets SOW looks really good! I am going to use this for my Year 7. Do you have a PPT for Lesson 5 and 6? (I feel really cheeky asking that).

    • Katie says:

      Haha no problem

      The link “Lesson 5 and 6” should now go to the powerpoint. It was supposed to link there in the first place – thanks for pointing it out!

      I was worried that the content was far too complex for year 7. It goes at a pretty quick pace, and contains a lot of formula work. Would probably work better with year 8 i think, or spread over more lessons.


  2. Gary says:

    Hi Patricia,

    Love your work. You have put a lot of effort into this, well done. I like you database section and I would like to use it. Do you have the database file that you used?



  3. sherlock says:

    Your scratch resources look very interesting – I have a low ability year 7 class – hopefully your efforts will prove helpful.

    Thank you so much for sharing 🙂

  4. Dave says:

    Could I possibly have the database file as well, what an excellent resource


  5. Moley says:


    You are an absolute life saver :o)
    I too would love to have a copy of the database if possible, however, if not I can probably cobble something together!

    I haven’t taught ICT for several years and am feeling a bit rusty, but your excellent resources have made me feel so much better about taking this on again.

    Thank you so much.

  6. kharia farakh says:


    I would really like to use yur databases unit for year 7. I am having difficulty downloading it. Is it possible to send the resources for databases unit via email.

    Many thanks.

  7. Jane Gardiner says:

    Hi the database stuff looks amazing! Could I please also have the link for all the resources?


  8. thanks Katie , these are fab resources

  9. Elizabeth says:

    Hi Katie,

    these are fantastic resources . Can i please have a link to the databases please.

    thank you

  10. Ros A says:

    Hi Katie,
    I am new to teaching ICT after having taught Physics for 14 years. I do not know what I would have done without your work and guidance. I had started with power point and could not think where to go next, when I stumbled on your blog. Most of the students seem quite good with word processing so I decided to try your spreadsheet. I tend to go through the lesson a week before I am due to deliver and it has been a life saver. I think I may have corrupted the L4 vlookup-countif file as when I try to do the exercises (finding out what stars earn) it appears to be giving me the wrong answer. e.g. for Scalett Johanssen I get £2,000 000 instead of £9,000 000. HELP what have I done wrong? I have gone through the spreadsheet as far as I know how and cannot see where I may had changed anything. Thanks

    • Katie says:


      Great to know my resources are coming in useful!

      I had the same problem with the spreadsheet. In order for it to work, the table of “stars” needs to be sorted alphabetically by the first column – a total oversight on my part! I’ve uploaded a revised version under the same link on the Year 7 page if you want to download it again. Fingers crossed it works (if not, let me know!)



  11. Ros A says:

    Thank you so much. What a star you are.


  12. Karen says:

    Hi Katie

    I have just stumbled across your blog and am so glad; what fantastic resources! Thank-you for sharing them.
    Could I also have the link for the database file?


  13. M Butler says:

    Hi would it be possible to get a link to the database resources

  14. Elizabeth says:

    Hi Katie , you emailed me the database resources link but it cant open . Can you kindly email it to me again . thank you for these


  15. Ros A says:

    Hi Katie,
    Would you be able to tell me where I am going wrong? I am trying to practice the IF formula in the quiz on spreadsheets, but even when the answer is correct it keeps coming up with incorrect. Here is my formula:=IF(A16=”His fellow administrators”,”Correct”,”Incorrect”). Help please. Thanks


  16. Julian says:

    Hello Katie, like many others I would really like a link to the database resources. thanks so much for sharing all this great work!

  17. Pauline says:

    Hi Katie
    Please could I have a link to the database resources as well. Thanks

  18. Julian says:

    Not sure if this site is still being updated? But if anyone does anyone have the database resources I would really appreciate them – julianaobrien at hotmail.co.uk


  19. Bernard Capel says:

    Hi. Like others stumbled across your blog by accident. Your resources are very good and I am hoping to adapt / use some of them in my teaching. Seems everybody is trying to create / do appropriate stuff for the new programmes of studey I would really appreciate the database file or link to go with the databases unit. Thanks. Keep up the excellent work.

  20. Calypso says:

    Hello Katie

    What a fantastic resources! Thank-you for sharing them. I would love to share me resources with you as well as i am trying to create appropriate stuff for the new program of study for the new academic year.

    Could I also have the link for the database file and to the publisher files (Publisher quiz.ppt Publisher quiz differentiated.ppt and lesson 6 ).

  21. Shafia says:

    Hi Kate, lesson 2 on data base ask student to open a database file that is not available on the site. Would it be possible to get it?

  22. jonwitts says:

    Hi Katie,

    I would really like to use your “Space Invaders” lessons in my Year 7 scheme I am currently writing. I would happily share it back with you.


  23. Almas says:

    Katie you are such a life saver……

  24. Kevin says:

    Kev –
    These are completely brilliant many thanks – I have a ton of home made resources myself along the computing stream i.e. Kodu, Python and others so in exchange feel free to drop me a line if you would like them sent

  25. Shepherd says:

    These are fantastic resources I think I will definitely use some of these.

  26. Mariel says:

    Hi Katie! Thank you for these resources. Very useful indeed. In my school our internet is very very poor. So when we have tried sharing homework and classwork via the school’s network. Most of the connections crash. I always wonder what kind of sharing systems ICT teachers are using to check classwork and homework…
    For now I am having to have students save their classwork on the Document’s folder of each computer and I have to check them one by one which is super time consuming… Does any of you guys have ideas, suggestions? Thanks a ton!

    • Katie says:


      We currently use Google Drive for all our homework as the students now have school based google accounts. Its perfect because they can share documents straight with us. Previous to this we were exept from setting homework! I know a lot of schools do booklets which covers a whole term/half term of topics at once rather than setting individual tasks every week.

      • Mariel says:

        Thanks for the fast resply Katie! and how about classwork? how do you correct it? how do students share them with you?

  27. Linda Owens says:

    Hi Katie, I am an ICT NQT, but working as an ICT teacher and coordinator at the moment in a small private school – very daunting as I have no one to bounce ideas off. Your KS3 plans have been so helpful and time consuming, thanks so much for sharing. Could you please send me the database link also? Kind regards Linda 🙂

  28. Orla says:

    These resources are great, i am a student teacher and i am really glad of excellent resources which i can adapt and use.

  29. Sandy says:

    These resources are superb and very well put together, Thank you for sharing. Feel cheeky asking but would you have the resources for lesson 5 and 6 for Publisher SoW?

  30. Rachel says:

    Thank you thank you. Your database resources will save me hours of work!

  31. Jill says:

    Hi Katie, these are excellent, thank you! i am going to use your database SOW… saves me loads of time, can you send me on the link to extra resources please that i see you talk about above? I have the drop box link if it is in there… thanks again, well done, these are all great:)

  32. Baha Uddin says:

    Hi Patricia,

    I really like your work, particularly database section and I would like to use it. Do you have the database file that you used?



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s