211184403_数据

1

第一部分 学位授予信息采集类别划分及填报注意事项

1.1学位授予信息采集类别划分

学位授予信息采集分为博士学位、硕士学位和学士学位三个层次，十个类别，类别具体划分情况如下：

1.1.1博士学位

（1）学历教育博士学位：指除同等学力人员申请博士学位以外的所有博士学术型学位获得者。

（2）同等学力人员申请博士学位：仅指以博士研究生毕业同等学力申请学术型学位者。

（3）博士专业学位：以各种攻读方式获得博士专业学位者（含同等学力人员申请博士专业学位）。

1.1.2硕士学位

（1）学历教育硕士学位：含通过推荐免试、全国统考和学校单考等考试形式入学后获得硕士学术型学位者。

（2）同等学力人员申请硕士学位：指以硕士研究生毕业同等学力申请学术型学位者和高等学校教师或中等职业学校教师在职攻读硕士学位者。

（3）硕士专业学位：以各种攻读方式获得硕士专业学位者（含同等学力人员申请硕士专业学位）。

1.2 有关说明及填报注意事项

（1）学位授予基本数据表对应数据结构中所有代码（第二部分各表中标注“#”的字段）及标准参见第三部分代码表对应代码。代码表中所有代码均可以从“教育部学位与研究生教育发展中心”网站（）上下载。

（2）所有数据项中数字均使用半角字符填报。

（3）姓名、论文题目等字段中如有生僻字，每个生僻字用“??”（半角）代替，如“张??燕”。

（4）身份证件类型和身份证件号码：

①内地身份证：中国大陆人士（除现役军人外）一律填写中华人民共和

2

国居民身份证证件，证件号码为15位或18位。

②军人证件：中华人民共和国现役军人（含武装警察、军校学员）填写军人证件。证件号码须以汉字开头，如“参字第1446707号”、“海字第140832号”、“武总字第017523号”等。

③港澳台身份证件：港澳人士填写“港澳居民来往内地通行证”，台湾人士填写“台湾居民来往大陆通行证”。

④华侨身份证：海外华侨填写其持有的华侨身份证，无华侨身份证者在证件号码字段中填写中国护照号码。

说明:1、农行的等额本金 提前还贷的计算方法，版权所有，请勿转载，下载用后请删除。

个人研究使用，本人非财会专业，计算的数据不一定准确，准确数字参见农行的还款凭证。

2、A1格已借用，不可动。

3、所有 提前还款日期栏内 填写的日期必须采用 =TEXT(DATE(2014,5,8),"e-m-d") 的方式，只改数字

提前还款日期栏内 填写的还款日期的位置：在本行中比 本行第一列的值 小或相等，比上一行第一

4、银行利率变化时，在 当月还款利息栏内 应按照公式要求及时调整还款利率值，并下拉更新。

5、当月剩余本金栏内值<0时，还款日期截止到上月。

6、总贷款额 变化时，应更改 B32格、C32格、和当月还款本金 栏内 的数据。

7、总贷款期限 变化时，应更改 当月还款本金 栏内 和 月还贷款日期 栏内 的数据。

8、第一次还款日期变化时，应将 月还贷款日期 栏内 的数据相应变化，按月计。

总贷款数额520000元总贷款期限180月15年

银行年利率6.55%第一次还款日期2014-5-8

银行年利率银行提前提前

变化日期年利率还款日期还款金额

第一次利率变化2014-5-86.55%

第一次提前还款2014-6-24100000

第二次利率变化

第二次提前还款2016-4-5

第三次利率变化

第三次提前还款2017-8-5

第四次利率变化

第四次提前还款2018-8-5

第五次利率变化

第五次提前还款2019-2-18

月还贷款当月当月当月当月次月利

日期剩余本金还款本金还款利息还款总额息递减额

2014-5-85200002888.8892838.3333335727.2222

2014-6-8517111.11112888.8892822.5648155711.4537-15.76851852

2014-7-8414222.22222888.8892560.4839515449.3728-262.0808642

2014-8-8411333.33332888.8892245.1944445134.0833-315.2895062

-2236-16644-3072-27164068-52911

327671750416388-6242814410

-39362116-304-166501954224319

32767-6320922016086-22505-3369

-1541245441840-1727521722206410

31192-103841010016641-21286-136911

6160-15800-3148-1083012489-2710

32340121441828810201-11489-61810

-3052-15252-1216-38105013-110010

315242476015668-27036500169612

4-16320-4356-30702459-22009

32767119321532013735-18938-24229

8996-11992-1476-1061210935-66310

3276714912179603713-288929911

-7548-13188-2556-103641149541410

310289016150965268-2070168410

-4432-15652-4404-1018012286-12709

30228234802031698228241012

-28128720796-158732233428668

29320-143361252816076-25484-147010

-7032-14768-380-1466318484154710

32767107521386010405-1227682710

-10664-13712-1160-83019932-23111

2293624280222042875126163810

-4920-16832-3772-1116914648-31110

2010420732209003170-1313108010

10940-23328-1676-52546454-9511

时间（日期，星开盘最高最低收盘涨跌涨幅%振幅%1990-12-19,三96.0599.9895.7999.98------1990-12-20,四104.3104.3999.98104.394.414.414.411990-12-21,五109.07109.13103.73109.134.744.545.171990-12-24,一113.57114.55109.13114.555.424.974.971990-12-25,二120.09120.25114.55120.255.74.984.981990-12-26,三125.27125.27120.25125.275.024.174.171990-12-27,四125.27125.28125.27125.280.010.010.0081990-12-28,五126.39126.45125.28126.451.170.930.9341990-12-31,一126.56127.61126.48127.611.160.920.8941991-01-02,三127.61128.84127.61128.841.230.960.9641991-01-03,四128.84130.13128.84130.131.29111991-01-04,五131.27131.44130.13131.441.311.011.011991-01-07,一131.99132.06131.44132.060.620.470.4721991-01-08,二132.62132.68132.06132.680.620.470.4691991-01-09,三133.3133.34132.68133.340.660.50.4971991-01-10,四133.93133.97133.34133.970.630.470.4721991-01-11,五134.61134.61134.51134.60.630.470.0751991-01-14,一134.11135.19134.11134.660.060.040.8021991-01-15,二134.21134.74134.19134.740.080.060.4081991-01-16,三134.19134.74134.13134.24-0.5-0.370.4531991-01-17,四133.66134.25133.65134.250.010.010.4471991-01-18,五133.69134.25133.66134.24-0.01-0.010.4391991-01-21,一133.69134.24133.66134.24000.4321991-01-22,二133.72134.24133.66133.72-0.52-0.390.4321991-01-23,三133.16133.72133.13133.16-0.56-0.420.4411991-01-24,四132.61133.16132.57132.61-0.55-0.410.4431991-01-25,五132.05132.07132.03132.05-0.56-0.420.031991-01-28,一131.46131.55131.46131.46-0.59-0.450.0681991-01-29,二130.94130.97130.94130.94-0.52-0.40.0231991-01-30,三130.44130.94130.41130.44-0.5-0.380.4051991-01-31,四129.93130.46129.93129.97-0.47-0.360.4061991-02-01,五129.5129.97129.44129.51-0.46-0.350.4081991-02-04,一129.05129.58129.05129.05-0.46-0.360.4091991-02-05,二128.56128.58128.53128.58-0.47-0.360.0391991-02-06,三129.13129.15128.06129.130.550.430.8481991-02-07,四129.74129.79129.13129.790.660.510.5111991-02-08,五130.36130.38129.79130.380.590.450.4551991-02-11,一130.91130.97130.38130.970.590.450.4531991-02-12,二131.54131.56130.97131.350.380.290.451991-02-13,三131.93131.93131.35131.910.560.430.4421991-02-14,四132.53132.53132.3132.530.620.470.1741991-02-19,二133.12133.13133.08133.130.60.450.0381991-02-20,三133.63133.66133.13133.660.530.40.3981991-02-21,四134.24134.28133.66134.280.620.460.4641991-02-22,五134.85134.87134.28134.870.590.440.4391991-02-25,一134.37134.87134.33134.4-0.47-0.350.41991-02-26,二133.9134.44133.9133.93-0.47-0.350.4021991-02-27,三133.44133.97133.44133.47-0.46-0.340.3961991-02-28,四132.99133.52132.97133.01-0.46-0.340.4121991-03-01,五132.53132.53132.47132.53-0.48-0.360.0451991-03-04,一132.09132.09131.97131.99-0.54-0.410.091上证指数日K线（1990-2017）1991-03-05,二131.41131.99131.41131.46-0.53-0.40.4391991-03-06,三130.88130.94130.88130.94-0.52-0.40.0461991-03-07,四130.41130.94130.41130.41-0.53-0.40.4051991-03-08,五129.84130.41129.84129.88-0.53-0.410.4371991-03-11,一129.3129.88129.3129.31-0.57-0.440.4471991-03-12,二128.72129.31128.72128.77-0.54-0.420.4561991-03-13,三126.13128.77126.13126.15-2.62-2.032.051991-03-14,四125.61126.15125.61125.63-0.52-0.410.4281991-03-15,五125.08125.62125.08125.17-0.46-0.370.431991-03-18,一124.7125.17124.69124.71-0.46-0.370.3831991-03-19,二124.23124.71124.22124.22-0.49-0.390.3931991-03-20,三123.66124.21123.63123.66-0.56-0.450.4671991-03-21,四123.14123.66123.12123.12-0.54-0.440.4371991-03-22,五122.62123.12122.62122.62-0.5-0.410.4061991-03-25,一122.12122.62122.1122.12-0.5-0.410.4241991-03-26,二121.62122.14121.62121.62-0.5-0.410.4261991-03-27,三121.12121.64121.12121.12-0.5-0.410.4281991-03-28,四120.65121.15120.61120.61-0.51-0.420.4461991-03-29,五120.16120.61120.11120.19-0.42-0.350.4151991-04-01,一120.69120.73119.68120.730.540.450.8741991-04-02,二121.21121.29120.73121.210.480.40.4641991-04-03,三121.71121.71121.21121.710.50.410.4131991-04-04,四122.2122.2121.24121.720.010.010.7891991-04-05,五121.07121.73121.03121.54-0.18-0.150.5751991-04-08,一121.11121.11121.05121.09-0.45-0.370.0491991-04-09,二120.6121.1120.6120.62-0.47-0.390.4131991-04-10,三120.15120.62120.09120.16-0.46-0.380.4391991-04-11,四119.64120.16119.62119.64-0.52-0.430.4491991-04-12,五119.2119.65119.15119.21-0.43-0.360.4181991-04-15,一118.73119.22118.72118.77-0.44-0.370.4191991-04-16,二118.36118.77118.34118.34-0.43-0.360.3621991-04-17,三117.92118.34117.89117.9-0.44-0.370.381991-04-18,四117.45117.93117.45117.45-0.45-0.380.4071991-04-19,五117.08117.5117.05117.08-0.37-0.320.3831991-04-22,一116.63117.08116.58116.63-0.45-0.380.4271991-04-23,二116.21116.63116.15116.19-0.44-0.380.4121991-04-24,三115.7116.19115.7115.79-0.4-0.340.4221991-04-25,四115.38115.79115.33115.36-0.43-0.370.3971991-04-26,五116.31116.31114.52115.560.20.171.551991-04-29,一114.86116.29114.75114.75-0.81-0.71.331991-04-30,二113.89114.87113.89113.94-0.81-0.710.8541991-05-02,四113.04113.2113.03113.16-0.78-0.680.1491991-05-03,五112.46113.17112.3112.41-0.75-0.660.7691991-05-06,一111.65112.41111.57111.61-0.8-0.710.7471991-05-07,二110.8110.9110.8110.82-0.79-0.710.091991-05-08,三110.16110.82110110.03-0.79-0.710.741991-05-09,四109.36110.12109.31109.32-0.71-0.650.7361991-05-10,五108.61109.4108.53108.53-0.79-0.720.7961991-05-13,一107.88107.88107.74107.84-0.69-0.640.1291991-05-14,二107.21107.84107.06107.19-0.65-0.60.7231991-05-15,三106.56106.6106.42106.57-0.62-0.580.1681991-05-16,四105.83105.86105.69105.77-0.8-0.750.161991-05-17,五105.12106.75104.96106.750.980.931.691991-05-20,一107.76107.82106.71107.821.0711.04