Syllabus

Title
0652 Corporate IT I - Information Structures
Instructors
Dr. Helena Lovasz-Bukvova
Type
PI
Weekly hours
2
Language of instruction
Englisch
Registration
09/05/17 to 10/07/17
Registration via LPIS
Notes to the course
Dates
Day Date Time Room
Wednesday 10/11/17 09:00 AM - 10:00 AM TC.3.08
Wednesday 10/18/17 09:00 AM - 01:30 PM TC.5.02
Wednesday 10/25/17 09:00 AM - 01:30 PM D2.0.382
Wednesday 11/08/17 09:00 AM - 01:30 PM TC.3.06
Wednesday 11/15/17 09:00 AM - 01:30 PM TC.3.07
Wednesday 11/22/17 09:00 AM - 01:30 PM TC.3.21
Contents

The collection and management of data plays an important role in today’s organisations. Increasingly, the importance of management of information and knowledge are also recognised. The understanding of mechanisms and ideas behind data and information management is an important skill in nearly all professions, as it helps to increase the personal as well as the organisational efficiency. This course aim is to furnish an in-depth understanding of the principles and key languages behind data and information collection, structuring, and retrieval, together with knowledge of their practical application.

In the course, we will address the following topics:

  • different possibilities of structuring data, their application as well as advantages and disadvantages
  • relational data structures, including the design of relational databases and data retrieval with SQL
  • encoding non-relational structures with XML (this includes also defining data structures with DTD and XSD) and HTML (this includes also CSS)
  • transforming XML-encoded information into different data formats with XSLT
  • management and retrieval of unstructured information (Information Retrieval)
  • introduction to Semantic Web and related information structures
The focus of this course is on theoretical understanding as well as practical application. The course structure also allows the participants to place their own focus on particular areas.
Learning outcomes

After attending this course, you will be able to understand, describe and judge key approaches to data and information management.

Subject-related skills

  • distinguish different approaches to structuring data, information, and knowledge
  • design relational databases and write SQL-queries to retrieve data
  • define structures of XML using DTD and XSD and create XML-files
  • design HTML-pages
  • transform XML using XSLT
  • understand key principles of information retrieval, such as Boolean logic in search expressions and Web Information Retrieval
  • understand key ideas of the Semantic Web

Soft-skills

  • ability to autonomously collect, filter, and structure information on a previously unknown subject
  • ability to assess own strength and weaknesses and adjust practices accordingly
  • experience with designing own learning processes
  • practice with decision making and planning
Teaching/learning method(s)

The aim of this course is not only to provide you with relevant theoretical knowledge, but also to enable you to put what you have learned into practical use. The design of the course reflects this, combining phases of knowledge acquisition with exercises and practical application. The instructor takes a part of a mentor, rather than a teacher; hence the course is driven by your active participation and learning needs. The learning activities can be divided into autonomous preparation, unit activities and project work.

  • Autonomous preparation. The course area on Learn@WU provides the participants with materials for autonomous preparation. The participants are expected to work through these materials on their own in preparation for the presence units.
  • Unit activities. In each unit (these can be better described as labs), the participants will take part in repetition and self-tests that will help them to better assess their own progress. Then they can decide whether they wish to engage in further learning and practice, if they wish to put their knowledge to a test (see Assessment) or if they want to get started on project work. The different activities are available in the form of learning stations, so that the participants have the freedom to tailor the presence labs to their own learning needs.
  • Project work. While parts of the assessed activities are carried out in the units (see assessment), the project work is of a complexity that needs a greater time investment. Although the participants are invited to carry out parts of the projects work in the units, according to their interest, they are likely to need further work after the units.

As the course covers a large number of topics within a very short period of time and with only 5 presence units, you will be expected to invest a considerable amount of time into autonomous learning. You can expect to invest up to 100 hours learning time (as adequate for 4 ECTS points), if you have no previous knowledge of the topics and wish to get a top grade. The workload can be roughly divided into following parts (the exact amount of time necessary will depend of your background and your learning style):

  • approx. 25 hours presence learning (20% compulsory attendance, but full attendance is strongly advisable)
  • up to 40 hours autonomous theoretical preparation and practice
  • up to 35 hours (ideally spread out evenly throughout the term) for project work
Please note: This is a very demanding course and it is not advisable to attempt it parallel to other similarly demanding courses! The course format requires a high level of self-discipline and interest in learning. The course does not require previous knowledge of programming or any other technical skills - as long as you willing to learn and not afraid to invest time into learning, you will do well in the course.
Assessment

This course is based on the idea that the participants are the decision makers in the course, who govern their learning according to their own needs. The assessment format takes it into account.The overall principle is that of performance-based assessment: you have to demonstrate certain abilities to gain points, but you are free to choose your assessment in a mix-and-match fashion.

The overall assessment consists of three parts, foundations, challenges and project, with each part consisting of several assessments.

Foundations (5 tests á 10 points, max. 50 points)

The foundations tests the participants understanding of the topics and their ability to apply them in business settings. This understanding is assessed in the form of written tests, requiring the participants to apply their knowledge to case studies and real-world examples. The participants are expected to be familiar with the key terms as well as the constructs and topics covered in the course. Any one of the tests can be taken in any of the units. Participants who do not get full points are allowed to improve their tests in later units. The participants can choose which tests and hence which topics they wish to focus on.

Challenges (5 challenges á 10 points, max. 50 points)

In the challenges, the participants are presented with a problem related to the concepts and languages they learn in the course. The challenges require an in-depth understanding of the languages and their interplay as well as conceptual abilities and knowledge of relevant research topics. Each challenge is related to a particular topic and this available in the related unit and cannot be retaken or take another time. The participants can decide freely, which challenges they wish to take.

Project (max. 50 points)

The project is an applied activity encompassing all topics covered in the course, though the participants can chose their focus in the project. The pariticipants are required to use their new knowledge and skill to solve a real-world problem, making their own decisions in the process. The projects require the participant to not only apply skills that were covered in the autonomous learning and the units, but to look for further knowledge as necessary to fulfil the project task.

Grades

The grading system is closely aligned to the assessment methods. The scale is non-linear, rather representing different levels of achievement:

  • under 50 points     5 (fail)
  • under 60 points      4
  • under 75 points      3
  • under 90 points      2
  • 90 points or more   1
Prerequisites for participation and waiting lists
  • Courses: GK1 Grundzüge der ITK (Foundations in ICT)  - this is a fixed restriction that cannot be waived under any circumstances!
  • Administrative: Registration in the LPIS, attendance of the first unit, participation in course planning

    Please note:

    • The number of available places is limited and there is often a list of students waiting for free places. If you have signed up for the course and during the registration period find out you will not attend, please remove your name from the list via LPIS. This will make your place available to others.
    • The assignment of available places in the course is based on the „first-come, first-served" principle.
    • The participation in the first unit is mandatory; students who fail to come forfeit their place to students on the waiting list. Students can excuse themselves if the reason for missing the first unit is serious and will concern only the first unit.
    Recommended previous knowledge and skills
    • You should have a basic understanding of the role of information systems in organisations (in general).
    • It is helpful though not mandatory, if you have a basic understanding of relational databases.
    • You should be open to learning about technical issues and willing to try them out yourself (even if you think that you are not technical).
    Availability of lecturer(s)

    Lecturer:   Helena Lovasz-Bukvova

    E-Mail:      helena.lovasz-bukvova@wu.ac.at

    Room: D2.2.078 (Building D2, entrance C)

    Schedule appointment: http://www.meetme.so/helenabukvova

    Is this for me?
    This is a course for everyone who not only wants to know about data and information structuring, but who actually wants to be able to sit down to a computer and apply the new-learned knowledge. The course welcomes participants from very different backgrounds (with existing IT skills or even totally without), as it provides a very very flexible learning structure. Participants should take into account the high learning effort that is associated with this course as well as the fact that it requires you to learn and work autonomously. Those who are not afraid to invest their time and get their hands dirty can expect to gain an array of new skills, and even discover their hidden IT talent.
    Unit details
    Unit Date Contents
    1 General information (1 hour)
    2 Lab: different models for data and information structuring
    3 Lab: structuring information (XML, relational databases, noSQL)
    4 Lab: transforming structured information (HTML, CSS, XSLT)
    5 Lab: Information retrieval
    6 Lab: Semantic Web
    Last edited: 2017-10-04



    Back