Introduction to Practical or Lab Class
MSOFFICE
1. Microsoft Word Basics
A. Creating a New Document:
- Starting a New Document:
- Open MS Word and create a new blank document.
B. Basic Document Functions:
- Entering Text:
- Type text and perform basic editing tasks.
- Saving Documents:
- Save your document with a specific name and file format.
- Opening Existing Documents:
- Open and edit previously saved documents.
C. Basic Formatting:
- Text Formatting:
- Apply basic formatting such as bold, italics, and underline.
- Paragraph Formatting:
- Align text (left, center, right) and adjust line spacing.
2. Microsoft Excel Basics
A. Introduction to Excel:
- Spreadsheet Basics:
- Overview of cells, rows, and columns.
- Entering Data:
- Type data into cells and perform basic calculations.
B. Basic Functions:
- Formulas:
- Introduction to basic formulas like SUM and AVERAGE.
- Formatting Cells:
- Adjust cell formatting, including number formats and alignment.
C. Saving and Opening Workbooks:
- Saving Workbooks:
- Save your Excel workbook with a specific name and format.
- Opening Existing Workbooks:
- Open and edit previously saved workbooks.
3. Microsoft PowerPoint Basics
A. Creating a Presentation:
- Starting a New Presentation:
- Open PowerPoint and create a new blank presentation.
B. Basic Slide Functions:
- Adding Slides:
- Insert new slides and choose layouts.
- Entering Text:
- Add and format text on slides.
C. Basic Presentation Formatting:
- Design Themes:
- Apply design themes to your presentation.
- Slide Transitions:
- Apply basic slide transitions to enhance your presentation.
Hands-On Practice
A. Practical Exercises:
- Word Exercise:
- Create and format a simple document (e.g., a brief report or memo).
- Excel Exercise:
- Enter data into a spreadsheet and perform basic calculations.
- PowerPoint Exercise:
- Create a basic presentation with a few slides and apply a design theme.
B. Assignment:
- Word Assignment:
- Create a formatted business letter.
- Excel Assignment:
- Create a simple budget spreadsheet with basic formulas.
- PowerPoint Assignment:
- Create a 3-slide presentation on a topic of choice.
Class 1: Assignments
1. Microsoft Word Assignment:
A. Create a Business Letter
Objective:
Apply basic text formatting and document creation skills.
Instructions:
- Create a New Document:
- Open Microsoft Word and start a new blank document.
- Compose the Letter:
- Write a business letter addressed to a hypothetical client or colleague. Include the following sections:
- Sender's Address: Your address or a fictional address.
- Date: The current date.
- Recipient's Address: The address of the recipient.
- Salutation: e.g., "Dear [Recipient's Name],"
- Body: Write the main content of the letter, including an introduction, main points, and a closing statement.
- Closing: e.g., "Sincerely," followed by your name.
- Format the Letter:
- Use basic formatting tools such as bold, italics, and underline to enhance the appearance.
- Adjust font style and size for readability.
- Align text properly and ensure consistent spacing.
- Save and Submit:
- Save the document as Business_Letter_YourName.docx.
- Submit the file according to your instructor’s guidelines.
2. Microsoft Excel Assignment:
A. Create a Simple Budget Spreadsheet
Objective:
Use basic Excel functions and formatting for data management.
Instructions:
- Create a New Workbook:
- Open Microsoft Excel and start a new blank workbook.
- Enter Data:
- In the first sheet, create a budget spreadsheet with the following columns:
- Category: e.g., Rent, Utilities, Groceries, Entertainment.
- Estimated Cost: Enter estimated costs for each category.
- Actual Cost: Enter actual costs for each category.
- Difference: Use a formula to calculate the difference between estimated and actual costs.
- Apply Basic Formatting:
- Use cell formatting to make the spreadsheet clear and readable.
- Apply basic formulas such as SUM to calculate total estimated and actual costs.
- Format cells with currency where appropriate.
- Save and Submit:
- Save the workbook as Budget_Spreadsheet_YourName.xlsx.
- Submit the file according to your instructor’s guidelines.
3. Microsoft PowerPoint Assignment:
A. Create a Basic Presentation
Objective:
Design a simple presentation to practice slide creation and formatting.
Instructions:
- Create a New Presentation:
- Open Microsoft PowerPoint and start a new blank presentation.
- Design the Slides:
- Title Slide: Include a title and a subtitle.
- Content Slides: Create two additional slides with the following content:
- Slide 1: Add a bullet-point list about a topic of your choice (e.g., "Benefits of Technology in Business").
- Slide 2: Add a chart or image related to the topic and provide a brief explanation.
- Format the Presentation:
- Apply a design theme to the entire presentation.
- Add slide transitions for visual appeal.
- Save and Submit:
- Save the presentation as Basic_Presentation_YourName.pptx.
- Submit the file according to your instructor’s guidelines.
These assignments will help students practice fundamental skills in Microsoft Word, Excel, and PowerPoint, setting a strong foundation for more advanced topics in subsequent classes.
Detailed Assignments(Solutions)
1. Microsoft Word Assignment:
Question. Create a Business Letter
Objective:
Apply basic text formatting and document creation skills.
Instructions:
- Create a New Document:
- Open Microsoft Word.
- Click on File > New > Blank Document to start a new document.
- Compose the Letter:
- Sender's Address:
- Type your address or a fictional address at the top of the document.
- Date:
- Below the sender's address, type the current date.
- Recipient's Address:
- Enter the address of the recipient, starting a few lines below the date.
- Salutation:
- Write a greeting such as "Dear [Recipient's Name],".
- Body:
- Compose the main content of the letter. Include:
- Introduction: A brief introduction stating the purpose of the letter.
- Main Points: Detailed information or requests.
- Conclusion: A closing statement summarizing the letter’s intent.
- Closing:
- Use a closing phrase like "Sincerely," followed by your name or a fictional name.
- Format the Letter:
- Bold: Highlight key information such as the salutation or closing and use the Bold feature.
- Italicize: Emphasize certain parts of the text, if necessary.
- Underline: Use Underline for headings or important details.
- Font and Size: Choose a readable font like Arial or Times New Roman and set the font size to 12 pt.
- Alignment: Align the text to the left and ensure consistent spacing between paragraphs.
- Save and Submit:
- Click File > Save As.
- Choose a location to save the file.
- Enter the filename Business_Letter_YourName.docx.
- Click Save.
- Submit the file according to your instructor’s guidelines.
2. Microsoft Excel Assignment:
Question. Create a Simple Budget Spreadsheet
Objective:
Use basic Excel functions and formatting for data management.
Instructions:
- Create a New Workbook:
- Open Microsoft Excel.
- Click on File > New > Blank Workbook to start a new workbook.
- Enter Data:
- Create Columns:
- In Cell A1, type Category.
- In Cell B1, type Estimated Cost.
- In Cell C1, type Actual Cost.
- In Cell D1, type Difference.
- Enter Categories and Costs:
- Category: Enter items like Rent, Utilities, Groceries, Entertainment in Column A (Cells A2 to A5).
- Estimated Cost: Enter estimated costs for each category in Column B (Cells B2 to B5). For example, 1000, 200, 150, 100.
- Actual Cost: Enter actual costs for each category in Column C (Cells C2 to C5). For example, 950, 210, 160, 90.
- Calculate Difference:
- In Cell D2, enter the formula =C2-B2 to calculate the difference between the actual and estimated costs.
- Drag the fill handle (bottom-right corner of the cell) down to copy the formula to other cells in Column D.
- Apply Basic Formatting:
- Cell Formatting: Format the cells in Columns B, C, and D to display as currency.
- Bold Headers: Bold the text in Row 1 for the headers.
- Borders: Add borders around the data range for clarity.
- Save and Submit:
- Click File > Save As.
- Choose a location to save the file.
- Enter the filename Budget_Spreadsheet_YourName.xlsx.
- Click Save.
- Submit the file according to your instructor’s guidelines.
3. Microsoft PowerPoint Assignment:
Question: Create a Basic Presentation
Objective:
Design a simple presentation to practice slide creation and formatting.
Instructions:
- Create a New Presentation:
- Open Microsoft PowerPoint.
- Click on File > New > Blank Presentation to start a new presentation.
- Design the Slides:
- Title Slide:
- In the first slide, add a title and subtitle. For example:
- Title: Introduction to Market Trends
- Subtitle: An Overview of Recent Developments
- Content Slides:
- Slide 2: Add a bullet-point list on a topic of your choice. For example:
- Title: Key Benefits of Market Research
- Content:
- Understanding Consumer Needs
- Identifying Market Opportunities
- **Enhancing Competitive Strategy`
- Slide 3: Insert a chart or image related to the topic. For example:
- Insert a Pie Chart: Go to the Insert tab, click Chart, and choose a Pie Chart to represent data.
- Insert an Image: Go to the Insert tab, click Pictures, and choose an image to include.
- Format the Presentation:
- Design Theme: Apply a design theme by clicking on the Design tab and selecting a theme.
- Slide Transitions: Add simple transitions between slides by going to the Transitions tab and choosing a transition effect.
- Save and Submit:
- Click File > Save As.
- Choose a location to save the file.
- Enter the filename Basic_Presentation_YourName.pptx.
- Click Save.
- Submit the file according to your instructor’s guidelines.
