Course Code	Semester	Course Name	LE/RC/LA	Course Type	Language of Instruction	ECTS
			//

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)
Course Assistant(s)
Schedule
Office Hour(s)
Teaching Methods and Techniques
Principle Sources
Other Sources

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 Optician has a basic level of theoretical knowledge in the field PO-2 They describes terms related to Opticianry field PO-3 They will have a basic level of practical knowledge in Opticianry field PO-4 They define problems when faced with an unexpected situation in line with the information obtained from the device. PO-5 Detects problems and looks for solutions in their field PO-6 Optician, using the basic knowledge of a given task is executed independently owned. PO-7 Lifelong learning awareness, identify learning requirements and access to information resources. PO-8 Inform individuals and organizations about the use of technological knowledge and skills they possess in the relevant issues, share their suggestions for solutions to problems orally and in writing. PO-9 An optician, use the acquired knowledge and skills at a basic level, he served as a member of the team to face any problem. PO-10 Personal and public health have sufficient awareness of safety and environmental protection will be aware of the risks that threaten the environment, warned the environmental and human health protection.

Learning Outcomes LO-1 Excel; file, home, insert, page layout, formulas, data, review, developer ve view tabs, operations, functions, form controls. LO-2 Work with multiple tables, queries, and create tables and Access application. LO-3 To be able to use MS excel processing tool for drawing objects, writing, formatting and creating tables. LO-4 To be able to produce graphs on MS Excel software LO-5 To be able to have ability to use MS PowerPoint tool and MS PowerPoint tool for creating and modifiying presentaions.

Course Assessment Matrix: