Navigation

Subject description

1427045 - Informaticki praktikum 3

Course specification
Course title
Acronym 1427045
Study programme
Module
Type of study
Lecturer (for classes)
Lecturer/Associate (for practice)
    Lecturer/Associate (for OTC)
      ESPB 3.0 Status
      Condition Oblik uslovljenosti
      The goal The goal of the course is mastering in practice the basic principles of programming and the possibility of applying that knowledge to use the full possibilities of creating documents with the Microsoft Office program package - Word and Excel. These abilities are useful in any work environment, but especially for the IT librarian whose task is to create a large number of diverse documents.
      The outcome The student is capable of independently compiling programs for solving simple tasks in the VBA programming language that can be included in documents created with the Microsoft Office software package - Word and Excel.
      Contents
      Contents of lectures A brief overview of basic concepts in programming. History of programming - machine instructions and processor programming, assembly and higher programming languages, compilers. Program development cycle: program writing, compilation, debugging, execution. VBA interpreter and macros in Microsoft Office programs. Working with the VBA editor in Microsoft Office programs. Forms. Introduction to object-oriented programming - event processing. Word and VBA: object model for Word (basic classes, properties and methods), conditional statements, collections and loops, modular programming, user data types (classes), working with files and catalogs (processing multiple documents simultaneously). Excel and VBA: object model (basic classes, properties and methods), working with strings, sorting and binary search. Word, Excel and VBA: Customizing the existing user interface.
      Contents of exercises
      Literature
      1. Paul McPhedries, Absolute Beginner's Guide to VBA, Computer Library, Čačak, 2005.
      2. Excel 2003 Programming in VBA - no secrets, Computer Library, Čačak, 2004.
      3. Writing VBA procedures for functions and subprograms in Excel, Faculty of Organizational Sciences, Belgrade, 2005.
      4. Miloš Utvić, material on the web: http://arhimed.matf.bg.ac.rs/~misko/flf/prog/prog.html
      Number of hours per week during the semester/trimester/year
      Lectures Exercises OTC Study and Research Other classes
      1 3
      Methods of teaching interactive-communicative, interactive (practical work at the computer)
      Knowledge score (maximum points 100)
      Pre obligations Points Final exam Points
      Activites during lectures 5 Test paper 55
      Practical lessons Oral examination
      Projects
      Colloquia 40
      Seminars