http://oss.reflected.net/jenkins/43174/cm-9-20130929-NIGHTLY-shooteru.zip

DOEACC O LEVEL (NIELIT) M1-R4: IT TOOLS AND BUSINESS SYSTEMS JANUARY 2014 SOLVED QUESTION PAPER.     by Vivek Roy .                            

===============================

1.1Which of the following file extensions does not indicate graphic files?

A)BMP   B)JPEG   C)DOC   D)GIF 

ANS: C)

1.2 In MS-Power Point which layout can be used to display hierarchies of employees in a
Company?

A)Dialog Box   B)Table   C)Pie Chart   D)Organization Chart

Ans:

 1.3The value of Primary key

A)cannot be null   B)can be null   C)can be duplicate   D)none of these

 Ans: A)

1.4What does an electronic spread sheet consists of? 

A) Rows   B)Columns   C)Cells   D)All of the aboveColumns

Ans:D)

1.5 The formula in cell A2 is =B2+C3 on copying this formula in cell C2 the formula will be 

A)=D3+E4   B)=D2+E3    C)=D2+E4   D) =D3+E3

Ans: B)

 1.6)Non-impact based printing device is
A)Dot-Matric Printer  B)Scanner   C)Laser Printer   D)None of the above

Ans: C

1.7) Which of the following shortcut is used to open a new file?
A)CTRL+S
B)CTRL+N
C)ALT+N
D)CTRL+V

Ans: B


1.8)MIS stands for
A)Maintenance Information System
B)Model Information System
C)Management Information System
D)Media Information Source

Ans:C)

 1.9)The Internet is owned by
A)IAB    B)IETF    C)Inter NIC     D)All of the above
 ans: D)

(Who Owns the Internet?

No one actually owns the Internet, and no single person or organization controls the Internet in its entirety.
The Internet is more of a concept than an actual tangible entity, and it relies on a physical infrastructure that connects networks to other networks.
There are many organizations, corporations, governments, schools, private citizens and service providers that all own pieces of the infrastructure, but there is no one body that owns it all. There are, however, organizations that oversee and standardize what happens on the Internet and assign IP addresses and domain names, such as the National Science Foundation, the Internet Engineering Task Force, ICANN, InterNIC and the Internet Architecture Board. )


 1.10)While sending a file or message on the net, it is divided into very small parts known as
A)Point    B)Particle    C)Pin    D)Packet

Ans:D)



2. Each statement below is either TRUE or FALSE. Choose the most appropriate one and
ENTER in the “OMR” answer sheet supplied with the question paper, following
instructions therein.
(1x10)
2.1 A set of instruction which perform a task is called program. True

2.2 A byte is the smallest unit of storage.  False

2.3 Analog computer is a mixture of hybrid and digital computer.False

2.4 Margins are the distance between the text and the edges of the paper.True

2.5 By default, the numbers are left aligned and text is right aligned in a spreadsheet. False
(actually numbers are Right aligned and text is Left aligned)

2.6 If you enter 127A in a cell it will be treated as number in the electronic spreadsheet as it startswith digit. False

2.7 In Access deleted record can be undone.

2.8 Access sorts data only in ascending order. False

2.9 Internet is network of networks. True

2.10 Paperless office & Virtual office are same.False


3.
Match words and phrases in column X with the closest related meaning/
word(s)/phrase(s) in column Y. Enter your selection in the “OMR” answer sheet supplied
with the question paper, following instructions therein.
(1x10)
              X                                                       Y                                                      
3.1 Information                     A. The base of Octal number system                       
3.2 DSS                                 B. Highest transmission text program                     
3.3 LINUX                             C. Returns highest value from cell A1 to A9            
3.4 http                                  D. Software to translate HLL to Machine Code      
3.5 Interpreter                       E. Person to Person Protocols                                 
3.6 PPP                                  F. Hyper text transfer protocol                                 
3.7 ls – l                                  G. Mixed cell reference in electronic spreadsheet  
3.8 $A44                                H. Processed Data                                                   
3.9 8                                       I. Command to get lost list of files in LINUX          
3.10 =max(a1:a9)                  J. Operating System                                                 
                                               K. Point to Point Protocols                                      
                                               L. Command to get long list of files in LINUX        
                                              M. Decision Support System                                     
 

 Ans: 3.1>H      3.2> M  3.3>J   3.4>F    3.5> D   3.6> K    3.7> L     3.8>  G
3.9> A   3.10>C




4.Each statement below has a blank space to fit one of the word(s) or phrase(s) in the list
below. Enter your choice in the “OMR” answer sheet supplied with the question paper,
following instructions therein.
(1x10)







A. LINK     B. 1000          C. MODEM        D. PASTE       E. AUTOSUM        F.CUT/COPIED          G. 1024    H. CAT    I. COMPILER      J. DATABASE  MANAGEMENT SYSTEM    K. CUT     L. DATABASE MODEL SYSTEM    M. HARDDISK


 4.1 The 1KB equals  1024 bytes.

4.2 AUTOSUM is used in electronic spreadsheet to total rows and/or columns.

4.3 The HARDDISK  is the example of Secondary memory.

4.4 Short-cut CTRL+X is used to  CUT.

4.5 DBMS stands for DATABASE  MANAGEMENT SYSTEM

4.6 The command to view the contents of a file in LINUX is   CAT

4.7 COMPILER translates a program written in high-level language into machine code.

4.8 Foreign Key is used to LINK the given table with other table.

4.9 A Clipboard is used for keeping the CUT/COPIED  text.

4.10 MODEM is a device to convert digital signal to analog & vice versa.

PART TWO
(Answer any FOUR questions)

5.A) Draw a block diagram of basic units of the Computer System. List various sub units of the CPU
and give the function of each of the units.
















5.b)  i)Convert:i)(7706)8 to Hexadecimal  ii)(7305) 10 to Octal.

AIRTEL 655 UNLIMITED PLAN.

AIRTEL 3G UNLIMITED PLAN.

====================

AIRTEL 3g plan is a JOKE to us. where they said after 3g.b you can surf @80 K.b/ps . But after 3GB you cant able to access internet. they are fraud , Beti-Ch**d .


never use any wireless 3g unlimited . as they whatever said its unlimited its totally BAKWASS!

IT TOOLS AND APPLICATIONS January 2008 solved / with answer question paper.

1.1       Which one is not an output device?

A)Printer  B)Monitor C)Keyboard D)Modem Ans: Keyboard

1.2       An operating system is:

A)Integrated software B)CD-ROM software C)Application software  D)System software

Ans: System software

1.3       One MB is equal to:

A)The amount of RAM in every computer B) 1 billion bytes C)1024KB D)1 thousand bytes

Ans- 1024 k.b

1.4       The resolution of a printer is measured in:

A) Megabits B) Hz C)Dots per inch (DPI) D)Inches (diagonal)

Ans: C

1.5       A computer port is used to:

A)Communicate with other computer peripherals
B) Download files from the web
C)Communicate with all hard drives
D)Connect computers together

 Ans: A

1.6       Which file extensions indicate only graphics files?

A) BMP and DOC

B) JPEG and TXT

C) TXT and STK

D)  BMP and GIF Ans :d




1.7       Which one is an e-mail address?

A)        http://vianet.com/index.htm

B)        D:\\Email\Standard

C)        joesmart@billme.com

D)        Chaminade.org/teachers/mailaddresses Ans: C

1.8       To insert clip art, pictures from disk into a Word Document, which of the following method is used?

A)        Insert Picture command
B)        Insert Object command
C)        Add Picture command
D)        Insert File command 

1.9       Which of the following is not a tool for analyzing spreadsheet data?

A)        What-if analysis
B)        Mail merge
C)        Goal seeking
D)        Sorting






1.10     The multiplication arithmetic operator is represented by which of the following symbols?

A)        ^

B)        *

C)        /

D)        x   Ans: B

2.         Each statement below is either TRUE or FALSE.   Choose the most appropriate one

and  ENTER  in  the    “tear-off”  sheet  attached  to  the  question  paper,  following

instructions therein.                                                                                                            (1x10)

2.1 If the text entered in a cell does not fit, Excel will display ##### to indicate that the text is too long. True

2.2 A mouse is a pointing device. True

2.3  An example of an input device is a printer. False

2.4  Microsoft office word is an application program. True

2.5  When you download files you send files from your computer to the Internet. False

2.6 A bit is bigger than a byte. False

2.7 An inkjet printer hammers rows of pins against paper to produce words or pictures. False

2.8 You can add dates to worksheets, but spreadsheets cannot use dates in calculations. False

2.9 In a spreadsheet, ordinary text is called a "label." True

2.10   Presentation programs create notes for each slide, which are visible only to the presenter.

3.   Match  words  and  phrases  in  column  X  with  the  closest  related  meaning/

word(s)/phrase(s) in column Y.   Enter your selection in the “tear-off” answer sheet

attached to the question paper, following instructions therein.                              (1 x 10)
X                                                                                      Y


3.1      Approximately a billion bytes or 10000 megabytes           A.      Text

3.2      A printed copy of computer output                                    B.      MODEM

3.3      The  use  of  graphical  symbols  instead  of  text             C.      vi

commands to control common computer functions

3.4      The programs or instructions that tell the computer          D.      Hard Copy

what to do.

3.5      The sequence of operations that defines a solution to       E.      Multimedia

a problem in logic.

3.6      A communications device which converts electronic       F.      Graphical User Interface

signals  from  one  kind  to  another  for  transmission

over  circuits  such  as  telephone  lines,  cable  lines,

microwave, satellite, etc.

3.7      A permanent storage device, which uses a laser disk      G.      Spreadsheet

to read information

3.8      A combination of text, graphics, sound and animation      H.      Slide Show

3.9      What  would  be  the  best  program  for  calculating         I.       del

numbers

3.10    Linux command                                                                  J.      CD ROM

K.      Gigabyte

L.      ALGORITHM

M.     Router

N.      Software

Ans: 3.1> k  3.2>d  3.3>F  3.4>N 3.5>L  3.6>B  3.7>J  3.8>E

4.         Each statement below has a blank space to fit one of the word(s) or phrase(s) in the

list below.   Enter your choice in the “tear-off” answer sheet attached to the question

paper, following instructions therein.                                                                         (1 x 10)

A.   Operating system                  B.   Virus                                      C.    Insert

D.   MegaHertz                             E.   Volatile                                   F.    Sectors

G.   Clipboard                               H.   Ctrl+Enter                               I.      Word Processor

J.    JPEG                                    K.   Upper                                     L.    Lab leader

M.   Icon                                       N.   Case                                      O.    ASCII

4.1  RAM is a(n) ________ memory.

4.2  Ms-word is an example of a(n) ________.

4.3  The ________ generally controls interaction of the application software and all the hardware

components.

4.4  In Unix, commands are ________ sensitive.

4.5  ________ is the name of a code used to represent characters.

4.6  The ________ is a section of RAM where your computer stores copied data.

4.7  ________ is a format for image files.

4.8  The feature that moves text to make room for new words as they are keyed is called ________

mode.

4.9  ________  is  a  small  picture  or  symbol  representing  a  computer  hardware  function  or

component.

4.10The speed of the clock chip is measured in ________.

PART TWO

(Answer any FOUR questions)

5.

a)         Convert (7305)8 to Binary and (1023)10 to Hexadecimal.

b)         Mention the basic functional units of a computer?

c)         What are the differences between RAM and ROM?

d)         What is the difference between systems software and applications software?

(4+4+3+4)

6.

a)         What is the difference between impact and non impact printer?

b)         Explain primary memory and its properties and types?

c)         List and explain any two input and output devices.

d)         With a neat diagram explain the working of a mouse.

(3+4+4+4)

7.

a)         You may prefer your Word documents or multiple page letters to be printed without any

numbering on the first page, how is it achieved?

b)         Define and explain how to adjust “Line spacing” & “paragraph spacing” in Word a document.

c)         In Power Point, explain using a custom animation effect, how do you make text appear on a

slide letter by letter?

(5+5+5)

8.

a)         What is the difference between Embedded charts and Chart Sheet? What are Legends and

how to add on the chart?

b)         What is the difference between relative and absolute references?

c)         In  Excel,  we  have  three  functions  named  a  ROUND(),  ROUNDDOWN(),  ROUNDUP();

how these are different? Explain with examples.

(5+5+5)

9.

a)         What is a compiler?   Give the differences between compiler and interpreter?

b)         Explain the functions of an operating system?

c)         What are the internal tasks or activities involved during booting of a computer?

(5+5+5)

Doeacc A level M1-R4 Answer Sheet january 2013

Doeacc A level M1-R4 Answer Sheet january 2013

O LEVEL JANUARY 2013 SOLVED / WITH ANSWER Question paper . IT Tools and Business System. M1-R4.

 It tools and business system previous year solved papers January 2013 are helpful Doeacc/Nielit student prepare for his upcoming exam July 2014

1. Each question below gives a multiple choice of answers. Choose the most appropriate one and enter in the “tear-off” answer sheet attached to the question paper, following instructions therein.                                           (1x10)



1.1 Decimal equivalent of the binary number 110111 is:
A) 55
B) 56
C) 57
D 58
Ans:55

1.2 Numbers in base 10 are called as
A) Octal System
B) Hexadecimal System
C) Decimal System
D) Binary Numbering System
Ans: Decimal System

1.3 MIDI stands for
A) Medium Interface for Digital Input
B) Musical Instrument Digital Interface
C) Musical Input for Digital Interface
D) Musical Interface for Digital Input 
Ans: B) Musical Instrument Digital Interface

1.4 Purpose of Arrange All option in the Word menu is
A) to align all the paragraphs in a Word document
B) to align all the open Word documents on screen for easy accessibility
C) to arrange all open Word files alphabetically
D) none of the above
Ans: to align all the open Word documents on screen for easy accessibility
 
1.5 Payroll system is a typical example of
A) Batch processing
B) On-line processing
C) Real time processing
D) None of the above 
Ans: Batch processing
 
1.6 A collection of worksheets is called as
A) Excel Sheets
B) Workbook
C) Excel worksheets
D) Excel Book
Ans: Workbook
 
1.7 The Save As dialog box can be used
A) for saving the file for the first time
B) to save file by some alternative name
C) to save file in a format other then Word
D) all of the above
Ans: all of the above
 
1.8 To paste text from the clipboard in the document being edited, press the keys
A) Ctrl and V
B) Ctrl and X
C) Ctrl and A
D) Ins
Ans: Ctrl and V
 
1.9 A bitmap is
A) A graphic file format made up of small dots
B) A specific kind of bitmap file with the .BMP extension
C) Is a format which windows use for desktop wallpaper
D) All of the above
Ans: All of the above
 
1.10 To change the cell reference C4:C9 to an absolute cell reference, you would enter it as
A) C4:C9
B) C$4:C$9
C) $C$4:$C$9
D) None of the above
Ans: $C$4:$C$9

2. Each statement below is either TRUE or FALSE. Choose the most appropriate one and ENTER in the “tear-off” sheet attached to the question paper, following instructions therein. (1x10)

2.1 An object, such as a paintbrush picture and word document can be inserted in a worksheet. True

2.2 Both the functions - NOW() and TODAY() can be used to display the current time. False

2.3 The Recycle Bin is a folder that provides a convenient place to store frequently used documents, graphics and other files. False

2.4 The Internet Protocol addressing system is deployed to keep track of the users connected to the Internet. False

2.5 References that have either a column or a row value absolute and the other relative are known as mixed references. False

2.6 The IF() function evaluates a condition and takes one of the two specified actions depending on the result of the evaluation. True

2.7 Windows clipboard can hold multiple pieces of information at the same point of time. False

2.8 H₂SO₄ is written in Word using superscript feature. False

2.9 There are only two types of page orientation – portrait and landscape. True

2.10 The process of merging the master document and the data source is called as Mail Merge. True

3. Match words and phrases in column X with the closest related meaning/word(s)/phrase(s) in column Y. Enter your selection in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

X		Y
3.1	In the year 1969, Department of Defence of the United States started a network called (G)	A.	Binary
3.2	A device that accomplishes modulation and demodulation (L)	B.	Insert
3.3	Number system to the base 2 (A)	C.	Word Wrapping
3.4	The first screen that appears after the computer is switched on (I)	D.	Shortcut
3.5	While creating a word document, when the insertion point reaches the end of the line, it automatically moves to the next line. (C)	E.	Worksheets
3.6	The menu on which the WordArt option is available (B)	F.	What-if analysis
3.7	It is a collection of worksheets (E)	G.	ARPAnet
3.8	Readymade formulas of Excel (J)	H.	View
3.9	Automatic recalculation of result of a formula if the data is changed (F)	I.	Desktop
3.10	The icons with an arrow in Windows Desktop (D)	J.	Functions
		K.	Program
		L.	MODEM
		M.	INTRANET

4. Each statement below has a blank space to fit one of the word(s) or phrase(s) in the list below. Enter your choice in the “tear-off” answer sheet attached to the question paper, following instructions therein. (1x10)

A.	CTRL X	B.	Codeword	C.	Clip Art
D.	Leader	E.	36	F.	55
G.	Slide View	H.	Spreadsheet	I.	Calibri
J.	Password	K.	Database	L.	Compiler
M.	12+24

4.1 A worksheet can be protected using a ____ .

Ans: Password

4.2 If you enter 12+24 in a Excel cell, it will display the result as ___ .

Ans: 12+24

4.3 The ____  command cuts the selected text and graphics and puts it on a clipboard.

Ans: CTRL X

4.4 The character that fills the space up to the next tab stop position is called the ____ character.

Ans: Leader

4.5 ____ is a name of a Font.

Ans: Calibri

4.6 ___ is the decimal equivalent of 100100.

Ans: 36

4.7 ____ view allows you to work on individual slides in a presentation software.

Ans: Slide View

4.8 ____ is a gallery of ready-made graphics available in presentation software.

Ans: Clip Art

4.9 ____ is a program to convert high level language into machine language.

Ans: Compiler

4.10 An arrangement of data in a particular order is called as a ____.

Ans: Database

Micromax 3g datacard MMX377G Installation in ubuntu, lubuntu, kubuntu, xubuntu ...

Installing usb modem in linux is quite difficult to new user like me in linux, I also got trouble to install usb modem driver in LUBUNTU. so searched over internet and get a good sollution...

here is the process

1. Pre-check before install the software

Insert the SIM card into the 3g dongle and plug the device into your computer or laptop USB Port.

Now check the plugged device using following command. Open your terminal (ctrl+T) and enter this command.

?

>ls /dev/sr*

Above command must be return the all devices the SCSI-CDROM’s that mounted on your machine. You may get the below result in your terminal

/dev/sr0

If you have more than one device connected you may see like below. To confirm which one is correct device that linked with your dongle. We need to unplug and execute the same command and see which device is disappeared from previous list. Then re plug and execute the command, now you can see that device back. Your current device maybe linked with /dev/sr1 or /dev/sr2 or anything else.

/dev/sr0 /dev/sr1 /dev/sr3

There is another case also, when you run ls /dev/sr* comand you may receive the following result. If you get this message, the software is already installed. We will see unintallation step at last. If you are not getting this message no problem go with step 2.

ls: cannot access /dev/sr*: No such file or directory

2. Mount the device.

Navigate to users Home directory in your terminal and enter the following command to mound the device.

?

>sudo mount /dev/sr0 /mnt

It will prompt the password, after entering the password you should receive following message

mount: block device /dev/sr0 is write protected, mounting read-only.

Now you can check the result of mount by executing below command

?

>cd /mnt  >ls

Now you will see all the installation packages of the device. We can notice see the two different package for 32-bit and 64-bit machine. We need to install the package according to that.

32-bit = 3g_modem_connect_D301_MMX_i3386.deb
64-bit = 3g_modem_connect_D301_MMX_amd64.deb

3. Installation, Lets consider for 64-bit, enter the following command.

?

> sudo dpkg -i 3g_modem_connect_D301_MMX_amd64.deb

When Installation finished. Unplug your Micromax 3g Datacard from your computer and re plug. Now it will connect to internet automatically, if device lock and Pincode is disabled.

4. We can check the COM port using this command.

?

>ls /dev/tty*

Now you can notice at the end of list with following

/dev/ttyUSB0
/dev/ttyUSB1
/dev/ttyUSB2
/dev/ttyUSB3

4. Connect to the Internet.

?

>sudo 3g_connect.sh ttyUSB0

When you enter this command, you will be getting connection progress, finally you will receive “pppd is connected” message.

Note : If your device lock is enabled, it will ask device code. so we need to enter the device code for further process. Default device code is “1234″.Share on TumblrNote : If your device lock is enabled, it will ask device code. so we need to enter the device code for further process. Default device code is “1234″.

now check your internet connection

?

>ping www.google.com

5. Disconnect from internet

?

>killall pppd

Use this command to terminate the internet connection.

Uninstall Micromax 3g datacard software

To uninstall the previous installation enter the following.

?

>sudo dpkg -r 3g_modem_connect_D301_MMX_amd64.deb

Hope this post will be very helpful when you lost your guide book or away from it. Happy browsing using Micromax 3g datacard MMX377G.

source :http://code-cocktail.in/micromax-3g-datacard-mmx377g-installation-ubuntu/

and if you cant find any device in /dev/sr* (sr0,sr1...)

then follow this step...

Please remove the modem, wait for about 10 seconds. Then plug it back in --> wait for about 1 minute --> run the following commands and post back their outputs -

Code:

lsusb dmesg | tail -20 lsmod usb-devices | grep -iA14 -B4 2020 modprobe -c | grep -i 2020.*4010

..And, just to see if we can get the drivers located on the modem itself, please try this -

Code:

sudo sed -i '/^Disable/ s:0:1:' /etc/usb_modeswitch.conf

Now unplug --> replug the modem and re-check-

Code:

lsusb

Do you see the ID 2020:0002 device again (or anything other than 4010 with 2020)? If not, reboot and try again. Now? If yes, what does this tell us -

Code:

ls /dev/sr*

PS:

The above change to the /etc/usb_modeswitch.conf file will disable the modeswitching so that we can access the storage (virtual cd) part of the modem. To be able to use it as a modem again, you will have to change the value "1" back to "0" with -

Code:

sudo sed -i '/^Disable/ s:1:0:' /etc/usb_modeswitch.conf

However, I suggest you keep it to "1" until we can copy the driver off its storage part. As soon as it is done, change it back to "0" with above command (you can of course also edit it with your GUI text editor, opening it as root). 

source: http://ubuntuforums.org/showthread.php?t=2175420