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.
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.
- Lesson 1- Intro to spreadsheets
- Lesson 2 – Graphs.ppt
- Lesson 3 – Formatting and formulas
- Lesson 4 – CountIFvlookup
- Lesson 5 and 6
The following scheme is designed to teach students the fundamentals of databases using Access.
Link to full set of resources here
- DB Lesson 1
- DB Lesson 2
- DB Lesson 3
- DB Lesson 4
- DB Lesson 5
- 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
- Lesson 1: Disco
- Lesson 2: Maze
- Lesson 3: Ping Pong
- Lesson 4: Snake
- Lesson 5: Space Invaders
- Lesson 6: Making games better
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.
- Lesson 1 – Intro to publisher
- Lesson 2 – Copyright
- Lesson 3
- 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.
- Lesson 3 – Cyber Bullying
- Lesson 4 – Powerpoint 1
- Lesson 5 – Powerpoint
- Lesson 6 -feedback
Crocodile is used as an introduction to control systems. Students learn about basic flow diagrams, variables, inputs/outputs and processed.
- Tutorial dance routine lesson 1
- Variables – Lesson 2
- Tutorial on button press lesson 3
- Tutorial setting parts properties lesson 4
- extension lesson 5