Networking Magical windows-5

 Networking

Exercise Solution

A.            Tick (P) the correct alternative :

1.            LAN stands for :

(a)          Local Area Network   

(b)         Star Topology

(c)          Wide Area Network      

(d)         Internet

2.            In batch processing jobs are served on the basis of:

(a)          FIFO     

(b)         LIFO

(c)          Request              

(d)         None of these

 

B.            Write T' for true and 'F' for false statement:

1.            Network makes a system fast. - True

2.            CPU allocates an equal amount of time to all the users in time sharing system. - True

3.            Multiprocessing can be done only on multiprocessor system. - True

4.            In Star Topology, the whole network collapses, if server collapses. - True

5.            A Real Time system does not response within the required time. – False

 

C.            Fill in the blanks :

1.            A computer can be connected to others via       cable  or             satellite.

2.            Modem is used to convert digital signal into      analog                and vice versa.

3.            Batch Mode is suitable only when processing of data is required in batches.

4.            CPU is the heart             of computer.

5.            Indian Railway Reservation System is the example of  real time system.

 

D.            Answer the following questions:

 

1.            How does data travel in LAN?

Ans:  In LAN network data is travelled via an independent wire or telephone wire.

 

2.            What is a Computer Network?

Ans; when more than one computer is connected together and interact with each other via cabl or satellite they form a computer network.

 

3.            What are the advantages of Networking?

Ans:

1)     Resources like printer, modem and hard disk can be share across network.

2)     Data and information are always available on the net.

3)     Messages are broadcast very quickly to all user connected with net.

4)     Ideas can be shared on the net as and when required to solve a problem among users.

 

4.            How does data travel from one computer to another in WAN?

Ans:  First digital data is converted into analog form by MODEM after which analog signal is travelled to different geographical location using telephone wire or satellite. After reaching destination it than convert analog to digital and information is used by target computer.

5.            Describe the Network Topologies.

Ans: The different way in which computers are connected to each other through Net is called Topology.

1. Bus Topology: All the nodes and server are connected on a single bus.

2. Star topology: All computers are connected to the main computer via independent wire or cable.

3. Ring Topology: All nodes and servers are connected in such a fashion that they make a structure of a ring.

Algorithm and Flowchart Magical Windows-5

 Algorithm and flowchart

Exercise Solution

A. Tick (P) the correct alternative:

1. It is a pictorial representation of formal instructions to perform a task :

 (a)      Algorithm                  

(b)       Flowchart

(c)       Program                    

(d)       Software

 2.                                are used to show :                           

(a)       Flow of instructions           

(b)       Input / Output

(c)       Start of flowchart

(d)       End of flowchart

3.                     symbol is used as a :                        

(a)       Decision box             

(b)       Process box

(c)       Connector                 

(d)       Output box

 

4. Sometimes when a process needs to be repeated again and again it can be put in a :

(a)       Decision box

(b)       Flowchart

(c)       Loop

(d)       Output box

 

B. Write 'T’ for true and 'F' for false statement:

1.         Flowcharts begin with stop. - False

2.         Flowcharts generally follows top to bottom or left to right approach. - True

3.         Connectors are used to connect two symbols of flowchart. - False

4.         Problems are broken down into smaller steps using flowcharts. - False

p.         The boxes are chosen as per user's wish. – False

 

C. Fill in the blanks:

1. A flowchart shows the flow of task        or instructions.

2.         Algorithm is a set of formal instruction.   

3. The line shows the            direction in which the flowchart is flowing.

4. Loop is used to repeat     a process again and again.

5.. If alterations are required, the flowchart may require redrawing    completely.

6. Flowcharts generally begin from top to bottom or from  left to right.

 

D. Answer the following questions:

1.         What do you understand by Flowchart?

Ans:  Flow chart is pictorial representation of problems which are broken down into smaller steps for solving a problem and reaching a solution.

 

2.         Write down the limitations of using Flowcharts.

Ans: 

        I.            Complex logic: For program logic is quite complicated leads becomes complex and clumsy.

      II.            Alteration and modifications: if alteration is required redesign or re-drawing of flowchart completely.

   III.            Reproduction: flowchart symbols cannot be types, reproduction of flowcharts becomes a problem.

3.         Write what each of these symbols is used for in a flowchart?

Ans: Home work for student. To be done by student.

 

MS PowerPoint 2007 Magical Windows-5

 MS Power Point 2007

Exercise solution

A. Tick (✓) the correct alternative :

1.            ________                is one of the most powerful tools for creating attractive an

effective presentations.

(a)          MS PowerPoint                             

(b)         Internet

(c)          MS Excel            

(d)         MS Windows

2.            _____      is a presentation software.

(a)          Hardware graphics       

(b)         MS Excel

(c)          MS PowerPoint             

(d)         MS Windows

3.            PowerPoint includes________    different types of views.

(a)          Five      

(b)         Four

(c)          Three 

(d)         Seven

4.            This view fills the computer screen with a slide and is what the audience will s< when they view the presentation :

(a) Normal view             £            

(b)         Slide Sorter view

(c)          Slide Show view

(d)         Notes Page view

5.            This option will leave the WordArt text without a fill color:

(a)          More Fill Colors              

(b)         Textures

(c)          No Fill 

(d)         All of these

 

B. Write T' for true and 'F' for false statement:

1.            PowerPoint includes five different types of views. - False

2.            The slide show view is used for giving an on screen presentation. - True

3.            The slide sorter view is the default view. - False

4.            PowerPoint is one of the most powerful tools for creating attractive and effective presentations. - True

5.            Slide Sorter view is used for giving an on screen presentation. - False

C. Fill in the blanks :

1.            Power point    offers a variety of ways to create a new presentation.

2.            Normal view, slide sorter view and slide show view  are the three types of

PowerPoint views.

3.            The normal view is the default view.

4.            MS windows    is not a presentation software.

5.            You can use WordArt to create stylized              text that is eye catching and professional.

6.  The slide view commands are located on the left  side of the PowerPoint window in Normal view.

 

D. Answer the following questions :

1.Name the three types of PowerPoint views.

Ans: normal view, Slide sorter view and Slide show view.

 

2. What is the difference between Slide Show view and Slide Sorter view?

Ans: Slide show view shows the presentation on full screen for audience and slide sorter view shows small versions of slide where it can be deleted, copied and moved.

 

3. Define Slide Transition.

Ans: Slide transition insert different effects between two slides.

 

4. What is the use of WordArt?

Ans: WordArt  allows you to create stylized text with textures, shadows and outlines.

 

5. Write steps to insert a shape into slides.

Ans:

1)     Select the insert tab.

2)     Click the shapes command.

3)     Click a shape from the menu.

4)     Move your cursor toward the slide.

5)     Click and hold down the mouse button and drag the cursor until the shape is the desired size.

6)     Release the mouse button to insert the shape.

 

6.Write steps to apply shape effect.

Ans:

1)     Select the shape you want to modify. The format tab will appear.

2)     Select the format tab.

3)     Click the shape effects command.

4)     Move your cursor over a menu option and submenu appear.

5)     Move your cursor over submenu to see a live preview of the effect on slide.

6)     Click an option to select the shape effect.

MS Excel 2007 Magical Windows-5

 MS Excel 2007

Exercise Solution

A.Tick (P) the correct alternative :

1. An Excel file is called as :

(a)          Spreadsheet  

(b)         Worksheet

(c)          Document                         

(d)         None of these

2.The basic unit of a spreadsheet is :                                     

(a)          Row     

(b)         Column

(c)          Cell       

(d)         Both (a) and (b)

3. A cell with a dark border around it.                                  

(a)          Cursor 

(b)         Pointer

(c)          Active Cell        

(d)         Column

4.The cell labeled F5 refers to :                                

(a)          Row F column 5             

(b)         Columns

(c)          Column F row 5               

(d)         All of these

 

B.            Write 'T' for true and ‘F’ for false statement:

1.            A spreadsheet is software for handling and manipulating numbers. - True

2.            An Excel file is called a worksheet. - True

 

3.            Cell is the basic unit of spreadsheet. - True

 

4.            A cell is the intersection of a row and    column. - True

 

5.            In Excel 2007 there are 1,048,576 rows. - True

 

C.            Define the following terms:

1.            Cell Address       -  It is location of a cell on the worksheet and defined by column letter and row number.

 

2.            Columns              - Columns are arranged vertically and are named from A to Z .

 

3.            Worksheet         -  A worksheet is a grid of cells.

 

4.            Formula bar      - It displays the cell entries and provides the line for working with formulas.

 

5.            Active cell          - A cell with a dark border around it.

 

D.            Fill In the blanks:

 

1.            Microsoft Excel is a member of               MS Office Software.   

 

2.            Calculations are               error free.

 

3.            Cell        in MS Excel is the basic unit of spreadsheet.

 

4.            A worksheet is a grid   of cells.

 

5.            Formula             entered into a cell begins with an equal = sign.

 

6.            A spreadsheet               is software for handling and manipulating numbers.

 

7.            In Business, to track profit        or to store customer and             employee  data.

 

E.            Answer the following questions:

 

1.            What     is a spreadsheet?

Ans: It is  software for handling and manipulating numbers.

 

2.            What     is MS Excel?

Ans: MS Excel is a spreadsheet package and a member of MS Office software.

 

3.            Write    the advantages of using MS Excel software?

Ans: 

1)     Entering data is faster and easier.

2)     Making changes are easier.

3)     Calculation are error free.

 

4.            Mention three areas where        MS          Excel     can         be           used as a good computing tool. justify your answer with examples.

Ans:

1)     In schools, to organize and track fee or marks information.

2)     At home, it can be used to monitor monthly expenses.

3)     In business, to track profit or to store customer and employee data.

5.Name three places where can a spreadsheet be used.

Ans: School, home and business.

6.What is a worksheet?

Ans:  A spreadsheet is a software for handling and manipulating numbers.

7. Write some advantages of using spreadsheet software.

Ans:

1)     Entering data is faster and easier.

2)     Making changes are easier.

3)     Calculation are error free.