Collecting Data from the Blood Drive

Collecting Data from the Blood Drive

Use Microsoft Excel to organize, format, and analyze blood drive data in a professional workbook.

Course Objective: This assignment addresses CO-6 (Microsoft Excel spreadsheets).

What You Will Do

In this assignment, you will build an Excel workbook that tracks and analyzes blood drive donor data.

• Create a donor data sheet with 42 records based on Assignment Tasks section below.
• Use formatting, formulas, sorting, and filtering tools.
• Create a summary section with live Excel formulas.
• Prepare the workbook for printing and submit it as an .xlsx file.

Scenario

The blood drive was a success. Dr. Elena Martinez now needs you to organize the donor information in Excel so the clinic can analyze the results and prepare for reporting.

Your workbook should be accurate, clearly formatted, and easy to review.

42

Total Donors

38

Units Collected

4

Deferred

Story So Far

In Week 1, you handled communication and scheduling. In Week 2, you created the flyer. In Week 3, you built the staff training presentation. This week, you are working with the event data in Excel.

Week 1: CommunicateWeek 2: AdvertiseWeek 3: Train StaffWeek 4: Track DataWeek 5: Report Results

Assignment Tasks

Select each item to view the workbook requirements.

Task 1: Donor Data Sheet (20 pts)

Task 2: Formatting (15 pts)

Task 3: Formulas and Analysis (20 pts)

Task 4: Sorting and Filtering (20 pts)

Task 5: Print Setup (15 pts)

Task 6: Final Review and Submit (0 pts)

Assignment Videos

If you get stuck on this assignment, review the following videos to help with completing the assignment.

Excel Tutorial for BeginnersExcel Formulas and Functions

▶Excel Tutorial for Beginners • Full Course • 120 min

Assignment Completion

Read each item to review final steps before you submit.

Requirements Checklist

Before you submit, make sure each item below is complete.

Workbook includes 42 donor records with all eight columns.

Exactly four donors are marked deferred with 0 units collected.

Data validation is applied to Blood Type and Status.

Headers are bold and include fill color and borders.

Deferred donors are highlighted with conditional formatting.

The top row is frozen.

Column widths are adjusted to show all content clearly.

Summary includes SUM, AVERAGE, COUNT or COUNTA, COUNTIF, IF, MIN, and MAX formulas.

All formulas use real cell references.

Data is sorted by Blood Type and then Last Name.

AutoFilter is applied to all columns.

Filtered View sheet includes the O+ screenshot.

Print settings are correct.

The file is saved as LastName_Week4_BloodDrive.xlsx.

Step-by-Step Instructions

1. Open Excel and create a blank workbook.
2. Rename the first sheet Donor Data.
3. Create headers for the eight required columns.
4. Enter 42 donor records and mark four as deferred.
5. Apply data validation to Blood Type and Status.
6. Format the sheet with bold headers, borders, and conditional formatting.
7. Freeze the top row and adjust column widths.
8. Create a summary section with all required formulas.
9. Sort the data and apply AutoFilter.
10. Filter for O+ donors and place a screenshot on a sheet named Filtered View.
11. Set print options to landscape and fit one page wide.
12. Save the workbook as LastName_Week4_BloodDrive.xlsx.

Need Help?

Before submitting, click through each worksheet to confirm the donor sheet, summary area, and filtered screenshot are all included and easy to read.

Grading Rubric

Criteria	Description	Points
Donor Data Sheet	Workbook includes 42 records, realistic data, and required columns with correct data validation.	20
Formatting	Headers, borders, conditional formatting, frozen row, and column widths are applied correctly.	15
Formulas and Analysis	Summary uses live Excel formulas including SUM, AVERAGE, COUNT or COUNTA, COUNTIF, IF, MIN, and MAX.	20
Sorting and Filtering	Workbook shows correct sorting, AutoFilter use, and a separate filtered screenshot sheet.	20
Print Setup	Workbook is prepared for print with correct orientation, scaling, header, and footer.	15
Total	90

Submission Instructions

Submit your completed workbook through Brightspace.

• Format: Excel file (.xlsx)
• File name: LastName_Week4_BloodDrive.xlsx
• Deadline: End of Week 4

Keep your formulas live. Do not replace them with typed values.

Submit Week 4 Assignment

Need Help?

Use these resources if you need support while building your workbook.

Basic Formulas

Read: Formulas and Functions, Parts 1 - 3 for SUM, AVERAGE, COUNT, MIN, and MAX.

COUNTIF and IF

Read: Formulas and Functions, Parts 1 - 3 for conditional formulas such as COUNTIF and IF.

Formatting and Conditional Formatting

Read: Excel Foundations, Parts 1 - 3 for formatting, freezing panes, and conditional formatting.

Sort, Filter, and Print

Read: Formulas and Functions, Parts 1 - 3 for sorting, filtering, and print setup.

Excel Interface Basics

Read: Excel Foundations, Parts 1 - 3 for data entry, Auto Fill, and worksheet tools.

Looking Ahead

You will use this Excel data again in Week 5 to create charts, a dashboard, and an executive summary.