{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Project","Product","Communication-Interaction","Process","Assessment"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Project","index":0,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[14,0,14,6],[19,4,32,10],[6,1,12,6]]}
["Interim Faculty Coach Evaluation"]
["Team:"]
["Project:"]
["Sponsor:"]
["Coach:"]
[]
["Instructions:","This rubric is intended for use at the end of the first quarter of senior project.  The faculty coach assesses the project on these criteria based on all available inputs: observing the project team, examining their work products, team evaluations of each other, faculty evaluations of presentations, and sponsor feedback.\n\nThe rating here does not necessarily directly map to a grade – it is left to the faculty member to arrive at an overall assessment.  It is intended as a comprehensive interim assessment of all aspects of team performance, and also to be used for accreditation assessment.\n\nNote to faculty coach: Please provide an overall assessment of the team on this worksheet, and use the other three worksheets to assess the Product, Communication, and Process aspects of the team's performance.  If an assessment category is not applicable for this particular project, leave that entry blank.  It will be left out of the maximum calculated on that worksheet."]
[]
[]
[]
[]
[]
[]
[]
["Achieving Customer Satisfaction"]
["Category","Poor\n1-2 points ","Needs Work\n3-4 points","Fair\n5-6 points","Good\n7-8 points","Very Good/Excellent\n9-10 points","Score"]
["Customer Satisfaction","Completely dissatisfied","Significant reservations","Some minor complaints","Customer satisfied","Customer delighted"]
[]
[null,"Maximum","Total",null,"Overall comments:"]
["Product",{"$f":"ProductMax","v":0},{"$f":"ProductTotal","v":0}]
["Communication/\nInteraction",{"$f":"CommunicationMax","v":0},{"$f":"CommunicationTotal","v":0}]
["Process",{"$f":"ProcessMax","v":0},{"$f":"ProcessTotal","v":0}]
["Totals",{"$f":"SUM(B20:B22)","v":0},{"$f":"SUM(C20:C22)","v":0}]

{"sheet":"Product","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Product"]
["Category","Poor\n1-2 points ","Needs Work\n3-4 points","Fair\n5-6 points","Good\n7-8 points","Very Good/Excellent\n9-10 points","Score","Comments"]
["Submission and content accuracy of documents","Significant number of documents missing with documents containing very inaccurate and/or incomplete information","Most documents submitted and somewhat accurate; more than a few inconsistencies or errors","Most documents submitted and mostly accurate; few inconsistencies or errors.","Most documents submitted and completely accurate; No inconsistencies or errors","Most documents submitted and completely accurate; No inconsistencies or errors with excellent presentation style and attention to detail"]
["Requirements","Team missed several key requirements","Some key requirements missed","Requirements had errors or were not clarified adequately","Requirements adequately elicited, documented and understood.","Requirements elicitation proactive, documentation very complete and clear."]
["Design","Hardly any design done or documented.","Design significantly inappropriate and missed several key concerns.  ","Design somewhat inadequate – some concerns not addressed or documented adequately","Design adequate and appropriate and documented.  Major design concerns addressed.","Several alternatives explored, eventual design well-suited to application needs."]
["Implementation ","Implementation quality completely unacceptable. Documentation poor ","Implementation artifacts had significant problems or difficult to understand; Implementation is not documented well. ","Implementation is marginal or not well thought through.  Implementation is sufficiently documented but is hard to understand.","Implementation artifacts reasonably sound. Implementation is well documented and easy to understand.","Implementation artifacts of excellent quality Implementation is well documented and easy to understand"]
["Testing","Hardly any testing done.","Testing was completely ad hoc and inadequate.","Test strategy inadequate or inappropriate, testing not thorough.","Testing was reasonably complete, strategy acceptable.","Very sound strategy, thorough testing of all deliverables."]
["Attention to Quality Concerns: Verification and Validation, Product Quality Attributes (“-ilities”)","Key quality concerns not identified or addressed.","Patchy attention to quality concerns, some concerns missed.","Quality concerns addressed somewhat inadequately.","Reasonably good job of identifying and addressing quality concerns.","Quality concerns explicitly identified and considered fully at every stage."]
[" Attention to issues in broader context of project (ethics, economics, social impacts, cost, sustainability, etc).","Key issues not identified or addressed.","Patchy attention to broader context, some issues missed or poorly addressed.","Issues in broader context identified and addressed somewhat inadequately.","Reasonably good job of identifying and addressing issues in broader context.","Issues in broader context explicitly identified and considered fully at every stage."]
["Total",null,null,null,"Maximum:",{"$f":"10*COUNT(G3:G9)","v":0},{"$f":"SUM(G3:G9)","v":0}]

{"sheet":"Communication-Interaction","index":2,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Communication and Interaction"]
["Area","Poor\n1-2 points ","Needs Work\n3-4 points","Fair\n5-6 points","Good\n7-8 points","Very Good/Excellent\n9-10 points","Score","Comments"]
["Communication with Customer","Hardly ever contacted customer, resulting in large communication gaps.","Did not keep customer informed, did not obtain clarifications when needed.","Occasional gaps in communication,  resulting in some disconnects.","Interacted adequately with customer, kept them reasonably well-informed.","Interacted very well, keeping customer fully in picture as needed and making sure that there were no concerns."]
["Customer Education","Team had a negative attitude towards the customer and did not bother to assist them.","Team blindly accepted customer inputs, did not convey own knowledge adequately. ","Team missed some occasions when customers needed education or clarifications were needed.","Team provided technical inputs to customer when needed or asked for.","Team made sure at every stage to educate customer and provide/seek clarifications."]
["Teaming Effectiveness","Team fractured, unable to work together constructively.","Team had some significant frictions and lack of mutual cooperation.","Team had some significant disconnects and frictions, but worked through them.","Team worked reasonably well together, no problems visible.","Team picked each other up, allocated work well, worked together as a cohesive whole."]
["Communication with faculty coach","Team had major frictions with faculty coach, did not seek help when needed or accept inputs.","Faculty coach not kept adequately in picture, or inputs often ignored.","Some gaps in communication with coach, inputs sometimes ignored or not sought when needed.","Reasonably good working relationships, fairly regular updates.","Faculty coach kept well in picture, inputs sought and used effectively as needed."]
["Communication with dept. personnel","Major problems in interactions with dept personnel.","Some frictions in interactions, significant omissions.","Some gaps: missed notifying or asking help /  permission.","No problems noticed.","Worked well with dept personnel, pleasure to work with."]
["Team Website","No team website. ","Website mostly useless – major documents missing, no regular updates.","Website updated at irregular intervals, OK contents.","Website adequate: reasonable contents, fairly regular updates.","Consistent updates, website was major enabler for communication."]
["Total",null,null,null,"Maximum:",{"$f":"10*COUNT(G3:G8)","v":0},{"$f":"SUM(G3:G8)","v":0}]

{"sheet":"Process","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Process"]
["Area","Poor\n1-2 points ","Needs Work\n3-4 points","Fair\n5-6 points","Good\n7-8 points","Very Good/Excellent\n9-10 points","Score","Comments"]
["Process Definition","Process not defined.","Process defined, but completely ignored during project.","Process definition was somewhat inappropriate or incomplete. ","Team selected a reasonable set of processes, generally followed them. ","Processes well matched to project, followed effectively."]
["Domain Understanding","No effort to gain understanding of problem domain or usage model.","Large gaps in understanding of problem domain and usage.","Domain understanding somewhat fuzzy.","Adequate grasp of domain and usage.","Solid domain understanding, effective utilization in solution design"]
["Planning & Tracking","Completely inadequate plans, no tracking.","Haphazard planning, hardly any tracking","Plans made, but not updated regularly.  Tracking inadequate.","Adequate plans, progress tracked reasonably well.","Systematic planning and re-planning, systematic tracking"]
["Meeting Schedule","Project not completed in time, or not on track for completion","Only partial delivery of commitments because of uncontrolled slippage.","Some slippage in commitments, without prior intimation","Deadlines generally met, no major slip-ups.","All deadlines met, prior intimation of any changes in schedule."]
["Adopting New Technologies","Team completely failed at picking up new technologies and could not use them at all.","Use of new technologies became a major barrier impacting success of project.","Team struggled a bit with new technologies, but pulled through.","Team picked up technologies adequately, only minor glitches in usage. ","Team able to ramp up well on new technologies and apply them effectively."]
["Artifact Quality Control","Major problems with artifact versions, no QA before delivery","Artifacts showed significant lack of attention to detail, versioning was confusing, no revision history","Artifacts delivered to coach / customer had some obvious problems /inconsistencies","Artifacts cleaned up fairly well before delivery, no versioning problems ","Artifacts thoroughly inspected before delivery, clear revision history"]
["Use of Metrics","No metrics","Some minimal attempt to track metrics, not used ","Metrics usage inconsistent, interpretation inadequate","Team tracked metrics and used them in reflections","Team used metrics effectively to improve processes"]
["Total",null,null,null,"Maximum:",{"$f":"10*COUNT(G3:G9)","v":0},{"$f":"SUM(G3:G9)","v":0}]

{"sheet":"Assessment","index":4,"n_rows":33,"n_cols":21,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,14,0,20],[16,1,16,7],[20,0,21,0],[20,1,21,1],[20,2,20,6],[20,7,21,7],[0,1,0,7],[0,8,0,13]]}
[null,"Product",null,null,null,null,null,null,"Communication and Interaction",null,null,null,null,null,"Process"]
[null,{"$f":"IF(ISBLANK(TRANSPOSE(ProductAssessment)),\"\",TRANSPOSE(ProductAssessment))","v":""},"","","","","","",{"$f":"IF(ISBLANK(TRANSPOSE(CommunicationAssessment)),\"\",TRANSPOSE(CommunicationAssessment))","v":""},"","","","","",{"$f":"IF(ISBLANK(TRANSPOSE(ProcessAssessment)),\"\",TRANSPOSE(ProcessAssessment))","v":""},"","","","","",""]
[null,{"$f":"AbetQuintileBins(10,B2)","v":""},{"$f":"AbetQuintileBins(10,C2)","v":""},"","","","","","","","","","","","","","","","","",""]
[]
["(a) Apply math, science, engineering",null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,"X",null,null,"X","X"]
["(b) Design and conduct experiments",null,null,null,null,"X","X",null,null,null,null,null,null,null,null,null,"X"]
["(c) Design a system to meet needs",null,"X","X",null,"X","X",null,null,null,null,null,null,null,null,null,null,"X"]
["(d) Function on teams",null,null,null,null,null,null,null,null,null,"X",null,null,null,null,"X"]
["(e) Solve engineering problems",null,"X","X","X"]
["(f) Understand responsibilities",null,null,null,null,null,null,"X","X","X","X",null,"X",null,null,null,null,"X"]
["(g) Communicate effectively","X","X",null,null,null,null,null,"X","X",null,"X","X","X"]
["(h) Understand impact of solutions",null,null,null,"X",null,null,"X",null,null,null,null,null,null,null,"X"]
["(i) Life-long learning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",null,null,"X"]
["(j) Knowledge of contemporary issues",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
["(k) Tools for engineering practice",null,null,"X","X",null,null,null,null,null,null,null,null,null,"X",null,null,null,"X",null,"X"]
[]
["4010-562","Software Engineering Senior Project"]
[]
["Assessment type:","Team"]
[]
["Outcome","Team\nCount","Outcome team percentages",null,null,null,null,"Total Percent"]
[null,null,1,2,3,4,5]
["(a) Apply math, science, engineering",{"$f":"AbetAssessment(AssessmentData,OutcomeSupport)","v":0},0,0,0,0,0,{"$f":"SUM(C23:G23)","v":0}]
["(b) Design and conduct experiments",0,0,0,0,0,0,0]
["(c) Design a system to meet needs",0,0,0,0,0,0,0]
["(d) Function on teams",0,0,0,0,0,0,0]
["(e) Solve engineering problems",0,0,0,0,0,0,0]
["(f) Understand responsibilities",0,0,0,0,0,0,0]
["(g) Communicate effectively",0,0,0,0,0,0,0]
["(h) Understand impact of solutions",0,0,0,0,0,0,0]
["(i) Life-long learning",0,0,0,0,0,0,0]
["(j) Knowledge of contemporary issues",0,0,0,0,0,0,0]
["(k) Tools for engineering practice",0,0,0,0,0,0,0]