Computer Tools For Politics and Governance
Political Science and Public Administration
Faculty of Political Sciences
First Cycle (Bachelor's Degree)
| Course Unit Title | Course Unit Code | Type of Course Unit | Level of Course Unit | Year of Study | Semester | ECTS Credits |
|---|---|---|---|---|---|---|
| Computer Tools For Politics and Governance | SBK232 | Elective | Bachelor's degree | 2 | Spring | 4 |
Name of Lecturer(s)
Assistant Prof. Dr. Cihan Necmi GÜNAL
Learning Outcomes of the Course Unit
1) Demonstrates proficiency in utilizing Microsoft Word to make and format docs relevant to political science and public administration.
2) Applies advanced features of Microsoft Excel to efficiently manage and analyze data sets commonly encountered in governance contexts.
3) Develops the ability to design and implement complex formulas and functions in Excel to perform calculations.
4) Constructs visually compelling charts, graphs, and tabs in Excel to effectively communicate key findings and trends, facilitating informed decision-making and policy analysis.
5) Classifies information and reorganizes findings with clarity and professionalism using the integration of Word and Excel functionalities.
Program Competencies-Learning Outcomes Relation
| Program Competencies | |||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||
| Learning Outcomes | |||||||||
| 1 | No relation | No relation | Middle | No relation | No relation | No relation | No relation | No relation | |
| 2 | Middle | No relation | No relation | High | No relation | No relation | No relation | Middle | |
| 3 | No relation | No relation | High | No relation | No relation | No relation | No relation | No relation | |
| 4 | No relation | No relation | No relation | No relation | No relation | High | No relation | No relation | |
| 5 | No relation | No relation | No relation | No relation | No relation | No relation | No relation | High | |
Mode of Delivery
Face to Face
Prerequisites and Co-Requisites
None
Recommended Optional Programme Components
Basic Readings in Social Sciences 1-2
Course Contents
This course will cover fundamental concepts and practical techniques in Microsoft Word and Excel, including doc formatting, data entry and analysis, formula creation, charting, and effective presentation methods, tailored specifically for students in political science and public administration to enhance their administrative and analytical skills.
Weekly Schedule
1) Introduction to Microsoft Word2) Doc formatting: fonts, styles, headings, and paragraph formatting
3) Creating and formatting docs relevant to governance contexts
4) Advanced Word Features
5) Working with tabs and lists
6) Collaborative editing and doc sharing techniques
7) Managing references and citations using Word's built-in tools
8) Midterm Exam
9) Introduction to Microsoft Excel
10) Data entry and manipulation: entering data, sorting, filtering, and basic functions
11) Cell formatting and conditional formatting
12) Advanced Excel Functions
13) Working with ranges and named ranges
14) Data validation and protection techniques
15) PivotTabs and PivotCharts: creating, customizing, and analyzing data
16) Final Exam
Recommended or Required Reading
1- Microsoft Excel 2019 Step by Step" by Curtis Frye
2- Microsoft Word 2019 Step by Step" by Joan Lambert and Curtis Frye
Planned Learning Activities and Teaching Methods
1) Lecture
2) Question-Answer
3) Discussion
4) Drill and Practice
5) Demonstration
6) Case Study
7) Lab / Workshop
Assessment Methods and Criteria
Contribution of Midterm Examination to Course Grade |
30% |
|---|---|
Contribution of Final Examination to Course Grade |
70% |
Total |
100% |
Language of Instruction
English
Work Placement(s)
Not Required