|
|
|
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 | | | | | | | | | | | | | | | |
|
|
|
|
|