活用谷歌拼音快速录入学生信息 宋灿军

 

活用谷歌拼音快速录入学生信息

靖江外国语学校  宋灿军  214500

当今网络时代信息量激增，客观上对传统的汉字录入提出了更高的要求，各种新颖的输入法如紫光拼音、搜狗拼音等应运而生，Google也顺应潮流推出了自己的谷歌拼音输入法。概括起来，谷歌拼音输入法具备五大特色：智能组句、流行词汇、网络同步、一键搜索、英文提示，大大方便了普通用户，更加人性化的是用户可以编辑自定义短语导入。联想到我们学校的班主任老师经常需要输入学生的各种信息，例如姓名、学籍号、家庭住址、联系电话等，能否利用谷歌输入法帮助老师们快速录入这些相关信息呢？假设学生名叫“王国华”，要求输入wgh就显示“王国华”，输入wghzz就显示王国华的家庭住址，输入wghdh就显示王国华的联系电话。经过实战试验，答案是肯定的。

首先准备一个学生信息的样表，如右图所示的EXCEL文件中，Sheet1存放了5名学生的信息，包括姓名、学籍号、家庭住址和联系电话。

步骤一：将表格中的学生数据行列转置，变成图中的B列形式。

数据量不大时，可以直接复制—选择性粘贴，如果数据量较大，可以考虑用Excel VBA编写代码自动完成，CommandButton参考代码如下：

Private Sub CommandButton1_Click()

Dim bq1, bq2 As String

Dim xb1, xb2 As String

Dim i, j, x, a, b As Integer

bq1 = "Sheet1"

bq2 = "Sheet2"

‘5行4列

a = 5

b = 4

For i = 1 To a

For j = 1 To b

          x = (i - 1) * b + j

          xb2 = "B" + CStr(x)

          xb1 = Chr(64 + j) + CStr(i + 1)

          Worksheets(bq2).Range(xb2) = Worksheets(bq1).Range(xb1)

Next j

Next i

End Sub

 

步骤二：生成学生姓名的汉语拼音缩写，如“王国华”转换为wgh

在样表的Sheet2的A1单元格中，写入下面的函数：

=LOWER(IF(B1="","",LOOKUP(CODE(MID(B1,1,1)),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}))&IF(B1="","",LOOKUP(CODE(MID(B1,2,1)),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}))&IF(LEN(B1)<3,"",LOOKUP(CODE(MID(B1,3,1)),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"}))&IF(LEN(B1)<4,"",LOOKUP(CODE(MID(B1,4,1)),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"})))

特别要注意，转换方法是通过判断汉字内码的编号范围来确定拼音首字母的范围，因为从编码D7F9往后的汉字都不是按拼音排序的，所以这方法会有些汉字的拼音首字母无法识别，但是基本上常用字都能识别。LOWER（）是为了转化为谷歌拼音所识别的小写字母，此法能将四个汉字以下的姓名转换为小写的首字母缩写形式。

步骤三：生成学生其他相关信息的汉语拼音缩写

在A2单元格中输入=A1&”xjh”，A3单元格中输入=A1&”zz”，A4单元格中输入=A1&”dh”，选中A1到A4单元格，用填充手柄拖下来即可生成我们需要的缩写。

步骤四：将Sheet2另存为“文本文件（制表符分隔）.txt”格式，再将txt改为dis扩展名。

步骤五：调出谷歌输入法—属性设置—词典—编辑自定义短语—导入*.dis 到此大功告成。

 

在实际运用中，结合谷歌输入法和我校原有6799名学生的电子档案，还可以快速录入身份证号码、学生家长姓名、工作单位、户籍地址等信息，切实提升了老师们的工作效率，收到了很好的效果。