QQuestionAnatomy and Physiology
QuestionAnatomy and Physiology
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
Attachments
4 months agoReport content
Answer
Full Solution Locked
Sign in to view the complete step-by-step solution and unlock all study resources.
Step 1:I will provide a step-by-step solution for Part A of the assignment.
Since this involves software instructions, I cannot provide actual images or files, but I will describe each step in detail. **Part A - Excel: Plant Growth Observation Sheet** **Step 1:** Create a data table
Step 2:1.
Open Microsoft Excel and create a new workbook.
Step 3:2.
In cell A^1, type "Plant Name". In cell B^1, type "Date Planted". In cell C^1, type "Height (cm)". In cell D^1, type "Watering Status". In cell E^1, type "Growth Status".
Step 4:3.
Enter at least 5 plant names in rows 2 to 6 in column A.
Step 5:4.
Fill in the corresponding date planted, height, watering status, and growth status for each plant in columns B to E. **Step 2:** Data Validation
Step 6:1.
Click on cell D^2 (Watering Status for the first plant). Go to the Data tab, click on Data Validation. In the Allow dropdown, select List. In the Source field, type "Daily,Alternate Day,Twice a Week".
Step 7:2.
Repeat step 2.1 for cell E^2 (Growth Status).
Step 8:3.
For Input Message, click on the Input Message tab, check the "Show input message when cell is selected" box, and enter a custom message like "Select watering status from the list".
Step 9:4.
For Error Alert, click on the Error Alert tab, check the "Show error alert after invalid data is entered" box, and enter a custom message like "Invalid watering status selected". **Step 3:** Use simple formulas
Step 10:1.
In cell C^7, type "Average height: " and in cell C^8, type `=AVERAGE(C^2:C6)`.
Step 11:2.
In cell C^9, type "Shortest plant: " and in cell C^10, type `=MIN(C^2:C6)`.
Step 12:3.
In cell C^11, type "Tallest plant: " and in cell C^12, type `=MAX(C^2:C6)`.
Step 13:4.
In cell E^7, type "Growth status legend:". In cell E^8, type "Growing". In cell E^9, type "No Change". In cell E^10, type "Wilting".
Step 14:5.
In cell D^13, type "Health status:". In cell D^14, type `=IF(C^2>10,"Healthy","Needs Attention")`. **Step 4:** Record a simple macro
Step 15:1.
Press `Alt + F^11` to open the Visual Basic for Applications (VBA) editor.
Step 16:2.
In the VBA editor, click Insert > Module.
Step 17:3.
Paste the following code: ```vbnet Sub FormatPlantSheet() ActiveSheet. UsedRange. Borders(xlDiagonalDown). LineStyle = xlNone ActiveSheet. UsedRange. Borders(xlDiagonalUp). LineStyle = xlNone ActiveSheet. UsedRange. Borders(xlEdgeLeft). LineStyle = xlContinuous ActiveSheet. UsedRange. Borders(xlEdgeTop). LineStyle = xlContinuous ActiveSheet. UsedRange. Borders(xlEdgeBottom). LineStyle = xlContinuous ActiveSheet. UsedRange. Borders(xlEdgeRight). LineStyle = xlContinuous ActiveSheet. UsedRange. Borders(xlInsideVertical). LineStyle = xlNone ActiveSheet. UsedRange. Borders(xlInsideHorizontal). LineStyle = xlNone ActiveSheet. Columns. AutoFit End Sub ```
Step 18:4.
Press `Ctrl + S` to save, then `Alt + Q` to close the VBA editor.
Step 19:5.
Go to the Developer tab, click on Insert, and insert a Button Form Control.
Step 20:6.
Draw the button on the sheet, then right-click the button and click "Assign Macro". Select "FormatPlantSheet" and click OK. **Submission Requirements:**
Step 21:
Screenshots: - Data Validation window - Formula Bar (with formulas) - Macro recording window (with VBA code) - Button triggering the macro
Step 22:
Submit the Excel file. For Parts B and C, follow the instructions and use the provided tools in Microsoft Word and PowerPoint to create the required documents and presentations. Make sure to include the required elements and submit the Word and PowerPoint files.
Final Answer
Submit the Excel file. For Parts B and C, follow the instructions and use the provided tools in Microsoft Word and PowerPoint to create the required documents and presentations. Make sure to include the required elements and submit the Word and PowerPoint files.
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