Section outline

  • 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!

  • Topic 1

    LECTURE 1

    Architecture of PC

    Short summary:pc

    - computer characteristic, term "personal computer", Von Neumann computer scheme, microcomputer, microprocessor - short history development

    - architecture of personal computers - motherboard, buses, BIOS, processor, computer memory, peripherals,

    - basic conceptions of processors, microprocessor communication with the outside, PC interface, computer memory, input-output devices,

    - software and it's classification.

     

    EXERCISE 1

    Initial exercise - familiarize students with the contents of the subject, credit conditions, continuous tests, form of exam, orientation on the school web pages, operation system Windows.

  • Topic 2

    LECTURE 2

    Numeral systems

    Short summary:

    - base of numeral systems,

    - binary, octal and hexadecimal numeral system,

    - arithmetic operations in numeral systems.

     

    EXERCISE 2

    Numeral systems - examples.

  • 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.

  • 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.

  • Topic 5

    LECTURE 5

    MS Word

     

    EXERCISE 5

    Word tasks 3 - mailings, labels, document completition.

  • 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.

  • Topic 7

    LECTURE 9

    Excel

    Short summary:

    - formulas and functions,

    - charts,

    - sorting, filtering, subtotals.

    EXERCISE 9

     Excel 1 - functions and formulas, charts

  • Topic 8

    LECTURE 7

    Computers and health

    Short summary:

    - musculoskeletal problems,

    - eye strain and a greater awareness of existing eye   problems

     

    EXERCISE 7

  • Topic 9

    LECTURE 8

    Computers and law

    Short summary:

    - internet fraud,

    - cybercrime,

    - computer crimes.

     

    EXERCISE 8

    1. TEST - WORD

    POWERPOINT

  • Topic 10

    LECTURE 10

    Computer networks

    Short summary:

    - network definiton,

    - network types,

    - internet, intranet, extranet

     

    EXERCISE 10

    MS Excel 2010 - charts

  • Topic 11

    LECTURE 11

    Computer infiltrations

    Short summary:

    - definition of infiltration,

    - viruses, trojans, worms

    - hoaxes, spams.

     

    EXERCISE 11

    MS Excel 2010 - sorting, filtering, subtotals.

  • Topic 13

    LECTURE 13 
    First term of exam


    EXERCISE     13     
    Test evaluation, credits.