AØKA08161U ICT-Applied

Volume 2017/2018
Education

MSc programme in Economics – elective course

Bacheloruddannelsen i økonomi - valfag efter 1. år 

The Danish BSc programme in Economics - elective after 1st year

This course is mainly for foreign students. Enrolled students can only register in the late registration period in January if there is available seat.

The course will for the last time be offered in the spring 2018

Content

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.

Learning Outcome

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.

None, or elementary knowledge of information technology and computer use. Because of content overlap students who have taken any of the courses Datamatik 1 or Datamatik 2 cannot participate in the course.
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. Group work recommended.
Schedule:

Spring 2018:
The overall schema for the BA 3rd year can be seen at https:/​/​intranet.ku.dk/​polit_ba/​undervisning/​Lektionsplan-F18/​Sider/​default.aspx
or the Master at https:/​/​intranet.ku.dk/​ECONOMICS_MA/​COURSES/​COURSECATALOGUE-F18/​Pages/​default.aspx


Autumn 2017:
3 hours lectures a week from week 36 to 50 (except week 42).

The overall schema for the BA can be seen at https:/​/​intranet.ku.dk/​polit_adm/​undervisning/​Lektionsplan-E17/​bachelorfag/​Sider/​default.aspx or the Master at https:/​/​intranet.ku.dk/​economics_ma/​courses/​CourseCatalogue-E17/​Courseschema/​Pages/​default.aspx

Timetable and venue:
To see the time and location of lectures please press the link/links under "Se skema" (See schedule) at the right side of this page (E means Autumn, F means Spring).

You can find the similar information partly in English at
https:/​​/​​skema.ku.dk/​​ku1718/​​uk/​​module.htm
-Select Department: “2200-Økonomisk Institut” (and wait for respond)
-Select Module:: “2200-E17; [Name of course]””
-Select Report Type: “List – Weekdays”
-Select Period: “Efterår/Autumn – Weeks 31-5”
Press: “ View Timetable”
  • Category
  • Hours
  • Lectures
  • 42
  • Preparation
  • 164
  • Total
  • 206
Credit
7,5 ECTS
Type of assessment
Continuous assessment
The 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, rules, exam schedule etc. is available at the intranet for master students (UK) , master students (DK) and bachelor students (DK).

____

Re-exam

There is no re-sit exam in ICT-Applied. Non-passed students are normally registered at the course in the next semester. due to the course will not be offered any more from June 30, 2018, non-passed students must contact the study administration. 

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.

____