<<it is essential that students are made to really believe that they can do something useful AFTER COMPLETING THEIR FIRST STATISTICS COURSE THAT THEY COULD NOT DO BEFORE! A possible reason that many one-course students say "Uuugggg" when Statistics is mentioned, is that they can't do much useful research after they have taken one course.>>
I second that Joe. While we cannot teach everything in the first course, I think having the students do real, meaningful experiments...not only gathering data in class for the entire class...but also letting EACH student decide individually what they want to study and try to apply what they know to it. Even if it does not work out perfectly they will understand what goes into doing statistics rather then studying statistics. If we do our job we will support their sensible efforts to analyze the situation and point out what more they have to consider.