If you keep your marks in a spreadsheet, you don't need to work out your average by hand every time a new result comes in. A simple AVERAGE formula over your grade column gives you the current figure, and an IF formula can flag any subject that falls below your pass mark. If you're not sure how to write these formulas, https://xlaipro.com/ lets you type what you want and gives you the Excel formula for it.