Page 41 - TP_iPlus_V2.1_Class8
P. 41

#Coding & Computational Thinking
                                                                                     #Creativity and Innovativeness


                        Practical Time


                      Create a similar invoice in Excel.


                      a.  Fill-up details of five items, their quantities and
                         unit prices.
                      b.  Using the PRODUCT function, calculate the
                         amount for each item.
                      •  Using the SUM function, calculate the total
                        amount.
                      •  Using a formula, calculate the GST according to the given rate.
                      •  Calculate Invoice amount payable.


                        Create an Excel worksheet and enter the following data:











                       Create a column chart based on the above data. Title of the chart should be ‘Yearly Sales
                       Chart’. The chart should be look like this:

























                     Teacher’s Corner

                 1.  Do a walk-through of all the Excel topics in detail listed in the chapter on the computer screen.
                 2.  Explain to the children the use of Excel at at home, in shops, businesses, industries, etc.
                 3.  Describe the different types of charts provided by Excel to the students.

                 4.  Talk to the students about the different styles that can be applied to a chart.





                                                                                                                  39
                                                                              Spreadsheet—Functions and Charts
   36   37   38   39   40   41   42   43   44   45   46