QQuestionNursing
QuestionNursing
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(C^2>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: Sheet^1]
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: Sheet^2]
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
Attachments
7 days agoReport content
Answer
Full Solution Locked
Sign in to view the complete step-by-step solution and unlock all study resources.
Step 1**Step 1:** In Microsoft Word, create a new document for the Plant Growth Observation Report.
Save this document with an appropriate name, such as "PlantGrowthReport\_YourName." **Step 2:** Create a small table summarizing the plant names and their current heights. - Click on the "Insert" tab in the ribbon and select "Table." Choose a 2x^3 table. - In the first row, type "Plant Name" and "Current Height (cm)" in the first and second columns, respectively. - In the second row, type the plant names and their corresponding heights from the Excel sheet. **Step 3:** Insert a picture of any plant. - Click on the "Insert" tab in the ribbon and select "Pictures." Choose a picture of a plant. - After inserting the picture, right-click on it and select "Wrap Text" > "Tight." - Add Alt Text to the picture by right-clicking on it, selecting "Accessibility" > "Alt Text." Type a short description of the picture. - Add a caption to the picture by right-clicking on it, selecting "Insert Caption." Choose a caption label, such as "Figure 1." **Step 4:** Add basic formatting. - Click on the "Design" tab in the ribbon and add a header with your name. - Click on the "Insert" tab in the ribbon and add a page number in the footer. - Write one paragraph describing the plant growth activity. - Apply line spacing or alignment formatting as needed. **Step 5:** Save the Word document. **Step 6:** Take screenshots showing the Alt Text panel, Caption dialog, and ribbon showing formatting. **
Final Answer
** Submit the Word file with the requested screenshots.
Need Help with Homework?
Stuck on a difficult problem? We've got you covered:
- Post your question or upload an image
- Get instant step-by-step solutions
- Learn from our AI and community of students