- Login to eCampus
- Open class roster and click on the grid icon
- In the new window that opens, select all (ctrl +
a)
- Copy (ctrl +c)
- Open Notepad: Start, All Programs, Accessories, Notepad
- Right click
- Paste (ctrl + v)
- Select all (ctrl + a)
- Copy (ctrl + c)
- Open new blank page in Excel (file, new)
- Position cursor in cell 1A
- Paste (ctrl + v) or right click, paste, and leave highlighted
- Format, Column, AutoFit Selection
+Credits:
Dr. William C. Wood, Professor, Dr. Ehsan Ahmed, Department Head, Economics
Department
- Using MS Internet Explorer,login to e-campus:
https://ecampus.jmu.edu/psp/ecampus/SELFSERV/?cmd=login
- Enter your JMU eID and your email Password - If you cannot login, call the Help Desk, x8-3555 to resolve the
password conflict - Click login - Click Access Class Roster - Click the Semester you want - Click the Course Title you want. (Note: there is a long wait
while "Processing") - Select (highlight) all student rows of information (not
the heading) by using your
mouse or
cursor keys.
Open Excel (version 2000 or higher)
- Cursor will be positioned in cell 1A
- Click Edit, Paste
- Format, Cells, Alignment
- Uncheck the grey checkmark in Merge Cells by clicking the
checkmark twice, OK - Data, sort, Column A, Ascending, No header row, OK - Format, Column, AutoFit Selection
- Format, Row, Height, 14, OK
To
Save the New File
- Click File, Save As, select a drive letter, type in a File name, click Save
*Credits:
Dr. William C. Wood, Professor, Economics Program; James (Bink) Montgomery,
Information Systems
Revised Directions 9-27-04.
- Using MS Internet Explorer,login to e-campus:
https://ecampus.jmu.edu/psp/ecampus/SELFSERV/?cmd=login
- Enter your JMU eID and your email Password - If you cannot login, call the Help Desk, x8-3555 to resolve the
password conflict - Click login - Click Access Class Roster - Click the Semester you want - Click the Course Title you want. (Note: there is a long wait
while "Processing") - Select (highlight) all student rows of information (not
the heading) by using your
mouse or
cursor keys.
- Click Edit, Copy
Open Excel (version 2000 or higher)
- Cursor will be positioned in cell 1A
- Click Edit, Paste
-
Wait for the hourglass to return to a cursor. Text will be highlighted.
- Format, Cells
- Click Alignment
tab
- Uncheck "Wrap text"
- Format, Column, AutoFit Selection - Format, Row, Height, 14, OK
To
Save the New File
- Click File, Save As, select a drive letter, type in a File name, click Save
*Credits:
Dr. William C. Wood, Professor, Economics Program; Oana Damboiu, MBA masters
candidate; and Daniel Duta, MBA masters candidate
November 2000 Directions below:
**From e-campus Faculty Roster to Excel Spreadsheet
(11-06-00)
- Using MS Internet Explorer, Open browser to:
https://ecampus.jmu.edu/servlets/iclientservlet/ecampus/?cmd=login
- Enter your email UserID and your email Password - If you cannot login, call the Help Desk, x8-3555 to resolve the
password conflict - Click login - Click For Instructors - Click Class Roster
- Do not enter any information in the blank fields
- Scroll down, click SEARCH
- Scroll to bottom of same page and you will find the links to your
classes. Click a link to open
roster.
- Select (highlight) all student rows of information
(not
the heading) by using your mouse or
cursor keys.
- Click Edit, Copy
Open Excel (version 2000 or higher)
- Cursor will be positioned in cell 1A
- Click Edit, Paste.
-
Wait for the hourglass to return to a cursor. Text will be highlighted. To Remove Double Spacing (be sure text is still highlighted)
- Click Data, Filter, AutoFilter - Click on one of the small arrow drop-down boxes found within the document
and scroll to the bottom
- Click (NonBlanks)
- Click Edit, Copy
To Paste the Roster into a New Excel Blank Sheet
- Click File, New, OK (Workbook,
General tab)
- Cursor will be positioned in cell 1A
- Click Edit, Paste,
- Click Format, Row, Height (enter 14), OK
- Click Format, Column, AutoFit Selection
To Remove Yellow Highlight
(added 09-20-02)
- Click Format, Cells, Patterns, No Color, OK
To Align Text Left
(added 09-20-02)
- Click
Format, Cells, Alignment, Left
To
Save the New File
- Click File, Save As, type in a File name, click Save
**Credits:
Philip W. Cash,
Graduate Assistant, Masters in Biology candidate, Dr. William C. Wood,
Professor, Economics Program, Safaa Najdi, Graduate Assistant, Masters
candidate in Computer Science; 11-06-00
Contact:
Loretta
Grunewald, (568-3216)
Senior Support Staff, 4th Floor Work Center, College of Business, James Madison University. Last reviewed
01/15/2008