Saturday 19 March 2022

Spreadsheet Modelling

Spreadsheet Modelling

Creating a formula through Google Sheets that will work out if a student has passed an exam


 

I used an IF function for my formula. I added up all three papers per student and divided by the number of tests taken. If the average was over 50 then the programme would print out Pass and fail if it was less than 50

No comments:

Post a Comment

Machine Learning

Today I learnt about decision trees. Decision trees are algorithms that classify things according to their features. To train the machine, a...