Q-2 Insert at least 10 students record in MS Excel having column 'roll no.

,
name , marks and semester.
B. Perform filter operation in different columns.

Roll No Name Marks Semester

1 John Doe 85 1
2 Jane Smith 78 1
3 Jim Brown 90 2
4 Lisa White 72 1
5 Tom Green 88 2
6 Sarah Black 94 3
7 Mary Blue 81 3
8 Mark Yellow 76 2
9 Anna Red 85 1
10 Luke Gray 93 3

Steps for performing filter operation in different columns.

1. Select the entire dataset , including headers.

2. Go to the Datatab and click on the Filter Option.
3. A drop-down arrow will appear next to the each column header.
4. Click on the drop-down arrow of the column you want to filter (e.g. 'Sem).
5. Choose the specific semester's you want to view (e.g. 'Semester 1').
6. Similarly, Same for the other's column.

After applying filter on the semester column.

Roll No Name Marks Semester
1 John Doe 85 1
2 Jane Smith 78 1
4 Lisa White 72 1
9 Anna Red 85 1
Q-2. Insert at least 10 students records in MS Excel having column ‘roll no,
name , marks and semseter.
C. Insert a column name- percentage and calculate all percentages
using formula.

Roll No Name Marks Semester Percentage

1 John Doe 85 1 85%
2 Jane Smith 78 1 78%
3 Jim Brown 90 2 90%
4 Lisa White 72 1 72%
5 Tom Green 88 2 88%
6 Sarah Black 94 3 94%
7 Mary Blue 81 3 81%
8 Mark Yellow 76 2 76%
9 Anna Red 85 1 85%
10 Luke Gray 93 3 93%
Q-2 Insert at least 10 students record in MS Excel having column 'roll no. , name , marks and
A. Perform sorting operations using single parameter and multiple parameter.

Roll No. Name Marks Semester

3 Smith 78 2
9 Emma 79 3
6 Mark 80 3
1 John 85 1
4 Head 88 3
10 Loki 89 2
7 Chris 91 1
2 Jarvis 92 1
5 Olivia 95 2
8 Michaeel 98 1

Steps for Sorting Operations

Multiple parameter sorting operation

1. Select the data range (for ex : A4:D14)

2. Go to the Data tab
3. Select on the sort
4. In the sort dialog box, click add level to add another sorting cretion
5. In the first level , sort by marks (Ascending/Descending)
6. In the second level , sort by semester (Ascending/Descending)
7.Click Ok
name , marks and semester.
Q-2 Insert at least 10 students record in MS Excel having column 'roll no. , name , marks and
A. Perform sorting operations using single parameter and multiple parameter.

Roll No. Name Marks Semester

3 Smith 78 2
9 Emma 79 3
6 Mark 80 3
1 John 85 1
4 Head 88 3
10 Loki 89 2
7 Chris 91 1
2 Jarvis 92 1
5 Olivia 95 2
8 Michaeel 98 1

Steps for Sorting Operations

Single Parameter Sorting Operation

1. Select the range of data (for ex: A4:D14)

2. Go to the data tab.
3. Click on Sort
4. In the sort dialog box , choose "marks" as the column to sort by.
5. Choose either Ascending (smallest to largest) or Descending (largest to smallest) order.
6. Click Ok
name , marks and semester.

smallest) order.
Q-13 Run the external commands CHKDSK and SCANDISK.

#CHKDSK Command

The CHKDSK command is used to check and repair errors on a disk

#Syntax

CHKDSK [drive:] [/F] [/V] [/R] [/X] [/C] [/I] [/B]

#Options

-/F Fixes errors on the disk.

-/V Displays the full path and name of every file on the disk.

-/R Locates bad sectors and recovers readable information.

-/X Forces the volume to dismount if it is currently in use.

-/C Skips checking of cycles within the folder structure.

-/I Performs a minimum check of index entries.

-B Re-evaluate bad clusters on the volume.

#Examples

To check and repair errors on the C:drive, use:

CHKDSK C:/F
To check and repair errors on the C:drive , locating bad sectors and
recovering readable information, use:

CHKDSK C:/ F / R

#SCANDISK Command

The SCANDISK command is used to scan and repair errors on a disk.

#Syntax

SCANDISK [drive:] [/F] [/C]

#Options

-/F Fixes errors on the disk

-/C Displays a summary of the scan

#Example

To scan and repair errors on the C:drive, Use:

SCANDISK C:/F

To scan the C:drive and display a summary of the scan, use:

SCANDISK C:/C
Q-12 Run the following commands -:

a. Tree

b. Deltree

c. Print

d. Xcopy

#Tree

The TREE command is used to display the directory structure of a drive

or a specific directory.

Syntax

TREE[drive:][path] [/F] [/A]

Options

-/F Displays the files in each directory.

-/A Displays the directory structure using ASCII characters instead of

graphic characters.

Example

To display the directory structure of the current directory, use:

TREE

To display the directory structure of the C:\ Windows directory, including

files, use:

TREE C:\Windows /F

#Deltree Command

The DELTREE command is used to delete a directory and all its

subdirectories and files.

Syntax

DELTREE [/Y] [drive:][path]

Options

-/Y Suppresses the confirmation prompt.

Example

To delete the C:\Temp directory and all its contents, use:

DELTREE c:\Temp

To delete the C:\Temp directory and all its contents without confirmation,
use:

DELTREEE /Y C:\Temp

#Print Command

The PRINT command is used to print a text file.

Syntax

Print [/D:device] [drive:][path] filename

Options

-/D:device Specifies the print device

Example

To print the C:\Documents\example.txt file, use:

Print C:\Documents\example.txt

To print the C:\Documents\example.txt file to a specific printer (e.g.

LPT1), Use:

Print /D:LPT1 C:\Documents\example.txt

#Xcopy Command

The XCOPY Command is used to copy files and directories.

Syntax

XCPY [source] [destination] [/A | /M] [/D[:date]] [/P] [/S] [/E] [/V] [/W]

Options

-/A Copies only files with the archive attribute set.

-/M Copies only files with the archive attribute set and clear the attribute.

-/D[:date] Copies files changed on or after the specified date.

-/P Prompts for confirmation before copying each file.

 -/S Copies directories and subdirectories.

-/E Copies all sbdirectories, even if they are empty.

-/V Verifies the size of each new file.

-/W Displays the file being copied.

Example

To copy the C:\Source\example.txt file to the C:\Destination directory, use:

XCOPY C:\Source\example.txt C:\Destination

To copy all files and subdirectories from the C:\Source directory to the
C:\Destination directory, use:

XCOPY C:\Source\*.*C:\Destinantion /S /E.p

Q-11 Run the ATTRIB command in MS-DOS on a existing file changing the
attributes R, H, A.

To run the ATTRIB commands in MS-DOS, follow these steps:

#Open MS-DOS Command Prompt

Open the MS-DOS command prompt. If you’re using a modern windows

version, you can do this by typing “cmd” in the Run Dialog Box (Windows

key +R).

#Navigate to the File Location

Navigate to the directory where the existing file is located using the CD

command.

#Run the ATTRIB Command

Once you’re in the correct directory, run the ATTRIB command with the
desired attributes. To change the attributes R(Read-Only), H(Hidden) and
A(Archive), use the following syntax:

ATTRIB [+/-]R [+/-]H [+/-]A filename

Replace “filename” with the name of your existing file.

#Explanation of Options

- + sets the attribute.

- - clear the attribute.

#Example

To set the Read-Only, Hidden, and Archive attributes for a file named
“example.txt” , use:

ATTRIB +R +H +A example.txt

To clear these attributes, use:

ATTRIB -R -H -A example.txt
Q- 9. Write an algorithm and draw the flow chart on MS Word to print all even
numbers between 1 to 100.

Algorithum

1. Start

2. Initialize the variable i to 2

3. While i<=100 , if Yes then go to step 4 , if No then go to step 7

4. If i%2==0 , if Yes then go to step 5 and after step 6 , if No then go to step 6

and after step 3

5. Print the value

6. Increment in value of i

7. Stop

Flowchart

Start

Initiliaze variable i =2

Is i<=100 No

Yes

Is No
i%2==0
?

Yes

Print i

i = i+1

Stop
Q-10. Write an algorithm and draw the flow chart on MS Word to calculate the
factorial of given number.

Algorithum

1. Start

2. Input Number

3. Set Fact=1 , i=1

4. Check condition i<=number , if false go to step 7

5. Fact = Fact * i

6. Update i=i+1 , after go to step 4

7. Display Fact

8. Stop

Flowchart

Start

Read Number

Fact = 1 , i=1

i<= number

Fact = Fact * i Display Fact

i=i+1

Stop
Q-8 Write an algorithm and draw the flow chart on MS Word to print the table
of a given number

Algorithum

1. Start

2. Input a number i.e. N.

3. Let A=1

4. Multiply A and N i.e.

M=A * N

5. Display 5

6. Increase A by 1 i.e. A=A+1

7. Is A<=10?

If Yes, repeat steps 4 to 7

If No, go to step 8

8. Stop

Flowchart

Start

Input N

A=1

M=A*N

Display M

A=A+1

Is A<=10? Yes

No

Stop
 Q-6 Write an algorithm and draw the flow chart on MS Word to find
greatest number from three numbers entered by the user.

Algorithum

1. Start

2. Input: Enter any three number , ex- 1 , 2 , 3 .

3. Compare:

 If 1 > 2 and 1 > 3 , then 1 is the greatest.

 If 2 > 1 and 2 > 3 , then 2 is the greatest.
 Else , 3 is the greatest.

4. Output: Display the greatest number.

5. End

Flowchart

Start

Input 1 , 2 , 3

Yes If 1 > 2 No

No No If 2>3
If 1>3

Yes Print 3 as greatest Yes

Print 1 as greatest Print 2 as greatest

Stop
Year No. of Admissions Gen OBC SC/ST Male Female
2021 800 450 300 50 500 300
2022 950 520 340 90 510 440
2023 1180 690 380 110 630 550
2024 1300 750 430 120 650 650
2025 1450 800 450 200 750 700
2026 1600 850 480 270 800 800
2027 1700 900 500 300 850 850
2028 1850 950 550 350 900 950
2029 1900 1000 600 350 950 950
2030 2000 1100 650 350 1000 1000

2021 Category Chart Bar Chart for Gender for All Years
1200
1000
800
600
400
200
0
1 2 3 4 5 6 7 8 9 10
Gen OBC SC/ST Male Female

A B

Progress line chart for no. of admission in

year 2021 to 2030
2500

2000

1500

1000

500

0
1 2 3 4 5 6 7 8 9 10

C
 Q–7 Write an algorithm and draw the flow chart on MS Word to check whether the
given number is prime or not.

Algorithum

1. Start

2. Read a “n” value to check prime or not.

3. Set i=1 , count=0.

4. If i<=n if true go to the step 5 , else go to step 8.

5. Check the condition n%i==0 if true then evaluate step 6 , if false go to step 7.

6. Set count = count+1.

7. i=i+1 go to step 4.

8. Check count ,if count =2 display prime, if not display it is not prime.

9. Stop

Flowchart

Start

Read n

Set i=1, count =0

No Yes
I<=n
n

Yes Count No Yes n%i ==0

==2

Display n Display n is
No
is prime not prime
Count=count+1

Stop i=i+1
op