Biotechnology Notes, Questions, and Study Resources

assignment: Download a research article should not be a review article impact factor higher than 1.2 ( not 1.2) Should not be any Pakistani and Indian author Should be biotechnology related Should not be older than 2000 ( not 2000)

Give part c with full steps and how to make it lavender themed 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

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