学校学生信息管理系统表

学生分班情况表,序号年班辅助列学号姓名年级班级班主任备注,1.0一年级2班112345.0张晓,2.0一年级3班123456.0张晓晓,3.0一年级2班234567.0,4.0一年级3班245678.0,5.0一年级3班356789.0,6.0一年级1班一年级1班167900.01班张丽,7.0一年级2班379011.0,8.0一年级3班490122.0,9.0一年级3班5101233.0,10.0一年级3班6112344.0,11.0一年级3班7123455.0,12.0一年级3班8134566.0,13.0一年级3班9145677.0,14.0一年级3班10156788.0,15.0一年级3班11167899.0,16.0一年级3班12179010.0,17.01,18.02,19.03,20.04,21.05,22.06,23.07,24.08,25.09,26.010,27.011,28.012,29.013,30.014,31.015,32.016,33.017,34.018,35.019,36.020,37.021,38.022,39.023,40.024,41.025,42.026,43.027,44.028,45.029,46.030,47.031,48.032,49.033,50.034,51.035,52.036,53.037,54.038,55.039,56.040,57.041,58.042,59.043,60.044,61.045,62.046,63.047,64.048,65.049,66.050,67.051,68.052,69.053,70.054,71.055,72.056,73.057,74.058,75.059,76.060,77.061,78.062,79.063,80.064,81.065,82.066,83.067,84.068,85.069,86.070,87.071,88.072,89.073,90.074,91.075,92.076,93.077,94.078,95.079,96.080,97.081,98.082,99.083,100.084,101.085,102.086,103.087,104.088,105.089,106.090,107.091,108.092,109.093,110.094,111.095,112.096,113.097,114.098,115.099,116.0100,117.0101,118.0102,119.0103,120.0104,121.0105,122.0106,123.0107,124.0108,125.0109,126.0110,127.0111,128.0112,129.0113,130.0114,131.0115,132.0116,133.0117,134.0118,135.0119,136.0120,137.0121,138.0122,139.0123,140.0124,141.0125,142.0126,143.0127,144.0128,145.0129,146.0130,147.0131,148.0132,149.0133,150.0134,151.0135,152.0136,153.0137,154.0138,155.0139,156.0140,157.0141,158.0142,159.0143,160.0144,161.0145,162.0146,163.0147,164.0148,165.0149,166.0150,167.0151,168.0152,169.0153,170.0154,171.0155,172.0156,173.0157,174.0158,175.0159,176.0160,177.0161,178.0162,179.0163,180.0164,181.0165,182.0166,183.0167,184.0168,185.0169,186.0170,187.0171,188.0172,189.0173,190.0174,191.0175,192.0176,193.0177,194.0178,195.0179,196.0180,197.0181,198.0182,199.0183,200.0184,201.0185,202.0186,203.0187,204.0188,205.0189,206.0190,207.0191,208.0192,209.0193,210.0194,211.0195,212.0196,213.0197,214.0198,215.0199,216.0200,217.0201,218.0202,219.0203,220.0204,221.0205,222.0206,223.0207,224.0208,225.0209,226.0210,227.0211,228.0212,229.0213,230.0214,231.0215,232.0216,233.0217,234.0218,235.0219,236.0220,237.0221,238.0222,239.0223,240.0224,241.0225,242.0226,243.0227,244.0228,245.0229,246.0230,247.0231,248.0232,249.0233,250.0234,251.0235,252.0236,253.0237,254.0238,255.0239,256.0240,257.0241,258.0242,259.0243,260.0244,261.0245,262.0246,263.0247,264.0248,265.0249,266.0250,267.0251,268.0252,269.0253,270.0254,271.0255,272.0256,273.0257,274.0258,275.0259,276.0260,277.0261,278.0262,279.0263,280.0264,281.0265,282.0266,283.0267,284.0268,285.0269,286.0270,287.0271,288.0272,289.0273,290.0274,291.0275,292.0276,293.0277,294.0278,295.0279,296.0280,297.0281,298.0282,299.0283,300.0284,301.0285,302.0286,303.0287,304.0288,305.0289,306.0290,307.0291,308.0292,309.0293,310.0294,311.0295,312.0296,313.0297,314.0298,315.0299,316.0300,317.0301,318.0302,319.0303,320.0304,321.0305,322.0306,323.0307,324.0308,325.0309,326.0310,327.0311,328.0312,329.0313,330.0314,331.0315,332.0316,333.0317,334.0318,335.0319,336.0320,337.0321,338.0322,339.0323,340.0324,341.0325,342.0326,343.0327,344.0328,345.0329,346.0330,347.0331,348.0332,349.0333,350.0334,351.0335,352.0336,353.0337,354.0338,355.0339,356.0340,357.0341,358.0342,359.0343,360.0344,361.0345,362.0346,363.0347,364.0348,365.0349,366.0350,367.0351,368.0352,369.0353,370.0354,371.0355,372.0356,373.0357,374.0358,375.0359,376.0360,377.0361,378.0362,379.0363,380.0364,381.0365,382.0366,383.0367,384.0368,385.0369,386.0370,387.0371,388.0372,389.0373,390.0374,391.0375,392.0376,393.0377,394.0378,395.0379,396.0380,397.0381,398.0382,399.0383,400.0384,401.0385,402.0386,403.0387,404.0388,405.0389,406.0390,407.0391,408.0392,409.0393,410.0394,411.0395,412.0396,413.0397,414.0398,415.0399,416.0400,417.0401,418.0402,419.0403,420.0404,421.0405,422.0406,423.0407,424.0408,425.0409,426.0410,427.0411,428.0412,429.0413,430.0414,431.0415,432.0416,433.0417,434.0418,435.0419,436.0420,437.0421,438.0422,439.0423,440.0424,441.0425,442.0426,443.0427,444.0428,445.0429,446.0430,447.0431,448.0432,449.0433,450.0434,451.0435,452.0436,453.0437,454.0438,455.0439,456.0440,457.0441,458.0442,459.0443,460.0444,461.0445,一年级3班学生花名册,年级:一年级班级:3班班主任:郭达,总人数:12.0女生:5.0男生:6.0,说明:通过下拉菜单选择年级和班级,其他内容自动生成,可A4打印,序号学号姓名身份证号性别出生日期年龄联系人联系人关系联系电话健康禁忌备注,2.045678.0,3.056789.0,4.090122.0,5.0101233.0,6.0112344.0,7.0123455.0,8.0134566.0,9.0145677.0,10.0156788.0,167899.0,12.0179010.0,13.0,14.0,15.0,16.0,17.0,小学班级基本情况,年/班年级班级班主任备注,一年级1班1班张丽,一年级2班2班宋晓,一年级3班3班郭达,学生信息查询,输入学生的学号145677.0,大潘潘同学,就读年级一年级就读班级3班班主任:郭达,身份证号:410521200801191003,性别女出生日期2008-01-19年龄11.0,联系人爸爸联系人关系父女联系电话138490012341,健康禁忌无,使用说明:,1.首先需要维护的是"学生基本信息"表格,其中绿色填充部分是公式自动计算,2.班级设置是分班的前提,可以在这里维护班级,"学生分班情况"的下拉列表就会自动变更,3.需要再分班中维护班级和年级情况,学生名单从"学生基本信息"中自动调取,4.班级名册,根据需要查询的班级选择,年级和班级,名单自动生成,5.主页中可以根据学号查询学生的所有信息,学生基本信息,序号学号姓名身份证号性别出生日期年龄联系人联系人关系联系电话健康禁忌备注,1.012345.0张晓4105212008101911112008-10-19父子不能跑步,2.023456.0张晓晓4105212009111910052009-11-1910.0,3.034567.0对鸡蛋过敏,4.045678.0,5.056789.0,6.067900.0,7.079011.0,8.090122.0,9.0101233.0,10.0112344.0,123455.0,12.0134566.0,13.0145677.0,14.0156788.0,15.0167899.0,16.0179010.0,17.0,18.0,19.0