Database/Query Design Help

I am designing an ASP.NET app that can be used to keep track of
attendance at office hours for a class.  The purpose of this is
that we need to know if a student is attending office hours by
different people (so that we can flag them as "in trouble").  I
don't know if I have chosen the best database design, and I'm lost as
to how to accomplish a query I need.

I have a table HoursAttendance that has the following design.

Column_Name   Data_Type   Length   Allow_Nulls
TA              
      char        
      4         
n
Date              
    smalldatetime 4     
    n
Start              
    smallint         
2          n
End              
     smallint     
    2          n
Student1            
bit              
  1          y
Student2            
bit              
  1          y
Student3            
bit              
  1          y
Student4            
bit              
  1          y
Student5            
bit              
  1          y

I chose to have the students as columns because the students don't
change, and then you add rows of office hours.  If students are
the rows, then you would be adding columns as the semester continued
which I thought was odder...?  I'm completely open to suggestions
on Database Design, because I really wasn't sure.

Ok, so now I need useful queries.  The one that I am stuck on (and
also the first one besides select * from HoursAttendance) is that I
want the names of Students who have attended more than x office
hours.  So I need something like

    select <column name> from HoursAttendance where count(sum(<column name>)) > x

Granted a better table design could help with this.  I'm
relatively new to design, so constructive criticism is desired please