Indicators data delivery

Example template

A small example template describing the delivery format can be downloaded from here:

Please download it and also read the notes below about the requested data format.

Illustration of “long format”

Please provide indicator data in the following “long” format, as illustrated by the subset below:

# A tibble: 18 × 6
   organization     unit  level variable  year value
   <chr>            <chr> <dbl> <chr>    <dbl> <dbl>
 1 Aalto University <NA>      0 cf        2018 1.14 
 2 Aalto University <NA>      0 cf        2019 1.22 
 3 Aalto University <NA>      0 cf        2020 1.12 
 4 Aalto University <NA>      0 jcf       2018 1.31 
 5 Aalto University <NA>      0 jcf       2019 1.29 
 6 Aalto University <NA>      0 jcf       2020 1.23 
 7 KTH              KTH       0 cf        2018 1.19 
 8 KTH              KTH       0 cf        2019 1.15 
 9 KTH              KTH       0 cf        2020 1.07 
10 KTH              KTH       0 jcf       2018 1.30 
11 KTH              KTH       0 jcf       2019 1.26 
12 KTH              KTH       0 jcf       2020 1.21 
13 KTH              A         1 cf        2018 1.03 
14 KTH              A         1 cf        2019 0.948
15 KTH              A         1 cf        2020 1.13 
16 KTH              A         1 jcf       2018 1.13 
17 KTH              A         1 jcf       2019 1.10 
18 KTH              A         1 jcf       2020 1.11

Note that all indicator variables are listed in the “variable” column rather than being provided in separate columns.

Excel (without semantic formatting, coloring or similar “non-data” encodings) can be used for the data delivery, as well as .csv-files. If using excel, please provide the data on the first worksheet.

Include a description of the data

Please do not forget to include a description of the data on the second worksheet or as a separate file. This meta information provides more information and descriptions and aims to facilitate interpretation of the included indicator data.

For example:

variable domain system_source variable_types variable_unit description last_modified_date
num_publ research bibmet numeric number Very important to add a clear description here. Number of publications of type XXX 2024-03-01
cf research bibmet numeric ratio Field-normalized citation rate, as an aggregated ratio. 2024-03-01
jcf research bibmet numeric ratio Field-normalized citation rate for journals, as an aggregated ratio at the unit level 2024-03-01
top10 research bibmet numeric number Proportion on publications belonging to top10% in its subject field. 2024-03-01

Units at KTH

Please use the unit abbreviations below when referring to internal units within KTH, also downloadable as csv: units.csv.

unit_abbr level unit_sv unit_en
A 1 Skolan för arkitektur och samhällsbyggnad (ABE) School of Architecture and the Built Environment (ABE)
AD 2 Arkitektur Architecture
AF 2 Byggvetenskap Civil and Architectural Engineering
AG 2 Samhällsplanering och miljö Urban Planning and Environment
AI 2 Fastigheter och byggande Real Estate and Construction Management
AK 2 Filosofi och historia Philosophy and History
AL 2 Hållbar utveckling, miljövetenskap och teknik Sustainable development, Environmental science and Engineering
C 1 Skolan för kemi, bioteknologi och hälsa (CBH) School of Engineering Sciences in Chemistry, Biotechnology and Health (CBH)
CD 2 Medicinteknik och hälsosystem Biomedical Engineering and Health Systems
CE 2 Kemi Chemistry
CF 2 Kemiteknik Chemical Engineering
CG 2 Fiber- och polymerteknologi Fibre- and Polymer Technology
CH 2 Genteknologi Gene Technology
CJ 2 Proteinvetenskap Protein Science
CK 2 Industriell bioteknologi Industrial Biotechnology
CM 2 Ingenjörspedagogik Engineering Pedagogics
J 1 Skolan för elektroteknik och datavetenskap (EECS) School of Electrical Engineering and Computer Science (EECS)
JH 2 Datavetenskap Computer Science
JJ 2 Elektroteknik Electrical Engineering
JM 2 Människocentrerad teknologi Human Centered Technology
JR 2 Intelligenta system Intelligent systems
M 1 Skolan för industriell teknik och management (ITM) School of Industrial Engineering and Management (ITM)
ME 2 Industriell ekonomi och organisation (Inst.) Industrial Economics and Management (Dept.)
MF 2 Maskinkonstruktion Engineering Design
MJE 2 Energiteknik Energy Technology
ML 2 Produktionsutveckling Production engineering
MO 2 Lärande Learning
MV 2 Materialvetenskap Materials Science and Engineering
S 1 Skolan för teknikvetenskap (SCI) School of Engineering Sciences (SCI)
SF 2 Matematik (Inst.) Mathematics (Dept.)
SH 2 Fysik Physics
SK 2 Tillämpad fysik Applied Physics
SM 2 Teknisk mekanik Engineering Mechanics

Notes

  • Ideally provide data for each level separately (i.e. KTH-level (level 0), school and department), even if lower-level data at the department level could be used to aggregate to higher levels. This reduces the risk of misunderstandings on how the data can be used, for example, double-counting of variables (e.g. publications or projects) when data is aggregated from the department to the school level.