john cooney research systems project, training and web manager monash research office research...
Post on 20-Jan-2016
213 views
TRANSCRIPT
![Page 1: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/1.jpg)
John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems
How to obtain your DIISR points via ROPES
![Page 2: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/2.jpg)
Click on my.monash portal
![Page 3: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/3.jpg)
Login…wambaru
●●●●●●●●
![Page 4: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/4.jpg)
Click on Research
![Page 5: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/5.jpg)
Now click on Services
![Page 6: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/6.jpg)
Click on the link to ROPES
![Page 7: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/7.jpg)
Click on My Publications
![Page 8: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/8.jpg)
Click on My Publications (again)
This is ROPES’ snapshot screen
![Page 9: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/9.jpg)
Click on DIISR point listing
Your publications display, below…
![Page 10: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/10.jpg)
Author Contribution is the column of interest…Now, scroll to the bottom of the page…
![Page 11: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/11.jpg)
Here we are at the bottom of the page.
Click the Download to Excel link
Download the entire table to your pc:
![Page 12: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/12.jpg)
Click OK to save the file on your pc
![Page 13: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/13.jpg)
Note filename: diisr_points.csv
Save the file somewhere where you can easily access it…
![Page 14: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/14.jpg)
We will now open up the file in MS Excel and I’ll step you through what’s left to do…
Go to where you stored the file on your hard drive and open it (in this example, it was stored in My Documents).
![Page 15: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/15.jpg)
Double-click the file to get started…
![Page 16: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/16.jpg)
Here’s the file, open in MS Excel…and the Author Contribution column
![Page 17: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/17.jpg)
Select the row containing the column headers, like this….
![Page 18: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/18.jpg)
…and now click on Sort & Filter
(users of older versions of MS Excel: click on Data menu > Filter > Autofilter)
![Page 19: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/19.jpg)
…and click Filter
![Page 20: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/20.jpg)
Dropdown boxes appear next to each column
headerWe can use them to
filter the table to show only what we are interested in
Let’s say we only want to see publications (and their points) published from 2007 to 2010 AND only those that fall in DIISR (formerly DEST, DEEWR) categories. No problem…
![Page 21: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/21.jpg)
Let’s do the years of interest first…Click on the YearPublished column’s dropdown box…
![Page 22: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/22.jpg)
Remove the tick from (Select All) and re-select only the years of interest
![Page 23: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/23.jpg)
…now select the years of interest and click OK
![Page 24: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/24.jpg)
![Page 25: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/25.jpg)
![Page 26: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/26.jpg)
![Page 27: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/27.jpg)
Now only records from the years of interest display
![Page 28: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/28.jpg)
We are only interested in publications in the following four categories: A1, B1, C1 and E1…
Any record belonging to a category with “hyphen-something” at the
end, must be filtered out e.g. C1-EXT, C1-LATE, etc.
AND - any record belonging to a category with a number other than 1
in it, must also be filtered out e.g. A2, B2, C2, E4, etc.
To hide records in non-DIISR categories (there is only one in
the example above) it is a similar operation as for year…
This time, however, we’ll filter on the DIISRCat column, like this..
![Page 29: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/29.jpg)
![Page 30: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/30.jpg)
![Page 31: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/31.jpg)
![Page 32: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/32.jpg)
Now we are looking at just DIISR publications across the years required.
While you could manually add up the figures in the Author Contribution column,
there is another way...
![Page 33: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/33.jpg)
Select all the visible cells in the table, including the column headings (Ctrl+A)
![Page 34: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/34.jpg)
Copy all the visible cells in the table (Ctrl+C).Only the filtered cells are selected.Now we will create a new worksheet and
copy just the relevant records to it.Click the create new worksheet button below…
![Page 35: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/35.jpg)
We just created a new worksheet. Now paste in the records (Ctrl+V)…
![Page 36: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/36.jpg)
Now only those records we are interested in appear aboveSelect the cell at the foot of the
AuthorCntbtn column.
![Page 37: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/37.jpg)
The final step is to tally up the DIISR Author Contribution points.
Click the AutoSum button (Σ):
![Page 38: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/38.jpg)
Lastly, hit the Enter key on your keyboard:
![Page 39: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/39.jpg)
Done!If your version of MS Excel doesn’t have an AutoSum button, click the fx button…
![Page 40: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/40.jpg)
Enter “SUM” into Search for a function: (no quotes) then click the Go button
SUM
![Page 41: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/41.jpg)
Enter “SUM” into Search for a function: (no quotes) then click the Go button
SUM
![Page 42: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/42.jpg)
Under Select a function: ensure SUM is selected. Now click OK
SUM
![Page 43: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/43.jpg)
…and click OK one more time
![Page 44: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/44.jpg)
Done!
![Page 45: John Cooney Research Systems Project, Training and Web Manager Monash Research Office Research Information Systems How to obtain your DIISR points via](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649d365503460f94a0e543/html5/thumbnails/45.jpg)
You will want to save your work in a format that supports filters and
formulae…So save your file in .xlsx or .xls format