|
 |
|
|
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) |
-- |
| Corequisite(s) |
-- |
| Special Requisite(s) |
-- |
| Instructor(s) |
Lecturer Erdem Yücesan |
| Course Assistant(s) |
|
| Schedule |
-- |
| Office Hour(s) |
-- |
| Teaching Methods and Techniques |
- |
| Principle Sources |
- |
| Other Sources |
- |
|
| Course Schedules |
| Week |
Contents |
Learning Methods |
| 1. Week |
İntroduction 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 |
Functions; Count, Max, Min, Countif, if. |
Lectures and application, Oral Presentation.
|
| 4. Week |
PivotChart. |
Lectures and application, Oral Presentation.
|
| 5. Week |
PivotChart. |
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 |
Insert Function, Forecast, Date, Today, Time, Int, Round, Pmt, Product, Rand, RandBetween functions. |
Lectures and application, Oral Presentation.
|
| 8. Week |
Midterm Week |
Lectures and application, Oral Presentation.
|
| 9. Week |
SQL server, Access, Visual Basic applications, macro, loop. |
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 |
Now, Option, Vlookup, Hlookup, Combo Box and applications. |
Lectures and application, Oral Presentation.
|
| 13. Week |
Work with multiple tables, queries, and create tables and Access application. |
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 |
Final Exam |
|
| 16. Week |
|
|
| 17. Week |
|
|
|
| Assessments |
| Evaluation tools |
Quantity |
Weight(%) |
| Midterm(s) |
1 |
20 |
| Final Exam |
1 |
80 |
| Program Outcomes |
| PO-1 | To define all information needed to learn at communication and information field. | | PO-2 | To learn all basic concepts about their future career | | PO-3 | Get the ability to use theoretical information in practical bussiness life. | | PO-4 | To represent and defind clearly their project. | | PO-5 | Using camera, lighting equipment, audio equipment professional way both indoor or outdoor. | | PO-6 | To have a clear visual language to impress spectator. | | PO-7 | To have enough skill about radio and tv producing, broadcasting and management. | | PO-8 | To have enough skill to create efficient project at audio visual field | | PO-9 | To have a responsability, morality about bussiness life. | | PO-10 | To have ability to work with others, being social and available for team works. | | PO-11 | To have the ability about project creation and management | | PO-12 | To have enough skill to demonstrate their project. | | PO-13 | To understand life time education's importance and being open all technical and social improvement. | | PO-14 | To have enough interest about actual social and cultural life | | PO-15 | To learn at least 1 foreign language. | |
| 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 | | LO 1 | | | | | | | | | | | | | | | | | LO 2 | | | | | | | | | | | | | | | | | LO 3 | | | | | | | | | | | | | | | | | LO 4 | | | | | | | | | | | | | | | | | LO 5 | | | | | | | | | | | | | | | |
|
|
|
|
|
