Open a Microsoft Excel Application 2007 on a personal computer. Type in the class name, semester and year in cell A1. Highlight cells A1 through G1. Under the Home Tab, select the merge and center option appearing in the alignment group.
Insert a label called "Last Name" in cell A2. Alphabetically fill the column with the students' last names in cell A3. Insert the label for first names in cell B2. Fill the column with the corresponding first names. Type in cell C2 the "student status," and fill the column with information such as freshman, sophomore, junior or senior. Insert a label for "contacts" in cell D2 and fill the column with student e-mail addresses.
Insert a label called "Counselors" in cell E2. Fill the column with the corresponding names for each student's counselor. Type a label for counselor email addresses in cell F2 and fill the column accordingly. Enter any additional labels and information, as desired, beginning with cell G2.
Save the file under an appropriate name. Back up the roster on a flash drive. Continue to update the roster for changes such as added or dropped students. Email copies of the roster to administrators as required.
If you are keeping your roster in hard-copy format, purchase a paper record keeper from a reputable educational supplier, such as Scholastic's Teacher Store. Confirm the record keeper contains a class roster. Input student information pursuant to the roster headings provided. Copy and distribute the roster to administrators as required.