小学毕业会考准考证号的编排参考步骤

小学毕业会考准考证号的编排参考步骤

1、打开excel。（输入文件名/保存）

2、输入:中心校代码、学校代码、考生姓名、学校名。要校对、要准确，上报时只提供考生号、考生姓名、毕业学校（体现班级）。

3、在考生姓名字段列前插入三列（分别代表中心、学校、考号，格式选择——文本），如：实验小学

01 01 01 01

中心代码学校代码考场考生号

4、智能填充（编辑\填充\向下填充）中心小学代码、学校代码、各学校考生顺序号（如：1——30号分为一段，表示该考场30位考生都来自不同学校，20人或15人为一段更为分散，此字段可根据学校规模大小来确定，用鼠标拖动即可）。

5、考生顺序号字段升序排序（各学校1号、2号……自动排序）

6、在c列编考生号，格式\文本。（如：0101……0130，0201……0230，……），每个考场30人，用鼠标拖动。

7、在E列前插入一列（考生号），合并A、B、C列到D列（格式自定义：00000000），插入FX\选文本函数中的合并单元格函数，在对话框中单击text1，再单击要合并的单元格A2，B2,C2，地址栏则出现：=CONCATENATE（A，B，C），然后智能填充D列（编辑\填充\向下填充）。8、在E列前插入一列（准考证号），选定准考证号列\复制\选择性粘贴\数值\确定\删除A、B、C及合并数据的列\保存。

9、交报名表时，以校为单位，按小号在上，大号在下的顺序整理交小教室。

When you are old and grey and full of sleep, And nodding by the fire, take down this book, And slowly read, and dream of the soft look Your eyes had once, and of their shadows deep; How many loved your moments of glad grace, And loved your beauty with love false or true, But one man loved the pilgrim soul in you,

And loved the sorrows of your changing face; And bending down beside the glowing bars, Murmur, a little sadly, how love fled

And paced upon the mountains overhead

And hid his face amid a crowd of stars.

The furthest distance in the world

Is not between life and death

But when I stand in front of you

Yet you don't know that

I love you.

The furthest distance in the world

Is not when I stand in front of you

Yet you can't see my love

But when undoubtedly knowing the love from both Yet cannot be together.

The furthest distance in the world

Is not being apart while being in love

But when I plainly cannot resist the yearning

Yet pretending you have never been in my heart. The furthest distance in the world

Is not struggling against the tides

But using one's indifferent heart

To dig an uncrossable river

For the one who loves you.