IT Foundations I
BASIC DATA
course listing
A - main register
course code
IDK0043
course title in Estonian
IT alused I
course title in English
IT Foundations I
course volume CP
-
ECTS credits
3.00
to be declared
yes
fully online course
not
assessment form
Pass/fail assessment
teaching semester
autumn - spring
language of instruction
Estonian
English
The course is a prerequisite
Computer aided Road Engineering (ETT0260)
Study programmes that contain the course
code of the study programme version
course compulsory
EAAB16/25
no
EACB17/25
no
EAEI02/25
yes
EAKI02/25
yes
EANB16/25
no
EATI02/25
yes
EAUI12/25
no
HAAB02/25
yes
HAJB08/25
yes
LAAB17/25
yes
LARB17/25
yes
LATB22/25
yes
TVTB12/25
yes
display more
Structural units teaching the course
ET - Tartu College
IT - Department of Software Science
Course description link
Timetable link
View the timetable
Version:
VERSION SPECIFIC DATA
course aims in Estonian
Aine eesmärgiks on anda esmased ja hädavajalikud oskused infoühiskonnas toimetulekuks ja luua eeldused tõhusaks infotööks. Tutvustatakse infotöö olulisemaid aspekte ning tutvutakse üldotstarbelise kontoritarkvara olulisemate funktsionaalsustega. Ühtlasi annab aine baasteadmised ka enamlevinumate riistvara toimimispõhimõtetest, kasutamisest ning ettevalmistamisest. Muu hulgas käsitletakse ka netiketti ja multimeediatöötlust; õpitakse tundma infoturbega seotud ohtusid ja võimalusi.
course aims in English
The purpose of this course is to provide students with necessary skills to survive in information society and perform efficiently with help of information technology devices. Overview will be given about basic skills to use hard- and software, introduction to the efficient work with information and office software will be given. Additionally relevant aspects of netiquette and multimedia, most important aspects of data protection will be included.
learning outcomes in the course in Est.
Üliõpilane:
- omab ettekujutust arvutite kasutamisest infotöö toetamiseks;
- saab aru Interneti tööpõhimõttest; valdab elementaartasemel HTML-keelt, tunneb netiketti;
- valdab elementaartasemel foto-, video ja helitöötluse vahendeid pildi- ja helitöötluse vahendeid;
- oskab turvaliselt jagada infot Internetis ning saab aru brauseri turvasertifikaadi ja kahetasemelise autentimise olemusest;
- teab arvuti põhikomponente, tunneb arvutivõrgu tööpõhimõtteid ja saab aru arvuti ostmisel kasutatavatest arvuti parameetritest;
- teab dokumentide (tekstid, tabelid, esitlused) põhielemente ja nende omadusi;
- koostab ja vormindab dokumente (tekstid, tabelid, esitlused), kasutades optimaalseid töövõtteid;
- tunneb ja kasutab kontoritarkvara lihtsamaid mugavusteenuseid (stiilid, mallid, sisukorrad jm);
- kasutab tabeliprogrammides eri liiki andmeid ning koostab keskmise keerukusega avaldisi (valemeid), kasutades funktsioone ja erinevaid viitamisvõimalusi andmetele;
- kasutab tabeliprogramme efektiivselt keskmise keerukusega rakenduste loomisel, milles võib olla kasutusel mitu omavahel seotud tabelit;
- omab ülevaadet tabeltöötlusvahendite andmeanalüüsi võimalustest, oskab teha andmetabelitest päringuid: väljavõtted, koondid.
learning outcomes in the course in Eng.
Student in result will have:
- clear understanding how to use computers for work purpose;
- understanding about main principles of Internet and is familiar with netiquette
- basic knowledge for multimedia files manipulation;
- skills to share information securely over the internet and understands the browser security functions;
- knowledge about main components of the computer, computer network and how to select one for buying based on main parameters;
- knowledge about digital document basic elements and functionality;
- skills to create and format digital documents optimally;
- skills to implement main convenience services offered by text editors (styles, templates, building blocks and so forth);
- skills to use different type of data in spreadsheet software and use medium complexity formulas to calculate the results;
- an overview about spreadsheet software data analysis functionalities and is able to deploy several of these.
brief description of the course in Estonian
Aine koosneb erinevatest moodulitest, mille läbimise käigus käsitletakse erinevaid teemasid ja antakse praktilisi oskusi tehnoloogia ja tarkvara käsitsemiseks:
- Dokumentide koostamine ja disain, kaasa arvatud esitluste koostamine
- Rakenduste loomine ja andmeanalüüsi teostamine tabelitöötluse vahenditega
- Lühiülevaade riistvarast ja arvutivõrkudest ja operatsioonisüsteemist
- Internet, infootsing ja multimeedia
- Küberturvalisus ja netikett
Aine algab eeltestiga, mille käigus selgitatakse välja tegelik vajadus erinevate moodulite läbimiseks - eeltestis mooduli läbimisel loetakse see moodul läbituks, kõigi moodulite läbimisel aine läbituks. Iga moodul lõpeb testiga.
Olulisel kohal kursuses on tabeliprogrammide struktuur, mudelid ja põhiobjektid. Vaadeldakse tabelite tüüpstruktuure, nimede ja valemite kasutamist tabelites, valideerimist, vahendeid tabelite korrastamiseks, päringute esitamiseks, koondite ja kokkuvõtete tegemiseks jms. Käsitletakse tööd mitme omavahel seotud tabeliga ja andmemudeleid andmebaasidele sarnanevate struktuuride kirjeldamiseks. Dokumenditöötluse osas toetatakse tudengi poolt erinevates ainetes teostatavate kirjalike tööde ja ettekannete vormistamist.
Interneti ja turbeküsimused on lahutamatult seotud ning neid käsitletakse koos erinevatest aspektidest lähtuvalt.
Moodulid sisaldavad olulise osa iseseisvat kodust tööd. Praktilist tegevust eeldavad mooduli osad läbitakse osaliselt praktikumides õppejõu juhendamisel ning võivad sisaldada ka mahukamate individuaaltööde koostamist.
brief description of the course in English
Course is composed from different modules, dealing with various topics with purpose to provide students with practical skills to handle technology and software:
- drafting and design of various documents;
- creating applications using spreadsheet tools;
- brief overview of the hardware and operating systems;
- Internet, information search and media;
- security risks.
An important part of the course is dedicated to the use of spreadsheets, the table structures, models and key objects. Different types of table structures will be introduced, also names and formulas used in the tables, validation, queries and so forth. Several examples of inter-related databases and data models will be introduced.
Document creation and formatting is introduced to support studies.
Internet and security risks are introduced and investigated from different aspects.
The course is focused on individual work and performing tests. Practical assignments will be performed partly on class under supervision and might contain significant parts of individual works packages.
type of assessment in Estonian
Arvestuse tulemus fikseeritakse mitteeristuvas hindamissüsteemis
(A/MA).
Arvestuse saamiseks peab sooritama kontrollitud keskkonnas
(arvutiklassis) kursuse lõpptesti.
Õppejõud võib esitada täiendavaid küsimusi kodutööde ja
testiküsimustele vastamisel kasutatud vahendite ja meetodite kohta
type of assessment in English
Final grading is assessed as either being passed or failed (P/F).
In order to receive credits for the course, students have to submit
and get acceptance for final test.
Additional questions might be asked about works and tests
according to need.
independent study in Estonian
Üliõpilane võidakse anda kuni neli individuaalset tööd (töö
koosneb mitmest ülesandest).
Ülesande püstitus ja esitamise tähtaeg iga kodutöö kohta teatatakse
kursuse õpikeskkonnas. Kodutöö sisu ja vormistus peavad vastama
antud ülesandepüstitusele, töö peab olema esitatud etteantud
tähtajaks.
Kodutööd hinnatakse mitteeristuvas hindamissüsteemis (A/MA).
Peale töö läbivaatamist teatab õppejõud õpikeskkonna kaudu, kas
töö on aktsepteeritud või mitte, ning parandamisele kuuluvad vead
ja puudused. Töö aktsepteeritakse, kui:
- kõik ülesanded on lahendatud;
- ükski lahendus ei sisalda olulisi vigu;
- vormistus on korrektne ja vastab nõuetele.
Mitteaktsepteeritud kodutöö tuleb parandada ja esitada uuesti.
Algselt negatiivse tulemuse saanud kodutöö võib saada positiivse
hinde (aktsepteeritud) alles pärast selle suulist kaitsmist õppejõuga
kokkulepitud ajal.
Märgitud mitteolulised vead ja puudused tuleb parandada ja tuua
kaasa lõpparvestuseks arvutiklassis. Hilinenult esitatud tööde
teemade kohta võib anda arvestuse ajal lisaülesanded.
Õppejõud võib arvestuse ajal esitada täiendavaid küsimusi tehtud
tööde kohta (ka siis, kui olulisi põhimõttelisi vigu ei esinenud).
independent study in English
Each student might get up to four homework assignments
(comprising of multiple topics). The description of each of the
homework is posted and the due date is communicated in a web
based environment. The contents of homework should correspond
to the problem description and homework should be handed in by
the due date.
Home works are assessed as either being passed or failed (P/F).
The acceptance of homework is a prerequisite for examination
accession.
Homework submitted on time, will be accepted, if:
- all the tasks are solved;
- none of the parts of the solution contain principal or significant
errors;)
- the homework is presented correctly and according to the
requirements.
A homework that is not passed, has to be corrected and
resubmitted.
An additional assessment might be estimated during final grading
about home works that have been submitted late.
All home works have to be defended orally during the final
grading and additional questions might be asked even in the case
the home works contain no important errors.
study literature
1. I. Amitan, J. Vilipõld. MS Excel. Rakenduste loomise põhielemendid. Tallinn, TTÜ
2. http://www.tud.ttu.ee/web/Juri.Vilipold/Exc_raamat/Exc_Pea_P.html Rakenduste loomine Excel'is (veebimaterjal)
3. E-õppele orienteeritud materjalid Web’is: e-õpikud, ekraanivisioonid jm.
study forms and load
daytime study: weekly hours
2.0
session-based study work load (in a semester):
lectures
0.0
lectures
0.0
practices
2.0
practices
16.0
exercises
0.0
exercises
0.0
lecturer in charge
-
LECTURER SYLLABUS INFO
semester of studies
teaching lecturer / unit
language of instruction
Extended syllabus or link to Moodle or to home page
2025/2026 autumn
Aleksandr Kormiltsõn, IT - Department of Software Science
English
    ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
    Riina Reinumägi, ET - Tartu College
    Estonian
      ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
      Olga Mironova, IT - Department of Software Science
      Estonian
        ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
        display more
        2024/2025 spring
        Olga Mironova, IT - Department of Software Science
        Estonian
          ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
          Irina Amitan, IT - Department of Software Science
          Estonian
            ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
            2024/2025 autumn
            Olga Mironova, IT - Department of Software Science
            Estonian
              ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
              Riina Reinumägi, ET - Tartu College
              Estonian
                ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                Aleksandr Kormiltsõn, IT - Department of Software Science
                English
                  ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                  2023/2024 spring
                  Irina Amitan, IT - Department of Software Science
                  Estonian
                    2023/2024 autumn
                    Olga Mironova, IT - Department of Software Science
                    Estonian
                      Riina Reinumägi, ET - Tartu College
                      Estonian
                        Aleksandr Kormiltsõn, IT - Department of Software Science
                        English
                          2022/2023 spring
                          Irina Amitan, IT - Department of Software Science
                          Estonian
                            2022/2023 autumn
                            Riina Reinumägi, ET - Tartu College
                            Estonian
                              Aleksandr Kormiltsõn, IT - Department of Software Science
                              English
                                Olga Mironova, IT - Department of Software Science
                                Estonian
                                  2021/2022 spring
                                  Irina Amitan, IT - Department of Software Science
                                  Estonian
                                    ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                    2021/2022 autumn
                                    Riina Reinumägi, ET - Tartu College
                                    Estonian
                                      ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                      Jelena Vendelin, IT - Department of Software Science
                                      English
                                        ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                        Aleksandr Kormiltsõn, IT - Department of Software Science
                                        English
                                          ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                          Irina Amitan, IT - Department of Software Science
                                          Estonian
                                            ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                            Jekaterina Tšukrejeva, IT - Department of Software Science
                                            English
                                              ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                              Anna Grund, IT - Department of Software Science
                                              English, Estonian
                                                ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                Olga Mironova, IT - Department of Software Science
                                                Estonian
                                                  ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                  Lilia Tünts, IT - Department of Software Science
                                                  English
                                                    ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                    2020/2021 spring
                                                    Irina Amitan, IT - Department of Software Science
                                                    Estonian
                                                      ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                      2020/2021 autumn
                                                      Lilia Tünts, IT - Department of Software Science
                                                      Estonian
                                                        ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                        Anna Grund, IT - Department of Software Science
                                                        Estonian
                                                          ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                          Aleksandr Kormiltsõn, IT - Department of Software Science
                                                          English
                                                            ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                            Irina Amitan, IT - Department of Software Science
                                                            Estonian
                                                              ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                              Jelena Vendelin, IT - Department of Software Science
                                                              English
                                                                ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                Riina Reinumägi, ET - Tartu College
                                                                Estonian
                                                                  ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                  Olga Mironova, IT - Department of Software Science
                                                                  Estonian
                                                                    ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                    2019/2020 spring
                                                                    Irina Amitan, IT - Department of Software Science
                                                                    Estonian
                                                                      ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                      Jelena Vendelin, IT - Department of Software Science
                                                                      Estonian
                                                                        ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                        2019/2020 autumn
                                                                        Aleksandr Kormiltsõn, IT - Department of Software Science
                                                                        English
                                                                          ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                          Lilia Tünts, IT - Department of Software Science
                                                                          Estonian
                                                                            ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                            Irina Amitan, IT - Department of Software Science
                                                                            Estonian
                                                                              ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                              Jelena Vendelin, IT - Department of Software Science
                                                                              English
                                                                                ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                Ahti Lohk, IT - Department of Software Science
                                                                                Estonian
                                                                                  ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                  Olga Mironova, IT - Department of Software Science
                                                                                  Estonian
                                                                                    ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                    Anna Grund, IT - Department of Software Science
                                                                                    Estonian
                                                                                      ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                      Riina Reinumägi, ET - Tartu College
                                                                                      Estonian
                                                                                        ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                        2018/2019 spring
                                                                                        Anna Grund, IT - Department of Software Science
                                                                                        Estonian
                                                                                          ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                          Irina Amitan, IT - Department of Software Science
                                                                                          Estonian
                                                                                            ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                            Lilia Tünts, IT - Department of Software Science
                                                                                            Estonian
                                                                                              ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                              2018/2019 autumn
                                                                                              Jelena Vendelin, IT - Department of Software Science
                                                                                              English
                                                                                                ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                Irina Amitan, IT - Department of Software Science
                                                                                                Estonian
                                                                                                  ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                  Ahti Lohk, IT - Department of Software Science
                                                                                                  Estonian
                                                                                                    ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                    Olga Mironova, IT - Department of Software Science
                                                                                                    Estonian
                                                                                                      ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                      Riina Reinumägi, ET - Tartu College
                                                                                                      Estonian
                                                                                                        ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                        2017/2018 spring
                                                                                                        Irina Amitan, IT - Department of Software Science
                                                                                                        Estonian
                                                                                                          ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                          Kersti Antoi, IT - Department of Software Science
                                                                                                          Estonian
                                                                                                            ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                            Olga Mironova, IT - Department of Software Science
                                                                                                            Estonian
                                                                                                              ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                              2017/2018 autumn
                                                                                                              Riina Reinumägi, ET - Tartu College
                                                                                                              Estonian
                                                                                                                ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                                Irina Amitan, IT - Department of Software Science
                                                                                                                Estonian
                                                                                                                  ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                                  Olga Mironova, IT - Department of Software Science
                                                                                                                  Estonian
                                                                                                                    ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                                    Msury Rogasian Mahunnah, IT - Department of Software Science
                                                                                                                    English
                                                                                                                      ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                                      Jelena Vendelin, IT - Department of Software Science
                                                                                                                      Estonian
                                                                                                                        ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                                        Kersti Antoi, IT - Department of Software Science
                                                                                                                        Estonian
                                                                                                                          ASSESSMENT METHOD_DigitalLiteracy1_IDK0043.pdf 
                                                                                                                          Course description in Estonian
                                                                                                                          Course description in English