Question - LIBRARY AND INFORMATION CENTRE



KENDRIYA VIDYALAYA SANGATHAN BHUBANESWAR REGIONSPLIT UP SYLLABUS 2018-19SUB: INFORMATICS PRACTICESCLASS: XIS.NoUnit Name Marks Allotted1Introduction to Computer systems102Introduction to Programming253Relational Database Management System304IT Applications 5TOTAL70Question Paper DesignClass-XI (2018-19) S.No.Typology of QuestionsVeryShort Answer(VSA)(1 mark)Short Answer-I(SA-I)(2 marks)Short Answer-II(SA-II)(4 marks)Long Answer(L.A)(6 marks)Total Marks%Weightage1Knowledge Based432-1825.72Conceptual Understanding451-1825.73Reasoning Based4-211825.74Skill based-1211622.9Total marks1297270(30)100MONTHWORKING DAYSno of period???MAY-JUNE2432JULY2632AUGUST2430SEPTEMBER2128OCTOBER1824 NOVEMBER 2016DECEMBER1922JANUARY24 APX.26SL NOMONTHEXPECTED WORKING DAYEXPECTED NO OF PERIODSDETAILED SPLIT UPPERIODS FOR CLASS ROOM TEACHING PRACTICAL PERIODSPractical /Experiment Activity1June 20182432UNIT-1: Introduction to Computer systemsHardware Concepts:Computer organization (basic concepts): CPU, Memory (RAM and ROM), I/O devices, communication bus, ports (serial, parallel), device specific ports;Input devices: Keyboard, Mouse, Light pen, Touch Screen, Graphics Tablet, Joystick, Microphone, OCR, Scanner, Smart Card reader, Barcode reader, QRCode reader, Biometric sensor, web camera;Output Devices: Monitor/Visual Display Unit (VDU), LCD screen, Television, Printer (Dot Matrix printer, Desk jet/ Inkjet/ Bubble jet printer, Laser printer), Plotter, Speaker;Secondary Storage Devices: Floppy Disk, Hard Disk, Compact Disk, Magnetic Tape, Digital Versatile Disk (DVD),Flash Drive, Memory parative properties of storage media;Memory Units: bit, Byte (Kilobyte, Megabyte, Gigabyte, Terabyte, Petabyte)Encoding scheme :ASCII,ISCII & UNICODEE-waste disposal.Security of computer system: Sources of attack and possible damages, malware – virus, worms, spyware and cookies as security threat, malware detection using a tool. Computer security, digital certificate, digital signature, firewall, password, file access permissionsTypes of Software:System Software:Operating systems: Need for operating system, major functions of Operating System; Examples of OS for mainframe (eg: Linux etc), PC/Server (eg: Windows, Ubuntu etc.), and mobile devices eg: Android, ios and Symbian.Language Processors: Assembler, Interpreter, and CompilerUtility Software: Compression tools, disk defragmenter, anti-virusApplication Software:General Purpose Application Software: Word Processor, Presentation Tool, Spreadsheet Package, Database Management System, Integrated Development Environment (IDE)Specific Purpose Application Software: Inventory Management System, Purchasing System, Human Resource Management System, Payroll System, Financial Accounting, Hotel Management and Reservation System etc [Monthly Test-1] 248Activity 1 to 42July 20182634Unit-2 Introduction to ProgrammingGetting started with Programming using IDEIntroduction, Rapid Application Development using IDE (Integrated Development Environment) such as Netbeans; Familiarization of IDE using basic Interface components- Label, Text Field, Text Area, Button, Checkbox, Radio Button. (As per appendix A)Developing General Application (As per the guidelines at appendix B) - Getting Familiar with Java Swing User Interface components-Frame, Dialog, OptionPane, Panel, ScrollPane, Label, TextField, PasswordField, TextArea, Button, CheckBox, RadioButton, ComboBox, ListBasic component handling methods and properties: setText(), getText(), isSelected(), setSelected() [Monthly Test-2] 2014Activity 5 to 6Practical 1 to 53Aug-20182430Introduction to Programming: (Contd…)Programming FundamentalsData Types: Concept of data types; Built-in data types - byte, short, int, long, float, double, char, string, booleanVariables: Need to use variable, declaring variables, variable naming convention, assigning value to variables;Integer object method: parseIntDouble object method: parseDouble, parseFloatControl Structures & Decision Structure – if, if-else, switch; Looping Structure- while, do . . while, for; [Periodic Test-1]1614Activity 7-11Practical 6-104Sep-20182128Introduction to Programming: (Contd…) Programming Guidelines:General Concepts; Modular approach;Stylistic Guidelines: Clarity and simplicity of expressions and names; Comments, Indentation;Running and debugging programs, Syntax Errors, Run-Time Errors, Logical Errors;Problem Solving Methodology: Understanding of the problem, Identifying minimum number of inputs required for output, breaking down problem into simple logical steps.Unit 3: Relational Database Management SystemDatabase Management SystemIntroduction to database concepts: Database, Relational database, Relation/Table, Attribute/Field, Tuple / Row;Data Types: Text (CHAR, VARCHAR), Number (DECIMAL, INT/INTEGER), Date and TimeKeys: Candidate key, Primary key, Alternate key, Foreign key;Examples of common Database Management System: MySQL, Ingres, Postgres, Oracle, DB2, MS SQL, Sybase etc.; Common Database management tools for mobile devices (eg: SQL Lite, Postgres SQL). [Monthly Test-3]101044Activity 12-14Practical 11-135Oct-20181824Relational Database Management System(Contd…)Introduction to MySQL: Classification of SQL Commands:DML - SELECT, INSERT, UPDATE, DELETE DDL - CREATE, DROP, ALTERCreating and using a database: CREATE DATABASE command to create a database, USE command to select a database.Creating a table: CREATE TABLE command to create a table, DESC command to display a table structure, INSERT command for inserting new rows, inserting new rows with NULL values and values of all the studied data types.Selection and Projection of a table.Displaying table data: SELECT command for selecting all the columns, selecting specific column(s), use of arithmetic operators.Defining and using column aliasEliminating duplicate values from display using DISTINCT keywordLimiting rows during selection (using WHERE clause)Using Comparison operators - =, <, >, <=, >=, <>, BETWEEN, IN, LIKE(%,_);Logical Operators –AND, OR, NOT and corresponding operator precedence;Working with NULL values. [Monthly Test-4]1212Activity 15-17Practical 14-16Autumn Break : 13/10/2018 to 22/10/20186Nov-20182016Relational Database Management SystemIntroduction to MySQL (Contd…)ORDER BY clause: Sorting in Ascending/Descending order, sorting by column alias name, sorting on multiple columns;Manipulating Data of a Table/Relation: UPDATE command to change existing data of a table, DELETE command for removing row(s) from a table.Restructuring a table: ALTER TABLE for adding new column(s) and deleting column (s) and modifying column Structure. DROP command to delete a database or a table. [Mid Term Exam]88Activity 18Practical 177Dec-20181922Relational Database Management System (Contd…)Functions in MySQL:String Functions: ASCII(), CHAR(), CONCAT(), INSTR(), LCASE(), UCASE(), LEFT(), LOWER(),LENGTH(), LTRIM(), MID(), RIGHT(), RTRIM(), SUBSTR(), TRIM(), UPPER().Mathematical Functions: - POWER(), ROUND(), TRUNCATE().Date and Time Functions: CURDATE(), DATE(), MONTH(), YEAR(), DAYNAME(), DAYOFMONTH(), DAYOFWEEK(), DAYOFYEAR(), NOW(), SYSDATE(). [Monthly test -5]1210Activity 18Practical 18-19Winter Break : 23/12/2018 to 01/01/20198Jan-20192420Till 25th JanUnit-4: IT Applicatione-Governance: Definition, benefits to citizens, e-Governance websites and their salient features and societal impacts; e-Governance challenges.e-Business: Definition, benefits to customers and business, e-Business websites and their salient features and societal impacts; netbanking, mobile banking, e-Business challenges.e-Learning: – Definition, benefits to students (learners), teachers (trainers) and school (Institution) management; MOOCs (Massive Open Online Courses) ; e-Learning websites and their salient features and societal impacts; e-Learning Challenges.Impact of ICT on society – social environmental and economic benefits Infomania [Periodic Test-2]128Activity 199Feb-2019Revision ,Project Submission and Practical’s [Per-Session Ending Exams]Note: 1. Split up is prepared as per the CBSE curriculum 2017-18 2. Separate note book has to be maintained by the students for recording the activity.ACTIVITES LIST FOR CLASS XI-IP(1) Create a list of hardware’s [input ,output & others] available in the Vidyalaya.(2)Create a list f software available in the Vidyalaya[operating system, application, antivirus & utility s/w] (3) Create symbolic diagram to represent the differences between various malicious programs.(4)Create a list of methods/ways used for computer security/safety. (5)Individual java controls will be given to individual students and students asked to represent the important properties and method of assigned java control in the class room during teaching.(6)Create an application to accept two strings - First Name and Last name from the user and display the message Welcome with the complete name of the user.(7) Create a list of data types available in the Java along with their size and example.(8)Create a list of properties which are common in all Java controls.(9)Create a list of tasks that may be programmed using if else statement.[minimum 10].(10)Create a list of tasks that may be programmed using switch statement.[minimum 10].(11)Create a list of tasks that may be programmed using iterative statement.[minimum 10.(12)Create a list of operators along with the precedence order available in java.(13)Individual problems has to be given to the individual student and student asked to create a list of steps used to solve the problem.(14)Create a list of Different errors may occurred in the program. (15)Create a symbolic diagram to depict various DBMS available for PC and Mobiles.(16) Create a table and show the followingsPrimary keyii. Candidate keysiii. Degreeiv. Cardinality(17)Create a symbolic diagram to categories the SQL commands into different category (DDL, DML, DCL &TCL)(18) Create two tables and show the following operations.Cartesian productii. Unioniii. Intersectioniv. join v. degree & cardinality in each operation.(19) Analyze any problem and generate the solution using ICT[front end & back end]Note: create your own Activities as per the split up syllabusPRACTICAL LIST FOR CLASS XI-IPQ(1)Design a GUI desktop application in java to accept the side of a square in a text field and calculate the area and perimeter of the square. Display the results in two separate text fields. Add appropriate labels and an exit button to end the application.Q(2) Design a GUI desktop application in java to accept marks in 5 subjects in five text fields and calculate the total and average marks. Display the results in separate text fields, which are disabled. Add appropriate labels and an exit button to end the application.Q(3)Design a GUI desktop application in java to accept sales of a company for four quarters in text fields. Calculate the total yearly sale and display the same in a dialog box. Add appropriate labels and an exit button to end the application. Q(4) Design a GUI desktop application in java to accept length in kilometers in a text field and display the converted length in meters in a second text field which is disabled. Add appropriate labels and an exit button to end the application.Q(5)Design a GUI desktop application in java to accept two numbers in a in a text field and interchange the values of first number and second number using a temporary variable. Add appropriate labels and an exit button to end the application.Q(6) Design a GUI application to perform simple arithmetic operation (+,-,*,/) and display the result in TextBox Q(7) Design a GUI application to calculate simple interest.Q(8)Develop an application to take input from user in a radio button out of the two referring to Area or Perimeter of a circle. Print the Area or Perimeter in a TextField for the value of Radius entered in another TextField.Q(9)Develop an application to take an input in TextField for a number. If the number is even then Display its square otherwise its cube in a MessageBox. Q(10)Develop an application to calculate area of a circle, a rectangle or a triangle depending upon the user's choice (from a set of Radio Buttons). Accept the desired input Radius OR Length-Bredth OR Side as per the option selected by the userQ(11) Design a GUI application to calculate Total, Average and Grade calculation for given marks of 5 subjects of 10th class and also display the eligibility of the student for the available stream in text area.Q(12)) Design a GUI application to Find the Discount of an item on the basis of Category of item [ElectricalAppliance using a Radio button] and its Cost [Below 1000/Above 1000/Equal to 1000 specified using a Radio button]Q(13) Design a GUI application to accept the cost price and selling price form the user in two text fields then calculate the profit or loss incurred.Q(14) Design a GUI application in java to identify the selling price of cost price enter by the user based on the selected profit margin (through radio button, 10%,20% & 30%) and display it.Q(15) Design a GUI application to create a list box for ClassName ,print the names of the class teacher according to the class selected.Q(16)Design a GUI application to calculate discount and net amount of the basis of payment option & bill amount using radio button. SQLQ(17)Table EMPTable: EMPEMPNOENAMEJOBMGRHIREDATESALCOMMDEPTNO7369SMITHCLERK790217-Dec-80800NULL207499ALLENSALESMAN769820-Feb-811600300307521WARDSALESMAN769822-Feb-811250500307566JONESMANAGER78392-Apr-812975NULL207654MARTINSALESMAN769828-Sep-8112501400307698BLAKEMANAGER78391-May-812850NULL307782CLARKMANAGER78399-Jun-812450NULL107788SCOTTANALYST756619-Apr-873000NULL207839KINGPRESIDENT17-Nov-815000NULL107844TURNERSALESMAN76988-Sep-811500NULL307876ADAMSCLERK778823-May-871100NULL207900JAMESCLERK76983-Dec-81950NULL307902FORDANALYST75663-Dec-813000NULL207934MILLERCLERK778223-Jan-821300NULL10SELECT WHERETo display the records of all employees who work as SALESMAN in DEPTNO 20To display the records of all employees with names of five characters and working in DEPTNO 10To display the records of all employees working as CLERK and getting SALARY between 1000 and 1200To display the records of all employees not working in DEPTNO 10 and 20 and joined before 01-01-1980To display the records of all employees who are not SALESMAN and get a salary less than 2500To display the records of all employees who working from 01-01-1980 and do not get a commissionPATTERNTo Display the records of all employees whose names start with S.To Display the records of all employees whose JOB have the letters NAG in them.To Display the records of all employees whose names have E as their second last character.NOTTo display the Records of all employees who do not receive any commission.To display the Records of all employees who do not work in DEPTNO 10To display the Records of all employees who do not get alary in between 800 to 1200SELECT ROWSTo display the ENAME, JOB and MGR CODE of all the employees sorted in descending order of SALARY.To display the EMPLOYEE NO, SALARY and HIREDATE of all the employees sorted in ascending order of DEPTNOTo display the ENAME, JOB and COMM of all the employees sorted in ascending order of HIREDATESELECT DISTINCTTo display the unique types of JOB done by the employees.To display the unique types of DEPTNO of employees.NULLTo display the details of the employee who does not have a managerTo display the list all employees who get a commissionTo display the list all employees who do not get a commission> < BETWEEN To display the record of all employees who have salary in the range of 800 to 1500To display the record of all employees who joined in the period between 01-01-1980 to 01-01-1981To display the record of all employees who have commission from 0 to 200.LISTTo display the record of all employees who have jobs as SALESMAN, MANAGER and ANALYSTTo display the record of all employees who work in department no 10,20,30To display the record of all employees who salaries as 800,1000 and 1200AGGREGATE FUNCTIONSFind the max SALARY of all employeesFind the min Salary in deptno 10Find the sum of all Salary for all employees in deptno 10 and 20Find the average of Salary of Department 10 and 20Find the number of employees in Deptno 10 and 20UPDATEChange the Department of FORD to 10Increase the SALARY of all Employees by 5 %Input the COMM of BLAKE 10% of SALARYDELETE Delete the record of BLAKEDelete the record of all employees who are in Deptno 10ALTERAdd a new column Phone char(10) to the table EMPIncrease the column size of ENAME by 10 Add NOT NULL Constraint to Phone columnDROPDrop the table EMPQ(18)Write SQL statements to do the following:a) Using the three separate words "We," "study," and "MySQL," produce thefollowing output:"We study MySQL"b) Use the string "Internet is a boon" and extract the string "net".c) Display the length of the string "Informatics Practices".d) Display the position of "My" in "Enjoying MySQL".e) Display the name of current month.f) Display the date 10 years from now. Label the column "Future."g) Display the day of week on which your birthday will fall or fell in 2010. Q(19)Create the following table named "Charity" and write SQL queries for the tasksthat follow:3710472444100I. Display all first names in lowercaseII. Display all last names of people of Mumbai city in uppercaseIII. Display Person Id along with First 3 characters of his/her name.IV. Display first name concatenated with last name for all the employees.V. Display length of address along with Person IdVI. Display last 2 characters of City and Person ID.VII. Display Last Names and First names of people who have "at" in the second orthird position in their first names.VIII. Display the position of 'a' in Last name in every row.IX. Display Last Name and First name of people who have "a" as the last character in their First names.X. Display the first name and last name concatenated after removing the leading and trailing blanks.XI. Display Person Id, last names and contribution rounded to the nearest rupee of all the persons.XII. Display Person Id, last name and contribution with decimal digits truncated of all the persons.XIII. Display Last name, contribution and a third column which has contribution divided by 10. Round it to two decimal points.Appendix –A Attached Separately ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download