AØKA08161U ICT-Applied
BSc programme in Economics - elective from the 2.year
MSc programme in Economics – elective course
This course is mainly for foreign students.
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. 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 as follows.
Knowledge:
Explain the correlation between spreadsheets, programming languages, application generators and databases
Explain the principles of relational databases
Explain the basic technologies behind the World Wide Web
Explain the SQL language and its applications
Explain the principles behind Object Oriented Programming
Explain where the studied technologies are positioned in the general system development process
Skills:
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
Use SQL for complex database queries with logical expressions and subqueries
Assist in planning, designing, creating and implementing the algorithmic part of a Web site
Competencies:
Use pc as development tool for administrative and analytical solutions
Communicate with IT-specialists
Contribute as member of IT project group
Teacher notes, extracts from manuals and library-online books. Machine-readable documentation. No purchases required.
The course consists of 3 hours of classes (lectures) every week for 14 weeks.
Timetable and venue:
To see the time and location of lectures and exercise classes please press the link/links under "Se skema" (See schedule) at the right side of this page (16E means Autumn 2016, 17F means Spring 2017). The lectures is shown in each link.
You can find the similar information partly in English at
https://skema.ku.dk/ku1617/uk/module.htm
-Select Department: “2200-Økonomisk Institut” (and wait for respond)
-Select Module:: “2200-E16; [Name of course]” or “2200-F17; [Name of course]”
-Select Report Type: List
-Select Period: “Efterår/Autumn – Weeks 30-3” or “Forår/Spring – Week 4-29”
Press: “ View Timetable”
- Category
- Hours
- Lectures
- 42
- Preparation
- 164
- Total
- 206
for enrolled students. More information about registration, schedule, rules, courses etc. can be found at the student intranet (KUnet) for courses (MA-English) and student intranet (KUnet) for courses (KA-Danish) or student intranet (KUnet) for courses (BA- Danish).
Registration and information for foreign students not enrolled please find more information at Study Economics.
For enkelfagsstuderende sker tilmelding via Åbent Universitet og Merit.
- 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 during the semester. There are no grades.
- Exam registration requirements
Running approval of mandatory papers.
- Aid
- All aids allowed
- Marking scale
- passed/not passed
- Censorship form
- No external censorship
- Exam period
During the course.
For enrolled students more information about examination, exam/re-sit, rules etc. is available at the student intranet for Examination (English) and student intranet for Examination (BA-Danish).
- Re-exam
The assignments must be handed in again and this has to be arranged with the course responsible.
Criteria for exam assesment
Students are assessed on the extent to which they master the learning outcome for the course.
Grading is on a pass/fail basis. In order to obtain a passing grade, students must demonstrate in a satisfactory way that they have met the learning outcomes.
Course information
- Language
- English
- Course code
- AØKA08161U
- Credit
- 7,5 ECTS
- Level
- Full Degree MasterBachelor
- Duration
- 1 semester
- Placement
- Autumn And Spring
- Schedule
- Teaching:
Autumn: Week 36-50
Spring: Uge 6-20
Timeschedule: See "Remarks"
Exam and re-sits: See "Exam" - Course capacity
- 28 (15 seats are primary for students at Department of Economics)
- Continuing and further education
- Price
- Study board
- Department of Economics, Study Council
Contracting department
- Department of Economics
Course responsibles
- Jeppe Traberg
(5-6e69747469447765716a316d78326f7932686f)
Atumn 2016 - Henrik Meyer
(12-6f6c7579707235746c806c794770697b35727c356b72)
Spring 2017
Lecturers
Lectures: See ‘Course responsibles’
Class teacher 2016:
Henrik Meyer
Class teacher 2017:
Henrik Kruuse