Table of Contents

1.Software
1.1 Software Installation
1.2 Software Uninstallation
1.3 Software Deletion
2.Microsoft PowerPoint
2.1 Presentation on Piracy
3.Adobe Photoshop
3.1 Lasso Tools
3.2 Polygonal Lasso Tool
4.Adobe Illustrator
4.1 National Flag Drawing
4.2 Area Text
5.Microsoft Excel
5.1 Generating Result Sheet
5.2 Few Formulas
6.Microsoft Access
6.1 Searching
6.2 Conditional Searching
7.Microsoft Word
7.1 Curriculum Vitae
 1.1 Software Installation
The process of installing operating system software is
complex, and expertise is essential for this task. In addition
to the operating system software, we need di erent types of
software. These pieces of software should be installed
based on our needs.

Installation of any software requires special attention to the

issues given below:
1. Whether the hardware of your device supports the pieces
of software to be installed.
2. Whether there is anything important in ‘Read me’ file; if
any, Read it.
3. Whether all other works are stopped during installation; if
not, the installation process often gets hampered.
4. Whether the anti-virus software is turned o .
5. Whether the administrator of the operating system has the
permission or not; (almost all the devices have the
permission except some particular).

Installation of software, except operating system one,

depends almost on the operating system itself. However, the
process of installation is almost the same. We need the soft
or digital copy of the software to install it.
For this practical, we will install VLC Media Player. The
process of installing a piece of software is given below:\

1. Double click the set-up file of software. The following

image is set-up file. Clicking on it will start the installation.

2. A pop-up will come up asking if we want to let the

following program make changes to this computer. We will
click ‘yes’.

3. Next pop up will ask us to select a language. Here we will

select our preferred language.

4. Here, we will be directed to set up preface to proceed to

the next step.
5. We must carefully read the user agreement before
accepting and continuing.

6. Next, we will choose the components that we want to

install.

7. Now we will choose install location and select destination

folder.
8. After completing all above steps, the software
will be installed after clicking ‘finish’.

Now, we have completed the installation of a software.

1.2 Software Uninstallation

The operating system software helps us to get the task done.
The nature of all kinds of operating system software is
almost same. The following steps should be followed to
uninstall a software from a computer or an ICT device run by
Microsoft windows operating system. Here, VLC media
player will be uninstalled.
1. Click the start button and go to the Control Panel. Then
double click the ‘Add or Remove’ to uninstall a programme.

2. Click uninstall of the programme that is to be uninstalled

and the uninstallation will take place immediately. The time
of uninstallation usually depends on the bulk of the file.

So like this, the software is uninstalled. But some parts of

the uninstalled programmes are dumped in the registry file
of the operating system.

1.3 Software Deletion

It is possible to delete any programme following the steps
below :
1. Press windows + r, activate Run command. Write ‘regedit’,
and press enter.
2. Enter the ‘file’ menu.

3. Click ‘Export’
4. The drive that contains the operating software, that is ‘C’,
should be selected.
5. Save the file. It is very important. If any error is made, the
system may be repaired.

6. Enter ‘Edit’ then.

7. Point to ‘Find’.
8. Find out the name of the software to be deleted. In this
case, it is VLC media player.

9. Click ‘Find Next’.

10. Wait for the search to be over and the select the file and
click ‘Delete’.

11. Lastly, press ‘F3’ of the keyboard and delete all the files
having that name from the registry file.

And so, the entire process of software deletion is completed.

 2.1 Presentation on Piracy
Step-by-Step Process to Create a PowerPoint
Presentation on Piracy

1. Open PowerPoint
1. Launch Microsoft PowerPoint on your computer.
2. Choose a blank presentation or select a template that
fits your theme.
2. Create the Title Slide
1. Add a title, such as "Understanding Piracy: Causes,
Impact, and Solutions."
2. Include your name, date, or organization details if
needed.
3. Optionally, add a relevant image or icon (e.g., a pirate
symbol, copyright logo).

3. Set Up the Slide Structure

1. Slide 2 - Agenda:
o List the key topics you’ll cover: Introduction, Types,
Impacts, Causes, Solutions, and Conclusion.

2. Slide 3 - Introduction:
o Define piracy briefly.
o Add a hook (e.g., a statistic about piracy's global
impact).
3. Slide 4-6 - Main Content:
o Dedicate one slide for each topic:
 Types of Piracy (e.g., digital, maritime,
intellectual property).
  Impacts of Piracy (economic losses, ethical
issues, legal consequences).
 Causes of Piracy (accessibility, cost, lack of
awareness).
4. Slide 7 - Solutions:
o Suggest preventive measures (e.g., education,
stronger laws, technological measures).
5. Slide 8 - Conclusion:
o Summarize the key points.

4. Add Visuals and Content

1. Use copyright-free images, icons, or illustrations to
enhance your slides
2. Create charts or graphs for numerical data (e.g.,
showing piracy trends over time).
3. Add bullet points for each topic (keep it concise—no
more than 5-7 points per slide).

5. Apply Slide Design

1. Select a theme from the Design tab in PowerPoint or
customize your own.
2. Ensure the font size is readable.
 3. Use consistent color scheme and typography.

6. Add Animations and Transitions

1. Use animations sparingly to emphasize key points (e.g.,
"Appear" for text or "Fade" for images).
2. Add simple transitions (like "Fade" or "Push") between
slides for smooth flow.

7. Review and Edit

1. Re-read each slide for typos, grammar, and clarity.
2. Check that visuals align with your content.
3. Ensure animations and transitions work as intended.

For example, A PowerPoint presentation on piracy is given

below.
 3.1 Lasso Tools
The Lasso Tools in Photoshop are essential for making
freehand, irregular, or complex selections. Photoshop
provides three variations of the lasso tool, they are Lasso
tool, Polygonal lasso tool, Magnetic lasso tool.

Lasso Tool (Freehand Lasso)

Purpose:
The basic Lasso Tool allows you to draw freehand selections
around the area you want to isolate or edit.
Steps to Use:
1. Activate the Tool:
o Select the Lasso Tool from the toolbar (shortcut: L).

2. Draw Your Selection:

o Click and hold the left mouse button, then drag
around the area you want to select.
3. Complete the Selection:
o Release the mouse button to close the selection
automatically.
o If the selection doesn't close perfectly, Photoshop
will connect the endpoint to the starting point with a
straight line.
 4. Modify or Edit:
o Once selected, you can copy, move, or apply e ects
to the selection.
Key Features:
 Best for irregular, freehand shapes.
 Not ideal for precise selections.

3.2 Polygonal Lasso tool

Purpose:
The Polygonal Lasso Tool is designed for creating straight-
edged selections. It’s perfect for selecting objects with
angular or straight lines.
Steps to Use:
1. Activate the Tool:
o Right-click on the Lasso Tool in the toolbar, then
select the Polygonal Lasso Tool.

2. Start Creating Points:

o Click on the canvas to set the first anchor point.

3. Draw Lines:
o Continue clicking to create straight segments
around your desired area.
4. Close the Selection:
 o Double-click at the end point, or click on the starting
point to close the selection automatically.
5. Edit or Refine:
o You can adjust the selection using other tools or
apply desired edits.
Key Features:
 Precise and e icient for objects with straight edges.
 Can switch to the regular Lasso Tool temporarily by
holding Alt/Option.

4.1 National Flag Drawing

Steps to Draw the Bangladeshi National Flag:
1. Set Up the Canvas
 Open Adobe Illustrator and create a new document
(Ctrl+N / Cmd+N).
 Set the canvas size to 800x500 pixels to match the
proportions of the flag.

2. Draw the Green Background

 Select the Rectangle Tool (M):
o Click and drag to draw a rectangle.
 Set the Rectangle Size:
o Go to the Transform panel (Window > Transform)
and set the dimensions to 800 px (width) and 500
px (height).

 Change the Color:

o Open the Swatches panel (Window > Swatches)
and set the fill color to green (#006A4E) (the o icial
flag green).
3. Draw the Red Circle
 Select the Ellipse Tool (L):
o Hold down Shift and drag to draw a perfect circle.
 Set the Circle Size:
o In the Transform panel, set the dimensions to 200
px (both width and height).

 Center the Circle:

o Use the Align Panel (Window > Align). Select the
rectangle and the circle, then click Horizontal
Align Center and Vertical Align Center.
 Adjust Position for Accuracy:
o Move the circle slightly to the left by 10% of the
rectangle's width.
o Use the Move tool (Shift+Arrow keys) or manually
adjust in the Transform panel.
 Change the Color:
 o Set the circle’s fill color to red (#F42A41) (the
o icial flag red).

4. Refine the Design

 Ensure no stroke is applied to the shapes (set stroke to
None in the toolbar).
 Verify the colors match the o icial flag colors.

5. Save the File

 Save the file in AI format (File > Save As) for further
edits.
  Export as PNG or JPG for sharing (File > Export > Export
As).

4.2 Area Text

Any text typed or placed in square, rectangular, circular,
elliptical or any closed path is called Area Text. To type or
arrange text in a closed path:
1. Create a square, rectangular, circular or elliptical path.
2. After selecting the. Type Tool, place the mouse pointer on
the closed path, the Type Tool will take the shape of the Area
Type Tool.
3. Click on the anchor point of the path, and the insertion
point will be placed inside the closed path, which will be
used as a Text Box or Text Container.
4. Start the work of typing.
5. When you will reach the right edge of a line, the insertion
pointer will automatically go down the next line. If typing
continues in this way, the next line will be automatically
started.
By following the above steps, Area text can be created.

5.1 Generating Result Sheet

Steps to Generate a Result Sheet
Step 1: Open Microsoft Excel
 Launch Microsoft Excel and open a new workbook.

Step 2: Create the Column Headers

 In Row 1, type the headers in the following order:
o A1: Roll Number / Student ID
o B1: Name
o C1: Subject 1
o D1: Subject 2
o E1: Subject 3
o F1: Total Marks
o G1: Percentage
o H1: Grade

Step 3: Input Student Data

 Fill in the rows below the headers with student data:
o Column A: Roll numbers or IDs.
o Column B: Names of students.
o Columns C-E: Marks obtained in each subject.

Step 4: Calculate Total Marks

  In Column F, calculate the total marks for each
student:
1. Click in F2 (first cell under Total Marks).
2. Enter the formula: =C2+D2+E2
3. Press Enter.
4. Drag the fill handle (bottom-right corner of the cell)
down to copy the formula for all students.

Step 5: Calculate Percentage

 In Column G, calculate the percentage:
1. Click in G2.
2. Enter the formula: =(F2/300)*100
(Replace 300 with the total marks possible for all subjects
combined.)
3. Press Enter.
4. Drag the fill handle down to apply the formula to all
rows.

Step 6: Assign Grades

 In Column H, assign grades based on percentages:
1. Click in H2.
 2. Enter the formula for conditional grading:
=IF(G2>=90,"A",IF(G2>=75,"B",IF(G2>=50,"C","F")))
3. Press Enter.
4. Drag the fill handle down to apply the formula to all
rows.

Step 7: Format the Sheet

 Bold the headers to make them stand out.
 Apply borders to the entire data table:
o Highlight the table.
o Go to Home > Font > Borders and choose All
Borders.
 Use Conditional Formatting to highlight specific
grades or percentages:
o Select the column (e.g., Column H for Grades).
o Go to Home > Conditional Formatting and create
rules.

Step 8: Save the File

 Save the result sheet as an Excel Workbook (.xlsx) for
editing or as a PDF for sharing:
o File > Save As > Choose Format.
 5.2 Few Formulas
Here are some commonly used Microsoft Excel formulas,
along with their purposes and examples:

1. Basic Arithmetic Formulas

 Addition:
=A1 + B1
 Subtraction:
=A1 - B1
 Multiplication:
=A1 * B1

 Division:
=A1 / B1
2. Aggregation Formulas
 SUM: Adds a range of numbers.
=SUM(A1:A10)
 AVERAGE: Calculates the average of numbers in a range.
=AVERAGE(A1:A10)
 COUNT: Counts numeric values in a range.
=COUNT(A1:A10)
 COUNTA: Counts non-empty cells.
=COUNTA(A1:A10)
 MAX: Finds the largest number in a range.
=MAX(A1:A10)
 MIN: Finds the smallest number in a range.
=MIN(A1:A10)

3. Logical Formulas
 IF: Conditional formula.
=IF(A1>50, "Pass", "Fail")
 AND: Checks if multiple conditions are true.
=AND(A1>50, B1<100)
 OR: Checks if at least one condition is true.

6.1 Searching
Searching in Microsoft Access
Microsoft Access allows users to search for specific data
within a database, making it easier to locate and work with
large sets of information. Searching can be done in various
ways, such as directly in datasheets, using filters, or creating
queries.

Ways to Search in Microsoft Access

1. Searching in Datasheets
 Directly search within a table or query's datasheet view.
 Useful for simple searches.
2. Using Filters
 Apply filters to show only the data matching specific
criteria.
 Suitable for quick and repetitive searches.
3. Creating Queries
 Use queries for complex searches across multiple
tables.
 Queries can combine search criteria, calculations, and
sorting.

Steps to Perform a Search in Microsoft Access

Search Directly in Datasheet View
1. Open the Table or Query:
o Open the table or query where you want to search
for data.
2. Use the Search Bar:
o At the bottom of the datasheet, locate the Search
Bar.
o Type the keyword or value you want to search for.
o Press Enter to navigate to the first match.
3. Navigate Results:
o Use the arrows beside the search bar to jump to
the next or previous result.

Apply Filters
1. Open the Table or Query:
o Open the desired table or query in datasheet view.
2. Select a Field:
o Click on the column header of the field you want to
filter.
3. Apply a Filter:
o Right-click the field and choose Filter by Selection
to filter by a specific value.
 o Alternatively, click the Filter button in the toolbar,
then choose the criteria.
4. Clear Filter:
o To remove the filter, go to Home > Sort & Filter >
Toggle Filter.

Search Using Queries

1. Open Query Design View:
o Go to Create > Query Design.

2. Add Tables:
o In the dialog box, add the table(s) where the data is
stored.
3. Select Fields:
o Drag and drop the fields you want to include in the
query to the design grid.
4. Set Criteria:
o In the Criteria row, specify your search condition:
 Example: To find records with "John" in a
"Name" field, enter "John" in the Criteria row
under the "Name" column.
5. Run the Query:
 o Click Run (red exclamation mark) on the toolbar to
view the results.
6. Save the Query (Optional):
o Save the query for future use by clicking File >
Save.

6.2 Conditional Searching

Conditional Searching in Microsoft Access
Conditional searching in Microsoft Access allows users to
retrieve data that matches specific conditions or criteria. This
is primarily done using queries, which are powerful tools for
filtering and analyzing data.

Steps to Perform Conditional Searching in Microsoft

Access
1. Open Your Database
 Launch Microsoft Access and open the database where
you want to perform the search.

2. Open Query Design View

1. Go to the Create tab in the ribbon.
2. Click on Query Design.
 3. A dialog box will appear prompting you to select the
tables or queries to use. Select the table(s) containing
the data and click Add.

3. Add Fields to the Query

1. Drag and drop the fields you want to include in your
search from the table into the design grid at the bottom
of the Query Design window.
2. For example, if you're searching for students who scored
above 80 in Math, add the Name and Math Score fields.

4. Set the Conditions

1. In the Criteria row of the desired field, enter the
condition:
o Equal to a specific value: =50
o Greater than a value: >50
o Less than a value: <50
o Range of values: BETWEEN 50 AND 100
o Text match: "John"
o Partial match: LIKE "J*" (matches anything starting
with "J")
o Null values: IS NULL or IS NOT NULL
5. Combine Multiple Conditions
 Use AND and OR to combine criteria:
o AND: Conditions must all be true.
Example: Math Score > 80 AND Science Score > 70
o OR: At least one condition must be true.
Example: Math Score > 80 OR Science Score > 70

6. Run the Query

1. Click the Run button (red exclamation mark) on the
toolbar to view the results.
2. The data matching your conditions will be displayed in a
datasheet view.
7. Save the Query (Optional)
1. To reuse the query, save it:
o Go to File > Save or press Ctrl+S.
o Provide a name for the query.

7.1 Curriculum Vitae

Steps to Create a CV in MS Word

1. Open Microsoft Word

1. Launch MS Word on your computer.
 2. Select "New Document" from the options.
3. Search for "Resume" or "CV" templates in the search
bar for a pre-designed option, or choose a blank
document to create a custom CV.

2. Set Up the Page

1. Margins: Go to the Layout tab and click on Margins.
Choose "Normal" or customize margins as needed.
2. Font and Size:
o Use professional fonts like Arial, Calibri, or Times
New Roman.
o Use 11-12 pt font for body text and 14-16 pt for
headings.
3. Alignment: Use left alignment for a clean and
professional look.
4. Spacing: Set line spacing to 1.0 or 1.15 for readability.

3. Add a Header
1. Click Insert > Header > Choose a simple style.
2. Add your name (large and bold), contact information
(email, phone number), and location (city and country).
3. Optionally, include links to your LinkedIn profile,
portfolio, or website.
4. Structure Your CV
1. Create Sections:
o Personal Information
o Career Objective or Summary
o Work Experience
o Education
o Skills
o Certifications (if applicable)
o Achievements (if applicable)
o References (optional or "Available upon request").
2. Use Insert > Text Box for a modern layout if desired.

5. Format Each Section

1. Personal Information:
o Name in bold and larger font.
o Contact details below in a smaller font.
2. Career Objective:
o Write 2-3 lines summarizing your career goals and
key strengths.
3. Work Experience:
 o List jobs in reverse chronological order (most
recent first).
o Include:
 Job title
 Company name
 Location
 Dates of employment (e.g., Jan 2020 – Dec
2023)
 Key responsibilities and achievements (use
bullet points).
4. Education:
o List degrees/diplomas in reverse chronological
order.
o Include institution name, degree, location, and
graduation date.

5. Skills:
o Use a bulleted list for technical, language, or soft
skills.
6. Certifications and Achievements:
o Add any certifications, awards, or notable
accomplishment.
6. Add Design Elements
1. Use Bold and Italics:
o Bold section headings and job titles.
o Use italics for dates or company names.
2. Insert Lines or Shapes:
o Use Insert > Shapes > Line to separate sections.
3. Tables for Alignment:
o Use a two-column table to align items neatly (e.g.,
job title on the left and dates on the right).
4. Bullet Points:
o Use bullets for lists to improve readability.

7. Save the CV
1. Go to File > Save As.
2. Save the document in both .docx (editable format) and
PDF (final format for sharing).