SRI CHAITANYA OLYMPIAD SCHOOL JUBILEEHILLS BRANCH

TODAY IS THE FIRST DAY OF THE REST OF YOUR LIFE

CHAPTER-1

1. MICROSOFT PUBLISHERI FILL IN THE BLANKS

1. THE DIFFERENT TYPES OF PUBLICATIONS CAN BE FOUND FROM PUBLICATION TYPES

2. CTRL+S IS THE SHORTCUT KEY TO SAVE A PUBLICATION

3. PICTURE FRAME IS PRESENT ON OBJECTS TOOLBAR OF THE PUBLICATION INTERFACE

4. COLOR SCHEME IS PRESENT ON FORMAT PUBLICATION BAR OF THE MS-PUBLISHER

5. SMALL CIRCLES ON THR CORNERS AND SIDES OF THE FRAME CALLED AS HANDLES

II TRUE OR FALSE

1. THE DEFAULT EXTENSION OF A PUBLISHER FILE IS .PUB [ T ]

2. THE BACKGROUND OPTION IS PRESENT IN VIEW MENU OF THE MS-PUBLISHER [ F ]

3. THE COLOR SCHEME OPTION IS ALSO PRESENT IN FORMAT MENU [ T ]

4. THE MS-PUBLISHER HELPS IN MAKING GREETING CARDS [ T ]

5. WE CANNOT INSERT CLIPART IN MS-PUBLISHER [ F ]

III ANSWER THE FOLLOWING QUESTIONS

1. WRITE THE USES OF MS-PUBLISHER?

ANS) MS-PUBLISHER CAN BE USED TO CREATE AND DESIGN VARIETY OF PUBLICATIONS LIKE BUSINESS CARDS, GREETING CARDS, AND INVITATION CARDS.

2. WRITE THE STEPS TO INSERT CLIP ART IN A PUBLICATION?

ANS) STEP-1 : CLICK ON INSERT MENU AND SELECT PICTURE OPTION

STEP-2 : ENTER A SEARCH TERM AS CELEBRATION AND PRESS GO

STEP-3 : SELECT THE CLIP ART AND DRAG ON THE FRAME

3. HOW TO APPLY A BACKGROUND TO A PUBLICATION?

ANS) STEP-1: CLICK ON FORMAT MENU

STEP-2: SELECT BACKGROUND OPTION

STEP-3 : CLICK ON DESIRED BACKGROUND

4. WRITE THE STEPS TO APPLY AUTO RECOVERY OPTION IN PUBLICATION?

ANS) STEP-1: CLICK ON TOOLS MENU

STEP-2: CLICK ON ‘OPTIONS’

STEP-3: CHOOSE THE SAVE TAB

STEP-4: MAKE SURE THAT THE CHECKBOX“SAVE AUTO RECOVERY INFO EVERY” IS TICKED

STEP-5: SET NUMBER OF MINUTES AS “1”

STEP-6: CLICK ON OK

CHAPTER-22. COMPUTER LANGUAGES

I. ABBREVIATIONS:

1.BASIC: BEGINNERS ALL PURPOSE SYMBOLOC INSTRUCTION CODE

2. LOGO: LOGIC ORIENTED GRAPHIC ORIENTED

3. FORTRAN: FORMULA TRANSLATOR4. COBOL: COMMON BUSINESS ORIENTED

LANGUAGE

II. BLANKS:1.PROGRAM2.COMPILER3.HIGH4.ASSEMBLY5.TRANSLATOR6.BINARY7.C++8.LOGO

III. TRUE OR FALSE:

1.F2.T3.F4.T5.TIV. MULTIPLE CHOICE QUESTIONS:

1.A2.C3.C4.B5.D

V. ANSWER THE FOLLOWING QUESTIONSQ 1. WHAT IS PROGRAMMING LANGUAGE?

A PROGRAMMING LANGUAGE IS DESIGNED TO COMMUNICATE AND GIVE INSTRUCTION TO COMPUTER

Q2. WHAT IS AN ASSEMBLY LANGUAGE? ASSEMBLY LEVEL LANGUAGE USES MNEMONIC CODES AND SYMBOLS.

ASSEMBLY LANGUAGE NEEDS ASSEMBLER TO TRANSLATE ASSEMBLY LANGUAGE TO MACHINE LANGUAGE.

Q3. WRITE ANY 3 ADVANTAGES OF HIGH LEVEL LANGUAGE?

PROGRAMS WRITTEN USING HIGH LEVEL LANGUAGE ARE EASILY UNDERSTANDABLE

RECTIFYING THE ERRORS IN THE PROGRAM IS EASY

KNOWLEDGE OF HARDWARE IS NOT REQUIRED.

Q4. DEFINE COMPILER AND INTERPRETER?COMPILER: COMPILER TRANSLATES ENTIRE PROGRAM IN A SINGLE STEP

INTERPRETER: INTERPRETER TRANSLATES THE PROGRAM IN STATEMENT BY STATEMENT PROCESS…PAGENO:24 1ST LET ‘S REVIEWI. MS-PUBLISHERII. AIII. B,C,AIV. 3,5,1,6,2,4V. COMPILERVI. PROGRAMVII. TRUEVIII.TRUE

CHAPTER-33. PROGRAMMING LOGIC TECHNIQUE

I.BLANKS: 1. PROGRAM2. PROGRAMMING LOGIC TECHNIQUE3. ALGORITHM4. GRAPHICAL5. PROCESS6. INPUT/OUTPUT7. PSEUDOCODEII. MCQ1.D2.C

3.A4.D5.AIII. WRITE IN CORRECT SEQUENCE ORDER1.DEFINE THE PROBLEM2.DEFINE THE SOLUTION3.MAP THE SOLUTION4.WRITE THE PROGRAM5.TEST THE PROGRAMIII. MATCHING:1.E2.C3.B4.A5.D

IV. ANSWER THE FOLLOWING QUESTIONS?1.WHAT IS AN ALGORITHM?A)AN ALGORITHM IS A STEP BY STEP PROCEDURE TO SOLVE A PROBLEM

Q2) WHAT IS FLOWCHART?

A) FLOWCHART IS A GRAPHICAL REPRESENTATION OF AN ALGORITHMQ3) EXPLAIN THE FEATURES OF ALGORITHM?A)

1) ALGORITHMS MAKE OUR WORK EASY2) EVERY STEP IS CLEARLY DESCRIBED3) DATAFLOW IS PROCESSED IN TOP-DOWN

APPROACHQ4) WRITE THE LIMITATIONS OF FLOWCHART?A)

1) FLOWCHARTS ARE DIFFICULT TO MODIFY2) THE DRAWING OF FLOWCHART IS MORE

THAN ONE SHEET OF PAPER, CONNECTOR IS USED TO JOIN DIFFERENT PAGES.

Q5) LIST THE SYMBOLS USED FOR FLOWCHART?A)

SYMBOL NAMETERMINALINPUT/OUTPUT

PROCESSDECISION

CONECTOR

FLOW SYMBOLS

CHAPTER-44. PROGRAMMING WITH QBASIC

I.BLANKS:1) QUICK BEGINNERS ALL PURPOSE

SYMBOLIC INSTRUCTION CODE2) .BAS3) NUMERIC AND ALPHA NUMERIC4) 405) END

6) HIGHII. TRUE OR FALSE:

1) F2) F3) T4) F

III. ANSWER THE FOLLOWING 1.WHAT IS VARIABLE? EXPLAIN TYPES OF

VARIABLES WITH EXAMPLE?A)Variable: A VARIABLE IS A PLACE IN COMPUTER MEMORY WHICH HAS AN ADDRESS AND STORES DATA TEMPORARILY.TYPES OF VARIABLE : VARIABLES ARE 2 TYPES:a) NUMERIC VARIABLE: A VARIABLE THAT HOLDS

ARITHMETIC CALCULATIONS IS CALLED NUMERIC VARIABLE.EX: A=143, HERE A IS NUMERIC VAIABLE

b) ALPHA NUMERIC (OR) STRING VARIABLE A VARIABLE THAT HOLDS AN

ALPHANUMERIC CONSTANT IS CALLED ALPHANUMERIC VRIABLE.

A VARIABLE MUST END WITH $ SIGN

A VARIABLE MUST ENCLOSED WITH DOUBLE QUOTES

EX : name$=”PRANEETH”Q2) EXPLAIN PRINT CLS REM COMMAND?A)PRINT: IT IS USED TO DISPLAY THE OUTPUT ON THE SCREENEX: PRINT “Q BASIC”CLS: IT IS USED TO CLEAR THE OUTPUT SCREENREM: REM STANDS FOR REMARK

IT GIVES AN EXPLANATION TO THE PROGRAM

THIS STATEMENT WILL NOT EXECUTE BY THE COMPILER

Q3) WHAT IS AN OPERATOR? EXPLAIN TYPES OF OPERATOR?ANS)OPERATOR: OPERATOR IS A SYMBOL THAT TELLS WHICH TYPE OF OPERATION IS GOING TO PERFORM

TYPES OF OPERATOR:

a)ARITHMETIC OPERATOR :

OPERATION OPERATORADDITION +

SUBSTRACTION -MULTIPLICATION *

DIVISION /EXPONETIAL ^

b)RELATION OPERATOR : THESE ARE USED TO COMPARE TWO VALUES.

OPERATION OPERATOREQUAL TO ==LESS THAN <MORE THAN >

LESS THAN OR EQUAL TO

<=

MORE THAN OR EQUAL TO

>=

NOT EQUAL TO <>

C) LOGICAL OPERATORS: THESE ARE USED TO COMBINE TWO OR MORE RELATIONAL OPERATORS.

Q4) DEFINE THE FOLLOWING COMMANDS?ANS)

1.CLS : CLEARS THE SCREEN2.PRINT : PRINTS STATEMENT ON OUTPUT

SCREEN3.REM : REM STANDS FOR REMARK4.END : ENDING OF YOUR PROGRAM

PGN0:45 2 ND LET ‘ S REVIEW I. 4,1,5,2,3II. FLOWCHARTIII. START

ACCEPT N1,N2 TOTAL=N1+N2

AVG=SUM/2

STOPIV. CLS

V. TRUEPAGE NO:46 AND 47 SAMPLE ASSESSMENT PAPER-II. ABBREVIATIONS

1.CLS: CLEAR SCREEN2.LOGO:LOGIC ORIENTED AND GRAPHIC

ORIENTED3.BASIC: BEGINNERS ALL PURPOSE

SYMBOLIC INSTRUCTION CODEII. BLANKS

1.LINE2.DESKTOP PUBLISHING3.PROGRAM4.GRAPHICAL5.REMARK

III. TRUE OR FALSE1.F2.F3.F

IV. CHOOSE THE CORRECT ANSWERS1.D2.D3.C

V. MATCH THE FOLLOWING1.B2.C

3.E4.A5.D

CHAPTER-55.NETWORKING CONCEPTS

I. BLANKS1.NETWORK2.CLIENT3.SERVER4.NIC5.MODEMII. MCQ1.B2.D3.C4.C5.B

III. TRUE OR FALSE1.F2.T

3.F4.F 5.TIV ABBREVIATIONS1.DNS: DOMAIN NAMING SERVICE2.HTTP: HYPER TEXT TRANSFER PROTOCOL3. IP: INTERNET PROTOCOL4. LAN: LOCAL AREA NETWORK5. TCP: TRANSMISSION CONTROL PROTOCOLV QUESTION AND ANSWERS

Q 1) WHAT IS A NETWORK?ANS) A COMPUTER NETWORK IS A COLLECTION OF COMPUTERS CONNECTED EACH OTHER

Q2) EXPLAIN ANY THREE ADVANTAGES OF NETWORK?ANS) HARDWARE SHARINGSOFTWARE SHARINGCOMMUNICATION INTERNET SHARINGRELIABILITY

Q3) WHAT IS INTERNET HOW IT IS DIFFERENT FROM EXTRANET?ANS) INTRANET: THE INTERNET IS A PRIVATE NETWORK USED IN ORGANIZATION WHERE AN EMPLOYEE IS HAVING RESTRICTION TO ACCESS INTERNETEXTRANET: THE EXTRANET IS A PUBLIC NETWORK WHERE EVERYONE CAN ACCESS TO INTERNET WITHOUT RESTRICTIONS.Q4) DIFFERENTIATE BETWEEN A SERVER AND A CLIENT?ANS)Q5) WHAT IS LAN AND WAN?LAN: IN LAN TWO OR MORE COMPUTERS AND PERIPHERAL DEVICES ARE CONNECTED WITHIN A SMALL GEOGRAPHICAL AREA OF NETWORKWAN: A WAN IS A LARGE COMPUTER NETWORK MADEUP OF SMALLER NETWORKS SUCH AS TWO OR MORE LANS

CHAPTER-66.WORKING WITH MS-EXCEL

I.BLANKS1.UNDO2.REDO3.CLIPBOARD4.HOME5.RELATIVE6.ABSOLUTE7.ABSOLUTE AND RELATIVE8.CELL REFERENCE9.AUTOFILL10. CTRL + YII.TRUE OR FALSE1.F2.F3.F4.T5.T

III. QUESTION AND ANSWERS1. DEFINE AUTOFILL OPTION?ANS) THE AUTOFILL OPTION HELPS US TO AUTOMATICALLY ENTER THE DATA WITHOUT TYPING.

2.WHAT IS CELL REFERENCE? EXPLAIN ITS TYPES?ANS) A CELL REFERENCE IS AN INFORMATION OF A CELL ON A WORKSHEET AND CAN BE USED IN FORMULA.THERE ARE TWO TYPES OF CELLREFERENCES:a)RELATIVE CELL REFERENCEb)ABSOLUTE CELL REFERENCE

3. EXPLAIN UNDO AND REDO OPTIONS?ANS) UNDO: THIS COMMAND IS USED TO REVERSE THE LAST ACTION THAT WE PERFORMEDTHE SHORTCUT KEYR OF UNDO IS: CTRL+Z REDO: THIS COMMAND IS USED TO REPEAT THE LAST ACTION THAT YOU HAVE DONE FOR UNDO COMMAND4.WRITE THE DIFFERENCE BETWEEN COPY AND MOVE COMMAND?ANS) WHEN WE COPY THE CELL THE DATA APPEARS IN BOTH LOCATIONS. WHEN WE MOVE THE CELL, THE DATA APPEARS ONLY AT WHERE YOU PASTE PAGE NO-77 3RD LET’S REVIEW

I.MATCHING1. D2.C3.A4.BII. DNS STANDS FOR:DOMAIN NAME SYSTEMIII.CIV.SERVERV.TRUEVI.REDOVII WRITE THE PROCEDURE TO FILL THE DAYS IN CELL

a.Type the first day of the weekb.Select the cell which contains first day of the

weekc.Move the mouse pointer exactly on the autofilld. As soon as you move mouse pointer onto the

handle it changed as ‘+’ symbole.Click and hold left mouse buttonf. Drag down the mouseg.You will see week days will be filled

automatically

CHAPTER-77. MORE ON MS-EXCEL

I.BLANKS1.FUNCTION2.FORMAT TABLE3.LEFT,CENTER,RIGHT4.CHART5.CONDITIONAL FORMATTINGII.TRUE OR FALSE1.F2.T3.T4.F5.FIII.QUSTION AND ANSWERSQ1) DEFINE FUNCTION AND CHART?ANS) FUNCTION: A FUNCTION IS A PREDEFINED FORMULA AVAILABLE IN EXCEL TO PERFORM CALCULATIONS.EVERY FUNCTION SHOULD BEGIN WITH = SIGN.EXAMPLE: =SUM(A2:E2)CHART: A CHART IS A GRAPHICAL REPRESENTATION OF DATA.Q2) WHAT IS CONDITIONAL FORMATTING?

CONDITIONAL FORMATTIONG MEANS APPLYING FORMATTING TO ONE OR MORE CELLS BASED ON THE VALUE OF A CELL.Q3) WRITE THE USES OF THE FOLLOWING FUNCTIONS?A)DATE: THE DATE FUNCTION CONVERTS THE CELL VALUE INTO DATE FORMET.SYNTAX: =date(year,month,day)EXAMPLE: =date(1993,02,01)TIME: THE TIME FUNCTION CONVERTS HOURS,MINUTESAND SECONDS GIVEN AS NUMBERS INTO TIME FORMAT.SYNTAX: =time(hours,minutes,seconds)EXAMPLE: =time(12,01,10)SUM: THE SUM FUNCTION HELPS US TO ADD VALUES INTO CELL AND DISPLAY SUM VALUES.SYNTAX: =SUM(E2:V2)AVERAGE: THIS FUNCTION HELPS US TO FIND THE AVERAGE OF SELECTED CELLS.SYNTAX: =average(E2:V2)

CHAPTER-88.WEB CONCEPTS

I.BLANKS1. ELECTRONIC MAIL2. E-MAIL

3. NOMINALII TRUE OR FALSE1.T2.F3.T4.T

IV. QUESTION AND ANSWERSQ1) WHAT IS AN E-MAIL?ANS) E-MAIL STANDS FOR ELECTRONIC MAIL. E-MAIL IS A WAY OF SENDING AND RECEIVING MESSAGES TO PEOPLE THROUGH INTERNETQ2) EXPLAIN ANY FOUR ADVANTAGES OF E-MAIL?ANS)a.WE CAN SEND E-MAIL AT FREE OF COST.b.E-MAILS ARE FAST AND SAVE TIMEc.E-MAIL DO NOT NEED ANY PAPERd.WE CAN ATTACH PICTURES,VIDEOS,MUSIC TO

E-MAILSe.WE CAN READ,PRINT,FORWARD,REPLY OR

DELETE THE RECEIVED MESSAGES.Q3)WRITE THE STEPS TO ATTACH A FILE INTO E-MAIL?ANS)

a) OPEN THE WEB-BROWSER b)TYPE gmail.com IN URL(uniform resource

locator)c)ENTER THE USER ID AND PASSWORDd)CLICK ON SIGN IN OPTIONe)CLICK ON COMPOSE OPTIONf) ENTER THE EMAIL ID OF THE RECEIVERg)CLICK ON ATTACHMENT ICONh)SELECT THE FILE YOU WNTED TO SENDi) CLICK ON OPEN BUTTONj) CLICK ON SEND BUTTON

PAGE NO:109 4TH LET ’S REVIEWI. FUNCTIONII. TRUEIII. CENTER ALIGNMENTIV. Type =sum(c2:e2) in f2 and press enter

key. Later apply autofill option for f3 to f6

V. TRUEPAGENO: 112 AND 113 SAMPLE ASSESSMENT PAPER-III. ABBREVIATION1. WAN: WIDE AREA NETWORK2. FTP: FILE TRANSFER PROTOCOL3. E-MAIL: ELECTRONIC MAIL

II. BLANKS1. NOMINAL2. LEFT,CENTER,RIGHT3. MODEM4. CTRL+Y5. At-the-rate

III. CHOOSE THE CORRECT ANSWER1. B2. B3. C4. A

IV. TRUE OR FALSE1. T2. F3. F