[Link].

- Sem- II Subject :- Computer Skills – II (Practical Record Questions)

Q.1] Define Operation Systems. Explain main Functions of Operating System.

An operating system (OS) is essential system software acting as an interface between user
applications and computer hardware, managing resources to ensure efficient operation. Key
functions include process management, memory allocation, file system management, device
handling and security. Examples include Windows, Linux, Android, and iOS.
Key Functions of an Operating System:
• Process Management: The OS manages the execution of programs (processes),
handling scheduling, creation, deletion, and synchronization to ensure efficient CPU
utilization.
• Memory Management: It tracks and manages primary memory (RAM), allocating
and deallocating space for processes to run effectively.
• File Management: The OS organizes, stores, and retrieves data on storage devices,
managing files and directories through a hierarchical file system.
• Device Management: It controls peripheral devices (printers, monitors, mouse)
using drivers to handle input/output operations.
• Security and Access Control: The OS protects data and resources from
unauthorized access, ensuring system integrity.
• User Interface (UI): It provides a user-friendly way to interact with the computer,
such as Graphical User Interfaces (GUI) or Command-Line Interfaces (CLI).
• Error Detection and Handling: The OS monitors system health, detecting errors
and preventing system crashes.
• Job Accounting: It tracks usage statistics for different users or jobs, which is useful
for monitoring performance and resource usage.

Q-2] Write the Process of changing Desktop background and themes.

Steps to Change the Desktop Background (Wallpaper):

1. Right-click on your desktop and select Personalize.
2. Select Background from the menu.
3. In the Personalize your background dropdown menu, choose Picture, Solid
color, Slideshow, or Windows spotlight.
4. To use your own photo, click Browse photos to select an image from your
computer.
5. Adjust the fit (Fill, Fit, Stretch, Tile, Center) if necessary.

Steps to Change Themes:

1. Right-click on the desktop and select Personalize.
2. Click on Themes in the left-hand menu or sidebar.
3. Under "Change theme," click on a theme thumbnail to apply it.
4. To get more, click Get more themes in Microsoft Store.
Q-3] Write the steps of creating, copying and deleting files & folders ?

1. Creating Files and Folders

• Folder: Right-click in an empty space in File Explorer or on the desktop,
select New, then choose Folder. Type a name and press Enter.
• File: Right-click in an empty space, select New, and choose the file type (e.g.,
Text Document, Word Document).
• Alternative: Use the "New folder" button on the Ribbon menu at the top of
File Explorer.

2. Copying and Moving Files/Folders

• Copy (Duplicate): Right-click the file/folder, select Copy (or press Ctrl+C),
navigate to the destination folder, right-click, and select Paste (or Ctrl+V).

• Move (Cut): Right-click the file/folder, select Cut (or press Ctrl+X), navigate
to the new location, right-click, and select Paste (or Ctrl+V).

• Drag and Drop: Click and drag a file/folder to a new folder. Note: Dragging to
a different drive copies the file; dragging within the same drive moves it. Hold
Ctrl while dragging to force a copy.

3. Deleting Files and Folders

• Delete to Recycle Bin: Select the file/folder and press the Delete key on the
keyboard, or right-click and select the trash can icon (or "Delete").
• Permanent Delete: Select the file/folder and press Shift + Delete to remove
it without sending it to the Recycle Bin.
• From Command Prompt: Use rm (Linux/macOS) or del (Windows) for
immediate deletion.

4. Renaming Files and Folders

• Click on the file/folder, press F2 on the keyboard, type the new name, and
press Enter.
• Alternatively, right-click the item and select Rename.

5. Selecting Multiple Items

• Adjacent Items: Click the first item, hold down the Shift key, and click the
last item.

• Non-Adjacent Items: Hold down the Ctrl key and click each item you want to
select.

• All Items: Press Ctrl+A.

Q-4] Explain the Network topologies. Explain the type of Networks (LAN, MAN & WAN)

Network topologies define the physical or logical arrangement of devices (nodes) and
connections in a network (e.g., bus, star, mesh), affecting performance and reliability.
Networks are classified by scale: LANs cover small, private areas (buildings); MANs span
cities; and WANs cover large, global distances.
Network Topologies (Arrangements)
• Bus Topology: All nodes are connected to a single central cable (the backbone). It
is simple but if the backbone fails, the network fails.

• Star Topology: All nodes connect to a central device (switch or hub). It is the most
common, as isolating a faulty node is easy, but the center is a single point of failure.

• Mesh Topology: Every device is connected to every other device (full mesh) or
some devices (partial mesh), providing high reliability.

• Ring Topology: Nodes are connected in a closed loop. Data travels in one direction,
and failure of one node can disrupt the network.

• Tree (Hierarchical) Topology: A root node connects to other nodes in a hierarchy,

often used for WANs.

Types of Networks (Scale)

• Local Area Network (LAN): Connects devices in a small area like a home, office, or
building.
o Characteristics: High speed (100 Mbps to 10 Gbps), low cost, private
ownership.
o Usage: File sharing, printer sharing.

• Metropolitan Area Network (MAN): Spans a city or a large campus, connecting

multiple LANs together.
o Characteristics: Covers 5–50 km, higher speed than WAN, moderate cost.
o Usage: Cable television, city-wide surveillance, campus networking.

• Wide Area Network (WAN): Spans large geographical areas, such as countries or
continents.
o Characteristics: Lower speed than LAN, high latency, uses public or leased lines.
o Usage: The Internet is the most common example
Summary Table
Feature LAN MAN WAN

Area Small (Building) City Country/Globe

Speed Very High Moderate Low

Cost Inexpensive Expensive Very Expensive

Latency Very Low Moderate High

Q-5] Write the process of creating Table in MS-WORD

Creating a table in MS Word is a straightforward process, primarily done via the Insert tab.
Here are the different methods to create, format, and manage tables.
1. Using the Table Grid (Fastest Method)
1. Place the cursor in your document where you want the table.

2. Go to the Insert tab on the top ribbon.

3. Click the Table button.

4. Drag your mouse cursor over the grid to select the desired number of rows and
columns (e.g., 3x4 table).

5. Click the mouse, and the table will appear in your document.

2. Using the "Insert Table" Dialog Box (For Larger Tables)

1. Go to the Insert tab and click Table.

2. Select Insert Table from the dropdown menu.

3. A dialog box will appear; enter the specific number of columns and rows you
need.

4. Choose AutoFit behavior (optional) to set column widths.

5. Click OK.

3. Drawing a Table (For Custom/Complex Layouts)

1. Go to the Insert tab > Table.

2. Select Draw Table.

3. Your cursor will turn into a pencil; click and drag to draw the outer box, then
draw vertical and horizontal lines to create cells.

4. To stop drawing, press Esc on your keyboard or click the Draw Table button
again.
Q-6] Explain the process of Mail-merge in MS-WORD

Mail merge in MS Word (found under the Mailings tab) combines a main document
with a data source (like Excel or Outlook) to create personalized, bulk documents.
The key steps are: starting the merge, selecting recipients, inserting merge fields,
previewing, and finishing/merging.
Detailed Steps for Mail Merge
1. Open or Create the Main Document: Open MS Word and start a blank document or
open your template.

2. Start the Mail Merge: Go to the Mailings tab, click Start Mail Merge, and select the
document type (e.g., Letters, E-mail Messages, Envelopes, or Labels).

3. Select Recipients (Data Source):

• Click Select Recipients in the Mailings tab.

• Choose Use an Existing List (select an Excel sheet or Access database).

• Alternatively, choose Type a New List to enter recipient data manually.

4. Insert Merge Fields:

• Place your cursor in the document where you want personal information to
appear.

• Click Insert Merge Field in the Mailings tab and select the desired field (e.g.,
First Name, Address).

5. Preview the Results: Click Preview Results to see how the finalized, populated
documents will look.

6. Finish & Merge:

• Click Finish & Merge to complete the process.

• Choose Edit Individual Documents to customize specific items, or Print

Documents / Send Email Messages to send them in bulk.

Key Considerations:
• Ensure your data source (e.g., Excel file) is saved and closed before merging.

• If sending emails, ensure each recipient has a corresponding email address in the
data source
Q-7] Write the features and use of Power Point 2007

Microsoft PowerPoint 2007 is a presentation graphics program that revolutionized the user
interface with the introduction of the Ribbon, replacing traditional menus and toolbars. It
is designed to create, view, and present slide shows that combine text, images, graphs,
SmartArt, animations, and videos, primarily used for professional or educational
presentations.
Key Features of PowerPoint 2007
• Ribbon Interface: A, task-oriented tab system (Home, Insert, Design, etc.) that
makes commands more accessible, replacing the old menu-based system.
• Office Button: Replaces the 'File' menu, allowing users to open, save, print, and
publish presentations.
• SmartArt Graphics: A new feature allowing users to turn bullet points into
professional, editable diagrams (lists, processes, hierarchies, cycles) in a single click.
• Office Themes & Quick Styles: Pre-designed templates that allow consistent
formatting (fonts, colors, and effects) across all slides and applications (Word/Excel).
• Live Preview: Enables users to see how changes (like fonts, themes, or layouts) will
look before actually applying them.
• Custom Animations and Transitions: Improved tools to add motion effects to
objects and smooth, professional transitions between slides.
• Enhanced Picture Editing: Features to easily crop, recolor, add styles, and apply
3D effects to pictures.
• PPTX File Format: A new XML-based file format that makes files smaller, more
secure, and less prone to corruption.
• Presenter View: A tool for displaying speaker notes and navigating slides on a dual-
monitor setup.

Uses of PowerPoint 2007

• Educational Presentations: Used by teachers and students to create
interactive lessons, lectures, and projects for smart classes.
• Business Meetings: Used to present sales reports, marketing strategies, or
company updates with charts and graphs.
• Creating Reports and Proposals: Used to generate professional, formatted
documents or, pitches for clients.
• Photo Albums: Features dedicated, easy-to-use tools for creating photo
slideshows.
• Training & Seminars: Used to create engaging, visual aids for workshops
and seminars.
• Kiosk/Self-Running Shows: Used to create automated, looping
presentations for display at conferences or exhibitions
Q-8] Explain the process to creating new presentation using a Blank Presentation
and Template

To create a new presentation in PowerPoint, open the app, click File > New, and
choose either "Blank Presentation" for a fresh start or select a pre-
designed Template/Theme. Blank presentations offer a white, empty slate, while
templates provide styled, pre-formatted, and customizable designs

Steps for a Blank Presentation (From Scratch)

1. Open PowerPoint and select New.

2. Click on Blank Presentation.

3. A default white slide appears, allowing you to add text, images, and content.

4. Use the Home tab to add new slides, or the Design tab to manually add
themes or customize the background later.

Steps for a Template (Pre-designed)

1. Open PowerPoint and click File > New.

2. Browse or search the available templates in the search box (e.g., "business,"
"education").

3. Select a template to see a preview, then click Create to download and open
it.

4. Edit the text and visuals within the pre-designed layout.

Key Tips
• Saving: Click File > Save to name and store your file.

• Pinning: Hover over a template and click the pushpin icon to keep it at the
top of your list for future use.

• Customization: Templates can be modified, including changing colors and

fonts.

Q-9] Explain different slide views in Power Point 2007

PowerPoint 2007 offers four main views to facilitate creation and

delivery: Normal (default editing), Slide Sorter (thumbnail layout
rearrangement), Slide Show (full-screen presentation), and Notes Page (speaker
note editing). These are accessed via the View tab or the bottom-right toolbar.
Key Slide Views in PowerPoint 2007:
• Normal View: The default workspace used for editing, where you can add
text, graphics, and layout elements to individual slides. It typically shows a
large view of the current slide, with thumbnails on the left, and a notes pane
below.

• Slide Sorter View: Displays all slides as thumbnail-sized images, making it

easy to reorder, add, or delete slides to organize the flow of the presentation.

• Slide Show View: Fills the computer screen with the presentation, simulating
how the audience will see the final product. It is used for delivering the
presentation, with navigation controls for moving between slides.

• Notes Page View: Displays each slide on a separate page, featuring a text
placeholder below it for speaker notes or scripts. This is ideal for printing out
notes for reference during the presentation.

• Master Views (Slide, Handout, Notes): These are used to set global
formatting, such as theme, fonts, and backgrounds, that apply to the entire
presentation, allowing for consistent styling.

These views can be accessed directly from the View tab on the Ribbon or by using
the view buttons located on the bottom-right corner of the window

Q-10] Write the process of applying slide designs & themes in Power Point 2007

Applying slide designs and themes in PowerPoint 2007 allows for the quick,
consistent formatting of a presentation, covering colors, fonts, and background
styles. These options are found under the Design tab on the ribbon.
Here is the step-by-step process:
1. Applying a Theme to All Slides
1. Open the Presentation: Open your PowerPoint 2007 file.

2. Navigate to the Design Tab: Click on the Design tab in the Ribbon.

3. Select a Theme: In the Themes group, click on any of the displayed

thumbnail previews to apply it to all slides.

4. View More Options: Click the More button (downward arrow) in the bottom-
right corner of the Themes group to see all available themes.

5. Live Preview: Hover your mouse over any theme thumbnail to see a live
preview of how it looks on your slide before selecting it.
2. Applying a Theme to Selected Slides Only
1. Select Slides: In the Slides/Outline pane on the left, click the specific slide(s)
you want to change.
• Note: Hold down the Ctrl key to select multiple individual slides.

2. Choose Theme: Go to the Design tab and locate the Themes group.

3. Right-Click and Apply: Right-click the desired theme and select Apply to
Selected Slides.

3. Customizing Themes (Colors, Fonts, Backgrounds)

After applying a theme, you can further customize it using the options in
the Background group on the Design tab:
• Colors: Change the theme's color palette by clicking Colors and selecting a
new set.

• Fonts: Change the theme's font pairing by clicking Fonts.

• Background Styles: Click Background Styles to select a different

background color or format, such as a solid color or gradient.

4. Setting a Default Theme

If you want to use a specific theme for all new presentations, right-click a theme in
the gallery and choose Set as Default Theme.

5. Using "Browse for Themes"

If you have a theme file (.thmx) downloaded or saved elsewhere, or want to use the
design of an old presentation:
1. Click the More button in the Themes gallery.

2. Select Browse for Themes.

3. Locate the theme file and click Apply.

Removing a Theme
To remove a custom theme and return to a plain layout, apply the Office
Theme (usually the first option with a white background).