Print

COURSE INFORMATION
Course CodeCourse TitleL+P HourSemesterECTS
TGT 213BASIC COMPUTER SCIENCE1 + 11st Semester2

COURSE DESCRIPTION
Course Level Associate's Degree
Course Type Elective
Course Objective Provide efficient use of computer and information technology to students.
Course Content Understand the Working principles of computer hardware, Understand working principles of applications, Advanced application with Microsoft Excel, Application development with Microsoft PowerPoint, Know internet resources and services, Understand the working principles of web pages, know use of searching engine, Application development with Microsoft Access.
Prerequisites No the prerequisite of lesson.
Corequisite No the corequisite of lesson.
Mode of Delivery Face to Face

COURSE LEARNING OUTCOMES
1Develops advanced applications with Microsoft Excel.
2Develops advanced applications with Microsoft Powerpoint.
3Learns general information about WEB page preparation techniques.
4Develops applications with Microsoft Access.

COURSE'S CONTRIBUTION TO PROGRAM
PO 01PO 02PO 03PO 04PO 05PO 06PO 07PO 08PO 09PO 10PO 11PO 12PO 13PO 14
LO 001  4      35   
LO 002  3      34   
LO 003  3      35   
LO 004         33   
Sub Total  10      1217   
Contribution00300000034000

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION
ActivitiesQuantityDuration (Hour)Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)14228
Mid-terms199
Final examination11515
Total Work Load

ECTS Credit of the Course






52

2
COURSE DETAILS
 Select Year   


 Course TermNoInstructors
Details 2023-2024 Fall1BEDİA SÜNDÜZ KILIÇ


Print

Course Details
Course Code Course Title L+P Hour Course Code Language Of Instruction Course Semester
TGT 213 BASIC COMPUTER SCIENCE 1 + 1 1 Turkish 2023-2024 Fall
Course Coordinator  E-Mail  Phone Number  Course Location Attendance
Lecturer BEDİA SÜNDÜZ KILIÇ bskilic@pau.edu.tr DSHMY D0201 %70
Goals Provide efficient use of computer and information technology to students.
Content Understand the Working principles of computer hardware, Understand working principles of applications, Advanced application with Microsoft Excel, Application development with Microsoft PowerPoint, Know internet resources and services, Understand the working principles of web pages, know use of searching engine, Application development with Microsoft Access.
Topics
WeeksTopics
1 General table operations in Excel
2 Examination of Excel buttons on the Home tab
3 Creating formulas and using calculation operators
4 Use of Mathematical Formulas
5 Use of Text Formulas
6 Use of Date and Logical Formulas
7 Sample applications for formulas
8 Graphic operations in Excel
9 PivotTable operations in Excel
10 Advanced Data Operations, printing command and printing settings in Excel
11 Sample applications with Excel
12 Preparing presentations with Powerpoint
13 Preparing presentations with Powerpoint
14 The Use of Internet, Making Basic Settings, The Use of Search Engines and E-mail Applications
Materials
Materials are not specified.
Resources
Course Assessment
Assesment MethodsPercentage (%)Assesment Methods Title
Final Exam50Final Exam
Midterm Exam50Midterm Exam
L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes