Course/Class Enrollment Template/Tool in Excel by kirkulmer

VIEWS: 448 PAGES: 5

More Info
									[CourseTitle]                                                                                                                             Class Session #
All Participants


Class ID    Last Name    First Name   Custom1    Custom2     Custom3                                                      Class ID    Last Name   First Name
    1      Roosevelt    Franklin D.   32        1933-1945    "FDR"                                                           1       Roosevelt    Franklin D.
    2      Truman       Harry         33        1945-1953    "Harry"                                                    Location     Eisenhower   Dwight D.
    1      Eisenhower   Dwight D.     34        1953-1961    "Ike"                                                      Date         Johnson      Lyndon B.
    2      Kennedy      John F.       35        1961-1963    "JFK"                                                      Time         Carter       James E.
    1      Johnson      Lyndon B.     36        1963-1969    "LBJ"                                                      Instructor   Bush         George
    3      Nixon        Richard M.    37        1969-1974    "Dick"                                                     # of Seats   Clinton      William
    2      Ford         Gerald R.     38        1974-1977    "Jerry"
    1      Carter       James E.      39        1977-1981    "Jimmy"
    2      Reagan       Ronald        40        1981-1989    "Gipper"
    1      Bush         George        41        1989-1993    "Poppy"
    1      Clinton      William       42        1993-2001    "Bill"
   17      Bush         George W.     43        2001-2009    "W"
                                                            If you find this template useful, please let others know!
ss Session # 1                                              Class Session # 2


     Custom1    Custom2       Custom3     Class ID   Last Name   First Name Custom1 Custom2
          32   1933-1945   "FDR"             2       Truman      Harry           33 1945-1953
          34   1953-1961   "Ike"        Location     Kennedy     John F.         35 1961-1963
          36   1963-1969   "LBJ"        Date         Ford        Gerald R.       38 1974-1977
          39   1977-1981   "Jimmy"      Time         Reagan      Ronald          40 1981-1989
          41   1989-1993   "Poppy"      Instructor
          42   1993-2001   "Bill"       # of Seats
ion # 2                             Class Session # 3


              Custom3     Class ID Last Name First Name Custom1 Custom2 Custom3
      "Harry"                3     Nixon     Richard M.      37 1969-1974 "Dick"
      "JFK"             Location
      "Jerry"           Date
      "Gipper"          Time
                        Instructor
                        # of Seats
All contents copyright © 2010 by Kirk Ulmer. All rights reserved.

Class ID         Last Name       First Name     Custom1     Custom2     Custom3    Count of Class ID
               1 Bush            George           41        1989-1993   "Poppy"           1
                 Carter          James E.         39        1977-1981   "Jimmy"           1
                 Clinton         William          42        1993-2001   "Bill"            1
                 Eisenhower      Dwight D.        34        1953-1961   "Ike"             1
                 Johnson         Lyndon B.        36        1963-1969   "LBJ"             1
                 Roosevelt       Franklin D.      32        1933-1945   "FDR"             1
1 Total                                                                                   6

               2 Ford            Gerald R.          38      1974-1977   "Jerry"           1
                 Kennedy         John F.            35      1961-1963   "JFK"             1
                 Reagan          Ronald             40      1981-1989   "Gipper"          1
                 Truman          Harry              33      1945-1953   "Harry"           1
2 Total                                                                                   4

               3 Nixon           Richard M.         37      1969-1974   "Dick"            1
3 Total                                                                                   1

              17 Bush            George W.          43      2001-2009   "W"               1
17 Total                                                                                  1

Grand Total                                                                               12
All contents copyright © 2010 by Kirk Ulmer. All rights reserved.




       Instructions
                  Fill up the data in columns A-F and the data magically appears in the class
                  sessions to the right. Look at the field comments for help.

                    "Want to know what you don't know"

                    I'd like to hear your feedback. Send comments to kirk_ulmer@hotmail.com

								
To top