LECTURE NOTES ON MS WORD: TYPE SETTINGS AND

PAGE SETTINGS

1. Type Settings in MS Word

1.1. Font Type

Definition:
The font type determines the design or appearance of the text in a document. Fonts
are categorized into:

1. Serif Fonts: e.g., Times New Roman (formal and professional look).
2. Sans-serif Fonts: e.g., Arial, Calibri (clean and modern style).
3. Monospace Fonts: e.g., Courier New (uniform character width).
4. Decorative Fonts: e.g., Comic Sans, used for informal documents.

How to Apply in MS Word:

1. Highlight the text you want to format.
2. Navigate to the Home Tab → Font Group → Click the drop-down menu
under Font to select a font type.

1.2. Font Size

Definition:
Font size determines the size of characters in the document, measured in points (pt).
One point equals 1/72 of an inch. Common font sizes:

Body Text: 10pt – 12pt.

Headings: 14pt – 18pt or larger for emphasis.

How to Adjust Font Size:

1. Highlight text → Go to the Home Tab → Font Group → Adjust size using
the Font Size Drop-down Menu or type the size directly.

2. Keyboard Shortcut: Ctrl + Shift + > (increase) or Ctrl + Shift + < (decrease).

Practical Tip: Use 12pt Times New Roman for academic documents.
1.3. Line Spacing
Definition:
Line spacing refers to the vertical space between lines of text in a paragraph.

Single Spacing: Minimal spacing, often for professional or compact documents.

1.5 Spacing: A balance between readability and compactness.
Double Spacing: Common for formal documents, such as essays or research
papers.

How to Apply Line Spacing:

1. Select the paragraph or text.

2. Go to the Home Tab → Paragraph Group → Click Line Spacing Icon (three
horizontal lines with an up/down arrow) → Select preferred spacing (e.g.,
1.0, 1.5, 2.0).
3. Keyboard Shortcut: Ctrl + 2 (double spacing), Ctrl + 1 (single spacing).

Practical Tip: Use double spacing for formal academic work or printing.

1.4. Text Alignment

Definition:
Text alignment refers to the horizontal placement of text within a page. Types of
alignment:

Left Align: Default alignment for most documents.

Center Align: Often used for headings or titles.
Right Align: Used for special formatting, such as page numbers.
Justify: Aligns text to both the left and right margins, giving a clean, professional
appearance.

How to Apply Text Alignment:

1. Highlight text → Go to the Home Tab → Paragraph Group → Click on the
desired alignment icon (Align Left, Center, Right, or Justify).

2. Keyboard Shortcuts:
3. Ctrl + L (Left Align).
4. Ctrl + E (Center Align).
5. Ctrl + R (Right Align).
6. Ctrl + J (Justify).
Practical Tip: Use Justify for professional reports and Left Align for informal notes.
2. Page Settings in MS Word
2.1. Page Breaks
Definition:
A page break ends the current page and moves text to the next page, allowing for
better organization.

Types of Page Breaks:

1. Automatic Page Break: Inserted by Word when the content exceeds the page.
2. Manual Page Break: Inserted manually to control page layout.

How to Insert Page Breaks:

1. Place the cursor where the new page should start.

2. Go to the Insert Tab → Pages Group → Click Page Break.
3. Shortcut: Ctrl + Enter.

Practical Tip: Use manual breaks to separate sections like chapters or appendices.

2.2. Margins
Definition:
Margins are the blank spaces around the edges of a page. Adjusting margins
impacts the printable area.

Default Margins:
Word’s default is 1-inch margins on all sides.

How to Adjust Margins:

1. Go to the Layout Tab → Page Setup Group → Click Margins → Choose

from pre-set options or select Custom Margins to define your own.

Practical Tip: Use 1-inch margins for standard documents, but smaller margins for
space-saving designs.
2.3. Layout Orientation Adjustment
Definition:
Page orientation determines how the text is printed on a page:

Portrait (vertical): Default setting, ideal for most text-based documents.

Landscape (horizontal): Suitable for wide tables, charts, or presentations.

How to Adjust Page Orientation:

2. Go to the Layout Tab → Page Setup Group → Click Orientation → Choose

Portrait or Landscape.

Practical Tip: Use Landscape for data-heavy documents like spreadsheets.

Understanding and applying these type and page settings in MS Word is essential
for creating professional and visually appealing documents. Proper formatting
ensures readability, accessibility, and compliance with academic or organizational
standards.
 LECTURE NOTES ON EXCEL: DATA COLLATION,
SORTING, AND ANALYSIS

1. Data Collation in Excel

1.1. Definition:
Data collation involves gathering and organizing information systematically in
Excel for analysis. In this case, the data will be grouped by gender and age ranges.

1.2. Steps for Data Collation:

1. Create a Table:

a. Open Excel and create column headers: Student Name, Gender, Age, Age
Group.

b. Enter the raw data under each column (e.g., student names, their gender, and
ages).

2. Group Ages into Categories:

a. Add a new column labeled Age Group to classify ages into ranges such as
5–10, 10–15, 15–20.

b. Use logical reasoning to assign each age into the appropriate group manually.

2. Sorting Data in Excel

2.1. Purpose of Sorting:

Sorting helps organize data in a logical order, making it easier to analyze and
compare. For this illustration, the data will be sorted by Gender and then by Age
Group.
2.2. Steps to Sort Data:
1. Highlight the Table:
a. Select the entire table, including the column headers.

2. Open the Sort Tool:

b. Go to the Data Tab → Click on Sort.

3. Set Sorting Criteria:

c. In the Sort by dropdown menu, select Gender.
d. Choose the sorting order (e.g., A to Z for Male → Female).
e. Click Add Level to set another criterion, such as Age Group.
f. Select the order (e.g., smallest to largest or 5–10 → 10–15 → 15–20).

4. Apply Sorting:
a. Click OK. The table will now be sorted according to your criteria.

3. Data Analysis in Excel

3.1. Purpose of Data Analysis:
b. Analyzing data helps to summarize and identify trends, such as the number
of males and females in each age group.

3.2. Steps for Analyzing Data:

1. Create a Summary Table:
a. Manually list the Age Groups (5–10, 10–15, 15–20) in a new section of the
sheet.
b. Add columns for Male, Female, and Total.

2. Count Population by Category:

a. Count the number of Males and Females for each age group manually or by
reviewing the sorted table.
b. Enter the total count in the corresponding row of the summary table.

4. Representing Analyzed Data Using Charts

4.1. Creating a Bar Chart:

a. Highlight the Summary Table:
b. Select the Age Group, Male, and Female columns.
2. Insert a Bar Chart:
a. Go to the Insert Tab → Charts Group → Select Clustered Bar Chart.

3. Customize the Chart:

b. Add a title (e.g., "Class Population by Age Group and Gender").
c. Label the X-axis (Population) and Y-axis (Age Group).
d. Adjust bar colors to differentiate Male and Female categories.

4.2. Creating a Pie Chart:

1. Highlight Data for Total Population:

a. Select the Age Group and Total Population columns.

2. Insert a Pie Chart:

b. Go to the Insert Tab → Charts Group → Select Pie Chart.

3. Customize the Chart:

c. Add a title (e.g., "Class Population Distribution by Age Group").
d. Add data labels to display percentages or totals for each segment.

Using Excel for data collation, sorting, and analysis is a practical way to manage
and interpret information. Visual representation through charts enhances
understanding and communication of results.
 LECTURE NOTES ON POWERPOINT

1. Changing Slide Background

1.1. Purpose of Changing the Background:
Changing the background of a slide enhances the visual appeal of a presentation
and ensures it aligns with the theme or content.

1.2. Steps to Change the Slide Background:

1. Select the Slide:
a. Click on the slide you want to modify in the slide pane.

2. Open Background Settings:

b. Go to the Design Tab → Click on Format Background (found at the far
right).

3. Choose Background Type:

c. Select from options such as Solid Fill, Gradient Fill, Picture or Texture Fill,
or Pattern Fill:
Solid Fill: Choose a single color.
Gradient Fill: Select a color gradient effect.
Picture or Texture Fill: Use a custom image or texture.
Pattern Fill: Use predefined patterns like stripes or dots.

4. Apply the Background:

d. Click Apply to All to change the background for all slides, or click Close to
apply to only the selected slide.

2. Text Formatting
2.1. Purpose of Text Formatting:

Proper text formatting makes your presentation easier to read and visually
appealing, highlighting key information effectively.

2.2. Steps for Text Formatting:

1. Select the Text Box:
a. Click inside the text box you want to format.

2. Change Font Type:

 b. Go to the Home Tab → In the Font group, choose a font from the dropdown
list (e.g., Arial, Times New Roman).
3. Adjust Font Size:
c. In the Font group, adjust the font size by using the up and down arrows or
typing in a custom size.

4. Change Font Color:

d. Click on the Font Color button in the Font group and select a color from the
palette.

5. Text Style and Effects:

e. Bold, Italicize, or Underline the text using the respective buttons in the Font
group.
f. Add additional text effects (e.g., shadow, glow) by clicking on the Text
Effects button in the Font group.

6. Text Alignment:
g. Align text left, center, right, or justified using the Paragraph group.

h. Adjust line spacing by selecting the Line Spacing button in the Paragraph
group.

3. Inserting Pictures and Charts

3.1. Purpose of Inserting Pictures and Charts:

a. Adding pictures and charts enhances visual appeal and makes the
presentation more informative and engaging.

3.2. Steps for Inserting Pictures:

1. Insert a Picture from File:
b. Go to the Insert Tab → Click Pictures → Select This Device to upload a
picture from your computer.
c. Browse and select the image, then click Insert.

2. Insert a Picture from Online Sources:

a. Go to the Insert Tab → Click Pictures → Select Online Pictures to search for
images from Bing or other online sources.

3. Resize and Position the Picture:

b. Click and drag the image’s corners to resize it.
 c. Use the handles to reposition the image on the slide.

3.3. Steps for Inserting Charts:

1. Insert a Chart:
a. Go to the Insert Tab → Click on Chart.
b. Choose the chart type (e.g., Bar, Pie, Line) and click OK.

2. Edit Data for the Chart:

a. An Excel spreadsheet window will open. Enter the data for the chart.
b. Close the Excel window once the data is entered, and the chart will
automatically update.

3. Format the Chart:

a. Use the Chart Tools ribbon to customize the chart’s design, colors, and
layout.

4. Creating Slides
4.1. Purpose of Creating Slides:
Slides are the core of a PowerPoint presentation, and it’s important to know how to
create and organize them effectively.

4.2. Steps for Creating New Slides:

1. Create a New Slide:
a. Go to the Home Tab → Click New Slide → Select a slide layout (e.g., Title
Slide, Title and Content, Blank, etc.).

2. Add Content to the Slide:

b. Click on the placeholders (title, content boxes) to add text, images, or other
objects.
c. If necessary, insert additional text boxes or shapes by using the options in
the Insert Tab.

3. Duplicate a Slide:
a. Right-click the slide in the slide pane and select Duplicate Slide to create a
copy.

4. Delete a Slide:
b. Right-click on the slide you want to remove and select Delete Slide or press
Delete on the keyboard.
5. Applying Animations and Transitions
5.1. Purpose of Animations and Transitions:
Animations make objects on a slide move or appear in a creative way. Transitions
control how one slide changes to the next.

5.2. Steps to Apply Animations:

1. Select the Object to Animate:
a. Click on the text, image, or shape you want to animate.

2. Choose an Animation Effect:

b. Go to the Animations Tab → In the Animation group, select an animation
effect (e.g., Fade, Fly In, Wipe).

3. Customize the Animation:

c. Click Animation Pane to open the animation options.
d. Adjust the timing, delay, and start options (On Click, With Previous, After
Previous).

4. Apply Multiple Animations:

a. Select multiple objects and apply different animation effects to each.

5.3. Steps to Apply Slide Transitions:

1. Select a Slide:
a. Click on the slide you want to apply a transition to.

2. Choose a Transition Effect:

b. Go to the Transitions Tab → In the Transition to This Slide group, choose a
transition effect (e.g., Fade, Push, Wipe).

3. Adjust Transition Timing:

c. Set the duration and add sound if desired.
d. Choose On Mouse Click or After to determine when the transition will occur.

4. Apply Transition to All Slides:

a. If you want to apply the same transition effect to all slides, click Apply to
All.