Computer data processing

Section outline

• Select section Basic information

  Collapse Expand

  Basic information

  Collapse all Expand all

  COMPUTER DATA PROCESSING

  Aim of the subject
  

  The goal of the subject is to gain theoretical knowledge and practical skills of working in MS Windows and with applications of MS Office. After completing the course you will be able to work actively with texts, tables, charts, lists and presentations. Acquired knowledge will be useful in other subjects (writing seminar works, bachelor and diploma thesis...).

  Credit conditions:

  • successful completion of two tests,
  • seminar work: presentation created in MS PowerPoint (10-12) slides - any theme from field of Information and communication technologies - submitted in electronic form.

  Course coordinator:
  Ing. Roderik Virágh, PhD.
  
  Lecturer:
  Ing. Roderik Virágh, PhD.
  
  

  Good luck in study!

  • Select activity Syllabus CDP

    

    Syllabus CDP File
  • Select activity Oznámenia

    

    Oznámenia Forum
  • Select activity Computer Data Processing - basic information WS 25/26

    

    Computer Data Processing - basic information WS 25/26 File PDF

    210.2 KB
• Select section Topic 3

  Collapse Expand

  Topic 3

  LECTURE 3
  

  Text editors

  Short summary:

  - short history of text editors,

  - national environment and text editors,

  - functions of text editors,

  - computer typography,

  - MS Word 2010

   

  EXERCISE 3

  Word tasks - fonts and symbols, paragraph formatting, bulletins and numbering, input objects, columns.

  • Select activity Lecture 3 - Text editors

    

    Lecture 3 - Text editors File
  • Select activity Tasks 1

    

    Tasks 1 File
  • Select activity Fonts and symbols

    

    Fonts and symbols File
  • Select activity Paragraph formatting

    

    Paragraph formatting File
  • Select activity Bulletins and numbering

    

    Bulletins and numbering File
• Select section Topic 4

  Collapse Expand

  Topic 4

  LECTURE 4

  MS Word

   

  EXERCISE 4

  Word tasks 2 - tab stops, tables, header and footer, styles, table of contents, index, citations and bibliography. Text for repetition.
  

  • Select activity Tasks 2

    

    Tasks 2 File
  • Select activity Objects, columns and tabs

    

    Objects, columns and tabs File
  • Select activity Edited text_repetition

    

    Edited text_repetition File
  • Select activity Not edited text_repetition

    

    Not edited text_repetition File
  • Select activity Addresses

    

    Addresses File
• Select section Topic 5

  Collapse Expand

  Topic 5

  LECTURE 5

  MS Word

   

  EXERCISE 5

  Word tasks 3 - mailings, labels, document completition.
  

  • Select activity Tasks 3

    

    Tasks 3 File
  • Select activity Article for tasks 3

    

    Article for tasks 3 File
  • Select activity Repetition_tasks

    

    Repetition_tasks File
  • Select activity Repetition_text

    

    Repetition_text File
• Select section Topic 6

  Collapse Expand

  Topic 6

  LECTURE 6

  Presentations

  - key points of presentations
  

  - structure of the presentation
  

  - presentations in Prezi
  

   

  EXERCISE 6

  Repetition of MS Word. Preparation for the test.

  • Select activity Presentations - theory

    

    Presentations - theory File
• Select section Topic 7

  Collapse Expand

  Topic 7

  LECTURE 9

  Excel

  Short summary:

  - formulas and functions,

  - charts,
  

  - sorting, filtering, subtotals.
  

  EXERCISE 9

   Excel 1 - functions and formulas, charts
  

  • Select activity Lecture 9 - Excel 1

    

    Lecture 9 - Excel 1 File
  • Select activity Lecture 9 - Excel 2

    

    Lecture 9 - Excel 2 File
  • Select activity Excel 1

    

    Excel 1 File
  • Select activity Task 1 Excel - results

    

    Task 1 Excel - results File
  • Select activity Excel basics

    

    Excel basics File
• Select section Topic 8

  Collapse Expand

  Topic 8

  LECTURE 7

  Computers and health

  Short summary:

  - musculoskeletal problems,

  - eye strain and a greater awareness of existing eye   problems

   

  EXERCISE 7

  • Select activity Lecture 7 - Computers and health

    

    Lecture 7 - Computers and health File
• Select section Topic 10

  Collapse Expand

  Topic 10

  LECTURE 10

  Computer networks

  Short summary:

  - network definiton,

  - network types,
  

  - internet, intranet, extranet
  

   

  EXERCISE 10

  MS Excel 2010 - charts

  • Select activity Computer networks

    

    Computer networks File
  • Select activity Excel 2

    

    Excel 2 File
  • Select activity Tasks 2 Excel - results

    

    Tasks 2 Excel - results File
  • Select activity Excel 4

    

    Excel 4 File
• Select section Topic 11

  Collapse Expand

  Topic 11

  LECTURE 11

  Computer infiltrations

  Short summary:

  - definition of infiltration,
  

  - viruses, trojans, worms
  

  - hoaxes, spams.
  

   

  EXERCISE 11

  MS Excel 2010 - sorting, filtering, subtotals.

  • Select activity Infiltrations

    

    Infiltrations File
  • Select activity Excel 3

    

    Excel 3 File
  • Select activity Task 3 Excel_ results

    

    Task 3 Excel_ results File
  • Select activity Excel 4

    

    Excel 4 File