The Banner report SWRCLEM generates a list of student emails based on a given subject code (for example, MTH for Math students, WR for Writing students). The report can be further narrowed down by campus. SWRCLEM can be downloaded into Excel and, if desired, used to create a mass email.

Two versions of the report are generated in Banner Report Viewer, one ending in .lis and the other ending in .txt. The .lis version lists only the number of students who were selected. The .txt version shows all MyPCC email addresses; it is also the download-friendly version.

swrclem

Directions:
  1. From the Banner Main Menu page, type SWRCLEM, then press Enter

  2. Click the Go button and then the Next Section . This will move your curser to the "Parameter Values" section.

 

       3. On the right side of the Parameter Values section (see picture above), type in the Term Code.

Term Codes:

Winter 2011=201101
Spring 2011=201102
Summer 2011=201103
Fall 2011=201104
etc.  

 

       4. Press the Down Arrow on your keyboard (or click with your mouse) to navigate to the second line, the Subject Code line.

 

       5. Type in the Subject Code (for example, WR for Writing) for the academic subject you want.

The report will show the MyPCC email addresses of all students enrolled in classes associated with the Subject Code you specify here.

 

       6. Type in the Campus Code if you wish to narrow your data down further by Campus. OR, leave this field blank if you don't want to narrow it down by campus.

  • 1 = Sylvania
  • 2 = Cascade
  • 3 = Rock Creek
  • 4 = SE Campus and other ELC locations
  • blank = all campuses

To specify more than one subject,

    • After typing in the first Subject Code, click the Insert icon.
    • In the blank line that appears, type '02' for the parameter number 2, Subject Code. A new blank line will appear.
    • Type in the next Subject Code.
    • Repeat as needed.

       7. Click the Next Section icon.

 

      8. Click the Save icon.

(For more information about running reports, including how to save your parameters for next time, see the Banner Report Help page.)

      9. Open Report Viewer and view your report.

Two files are created for this report. The file name that ends with .txt is the report you will need for downloading. (The report with ".lis" at the end of the file name will only show the parameter values you have entered and the number of students.)

To download the .txt version of the report, go through the Downloading Process to save and convert your report into Excel format. (Note: When you open the file in Excel, choose "delimited" and indicate "tab" as the delimiting character.)

 See Also:

Convert Excel Data into a Friendlier Format