{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":148,"n_cols":9,"rows_kept":148,"merged":[[0,0,0,8],[1,0,1,8],[3,0,3,1],[3,5,3,6],[4,0,4,1],[5,0,5,1],[7,0,8,9],[10,0,11,9],[32,2,32,3],[34,2,34,3],[41,0,42,9],[44,0,45,9],[83,2,83,3],[93,0,93,9],[94,0,96,9],[128,2,128,3],[147,0,148,9]]}
["University Template for Merit Adjustments"]
["Professor +5, +10, +15"]
[]
["Name:",{"$nulls":3},"Years:"]
[]
["Department/School:",null,"University Libraries"]
[]
["All activities count as 1 activity each, such that completing 2 of the same activities within 1 year constitutes having completed 2 of those activities that year. No fractional amounts or rounding shall be permitted. The number of completed activities should be written in the year they were completed. Activities that overlap shall receive points in only 1 area. "]
[]
[]
["Teaching/Primary Duties: For a rating of Satisfactory, faculty must meet tenure requirements in Teaching/Primary Duties, and for a rating of Outstanding, faculty must meet tenure requirements in Teaching/Primary Duties and also complete eight (8) of the following activities: "]
[]
[]
[{"$nulls":4},"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,1,"Assigned duties that exceed 18 ACEs in an academic year – up to 3 activities per 5 year cycle"]
[null,2,"Chairing a completed doctoral dissertation – up to 2 activities per 5 year cycle  "]
[null,3,"Chairing a completed master’s thesis – up to 2 activities per 5 year cycle"]
[null,4,"Departmental independent study/readings (1 activity per 6 sh completed)                            Total:",{"$f":"SUM(E18+F18+G18+H18+I18)","v":0}]
[null,5,"Undergraduate research supervision of projects presented and completed (URD)"]
[null,6,"Honor’s thesis advised and completed"]
[null,7,"Student research advised and presented off campus"]
[null,8,"Serving on a graduate thesis or project"]
[null,9,"Graduate project (non-thesis) advised and completed"]
[null,10,"Serving on a doctoral dissertation committee"]
[null,11,"Conversion of a face-to-face course to fully online format"]
[null,12,"Development of a new approved/fully delivered course"]
[null,13,"Major innovation in use of technology for teaching/primary duties"]
[null,14,"Graduate coordinator during summer when not on contract"]
[null,15,"Development and delivery of an approved service learning project"]
[null,16,"Professional development (1 activity per 5 workshops), limit of 5 activities per 5 year cycle"]
[null,17,"College Excellence Award in a teaching/primary duties area (1 activity credit per activity)"]
[null,18,"Supervising peer mentor, if not receiving ACEs (1 point per 2pm supervised)"]
[null,19,"Significant innovation in providing a Library collection, resource or service for student learning"]
[null,20,"Supervising graduate assistants doing library projects (1 activity per year)"]
[null,21,"Development of a new approved/delivered project or program enhancing Library Liaison activities "]
[null,22,"Development and delivery of an approved tool or project enhancing access to Library information and services"]
[null,23,"Serving on a major Library Collection project"]
[null,24,"Initial achievement of or recertification of a professional licensure or certification requiring education-based activates that supports your primary duties and/or department/college accreditation standards (1 activity per renewal)"]
[null,25,"Other teaching or primary-duty activity of comparable value"]
[null,null,"Total",null,{"$f":"SUM(E15+E16+E17+E19+E20+E21+E22+E23+E24+E25+E26+E27+E28+E29+E30+E31+E32+E33+E34+E35+E36+E37+E38+E39)","v":0},{"$f":"SUM(F15+F16+F17+F19+F20+F21+F22+F23+F24+F25+F26+F27+F28+F29+F30+F31+F32+F33+F34+F35+F36+F37+F38+F39)","v":0},{"$f":"SUM(G15+G16+G17+G19+G20+G21+G22+G23+G24+G25+G26+G27+G28+G29+G30+G31+G32+G33+G34+G35+G36+G37+G38+G39)","v":0},{"$f":"SUM(H15+H16+H17+H19+H20+H21+H22+H23+H24+H25+H26+H27+H28+H29+H30+H31+H32+H33+H34+H35+H36+H37+H38+H39)","v":0},{"$f":"ROUNDDOWN(SUM(I15+I16+D18/6+I17+I19+I20+I21+I22+I23+I24+I25+I26+I27+I28+I29+I30+I31+I32+I33+I34+I35+I36+I37+I38+I39),)","v":0}]
[]
["Note:  If activities overlap, the faculty member can only count the activity in one area.  For instance, if the faculty member advises a thesis or research project and counts this as an activity, they cannot count a presentation of that project as another activity. "]
[]
[]
["Scholarly/Professional Activities: For a rating of Satisfactory, faculty must complete 6 of the following activities, and for a rating of Outstanding, faculty must either: (1) complete eight (8) of the following activities, at least 1 of which must be from Category A, or (2) complete 10 of the following activities."]
[]
[]
[null,null,"Category A:  Higher-level contributions",null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,26,"Publication of a book by a university press/national publisher which is scholarly and peer-reviewed"]
[null,27,"Publication of a peer-reviewed journal article"]
[null,28,"Publication of a college level textbook by a recognized publisher"]
[null,29,"Recipient of national/international scholarly/professional/creative activities award"]
[null,30,"Competitive, major, Sponsored Projects approved external grant award above $15,000"]
[null,31,"Peer-reviewed article published in proceedings of a national/international conference"]
[null,32,"Invited performance or peer-reviewed show wherein performance or artistic work is accepted"]
[null,33,"Publication of a chapter(s) in a book (if peer-reviewed)"]
[null,34,"Editor of a national, peer-reviewed journal"]
[null,35,"College Excellence Award in a scholarly/professional area (1 activity credit per activity) "]
[null,36,"Distinguished Faculty Lecturer"]
[null,37,"Creator/organizer of a professional conference/workshop"]
[null,38,"An equivalent professional or scholarly activity"]
[null,null,"Total",null,{"$f":"SUM(E49:E61)","v":0},{"$f":"SUM(F49:F61)","v":0},{"$f":"SUM(G49:G61)","v":0},{"$f":"SUM(H49:H61)","v":0},{"$f":"SUM(I49:I61)","v":0}]
[]
[null,null,"Category B:  Moderate-level and lower-level contributions",null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,39,"Delivery of a peer-reviewed presentation (international, national or regional)"]
[null,40,"Editor of a scholarly/technical book"]
[null,41,"Publication of a monograph by a reputable publisher or professional organization"]
[null,42,"Competitive, Sponsored Projects-approved external grant award below $15,000"]
[null,43,"Publication in a peer reviewed state-level journal"]
[null,44,"Publication of a book review"]
[null,45,"Delivery of a peer-reviewed, state-level conference paper"]
[null,46,"Editor of state/regional journal"]
[null,47,"Membership of and contribution to an editorial board"]
[null,48,"Submission of an unfunded Sponsored Projects approved, external grant"]
[null,49,"Awarded internal university level competitive grant"]
[null,50,"Summer stipend awarded"]
[null,51,"Peer review of multiple articles for a professional publication"]
[null,52,"Conference submission reviewer"]
[null,53,"Organizing a session at a professional conference"]
[null,54,"Non-juried, scholarly presentation or workshop"]
[null,55,"Indexer/abstractor for an entire volume of a professional publication"]
[null,56,"Translator of a scholarly journal article or book published by a non-vanity press"]
[null,57,"Major approved computer application or metadata project (not part of one's primary duties)"]
[null,58,"Developer of the intellectual content of a professional website (not part of one's primary duties), moderator of a professional electronic discussion group, or producer of a multimedia work"]
[null,59,"Significant article in a professionally-recognized magazine or journal"]
[null,60,"Appointed to library consortium committee or task force, e.g. CARLI, OCLC, etc."]
[null,61,"Visiting professor, lecturer, or scholar in (one's professional area of expertise) at a college, university, or professional institute"]
[null,62,"Substantial approved in-house publication or internal research related to library operations (not part of one's primary duties)"]
[null,63,"Successfully-completed approved for-credit course work related to professional development"]
[null,64,"Serving as a CITR Teaching or Research Faculty Associate, if not receiving ACEs"]
[null,65,"An equivalent professional or scholarly activity"]
[null,null,"Total",null,{"$f":"SUM(E65:E91)","v":0},{"$f":"SUM(F65:F91)","v":0},{"$f":"SUM(G65:G91)","v":0},{"$f":"SUM(H65:H91)","v":0},{"$f":"SUM(I65:I91)","v":0}]
[]
["Service Activities: (minimum of 6 activities required for Satisfactory rating; minimum of 8 activities, one in Category A, for Outstanding rating)"]
["For a rating of Satisfactory, faculty must complete 6 of the following activities, and for a rating of Outstanding, faculty must either: (1) complete eight (8) of the following activities, at least 1 of which must be from Category A, or (2) complete 10 of the following activities."]
[]
[]
[null,null,"Category A",null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,66,"Chair or member of a major university council/committee that meets 1 to 2 times per month (i.e. Graduate Council, CGE, CCPI, CAGAS, Faculty Senate, etc.) if not receiving ACES"]
[null,67,"Significant leadership position in one’s professional organization"]
[null,68,"Search committee chair"]
[null,69,"DPC chair"]
[null,70,"CPC or UPC chair (if 4 or more portfolios are evaluated) "]
[null,71,"Chair, active department/college committee (meets at least 1 to 2 times a month)"]
[null,72,"College Excellence Award in a service area (1 activity credit per activity)"]
[null,73,"Member of the IRB or IACUC"]
[null,74,"Equivalent service activity"]
[null,null,"Total",null,{"$f":"SUM(E99:E107)","v":0},{"$f":"SUM(F99:F107)","v":0},{"$f":"SUM(G99:G107)","v":0},{"$f":"SUM(H99:H107)","v":0},{"$f":"SUM(I99:I107)","v":0}]
[]
[null,null,"Category B",null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,75,"Maintenance of department hardware/software used by multiple courses/faculty"]
[null,76,"Chair or member of a major department/college/university committee that meets irregularly"]
[null,77,"Chair, CPC or UPC (if 3 or fewer portfolios are reviewed)"]
[null,78,"Search committee member"]
[null,79,"Member of Faculty Senate ad-hoc committee if meets at least, on average, once a month for a full year (i.e. Distance Learning ad-hoc committee, Foreign Language/Global Issues Committee, GERC, Online Course Information Implementation Committee, etc.)"]
[null,80,"Member of UPI negotiating team (up to 6 members may earn an activity point/year during negotiations with the University) if not receiving ACEs"]
[null,81,"Member of UPI Executive Committee (VP, Secretary, Treasurer) if not receiving ACEs"]
[null,82,"Member of other standing Faculty Senate Committees/Councils (or University Committees) that meet less regularly than 1 or 2 times a month (examples: WID, CIA, CCPU, CIE, COC, Committee on President and Provost Performance, etc.)"]
[null,83,"Chair of standing department committee not already under Category A"]
[null,84,"Officially assigned and actively engaged as faculty mentor"]
[null,85,"Student organization advisor"]
[null,86,"Member of standing/active, time intensive department/college committee that meets regularly"]
[null,87,"Non-juried presentation or workshop (not scholarship in nature)"]
[null,88,"Significant recruiting/retention activities (if not receiving ACEs)"]
[null,89,"Chairperson or coordinator of local conference"]
[null,90,"Professionally-related substantial and ongoing outreach activities throughout the year"]
[null,91,"Committee member of a state, national, or international professional organization"]
[null,92,"Coordinate/organize approved library programming, if not otherwise compensated "]
[null,93,"Special approved project for the library or other university entity, if not otherwise compensated"]
[null,94,"Serving as a CITR Teaching or Research Faculty Associate, if not receiving ACEs"]
[null,95,"Equivalent service activity"]
[null,null,"Total",null,{"$f":"SUM(E111:E131)","v":0},{"$f":"SUM(F111:F131)","v":0},{"$f":"SUM(G111:G131)","v":0},{"$f":"SUM(H111:H131)","v":0},{"$f":"SUM(I111:I131)","v":0}]
[null,null,"Annual Total",null,{"$f":"SUM(E40+E62+E92+E108+E132)","v":0},{"$f":"SUM(F40+F62+F92+F108+F132)","v":0},{"$f":"SUM(G40+G62+G92+G108+G132)","v":0},{"$f":"SUM(H40+H62+H92+H108+H132)","v":0},{"$f":"SUM(I40+I62+I92+I108+I132)","v":0}]
[null,null,"Grand Total",null,{"$f":"(E133)","v":0},{"$f":"SUM(E133:F133)","v":0},{"$f":"SUM(E133:G133)","v":0},{"$f":"SUM(E133:H133)","v":0},{"$f":"SUM(E133:I133)","v":0}]
[]
["Year 1:",null,"Department Chair _______________________     DPC Chair _______________________",null,null,"Dean ______________________"]
[]
["Year 2:",null,"Department Chair _______________________     DPC Chair _______________________",null,null,"Dean ______________________"]
[]
["Year 3:",null,"Department Chair _______________________     DPC Chair _______________________",null,null,"Dean ______________________"]
[]
["Year 4:",null,"Department Chair _______________________     DPC Chair _______________________",null,null,"Dean ______________________"]
[]
["Year 5:",null,"Department Chair _______________________     DPC Chair _______________________",null,null,"Dean ______________________"]
[]
[]
["Additional Notes:"]
["Departments, subject to the contractual process, may add equivalent activities; otherwise, no changes may be added to or removed from this document during the trial period outlined in the Memorandum of Understanding."]