Cse Lab Report
Cse Lab Report
On
Basic Computer Skills Labratory Works
Submitted To
Sajib Chattergee
Lecturer
Computer Science and Engineering
Discipline
Khulna University
Submitted By:
Papry khanom
Student ID: 212617
1 st year, 2 nd term
Mass Communication and
Journalism
Khulna University, Khulna
1
Fig1: Above pictures shows the different steeps of creating a new ms word document
Result: After creating a new word document the interface looks like the figure
Fig2. Above picture shows the result after creating a new document
Experiment No: 02
Experiment Name: Saving and Opening previous documents.
2
Save: When you create or edit a document, you'll use the Save command
to save your changes. You'll use this command most of the time. When
you save a file, you'll only need to choose a file name and location the
first time. After that, you can click the Save command to save it with the
same name and location.
Save As: You'll use this command to create a copy of a document while
keeping the original. When you use Save As, you'll need to choose a
different name and/or location for the copied version.
Procedure:
Saving a document
1. Once a MS Word document is finished with desired writings Click on the Office
Button.
2. Click on save as dialog box
3. Select folder or places where to save the document from save in combo box
4. Write the file name in file name text box
5. Select file type as word document
6. Click save Button to save the document.
Opening previous document.
1. If the document is on the desktop a double right click opens the document
2. If the document is in other drive first click on start button
3. Then click on Computer menu from menu Bar
4. Click on desired drive. Here I click D drive
5. Then take the cursor on the word document
6. Then double right click opens the document
3
Fig3: Above pictures shows the different steeps of saving a new ms word document
4
5
Fig4: Above pictures shows the different steeps of opening a previous ms word
document
Result: After saving and opening a new word document the interface looks like the figure
6
Fig 5: Above pictures shows the result after opening a previous ms word document
and saving a new ms word document
Experiment No: 03
Experiment Name: Making a text or line or paragraph Bold, italic, underlined
Equipment: Desktop, keyboard, mouse, power supply, windows 7 operating system,
Microsoft office 10 software etc
Introduction: Content will be more scannable – When you use bold, italics, and
underlines properly it will make the content more scannable to readers. They can easily
identify words and phrases that carry more weight in the content.
Procedure:
1. Write a sentence in ms word
2. Take the cursor on the left side of the texts I want to make bold, italic, underlined
3 Click where you want to begin the selection,
4. Hold down the left mouse button, and then drag the pointer over the text that I want to
select.
5. To change the selected font to bold, italic, underlined click B, I and U in the formatting
ribbon at the top of the document
7
Fig 6: Above pictures shows the steps of making a text or line or paragraph Bold,
italic, underlined
8
Results: The results are looked like the pictures in fig 6
Experiment No: 04
Experiment Name: Writing a text or sentence or paragraph as caps or small and adding
superscript and subscript.
Equipment: Desktop, keyboard, mouse, power supply, windows 7 operating system,
Microsoft office 10 software etc
Introduction: A subscript or superscript is a character (such as a number or letter) that is
set slightly below or above the normal line of type, respectively. It is usually smaller than
the rest of the text. Subscripts appear at or below the baseline, while superscripts are
above. Subscripts and superscripts are perhaps most often used in formulas,
mathematical expressions, and specifications of chemical compounds and isotopes, but
have many other uses as well.
Procedure:
1. Click on the caps lock button on the key board
2. Now write something the text is in caps letter
3 click again on the caps lock button on the key board the write something it is in small
letter.
4. Put the cursor adjacent right side of the text to be subscripted or superscripted
5. Click X 2 for subscription and X2 i in the formatting ribbon at the top of the document.
9
Fig 7: Above pictures shows the steps of writing a text or sentence or paragraph as
caps or small and adding superscript and subscript.
Results: The results are looked like the pictures in fig 7
Experiment No: 05
Experiment Name: Adjusting proper Text alignment and line spacing.
Equipment: Desktop, keyboard, mouse, power supply, windows 7 operating system,
Microsoft office 10 software etc
Introduction: The alignment options in MS Word control how text is positioned in
relation to the page margins. This can be controlled via the “Paragraph” section of the
“Home” tab on the ribbon. From left to right, you have four alignment options available.
These are:
Align Left – Used to align the text to the left margin
Center – Used to position text centrally on the page
Align Right – Used to align the text with the right margin
Justify – Used to spread text evenly across the page so the first word on each line begins
at the left margin and the last word ends at the right margin
Procedure:
Text Alignment
1. Write something in the ms word
2. Select the desired text or paragraph
3 Click left /right/central/justified alignment in the formatting ribbon at the top of the
document.
Line spacing
10
1. Write something in the ms word
2. Select the desired text or paragraph
3. Click on line spacing object from paragraph group in the formatting ribbon at the top of
the document.
4. Select from the drop down box.
11
Fig 8: Above pictures shows the steps of Adjusting proper Text alignment and line
spacing.
Results: The results are looked like the pictures in fig 8
Experiment No: 06
Experiment Name: Adjusting Font, size and style
Equipment: Desktop, keyboard, mouse, power supply, windows 7 operating system,
Microsoft office 10 software etc
Introduction: We can use different font types and sizes to differentiate the texts that are
most important. We can highlight the important topics by using bigger font sizes. This
will help the audience to easily determine the information that they should pay more
attention to.
Procedure:
1. Write something in the ms word
2. Select the desired text or paragraph
3 Go to the font; font size and font color in the formatting ribbon at the top of the
document
4. Select proper font type font size and font color for the text
12
Fig 9: Above pictures shows the steps of Adjusting Font, size and style
Results: The results are looked like the pictures in fig 9
Experiment No: 07
Experiment Name: Inserting bullets and numbers in ms word
Equipment: Desktop, keyboard, mouse, power supply, windows 7 operating system,
Microsoft office 10 software etc
Introduction: Word lets us to make two types of lists: bulleted and numbered. Bulleted
and numbered lists help to simplify steps or items to readers. Teachers often use bulleted
lists to highlight important pieces of their lessons. Manuals often include numbered lists
to assist readers with step-by-step instruction.
Procedure:
1. Select the text I want to format as a list.
2. On the Home tab, click the drop-down arrow next to the Bullets or numbers
command. A menu of bullet styles or numbers will appear.
3. Move the mouse over the various bullet styles or numbers
4. The text will be formatted as a bulleted list or numbered list.
13
Fig 10: Above pictures shows the steps of Inserting bullets and numbers in ms word
Results: The results are looked like the pictures in fig 10
Experiment No: 08
Experiment Name: Inserting Table, charts, shapes, and text box.
Equipment: Desktop, keyboard, mouse, power supply, windows 7 operating system,
Microsoft office 10 software etc
Introduction:
Word processing isn’t just about words—and neither is Word 2013. Although
text probably accounts for the bulk of your documents, you can liven up the
proceedings and make your points more clearly by adding other elements. Tables
organize information into rows and columns so that readers can easily navigate
large collections of data. Charts take the same kind of information and present it
photos, a company logo, whimsical clip art, executive portraits, product photos
—if you’ve got a picture on your computer (or stored in the cloud), you can put
it in your document. This chapter shows you how to work with nontext elements
in Word: inserting them into a document, resizing and moving them, editing
14
them. Your documents will be that much more interesting, and your points will
Procedure:
Table
1. Take the cursor where the Table, is to be inserted
2. Click on Insert tab
3. Click on the Table Click on Insert Table
4. Fill in the number of columns and number of rows text box
5. Finally click ok
15
2. Click on Insert tab
3. Click on Picture menu
4. Click on the selected drive where the picture is
5. Double Click on the folder where the picture is
6. Double Click on the image file
16
Fig 12: Above pictures shows the steps of Inserting picture
Shape
1. Click on Insert tab
2. Click on shapes object in the illustration group
3. Click on the desired shape
4. Draw the shape on the desired place
17
Fig 13: Above pictures shows the steps of Inserting shape
Smart art
1. Take the cursor where the smart art to be inserted
2. Click on Insert tab
3. Click on Smart art object in the illustration group
4. Click on the desired Smart art
5. Click on ok Dialog box.
18
Fig 14: Above pictures shows the steps of Inserting smart art
Chart
1. Take the cursor where the chart is to be inserted
2. Click on Insert tab
3. Click on chart object in the illustration group
4. Click on the desired type of chart
5. An additional window of ms excel will be created
6. There will be a table
7. Edit table as expected
8. Then cross the additional window
19
Fig 15: Above pictures shows the steps of Inserting Chart
20
120
100
80
Papry
60
Aparajita
40 Shadhona
20
0
Math English Science
Fig 16: Above pictures shows the results of Inserting table charts, shapes, and smart
art
Experiment No: 09
Experiment Name: Setting up margin, ruler, size, orientation, columns and line
numbers.
Equipment: Desktop, keyboard, mouse, power supply, windows 7 operating system,
Microsoft office 10 software etc
21
Introduction: The paper size, color, and borders give the reader an overall sense of the
document’s theme and quality. Margins, the text layout, and perhaps a watermark send
further visual clues. Making the right choices about your document setup helps you send
the right message to your readers. Say you’re working on an invitation; using a smaller,
elegant paper size and adding a subtle border lets your recipients know right away that
they’re in for a sophisticated event.
Procedure:
Margins
1. Take the cursor anywhere of the page is to be margined.
2. Click on margin object in the page setup group from page layout tab
3. Click on custom margin
4. Select desired size of margin from top, bottom, right, left text box
5. Finally click ok
22
Fig 17: Setting up orientation
Size
1. Take the cursor anywhere of the page is to be margined.
2. Click on Size object from page setup group
3. Click on A4 or legal size from the drop down box
Column
1. Take the cursor anywhere of the page is to be margined.
2. Click on column object from page setup group
3. Click on one, tow ,three etc columns
23
Fig 19: Setting up Column number
Result: The results are shown on fig 16, 17, 18, 19
Experiment No: 10
Experiment Name: Creating new Microsoft Excel document.
Equipment: Equipment: Desktop, keyboard, mouse, power supply, windows 7
operating system, Microsoft office 10 software etc
Introduction: Microsoft Excel enables users to identify trends and organize and sort data
into meaningful categories. Excel also performs Human Resources functions, such as
sorting worked hours and organizing employee profiles and expenses, which help
businesses better understand the structure and activities of their workforce.
Procedure:
1. Start a computer having operating system Windows 7 Ultimate
2. Click on Start Button which is located on the left-hand bottom corner on my Desktop
3. Click the All Programs button just above the Start button.
4. Find the group Microsoft Office and click on it.
5. In the sub-group, one of the icons will be Microsoft Office Excel and click on it.
24
Fig 20: Opening a new ms office excel document
25
Experiment Name: Saving and Opening previous ms excel document.
26
Fig 22: saving a ms office excel document
Opening previous documents.
1. If the document is on the desktop a double right click opens the excel document
2. If the excel document is in other drive first click on start button
3. Then click on Computer menu from menu Bar
4. Click on desired drive. Here I click D drive
5. Then take the cursor on the Excel document
6. Then double right click opens the excel document
27
Fig 23: saving a ms office excel document
Experiment No: 12
28
Experiment Name: Creating the GPA calculation system in excel using logical operator
if, nested if, and, nested and and sum, subtract, multiplication average formula
Equipment: Desktop, keyboard, mouse, power supply, windows 7 operating system,
Microsoft office 10 software etc
Introduction:
The IF function allows you to make a logical comparison between a value and what you
expect by testing for a condition and returning a result if True or False. =IF(Something is
True, then do something, otherwise do something else) So an IF statement can have two
results. The first result is if your comparison is True, the second if your comparison is
False. IF statements are incredibly robust, and form the basis of many spreadsheet
models, but they are also the root cause of many spreadsheet issues. Ideally, an IF
statement should apply to minimal conditions, such as Male/Female, Yes/No/Maybe, to
name a few, but sometimes you might need to evaluate more complex scenarios that
require nesting* more than 3 IF functions together. * “Nesting” refers to the practice of
joining multiple functions together in one formula.
Procedure:
1. Enter Student ID
2. Enter Ct 1 , CT2 and CT 3 Marks
3. Find best 1 using the formulae =LARGE(B2:D2,1)
4. Find best 2 using the formulae =LARGE(B2:D2,1)
5. Enter Section A and Serction B marks
6. Find the total of best 1, best 2 Section A and Section B marks
7. Find the GPA Using Formula
=IF(K2>=80,"4.00",IF(AND(K2>=75,K2<80),"3.75",IF(AND(K2>=70,K2<75),"3.50
",IF(AND(K2>=65,K2<70),"3.25",IF(AND(K2>=60,K2<65),"3.00",IF(AND(K2>=5
5,K2<60),"2.75",IF(AND(K2>=50,K2<55),"2.50",IF(AND(K2>=45,K2<50),"2.25",I
F(AND(K2>=40,K2<45),"2.00",IF(K2<40,"0.00"))))))))))
8. Find the GPA Using Formula
=IF(K2>=80,"A+",IF(AND(K2>=75,K2<80),"A",IF(AND(K2>=70,K2<75),"A-",IF(
AND(K2>=65,K2<70),"B+",IF(AND(K2>=60,K2<65),"B",IF(AND(K2>=55,K2<60
),"B-",IF(AND(K2>=50,K2<55),"C+",IF(AND(K2>=45,K2<50),"C",IF(AND(K2>=
40,K2<45),"D",IF(K2<40,"Fail"))))))))))
29
Fig 25: Steps of Calculating GPA
Result: The result is shown below
Student Ct Section Section
Id. 1 Ct2 Ct3 Best1 Best2 Average Attendance A B Total CGPA Grade
212601 9 10 6 10 9 9.5 10 22 22 73 3.50 A-
212602 8 11 9 11 9 10 8 22 20 70 3.50 A-
212603 7 10 10 10 10 10 9 20 19 68 3.25 B+
212604 12 9 11 12 11 11.5 10 18 19 70 3.50 A-
212605 10 8 8 10 8 9 10 20 21 69 3.25 B+
212606 6 11 11 11 11 11 10 9 10 51 2.50 C+
212607 9 8 12 12 9 10.5 10 9 7 47 2.25 C
212608 10 11 8 11 10 10.5 8 20 19 68 3.25 B+
212609 11 12 10 12 11 11.5 9 18 19 69 3.25 B+
212610 8 8 11 11 8 9.5 10 20 21 70 3.50 A-
212611 11 10 9 11 10 10.5 10 21 22 74 3.50 A-
212612 12 11 12 12 12 12 10 25 22 81 4.00 A+
212613 8 9 11 11 9 10 6 11 7 44 2.00 D
212614 10 12 12 12 12 12 10 20 19 73 3.50 A-
212615 11 8 8 11 8 9.5 8 18 19 64 3.00 B
212616 9 9 10 10 9 9.5 9 5 2 35 0.00 Fail
212617 12 11 12 12 12 12 10 20 22 76 3.75 A
212618 8 10 9 10 9 9.5 10 15 12 56 2.75 B-
212619 9 8 12 12 9 10.5 10 20 19 70 3.50 A-
212620 11 9 8 11 9 10 10 18 19 67 3.25 B+
Fig 26: Result of Calculating GPA
30
Experiment No: 13
Experiment Name: Electricity Bill Calculation using ms excel using logical operator if,
nested if, and, nested and and sum, subtract, multiplication formula
Equipment: Experiment Name: Equipment: Desktop, keyboard, mouse, power supply,
windows 7 operating system, Microsoft office 10 software etc.
Introduction:
Though very popular, the nested IF statement is not the only way to check multiple
conditions in Excel. In this tutorial, you will find a handful of alternatives that are
definitely worth exploring.
Procedure:
1. Enter Meter Number, Billing Month, Previopus Reading, Current Reading
2. Find Consumed Unit by subtracting previous reding from current reading using
formula =G2-F2
3. Find best 2 using the formulae =LARGE(B2:D2,1)
4. Enter Section A and Serction B marks
5. Find the total of best 1, best 2 Section A and Section B marks
6. Find the net bill using formula =IF(H2<=75,75*4.19,IF(H2<=200,75*4.19+(H2-
75)*5.72,IF(H2<=300,75*4.19+125*5.72+(H2-
200)*6,IF(H2<=400,75*4.19+125*5.72+100*6+(H2-
300)*6.34,IF(H2<=600,75*4.19+125*5.72+100*6+100*6.34+(H2-
400)*9.94,IF(H2>600,75*4.19+125*5.72+100*6+100*6.34+200*9.94+(H2-
600)*11.46))))))
7. Enter Meter rent
8. Find the vat using formula =I2*5/100
9. Find total bill using formula =I2+J2+K2
31
Result: The result is shown bellow
Accont Previous Current Consumed Meter
NO Billing Month Reading Reading Unit Net Bill Rent Vat Total Bill
Total Per Unit
1235 October 13421 13761 340 1882.9 10 94 1986.9925 Unit Rate
1236 October 15722 16255 533 3585.3 10 179 3774.5335
0-75 4.19 taka
1237 October 10226 10255 29 314.25 10 16 339.9625 unit
76-200 5.72 taka
1238 October 10312 10453 141 691.77 10 35 736.3585 unit
201- 6.00 taka
300
2054 October 12457 12568 111 520.17 10 26 556.1785 unit
301- 6.34 taka
1501 October 13452 13822 370 2073.1 10 104 2186.7025 400 uni
401- 9.94 taka
600
1502 October 12450 12645 195 1000.7 10 50 1060.6825 unit
600+ 11.46 taka
1503 October 15342 15762 420 2462.1 10 123 2595.1525 unit
1504 October 16750 16810 60 314.25 10 16 339.9625
1505 October 15425 15986 561 3863.6 10 193 4066.7695
1506 October 12542 12856 314 1718 10 86 1813.9105
1507 October 14252 14285 33 314.25 10 16 339.9625
1508 October 10255 10350 95 428.65 10 21 460.0825
1680 October 10453 10853 400 2263.3 10 113 2386.4125
1681 October 12568 12866 298 1617.3 10 81 1708.1125
1682 October 13822 14245 423 2491.9 10 125 2626.4635
1683 October 12745 13120 375 2104.8 10 105 2219.9875
1684 October 15762 16852 1090 9866.7 10 493 10369.983
1685 October 10255 11852 1597 15677 10 784 16470.714
1686 October 10453 10520 67 314.25 10 16 339.9625
32
Procedure:
1. Start a computer having operating system Windows 7 Ultimate
2. Click on Start Button which is located on the left-hand bottom corner on my Desktop
3. Click the All Programs button just above the Start button.
4. Find the group Microsoft Office and click on it.
5. In the sub-group, one of the icons will be PowerPoint document and click on it.
33
Fig 29: Results of opening new PowerPoint Document
Experiment No: 14
Experiment Name: Saving and opening new Microsoft PowerPoint document.
Equipment: Desktop, keyboard, mouse, power supply, windows 7 operating system,
Microsoft office 10 software etc.
Introduction: Microsoft PowerPoint is one of the most popular technology that is being
used by many of us in our day in day out to present our views in more attractive and
precise way with numerous special effects. With a few clicks, user can add graphics, text,
visuals, sounds and many more effects. In most of the Business meetings, PowerPoint
presentation making the sessions more interesting for the listeners compared to old
traditional way of representation
Procedure:
Saving a document
1. Once a PowerPoint document is finished with desired writings Click on the Office
Button.
2. Click on save as dialog box
3. Select folder or places where to save the excel document from save in combo box
4. Write the file name in file name text box
5. Select file type as Excel document
6. Click save Button to save the document.
34
Fig 30: Saving new PowerPoint Document
35
Experiment No: 15
Experiment Name: Adding new slide on a PowerPoint Document and writing text on it.
Equipment: Desktop, keyboard, mouse, power supply, windows 7 operating system,
Microsoft office 10 software etc.
Introduction: New slide is very important button to aggregate and complete presentation
document.
Procedure:
1. Click on Home Tab
2. Write Title of the slide into the click to add title text box
3. Write the description of the topic into the click to add text box
36
Experiment No: 16
Experiment Name: changing layout, design, color and fonts of a slide
Equipment: Desktop, keyboard, mouse, power supply, windows 7 operating system,
Microsoft office 10 software etc.
Introduction: It is important to know the procedure of changing layout, design, color and
fonts of a slide to make the presentation attractive
1. Procedure:
2. Click on Home Tab
3. Click on the Layout object in the slides group
4. Select a layout from drop down box
5. Go to Design tab click on it
6. Choose a theme from the themes group
7. Click on background Style object from Background group
8. Choose a background style
9. Change color and font from colors and fonts object from theme group
37
Fig 34: Steps Changing layout, design, color and fonts of a slide
Experiment No: 17
Experiment Name: Add animations to text, pictures, shapes, and more in your
presentation
Equipment: Desktop, keyboard, mouse, power supply, windows 7 operating system,
Microsoft office 10 software etc.
Introduction: Adding animations make presentation more attractive
Procedure:
1. Select the object or text you want to animate.
2. Select Animations and choose an animation.
3. Select Effect Options and choose an effect.
38
Manage animations and effects
There are different ways to start animations in your presentation:
On Click: Start an animation when you click a slide.
With Previous: Play an animation at the same time as the previous animation in
your sequence.
After Previous: Start an animation immediately after the previous one happens.
Duration: Lengthen or shorten an effect.
Delay: Add time before an effect runs.
Add more effects to an animation
1. Select an object or text with an animation.
2. Select Add Animation and choose one.
Change the order of animations
1. Select an animation marker.
2. Choose the option you want:
Move Earlier: Make an animation appear earlier in the sequence.
Move Later: Make an animation occur later in the sequence.
39
40