Page 8 - iPrime_V2.2_class7
P. 8

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
                                                        Contents





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