Differences

This shows you the differences between two versions of the page.

--- batch_uploading_etds_to_scholarworks [2017/02/01 18:37]
ldegozzaldi [Adding “OPT-OUTS” TO Scholarworks Metadata Spreadsheets]
+++ batch_uploading_etds_to_scholarworks [2017/02/01 18:37]
ldegozzaldi [Adding “OPT-OUTS” TO Scholarworks Metadata Spreadsheets]
@@ Line 118: / Line 118: @@
   - Make a new copy of the Master File Sheet 2 (all titles) of the ETD Master File, retaining only columns R (Opt-ins/Opt-outs), A or J (Author), B (Department), C (Year), D (Masters/PhDs) and title (F).  Make sure all data is connected, with no blank columns between, and sort on column R.
   - Retain only the rows with Opt-out in Column R.
-  - After sorting on R, delete all rows which do not contain "Opt-out." **Transfer any __new__ Opt-out information to ETD Opt-out Tracking sheet.xlsx, also present in the W: Drive in the same location as the Master File.**  (Hint: Sort by Department to isolate the new Opt-outs, as reported to us. Run a duplicate check on the ETD Out-out Tracking sheet, to be sure we don't already have any of this added information.)
+  - After sorting on R, delete all rows which do not contain "Opt-out." **Transfer any __new__ Opt-out information to ETD Opt-out Tracking sheet.xlsx, also present in the W: Drive in the same location as the Master File.**  (Hint: Sort by Department to isolate the new Opt-outs, as reported to us.  Run a duplicate check on the ETD Out-out Tracking sheet, to be sure we don't already have any of this added information.)
   - When the ETD's on the Opt-out list are in process, enter this information on the ETD Opt-out Tracking sheet, together with date.
   - When the ETD's have been uploaded to ScholarWorks and uploaded and downloaded to Connexion and Aleph, enter DONE on the ETD Opt-out Tracking sheet, together with date.