university_student_scores

student_scores 某科目大学生成绩情况
字段名, 数据类型, 描述
学号, 字符串 (object), 学生唯一编号，由年级 + 学院代码 + 三位院内流水号组成
班级, 字符串 (object), 学生所在班级名称，格式如“2024级计算机科学与技术1班”
性别, 字符串 (object), 学生性别，取值为“男”或“女”
平时作业平均分, 浮点型 (float64), 学生平时作业成绩的平均分，范围通常为 0–100
测验平均分, 浮点型 (float64), 学生日常测验成绩的平均分，范围通常为 0–100
出勤率, 浮点型 (float64), 学生课程出勤表现换算后的分值，范围通常为 0–100
平时成绩, 浮点型 (float64), 由平时作业平均分、测验平均分和出勤率加权计算得到，计算公式为：平时作业平均分 × 0.35 + 测验平均分 × 0.35 + 出勤率 × 0.30
期末考试成绩, 整数型 (int64), 学生期末考试成绩，为整数分
总评成绩, 浮点型 (float64), 学生课程总评成绩，由平时成绩和期末考试成绩加权计算得到
总评等级, 字符串 (object), 根据总评成绩划分的等级，取值为“优秀”“良好”“中等”“及格”“不及格”

student_scores: Undergraduate course academic performance dataset
Field Name, Data Type, Description
Student ID, string (object), Unique student identifier, composed of grade, college code and 3-digit internal serial number
Class, string (object), Name of the student's class, in the format such as "Class 1, Computer Science and Technology, 2024 Grade"
Gender, string (object), Student's gender, with valid values of "Male" or "Female"
Average score of regular assignments, float64, Average score of the student's regular assignments, typically ranging from 0 to 100
Average score of daily quizzes, float64, Average score of the student's daily quizzes, typically ranging from 0 to 100
Attendance rate, float64, Score converted from the student's course attendance performance, typically ranging from 0 to 100
Regular course performance score, float64, Weighted score calculated from the average regular assignment score, average daily quiz score and attendance rate, with the formula: Average regular assignment score × 0.35 + Average daily quiz score × 0.35 + Attendance rate × 0.30
Final examination score, int64, Student's final examination score, which is an integer value
Overall course score, float64, Weighted overall course score calculated from the regular course performance score and final examination score
Overall course grade level, string (object), Grade level determined based on the overall course score, with valid values of "Excellent", "Good", "Medium", "Pass" and "Fail"

搜集汇总

背景与挑战

背景概述

该数据集记录了大学生某科目的成绩情况，包含学号、班级、性别、平时作业平均分、测验平均分、出勤率、平时成绩、期末考试成绩、总评成绩和总评等级等字段。数据以Excel文件形式提供，用于分析学生学业表现。