{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Application form"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Application form","index":0,"n_rows":144,"n_cols":12,"rows_kept":144,"cut":false,"hidden":false,"merged":[[143,0,145,1],[134,7,134,12],[112,6,112,9],[125,0,125,1],[128,0,130,1],[135,0,135,1],[132,11,132,12],[131,11,131,12],[130,11,130,12],[141,0,141,1],[137,3,140,12],[136,3,136,12]]}
["Digital Sciences application form","Report of undergraduate study achievements",null,"1. Theoretical computer science"]
[null,null,null,"2. Programming"]
["Useful Information",null,null,"3. Web development"]
["Homepage",null,null,"4. Human-computer-interaction"]
["Additional informations",null,null,"5. Knowledge organization"]
["Explanation Video (how to fill out this sheet)",null,null,"6. Digital society"]
[null,null,null,"7. Information visualization"]
["Study fields",null,null,"8. Information in companies"]
["Business Information Systems (BIS)",null,null,"9. Data modeling"]
["Data and Information Science (DIS)",null,null,"10. Data analysis"]
["IT Management (ITM)",null,null,"11. Data mining"]
["Software Architecture (SAR)",null,null,"12. Information research"]
[null,null,null,"13. Data bases"]
["a) Specific Information (Attributes)","Value",null,"14. IT law"]
["Last name:","Example",null,"15. Media technology and production"]
["First name:","Example",null,"16. Communication technology and networks"]
["Application via","TH-Köln",null,"17. Operating systems"]
["Application number:","Example",null,"18. IT operations"]
["Application for specialization:","SAR: Software Architecture",null,"19. IT controlling"]
[null,null,null,"Other"]
["b) Report of Study Achievements","Study Profile"]
["Program name:","Informatik"]
["Degree:","Bachelor"]
["University (Country):","Example University (Germany)"]
["Total of credits:",180]
[]
["c) Catalogue of modules ","Credit points"]
["Please list all modules below (copy the modules as they are listed in your study program catalogue). Then rate in which focus are they belong. Usefull Information is linked on each focus are on the right. If a module has a yellow background, it means that something in the row is missing","Important info: If a module is highlighted in yellow,\nyou either do not have a focus area selected yet or you have more than one focus area selected.",null,"Acting Responsibly","Architecting and Coding Software","Empowering Business","Designing Innovation and Products","Generating and Accessing Knowledge","Managing & Running IT","Other","","Module of Computer or \nInformation Science \n\n"]
["Example  …Einführungsprojekt in die Informatik…(to be substituted!)",5,null,null,"x",null,null,null,null,null,null,"2. Programming"]
["Example  …Algorithmen und Programmierung I…(to be substituted!)",8,null,null,"x",null,null,null,null,null,null,"3. Web development"]
["Example  …Einführung in Betriebssysteme und Rechnerarchitektur…(to be substituted!)",5,null,null,null,null,null,"x"]
["Example  …Mathematik I…(to be substituted!)",7,null,null,null,null,null,"x"]
["Example  …Theoretische Informatik I…(to be substituted!)",5,null,null,"x",null,null,null,null,null,null,"4. Human-computer-interaction"]
["Example  …Algorithmen und Programmierung II…(to be substituted!)",7,null,null,null,null,"x",null,null,null,null,"5. Knowledge organization"]
["Example  …Betriebssysteme und verteilte Systeme…(to be substituted!)",5,null,null,null,null,null,null,"x",null,null,"7. Information visualization"]
["Example  …BWL - Grundlagen…(to be substituted!)",5,null,null,null,"x",null,null,null,null,null,"7. Information visualization"]
["Example  …Mathematik II…(to be substituted!)",8,null,null,null,null,null,"x"]
["Example  …Theoretische Informatik II…(to be substituted!)",5,null,null,"x",null,null,null,null,null,null,"6. Digital society"]
["Example  …Algorithmik…(to be substituted!)",5,null,null,"x",null,null,null,null,null,null,"2. Programming"]
["Example  …Datenbanksysteme…(to be substituted!)",5,null,null,"x",null,null,null,null,null,null,"6. Digital society"]
["Example  …Informations- und Prozessmanagement…(to be substituted!)",5,null,null,null,null,null,null,"x",null,null,"18. IT operations"]
["Example  …Kommunikationstechnik und Netze…(to be substituted!)",5,null,null,"x",null,null,null,null,null,null,"6. Digital society"]
["Example  …Projektmanagement…(to be substituted!)",5,null,null,null,"x",null,null,null,null,null,"16. Communication technology and networks"]
["Example  …Softwaretechnik I…(to be substituted!)",5,null,null,"x",null,null,null,null,null,null,"5. Knowledge organization"]
["Example  …Informatik, Recht und Gesellschaft…(to be substituted!)",5,null,"x"]
["Example  …Künstliche Intelligenz…(to be substituted!)",5,null,null,null,null,null,"x"]
["Example  …Mensch-Computer-Interaktion…(to be substituted!)",5,null,null,null,null,"x",null,null,null,null,"4. Human-computer-interaction"]
["Example  …Paradigmen der Programmierung…(to be substituted!)",5,null,null,"x",null,null,null,null,null,null,"17. Operating systems"]
["Example  …Softwaretechnik II…(to be substituted!)",5,null,null,"x",null,null,null,null,null,null,"5. Knowledge organization"]
["Example  …Spezielle Gebiete der Datenbanken…(to be substituted!)",5,null,null,"x",null,null,null,null,null,null,"8. Information in companies"]
[]
["Example  …Wahlspezialisierung I…(to be substituted!)",15,null,null,null,null,null,null,null,"x"]
["Example  …Wahlspezialisierung II…(to be substituted!)",15,null,null,null,null,null,null,null,"x"]
["Example  …Praxisprojekt mit begleitendem Projektseminar…(to be substituted!)",15,null,null,null,null,null,null,null,"x"]
["Example  …Bachelorarbeit…(to be substituted!)",12,null,null,null,null,null,null,null,"x"]
["Example  …Bachelor Kolloquium…(to be substituted!)",3,null,null,null,null,null,null,null,"x"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total credit points:",{"$f":"SUM(B29:B108)","v":180},null,{"$f":"SUMIFS($B29:$B108,D29:D108,\"x\")","v":5},58,10,12,25,10,60,null,{"$f":"SUMIFS($B29:$B108,L29:L108,\"<>Other\",L29:L108,\"<>\")","v":90}]
[null,"eq ECTS :",null,{"$f":"D109*$B112/$B109","v":5},{"$f":"E109*$B112/$B109","v":58},10,12,25,10,60,null,90]
[null,"eq Prozent",null,{"$f":"D109/$B109","v":2.7777777777777776E-2},{"$f":"E109/$B109","v":0.32222222222222224},{"$f":"F109/$B109","v":5.5555555555555552E-2},6.6666666666666666E-2,0.1388888888888889,5.5555555555555552E-2,0.33333333333333331,null,0.5]
["Mindest ECTS gemäß PO1 §3 (6):",180]
[null,null,null,null,null,null,"Minimum"]
[null,null,null,"Area","Total Credit","scaled credit","BIS","DIS","ITM","SAR"]
[null,null,null,"AR",{"$f":"D109","v":5},{"$f":"D110","v":5},5,5,5,5]
[null,null,null,"ACS",{"$f":"E109","v":58},{"$f":"E110","v":58},10,10,5,30]
[null,null,null,"DIP",{"$f":"G109","v":12},{"$f":"G110","v":12},0,0,0,0]
[null,null,null,"EB",{"$f":"F109","v":10},{"$f":"F110","v":10},25,5,5,5]
[null,null,null,"GAK",{"$f":"H109","v":25},{"$f":"H110","v":25},5,30,5,5]
[null,null,null,"MRI",{"$f":"I109","v":10},{"$f":"I110","v":10},5,0,30,5]
[null,null,null,"Other",{"$f":"J109","v":60},{"$f":"J110","v":60}]
[null,null,null," -"]
[null,null,null,"SUM",{"$f":"SUM(E115:E121)","v":180},180,50,50,50,50]
[]
[null,null,null,null,null,null,"Gap BIS*","Gap DIS*","Gap ITM*","Gap SAR*"]
["You can apply for the subjects where the gap is below or equal to 15 !",null,null,"AR",null,null,{"$f":"MAX(0,G115-F115)","v":0},{"$f":"MAX(H115-F115,0)","v":0},{"$f":"MAX(I115-F115,0)","v":0},{"$f":"MAX(J115-F115,0)","v":0}]
[null,null,null,"ACS",null,null,{"$f":"MAX(G116-F116,0)","v":0},0,0,0]
[null,null,null,"DIP",null,null,{"$f":"MAX(G117-F117,0)","v":0},0,0,0]
["This tables calculate if enough credits in the focus areas were earned in order to be able to apply to the specific field of study. It is not meant as a guarantee that you will or will not be approved but it serves as a way to give you an automatic feedback on your self evaluation.",null,null,"EB",null,null,{"$f":"MAX(G118-F118,0)","v":15},0,0,0]
[null,null,null,"GAK",null,null,{"$f":"MAX(G119-F119,0)","v":0},5,0,0]
[null,null,null,"MRI",null,null,{"$f":"MAX(G120-F120,0)","v":0},0,20,0,null,"Green: You can apply"]
[null,null,null,null,null,null,null,null,null,null,null,"Yellow: You can apply, but you need to earn the missing credits later"]
[null,null,null,"SUM",null,null,{"$f":"SUMIF(G126:G131,\">0\")","v":15},{"$f":"SUMIF(H126:H131,\">0\")","v":5},{"$f":"SUMIF(I126:I131,\">0\")","v":20},{"$f":"SUMIF(J126:J131,\">0\")","v":0},null,"Red: You cannot apply"]
[]
[null,null,null,"Your current selection: ",null,null,null,{"$f":"IF(B19=\"BIS: Business Information Systems\",HYPERLINK(\"https://digital-sciences.de/en/studyprograms/business-information-systems/index.html\",\"BIS: Business Information Systems\"),IF(B19=\"DIS: Data and Information Science\",HYPERLINK(\"https://digital-sciences.de/en/studyprograms/data-and-information-science/index.html\",\"DIS: Data and Information Science\"),IF(B19=\"ITM: IT-Management\",HYPERLINK(\"https://digital-sciences.de/en/studyprograms/it-management/index.html\",\"ITM: IT-Management\"),IF(B19=\"SAR: Software Architecture\",HYPERLINK(\"https://digital-sciences.de/en/studyprograms/software-architecture/index.html\",\"SAR: Software Architecture\"),5))))","v":"SAR: Software Architecture"}]
["Click the \"Check form for errors\" button to check if everything is correct."]
[null,null,null,{"$f":"IF(L111<44/100,\"1) Not enough ECTS in Computer and Information Science (80 required).\",\"1) ECTS precondition in Computer and Information Science fulfilled, if the admission committee accepts your self-assessment.\")","v":"1) ECTS precondition in Computer and Information Science fulfilled, if the admission committee accepts your self-assessment."}]
[null,null,null,{"$f":"IF(AND(B19=\"BIS: Business Information Systems\",G133<=15),\"2) You should be eligible for your specialisation, if the admission committee accepts your self-assessment.\",IF(AND(B19=\"DIS: Data and Information Science\",H133<=15),\"2) You should be eligible for your specialisation, if the admission committee accepts your self-assessment.\",IF(AND(B19=\"ITM: IT-Management\",I133<=15),\"2) You should be eligible for your specialisation, if the admission committee accepts your self-assessment.\",IF(AND(B19=\"SAR: Software Architecture\",J133<=15),\"2) You should be eligible for your specialisation, if the admission committee accepts your self-assessment.\",_xlfn.CONCAT(\"2) You might not be eligible for your specialisation: \",B19)))))","v":"2) You should be eligible for your specialisation, if the admission committee accepts your self-assessment."}]
[]
[]
[]
["After completion, please convert the file to a csv file and then upload it to Sciebo."]
[]
["Thank you for your application."]