Some conversion codes for the subject of innovation ability of postgraduates

/****** Script for selecttopnrows command from SSMS ******/select TOP 1000 [school], [grade], [gender], [1#_ ask if you have hair during school Do you have an academic paper? Please select the highest level published:], [2#_ did you attend a research project during school? Please select the highest level of participation:], [3#_ do you attend an academic meeting during the school period? Please select the highest level of participation:], [4#_ do you participate in the Innovation Competition program during school? Please select the highest level of participation:], [5#_ have you obtained or applied for a patent certificate during the school period? Please select the corresponding number of times:], [6, what is your undergraduate degree in the average score of the following areas within?      ], [7, what is the average score of each section in your study period roughly within the following range?] , [1#_ can often find inspiration in his field of expertise from other areas], [2#_ I am good at discovering new changes in life, new problems], [3#_ can proactively discover some problems and discover the various connections related to problems], [4#_ in thinking and solving problems, my thinking is always clear, Smooth, often emerging in the mind of ideas], [5#_ I am good at discovering the unknown part of the problem, usually can predict the outcome of the problem, and can correctly verify the results], [6#_ learning I can think more than others], [7#_ I dare to imagine a new work plan], [8#_ often encounters problems, I often think and explore possibilities in many ways, rather than fixing them in a way or a certain aspect], [9#_ I can recover quickly from the setback and move on], [10#_ I am able to meet difficulties when I encounter problems], [11#_ I do not Often rigorous, serious, and thoughtful, excellence], [12#_ I can question authority, even if there are some conclusions], [13#_ I would rather work hard with everyone, rather than work alone], [14#_ I often participate in collective activities or projects], [1 5#_ I often talk with others about academic, exchange of ideas], [1, our school learning atmosphere is very strong-], [0~1], [one to one], [one to one], [one to one], [[2], [up to], [I can be very good use of more learning Division knowledge toProblem solving], [0~11], [1~21], [2~31], [3~41], [4~51], [3, I can quickly collect the information I need and effectively handle-], [0~12], [ 1~22], [2~32], [3~42], [4~52], [4, I often focus on relevant disciplines or academic frontier issues-], [0~13], [1~23], [2~33], [-      3], [4~53], [5, in solving the problem, I analyze the problem faster, and the specific implementation is slow-], [0~14], [1~24], [2~34], [3~44], [4~54]      , [6, the idea of innovation often has, but really little to do-], [0~15], [1~25], [2~35], [3~45], [4~55], [7, when I do it I can always do very well-] , [0~16], [1~26], [2~36], [3~46], [4~56], [What are your suggestions for improving graduate students ' innovation ability?] (optional)], [total score], [F76], [F77], [F78], [F79], [F80], [F81], [F82], [F83], [F8 4], [F85] from [innovation]. [dbo]. [Graduates]use innovationupdate Graduates Set school = ' Nanchang University ' where school = ' 1 ' update graduates set school = ' Jiangxi University of Finance ' Where school = ' 2 ' update gr Aduates Set school = ' Jiangxi Normal University ' where school = ' 3 ' update graduates set school = ' Nanchang Aviation University ' where school = ' 4 ' update graduates set school = ' Jiangxi Agricultural University ' where school = ' 5 ' Update graduates Set school = ' East China Jiaotong University ' where school = ' 6 ' update graduates set grade = ' Research One ' where grade = ' 1 ' update graduates set grade = ' Research two ' where grade = ' 2 ' Update grad Uates Set grade = ' Research three ' where grade = ' 3 ' SELECT * FROM dbo.graduatesupdate graduates set gender = ' male ' where gender = ' 1 ' update graduates set gender = ' Female ' WHERE sex = ' 2 ' Delete from graduates where grade is Nullselect COUNT (*) as ' Nanchang University research a number ' from graduates where school = ' Nanchang University ' and grade = ' Research a ' SELECT COUNT (*) as ' Nanchang University research Two people ' from graduates where school = ' Nanchang University ' and grade = ' Research II ' SELECT COUNT (*) as ' Nanchang University research three people ' from graduates Where school = ' Nanchang University ' and grade = ' Research Three '/* * below begin to convert the questionnaire data into point values */

/****** Script for selecttopnrows command from SSMS ******/select TOP 1000 [school], [grade], [gender], [Q1], [Q 2], [Q3], [Q4], [Q5], [Q6], [Q7], [Q8], [Q9], [Q10], [Q11], [Q12], [Q13], [Q14], [Q15], [Q16], [Q17], [Q18], [Q19], [Q20], [Q21], [Q22], [Q [0~1], [+/-], [+/-], [All-in-all], [all-in-all], [Q24], [0~11], [1~21], [2~31], [      3~41], [4~51], [Q25], [0~12], [1~22], [2~32], [3~42], [4~52], [Q26], [0~13] , [1~23], [2~33], [3~43], [4~53], [Q27], [0~14], [1~24], [2~34], [3~44], [      4~54], [Q28], [0~15], [1~25], [2~35], [3~45], [4~55], [Q29], [0~16], [1~26] , [2~36], [3~46], [4~56], [What are your suggestions for improving graduate students ' innovation ability?] (optional)], [total score] from [innovation]. [dbo]. [Graduates]/*select count (*) as ' Nanchang University research One number' from graduates where school = ' Nanchang University ' and grade = ' Research One ' select COUNT (*) as ' Nanchang University research two number ' from graduates where school = ' Nanchang University ' and grade = ' Research II ' Sele CT COUNT (*) as ' Nanchang University research three people ' from graduates where school = ' Nanchang University ' and grade = ' Research Three ' */select * from Graduatesselect COUNT (*) from Graduat Es where school = ' Nanchang University ' select COUNT (*) from graduates where school = ' Jiangxi University of Finance ' SELECT COUNT (*) from graduates where school = ' Jiangxi Normal University ' select C Ount (*) from graduates where school = ' Nanchang University of Aeronautics ' SELECT COUNT (*) from graduates where school = ' Jiangxi Agricultural University ' SELECT COUNT (*) from graduates whe Re school = ' East China Jiaotong University '/*********** below began to convert ***********************//*1. Have you published any academic papers during your time at school?  Please select the highest published level: [Single topic]0c issue above 0C issue 0 core periodicals 0 cores Select 1 to 5 points, 2 to 3, 3 to 2, 4 to 1 */update graduates set q1= ' 5 ' where q1= ' 1 ' Update graduates Set q1= ' 3 ' where q1= ' 2 ' Update graduates set q1= ' 2 ' where q1= ' 3 ' Update graduates set q1= ' 1 ' where q1= ' 4 ' Update graduates s The ET q1= ' 1 ' where q1= '-2 '---2 is assigned a value of 1 points/*2. Did you attend a scientific research project during your school?  Please select the highest level that has been attended: [Single topic]0 international level 0 National 0 Provincial 0 provincial or no choice 1 5 points, 2 3 points, 3 to 2 points selected 4 1 points */update graduates set q2= ' 5 ' where q2= ' 1 ' Update graduates Set q2= ' 3 'where q2= ' 2 ' Update graduates set q2= ' 2 ' where q2= ' 3 ' Update graduates set q2= ' 1 ' where q2= ' 4 ' Update graduates set q2= ' 1 ' wh Ere q2= '-2 '---2 is assigned a value of 1/*3. Would you like to attend an academic meeting during your stay at school?  Please select the highest level of participation: [Single topic]0 international level 0 National 0 Provincial 0 provincial or no choice 1 5 points, 2 3 points, 3 of 2 points selected 4 1 points */select * from Graduatesupdate Graduates set q3= ' 5 ' where q3= ' 1 ' Update graduates set q3= ' 3 ' where q3= ' 2 ' Update graduates set q3= ' 2 ' where q3= ' 3 ' Update graduates set q3= ' 1 ' where Q 3= ' 4 ' Update graduates set q3= ' 1 ' where q3= '-2 '---2 is assigned a value of 1 points/*4. Do you participate in the Innovation Competition program during school?  Please select the highest level of participation: [Single topic]0 international level 0 National 0 Provincial 0 provincial or no choice 1 5 points, 2 3 points, 3 of 2 points selected 4 1 points */select * from Graduatesupdate Graduates set q4= ' 5 ' where q4= ' 1 ' Update graduates set q4= ' 3 ' where q4= ' 2 ' Update graduates set q4= ' 2 ' where q4= ' 3 ' Update graduates set q4= ' 1 ' where Q 4= ' 4 ' Update graduates set q4= ' 1 ' where q4= '-2 '---2 is assigned a value of 1 points/*5. Have you obtained or applied for a patent certificate during your stay at school? Please select the corresponding number of times: [Single-Choice]00010203 and above selected 1 to 1 points, 2 to 2 points, 3 to 3 points, 4 to 5 points */select * from Graduatesupdate Graduates set q5= ' 5 ' where q5= ' 4 ' UPDA TE graduates set q5= ' 3 ' where q5= ' 4 ' Update graduates set q5= ' 2 ' wherE q5= ' 2 ' Update graduates set q5= ' 1 ' where q5= ' 1 ' Update graduates set q5= ' 1 ' where q5= '-2 '---2 is assigned 1 points/*6, the average score of your undergraduate studies is roughly Which of the following ranges? [Single Choice]0100~90090~80080~70070~0 1 to 5 points, 2 to 3 points, 3 to 2 for 4 to 1 points */select * from Graduatesupdate Graduates set q6= ' 5 ' where q6= ' 1 ' Update graduates set q6= ' 3 ' where q6= ' 2 ' Update graduates set q6= ' 2 ' where q6= ' 3 ' Update graduates set q6= ' 1 ' where q6= ' 4 ' Up Date graduates set q6= ' 1 ' where q6= '-2 '---2 is assigned 1 points/*7, may I ask you to study the average score of each section in the following range? [Single Choice]0100~90090~80080~70070~0 1 to 5 points, 2 to 3 points, 3 to 2 for 4 to 1 points */select * from Graduatesupdate Graduates set q7= ' 5 ' where q7= ' 1 ' Update graduates set q7= ' 3 ' where q7= ' 2 ' Update graduates set q7= ' 2 ' where q7= ' 3 ' Update graduates set q6= ' 1 ' where q6= ' 4 ' Up The assignment of date graduates set q7= ' 1 ' where q7= '-2 '---2 is 1 points/*8. Often found in other areas of their own professional field of innovation Inspiration [single topic] very does not meet the 0 very does not meet the 0203040 very well in line with the very 9. I am good at discovering new changes in life, new problems [single topic] very inconsistent with the 0 very incompatible with the 0203040 very well in line with the very 10. Can proactively find some problems, and found that the various links related to the problem [single topic] very does not meet the 0 very incompatible with 0203040 very well in line with the very 11. In thinking and solving problems, my thinking is always clear, smooth, the mind is often the idea of the emergence of the mind [single topic] very inconsistent with 0 non-Often does not meet the 0203040 very well in accordance with the 12. I am good at discovering the unknown part of the problem, and can usually predict the outcome of the problem, and can correctly verify the results [single-choice] very inconsistent with the 0 very non-compliant 0203040 very well in line with the very 13. I was able to learn a lot more than others. [Single topic] very inconsistent with the 0 very incompatible with the 0203040 very well in line with the very 14. I dare to imagine the new work programme [single topic] very inconsistent with the 0 very non-compliant 0203040 very well in line with the very 15. Usually when encountering problems, I often can think from many aspects, explore the possibility, rather than fixed in a way of thinking or confined to a certain aspect [single-choice] very inconsistent with the 0 very incompatible with the 0203040 very well in line with the very 16. I can quickly recover from the setback and move on [single topic] very inconsistent with the 0 very incompatible with the 0203040 very well in line with the very 17. I was able to meet the difficulties when I met the problem [single topic] very does not meet the 0 very incompatible with the 0203040 very well in line with the very 18. I work very rigorous, serious, and the problem of thoughtful, excellence [single topic] very not in line with 0 very incompatible with the 0203040 very well in line with the very 19. I was able to question the authority even though some already had a verdict [single topic] very inconsistent with the 0 very incompatible 0203040 very well in line with the very 20. I would rather work hard with you than work alone [single topic] very inconsistent with the 0 very non-compliant 0203040 very well in line with the very 21. I often participate in group activities or projects [single topic] very inconsistent with 0 very non-compliant 0203040 very well in line with 22.  I often talk to others about academic, exchange of ideas [single topic] very not meet the 0 very incompatible with the 0203040 very well in line with the */--q8--q22, without conversion and are positive April 6, 2016 13:51:15select * from graduates where Q10<0select * from Graduatesupdate Graduates set q10= ' 3 ' where q10= '-2 '---2 assignment is 3 points select * from graduates where Q 15<0update graduates set q15= ' 3 ' where q15= '-2 '---2 assignment is 3 points SELect * from graduates where Q16<0update graduates set q16= ' 3 ' where q16= '-2 '---2 Assignment for 3 points select * from graduates where Q19 <0update graduates set q19= ' 3 ' where q19= '-2 '---2 is assigned a 3 point select * from graduates where Q21<0update graduates set q21= ' 3 ' where q21= '-2 '---2 is assigned a 3-point select * from graduates where Q22<0update graduates set q22= ' 3 ' where q22= '-2 '---2 is assigned 3 points Sele CT * FROM Graduates

Some conversion codes for the subject of innovation ability of postgraduates