IT120 Intro to Android

Step-by-step Organization of IT120

schedule: 3 weeks, 3 times a week, 1.5 hours each, 7:30 - 9pm, first 3 weeks of January 2010
capacity: 40-50 students

Rename affiliation to canonical names, e.g. Natural Science => HCMUS
Sort by affiliation
Enter programming tests
Accept teacher recommendations
Accept perfect scores
Reject anyone with attendance 6 or below
Reject poor programming experience
Accept people with Android device and at least Java skill 2 (0..4)
Reject people who got accepted to IT110 but didn't attend well => didn't get any rejections out of that

Look at the accepted numbers: 39. We still have 25-30 to go. We have 14 people who submitted tests and didn't get perfect score. We accept them all, that gets us to 53.
NOW TO SAVE TIME: in parallel, start SMS (or email if no number) people who get accepted/rejected
Reject people who actually say they're not in the country
Reject Java skill 0/1 and C# but no year (not following instructions)
Now reject Java skill 2
Problem: Some FPT-Aptech students didn't apply on the list, and 1 test is on none of them.
Now we have around 71 people accepted.

Sort by phone number (so everyone should have provided a phone number)
Sort by name
Download as excel
Prepare for printing: landscape, repeat header row, enable gridlines, remove margins resize columns, include columns (challenge score, accepted, dates)

Have students check their name on the list
If not on list, enter information on separate sign-in sheet
If the class is too full, then notify people on the sign-in sheet that were not accepted that they may not be allowed in the next class
Create a blank ordered waiting list signup sheet with columns: Name, email, phone, first time?

Tell students to come around 7:15. At 7:30 we let in people on waiting list in order if there is room, leaving the aisles empty. After 7:30, people are let in if there is room regardless of acceptance status. After 7:40, we close doors and prevent people from coming in.
Update mailing lists of students: accepted + rejected but persistent + walkins
Email students explaining attendance and waiting list procedure, the posting of slides on the web site, and the location of forum discussions
Once attendance has reached a level where there is enough room, we just do a headcount and pass the attendance sheet around (but no need to verify)

We need to collect both email addresses and phone numbers because often one is wrong and sometimes we need last-minute messages by SMS