TTK University of Applied Sciences
Login

Curriculum subject

Data Processing

Subject
Subject code RKE094
Subject name Data Processing
Credit points 3 ECTS
Grading method Grade prelim
Curriculum subject
Curriculum 2014 RG
Study year 1
Semester Spring semester
Subject type Optional
Subject loads
Practice 32
General description
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.
General aim
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.
Aim
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
Form description
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.
Literature
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).
Evaluation methods
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.
Replacement Subjects
TRT465 Informatics AO3 - AO7
RKE010 Informatics
RKE120 Data Processing
Current rounds
Data Processing AE11/21
Data Processing HE11/21
Data Processing KAE11/21
Data Processing KHE11/21
Data Processing KK11/21
Data Processing KRG11/21
Data Processing KTE11/21
Data Processing TE11/21
eten