TR ENG

CANKIRI KARATEKIN UNIVERSITY Bologna Information System

Course Information

Course Information

Course Content

Course's Contribution to Prog.

ECTS Workload in Relation

ECTS- Workload Calculation Tool

Program Information

Mission and Vision

Program Learning Outcomes

Course Struct. & ECTS Credits

Course Catalogs

Course & Program L. Outcomes

TYYC Level Qualification

TYYC Core Area Competencies

Admission Requirements

Access to Further Studies

Qualification Awarded

Final Examination

Assessment and Grading

Head of Dept. & Coord.

Educational Staff

Görüş Bildir Print
  • Course Information
    • Course Title Code Semester Laboratory+Practice (Hour) Pool Type ECTS
    Electronic tabulation İSG239 FALL 2+0 C 2
    Learning Outcomes
    1-Implementing spreadsheet elements and software
    2-Filing, preparing and analyzing data with electronic spreadsheets
    3-Copying, moving and analyzing data
    4-Analyzing data, sorting, filtering, checking and validating
    5-Developing formulas for data manipulation, performing circular references.
  • ECTS / WORKLOAD
    • ActivityPercentage

    (100)

    		NumberTime (Hours)Total Workload (hours)
    Course Duration (Weeks x Course Hours)14228
    Classroom study (Pre-study, practice)14114
    Assignments0155
    Short-Term Exams (exam + preparation) 0000
    Midterm exams (exam + preparation)40155
    Project0000
    Laboratory 0000
    Final exam (exam + preparation) 60188
    0000
    Total Workload (hours)   60
    Total Workload (hours) / 30 (s)     2 ---- (2)
    ECTS Credit   2
  • Course Content
    • Week Topics Study Metarials
    1 Introduction to electronic spreadsheet and general concepts. R1
    2 Window elements and display formats. R1
    3 Worksheet, view creation, view adjustment, window splitting. Filing operations. R1
    4 Opening a file, changing the record type. Working with cells. R1
    5 Cell selection, row and column adjustment, naming, data entry, cell editing, cell merging, renewal, data discovery. R1
    6 Data copying and moving. Worksheet settings, pre-printing rows and columns. R1
    7 Formatting operations, borders, patterning, formatting, conditional formatting. R1
    8 Add operations, add parent and child insert, page number, time, date. R1
    9 Adding graphics, images, objects and linking between pages. R1
    10 Create menus, add icons, assign commands on toolbars. R1
    11 Data analysis. Data sorting, filtering, checking, validation, data form creation, summary table creation. R1
    12 Formulas, using circular reference, conditional formulas. R1
    13 Formulas, using mathematical formulas, text formulas, date and time formulas. R1
    14 Do not use tools. Creating protection, sharing a workbook, creating a macro. Applications. R1
    Prerequisites -
    Language of Instruction Turkish
    Responsible Lecturer Fahri OLUK
    Instructors -
    Assistants
    Resources K1. Bal, H. Ç., Bilgisayar ve İnternet Kullanımı, Murathan Yayın Evi, 2012, 416 sayfa.
    Supplementary Book K3. AICHE, Guidelines for Chimical Transportation Safety, Security and Risk Management, 2 nd Ed. 2008.
    Goals To be able to process, analyze and conclude OHS data with electronic spreadsheet studies. To be able to handle quantitative data of occupational accidents and occupational diseases. To be able to draw conclusions from OHS data.
    Content Introduction to electronic spreadsheet and general concepts. Window elements and display formats. Worksheet, view creation, view adjustment, window splitting. Filing operations. Opening a file, changing the record type. Working with cells. Cell selection, row and column adjustment, naming, data entry, cell editing, cell merging, renewal, data discovery. Data copying and moving. Worksheet settings, pre-printing rows and columns. Formatting operations, borders, patterning, formatting, conditional formatting. Add operations, add parent and child insert, page number, time, date. Adding graphics, images, objects and linking between pages. Create menus, add icons, assign commands on toolbars. Data analysis. Data sorting, filtering, checking, validation, data form creation, summary table creation. Formulas, using circular reference, conditional formulas, mathematical formulas, text formulas, date and time formulas. Do not use tools. Creating protection, sharing a workbook, creating a macro. Applications.
  • Program Learning Outcomes
    • Program Learning Outcomes Level of Contribution
    1

    To have the ability to identify and evaluate the occupational risks that may occur in the working environment by analyzing the production processes.     		-
    2

    Developing the ability to work with team spirit.     		-
    3

    At least one foreign language at the general level of the European language portfolio A2, following the knowledge of the field and communicating with colleagues.     		-
    4

    Using information and communication Technologies together with computer software at minimum European computer license basic level required by the field.     		4
    5

    Gaining legal and Professional reasoning skills about occupational health and safety.     		-
    6

    To recognize occupational safety materials, warning and danger signs and paltes, to have information about their properties and to have the competence to use them for their intended purpose.     		-
    7

    To have the ability to plan and implement occupational safety trainings.     		2
    8

    Gaining the ability to communicate with society.     		-
    9

    To have sufficient knowledge about measurement techniques and methods for occupational safety and health.     		-
    10

    To have information about the basic measures to be taken in order to protect the health of workers and prevent occupational diseases that may ocur.     		-
    11

    Gaining the ability to work in a team, have the self confidence to take responsibility, to take authority and to fulfill the requirements.     		2
    12

    To be able to organize the periodical controls related to occupational health and safety.     		-
    13

    To carry out recording and reporting activities.     		4
    14

    To be able to provide specific information fort he sectors.     		-
    15

    Having legislation knowledge at technician level in the field of occupational health and safety.     		-
    Çankırı Karatekin Üniversitesi  Bilgi İşlem Daire Başkanlığı  @   2017 - Webmaster