Print

COURSE INFORMATION
Course CodeCourse TitleL+P HourSemesterECTS
TDS 243PRACTICING BASIC INFORMATION TECHNOLOGY-II2 + 12nd Semester3

COURSE DESCRIPTION
Course Level Associate's Degree
Course Type Compulsory
Course Objective To reinforce the knowledge of students who have gained basic knowledge about computer use and to enable them to use computers at an advanced level
Course Content Developing advanced applications with Microsoft Excel, developing advanced applications with Microsoft PowerPoint, information about WEB page preparation techniques, developing applications 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 13
LO 001   5         
LO 002   5         
LO 003   3         
LO 004   5         
Sub Total   18         
Contribution0005000000000

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION
ActivitiesQuantityDuration (Hour)Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)14342
Hours for off-the-classroom study (Pre-study, practice)13113
Mid-terms155
Laboratory13113
Final examination155
Total Work Load

ECTS Credit of the Course






78

3
COURSE DETAILS
 Select Year   


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


Print

Course Details
Course Code Course Title L+P Hour Course Code Language Of Instruction Course Semester
TDS 243 PRACTICING BASIC INFORMATION TECHNOLOGY-II 2 + 1 1 Turkish 2023-2024 Spring
Course Coordinator  E-Mail  Phone Number  Course Location Attendance
Lecturer BEDİA SÜNDÜZ KILIÇ bskilic@pau.edu.tr DSHMY D0201 %70
Goals To reinforce the knowledge of students who have gained basic knowledge about computer use and to enable them to use computers at an advanced level
Content Developing advanced applications with Microsoft Excel, developing advanced applications with Microsoft PowerPoint, information about WEB page preparation techniques, developing applications with Microsoft Access.
Topics
WeeksTopics
1 Table creation, general table operations and conditional formatting in Excel
2 Creating formulas and using calculation operators
3 Use of Mathematical Formulas
4 Use of Text Formulas
5 Use of Date and Logical Formulas
6 Sample applications for formulas
7 Graphic operations in Excel
8 Advanced Data Operations, PivotTable operations, printing command and printing settings in Excel
9 Sample applications with Excel
10 Preparing advanced presentations with Powerpoint
11 Information about WEB page preparation techniques and introduction to HTML codes
12 Examining database working principles and table structure, data types and field properties in databases
13 Querying on tables
14 Form and report components in databases
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