Does my computer need to be turned on for my backups to happen?

A  Yes, you need to have your computer on and be connected to the internet. If you forget to leave your computer turned on it will attempt to perform the backup the next time it is powered up.