{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Example","Grade Tracker and Action Plan T"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[[9,0,9,5],[10,0,10,5],[11,0,11,5],[12,0,12,25],[0,0,2,5],[3,0,3,5],[4,0,4,25],[5,0,5,6],[6,0,6,5],[7,0,7,5],[8,0,8,5]]}
["Instructions for Grade Tracker & Action Planner"]
[]
[]
["Scholarship Chairs: This tool is designed to assist you in tracking the grades of members/Associate Members, give you an idea of what your chartered/provisional chapter GPA will be at the end of the term, and provide a quick reference of the academic standing (including requirements and restrictions) of each member/associate member. This should be shared with the ABT scholarship advisor. It should not be shared with anyone else. Below are instructions for how to use this tool. Please read everything carefully before starting. If you have questiions or need assistance, please reach out to the office success manager for scholarship chairs."]
["You must make a copy of this document before using it -- make your copy first and then follow the rest of the directions."]
["- All information in the red columns should be entered as it would appear on a grade report."]
["- The term & cumulitve GPAs in the Buff section will auto-populate -- DON'T EDIT THIS COLUMN"]
["- The formula should extend all the way down to cell 130. If you have more than 130 members/Associate Members in your chartered/provisional chapter, simply click on the formula and change the last number in the data set (either D6:D130 or E6:E130) to whatever additional cells your data extends to. Otherwise, you can just let the formula do the work."]
["- This should give you the most accurate snapshot of what your chartered/provisional chapter's average GPA will be at the end of the term, assuming everyone is being transparent about their grades. "]
["- You can determine what level of academic standing should be entered into the corresponding column in accordance with your chartered/provisional chapter's scholarship/academic plan. This example aligns with the sample scholarship plan provided with your officer resources. Academic standing should be based on the cumulative and most-recent term GPA -- if these will place a member/associate member in different categories, it is a best practice to default to academic standing for the lower of the two to ensure the member/Associate Member is getting the necessary support."]
["- Action plans should be based on your scholarship program. The scholarship program must align with your chartered/provisional chapter bylaws, meet or strengthen Delta Chi Law requirements, and align with university expectations. "]
["- Remember: It is your job as the scholarship chair of your chapter to ensure the chartered/provisional chapter lives up to Delta Chi's core value of \"assisting in the acquisition of a sound education.\" This document should be a resource to track, encourage, and assist your brothers in improving their overall grades, and in turn help assure that Delta Chi is invested in helping them achieve the best education possible. Action plans should always offer support and guidance first, rather than punishment. "]
["- The \"Notes\" column should be used by the scholarship chair to track action plan steps completed and record when restricted attendance at social events or intramural events is used."]

{"sheet":"Example","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,3,4],[0,5,0,7],[0,8,3,8],[1,5,1,7],[2,5,2,7],[3,5,3,7]]}
["Delta Chi Fraternity Grade Tracker & Action Planner",{"$nulls":4},"Chapter Average Term GPA:"]
[{"$nulls":5},{"$f":"ROUND(AVERAGE(D6:D130),2)","v":2.91}]
[{"$nulls":5},"Chapter Cumulative GPA:"]
[{"$nulls":5},{"$f":"ROUND(AVERAGE(E6:E130),2)","v":3.05}]
["First Name","Last Name","Student ID","Term GPA","Cumualtive GPA","Level of Academic Standing","Requirements","Restrictions","Notes"]
["Albert","Barnes",2525402.0,2.94,3.15,"Good","2 Learning Activities per week","N/A"]
["Myron","Crandel",2560029.0,3.94,3.94,"Exceptional","N/A","N/A"]
["John","Gorham",2552926.0,3.09,3.09,"Good","2 Learning Activties per week","N/A"]
["Peter","Johnson",2521605.0,3.53,3.65,"Exceptional","N/A","N/A"]
["Edward","O'Malley",2552356.0,2.58,2.58,"At-Risk (High)","7 Learning Activities per week (3 must be tier 2 or higher, and 2 must be tier 3), review Academic Reflection with the scholarship chair or a member of the scholarship committee, meet with the scholarship chair or a member of the scholarship committee every other week, and meet with the health and wellness chair once a month","1 social event a month and needs scholarship chair approval before playing intramural sports","8/25 - reviewed Aademic Reflection\nMeeting with scholarship chair every other Tuesday at 10am\nMet with health and wellness chair - August, September\n9/12 - social event attended"]
["Owen","Potter",2554161.0,3.67,3.67,"Exceptional","N/A","N/A"]
["AD","Stillman",2534793.0,2.2,2.69,"Probation ","10 Learning Activities per week (4 must be tier 2 or higher and an additional 3 must be tier 3), review Academic Reflection with the scholarship chair or a member of the scholarship committee, meet with scholarship chair or a member of the scholarship committee weekly, meet with health and wellness chair once a month, and meet with ABT scholarship advisor, \"BB\" - chapter advisor, or faculty advisor every 6 weeks","1 social event a term (must show current grades to scholarship chair before getting permission to attend), cannot serve as an officer, cannot play intramural sports; and loss of voting privileges","8/30 - reviewed Aademic Reflection\nMeeting with James on the scholarship committee every Monday at 3pm\nMet with health and wellness chair - August, September\n**Has NOT met with advsior for first six weeks yet - one more reminder, then refer situation to the \"F\""]
["Thomas","Sullivan",2541608.0,2.8,2.91,"Satisfactory","3 Learning Activities per week (at least 1 must be tier 2 or higher)","N/A","Week of 9/8 - all Learning Activities came from Tier 1, gave him a reminder about Tier 2 expectation and he said he forgot, has been doing well since then"]
["Monroe","Sweetland",2559746.0,0.75,0.75,"Probation","10 Learning Activities per week (4 must be tier 2 or higher and an additional 3 must be tier 3), review Academic Reflection with the scholarship chair or a member of the scholarship committee, meet with scholarship chair or a member of the scholarship committee weekly, meet with health and wellness chair once a month, and meet with ABT scholarship advisor, \"BB\" - chapter advisor, or faculty advisor every 6 weeks","1 social event a term (must show current grades to scholarship chair before getting permission to attend), cannot serve as an officer, cannot play intramural sports; and loss of voting privileges","8/26 - reviewed Aademic Reflection\nMeeting with scholarship chair every Thursday (during chapter study hours)\nMet with health and wellness chair - August, September\n9/12 - social event attended"]
["Thomas","Watkins",2532616.0,1.83,2.69,"Probation","10 Learning Activities per week (4 must be tier 2 or higher and an additional 3 must be tier 3), review Academic Reflection with the scholarship chair or a member of the scholarship committee, meet with scholarship chair or a member of the scholarship committee weekly, meet with health and wellness chair once a month, and meet with ABT scholarship advisor, \"BB\" - chapter advisor, or faculty advisor every 6 weeks","1 social event a term (must show current grades to scholarship chair before getting permission to attend), cannot serve as an officer (must step down from position as \"C\"), cannot play intramural sports; and loss of voting privileges","8/24 - reviewed Aademic Reflection\nMeeting with Tim on scholarship committee every Monday at 5pm **skipped first 2 meetings, started attending after talking to scholarship chair and F\nMet with health and wellness chair - August, September"]
["Frederick","Whitney",2552552.0,3.64,3.64,"Exceptional","N/A","N/A"]
["Sir Edward","Coke",2522804.0,4.0,3.87,"Exceptional","N/A","N/A"]

{"sheet":"Grade Tracker and Action Plan T","index":2,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,3,4],[0,5,0,7],[1,5,1,7],[2,5,2,7],[3,5,3,7]]}
["___________ Chartered/Provisional Chapter \nof Delta Chi Fraternity \nGrade Tracker & Action Planner",{"$nulls":4},"Chapter Average Term GPA:"]
[{"$nulls":5},{"$f":"ROUND(AVERAGE(D6:D130),2)","v":"#DIV/0!"}]
[{"$nulls":5},"Chapter Cumulative GPA:"]
[{"$nulls":5},{"$f":"ROUND(AVERAGE(E6:E130),2)","v":"#DIV/0!"}]
["First Name","Last Name","Student ID","Term GPA","Cumualtive GPA","Level of Academic Standing","Requirements","Restrictions","Notes"]