|
 |
|
|
Introduction to Computer II
| Course Code | Semester |
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-1 | P O 1. To have basic knowledge about Public Relations and Advertising | | PO-2 | P O 2. To have basic knowledge about Human Resources | | PO-3 | P O 3. To have basic knowledge about Marketing | | PO-4 | P O 4. To have basic knowledge about Aesthetic Arts and Fine Arts | | PO-5 | P O 5. To have basic knowledge about information technology | | PO-6 | P O 6. To have basic knowledge about Law | | PO-7 | P O 7. To have basic knowledge about Project Management | | PO-8 | P O 8. To have knowledge on Atatürk Principles and Revolution History | | PO-9 | P O 9. To have professional English on Communication | | PO-10 | P O 10. To have knowledge about effective Turkish Language | | PO-11 | P O 11.To have knowledge about communication | | PO-12 | P 0 12.To have knowledge about business functions | |
| Learning Outcomes |
| LO-1 | To be able to use MS excel processing tool for drawing objects, writing, formatting and creating tables. | | LO-2 | To be able to produce graphs on MS Excel software | | LO-3 | To be able to have ability to use MS PowerPoint tool and MS PowerPoint tool for creating and modifiying presentaions. | | LO-4 | Excel; file, home, insert, page layout, formulas, data, review, developer ve view tabs, operations, functions, form controls. | | LO-5 | Work with multiple tables, queries, and create tables and Access application. | |
|
| Course Assessment Matrix: |
|
| | PO 1 | PO 2 | PO 3 | PO 4 | PO 5 | PO 6 | PO 7 | PO 8 | PO 9 | PO 10 | PO 11 | PO 12 | PO 13 | PO 14 | PO 15 |
|
|
|
|
|
