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
7 days agoReport content
Answer
Full Solution Locked
Sign in to view the complete step-by-step solution and unlock all study resources.
Step 1I 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 21.
Open Microsoft Excel and create a new workbook.
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