AØKA08161U ICT-Applied
MSc in Economics
The course work aims to give the students basic IT-knowledge on the background of tasks related to both public and business organizations where ICT play a strategic role. Cornerstones are efficient database handling and efficient data processing in spreadsheets.
In the course we practice development of various software applications on the computer as well as providing a general system understanding that will facilitate communication with IT-specialists. E.g. the student should be capable of developing smaller applications for spreadsheets, and also for instance be able to provide a clear specification for an IT-specialist to develop a database based web application.
Among the course subjects are:
- Creating macros and functions in spreadsheets and in this way improving efficiency and reducing errors (for example programming macros for Excel).
- Design and use of Graphical User Interfaces (GUI). GUI permeates most personal computer and web applications today and knowledge about the idea and approaches to designing and using is essential in present-day IT.
- Use and solution integration of databases (for example extracting stock data to aggregate statistics)
- Client and server based web technologies (example: through the web providing the customer with database information such as it is done by web banking and public sector tax information)
- Communication technologies
- Definition of business scopes and specification of system requirements
- Algorithmic solutions are based on VBA (Visual Basic for Applications), primarily connected to enhancing and customizing Excel with macros and functions. Database queries are defined using SQL. Various tools, such as HTML, Scripts, c#, XML for web-site design are studied, including Expression Web. Hands-on guidance will be provided as needed during the course.
The selected tools can be used on the student’s own computer, or on computers in the student user rooms.
The objective of the ICT-Applied course is to provide students with a broad knowledge of Information and Communications Technology, as it relates to working as an economist, and to an understanding of today’s business processes and strategy. This will enhance the student’s job opportunities in both the public and the private sector.
The specific objectives, i.e. the learning outcomes, are that by the end of the course all students will be able to:
- Explain the correlation between spreadsheets, programming languages, application generators and databases
- Record and edit macros in spreadsheets like Excel
- Write tailored software for spreadsheets in a proper programming language
- Design, develop and test Windows applications based on simple algorithms
- Explain the principles of relational databases
- Use SQL for complex database queries with logical expressions and subqueries
- Explain the principles behind Object Oriented Programming
- Explain the basic technologies behind the World Wide Web
- Plan, design, create and implement a Web site
- Explain where the studied technologies are positioned in the general system development process
Teacher notes, extracts from manuals and machine readable documentation.
The teaching comprises lectures, hands-on guidance, assignments and tasks. Normally assignments and tasks can be solved using the student’s own pc, provided Windows and Office are installed. The utilized web-development software is provided for installation on the student’s computer.
Time and room:
Time and room for the lectures and exercise classes: Please press the link under "Se skema" (See schedule). 15F means Spring (Forår) 2015, 14E means Autumn (Efterår) 2014.
The schedule for the Spring semester is available partly in English at this link:
https://skema.ku.dk/KU1415/reporting/textspreadsheet?objectclass=module&idtype=id&identifier=43801&t=SWSCUST+module+textspreadsheet&days=1-5&weeks=27-52&periods=1-68&template=SWSCUST+module+textspreadsheet
The first lecture in the springsemester will be the 3.th of February 2015 at 15.00 o´clock (3.00 PM).
Danish students are not allowed to register for the course in the ordinary registration period. If there are free spots on the course it will be possible for all students to register in the late registration period.
- Category
- Hours
- Lectures
- 42
- Preparation
- 164
- Total
- 206
- Credit
- 7,5 ECTS
- Type of assessment
- Continuous assessmentThe completion of the course is based on the approval of 4-5 compulsory assignments, and an individual test. There are no grades.
- Aid
- All aids allowed
- Marking scale
- passed/not passed
- Censorship form
- No external censorship
- Exam period
- More information is available at https://intranet.ku.dk/economics_ma/examination/Pages/default.aspx
- Re-exam
- The assignments must be handed in again and this has to be arranged with the course responsible.
Criteria for exam assesment
The student must in a satisfactory way demonstrate that he/she has mastered the learning outcome of the course.
Course information
- Language
- English
- Course code
- AØKA08161U
- Credit
- 7,5 ECTS
- Level
- Full Degree MasterBachelor
- Duration
- 1 semester
- Placement
- Autumn And Spring
- Schedule
- Autumn (week 36-50)
Spring (week 6-21) - Continuing and further education
- Price
320 DKK per ECTS
- Study board
- Department of Economics, Study Council
Contracting department
- Department of Economics
Course responsibles
- Jeppe Traberg (5-746f7a7a6f4a7d6b777037737e38757f386e75)
- Henrik Meyer (12-6a6770746b6d306f677b6774426b6476306d7730666d)