Associate Degree Programs
Vocational School of Technical Sciences
Computer Programming
Anlık RSS Bilgilendirmesi İçin Tıklayınız.Düzenli bilgilendirme E-Postaları almak için listemize kaydolabilirsiniz.


Introduction to Computer II

Course CodeSemester Course Name LE/RC/LA Course Type Language of Instruction ECTS
BİL2001 2 Introduction to Computer II 4/0/0 CC Turkish 4
Course Goals

Students will learn how the computers are used in business graphics program and the most important features of excel processing and access. 

Prerequisite(s) None
Corequisite(s) None
Special Requisite(s) None
Instructor(s) Lecturer Erdem Yücesan
Course Assistant(s) None
Schedule Distance Education
Office Hour(s) CATS Meetings
Teaching Methods and Techniques

Lecture, Application.


Applications by using computers.

Problems are created and solved by using computer.

Compulsory homeworks from lecture notes.

Principle Sources Office, ingilizce sürüm, N.Tekin, M.Tekin, İstanbul Kültür Üniversitesi, 2011.
Other Sources

Microsoft Office Professional 2010 Step by Step (Step by Step (Microsoft)) by Joan Lambert III, Joyce Cox and Curtis Frye D. (Sep 10, 2010)

 

Microsoft Word 2010 Step by Step (Step By Step (Microsoft)) by Joyce Cox and Joan Lambert III (Jun 23, 2010)

 

Bilgisayara Giriş, Faruk Çubukçu, Gama Basım Yayım Dağıtım, Yayın Yılı: 2011; 726sayfa.

 

Windows 7 ve Ms Office 2010, Hayrettin Üçüncü, Alfa Yayınları, İstanbul, 2011.

Bilgisayara Giriş, Faruk Çubukçu, Gama Basım Yayım Dağıtım, Yayın Yılı: 2011; 726sayfa.

 

Teach Yourself VISUALLY Office 2013 (Teach Yourself VISUALLY (Tech)) by Elaine Marmel (Mar 18, 2013)

 

Introduction to Computers (Shelley Cashman Series) by Gary B. Shelly, Steven M. Freund and Misty E. Vermaat (Jun 18, 2010)

Course Schedules
Week Contents Learning Methods
1. Week Introduction to Microsoft Excel. Tables, insert function; sum, average, charts. Lectures and application, Oral Presentation.
2. Week Functions; Count, Max, Min, Countif, if. Lectures and application, Oral Presentation.
3. Week PivotChart. Lectures and application, Oral Presentation.
4. Week Form controls; Group Box, Option Button, combo box, spin button. Lectures and application, Oral Presentation.
5. Week Contitional formating, Data Validation, $ operator. Lectures and application, Oral Presentation.
6. Week Insert Function, Forecast, Date, Today, Time, Int, Round, Pmt, Product, Rand, RandBetween functions. Lectures and application, Oral Presentation.
7. Week Matrix operations, Equation solutions Lectures and application, Oral Presentation.
8. Week Midterm Week
9. Week Sheet, conditional formating, data filter. Lectures and application, Oral Presentation.
10. Week SQL server, Access, Visual Basic applications, macro, loop. Lectures and application, Oral Presentation.
11. Week Now, Option, Vlookup, Hlookup, Combo Box and applications. Lectures and application, Oral Presentation.
12. Week Access database. Objects, table, Form ve Report. Lectures and application, Oral Presentation.
13. Week Creating a data base. OLE Object, Text Object, Report. Queries. Lectures and application, Oral Presentation.
14. Week Work with multiple tables, queries, and create tables and Access application. Lectures and application, Oral Presentation.
15. Week
16. Week
17. Week
Assessments
Evaluation tools Quantity Weight(%)
Midterm(s) 1 20
Final Exam 1 80


Program Outcomes
PO-1Ability to define, collect, and evaluate necessary data in the field of computer programming and effectively apply theoretical knowledge in practical applications..
PO-2Possession of fundamental knowledge of computer systems, software, and hardware, and the ability to effectively utilize the required technologies for the profession.
PO-3Possession of up-to-date, fundamental, and applied knowledge related to computer programming.
PO-4Awareness of occupational health and safety, environmental consciousness, and quality processes, and the ability to apply them in the workplace.
PO-5Ability to follow developments in information technologies and integrate innovations into the profession.
PO-6Effectively using information technologies related to the profession (software, programs, animations, etc.).
PO-7Acquiring the analytical thinking skills required by computer programming, developing and executing programs with an appropriate perspective.
PO-8Independently evaluating professional problems and issues with an analytical and critical approach and presenting solutions.
PO-9Effectively expressing the work conducted in the field to project teams and institutions.
PO-10Taking responsibility in the workplace, organizing employees and workflow, and providing services in accordance with quality and standards.
PO-11Effectively presenting thoughts at the level of knowledge and skills through written and verbal communication in a clear and understandable manner.
PO-12Valuing teamwork, contributing to the group, and collaborating effectively with colleagues.
PO-13Ability to adapt to next-generation technologies such as artificial intelligence, big data analytics, cybersecurity, and cloud computing, and to acquire fundamental knowledge and skills in these areas.
PO-14Being aware of career management and lifelong learning, following technological advancements, and continuously improving oneself.
PO-15Possessing social, scientific, cultural, and ethical values in the collection, implementation, and dissemination of field-related data.
PO-16Possession of foreign language skills sufficient to follow developments in the field and communicate at an international level.
PO-17Emphasizing effective communication in the field and using the Turkish language accurately.
PO-18Ability to adopt and promote workplace safety, health, and environmental awareness.
PO-19Ability to objectively evaluate the performance of team members and provide accurate information to management.
Learning Outcomes
LO-1To be able to use MS excel processing tool for drawing objects, writing, formatting and creating tables.
LO-2To be able to produce graphs on MS Excel software
LO-3To be able to have ability to use MS PowerPoint tool and MS PowerPoint tool for creating and modifiying presentaions.
LO-4Excel; file, home, insert, page layout, formulas, data, review, developer ve view tabs, operations, functions, form controls.
LO-5Work with multiple tables, queries, and create tables and Access application.
Course Assessment Matrix:
Program Outcomes - Learning Outcomes Matrix
 PO 1PO 2PO 3PO 4PO 5PO 6PO 7PO 8PO 9PO 10PO 11PO 12PO 13PO 14PO 15PO 16PO 17PO 18PO 19
LO 1
LO 2
LO 3
LO 4
LO 5