Until we have a more automated way to do it ... here is a technique to let you create a class roll (attendance list) in Excel from Banner. It involves using Internet Explorer and Excel at the same time .. and we copy and paste the class roll information from one to the other (but then have to clean it up a little!).
To begin .. open Internet Explorer and log in to Banner .... also open EXCEL (have both programs open at the same time).
Step 1) Go to MY.LTU.EDU and Log in to the Secure area of BannerWeb.
(Note : This technique will probably only work with INTERNET EXPLORER, since we are copying/pasting to Excel).
Step 2) Under the Faculty Services, select the term, and then go to the SUMMARY CLASS LIST.
Step 3) Choose which class you want to use.
Step 4)You should get a list of students, IDs, and a bunch of other stuff. Click the mouse down to the left of the first student number, hold the mouse button down, to select all the student information ("click and drag" to select). [Note : I have blanked out, or faked the student numbers here for security purposes.]
Step 5) This is what the "selected" students would look like ... now you can release the mouse button.
Step 6) Go to the EDIT menu, and select COPY (this will copy that information to the "clipboard" - we can paste it into Excel).
Note : We are actually going to Paste the data to Excel, copy it again, and then paste it again ... it's crazy, but it just might work!
Step 7) Now switch over to Excel (you could Alt-Tab if it is open, or click on the application in the bottom task bar). Click into the first cell (A1) and then go to the EDIT menu and select PASTE
Note : You should get all the data into the spreadsheet, but the formatting will look very weird ... don't worry, we are going to clean it up!
Step 8) Here is what the spreadsheet should look like ... not pretty huh?
This is actually just a temporary paste ... we are going to now clean it up a little. For example .. there are "links" with those student names .. but they won't work in Excel, so we need to "unlink" them! ... PasteSpecial to the rescue!
Step 9) Without clicking the mouse (i.e. leaving everything selected) - go to the EDIT menu and select COPY again!
Step 10) Go to the FILE menu, select NEW .. this will create a new worksheet in Excel
Step 11) This time when we paste (go to EDIT menu), we want to PASTE SPECIAL - select VALUES then OK
Step 12) Now this is looking a litttle cleaner!
At this point, you could delete whichever columns you don't need to have (for me, I keep the userID column and the names column, and get rid of the rest. You can click on the column header itself (such as the Letter A above) - that should highlight the whole column, then go to Edit and select DELETE. Or you could select multiple columns (click down on one, and drag sideways to select the others), and then delete them.
Step 13) Cleaning up the Student ID - let's format it! Select the B column (in this case) and then go to FORMAT then CELLS.
Step 14) Choose the NUMBER tab, then CUSTOM category .. then type in 9 zeros (this is the "mask" for the id number)
Step 15) You should have the Banner ID showing up as the 0-padded 9 digit id (looks neater).
Step 16) Now you can save this Excel file (you can close the "original" file .. you don't have to save that - it has all that weird formatting that you don't want)!
Return to the Laptop help page
Last Updated = Friday, 03-Feb-2006 22:34:48 EST Of the 74 people that have visited this site, you are the most recent.