how guidance and supervision from parents helps in a child's academic excellence?

Ask yourself this: How would children do if their parents didn't care at all?

It depends on the age of the child, among other things.

If you ask a more specific question, you'll get a better answer.