Page 10 - CA 165 ver 1.0 Class 9
P. 10

●  Spreadsheets: concept of a worksheet and a workbook, create and save a worksheet.
                  ●  Working with a spreadsheet: enter numbers, text, date/time, series using auto fill; edit and format a worksheet including
                     changing the colour, size, font, alignment of text; insert and delete cells, rows and columns. Enter a formula using the
                     operators (+,-,*, /), refer to cells, and print a worksheet.
                  ●  Use simple statistical functions: SUM (), AVERAGE (), MAX (), MIN (), IF () (without compound statements); embed charts of
                     various types: line, pie, scatter, bar and area in a worksheet.

                  Lab Exercises
                  ●  Browser settings for a secure connection
                  ●  Working with the operating system: Navigation of the file system using a mouse and keyboard.
                  ●  Word processing: create a text document; create a letter, report, and greeting card.
                  ●  Create a text document with figures in it. It should describe a concept taught in another course.
                  ●  Discuss the following in a text document about the basic organisation of a computer: CPU, memory, input/output devices,
                     hard disk.
                  ●  Create a text document in an Indian language other than English.
                  ●  Create a presentation.
                  ●  Create a presentation with animation.
                  ●  Include existing images/ pictures in a presentation.
                  ●  Animate pictures and text with sound effects in a presentation
                  ●  Create a simple spreadsheet and perform the following operations: min, max, sum, and average.
                  ●  Create different types of charts using a spreadsheet: line, bar, area and pie.

                  Breakup of marks for the Practicals:
                                S. No.                      Unit Name                           Marks
                                                                Lab Test (30 marks)
                                       Word processing                                            10
                                  1.
                                       Handling spreadsheets                                      10
                                       Creating presentations                                     10
                                  2.                        Report File + viva  (10 marks)
                                       Report file:
                                       •   4 documents each with a word processor, spreadsheet, and   8
                                          presentation tool
                                       Viva voce (based on the report file)                       2
                                  3.   Project (that uses most of the concepts that have been learnt)  (10 marks)
                                       Total Marks                                                50




























                                                                  (viii)
   5   6   7   8   9   10   11   12   13   14   15