摘要
当给定了考生的学号、姓名等信息之后,如何快速地将一个考场内考生的座位随机安排?这是一个很有实用价值的问题。本文灵活运用了Excel中的多个函数的组合,巧妙地解决了考场的随机排座和考生座位的查找问题,并用实例进行动态演示说明。
How to quickly arrange the seats of examinees in an exam room when given the information of the students' number,name and so forth? This is a very practical problem. This paper uses the combination of several functions in Excel flexibly, which perfectly solves the problem of random arrangement and finding of examinee seats, and uses examples to demonstrate and illustrate.
引文
[1]涂志芳.运用Excel数编排高校校园运动会秩序册[J].武汉体育学刊,2013,20(5):64-67.
[2]黎国胜.用Excel2002轻松实现考试座位的随机编排[J].信息技术教育,2003,9:83.
[3]郭民之,等.概率统计实验[M].北京:北京大学出版社,2012:6-11.
[4]王巧伶.Excel 2010函数应用速查手册[M].北京:机械工业出版社,2013.
[5]顾晓鸣,陆群,沈伟.运用Excel“随机数发生器”进行随机化分组[J].中国医院统计,2007,14(3):287-288.
[6]Jacky Davis.函数组合应用范例[M].北京:科学出版社,2013.