Page 6 - Computer - 8

Contents
Contents

1. Computer Networking 5-15
• Applications of Computer Networking • Networking Terminologies • Network Architecture
• Types of Computer Networks • Components of Computer Network • Network Topologies
• Protocols • Advantages of Computer Networking • Disadvantages of Computer Networking
2. Databases in Excel 16-28
• Working with Databases in Excel • Displaying Subtotals • Data Validation
• Goal Seek • Scenario Manager • Pivot Table
3. Introduction to Access 2019 29-50
• Database Management System (DBMS) • Microsoft Access 2019 • Components of Access 2019 Window
• Database Objects • Working with Databases • Working with Tables
• Sorting Records in a Datasheet • Design View in Access • Components of Design View
• Working with Tables in the Design View
4. Queries, Forms & Reports in Access 2019 51-62
• Working with Queries • Working with Forms • Working with Reports
5. List and Images in HTML5 63-75
• Structure of an HTML Document • HTML5 Elements • Cascading Style Sheet (CSS)
• Creating Lists • Ordered List • Description List
• Inserting Images
Worksheet-1 76-77
• Based on Chapters 1 – 5
6. Tables, Links, Audio, Video and Frames in HTML5 78-90
• Working with Tables • Working with Hyperlinks • Inserting Audio
• Inserting Video • Inserting Frames
7. Iterative Statements in Python 91-100
• Iterative Statements • Components of a Loop • For Loop
• Use of Range( ) function in For Loop • While Loop • Jump Statements in a Loop in Python
8. Functions, Strings, and Lists in Python 101-114
• Functions in Python • Features of Functions • Components of a Python Function
• Types of Functions in Python • Creating a Function • Calling a Function
• Working with Strings • Working with Lists
9. Introduction to Photoshop 2022 115-129
• Features of Photoshop 2022 • Starting Photoshop 2022 • Components of Photoshop 2022 Workspace
• Working with Files • Using the Tools Panel • Selection Tools
• Drawing Tools • Painting Tools
10. More on Photoshop 2022 130-145
• Retouching Tools • Working with Layers • Working with Text • Using Filters
11. Future of Artificial Intelligence 146-163
• Big Data • Data Mining • Neural Networks
• Deep Learning • Data Science and Data Scientists • Future Domains of AI
Worksheet-2 164-165

• Based on Chapters 6 – 11
Cyber Olympiad 166
Mental Ability and Logical Reasoning 167

Projects 168-171
Database 172-176
• Introduction to Windows 11