I’m doing a media production foundation and struggling to know what good looks like
Have you spoken to your course tutors? They should be helping you with things like this. For many media courses you wouldn't be expected to produce a portfolio with sketchbooks but instead a showreel of work you've been invovled with (stating your role)