Does my wallet need to be opened on my computer in order for airdrops and staking to occur? My coins are appearing on my wallet and looks good to go but not wanting to leave it open 24/7

Yes, except for the maturing period of coins, which occurs even when the wallet is off.