• To provide students with knowledge about creating programs with Microsoft Office programs (Excel, Power Point, Word, Outlook), preparing presentations, writing in electronic environment, and mastering the e-mail culture.
• To inform students about how they can benefit from computers, spreadsheet software, word processing software, and presentation preparation software in school and business life.
• To touch on the development of computers, computer networks, information processing, CPU, memory, computer input/output and storage devices, software, operating systems, word processing programs.
Prerequisite(s)
None
Corequisite(s)
None
Special Requisite(s)
- Entry level computer usage qualification
- Entry level English
Instructor(s)
Assist. Prof. Dr. Nezriye Gözde Bircan
Course Assistant(s)
Schedule
*Theory - Tuesday, 14:00-15:50, LAB-1, Basın Ekspres Campus
*Practice - Thursday, 15.00:16.50, LAB-1, Basın Ekspres Campus
Office Hour(s)
Wednesday, 10:00-11:00, B8-06, Basın Ekspres Campus
Teaching Methods and Techniques
- Theoretical Teaching in classroom
- Applications by using computers in laboratory
- Real business problems are created and solved by using computer
- Compulsory homeworks from lecture notes
Principle Sources
- Bilgisayar Kurs Kitabı, Arkadaş Yayınları, 2.BASKI
Other Sources
- Lecture Notes prepared by instructor
Course Schedules
Week
Contents
Learning Methods
1. Week
Interface-Sheet-Row-Cell
Formatting
Key Features
Table Structures
Oral presentation, Laboratory
2. Week
"Sort and Filter
Data Tools
Pivot Tables"
Oral presentation, Laboratory
3. Week
"Graphs
• Line Charts
• Pie Charts
• Column - Bar Charts
• Combo Charts"
Oral presentation, Laboratory
4. Week
"Introduction to Formulas
Functions
• SUM,AVERAGE,MIN,MAX
• IF,VLOOKUP,INDEX,MATCH"
Oral presentation, Laboratory
5. Week
Power Query 1
Oral presentation, Laboratory
6. Week
Power Query 2
Oral presentation, Laboratory
7. Week
Dashboard Development
Oral presentation, Laboratory
8. Week
Programming with Excel 1
Oral presentation, Laboratory
9. Week
Programming with Excel 2
Oral presentation, Laboratory
10. Week
Programming with Excel 3
Oral presentation, Laboratory
11. Week
Creating Slides
Oral presentation, Laboratory
12. Week
Advanced Slide Techniques
Oral presentation, Laboratory
13. Week
Learning MS Word
Oral presentation, Laboratory
14. Week
Mail Management with Outlook
Oral presentation, Laboratory
15. Week
Final Exam
Exam
16. Week
Final Exam
Exam
17. Week
Final Exam
Exam
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
20
Quizzes
1
20
Homework / Term Projects / Presentations
1
0
Attendance / Participation
1
0
Final Exam
1
60
Program Outcomes
PO-1
Demonstrates a basic level of understanding in related disciplines (such as economics, sociology, psychology, quantitative sciences, etc.) that form a foundation for business administration, and makes use of and applies them to the field of business.
PO-2
Applies mathematical, scientific and social knowledge to business problems.
PO-3
Demonstrates a basic level of understanding in business functions and management (such as management, production, marketing, accounting, finance, human resources, behavioural sciences, etc.) and interprets the theoretical arguments focusing on interactions between the actors and the cultures in the field.
PO-4
Determines how to use acquired theoretical and practical knowledge and skills related to business in application and field analysis and applies them.
PO-5
Identifies and evaluates the relations in the field of business; describes the problems and presents analytical solutions through modelling and interpreting (critical thinking).
PO-6
Designs a business process in any functional stage that complies with identified objectives.
PO-7
Develops effective business communication skills (written-verbal/formal-informal).
PO-8
Owns effective working skills individually or on a team in business and multidisciplinary fields.
PO-9
Acts with a sense of professional and ethical responsibility.
PO-10
Improves effective verbal and written communication skills in English, and acquires competence in minimum one foreign language.
Learning Outcomes
LO-1
- To recognize basic hardware components of a computer and describe their functionallity
LO-2
- To be able to describe the difference between application softwares and system softwares
LO-3
- To describe Central Processing Unit (CPU) and computer Input/Output
LO-4
- To get general information about computer files, data storage, computer network, internet, software license, viruses, computer and healt
LO-5
- To be able to explain the importance of MS Office tools for academic and business life
LO-6
- To be able to use MS Word word processing tool for drawing objects, writing, formatting and creating tables.
LO-7
- To be able to have ability to use MS PowerPoint tool for creating and modifiying presentaions
