Course - Introduction to information technology and databases - DIFT1002
DIFT1002 - Introduction to information technology and databases
About
New from the academic year 2019/2020
Examination arrangement
Examination arrangement: Written examination
Grade: Letters
Evaluation | Weighting | Duration | Grade deviation | Examination aids |
---|---|---|---|---|
Skriftlig eksamen | 100/100 | 3 hours | B |
Course content
IT introduction: Introduction to information technology, computer architecture, binary system, software and operating systems, local networks and the Internet, virtualization and cloud computing, collaboration tools, social media and data security.
Databases: Introduction to data modeling with EER. Design of relation database including use of keys and reference integrity. Database Definition (DDL) and Data Manipulation (DML) in SQL. Use of a selected database tool (MySQL or equivalent).
Learning outcome
Knowledge
The candidate:
- can describe the computer's basic architecture
- explain the operating system's basic functions and roles
- explain the basic behavior of local networks and the internet
- know the concepts of virtualization and known providers within cloud services
- knowing useful collaboration tools and key social media
- know important concepts within databases and explain these
- can use SQL
- understand (interpret) an (E) ER diagram and know how this can be translated into the relational data model
Skills
The candidate:
- can choose appropriate collaborative tools to solve tasks in collaboration with others
- can secure their own computer and computer networks against attacks and accidents
- can create a virtual machine or service with a cloud computing supplier
- can draw their own (E) ER diagrams to achieve a good database structure
- can create a separate database and retrieve and modify the data in this database, all through SQL
General competence
The candidate:
- get a basic understanding of how information technology is used in different contexts of society
- get an understanding of how database solutions can be used to solve different requirements for storing digital data.
Learning methods and activities
Teaching and practical compulsory exercises that are included in the work requirements, supervision with a teacher and / or student assistant.
Compulsory assignments
- Exercises
Further on evaluation
Simultaneous exam (same time) as equivalent subjects in new BA in Digital Business Development (formerly IT-supported business development).
Simultaneous exam (same time) with distance learning subjects IFUD1103 Databases.
Deferred exam is conducted in the next regular exam period.
Assessment report requires approved teaching message the same semester. Mandatory activity from previous semesters can be approved by the institute.
Specific conditions
Admission to a programme of study is required:
Digital Business Development (ITBAITBEDR)
Recommended previous knowledge
Basic use of web-browser and text editor.
Required previous knowledge
None.
Course materials
Given at the start of the study.
Credit reductions
Course code | Reduction | From | To |
---|---|---|---|
INFT1001 | 7.5 | ||
IINI1001 | 3.7 | ||
IFUD1101 | 3.7 | ||
IINI1003 | 3.7 | ||
IFUD1103 | 3.7 | ||
IDRI1002 | 7.5 | ||
IDATT2103 | 3.0 |
No
Version: 1
Credits:
7.5 SP
Study level: Foundation courses, level I
Term no.: 1
Teaching semester: AUTUMN 2019
Language of instruction: Norwegian
Location: Trondheim
- Computer and Information Science
Department with academic responsibility
Department of Computer Science
Examination
Examination arrangement: Written examination
- Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
- Autumn ORD Skriftlig eksamen 100/100 B 2019-11-27 09:00
-
Room Building Number of candidates SL311 lyseblå sone Sluppenvegen 14 30 SL120 orange sone Sluppenvegen 14 1 SL311 orange sone Sluppenvegen 14 27
Examination arrangement: Home examination
- Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
-
Spring
UTS
Home exam
100/100
Release
2020-05-06Submission
2020-05-06
09:00
INSPERA
12:00 -
Room Building Number of candidates
- * The location (room) for a written examination is published 3 days before examination date. If more than one room is listed, you will find your room at Studentweb.
For more information regarding registration for examination and examination procedures, see "Innsida - Exams"