Computer application

NAME OF THE COURSE Computer application

Code

KTA113

Year of study

1.

Course teacher

Assoc Prof Dražan Jozić

Credits (ECTS)

4.0

Associate teachers

Type of instruction (number of hours)

P S V T

30

0

15

0

Status of the course

Mandatory

Percentage of application of e-learning

0 %

COURSE DESCRIPTION

Course objectives

Acquiring a basic knowledge of computers and computer systems. Knowledge about the use of Internet content and protect your computer from malicious programs. Basic skills about the content management (folders and files) on PCs using the Windows operating system. Basic skills using programs offered in the MS Office software.

Course enrolment requirements and entry competences required for the course

 

Learning outcomes expected at the level of the course (4 to 10 learning outcomes)

After passing the exam the student will be able to:
1. Manage content on PC computer (files and folders)
2. Use the MS Word in the purpose of the editing the file according to the specified requirements (defining the shape and page layout, inserting the images, finished elements, tables, graphs ...)
3. Use the MS Excel for analysis, calculation, sorting, graphical presentation and format tables.
4. Use the MS PowerPoint to create presentations
5. Set up and use MS Outlook for editing and emailing
6. Find reliable sources of information on the Internet

Course content broken down in detail by weekly class schedule (syllabus)

1. Week L General information about the course and mode of examination, Introduction to computers application, Information activity and technology, Computerization, Computer applications in Chemistry and Chemical Engineering
E
2. Week L Hardware (PC), Von Neumann’s model computers, Computer hardware, Computer types, Basic terms in the Computer Engineering and informatics, Basic parts (components) of the PC, Central processing unit (CPU), Computer memory, Motherboards and connectors, Input and Output devices
E
3. Week L Operating systems and applications, The BIOS (Basic Input / Output System), Preparing disks and drives for installation of the OS, File system (FAT, NTFS), Computer Programs, System programs, Application programs, Operating systems
E
4. Week L Basics commands for MS-DOS, GUI (Graphical User Interface), Properties GUI, History of developing the MS Windows OS, Example Installations operating systems (Windows OS), Customizing the User Interface, Library, Customize settings on PC computer, Firewall, Windows Defender, Windows Update, Action Center, Commercial antivirus programs
E
5. Week L Backup and Restore, Control Panel, Customize the computer, The Device Manager, Accounts, Network and Sharing Center, Troubleshooting, Personalization, BitLocker Drive Encryption, Region and Language, Programs and Features, Installing and uninstalling programs, Display, Devices and Printers, Default Programs, Help and Support, Accessories and system tools, Shortcuts in Window OS, Changing the language of Windows OS
E
6. Week L Malicious software (malware), Computer viruses, Computer worms, Trojan horses, Logic bombs, Spyware, Advertising Programs (Adware), INTERNET, History of the Internet, TCP / IP protocol
E
7. Week L First test
E
8. Week L Internet, Computer network and classification networks, Internet protocols: HTTP, HTTPS and FTP, Web browsers, Copyright Law
E
9. Week L MS Office, MS Word, How to start the MS Word, Layout MS Word window, The status bar, Tabs and tools, Copy and paste data, Special characters, Styles, Tabs, Sections, Creating a new document, Copy text, Headers and footers, Page numbers
E MS Word: How to insert and edit the text and its formatting. Paragraph formatting. Lists of lists. Working with documents. formatting documents
10. Week L How to insert and edit the formulas and equations, Application of the finished style characteristics, Input tables and formatting, input images in the document, the entry of bibliographic data entry page breaks and section breaks (define different sections of the document), display the contents of the document
E MS Word: Insert pictures, tables and SmartArt elements in the document. Formatting headers and footers document. Entering references and footnotes in the document. Insert the page break, Section break, Application of different style for document
11. Week L MS Excel, How to start MS Excel, Layout MS Excel windows, Toolbar for quick access, Status bar, Tabs and tools, Tabs formulas, Editing data within a worksheet, Graphic data presentation, Input data string in the table, Add the trend data, Sorting data set
E MS Excel: Working with the tables. Entering data into tables and data formatting. Entering a series of data. Entering data from different files. Displaying data graphically.
12. Week L Conditional Formatting Data, Creating and deleting equations, Addresses cells (relative, absolute, mixed), Types of functions, Logical operators, Boolean functions, Examples of application functions (IF, AND, OR, COUNTIF ..), MS PowerPoint, MS PowerPoint Startup, The appearance of windows, tabs and tools, Creating presentations, add themes, Themes Edit, Insert object (images, tables, links, media content ...)
E MS Excel: Data processing, Calculating with tables, Input and syntax for creating mathematical equations. Showing the trend curve.
13. Week L MS Outlook, MS Outlook Startup, The appearance of windows, tabs and tools, Creating a user account , Creating a new e-mail
E MS Power Point: Creating presentations. Choosing the design, How to make redesign of an existing template.
14. Week L Databases, What databases they are?, Fields in databases, How databases are developed?, Center for online databases, Bibliographic databases, Citation databases, Databases with full-text, Sciencedirect databases, Scopus databases, Web database, Bibliography
E
15. Week L Second Test
E

Format of instruction:

Student responsibilities

Class attendance in the amount of 70% to 100%, and to experimental work of 100% from total hours.

Screening student work (name the proportion of ECTS credits for eachactivity so that the total number of ECTS credits is equal to the ECTS value of the course):

Class attendance

0.5

Research

0.0

Practical training

1.0

Experimental work

0.0

Report

0.0

 

 

Essay

0.0

Seminar essay

0.0

0.6

Tests

0.5

Oral exam

0.0

0.8

Written exam

0.6

Project

0.0

 

 

Grading and evaluating student work in class and at the final exam

The written exam can be finished over the two tests during the semester. Minimum for successful tests is the limit of the 60% resolved test. Each test in assessing participates with a share of the 15% of the final grade. Presence at lectures 70-100% participates with a share of the 5% of the final grade while the presence of the laboratory exercises from 100% participates with a share of the 15% of the final grade. Practical part of exam participates with a share of the 50% of the final grade. The examination periods there is a written and oral exam. Minimum for successful written exam is the limit of the 60% resolved test. Passing one test (previous activity) is valuable in the summer semester examination period with a share of the 20% of the final grade. Written exam has a share of the 20% and practical part of exam has a share of the 40% of the final grade. Students who have not passed any tests during the semester they take the examination through written and practical exams in the regular examination period. Minimum for successful tests the limit of the 50% resolved test. Written part of exam participates with a share of the 30% of the final grade and practical part of exam with a share of the 50% of the final grade.
The final grade: 60%-71% - sufficient, 72%-81% - good, 82%-91% very good, 92%-100% - excellent.

Required literature (available in the library and via other media)

Title

Number of copies in the library

Availability via other media

D.Jozić, Predavanja iz kolegija:Primjena računala, Kemijsko-tehnološki fakultet, Interna skripta, Split, 2013.

1

Wallace Wang, Office 2010 For Dummies, Wiley Publishing Inc., Indiana, 2010.

1

Optional literature (at the time of submission of study programme proposal)

Selected articles from journals recommended by lecturer

Quality assurance methods that ensure the acquisition of exit competences

1. Tracking suggestions and reactions of students throughout the semester
2. Student survey

Other (as the proposer wishes to add)