Page 6 - Digital Age - 7

Contents

1. Number System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5-11
• Types of Number System • Conversion of Decimal Number into Binary Number • Binary Addition
• Binary Subtraction • Binary Multiplication • Binary Division
2. Advanced Features in Excel 2016 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12-20
• Using Flash Fill • Sorting Data • Filtering Data
• Conditional Formatting • Using Format Painter
3. Charts in Excel 2016 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .21-33
• Types of Charts • Elements of a Chart • Creating a Chart
• Creating a Combo Chart • Adding Chart Elements • Changing Chart Type
• Changing Chart Layout • Changing Chart Style • Changing Chart Colour Scheme
• Formatting Elements of a Chart • Deleting a Chart • Moving a Chart
• Sparklines
4. Variables & Operators in Python . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .34-42
• Starting Python • Components of Python IDLE Window • Working with Python IDLE
• Data Types in Python • Declaring and Initialising a Variable • Operators in Python
• Precedence of Operators
5. Decision Making in Python . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .43-51
• Conditional Statements • If Statement • If … Else Statement
• Nested If … Else Statement • If … Elif … Else Ladder • Indentation of Statements in Python
Worksheet-1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .52-53
• Based on Chapters 1 – 5
6. Introduction to HTML5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .54-63
• What is HTML? • Features of HTML5 • HTML Editors • HTML5 Coding
• Structure of an HTML Document • Working with HTML Documents • Basic HTML Tags
7. Adding CSS in HTML5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .64-73
• Understanding Cascading Style Sheets • Ways of Inserting CSS in HTML • Setting Background Properties
• Setting Text Properties • Setting Margin Properties • Setting Border Properties
• Inline Styles
8. Internet Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .74-82
• Communication Services • Social Networking • Online Gaming • Productivity Services
• Cloud File Storage Services • Media Streaming Services • Web-based Services
9. Computer Malware . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .83-90
• What Malware Can Do? • What Malware Cannot Do? • Sources of Malware
• Indications of Malware Infection • Types of Malware • Preventing Malware Infections
• Antivirus Software
10. App Development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .91-99
• What are Apps? • Types of Apps • Categories of Apps • Where to get Apps From?
• What is App Development? • Platforms for Building Apps • Creating an App
11. How AI Works? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100-107
• Defining Artificial Intelligence • Disciplinary Approaches to AI • How AI Works? • Symbolic AI
• Machine Learning AI • Factors Encouraging ML • Types of Machine Learning
Worksheet-2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108-109
• Based on Chapters 6 – 11
Cyber Olympiad & Mental Ability and Logical Reasoning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110
Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111-112