Last spring, I taught an online course. In the middle of the semester, a student did not do well on one assignment and asked if I could give him another set of questions to review. I said yes.
The assignment was a database design task that involved a business case and a dozen sample data rows – for example, a fictional medical clinic that uses Excel sheets to manage its appointments. The table in the image below contains sample data from last year.
![table with data including staff ID, doctor name, patient ID, patient name, appointment date, appointment time, surgery ID, surgery description, and operating room.](https://i0.wp.com/ctl.cedarville.edu/wp/wp-content/uploads/2024/06/image.png?resize=960%2C215&ssl=1)
The most time-consuming aspect of creating a similar assignment was developing a new case and generating sample data which must represent as many unique cases as possible. Once the case was created, I could reuse the same questions as the previous assignment.
I turned to Microsoft Copilot for some help. In my prompt, I included both the learning outcomes that the assignment was to assess as well as the original assignment to allow AI to understand its context. Then, I asked Copilot to propose a new assignment based on the information I provided.
The first case Copilot gave me was a library management system case. It initially gave me five rows, so I asked for ten and instructed Copilot to consider different use cases and choose books suitable for a Christian school. The table in the image below is the final version.
![table with data including librarian ID, librarian name, book ID, book name, member ID, member name, borrow date, return date, shelf ID, and shelf location.](https://i0.wp.com/ctl.cedarville.edu/wp/wp-content/uploads/2024/06/library-data.png?resize=960%2C290&ssl=1)
This exercise with Copilot was to create an assignment based on an existing assignment. However, I was curious and asked Copilot what information I should provide to assist me in designing a good assignment. Below is the response:
Copilot – To help you design a good assignment, I would need the following information:
- Subject or Topic: What is the subject or topic of the assignment? Is it related to a specific course or field of study?
- Objective: What do you want the students to learn or achieve from this assignment?
- Format: What format should the assignment take? For example, is it a research paper, a presentation, a group project, etc.?
- Length: How long should the assignment be? If it’s a written assignment, how many pages or words should it be?
- Resources: Are there any specific resources the students should use? For example, specific textbooks, websites, or databases.
- Deadline: When is the assignment due? Is there a specific submission process?
- Grading Criteria: How will the assignment be graded? What are the key points that students should focus on to get a good grade?
- Level of Difficulty: What is the expected level of difficulty of the assignment? Is it designed for beginners, intermediate learners, or advanced students?
- Prerequisites: Are there any prerequisites for the assignment? Do students need to have certain knowledge or skills before they can start the assignment?
- Additional Instructions: Are there any other specific instructions or guidelines for the assignment?
Once I have this information, I can help you design an assignment that is engaging, challenging, and effective for your students. Please provide as much detail as possible to ensure the assignment is tailored to your needs.
To test it, I continued and gave Copilot the following prompt:
Topic: CRUD design in a System Analysis and Design course.
Objective: Use a CRUD matrix to map user permissions and responsibilities to database management for a given case scenario.
Format: Make the assignment as a case study. Provide learners with an authentic scenario with use cases and then ask them to map out the CRUD matrix.
Resources: Use the template provided in the Resources module of the Canvas course
Grading: Create a rubric for grading the case study
Submission: Submit a Word file in Canvas
Here is the output:
Case Scenario: You are a system analyst for a medium-sized hospital. The hospital is planning to upgrade its patient records management system. The new system will have different types of users including doctors, nurses, administrators, and patients. Each user type will have different permissions for creating, reading, updating, and deleting data.
Questions:
- User Permissions: List the types of data each user type should be able to create, read, update, and delete. Consider data such as patient records, appointment schedules, medical histories, billing information, etc.
- CRUD Matrix: Based on your answer to the previous question, create a CRUD matrix that maps user permission to database operations. Use the template provided in the Resources module of the Canvas course.
- Case Analysis: Discuss how the CRUD matrix helps in managing user permissions and responsibilities in the context of the hospital’s patient records management system.
Submission: Please submit your answers in a Word file in Canvas. Make sure to follow the formatting guidelines provided in the Resources module of the Canvas course.
Grading: Your assignment will be graded based on the following rubric:
- Understanding of CRUD (30%): Demonstrates a clear understanding of CRUD operations and their role in database management.
- CRUD Matrix (40%): Accurately maps user permissions to CRUD operations in the matrix.
- Case Analysis (30%): Provides a thoughtful analysis of how the CRUD matrix applies to the case scenario.
It is not perfect, but it is a good starting point for me to continue working on it later.
From my interaction with Copilot for assignment creation, I have found that Generative AI is helpful in drafting assignments, especially when you can provide thorough details of what you want to assess and the context of the course.
Questions? Comments? Drop them below, and we’ll chat!
Want to never miss a post? Subscribe here!
- Generative AI, In Practice: Assignment Creation - June 19, 2024
- AECT Reflection: Haisong Ye on Mental Fatigue and Its Implication in Course Design - November 2, 2023
- Is Online Proctoring a Good Solution for Teaching and Learning? - February 14, 2023