Version classiqueVersion mobile
OpenEdition Books

The role of German universities in a system of joint knowledge generation and innovation

 | 
Mirja Meyborg

14. Appendix

Texte intégral

Appendix 1: Overview of all German universities that are subject of study (own illustration).

Appendix 1: Overview of all German universities that are subject of study (own illustration).

Appendix 2: PATSTATT IWW Data-Base

Appendix 2: PATSTATT IWW Data-Base

1Appendix 3: Exemplary Illustration of calculating the different Distances between the German Universities and their individual Cooperation Partners using the Haversine Formula.

2Sub abstand ( )

3Application.ScreenUpdating = False

4Dim Ende As Long Ende = 280000

5Dim step As Long

6step = 0

7For gesamt = 10 To 92

8Dim Uniname (92) As String

9Uniname (l) = "Forschungszentrum"

10Uniname (2) = "Unternehmen"

11Uniname (lO) = "kit"

12Uniname (ll) = "rwth aachen"

13Uniname (12) = "lmu"

14Uniname (13) = "münchen th"

15Uniname (14) = "uni heidelberg"

16Uniname (15) = "uni göttingen"

17Uniname (16) = "uni freiburg"

18Uniname (17) = "uni konstanz"

19Uniname (19) = "uni augsburg"

20Uniname (20) = "uni bamberg"

21Uniname (21) = "uni bayreuth"

22Uniname (22) = "uni bielefeld"

23Uniname (23) = "uni bochum"

24Uniname (24) = "uni bonn"

25Uniname (25) = "braunschweig tu"

26Uniname (26) = "uni bremen"

27Uniname (28) = "darmstadt tu"

28Uniname (29) = "dortmund tu"

29Uniname (30) = "uni duisburg essen"

30Uniname (31) = "uni düsseldorf"

31Uniname (32) = "uni erlangen nürnberg"

32Uniname (33) = "uni frankfurt"

33Uniname (34) = "uni gießen"

34Uniname (35) = "fernuni hagen"

35Uniname (36) = "uni hamburg"

36Uniname (37) = "uni hannover"

37Uniname (38) = "kaiserslautern tu"

38Uniname (39) = "uni kassel"

39Uniname (40) = "uni kiel"

40Uniname (41) = "uni koblenz-landau"

41Uniname (43) = "uni köln"

42Uniname (44) = "uni mainz"

43Uniname (45) = "uni mannheim"

44Uniname (4 6) = "uni marburg"

45Uniname (47) = "uni münster"

46Uniname (48) = "uni Oldenburg"

47Uniname (4 9) = "uni Osnabrück"

48Uniname (50) = "uni paderborn"

49Uniname (51) = "uni passau"

50Uniname (52) = "uni regensburg"

51Uniname (53) = "uni des saarlandes"

52Uniname (54) = "uni siegen"

53Uniname (55) = "uni Stuttgart"

54Uniname (56) = "uni trier"

55Uniname (57) = "uni tübingen"

56Uniname (58) = "uni Ulm"

57Uniname (59) = "uni Wuppertal"

58Uniname (60) = "uni würzburg"

59Uniname (61) = "TU Clausthal"

60Uniname (62) = "Uni Flensburg"

61Uniname (63) = "Bundeswehr Hamburg"

62Uniname (64) = "Uni Hamburg Harburg"

63Uniname (65) = "Uni Hildesheim"

64Uniname (66) = "Uni Eichstädt Ingolstadt"

65Uniname (67) = "Uni Lübeck"

66Uniname (68) = "Uni Lüneburg"

67Uniname (69) = "Uni Mannheim"

68Uniname (70) = "Uni Bundeswehr München"

69Uniname (71) = "Uni Passau"

70Uniname (72) = "Uni Hohenheim"

71Uniname (75) = "Freie Uni Berlin"

72Uniname (7 6) = "Humboldt Uni Berlin "

73Uniname (77) = "TU Berlin"

74Uniname (78) = "TU Chemnitz"

75Uniname (7 9) = "TU Cottbus"

76Uniname (80) = "TU Dresden"

77Uniname (81) = "Uni Erfurt"

78Uniname (82) = "Uni Frankfurt Oder"

79Uniname (83) = "TU Bergakademie Freiberg"

80Uniname (84) = "uni Greifswald"

81Uniname (85) = "uni halle-wittenberg"

82Uniname (8 6) = "tu ilmenau"

83Uniname (87) = "friedrich Schiller uni Jena"

84Uniname (88) = "uni leipzig"

85Uniname (89) = "uni magdeburg"

86Uniname (90) = "uni potsdam"

87Uniname (91) = "uni rostock"

88Uniname (92) = "bauhaus uni weimar"

89If Uniname (gesamt) < > " " Then

90Dim abstand As Double

91Dim abstandh As Double

92Dim platz As Long

93Dim uni As Integer

94Dim entf (40) As Long

95Dim entfg (40) As Double

96Dim dabei As Boolean

97Dim ausland As Long

98Dim arg As Double

99Dim Eigengewicht As Double

100Eigengewicht = C

101For i=l To 40

102entf (i) = 0

103Next

104For ii=l To 40

105Entfg (ii) = 0

106Next

107ausländ = 0

108uni = gesamt

109Dim gewichtungscount As Long

110For Z = 2 To Ende

111dabei = False

112gewichtungscount = 0

113For X=l To 500

114If Cells (Z +X-1, 9) = uni The

115dabei = True

116platz = X

117Eigengewicht = Eigengewicht + Cells (Z + X - 1, 8).Value

118End If

119If Cells (Z +X-1, 9) > 6 Then

120gewichtungscount = gewichtungscount + 1 End If

121If Cells (Z + X -1, 1) < > Cells (Z + X, 1) Then

122Exit For

123End If

124Next

125If dabei = True Then

126For Count =1 To X

127If Count < > platz And Cells (Z + Count - 1, 13) < > " " Then 'abstand = (((Cells (Z + count - 1, 13) – Cells (Z + platz - 1, 13)) * 71.46) ^ 2+ ((Cells (Z + count - 1, 14) –Cells (Z + platz - 1, 14)) * 111) ^ 2) ^ (0.5)

128arg = Sqr ((Sin ((Cells (Z + Count - 1, 14) / 180 * 3.1415926 – Cells (Z + platz - 1, 14) / 180 * 3.1415926) / 2)) ^ 2+ Cos (Cells(Z + platz - 1, 14) / 180 * 3.1415926) * Cos (Cells (Z + Count - 1, 14) / 180 * 3.1415926) * Sin ((Cells (Z + Count - 1, 13) / 180 * 3.1415926 – Cells (Z + platz - 1, 13) / 180 * 3.1415926) /2)) ^ 2)

129abstandh = 2* 6371 * Atn (arg / Sqr (-arg * arg + 1)) 'Cells( Z + count - 1, 15) = abstand

130If abstandh > 0 And abstandh <= 25Then

131Entf (l) = entf (l) + 1

132entfg (l) = entfg (l) + Cells(Z + Count - 1, 8).Value /

133gewichtungscount

134End If

135If abstandh > 25 And abstandh <= 50 Then

136Entf (2) = entf (2) + 1

137Entfg (2) = entfg (2) + Cells (Z + Count - 1, 8).Value /

138gewichtungscount

139End If

140If abstandh > 50 And abstandh <= 75 Then

141entf (3) = entf (3) + 1

142Entfg (3) = entfg (3) + Cells (Z + Count - 1, 8).Value /

143gewichtungscount

144End If

145If abstandh > 75 And abstandh <= 100 Then

146entf (4) = entf (4) + 1

147entfg (4) = entfg (4) + Cells (Z + Count - 1, 8).Value /

148gewichtungscount

149End If

150End If

151'If count < > platz And (Cells (Z + count - 1, 3) < > "de"

152And Cells (Z +X-1, 3) < > "De") Then

153'ausländ = ausländ + 1

154'End If

155'If Cells (Z + count - 1, 14) < > " " Then

156'Cells (Z + count -1, 15) = abstand

157'Cells (Z + count -1, 16) = abstandh

158'Cells (Z + count - 1, 17) = arg

159'End If

160Next

161End If

162Z = Z+X-1

163Next

164For j = l To 40

165Cells (j +1, 17+4* step) = entf (j)

166Next

167For jj = l To 40

168Cells (jj +1, 18+4* step) = entfg(jj)

169Next

170Dim Namee (2) As String

171Namee (l) = "Ergebnis"

172Namee(2) = Uniname (uni)

173Cells (l, 16 + 4* step) = Join (Namee)

174'Cells(7, 17+4* step) = ausländ

175Cells (2, 16 + 4* step) = "25km"

176Cells (3, 16 + 4* step) = "25-50km"

177Cells (4, 16 + 4* step) = "50-75km"

178Cells (5, 16 + 4* step) = "75-100km"

179Cells (8, 16 + 4* step) = "Eigengewicht"

180Cells (8, 17 + 4* step) = Eigengewicht

181step = step + 1

182End If

183Next

184End Sub

Appendix 4: Value of normalized Degree Centrality regarding the Publication Activity of all German Universities in 2000 and compared by Ranking to 2009 (own illustration).

Appendix 4: Value of normalized Degree Centrality regarding the Publication Activity of all German Universities in 2000 and compared by Ranking to 2009 (own illustration).

Appendix 5: Value of Betweenness-Centrality regarding the Publication Activity of all German Universities in 2000 and compared by Ranking to 2009 (own illustration).

Appendix 5: Value of Betweenness-Centrality regarding the Publication Activity of all German Universities in 2000 and compared by Ranking to 2009 (own illustration).

Appendix 6: Value of normalized Degree Centrality regarding the Patenting Activity of all German Universities (Ranking) 2007/2008 (own illustration).

Appendix 6: Value of normalized Degree Centrality regarding the Patenting Activity of all German Universities (Ranking) 2007/2008 (own illustration).

Appendix 7: Value of Betweenness Centrality regarding the Patenting Activity of all German Universities (Ranking) 2007/2008 (own illustration).

Appendix 7: Value of Betweenness Centrality regarding the Patenting Activity of all German Universities (Ranking) 2007/2008 (own illustration).

Appendix 8: Overview of Publication Activity of all German Universities in absolute Numbers, 2000 (own illustration).

Appendix 8: Overview of Publication Activity of all German Universities in absolute Numbers, 2000 (own illustration).

Appendix 9: Overview of Publication Activity of all German Universities in absolute Numbers, 2009 (own illustration).

Appendix 9: Overview of Publication Activity of all German Universities in absolute Numbers, 2009 (own illustration).

Appendix 10: Table of Regression Results concerning scientific Publications.

Appendix 10: Table of Regression Results concerning scientific Publications.

Appendix 11: Table of Regression Results concerning Patent Applications.

Appendix 11: Table of Regression Results concerning Patent Applications.

Appendix 12: Overview of Fourfold Tables regarding the Collaboration Activity of the three Groups of German Universities, weighted Numbers, 2000 and 2009 (own illustration).

Appendix 12: Overview of Fourfold Tables regarding the Collaboration Activity of the three Groups of German Universities, weighted Numbers, 2000 and 2009 (own illustration).

Appendix 13: Overview of Fourfold Tables regarding the institutional Distribution of the Co-Authors of the three Groups of German Universities, weighted Numbers, 2000 and 2009 (own illustration).

Appendix 13: Overview of Fourfold Tables regarding the institutional Distribution of the Co-Authors of the three Groups of German Universities, weighted Numbers, 2000 and 2009 (own illustration).

Appendix 14: Overview of Fourfold Tables regarding the institutional Distribution of the Co-Applicants of the three Groups of German Universities, absolute Numbers, 1999/2000 and 2007/2008 (own illustration).

Appendix 14: Overview of Fourfold Tables regarding the institutional Distribution of the Co-Applicants of the three Groups of German Universities, absolute Numbers, 1999/2000 and 2007/2008 (own illustration).
  • 1 It is not possible to properly visualize the whole network of the KIT as it is too large.

Appendix 15: Exemplary Illustration of all Network Interactions between the KIT and the German Universities that have been Subject of Study (in Terms of Publications, 2009).1

Appendix 15: Exemplary Illustration of all Network Interactions between the KIT and the German Universities that have been Subject of Study (in Terms of Publications, 2009).1
  • 2 It is not possible to properly visualize the whole network of the University of Heidelberg as it i (...)

Appendix 16: Exemplary Illustration of all Network Interactions between the University of Heidelberg and the German Universities that have been Subject of Study (in Terms of Publications, 2009).2

Appendix 16: Exemplary Illustration of all Network Interactions between the University of Heidelberg and the German Universities that have been Subject of Study (in Terms of Publications, 2009).2

Notes

1 It is not possible to properly visualize the whole network of the KIT as it is too large.

2 It is not possible to properly visualize the whole network of the University of Heidelberg as it is too large.

Table des illustrations

Titre Appendix 1: Overview of all German universities that are subject of study (own illustration).
URL http://books.openedition.org/ksp/docannexe/image/244/img-1.jpg
Fichier image/jpeg, 261k
Titre Appendix 2: PATSTATT IWW Data-Base
URL http://books.openedition.org/ksp/docannexe/image/244/img-2.jpg
Fichier image/jpeg, 243k
Titre Appendix 4: Value of normalized Degree Centrality regarding the Publication Activity of all German Universities in 2000 and compared by Ranking to 2009 (own illustration).
URL http://books.openedition.org/ksp/docannexe/image/244/img-3.jpg
Fichier image/jpeg, 363k
Titre Appendix 5: Value of Betweenness-Centrality regarding the Publication Activity of all German Universities in 2000 and compared by Ranking to 2009 (own illustration).
URL http://books.openedition.org/ksp/docannexe/image/244/img-4.jpg
Fichier image/jpeg, 368k
Titre Appendix 6: Value of normalized Degree Centrality regarding the Patenting Activity of all German Universities (Ranking) 2007/2008 (own illustration).
URL http://books.openedition.org/ksp/docannexe/image/244/img-5.jpg
Fichier image/jpeg, 305k
Titre Appendix 7: Value of Betweenness Centrality regarding the Patenting Activity of all German Universities (Ranking) 2007/2008 (own illustration).
URL http://books.openedition.org/ksp/docannexe/image/244/img-6.jpg
Fichier image/jpeg, 299k
Titre Appendix 8: Overview of Publication Activity of all German Universities in absolute Numbers, 2000 (own illustration).
URL http://books.openedition.org/ksp/docannexe/image/244/img-7.jpg
Fichier image/jpeg, 221k
Titre Appendix 9: Overview of Publication Activity of all German Universities in absolute Numbers, 2009 (own illustration).
URL http://books.openedition.org/ksp/docannexe/image/244/img-8.jpg
Fichier image/jpeg, 371k
Titre Appendix 10: Table of Regression Results concerning scientific Publications.
URL http://books.openedition.org/ksp/docannexe/image/244/img-9.jpg
Fichier image/jpeg, 129k
Titre Appendix 11: Table of Regression Results concerning Patent Applications.
URL http://books.openedition.org/ksp/docannexe/image/244/img-10.jpg
Fichier image/jpeg, 128k
Titre Appendix 12: Overview of Fourfold Tables regarding the Collaboration Activity of the three Groups of German Universities, weighted Numbers, 2000 and 2009 (own illustration).
URL http://books.openedition.org/ksp/docannexe/image/244/img-11.jpg
Fichier image/jpeg, 292k
Titre Appendix 13: Overview of Fourfold Tables regarding the institutional Distribution of the Co-Authors of the three Groups of German Universities, weighted Numbers, 2000 and 2009 (own illustration).
URL http://books.openedition.org/ksp/docannexe/image/244/img-12.jpg
Fichier image/jpeg, 270k
Titre Appendix 14: Overview of Fourfold Tables regarding the institutional Distribution of the Co-Applicants of the three Groups of German Universities, absolute Numbers, 1999/2000 and 2007/2008 (own illustration).
URL http://books.openedition.org/ksp/docannexe/image/244/img-13.jpg
Fichier image/jpeg, 314k
Titre Appendix 15: Exemplary Illustration of all Network Interactions between the KIT and the German Universities that have been Subject of Study (in Terms of Publications, 2009).1
URL http://books.openedition.org/ksp/docannexe/image/244/img-14.jpg
Fichier image/jpeg, 428k
Titre Appendix 16: Exemplary Illustration of all Network Interactions between the University of Heidelberg and the German Universities that have been Subject of Study (in Terms of Publications, 2009).2
URL http://books.openedition.org/ksp/docannexe/image/244/img-15.jpg
Fichier image/jpeg, 471k

Lire

Open access