This spreadsheet is idea for either auditing a set of skills you cover with a project or for filling gaps in knowledge that you would like the pupils to have by the end of KS3.
I have added a list of some skills, you can either add to the list or make your own.
Many people teach Design and Technology through projects, it is very easy to miss the big picture of what pupils learn as they move from one year to the next.
I have added three year groups for KS3, you could continue this for KS4 too, I have split each year group into 6 columns to represent each half term.
Have fun and share your finished audit of the Design and Technology Teacher's FB group if you are pleased with how it looks for you.