I've used Walmart (and, slightly better, Target) tents . . . both sufficed, but typically have rain flies that do no go near enough to the ground . . . . any amount of rain will have the tent body wet on the outside, as the fly doesn't down far enough), and if it's wet on the outside, much contact on the inside (from gear, or a sleeper rolling) will result in wet on the inside . . .
If fiscally possible, I'd go to REI (or Campmor) and get a decent brand name tent (rain ly coverage and aluminum poles both being items of interest).
Most importantly, have fun!
Searching for the immaculate contraption