試算表融入的數學教學與評量設計

Spreadsheet Integrated Mathematics Instruction and Assessment Designs

本研究旨在發展一個試算表融入的數學教學與評量設計，研究中以專題學習方式，進行試算表融入的教學與評量。研究樣本為台南與高雄地區2 校共71位國小五年級學生，分為資優學生實驗組、一般學生實驗組、和一般學生控制組，實驗介入為期六個月。就一般學生而言，試算表融入的教學對學生數學能力有積極的助益，組別可解釋的變異為11%。就應用試算表解題能力而言，資優學生明顯高於一般學生，但整體而言該實作評量尚須進一步簡化以利後續應用。

The purpose of this study is to investigate the effect of the spreadsheet integrated Mathematics instruction and assessment design. A project-based learning (PBL) approach was adopted for spreadsheet integrated intervention. The spreadsheet integrated performance assessment of statistic and algebra was developed as the criterion variable. Seventy-one 5th graders of Tainan and Kaohsiung were included as the sample of this PBL intervention study. One gifted and one regular class was assigned as experiment group， and another regular class was selected as control group. The difference of post-test between two regular classes is discussed by an analysis of covariance result. The preliminary result indicates that the spreadsheet integrated instruction is effective for students' mathematics learning. For the spreadsheet integrated performance assessment result， the gifted students perform better than the regular students. The assessment design needs to be revised for an easier version for further application in elementary school.