| PRE-SCHOOL TEACHING | |||||
| Bachelor | TR-NQF-HE: Level 6 | QF-EHEA: First Cycle | EQF-LLL: Level 6 | ||
| Course Code | Course Name | Semester | Theoretical | Practical | Credit | ECTS |
| GEP0375 | Information and Communication Technology II | Fall | 3 | 0 | 3 | 5 |
| This catalog is for information purposes. Course status is determined by the relevant department at the beginning of semester. |
| Language of instruction: | English |
| Type of course: | GE-Elective |
| Course Level: | Bachelor’s Degree (First Cycle) |
| Mode of Delivery: | E-Learning |
| Course Coordinator : | Instructor ADEM ÖZER |
| Course Objectives: | This course aims to provide proficiency in widely used office programs in the workplace, with a particular focus on advanced knowledge and usage of Excel. It also seeks to offer an updated perspective on contemporary software tools. Additionally, through various scenarios, the course aims to enhance students' problem-solving abilities. |
|
The students who have succeeded in this course; By successfully completing this course, you will be able to: Microsoft Word - Create and format different document types (e.g., letters, reports, articles, etc.). - Insert tables, charts, and images. - Apply academic writing rules, such as citations and footnotes. - Divide long documents into sections and create an index. - Prepare forms and surveys. - Collaborate on the same document with multiple users. Microsoft Excel - Perform basic and complex mathematical operations. - Visualize data through tables and charts. - Use techniques such as filtering and sorting for data analysis. - Utilize advanced features like pivot tables. - Import and process data from various data sources. Microsoft PowerPoint - Create impactful and professional presentations. - Use different slide layouts and animations. - Add audio, video, and images to presentations. - Save and share presentations in different formats. - Engage with the audience during presentations. In this course, lecture, individual study, discussion, reading, technology-supported learning teaching methods and techniques are used. |
| This course aims to equip students with fundamental and advanced skills in Microsoft Word, Excel, and PowerPoint, along with an introduction to AI-powered presentation tools and emerging technologies in office software. Throughout the course, students will engage in hands-on practice, including document creation, data analysis, and professional presentation design, while developing essential skills for academic and professional settings. Teaching Methods and Techniques Used in the Course: Lecture Discussion Individual Study Reading Technology-Enhanced Learning Week 1 Introduction to the course Expectations from the course Scope, rationale, significance, and rules of the course Week 2 MS Word Basic interface and functions of Microsoft Word Creating and formatting different document types (e.g., letters, reports, articles) Week 3 MS Word Inserting tables, charts, and images in Word Applying academic writing rules such as citations and footnotes Dividing long documents into sections and creating an index Week 4 MS Word Creating forms and surveys in Word Collaborating on the same document with multiple users Week 5 MS Excel Basic interface and functions of Microsoft Excel Performing basic and complex mathematical operations Week 6 MS Excel Visualizing data through tables and charts Using techniques such as filtering and sorting for data analysis Week 7 MS Excel Using advanced features like macros and pivot tables Importing and processing data from various data sources Week 8 Midterm Exam Week 9 MS PowerPoint Basic interface and functions of Microsoft PowerPoint Creating impactful and professional presentations Week 10 MS PowerPoint Using different slide layouts and animations Adding audio, video, and images to presentations Week 11 MS PowerPoint Saving and sharing presentations in different formats Engaging with the audience during presentations Week 12 Emerging Technologies Artificial intelligence presentation tools Using AI tools (e.g., Prezi AI, Beautiful.ai) Benefits and limitations of AI presentation tools Creating presentations using AI tools Week 13 Emerging Technologies Using AI and other emerging technologies in Word and Excel Preparing documents and spreadsheets more efficiently with new technologies Week 14 Summary and Q&A |
| Week | Subject | Related Preparation |
| 1) | Introduction Course Overview Expectations from the Course Scope, Rationale, Significance, and Rules of the Course | |
| 2) | The Basic Interface and Functions of Microsoft Word Creating and Formatting Different Document Types (e.g., letters, reports, articles, etc.) | |
| 3) | Inserting Tables, Charts, and Images in Word Applying Academic Writing Rules, Such as Citation and Adding Footnotes Dividing Long Documents into Sections and Creating an Index | |
| 4) | Creating Forms and Surveys in Word Collaborating on the Same Document with Multiple Users | |
| 5) | Microsoft Excel's basic interface and functions Performing basic and complex mathematical operations | |
| 6) | Visualizing data through tables and charts Using techniques such as filtering and sorting for data analysis | |
| 7) | Using advanced features such as macros and pivot tables in Excel Importing and processing data from various data sources | |
| 8) | Midterm Week | |
| 9) | Microsoft PowerPoint's basic interface and functions Creating impactful and professional presentations | |
| 10) | Using different slide layouts and animations Adding audio, video, and images to presentations | |
| 11) | Saving and sharing presentations in different formats Engaging with the audience during presentations | |
| 12) | Artificial Intelligence presentation tools Using artificial intelligence presentation tools (e.g., Prezi AI, Beautiful.ai) Benefits and limitations of artificial intelligence presentation tools Creating presentations using an artificial intelligence presentation tool | |
| 13) | Using artificial intelligence and other emerging technologies in Word and Excel Preparing documents and spreadsheets more quickly and easily with new technologies | |
| 14) | Summary and Q&A |
| Course Notes / Textbooks: | |
| References: | "İleri Düzey Excel 2019", Seçkin Yayınları, 9.Baskı, Ömer Bağcı Office 2016/ Tolga Demirhan; Pınar Aydan Demirhan, İlker Hacıoğlu, Altan Mesut |
| Semester Requirements | Number of Activities | Level of Contribution |
| Quizzes | 1 | % 30 |
| Homework Assignments | 2 | % 20 |
| Final | 1 | % 50 |
| Total | % 100 | |
| PERCENTAGE OF SEMESTER WORK | % 50 | |
| PERCENTAGE OF FINAL WORK | % 50 | |
| Total | % 100 | |
| Activities | Number of Activities | Duration (Hours) | Workload |
| Course Hours | 13 | 3 | 39 |
| Study Hours Out of Class | 12 | 3 | 36 |
| Homework Assignments | 2 | 15 | 30 |
| Quizzes | 1 | 10 | 10 |
| Final | 1 | 2 | 2 |
| Total Workload | 117 | ||
| No Effect | 1 Lowest | 2 Low | 3 Average | 4 High | 5 Highest |
| Program Outcomes | Level of Contribution | |
| 1) | Analyze and demonstrate knowledge of concepts, ideas, applications in early childhood education and to be able to evaluate them critically. | |
| 2) | To understand and know the developmental and learning capacities of 0-66 month old children and to reflect these to their education process. | |
| 3) | Implementation of the subject matter, pedagogical and professional knowledge necessary for early childhood education. | |
| 4) | Create teaching potential for 0-66 months old children regarding their multidimensional developmental process including skills and attitudes and behavior applicable to life. | |
| 5) | To know how to develop, apply and evaluate learning mediums with sıitable education programs, teaching approach and methods and techniques which is flexible for each individual child . | |
| 6) | To know and apply the necessary measurement and assessmant techniques suitable for early childhood educaton. | |
| 7) | To develop and apply projects that supports children, families and individuals in the community and contributing positively to their developmental process. | 1 |
| 8) | To integrate the knowledge and experience of working together with different programs and different age groups. | |
| 9) | To demonstrate the commitment to early childhood profession, professionalism,life-long learning and professional growth. | |
| 10) | To cooperate and collaborate with other individuals and community to bring awareness about early childhood education to society. | 1 |
| 11) | To be able to recognize problems in early childhood education, to bring scientifically acceptable solutions to these problems and participate effectively in projects leading to such solutions. | 1 |
| 12) | Demonstrate knowledge of the laws, regulations and policies related to early childhood education and act accordingly. | |
| 13) | To demonstrate commitment to societial,scientific and professional values. | |
| 14) | To recognize and respect different cultures and to be sensitive to individual and cultural differences. | 5 |
| 15) | To demonstrate competence and ethical approach in information and communication technologies. | 1 |
| 16) | To demonstrate English profiency in communicating, knowledge sharing and professional development areas of early childhood education. | 2 |