Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    21 st   #Critical Thinking
                                                                                                     Century
                        Lab Session                                                                    Skills  #Technology Literacy

                           Create a worksheet in Calc listing 10 different fruits with columns for Fruit Name, Price per Unit
                           and Quantity Available. Apply Data Validity to the Quantity Available column so that only integer
                           values between 1 and 50 can be entered. Test the validity by attempting to enter a value outside
                           the allowed range and observe the error message. Save the worksheet after completing the task.
                          Create a  worksheet  in Calc with  students’ marks for  different  subjects. Use a  Pivot Table  to
                           summarise the data by placing subjects in Row Fields, students’ names in Column Fields and
                           marks in Data Fields to display the total, highest and lowest marks for each subject.

                      Teacher's Note

                        1.  Illustrate the concepts discussed in the chapter to the students.
                        2.  Help students understand the difference between:
                           a.  Auto Filter and Standard Filter      b.  Sorting and Filtering

                     58     Premium Edition-VII

| 55 56 57 58 59 60 61 62 63 64 65 |