To break into Smith’s office, there are two ways
1. You have to max out your security skill (or maybe get it high enough) to bypass the lock without triggering the alarm
2. You have to max out your magic skill (or get it high enough) to unlock the magic shop and for the ritual. With the magic shop, you have to buy the thunderstorm ritual components and must have ectoplasm from Zero (Golden Frennie)