Faculty can use online rosters

• to look up SIREN account names for students at the beginning of a course
• to see when students last accessed their accounts from on campus
• to use as attendance sheets during the semester
• to merge into personal letters or contracts or to print on labels for handouts
• to populate spreadsheets for attendance or grading
• to generate accounts for eligible students

• Click on "spreadsheet" for the appropriate class.
• Save the file. Select the desired location.
• Open Word. Select New under the File menu. Select, from the Wizard, "Create labels for a mailing list."
• When the Mail Merge Helper displays, click Get Data and move down to open data source. In Files of Type: box, select "all files" in order to see the file (which was saved in spreadsheet format). Navigate to the saved file. Double-click on the file name to open it. Click "Set up Main Document."
• Select the size labels as determined by the Avery product number and click OK. Or you can create a sample label by clicking "Insert Merge Field" and selecting the desired field. If a merge did not occur during the setup, go to Tools/Mail Merge to merge the roster information into the label format. Save the file and print.

• Click on "spreadsheet" for the appropriate class.
• Save the file to the desired location (a folder or your desktop).
• Open Word. Select New under the File menu and click Letters tab and Letter icon to create a new document, or open a previously created form letter and select Mail Merge under the Tools menu.
• When Mail Merge Helper displays, click Get Data and move down to open data source. In "Files of type:" box, select "all files" in order to see the file (which was saved in spreadsheet format). Navigate to the saved file. Double-click on the file name to open it. Click "Set up Main Document."
• From the Letter Wizard, click "send letters to mailing list."
• Under Tools, select Mail Merge to merge the roster information into your letter template. Save the file and print.

• Click on "spreadsheet" for the appropriate class.
• Save the file. Select the desired location.
• Open Excel. Select Open under the File Menu; in "Type of files" box, select "all files." Navigate to the appropriate file.
• Double-click on the file name to open it. Click "Set up Main Document."
• Select "delimited," "Tab," and "Column Data Format: General" from the Wizard.