PAÜ .:. Eğitim Öğretim Bilgi Sistemi

COURSE INFORMATION

Course Code	Course Title	L+P Hour	Semester	ECTS
CBPG 105	OFFICE SOFTWARES	3 + 1	1st Semester	5

COURSE DESCRIPTION

Course Level	Associate's Degree
Course Type	Compulsory
Course Objective	With this course, the student, in every branch of information technology competencies needed on the use of office programs aimed to gain
Course Content	Document Processing, Formatting Operations Document Control, Print, Table Operations- Object Operations, Advanced Features Macros, Customization Study Area, Data Entry, Formatting Operations Formulas, Functions Charting, Data Analysis Data Analysis Print, Macros, Customization Work Area, Slide Processing, Design Slide Objects, Display Settings, Print, Privatization Internet Concepts E-Mail
Prerequisites	No the prerequisite of lesson.
Corequisite	No the corequisite of lesson.
Mode of Delivery	Face to Face

COURSE LEARNING OUTCOMES

1	Gain proficiency on the use of office programs.
2	The student, a word processor program and the features, uses an active way.
3	Student, spreadsheet preparation software, uses an efficient manner.

COURSE'S CONTRIBUTION TO PROGRAM

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION

Activities	Quantity	Duration (Hour)	Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)	14	4	56
Hours for off-the-classroom study (Pre-study, practice)	14	2	28
Assignments	2	8	16
Mid-terms	1	8	8
Laboratory	14	1	14
Final examination	1	8	8
Total Work Load ECTS Credit of the Course			130 5

COURSE DETAILS

Select Year

	Course Term	No	Instructors
Details	2020-2021 Fall	1	ENGİN DUTAR

Course Details

Course Code	Course Title	L+P Hour	Course Code	Language Of Instruction	Course Semester
CBPG 105	OFFICE SOFTWARES	3 + 1	1	Turkish	2020-2021 Fall

Course Coordinator	E-Mail	Phone Number	Course Location	Attendance
Lecturer ENGİN DUTAR	edutar@pau.edu.tr		ÇMYO A0063	%70

Goals		With this course, the student, in every branch of information technology competencies needed on the use of office programs aimed to gain
Content		Document Processing, Formatting Operations Document Control, Print, Table Operations- Object Operations, Advanced Features Macros, Customization Study Area, Data Entry, Formatting Operations Formulas, Functions Charting, Data Analysis Data Analysis Print, Macros, Customization Work Area, Slide Processing, Design Slide Objects, Display Settings, Print, Privatization Internet Concepts E-Mail

Topics

Weeks	Topics
1	Word 2007 Overview, Input tab: Panel group, Font group, paragraphs Group, Styles, Tables and features
2	Add tab: With Illustrations, Text Group, the Page Layout Tab: Arrange group
3	Page Layout tab: Page Setup, Page Background
4	Applications tab: Table of Contents, Footnotes, Picture Post, List
5	Mail tab: Mail Merge, Result Preview
6	Review tab: Writing group, group description, Monitoring Groups, With Changes
7	Add tab: Header Footer group, View tab: With views of the document, Show Hide group, the Zoom Group
8	Overview of Excel 2007, Input tab: Panel Group, Font group, Alignment Group Number
9	Data tab: Get External Data group, the Data Tools group, Mainline Group
10	Data tab: Get External Data group, the Data Tools group, Mainline Group
11	Formulas tab: Function Library, Defined Names group, Formula Auditing
12	Logical tests and applications
13	Input tab: style group, the Data tab: Sort & Filter
14	Appearance tab: Group Workbook Views, Show Hide group, the Zoom Group, Window

Materials

Materials are not specified.

Resources

Resources	Resources Language
Bilgisayar I-II Temel Bilgisayar Becerileri- Pagem Akademi Yayınları	Türkçe

Course Assessment

Assesment Methods	Percentage (%)	Assesment Methods Title
Final Exam	60	Final Exam
Midterm Exam	40	Midterm Exam

L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes

Prospective Student