Question:
Give part B
A group of biotechnology students is planning a “Plant Growth Observation Activity”
as part of their introductory biology course. They will grow simple plants (such as mint,
beans, mustard, or green peas) and record basic observations such as height, number of
leaves, watering schedule, and growth status.
Your task is to apply Microsoft Excel, Word, and PowerPoint to help students record,
document, and present their plant growth observations.
Complete all tasks in Parts A, B, and C (this is ONE single question).
🌱 PART A — Excel: Plant Growth Observation Sheet
Create a basic Plant Growth Tracker in Microsoft Excel.
1. Create a simple data table
Include at least 5 plants, with columns:
Plant Name (e.g., Mint, Bean Plant, Aloe Vera, etc.)
Date Planted
Height (cm)
Watering Status (Daily / Alternate Day / Twice a Week)
Growth Status (Growing / No Change / Wilting)
2. Data Validation (Required)
Apply Data Validation to:
Watering Status column → Three options only
Growth Status column → Three options only
Add:
An Input Message
An Error Alert
3. Use simple formulas
Insert formulas such as:
AVERAGE() → average plant height
MIN() and MAX() → shortest and tallest plant
IF() → e.g.,
=IF(C2>10,"Healthy","Needs Attention")
4. Record a simple macro
Record a macro named FormatPlantSheet that:
Applies borders to the whole table
Auto-fits columns
Assign the macro to a button or shape.
Submission Requirements
Screenshots:
o
Data Validation window
o
Formula Bar
o
Macro recording window
o
Button triggering the macro
Submit the Excel file
🍃 PART B — Word: Plant Growth Observation Report (C-3 Application)
Prepare a 1–2 page simple report using Microsoft Word.
The report should include:
1. A small table
Summarize the plant names and their current height.
2. One picture
Insert a picture of any plant (real or downloaded).
Apply:
Tight text wrapping
Alt Text
Caption
3. Basic formatting
Include:
A Header with your name
A Footer with page number
One paragraph describing the plant growth activity
Use of line spacing or alignment formatting
Submission Requirements
Screenshots showing:
Alt Text panel
Caption dialog
Ribbon showing formatting
Submit the Word file.
🌻 PART C — PowerPoint: Present the Plant Growth Activity (C-3
Application)
Create a 4-slide basic PowerPoint presentation describing the plant observation
activity.
Required Slides:
1. Title Slide
2. Slide showing a picture of one plant + short description
3. Slide explaining what information was recorded in Excel
4. Slide explaining how Word helps document the activity
Technical Requirements:
Apply one theme
Apply one variant
Add one slide transition
Add one animation
Add a small logo (any leaf or plant icon) using Slide Master
Submission Requirements:
Screenshot of Slide Master
Screenshot of Animation Pane
Screenshot of Theme used
Submit the PPT file
[Sheet: Sheet1]
Plant Selected: Green Peas
Sample Observation Table (7 Days)
Date Plant Type Height Number of Leaves Watering Growth Status
Day 1 Green Peas 2 cm 2 yes seedling appeared
Day 2 Green Peas 2.5 cm 2 yes slight increase in height
Day 3 Green Peas 3 cm 3 yes one new leaf
Day 4 Green Peas 3.8 cm 3 yes stem gettting stronger
Day 5 Green Peas 4.5 cm 4 yes noticeable growth
Day 6 Green Peas 5.2 cm 4 yes plant looks healthy
Day 7 Green Peas 6 cm 5 yes good overall progress
[Sheet: Sheet2]
Plant Name Date Planted Height (cm) Watering Status Growth Status
Lavender 15/10/2025 18 Twice a week Growing
Tomato Plant 1/10/25 25 Daiky Growing
Snake Plant 10/9/25 30 Alternate day No change
Parsley 12/10/25 10 Daily Growing
Cactus 20/08/25 5 Twice a day No change
Average Heights Growth status legend
17.6 Growing
Shortest plant No change
5 Wilting
Tallest plant
30
Health status
Healthy
...
