CI2000 week 5 Sharing the Good News

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)

CI2000 - Computer FundamentalsUltimate Medical Academy

Week 5 Assignment | 90 Points | Final Assignment

Sharing the Good News!

Use Microsoft Excel to create charts, advanced formulas, lookup tools, and a professional dashboard that tells the story of the blood drive results.

Course Objectives: This assignment addresses CO-6 (Microsoft Excel spreadsheets) and CO-7 (Healthcare IT).

What You Will Do

In this final assignment, you will build on your Week 4 Excel workbook to create a polished, board-ready report.

• Create charts that summarize the blood drive data clearly.
• Use advanced Excel formulas, including conditional functions and lookup tools.
• Build a dashboard sheet with key metrics and visual summaries.
• Submit the final workbook as an .xlsx file.

Scenario

Dr. Elena Martinez has been invited to share the blood drive results with the Board of Directors. She needs a professional Excel workbook that turns the donor data into charts, analysis, and a dashboard that is easy to understand.

This final project brings together the communication, design, presentation, and spreadsheet skills you practiced throughout the course.

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. In Week 4, you organized the donor data in Excel. This week, you will turn that data into a board-ready report.

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: Pie Chart — Blood Type Distribution (20 pts)

Task 2: Column Chart — Donations by Time Slot (20 pts)

Task 3: Additional Chart of Your Choice (10 pts)

Task 4: Advanced Formulas (15 pts)

Task 5: Donor Information Lookup (10 pts)

Task 6: Executive Summary Dashboard (15 pts)

Task 7: Final Review and Submit (0 pts)