Subject 'Data Processing'

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

The main concepts of information tecnology.
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 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.Amitan, J. Vilipõld MS Excel rakenduste loomise põhielemendid. Tallinn. TTÜ 2001.
2.V. Jokk Dokumentide Disain töökeskkonnas MS Word.Tallinn. TTÜ,2003.
3.M. Langer Excel 2000 Windows. Tallinn: Kirjastus KOGE, 2000.
4.M. Langer Word 2000 Windows. Tallinn: Kirjastus KOGE, 2000.
5.J. Pihlau Internet 2000. Tallinn "Külm" 2000.
6.T.Tilk Arvutikursus algajale Windows XP. Kuressaare. Tallinna Raamatutrükikoda, 2008.
7.T.Tilk Arvutiõpik I, II. Kuressaare. Tallinna Raamatutrükikoda, 1999/2000.
8.T. Tilk Arvutiõpik MS Office.Kuressaare. Tallinna Raamatutrükikoda, 2005.
9.J.Walkenbach, C. Banfield Excel 2003 võhikule. Alg- ja kesktase. Tõlge Kirjastuse OÜ. 2005 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.

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