Available with: Microsoft 365 Copilot
Government scenario: Create a public hearing briefing deck
Scenario
AI accelerates the creation of public hearing materials by automating feedback analysis, drafting talking points, and building a polished deck—ensuring transparency and saving hours of manual effort.
1. Gather citizen feedback
Copilot quickly summarizes citizen feedback that has been exported to Excel from a Microsoft Form. It groups comments by theme—like zoning and traffic impact. The team copies the response into Word with one click.
Example prompt: Summarize all citizen feedback from / UpcomingZoningFeedback.xlsx group by theme.
2. Complete sentiment review
The team asks Copilot to draft a narrative summary of the top themes and sentiment trends. This gives employees a clear storyline for the briefing deck and helps leadership to understand public sentiment ahead of the hearing.
Example prompt: Add a summary of key themes and sentiment
3. Analyze data
Copilot converts the feedback into charts showing frequency of concerns and geographic distribution, turning qualitative input into actionable insights for decision-makers.
Example prompt: Generate charts showing the top five citizen concerns and their frequency by district.
4. Build the briefing deck
Instead of starting from scratch, Copilot generates a structured deck with sections for key themes, visuals, and proposed actions. It applies the correct agency branding and suggest layouts to make information easy to understand.
Example prompt: Create a five-slide briefing deck for the zoning hearing using the two files built earlier: /UpcomingZoningTrends.docx and /UpcomingZoningFeedback.xlsx.
5. Record and transcribe the hearing
Copilot automatically records and transcribes the public hearing in real time, tagging speakers and capturing decisions. This ensures an accurate record without manual note-taking and supports transparency for citizens and auditors.
Copilot in Teams
Benefit: Be present during the meeting by relying on Copilot in Teams for transcription and summary.
6. Recap hearing notes and share outcomes
Copilot updates the briefing deck with key decisions, next steps, and community feedback highlights. This provides a clear, actionable summary within hours.
Copilot in PowerPoint
Example prompt: Based on this recap of the zoning hearing add a new slide including decisions, next steps, and updated visuals for the briefing deck.
1Access Microsoft 365 Copilot Chat at m365copilot.com, or the Microsoft 365 Copilot Chat mobile app and set toggle to “Web”.
2Access Microsoft 365 Copilot Chat at m365copilot.com, the Microsoft 365 Copilot Chat mobile app, or the Microsoft 365 Copilot Chat app in Teams, and set toggle to “Work”.
3AI Agents allow Copilot to access your organization-specific apps. In the past this would have required an API call to get data from a system of record.
The content in this example scenario is for demonstration purposes only. You should evaluate how Copilot aligns with your organization’s business processes, regulatory requirements, and responsible AI principles.
What's next
Explore more Government Scenarios
Government Scenario LibraryStart using Copilot
Go to the Copilot app to try a new scenario now. Everyone can start with Copilot Chat and if you are licensed Microsoft 365 Copilot connects to your work data and apps.
Start using CopilotView all downloadable content
Download our functional scenario kits, scenario guides, and day in the life guides to accelerate your Copilot implementation.
View downloads