Print

COURSE INFORMATION
Course CodeCourse TitleL+P HourSemesterECTS
BAS 300COMPUTERS - II2 + 22nd Semester4

COURSE DESCRIPTION
Course Level Associate's Degree
Course Type Compulsory
Course Objective Course of this study will provide a table in the working life of the program aims to ease understanding
Course Content The basic features of MS Excel. In Excel file creation, file opening and saving. In the MS Excel program, working with workbooks and worksheets. Selecting Cells and Entering and filling data. Selection and navigation in the Workbook, Worksheet Formatting. Editing Worksheet Data. Cells and Data Append, Copy / Transport. Creating formulas in Excel, enter formulas and Working with graphics. Managing list. Print.
Prerequisites No the prerequisite of lesson.
Corequisite No the corequisite of lesson.
Mode of Delivery Face to Face

COURSE LEARNING OUTCOMES
1ICT skills needed in every branch of the gain proficiency on the use of office programs
2Word processing program actively uses and properties
3Tables and charts and tables are computed

COURSE'S CONTRIBUTION TO PROGRAM
PO 01PO 02PO 03PO 04PO 05PO 06PO 07PO 08PO 09PO 10PO 11PO 12PO 13PO 14
LO 001            14
LO 002             4
LO 003             4
Sub Total            112
Contribution00000000000004

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION
ActivitiesQuantityDuration (Hour)Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)14456
Hours for off-the-classroom study (Pre-study, practice)14228
Mid-terms166
Final examination166
Report / Project248
Total Work Load

ECTS Credit of the Course






104

4
COURSE DETAILS
 Select Year   


 Course TermNoInstructors
Details 2023-2024 Spring1ALİ COŞKUN
Details 2022-2023 Spring1ALİ COŞKUN
Details 2021-2022 Spring1ALİ COŞKUN
Details 2020-2021 Spring1ALİ COŞKUN
Details 2019-2020 Spring1ALİ COŞKUN
Details 2018-2019 Spring1ALİ COŞKUN
Details 2017-2018 Spring1ALİ COŞKUN
Details 2016-2017 Spring1ENGİN DUTAR
Details 2015-2016 Spring1ENGİN DUTAR
Details 2014-2015 Spring1ENGİN DUTAR
Details 2013-2014 Spring1TİMUÇİN KÖROĞLU
Details 2012-2013 Spring1TİMUÇİN KÖROĞLU
Details 2011-2012 Spring1TİMUÇİN KÖROĞLU
Details 2010-2011 Summer1TİMUÇİN KÖROĞLU
Details 2010-2011 Spring1TİMUÇİN KÖROĞLU
Details 2010-2011 Spring1HAMİD YEŞİLYAYLA


Print

Course Details
Course Code Course Title L+P Hour Course Code Language Of Instruction Course Semester
BAS 300 COMPUTERS - II 2 + 2 1 Turkish 2023-2024 Spring
Course Coordinator  E-Mail  Phone Number  Course Location Attendance
Lecturer ALİ COŞKUN alicoskun@pau.edu.tr ÇMYO A0064 %
Goals Course of this study will provide a table in the working life of the program aims to ease understanding
Content The basic features of MS Excel. In Excel file creation, file opening and saving. In the MS Excel program, working with workbooks and worksheets. Selecting Cells and Entering and filling data. Selection and navigation in the Workbook, Worksheet Formatting. Editing Worksheet Data. Cells and Data Append, Copy / Transport. Creating formulas in Excel, enter formulas and Working with graphics. Managing list. Print.
Topics
WeeksTopics
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
ResourcesResources Language
Adım Adım Word 2007 Türkçe
Adım Adım Excel 2007Türkçe
Course Assessment
Assesment MethodsPercentage (%)Assesment Methods Title
Final Exam60Final Exam
Midterm Exam40Midterm Exam
L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes