Page 6 - Computer - 7

Contents
Contents

1. Number System 5-13
• Types of Number System • Conversion of Decimal Number into Binary Number
• Binary Addition • Binary Subtraction • Binary Multiplication • Binary Division
2. Advanced Features in Excel 2019 14-25
• Using Flash Fill • Sorting Data • Filtering Data
• Conditional Formatting • Using Format Painter
3. Charts in Excel 2019 26-44
• 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 45-56
• Features of Python • 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 57-67
• Conditional Statements • If Statement • If … Else Statement
• Nested If … Else Statement • If … Elif … Else Ladder • Indentation of Statements in Python
Worksheet-1 68-69
• Based on Chapters 1 – 5
6. Introduction to HTML5 70-82
• 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 83-96
• 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 97-109
• Communication Services • Social Networking • Online Gaming • Productivity Services
• Cloud File Storage Services • Media Streaming Services • Web-based Services
9. Computer Malware 110-119
• 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 120-136
• 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? 137-149
• Defining Artificial Intelligence • Disciplinary Approaches to AI • How AI Works? • Symbolic AI
• Machine Learning AI • Factors Encouraging ML • Types of Machine Learning
Worksheet-2 150-151
• Based on Chapters 6 – 11
Cyber Olympiad 152
Mental Ability and Logical Reasoning 153
Projects 154-155
Database 156-164
• Google Docs, Slides, and Sheets