Vijesti

2010 / Computer Science II

Computer Science II

25.11.2010

STUDY: Motor Vehicle Maintenance

Course: Computer Science II

 

Semester:

Lectures + Exercises:

Total:

ECTS Credits:

Elective

2

1

45

3

Course Objective: Gaining knowledge of using applications needed for the performance of complex calculations and work with databases.

Course Contents: Calculation table in MS Excel: organisation of data storage. Navigating through the table and worksheets. Worksheet editing. Types of data. Data input, editing and deleting. Basic arithmetic operations and input of formulas. Work with columns, rows and cell ranges. Linear and ascending lists. Graphical data presentation and graph editing. Setting formulas and eliminating errors at their calculation. Function types. Work with data lists. Calculation analysis and data summing in a central table. Databases in MS Access: basic objects and organisation of data. Data types. Drawing and updating a data table. Making forms, queries and reports. Index and key setting. Establishing a connection between tables.

General and Specific Competencies (Knowledge and Skills): Gaining knowledge and skills needed to work with the applications for performing calculations and with databases.

Skip to content