CTE 113 - COMPUTER APPLICATION PACKAGE

Practical 1
Title of the Experiment: How to make use of word processor (MS Word)
Aims of Objectives: The main objective of this practical is to learn how to make
use of word processor (MS Word) to type document and design.
Apparatus Required:
I. Microsoft word
II. Desktop computer / Laptop

Theory of the Experiment:

Using a word processor like Microsoft Word can be quite versatile. Here's a basic guide
learnt in class to get you started:

1. Creating a New Document:

 Open Microsoft Word.

 Click on "Blank Document" to start with a new, empty document.

2. Typing Text:

 Click on the blank page and start typing.

 You can change font style, size, and color from the toolbar at the top.

3. Formatting Text:

 Highlight the text you want to format.

 You can make text bold, italic, underline, or change its alignment using the toolbar.
 You can also change the font type, size, color, and apply various styles.

4. Inserting Images:
 Go to the "Insert" tab on the toolbar.
 Click on "Pictures" to insert images from your computer.
 You can also insert shapes, icons, 3D models, and other elements from the "Insert" tab.

5. Page Layout:

 You can adjust page margins, orientation (portrait or landscape), and size from the
"Layout" tab.
 Add headers and footers, page numbers, and customize the layout of your document.

6. Spell Check and Grammar:

 Microsoft Word automatically checks your spelling and grammar as you type.
 Misspelled words will be underlined in red. Right-click on them to see suggested
corrections.
 Grammar errors will be underlined in green.

7. Saving Your Document:

 Click on the floppy disk icon (or go to File > Save) to save your document.
 Choose a location on your computer and give your document a name.
 Word documents usually have the extension ".docx".

8. Printing:

 To print your document, go to File > Print.

 Adjust print settings such as the number of copies, printer selection, and page range.
 Click "Print" to print your document.

9. Advanced Features:

 Explore other features such as tables, footnotes, endnotes, citations, and more from the
toolbar.
 You can also add comments, track changes, and collaborate with others on the same
document.
Discussion/Result:

Microsoft Word is a versatile tool that can be used to create a wide range of documents,
from simple letters and resumes to complex reports and newsletters. Here are some of
the things will create in class using MS Word:

 Personal letters
 Professional resumes
 Curriculum vitae (CVs)
 Cover letters
 Basic slide presentations can be created in Word using features like text boxes, images,
and SmartArt graphics.
 Flyers
 Study guides
 Handouts
 eBooks

The possibilities are quite extensive, and with Word's formatting and design features,
you can customize your documents to suit your specific needs and preferences. Whether
for personal or professional use, Microsoft Word remains a go-to tool for document
creation and editing.

Precautions:

When using Microsoft Word, there are several precautions you should consider to
ensure the security, integrity, and proper functioning of your documents:

1. Use Trusted Sources

2. Beware of Phishing

3. Regularly Update Software

4. Use Password Protection

5. Backup Important Documents

6. Protect Against Data Loss

Diagram
1.
2.
Practical 2
Title of the Experiment: How to make use of spreadsheet (MS Excel)
Aims of Objectives: The main objective of this practical is to learn how to make
use of spreadsheet (MS Excel) to organize, analyze, and visualize data.
Apparatus Required:
III. Microsoft Excel
IV. Desktop computer / Laptop

Theory of the Experiment:

Using a spreadsheet program like Microsoft Excel can help you organize, analyze, and
visualize data efficiently. Here's a basic guide to get you started with Excel we use in
class:

1. Creating a New Workbook:

 Open Microsoft Excel.

 You'll start with a new workbook containing one or more worksheets (tabs at the
bottom).

2. Entering Data:

 Click on a cell and start typing to enter data.

 You can enter text, numbers, dates, and formulas into cells.
 Press Enter to move to the next cell or use the arrow keys to navigate.

3. Formatting Cells:

 Select the cells you want to format.

 Use the toolbar at the top to change font styles, sizes, colors, and alignment.
 You can also format cells for specific data types (e.g., currency, percentage, date) from
the Number Format dropdown.

4. Working with Formulas and Functions:

 Formulas are equations that perform calculations on values in your worksheet.
 Start a formula with an equals sign (=) followed by the calculation.
 Excel offers a wide range of functions for various purposes (e.g., SUM, AVERAGE).
 Use the Formulas tab to insert functions or explore function categories.

5. Creating Charts and Graphs:

 Select the data you want to visualize.

 Go to the Insert tab and choose the chart type (e.g., bar chart, line chart, pie chart).
 Excel will generate a chart based on your selected data.

6. Sorting and Filtering Data:

 Select the range of cells you want to sort or filter.

 Go to the Data tab and use the Sort or Filter options.
 Sorting arranges data in ascending or descending order.
 Filtering allows you to display only specific rows based on criteria you set.

7. Using Conditional Formatting:

 Conditional formatting highlights cells based on specified conditions.

 Select the cells you want to format.
 Go to the Home tab and choose from various conditional formatting options (e.g., color
scales, data bars, icon sets).

8. Protecting Worksheets:

 You can protect worksheets to prevent accidental changes to important data.

 Go to the Review tab and click on Protect Sheet.
 Set a password and choose the actions users are allowed to perform.

9. Saving and Sharing Workbooks:

 Click on the floppy disk icon (or go to File > Save) to save your workbook.
 Choose a location on your computer and give your workbook a name.
 You can share Excel workbooks via email, cloud storage, or network drives.

Discussion/Result:

Microsoft Excel is a powerful spreadsheet program that can be used for a wide range of
tasks in various fields. Here's a discussion of some common uses for Excel:

1. Data Analysis and Visualization:

 Excel is commonly used to analyze and visualize data. You can perform calculations,
create charts, and graphs to identify trends, patterns, and relationships within your data.

2. Financial Management:

 Excel is widely used for financial tasks such as budgeting, expense tracking, and financial
forecasting. You can create spreadsheets to manage income, expenses, investments, and
savings.

3. Inventory Management:

 Excel can be used to track inventory levels, monitor stock movements, and manage
supply chain operations. You can create spreadsheets to record inventory data, calculate
reorder points, and analyze inventory trends.

4. Data Entry and Storage:

 Excel can serve as a database for storing and organizing data. You can create structured
spreadsheets to store information such as customer details, product catalogs, employee
records, and sales transactions.

5. Statistical Analysis:

 Excel provides built-in statistical functions and tools for statistical analysis. You can
calculate descriptive statistics, perform hypothesis testing, and conduct regression
analysis to analyze data and make informed decisions.

6. Educational and Academic Purposes:

 Excel is widely used in education and academia for teaching, research, and analysis.
Students and researchers can use Excel to analyze data, perform simulations, and
visualize results across various disciplines.

7. Decision Making and Planning:

 Excel can support decision making and planning across different contexts. Whether it's
making strategic business decisions, planning marketing campaigns, or organizing
personal tasks, Excel provides tools for analyzing data and making informed decisions.

Diagram
1.