Page 8 - KEC Khaitan C6 Flipbook
P. 8

Contents



                                                                   B
                                 A
                                                                                                      C
                              ICT                           VOCATIONAL TECH CURRICULUM
                             Part A                             Part B                             Part C


                   A1  Editing in Excel 2021   7     B1  Introduction to Illustrations   82  C1  Robotics: A Journey into
                         Selecting a Range of Cells         Raster Illustrations            Automation             116
                          Editing Cell Contents             Vector Illustration
                          Undo and Redo Commands                                               Robotics
                          Deleting Cell Contents            File Formats                       Applications of Robotics
                          Deleting Cells, Rows Or Columns     Using 2D Shapes in Graphics      Importance of Robotics
                          Inserting Cells, Rows Or Columns  B2  Vector Landscape in            Basic Components of Robots
                          Copying the Data               Adobe Illustrator       85
                          Moving the Data                                                      What is a Circuit?
                          Autofill                          Illustrator Workspace              Electronic Components
                           Changing the Column Width and     Creating a New Document           Tinkercad Circuit
                        Row Height                          Setting Up the Workspace           Types of Circuits
                  A2  Formulas and Functions in Excel       Designing Vector Background  C2  Exploring Microcontrollers   126
                                                            Creating Illustrations
                      2021                     21           Adding Effects
                         Data Types in Excel 2021           Duplicating Elements               Introduction to BBC Micro:BIT
                          Operators in Excel 2021            Export Vector Artwork in Desired     What is a Microcontroller?
                          Operators Precedence             Formats in Illustrator               Exploring the BBC Micro:bit
                          Ways to Enter a Formula in Excel 2021  B3  Digital Flat Animals Design   98  Interface
                          Cell Range                                                    C3  Building Smart Solutions: An
                          Cell Reference                    Creating Animal Shapes          Introduction           136
                          Functions                         Saving the Completed Artwork
                  A3  Charts in Excel 2021    34            Exporting the Completed Artwork    Introduction to IoT
                         Charts                      B4  Branding (Logo, Poster and            Understanding Ultrasonic Sensors
                          Advantages of Charts           Visiting Card Designing)   103        What are Motors?
                          Components of a Chart                                                 Using Sonar and Servo Extensions
                          Types of Charts                   Branding                          in MakeCode for Micro:bit
                           Creating a Chart                 Types of Branding
                          Changing Chart Type               What is a Logo?                     Connecting to Thinkspeak with WiFi
                          Setting the Data Range            Designing a Logo                  Shield
                          Moving and Resizing the Chart     Business Card
                          Changing Background of the Chart
                  A4  Advanced Features of Excel  47         Designing and Formatting Business
                                                           Cards
                         SUM()                              Designing Posters
                          IF()                              Exporting and Finalizing Designs
                          Sorting Data in Excel
                          Filtering Data in Excel
                          Conditional Formatting
                  A5  Cyber Security          57
                         What is Cyber Security?
                          Need for cyber Security
                          Computer Ethics
                          Common Cyber Security Measures
                           Indian Laws and Government
                        Initiatives
                  A6  Algorithm, Flowchart and
                      Mind Maps               65
                         Algorithm
                          Writing an Algorithm
                          Flowchart
                          Drawing a Flowchart
                          Brainstorming
                         Mind Maps
                          Computer Languages
                          Language Translator

                   Periodic Assessment 1        46   Periodic Assessment 2        77  Test Sheet 1                  78

                   Project                     80

                                                                  (vi)
   3   4   5   6   7   8   9   10   11   12   13