{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["汇总表","导师","评阅人","答辩"],"read":"whole","date_system":"1900"}

{"sheet":"汇总表","index":0,"n_rows":24,"n_cols":11,"rows_kept":24,"merged":[[0,0,0,10],[1,1,1,2],[1,4,1,10],[2,5,2,6],[2,7,2,8],[2,9,2,10],[3,0,5,0],[3,2,5,2],[3,5,3,6],[3,7,3,8],[3,9,3,10],[4,1,5,1],[4,4,5,4],[4,5,5,6],[4,7,5,8],[4,9,5,10],[6,5,6,6],[6,7,6,8],[6,9,6,10],[7,5,7,6],[7,7,7,8],[7,9,7,10],[8,5,8,6],[8,7,8,8],[8,9,8,10],[9,5,9,6],[9,7,9,8],[9,9,9,10],[10,5,10,6],[10,7,10,8],[10,9,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,6],[11,7,13,8],[11,9,13,10],[14,0,15,0],[14,2,15,2],[14,5,14,6],[14,7,14,8],[14,9,14,10],[15,5,15,6],[15,7,15,8],[15,9,15,10],[16,5,16,6],[16,7,16,8],[16,9,16,10],[17,0,19,0],[17,2,19,2],[17,5,17,6],[17,7,17,8],[17,9,17,10],[18,5,18,6],[18,7,18,8],[18,9,18,10],[19,5,19,6],[19,7,19,8],[19,9,19,10],[20,0,21,3],[20,4,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[22,0,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[23,0,23,4],[23,5,23,7],[23,9,23,10]]}
["济南大学机械工程专业\n《毕业设计》考核细则与成绩评定表"]
[null,"学生姓名：",null,"班级：","学号："]
["序号","毕业要求","支撑的课程目标","评价要素","分值","指导教师\n评分",null,"评阅教师\n评分",null,"答辩小组\n评分"]
[1,"3-1","课程目标1：掌握现代文献检索及资料查询技术，能够运用现代信息技术获取相关信息","根据课题任务开展调研，进行需求分析，设计任务是否合理",5,{"$f":"导师!F4","v":0},null,{"$f":"评阅人!F4","v":0},null,{"$f":"答辩!F4","v":0}]
[null,"2-1",null,"文献综述质量",5,{"$f":"导师!F5","v":0},null,{"$f":"评阅人!F5","v":0},null,{"$f":"答辩!F5","v":0}]
[{"$nulls":3},"参考文献规范性"]
[2,"2-2","课程目标2：培养学生具有综合运用所学理论知识和技能，分析解决实际问题的初步能力。","分解设计任务，进行功能设计",5,{"$f":"导师!F7","v":0},null,{"$f":"评阅人!F7","v":0},null,{"$f":"答辩!F7","v":0}]
[3,"3-2","课程目标3：考虑本领域的新产品、新工艺、新技术和新设备的基础上，应用设计理论及创新方法提出系统初步解决方案。","设计方案的创新性",5,{"$f":"导师!F8","v":0},null,{"$f":"评阅人!F8","v":0},null,{"$f":"答辩!F8","v":0}]
[4,"4-2","课程目标4：针对特定的设计题目，基于科学原理并采用科学方法，考虑设备、工艺、系统的应用场合/环境，对设计方案的可行性进行研究。","考虑设备、工艺、系统所针对的特定应用场合，分析设计方案的可行性",5,{"$f":"导师!F9","v":0},null,{"$f":"评阅人!F9","v":0},null,{"$f":"答辩!F9","v":0}]
[5,"6-2","课程目标5：了解和设计相关的安全、健康、法律等方面的知识，合理分析评价设计方案对上述因素的影响，并理解应承担的责任。","方案论证时，分析方案对社会、安全、法律及文化等因素的影响",5,{"$f":"导师!F10","v":0},null,{"$f":"评阅人!F10","v":0},null,{"$f":"答辩!F10","v":0}]
[6,"2-3","课程目标6：通过对多种方案进行比较、分析，确定合理设计方案。","方案论证的充分性与合理性，确定总体设计方案",5,{"$f":"导师!F11","v":0},null,{"$f":"评阅人!F11","v":0},null,{"$f":"答辩!F11","v":0}]
[7,"3-4","课程目标7：制图符合标准，设计说明书格式规范，条理清楚，计算正确。","图纸工作量与质量",25,{"$f":"导师!F12","v":0},null,{"$f":"评阅人!F12","v":0},null,{"$f":"答辩!F12","v":0}]
[{"$nulls":3},"设计说明书完整性与规范性"]
[{"$nulls":3},"设计计算正确性"]
[8,"5-1","课程目标8：能够针对特定设计题目，选择与使用相关设计手册、标准和现代设计工具","机械相关手册/标准的使用情况",5,{"$f":"导师!F15","v":0},null,{"$f":"评阅人!F15","v":0},null,{"$f":"答辩!F15","v":0}]
[null,"5-2",null,"现代设计工具的使用情况",5,{"$f":"导师!F16","v":0},null,{"$f":"评阅人!F16","v":0},null,{"$f":"答辩!F16","v":0}]
[9,"7-2","课程目标9：能够评价毕业设计内容对环境和社会可持续发展的影响。","考虑产品、设备、工艺、技术等对环境及社会可持续发展的影响",5,{"$f":"导师!F17","v":0},null,{"$f":"评阅人!F17","v":0},null,{"$f":"答辩!F17","v":0}]
[10,"10-1","课程目标10：能够清晰地表达设计思路、工作原理、技术路线，就复杂工程问题与同行进行沟通和交流。","口头表达逻辑性及清晰度，书面表达合理性",10,{"$f":"导师!F18","v":0},null,{"$f":"评阅人!F18","v":0},null,{"$f":"答辩!F18","v":0}]
[null,"10-2",null,"师生交流互动",10,{"$f":"导师!F19","v":0},null,{"$f":"评阅人!F19","v":0},null,{"$f":"答辩!F19","v":0}]
[null,"10-3",null,"英文摘要及英文翻译质量",5,{"$f":"导师!F20","v":0},null,{"$f":"评阅人!F20","v":0},null,{"$f":"答辩!F20","v":0}]
["总分",{"$nulls":3},100,{"$f":"SUM(F4:G20)","v":0},"分",0,"分",0,"分"]
[{"$nulls":5},{"$f":"\"（\"&IF(F21<60,\"不及格\",IF(F21<70,\"及格\",IF(F21<80,\"中等\",IF(F21<90,\"良好\",\"优秀\"))))&\"）\"","v":"（不及格）"},null,{"$f":"\"（\"&IF(H21<60,\"不及格\",IF(H21<70,\"及格\",IF(H21<80,\"中等\",IF(H21<90,\"良好\",\"优秀\"))))&\"）\"","v":"（不及格）"},null,{"$f":"\"（\"&IF(J21<60,\"不及格\",IF(J21<70,\"及格\",IF(J21<80,\"中等\",IF(J21<90,\"良好\",\"优秀\"))))&\"）\"","v":"（不及格）"}]
["评分者签名"]
["毕业设计总评成绩     （总评成绩=指导教师评分×30%+评阅教师评分×20%+答辩小组评分×50%）",{"$nulls":4},{"$f":"F21*0.3+H21*0.2+J21*0.5","v":0},null,null,"分",{"$f":"\"（\"&IF(F24<60,\"不及格\",IF(F24<70,\"及格\",IF(F24<80,\"中等\",IF(F24<90,\"良好\",\"优秀\"))))&\"）\"","v":"（不及格）"}]

{"sheet":"导师","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[0,0,0,6],[1,1,1,2],[1,4,1,6],[2,5,2,6],[3,0,5,0],[3,2,5,2],[3,5,3,6],[4,1,5,1],[4,4,5,4],[4,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,6],[14,0,15,0],[14,2,15,2],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,0,19,0],[17,2,19,2],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,0,21,3],[20,4,21,4],[21,5,21,6]]}
["济南大学机械工程专业\n《毕业设计》考核细则与成绩评定表"]
[null,"学生姓名：",null,"班级：","学号："]
["序号","毕业要求","支撑的课程目标","评价要素","分值","指导教师\n评分"]
[1,"3-1","课程目标1：掌握现代文献检索及资料查询技术，能够运用现代信息技术获取相关信息","根据课题任务开展调研，进行需求分析，设计任务是否合理",5]
[null,"2-1",null,"文献综述质量",5]
[{"$nulls":3},"参考文献规范性"]
[2,"2-2","课程目标2：培养学生具有综合运用所学理论知识和技能，分析解决实际问题的初步能力。","分解设计任务，进行功能设计",5]
[3,"3-2","课程目标3：考虑本领域的新产品、新工艺、新技术和新设备的基础上，应用设计理论及创新方法提出系统初步解决方案。","设计方案的创新性",5]
[4,"4-2","课程目标4：针对特定的设计题目，基于科学原理并采用科学方法，考虑设备、工艺、系统的应用场合/环境，对设计方案的可行性进行研究。","考虑设备、工艺、系统所针对的特定应用场合，分析设计方案的可行性",5]
[5,"6-2","课程目标5：了解和设计相关的安全、健康、法律等方面的知识，合理分析评价设计方案对上述因素的影响，并理解应承担的责任。","方案论证时，分析方案对社会、安全、法律及文化等因素的影响",5]
[6,"2-3","课程目标6：通过对多种方案进行比较、分析，确定合理设计方案。","方案论证的充分性与合理性，确定总体设计方案",5]
[7,"3-4","课程目标7：制图符合标准，设计说明书格式规范，条理清楚，计算正确。","图纸工作量与质量",25]
[{"$nulls":3},"设计说明书完整性与规范性"]
[{"$nulls":3},"设计计算正确性"]
[8,"5-1","课程目标8：能够针对特定设计题目，选择与使用相关设计手册、标准和现代设计工具","机械相关手册/标准的使用情况",5]
[null,"5-2",null,"现代设计工具的使用情况",5]
[9,"7-2","课程目标9：能够评价毕业设计内容对环境和社会可持续发展的影响。","考虑产品、设备、工艺、技术等对环境及社会可持续发展的影响",5]
[10,"10-1","课程目标10：能够清晰地表达设计思路、工作原理、技术路线，就复杂工程问题与同行进行沟通和交流。","口头表达逻辑性及清晰度，书面表达合理性",10]
[null,"10-2",null,"师生交流互动",10]
[null,"10-3",null,"英文摘要及英文翻译质量",5]
["总分",{"$nulls":3},100,{"$f":"SUM(F4:G20)","v":0},"分"]
[{"$nulls":5},{"$f":"\"（\"&IF(F21<60,\"不及格\",IF(F21<70,\"及格\",IF(F21<80,\"中等\",IF(F21<90,\"良好\",\"优秀\"))))&\"）\"","v":"（不及格）"}]

{"sheet":"评阅人","index":2,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[0,0,0,6],[1,1,1,2],[1,4,1,6],[2,5,2,6],[3,0,5,0],[3,2,5,2],[3,5,3,6],[4,1,5,1],[4,4,5,4],[4,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,6],[14,0,15,0],[14,2,15,2],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,0,19,0],[17,2,19,2],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,0,21,3],[20,4,21,4],[21,5,21,6]]}
["济南大学机械工程专业\n《毕业设计》考核细则与成绩评定表"]
[null,"学生姓名：",null,"班级：","学号："]
["序号","毕业要求","支撑的课程目标","评价要素","分值","评阅教师\n评分"]
[1,"3-1","课程目标1：掌握现代文献检索及资料查询技术，能够运用现代信息技术获取相关信息","根据课题任务开展调研，进行需求分析，设计任务是否合理",5]
[null,"2-1",null,"文献综述质量",5]
[{"$nulls":3},"参考文献规范性"]
[2,"2-2","课程目标2：培养学生具有综合运用所学理论知识和技能，分析解决实际问题的初步能力。","分解设计任务，进行功能设计",5]
[3,"3-2","课程目标3：考虑本领域的新产品、新工艺、新技术和新设备的基础上，应用设计理论及创新方法提出系统初步解决方案。","设计方案的创新性",5]
[4,"4-2","课程目标4：针对特定的设计题目，基于科学原理并采用科学方法，考虑设备、工艺、系统的应用场合/环境，对设计方案的可行性进行研究。","考虑设备、工艺、系统所针对的特定应用场合，分析设计方案的可行性",5]
[5,"6-2","课程目标5：了解和设计相关的安全、健康、法律等方面的知识，合理分析评价设计方案对上述因素的影响，并理解应承担的责任。","方案论证时，分析方案对社会、安全、法律及文化等因素的影响",5]
[6,"2-3","课程目标6：通过对多种方案进行比较、分析，确定合理设计方案。","方案论证的充分性与合理性，确定总体设计方案",5]
[7,"3-4","课程目标7：制图符合标准，设计说明书格式规范，条理清楚，计算正确。","图纸工作量与质量",25]
[{"$nulls":3},"设计说明书完整性与规范性"]
[{"$nulls":3},"设计计算正确性"]
[8,"5-1","课程目标8：能够针对特定设计题目，选择与使用相关设计手册、标准和现代设计工具","机械相关手册/标准的使用情况",5]
[null,"5-2",null,"现代设计工具的使用情况",5]
[9,"7-2","课程目标9：能够评价毕业设计内容对环境和社会可持续发展的影响。","考虑产品、设备、工艺、技术等对环境及社会可持续发展的影响",5]
[10,"10-1","课程目标10：能够清晰地表达设计思路、工作原理、技术路线，就复杂工程问题与同行进行沟通和交流。","口头表达逻辑性及清晰度，书面表达合理性",10]
[null,"10-2",null,"师生交流互动",10]
[null,"10-3",null,"英文摘要及英文翻译质量",5]
["总分",{"$nulls":3},100,{"$f":"SUM(F4:G20)","v":0},"分"]
[{"$nulls":5},{"$f":"\"（\"&IF(F21<60,\"不及格\",IF(F21<70,\"及格\",IF(F21<80,\"中等\",IF(F21<90,\"良好\",\"优秀\"))))&\"）\"","v":"（不及格）"}]

{"sheet":"答辩","index":3,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[0,0,0,6],[1,1,1,2],[1,4,1,6],[2,5,2,6],[3,0,5,0],[3,2,5,2],[3,5,3,6],[4,1,5,1],[4,4,5,4],[4,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,6],[14,0,15,0],[14,2,15,2],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,0,19,0],[17,2,19,2],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,0,21,3],[20,4,21,4],[21,5,21,6]]}
["济南大学机械工程专业\n《毕业设计》考核细则与成绩评定表"]
[null,"学生姓名：",null,"班级：","学号："]
["序号","毕业要求","支撑的课程目标","评价要素","分值","答辩小组\n评分"]
[1,"3-1","课程目标1：掌握现代文献检索及资料查询技术，能够运用现代信息技术获取相关信息","根据课题任务开展调研，进行需求分析，设计任务是否合理",5]
[null,"2-1",null,"文献综述质量",5]
[{"$nulls":3},"参考文献规范性"]
[2,"2-2","课程目标2：培养学生具有综合运用所学理论知识和技能，分析解决实际问题的初步能力。","分解设计任务，进行功能设计",5]
[3,"3-2","课程目标3：考虑本领域的新产品、新工艺、新技术和新设备的基础上，应用设计理论及创新方法提出系统初步解决方案。","设计方案的创新性",5]
[4,"4-2","课程目标4：针对特定的设计题目，基于科学原理并采用科学方法，考虑设备、工艺、系统的应用场合/环境，对设计方案的可行性进行研究。","考虑设备、工艺、系统所针对的特定应用场合，分析设计方案的可行性",5]
[5,"6-2","课程目标5：了解和设计相关的安全、健康、法律等方面的知识，合理分析评价设计方案对上述因素的影响，并理解应承担的责任。","方案论证时，分析方案对社会、安全、法律及文化等因素的影响",5]
[6,"2-3","课程目标6：通过对多种方案进行比较、分析，确定合理设计方案。","方案论证的充分性与合理性，确定总体设计方案",5]
[7,"3-4","课程目标7：制图符合标准，设计说明书格式规范，条理清楚，计算正确。","图纸工作量与质量",25]
[{"$nulls":3},"设计说明书完整性与规范性"]
[{"$nulls":3},"设计计算正确性"]
[8,"5-1","课程目标8：能够针对特定设计题目，选择与使用相关设计手册、标准和现代设计工具","机械相关手册/标准的使用情况",5]
[null,"5-2",null,"现代设计工具的使用情况",5]
[9,"7-2","课程目标9：能够评价毕业设计内容对环境和社会可持续发展的影响。","考虑产品、设备、工艺、技术等对环境及社会可持续发展的影响",5]
[10,"10-1","课程目标10：能够清晰地表达设计思路、工作原理、技术路线，就复杂工程问题与同行进行沟通和交流。","口头表达逻辑性及清晰度，书面表达合理性",10]
[null,"10-2",null,"师生交流互动",10]
[null,"10-3",null,"英文摘要及英文翻译质量",5]
["总分",{"$nulls":3},100,{"$f":"SUM(F4:G20)","v":0},"分"]
[{"$nulls":5},{"$f":"\"（\"&IF(F21<60,\"不及格\",IF(F21<70,\"及格\",IF(F21<80,\"中等\",IF(F21<90,\"良好\",\"优秀\"))))&\"）\"","v":"（不及格）"}]