🧠 Workflow 1: Reference Checking

🛠️ Tools Used in This Workflow

Scenario Overview

You need to evaluate the academic integrity of your students' work and verify the legitimacy of their references. Doing this manually can be time-consuming and challenging, especially with many references and students to mark.

Using GenAI tools, you can quickly verify reference authenticity, identify potential predatory journals, and ensure students are citing real, credible research.

Task: This is a mock essay with some real and some fake references. Your task is to identify which references are legitimate and which are not.

You can copy and paste this essay into a Word document, save it, and then upload it to Copilot chat with the prompt.

Remember: only upload or paste student work into your university-approved GenAI platform that is protected by enterprise license.

Mock Essay

You can check if the references used in the essay are legitimate and used correctly. We can easily do this using GenAI.

To do this, you can use the Persona → Task → Context → Format (P-T-C-F) prompt structure. This helps you create clear and effective prompts for AI tools.

Practice: Improve the Prompt

Here is an example prompt following the P-T-C-F structure to get you started:

3·4 Sample P-T-C-F Prompt

Copy

Role: Comms writer
Persona: Academic writing specialist  
Task: Summarise Chapter 4 focusing on methodology  
Context: Post-graduate audience; APA 7th; 2,500-word chapter supplied below  
Format: Bullet list ≤100 words with 5 key citations

This prompt is specific, clear, and actionable. It tells the AI your role, what you want to do (the task), the context you're working in, and how you want the output formatted.
NOTE: Remember to account for hallucinations and ensure the AI's responses are grounded in the provided context - add columns like "Is this a hallucination" or "Does this exist in PUBMED" etc to ensure the results are correct

Practice: Write your own prompt using the same structure to complete the reference evaluation task. You want your output to look something like this:

Rewrite this prompt using P-T-C-F structure: Persona, Task, Context, Format:

Once you have improved your prompt, you can paste it in Copilot chat to check the references in the essay along with the Word document (or just copy-pasting the essay - but not recommended).

Prompt used to generate the reference table

Persona: Academic integrity assistant
Task: For each reference in these 10 essays produce a table with:
 StudentID | Reference | DOI/PMID | Journal | 2024 Impact Factor | URL | Predatory? (Yes/No + reason) | 1-sentence summary| Used Correctly in Context
Context: StudentID is in the filename; if IF unknown write NA
Format: Markdown table

🔧 How to Modify This Workflow

• ✅ Use EndNote: Export your EndNote library and ask Copilot to compare citations against it.
• ✅ Upload 50 essays at once: Place all essays in a folder and ask Copilot to extract references from each file.
• ✅ Export to Excel: Ask Copilot to format the output as a Markdown or CSV table and paste into Excel.
• ✅ Include citation context: Ask Copilot to check how each reference is used in the essay.
• ✅ Add hallucination detection: Modify the prompt to include a column that flags whether each reference is real or fabricated.

🧪 Hallucination Detection: Prompt Enhancement

To detect hallucinated references, add this column to your output table:

• Column Name: Possible Hallucination?
• Logic: Ask Copilot to check each reference against EndNote or CrossRef. If not found, mark as "Yes".

Prompt Example:

Persona: Academic integrity assistant
Task: For each reference in these 50 essays, generate a table with:

Student ID (from filename)
Reference
DOI
Journal
Predatory? (Yes/No + reason)
Used correctly in context?
Exists in EndNote library?
Possible Hallucination?

Context: Essays are stored in a folder. EndNote export is available.
Format: Excel-compatible table

⚠️ What Could Go Wrong?

🚀 Next Steps: Advanced Options

🔹 Excel Script Integration

Use Excel Copilot to:

• Highlight missing DOIs
• Flag duplicate references
• Add conditional formatting for predatory journals
• Create pivot tables to summarize citation patterns

🔹 Power Automate Integration

• Automatically trigger reference checking when essays are uploaded to SharePoint or OneDrive.
• Auto-email flagged reports
• Log citation quality scores into a central dashboard.

🔹 Build a Citation Dashboard

Use Excel + Power BI to visualise:

• Most cited journals
• Frequency of predatory sources
• Citation accuracy trends across modules

📅 Workflow 2: Calendar Automation

🛠️ Tools Used in This Workflow

Scenario Overview

You’ve just finalised your teaching or meeting schedule for the next few months. It includes dozens of sessions: lectures, labs, tutorials, or admin meetings. Now you need to add them all to Outlook or Teams. Instead of creating each event manually, this workflow shows you how to use Excel and Copilot to generate a calendar file that you can import in seconds.

In this workflow, we will:

1. Prepare your timetable data in Excel
2. Use Copilot to generate a calendar file that you can import in seconds.

BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Your Organization//Your Product//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Your Calendar Name
X-WR-TIMEZONE:Your Timezone
BEGIN:VEVENT
UID:unique-event-id
DTSTAMP:20230922T090000Z
DTSTART:20230922T090000Z
DTEND:20230922T100000Z
SUMMARY:Event Title
LOCATION:Event Location
DESCRIPTION:Event Description
END:VEVENT
END:VCALENDAR
            

📊 Prepare Your Excel File

Your schedule first needs to be prepared in Excel. Ensure columns exactly as below otherwise the .ics file may fail.
You can also just copy the table below and paste it on Excel or directly into Copilot:

Sample Timetable

Excel Copilot Prompt

Prompt Structure

To create an effective prompt for Excel Copilot, we can try the P-T-C-F structure. Below, try crafting the prompt to generate an .ics file from the provided table. Copy and save the table to Excel first and then upload it to Copilot with your prompt

BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//University of Glasgow//Calendar Automation//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
BEGIN:VEVENT
UID:BIO101-2025-09-22-0900-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250922T090000
DTEND;TZID=Europe/London:20250922T100000
SUMMARY:BIO101
LOCATION:Lab 1
END:VEVENT
BEGIN:VEVENT
UID:CHE102-2025-09-22-1000-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250922T100000
DTEND;TZID=Europe/London:20250922T110000
SUMMARY:CHE102
LOCATION:Lab 2
END:VEVENT
BEGIN:VEVENT
UID:PHY103-2025-09-22-1100-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250922T110000
DTEND;TZID=Europe/London:20250922T120000
SUMMARY:PHY103
LOCATION:Lecture Hall A
END:VEVENT
BEGIN:VEVENT
UID:MTH104-2025-09-22-1300-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250922T130000
DTEND;TZID=Europe/London:20250922T140000
SUMMARY:MTH104
LOCATION:Room 201
END:VEVENT
BEGIN:VEVENT
UID:ENG105-2025-09-22-1400-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250922T140000
DTEND;TZID=Europe/London:20250922T150000
SUMMARY:ENG105
LOCATION:Room 202
END:VEVENT
BEGIN:VEVENT
UID:BIO101-2025-09-23-0900-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250923T090000
DTEND;TZID=Europe/London:20250923T100000
SUMMARY:BIO101
LOCATION:Lab 1
END:VEVENT
BEGIN:VEVENT
UID:CHE102-2025-09-23-1000-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250923T100000
DTEND;TZID=Europe/London:20250923T110000
SUMMARY:CHE102
LOCATION:Lab 2
END:VEVENT
BEGIN:VEVENT
UID:PHY103-2025-09-23-1100-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250923T110000
DTEND;TZID=Europe/London:20250923T120000
SUMMARY:PHY103
LOCATION:Lecture Hall A
END:VEVENT
BEGIN:VEVENT
UID:MTH104-2025-09-23-1300-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250923T130000
DTEND;TZID=Europe/London:20250923T140000
SUMMARY:MTH104
LOCATION:Room 201
END:VEVENT
BEGIN:VEVENT
UID:ENG105-2025-09-23-1400-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250923T140000
DTEND;TZID=Europe/London:20250923T150000
SUMMARY:ENG105
LOCATION:Room 202
END:VEVENT
BEGIN:VEVENT
UID:BIO101-2025-09-24-0900-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250924T090000
DTEND;TZID=Europe/London:20250924T100000
SUMMARY:BIO101
LOCATION:Lab 1
END:VEVENT
BEGIN:VEVENT
UID:CHE102-2025-09-24-1000-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250924T100000
DTEND;TZID=Europe/London:20250924T110000
SUMMARY:CHE102
LOCATION:Lab 2
END:VEVENT
BEGIN:VEVENT
UID:PHY103-2025-09-24-1100-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250924T110000
DTEND;TZID=Europe/London:20250924T120000
SUMMARY:PHY103
LOCATION:Lecture Hall A
END:VEVENT
BEGIN:VEVENT
UID:MTH104-2025-09-24-1300-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250924T130000
DTEND;TZID=Europe/London:20250924T140000
SUMMARY:MTH104
LOCATION:Room 201
END:VEVENT
BEGIN:VEVENT
UID:ENG105-2025-09-24-1400-glasgow.ac.uk
DTSTAMP:20250802T125002Z
DTSTART;TZID=Europe/London:20250924T140000
DTEND;TZID=Europe/London:20250924T150000
SUMMARY:ENG105
LOCATION:Room 202
END:VEVENT
END:VCALENDAR
                

Persona: Calendar automation specialist
Task: Generate a full .ics file from this table
Context: Time zone Europe/London
Format: Return only plain-text .ics

Import to Outlook

Copilot chat provides a link to get the calendar file. Save it and then import it into your Outlook calendar.

If the output was rather displayed, you can Copy output ➜ save as semester.ics

These steps are for Outlook New version

1. Calendar tab ▷ Add Calendar (bottom left panel) ▷ Upload from file ▷ Add your .ics file
2. Choose Add to existing calendar
3. Spot-check three random events

🔧 How to Modify This Workflow

• ✅ Add event descriptions: Include lecture topics, module codes, or links.
• ✅ Add reminders: Ask Copilot to include alerts (e.g., 15 minutes before).
• ✅ Add recurring events: Use logic like "every Monday for 10 weeks".
• ✅ Include Teams links: Add meeting URLs for hybrid sessions.
  FYI: You can just add a reusable link for the Teams meeting that can be the same. See below for more info
• ✅ Auto-email invites: Use Power Automate to send .ics files to students or staff.

🧩 Enhanced Copilot Prompt for Calendar Automation

You can modify your excel file to include additional columns for event descriptions, reminders, and Teams links. Here is an example:

Now, Here is a more detailed prompt to do the above:

 
Persona: Calendar automation specialist
Task: Generate a .ics calendar file from this Excel timetable
Context: Time zone Europe/London; each row represents a separate event
Additional Instructions:
    Add event descriptions: Include lecture topics, module codes, or links from the Excel table
    Add reminders: Include a 15-minute alert before each event
    Add recurring events: Use logic like “every Monday for 10 weeks” where applicable
    Include Teams links: Add a Microsoft Teams meeting URL to each event
    Invite attendees: Add email addresses from the Excel table to send calendar invites
Format: Return only plain-text .ics content, ready to be saved and imported into Outlook

            

🧩 Reusable Teams Meeting Link

To create a reusable Teams meeting link:

1. Schedule a new Teams meeting in your calendar.
2. Copy the meeting link from the meeting details.
3. Use this link for all relevant events in your .ics file.

Note: We are doing this because Copilot cannot automatically generate a Teams link. When you manually create a meeting in Outlook and toggle “Teams Meeting”, Outlook uses Microsoft Graph API in the background to generate a secure, unique Teams link. Copilot (in Excel or Chat) can’t currently access that API directly to generate a real Teams link unless it’s integrated with Power Automate or Outlook’s backend services.

🧪 Hallucination Safeguards

While Copilot is reliable with structured data, it may occasionally misinterpret time zones, duplicate events, or format .ics files incorrectly. To reduce errors:

✅ Always specify the time zone:
"Time zone: Europe/London"

✅ Ask Copilot to return plain-text .ics only:
"Do not include HTML or formatting."

✅ Spot-check 3–5 events manually before importing.
✅ Use Excel formulas to validate time formats before prompting Copilot.

⚠️ What Could Go Wrong?

🚀 Next Steps: Advanced Options

🔹 Excel Script Integration

Use Excel Copilot to:

• Validate time formats
• Highlight overlapping events
• Auto-generate .ics content per row
• Create a "Week View" summary

🔹 Power Automate Integration

• Automatically send calendar invites when a new timetable is uploaded.
• Sync .ics files with Outlook or Teams calendars.
• Trigger reminders or room booking confirmations.
• Trigger calendar creation when a new Excel file is uploaded to SharePoint.
• Automatically create Outlook events with Teams links.
• Send invites to students or staff based on Excel data.

🔹 Combine with Room Booking Systems

• Link timetable data to Microsoft Bookings or SharePoint room calendars.
• Auto-check room availability and suggest alternatives.

🔹 Build a Scheduling Dashboard

Use Excel + Power BI to visualise:

• Room usage
• Course overlaps
• Staff availability

🗂️ Workflow 3: Batch Renaming & Structuring folders

🛠️ Tools Used in This Workflow

Scenario: You receive 100 student essays stored in Downloads\Essays\. Each is named like Surname 12345678 Essay.docx. You must:

1. Rename every essay to <CourseCode>_<StudentID>_Essay.docx, e.g., BIO101_12345678_Essay.docx.
2. Duplicate a template rubric file (Rubric.docx) for each student and rename it to <CourseCode>_<StudentID>_Rubric.docx.
3. Create a folder called <StudentID>_<CourseCode> and move both files inside.

Doing this manually would take hours—let’s use Microsoft 365 Copilot to generate a PowerShell script that automates everything in seconds.

Write this prompt using the CLEAR framework:

Context:

I have a folder of student essays named in the format Surname_ID_Essay.docx in the folder  ADD PATH TO FOLDER HERE for example: C:\Users\alish\Downloads\Rename_Files

I need to rename each file to ABC123_ID_Assignment1.docx, where ABC123 is the course code and Assignment1 is the assignment name.

I also have a file called rubric_template.docx that should be copied and renamed for each student as ABC123_ID_Rubric.docx.

Both the renamed essay and rubric should be placed into a folder named ID_CourseName, where CourseName is the name of the course.

Limitations:

The solution must work without requiring additional tools or services.


Format:

Return a PowerShell script for Windows (OR a Bash script for macOS).

# PowerShell Script: organize_essays.ps1

$courseCode = "ABC123"
$courseName = "CourseName"
$assignmentName = "Assignment1"
$sourceFolder = "essays"
$outputFolder = "organized_essays"
$rubricTemplate = "rubric_template.docx"

New-Item -ItemType Directory -Force -Path $outputFolder

Get-ChildItem -Path $sourceFolder -Filter "*_Essay.docx" | ForEach-Object {
    $parts = $_.BaseName -split "_"
    $studentID = $parts[1]
    $studentFolder = "$outputFolder\$studentID" + "_$courseName"
    New-Item -ItemType Directory -Force -Path $studentFolder

    $newEssayName = "$courseCode" + "_$studentID" + "_$assignmentName.docx"
    $newRubricName = "$courseCode" + "_$studentID" + "_Rubric.docx"

    Copy-Item $_.FullName -Destination "$studentFolder\$newEssayName"
    Copy-Item "$sourceFolder\$rubricTemplate" -Destination "$studentFolder\$newRubricName"
}

Write-Host "✅ All files have been renamed and organised."

#!/bin/bash

course_code="ABC123"
course_name="CourseName"
assignment_name="Assignment1"
source_folder="essays"
output_folder="organized_essays"
rubric_template="rubric_template.docx"

mkdir -p "$output_folder"

for file in "$source_folder"/*_Essay.docx; do
    filename=$(basename "$file")
    IFS='_' read -r surname student_id rest <<< "$filename"

    student_folder="$output_folder/${student_id}_${course_name}"
    mkdir -p "$student_folder"

    new_essay_name="${course_code}_${student_id}_${assignment_name}.docx"
    new_rubric_name="${course_code}_${student_id}_Rubric.docx"

    cp "$file" "$student_folder/$new_essay_name"
    cp "$source_folder/$rubric_template" "$student_folder/$new_rubric_name"
done

echo "✅ All files have been renamed and organised."

Running the Script

Save the script from Copilot as organize_essays.ps1 (Windows) or organize_essays.sh (macOS) in the same folder as your essay files.

Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser

cd /path/to/your/essay/folder

⚠️ Important: Test on a small subset first (for example, 5 files) before running on the full batch.

🔧 How to Modify This Workflow

• ✅ Log actions: Add a CSV log that records renamed files and timestamps.
• ✅ Zip folders: Compress each student folder for upload or archiving.
• ✅ Add error handling: Skip files with missing or malformed IDs.
• ✅ Include date stamps: Add submission date to filenames for version control.

🧩 Enhanced Prompt

Context:
I have a folder of student essays named in the format Surname_ID_Essay.docx.
I need to rename each file to ABC123_ID_Assignment1.docx, where ABC123 is the course code and Assignment1 is the assignment name.
I also have a file called rubric_template.docx that should be copied and renamed for each student as ABC123_ID_Rubric.docx.
Both the renamed essay and rubric should be placed into a folder named ID_CourseName, where CourseName is the name of the course.

Limitations:
The solution must work without requiring additional tools or services.

Format:
Return a PowerShell script for Windows OR a Bash script for macOS.

⚠️ What Could Go Wrong?

🧪 Hallucination Safeguards

While hallucination is less likely in file renaming workflows, you can still ask Copilot to:

✅ Validate filename patterns:
"Check if each filename matches the expected format before renaming."

✅ Flag unknown formats:
"Add a column to the log for 'Filename Valid?' and mark Yes/No."

🚀 Next Steps: Advanced Options

🔹 Excel Integration

Use Excel to:

• Track renamed files
• Match student IDs to names
• Generate folder names dynamically

🔹 Power Automate Integration

• Automatically trigger renaming when files are uploaded to SharePoint or OneDrive.
• Auto-email confirmation to staff once renaming is complete.
• Log renamed files into a central Excel tracker.

🔹 Build a Submission Dashboard

Use Excel + Power BI to visualise:

• Submission status
• Missing files
• Folder organisation completeness