Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 136 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 136

    P R O J E C T W O R K

                      LibreOffice Calc
                                                                                                       21 st
                      Project 1                                                                      Century   #Technology Literacy
                                                                                                      Skills
                      Create a grade sheet in LibreOffice Calc like the one shown below. Add an additional column
                      after "Marks in English" for "Marks in Computer”.

                         Name of the          Marks in          Marks in        Marks in Social           Marks in
                            Student        Mathematics           Science             Science               English

                             Pooja               75                 72                  76                   67

                           Sandeep               79                 73                  75                   68

                             Nidhi               80                 83                  79                   67

                             Komal               69                 69                  80                   56

                            Deepak               57                 47                  59                   76

                          Add a new column for "Marks in Computer.
                          Add another new column for "Marks in Computer.
                           Calculate  the  average  marks  for  each  student  in  the  "Average  Marks"  column  using  the
                          AVERAGE function.
                                                                                                       21 st
                      Project 2                                                                     Century   #Technology Literacy
                                                                                                      Skills
                      Create a table in LibreOffice Calc like the one shown below. Use the Sort feature to arrange the
                      data by Salary in descending order and then by Department in ascending order.

                          Employee Name             Department                Salary                     Age

                               Vikram                   Sales                  35000                      28

                               Sushma                    HR                    45000                      32

                                 Ajay                Marketing                 40000                      30

                                Meera                    IT                    50000                      29

                               Deepak                   Sales                  38000                      27

                    134     Premium Edition-VII

| 131 132 133 134 135 136 137 138 |