Subject 'Data Processing'

Year:   2012/2013    2013/2014    2014/2015    2015/2016    2016/2017    

The main concepts of information tecnology.
The main principles of designing presentations. Creating presentations. Inserting and changing various objects. Slide master. Links. Animations.
Text processing and reference system according to the TCE instruction for written papers. Creating and editing documents. Text structuration. Adding objects to text. Formula redactor MS Eqution. Footers and headers. Creating the table of contents. Tracking changes.
Working with tables. Typical structure of a table. Using formulas and functions in tables: inserting and copying of formulas and functions, aadresses and names. Data types and formats. Formatting tables. Sorting, filtering. Creating, editing and formation of diagrams. Printout adjustment.

The objective of the course is to provide knowledge and skills for coping in the world that relies more and more on information technology. The course creates conditions to successfully use MS Office in one's studies.

After completing the course, the student:
* knows and understands the principles and main terms of information technology;
* can work with a presentation software and create and design presentations;
* can work with a word processor and compile text documents needed for work;
* can work with a spreadsheet application, analyze data and present the results graphically
* can use computers for obtaining, processing and storing information

Classroom work - lectures, practical work classes
Practical work class consist of solving exercises.
Every student has to write independently a paper coherent to the requirement of TCE
Prelim.

1. Reinumägi, R. (2011) Esitluse loomine PowerPoint 2007-2010 abil. Käsiraamat.Tartu: Binari Pro, 96 lk.
2. Reinumägi, R. (2011). Excel 2007-2010 tavakasutajale. Käsiraamat. Tartu: Binari Pro, 134 lk.
3. Reinumägi, R. (2014). Excel 2010-2013 tavakasutajale. Käsiraamat. Tartu: Binari Pro, 147 lk.
4. Reinumägi, R. (2012). Excel 2007-2010 valemid ja funktsioonid. Tartu: Binari Pro, 166 lk.
5. Reinumägi, R. (2010). Tekstidokumendi loomine ja kujundamine Word 2007-2010 abil. Käsiraamat. Tartu: Binari Pro, 160 lk.
6. Tilk, T. (2010). Arvutikursus Windows 7. Kuressaare: T. Tilk, 160 lk.
Materials chosen and put together by the lecturer (partially available on internet).

The course ends with a final grade, summarizing the previous graded tasks.
The paper - coherence to the requirements of TCE, skills of using the right settings for editing texts in word processor, creating a correct and easily editable document.
The test - solving exercises on data processing by using spreadsheet application.
The presentation.

2020: AE*  ET*  HE  KK  KT  LK  ME*  RG  RO*  TE  

2019: AT*  ET*  HE  KK  KT  LK  ME*  RG  RO*  TE  TL  

2018: AT  ET  HE  KK  KT  LK  ME  RG  RO*  TE  TK  TL  

2017: AT  ET  HE  KK  KT*  ME  RG  TE  TK  TL  TT  

2016: AT  ET  HE  KT*  ME  RG  TE  TK  TL  TT  

2015: AT  ET  HE  KT*  ME  RG  TE  TL  TT  

2014: AT  ET  HE  KT*  ME  RA*  RG*  TE  TL  TT  

2013: AT  ET  HE  KT*  ME  RA*  RG*  TE  TL  TT  

2012: AT  EI*  ET  GI*  KT*  LI  MI  RA*  RR  TD  TEI  TI  

2011: AT  EI*  GI*  KT*  LI  MI  RA*  RR  RT*  TD  TEI*  TI  

2010: AT  EI*  GI*  KT*  LI  MI  RA*  RR  TD  TEI*  TI  

2009: AT  EI*  GI*  KT*  LI  MI  RA*  RR  TD  TEI*  TI  

* Optional subject