|
 |
|
|
Introduction to Computer II
| Course Code | Semester |
Course Name |
LE/RC/LA |
Course Type |
Language of Instruction |
ECTS |
| BİL2001* - |
4 |
Introduction to Computer II |
4/0/0 |
UE |
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 | Installation of electrical and electronic systems | | PO-2 | Taking baseline measurements | | PO-3 | Setting up digital circuits | | PO-4 | Setting up analog circuits | | PO-5 | Ability to set up microprocessor circuits and program | | PO-6 | Installation of electric motors and experiments | | PO-7 | Setting up systems of control circuits | | PO-8 | Gaining professional experience and manual dexterity | | PO-9 | Gaining practical circuit installation experience | |
| 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 |
|
|
|
|
|
