course-details-portlet

INFT1001 - Introduction to information technology and databases

About

New from the academic year 2019/2020

Examination arrangement

Examination arrangement: Written examination
Grade: Letters

Evaluation form Weighting Duration Examination aids Grade deviation
Written examination 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

Exam registration requires that class registration is approved in the same semester. Compulsory activities from previous semester may be approved by the department.

Admission to a programme of study is required:
Information Technology (ITBAINFO)

Required previous knowledge

None.

Course materials

Given at the start of the course.

Credit reductions

Course code Reduction From To
IDRI1002 7.5 01.09.2019
IINI1001 3.7 01.09.2019
IFUD1101 3.7 01.09.2019
IINI1003 3.7 01.09.2019
IFUD1103 3.7 01.09.2019
DIFT1002 7.5 01.09.2019
IDATT2103 3.0
More on the course

No

Facts

Version: 1
Credits:  7.5 SP
Study level: Foundation courses, level I

Coursework

Term no.: 1
Teaching semester:  AUTUMN 2019

No.of lecture hours: 8
Lab hours: 8

Language of instruction: Norwegian

Location: Trondheim

Subject area(s)
  • Computer and Information Science
Contact information
Course coordinator: Lecturer(s):

Department with academic responsibility
Department of Computer Science

Phone:

Examination

Examination arrangement: Written examination

Term Status code Evaluation form Weighting Examination aids Date Time Digital exam Room *
Autumn ORD Written examination 100/100 B 2019-11-27 09:00
Room Building Number of candidates
Storhall del 1 Idrettssenteret (Dragvoll) 7
Spring UTS Written examination 100/100 B 2020-05-06 09: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.
Examination

For more information regarding registration for examination and examination procedures, see "Innsida - Exams"

More on examinations at NTNU