Page 6 - Digital Age - 6

Contents

1. Computer Language . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5-10
• Early Calculating Devices • Evolution of Computers • Computer Languages
2. Files and Folders . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .11-18
• Files • Folders • File Explorer
• Components of File Explorer Window • Working with Files and Folder • Changing the View in File Explorer
3. Table in Word 2016 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .19-26
• Inserting a Table • Entering Data in a Table • Selecting Parts of a Table
• Modifying a Table • Formatting a Table • Inserting Pictures in a Table Cell
• Performing Simple Calculations in a Table
4. Mail Merge . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .27-31
• Using Mail Merge Wizard
5. Enhancing Presentations in PowerPoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .32-40
• Inserting an Audio File • Inserting a Video File • Deleting Audio or Video File

• Animations • Transitions • Rehearsing Timings for a Slide Show
Worksheet-1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .41-42

• Based on Chapters 1 – 5
6. Advanced Scratch 3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .43-52
• Working with Variables • Working with Operators • Combining the Elements
7. More on Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .53-66
• Entering Data in Cells • Editing Cell Contents • Undo and Redo Commands

• Copying and Moving Cell Contents • Inserting Cells, Rows, or Columns • Deleting Cells, Rows, or Columns
• Changing Row Height and Column Width • Font Formatting • Cell Formatting
• Working with Long Text • Number Formatting • Date and Time Formatting
8. Formulas and Functions in Excel 2016 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .67-77
• Formula • Entering a Formula • Entering Cell References
• Precedence of Operators in a Formula • Using Cell Referencing in a Formula • Using Functions in Formulas
• Common Functions in Excel • Writing a Formula Using Insert Function
9. Introduction to Python . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .78-85
• What is Python? • Features of Python • Starting Python
• Components of Python IDLE Window • Python Working Modes • Working in Script Mode
• Understanding Variables • Input and Output Operations in Python
• Comments in Programs
10. Email . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .86-93
• Advantages of Email • Email Account and Email Address • Creating an Email Account
• Email Folders • Using Your Email Account • Email Netiquettes
11. Types of Artificial Intelligence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .94-99
• Concept of Intelligence • Artificial Intelligence • Types of Artificial Intelligence
Worksheet-2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .100-101
• Based on Chapters 6 – 11
Cyber Olympiad & Mental Ability and Logical Reasoning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102
Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .103-104