Page 382 - Trackpad IT-402_Class-IX
P. 382

After creating the worksheet, write functions/formulas to the following:

             Write the formula to calculate the Total points (Sum of Points + Bonus) of each player in cell F2 – F6.
             Write the feature used for arranging the Rank from Highest to Lowest.
             To find the Player with Maximum TOTAL to be written to Cell F7.

             To find the Average of Points to be written in cell C7.
             To change the Orientation of the Page from Landscape to Portrait.
         6.  Create the Quarterly sales report in OpenOffice Calc:














            After creating the report, write functions/formulas to the following:

             Write the formula to calculate the Total sales of North Zone.
             Write the feature used for arranging the Sales from Lowest to Highest.
             To find the Maximum Sales in East Zone.

             To find the Average Sales in Jan-Mar in cell C7.
             To find the difference between the sales in East Zone and West Zone in Apr-Jun.

                                                                                                 21 st
        Digital Presentation:                                                                  Century   #Creativity
                                                                                                Skills
         1.  Create a Presentation on:

            Ethics in IT
            New Trends in Technology
            Global Warming

            Impact of Social Medial
            Cyber security
            If you are given a choice of career in IT, then which one will you prefer and why?

             Plagiarism and the World Wide Web
           Notes
             The presentation should have minimum of 10 slides.

             The first slide should have your name, class and section.
             The second slide should be the index slide.
             All the slides in the presentation should have a common background.

             Try to include one appropriate picture per slide.
             Use Custom Animation and transition effects in each slide.

            Use all the features learnt so far.

          382   Trackpad Information Technology-IX
   377   378   379   380   381   382   383   384   385   386   387