COMPUTER APPLICATIONS (8 6) - CISCE

1 COMPUTER APPLICATIONS (86). Aims: 4. To enable students to learn to process words and numbers, analyze data, communicate ideas 1. To empower students by enabling them to build effectively and make the optimum use of their own APPLICATIONS . COMPUTER resources. 2. To introduce students to some effective tools to 5. To help students learn fundamental concepts of enable them to enhance their knowledge, broaden computing using object oriented approach in one horizons, foster creativity, improve the quality of COMPUTER language. work and increase efficiency. 6. To provide students with a clear idea of ethical 3. To enable students to learn to use the World Wide issues involved in the field of computing. Web in order to gather knowledge and communicate with students and the academic community all over the world. CLASS IX. There will be one written paper of two hours duration ii) Graphic User Interface carrying 100 marks and Internal Assessment of 100.

2 Working with the Graphical User Interface marks. (GUI), Elements of a GUI, handling files and The paper will be divided into two sections A and B. directories under GUI, managing the desktop. Section A (Compulsory 40 marks) will consist of Concept of an active window. Familiarity with compulsory short answer questions covering the entire the icons, the buttons and the task bar. syllabus. Resizing a window. Handling multiple windows. Section B (60 marks) will consist of questions which will require detailed answers and there will be a choice Creating folders. Copying items. Moving of questions in this section items. Deleting Items. Setting attributes of items. THEORY 100 Marks Creating shortcuts on the desktop, arranging the folders on the desktop. 1. Operating System 2. The Internet i) Introduction to Operating System Internet, e-mail, WWW, modem and related protocols.

3 The need for an operating system, features and functions of an operating system and Working of internet, creating an e-mail account, sending and receiving e-mails, web servers, search familiarity with installing and uninstalling engines to perform a simple search and Boolean software. operators to fine tune a search, basic working of a Functions and features of an operating system modem (modulation and demodulation) through block (examples of single user and multiple users); diagrams only. Protocols and its need (FTP, HTTP, familiarize the students with installation and IMAP, POP, SMTP). Downloading information. un-installation of connected peripherals and other related softwares like dictionaries, encyclopedias, etc. 141. 3. Computing and Ethics Defining the structure of a database, entering data of various types, saving it in an appropriate area. Ethical issues in computing.

4 Adding, deleting and modifying records, global editing. Intellectual property rights; protection of individual's Performing calculations on one record or a group of right to privacy; data protection on the internet; records. protection against Spam; software piracy, cyber crime, Modifying the structure of a database by inserting, hacking, protection against malicious intent and deleting or modifying fields. malicious code. Sorting on one field/ multiple fields, sorting selected The stress should be on good etiquette and ethical records/ all the records. practices. Indexing on one field/ multiple fields. The need for 4. Office Application Software: re- indexing. Sorting vs. Indexing. Setting query condition, Relational and Logical Word processor, Multimedia presentation and Operators, setting query using multiple conditions. Spreadsheets. Generating detailed or summary reports.

5 Discuss the following features for Word Processor, Working with multiple databases and explain the Multimedia Presentation and Spreadsheets: relationship (one to one, one too many, many to one and many to many) through real life examples. Opening and closing, saving, editing, formatting, Linking objects/embedding objects, linking vs. printing, spell check, grammar and header/footer. embedding. Creating database APPLICATIONS depending upon the Special features: requirement of the user. Word Processor inserting a table and working with 6. Elementary Concept of Objects and Classes tables. Modelling entities and their behaviour by objects; a Multimedia Presentation the students should be able class as a specification for objects and as an object to create a presentation using images / pictures, sound, factory; computation as message passing/function calls video and custom animation.

6 Students should be able between objects (many examples should be done to to import material from word processors, spreadsheets, illustrate this). Objects encapsulate state (attributes). databases and internet. and have behaviour (functions). Class as a user defined type. Spreadsheets Using formulae functions A class may be regarded as a blueprint to create (mathematical), working with ranges, graphs and objects. It may be viewed as a factory that produces charts. Difference between absolute and relative similar objects. A class may also be considered as a references. new data type created by the user, that has its own functionality. 5. Database Packages All the four features of Object Oriented Programming The need for database management; creating and should be defined and explained using real life saving a database; editing a database; performing examples.

7 Calculations; modifying the structure of a database;. sorting, indexing; querying; report generation. Analyze each object and show how each contains Working with multiple databases, object linking and attributes and responds to certain messages or permits embedding, creating APPLICATIONS . certain operations. The need for database management for handling vast Emphasize that an object is an instance of a class. A. amount of data- storing, sorting, summarizing, single object is just a bundle of values, one for each classifying and retrieving quickly. attribute in the class. 142. 7. Values and types Suggested list of Assignments: Tokens and its types, Primitive types, operations on For topics (1 5). primitive values, expressions, assignment (assignment 1. Connect to net. If you are already connected start a is also an expression). browser and a search engine and perform a simple Introduce the primitive types and the range of values search on any of the subjects.

8 Then perform a each represents. Discuss all the operations that can be Boolean search for the same topic and note the done with primitive types namely mathematical, difference. Create your own email ID and send an relational and logical. Discuss precedence and e-mail. associativity of operators. Introduce the concept of type 2. A story is given in which the main character is a casting. lady, Mrs. James. Make changes in the document using find and replace so that the main character Introduce and , for becomes a gentleman Mr. Brown. Take care of the simple output. pronouns. Discuss different types of errors occurring during 3. Design a presentation to launch an awareness execution and compilation of the program (syntax program like Save the Earth . errors, runtime errors and logical errors). 4. Create a presentation to highlight the activities in 8. Conditionals and non-nested loops your school.

9 Application of if else, if else if ladder, switch-case 5. Build a friendly database to access phone numbers, (default, break). emails and addresses conveniently. Fixed number of iterations- the for loop. Unknown For topics (6-8). number of iterations - while loop, do-while loop. The laboratory assignments will form the bulk of the The conditional/ternary operator (? : ) should be course. Good assignments should have problems which introduced at this point. require design, invention of an algorithm and only then implementation and testing. The problems will mimic Loops are fundamental to computation and their need a real life problem and require careful design or will should be shown by examples.. require an interesting algorithm to solve it. They should Examples: various number based problems: prime also embody one or more concepts that have been numbers, composite numbers, perfect numbers, discussed in the theory class.

10 A significant proportion fibonacci numbers, etc. of the time has to be spent in the laboratory. Computing can only be learnt by doing. INTERNAL ASSESSMENT - 100 Marks Some sample problems are given below as examples. This segment of the syllabus is totally practice oriented. The problems are of varying levels of difficulty: The accent is on acquiring basic usage skills quickly and efficiently. 6. Enter marks of ten students in six subjects, find the total marks and the average of each student using Assignments and Application Building Mathematical functions and make a chart on the Students should complete a number of laboratory basis of their average marks. assignments during the whole year to reinforce the concepts studied in the class. 7. Create a table in a Word Processor for your class The students should build one real life application with the following fields: Roll No.