Page 8 - Trackpad_ipro 4.1_Class7
P. 8

Contents







                                                 Computer Studies ICSE Syllabus


                  Topic 1:  Computer—Hardware Components               Topic 5:  Spreadsheets—An Introduction
                  Topic 2:  Number System—An Introduction              Topic 6:  Database and DBMS—An Introduction
                  Topic 3:  Computer Virus                             Topic 7:  HTML—Advanced Features
                  Topic 4:  Ethics and Safety Measures in Computing


                           Computer—Hardware Components          7              J  Using Formulas to Perform Calculation
                   01      J  Hardware                                          J  Order of Operation
                           J  New Trends in Hardware
                                                                                   Worksheet 1                       80
                           Number System                       21
                   02      J   What is a Number System?                            Test Sheet 1                      81
                           J   Decimal to Binary Conversion
                           J  Binary to Decimal Conversion                      Database and DBMS—
                           J  Operations on Binary Numbers              07      An Introduction                     83
                                                                                J  Concept of a Database
                           Computer Virus                      30
                   03      J  What is a Computer Virus?                         J  Advantages of a Database System
                           J  Types of Computer Viruses                         J  Types of Databases
                                                                                J  Terms Related to a Database
                           J   How does a Computer get Infected                 J  Access 2019
                              with a Virus?
                                                                                J  Components of Access 2019
                           J   How do you know if your PC has a Virus?
                                                                                J  Creating a Database
                           J  How to Protect your PC from a Virus?
                                                                                J  Data Types in Access 2019
                           J  Malware
                                                                                J  Types of Views in Access
                           J  Antivirus
                                                                                J   Naming Conventions for Writing a Field
                           J  Firewall
                                                                                   Name
                           Ethics and Safety Measures in                        J  Creating a Table
                   04      Computing                           40               J  Opening an Existing Database
                           J  Internet                                          J  Exiting Access 2019
                           J Computer Ethics                                    More on Access                      97
                           J  Internet Ethics                           08      J  Forms in Access
                           J  Unethical Practices
                                                                                J  Queries in Access
                           J   Safety Measures While using                      J  Reports in Access
                              Computer/Internet
                           J  Digital Footprints                                Lists and Tables in HTML           109
                                                                        09      J  Creating Lists
                           Spreadsheets—An Introduction        53
                   05      J  Features of Excel 2019                            J  Creating Tables
                           J  Starting Excel 2019                               More on HTML                       125
                           J  Components of Excel 2019 Window           10      J  Inserting Images
                           J  Types of data                                     J  Linking Web Pages
                           J  Creating a New Workbook                           J  Adding Audio & Video
                           J  Entering Data in a Worksheet                      J  Frames
                           J  Saving a Workbook                                 J  Forms in HTML5
                           More on Spreadsheets                64                  Worksheet 2                     152
                   06      J  Selecting Cells in a Worksheet
                           J  Copying/Moving Data                                  Test Sheet 2                    153
                           J  Using Undo and Redo Features                      Project Work                       155
                           J  Column Width and Row Height
                           J  Inserting Rows/Columns                              Explore More (Introduction to MySQL)  158
                           J  Merging Cells                                       Uncover Artificial Intelligence &
                           J  Formatting Spreadsheets                           Robotics                           162
                           J  AutoFill                                          OGO Cyber Sample Questions         166
                                                                                Glossary                           168
                                                                   (vi)
   3   4   5   6   7   8   9   10   11   12   13