-To give the ability for using any kind of chart processing and presentation softwares for their academic or business life. Students will learn how the computers are used in business graphics program and the most important futures of excel processing, access.
Prerequisite(s)
-
Corequisite(s)
-
Special Requisite(s)
-
Instructor(s)
Lecturer Nahide Tekin, Öğr.Gör Murat Tekin
Course Assistant(s)
-
Schedule
Distance Education
Office Hour(s)
CATs Meetings
Teaching Methods and Techniques
-Lecture, Applications
-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.
-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, Application, Presentation
2. Week
Functions; Count, Max, Min, Countif, if.
Lectures, Application, Presentation
3. Week
PivotChart.
Lectures, Application, Presentation
4. Week
Form controls; Group Box, Option Button.
Lectures, Application, Presentation
5. Week
Contitional formating, Data Validation, $ operator.
Now, Option, Vlookup, Hlookup, Combo Box and applications.
Lectures, Application, Presentation
12. Week
Access database. Objects, table, Form ve Report.
Lectures, Application, Presentation
13. Week
Creating a data base. OLE Object, Text Object, Report. Queries.
Lectures, Application, Presentation
14. Week
Work with multiple tables, queries, and create tables and Access application.
Lectures, Application, Presentation
15. Week
16. Week
17. Week
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
20
Final Exam
1
80
Program Outcomes
PO-1
Adequate knowledge in mathematics, science and engineering subjects pertaining to the relevant discipline; ability to use theoretical and applied knowledge in these areas in the solution of complex engineering problems.
PO-2
Ability to formulate, and solve complex engineering problems; ability to select and apply proper analysis and modeling methods for this purpose.
PO-3
Ability to design a complex systemi process, device or product under realistic constraints and conditions, in such a way as to meet the desired results; ability to apply modern design methods for this purpose.
PO-4
Ability to select and use modern techniques and tools needed for analyzing and Solving complex problems encountered in engineering practice; ability to employ information technologies effectively.
PO-5
Ability to design and conduct experiments, gather data, analyze and interpret results for investing complex engineering problems or discipline specific research questions.
PO-6
Ability to work efficiently in intra-disciplinary and multi-disciplinary teams; ability to work individually.
PO-7
Ability to communicate effectivley, both orally and in writing; knowledge of a minimum of one foreign language; ability to write effective reports and comprehend written reports, prepare design and production reports, make effective presentations, and give and receive clear and intelligible instruction.
PO-8
Awareness of the need for lifelong learning; ability to access information, to follow developments in science and technology, and to continue to educate him/herself.
PO-9
Knowledge on behavior according ethical principles, professional and ethical responsibility and standards used in engineering practices.
PO-10
Knowledge about business life practices such as project management, risk management, and change management; awareness in entrepreneurship, innovation; knowledge about sustainable development.
PO-11
Knowledge about the global and social effects of engineering practices on health, environment, and safety, and contemporary issues of the century reflected into the field of engineering; awareness of the legal consequences of engineering solutions.
Learning Outcomes
LO-1
To be able to use MS excel processing tool for drawing objects, writing, formatting and creating tables. (KNOWLEDGE)
LO-2
To be able to produce graphs on MS Excel software. (KNOWLEDGE)
LO-3
To be able to have ability to use MS PowerPoint tool and MS PowerPoint tool for creating and modifiying presentaions. (SKILL)
LO-4
Excel; file, home, insert, page layout, formulas, data, review, developer ve view tabs, operations, functions, form controls. (KNOWLEDGE)
LO-5
Work with multiple tables, queries, and create tables and Access application. (KNOWLEDGE)
