開始
↓
獲取所有學生數據
↓
計算每個學生的權重：weight = 1 / (total_score + 1)
↓
計算總權重
↓
生成隨機數 random_val ∈ [0,1)
↓
遍歷學生列表，累加歸一化權重
↓
當累加權重 ≥ random_val 時選擇當前學生
↓
返回選中學生信息
結束

# 權重隨機點名算法核心實現
def random_rollcall():
    students = Student.query.all()
    if not students:
        return None
    
    weighted_students = []
    total_weight = 0
    
    # 計算每個學生的權重（積分越高權重越低）
    for student in students:
        weight = 1 / (student.total_score + 1)  # +1避免除零
        weighted_students.append({
            'student': student,
            'weight': weight
        })
        total_weight += weight
    
    # 基於權重進行隨機選擇
    random_val = random.random()
    current_weight = 0
    
    for ws in weighted_students:
        normalized_weight = ws['weight'] / total_weight
        current_weight += normalized_weight
        if random_val <= current_weight:
            return ws['student']
    
    # 浮點數精度問題備選方案
    return random.choice(students)

// 前端積分記錄方法
async recordScore(scoreChange, questionType = '') {
    if (!this.currentStudent) {
        this.showNotification('請先選擇學生', 'warning')
        return
    }

    try {
        await rollcallAPI.recordRollcall({
            student_id: this.currentStudent.student_id,
            call_type: this.callMode,
            question_type: questionType,
            score_change: scoreChange
        })
        
        // 更新本地數據
        this.currentStudent.total_score += scoreChange
        if (this.callMode === 'random') {
            this.currentStudent.random_count += 1
        }
        
        await this.loadStudents()  // 刷新數據
        await this.loadRecentRecords()
        
        this.showNotification(
            `${this.currentStudent.name} ${scoreChange > 0 ? '+' : ''}${scoreChange}分`,
            'success'
        )
    } catch (error) {
        console.error('記錄分數失敗:', error)
        this.showNotification('記錄失敗', 'error')
    }
}

# 學生數據導入測試
def test_student_import_excel():
    # 測試數據：模擬Excel文件內容
    test_data = [
        {'學號': '20241101', '姓名': '測試學生1', '專業': '計算機科學'},
        {'學號': '20241102', '姓名': '測試學生2', '專業': '軟件工程'}
    ]
    
    # 測試函數：驗證Excel導入功能
    result = import_students_from_excel(test_data)
    
    # 斷言驗證
    assert result['status'] == 'success'
    assert result['message'] == '成功導入 2 名學生'
    assert Student.query.count() == 2

# 隨機點名算法測試
def test_random_rollcall_algorithm():
    # 準備測試數據
    students = [
        Student(total_score=0),   # 高概率
        Student(total_score=10),  # 中概率  
        Student(total_score=50)   # 低概率
    ]
    
    # 測試算法分佈
    selection_count = {0: 0, 1: 0, 2: 0}
    for _ in range(1000):
        selected = random_rollcall(students)
        selection_count[students.index(selected)] += 1
    
    # 驗證概率分佈合理性
    assert selection_count[0] > selection_count[2]  # 低積分學生被點次數更多