CS 150A - SQL Server Databases - Stage 5 - Rose Endres
Assessment
| Assessment Methods | Analysis of exam, quiz, or homework items linked to specific SLOs |
|---|---|
| Assessment Description | Analysis of coding assignments and exams and scores including the standard SQL techniques required by the SLOs. The topics assessed included aggregates with groupings, unmatched queries, multi-matched queries, aggregates on two different attributes, finding winners with ties on calculated expressions. |
| Learning Outcomes | All |
| Number of Sections | 1 |
| Number of Instructors | 1 |
| Number of Students | 7 active students at final exam |
Data Analysis
| Data Shared With | Instructors of the same course (at CCSF) |
|---|---|
| Data Sharing Methods | None |
| Data Summary | Of the students who completed the assignments, five assignments had an average score less than 80 (out of 16 assignments). The overall final exam score was 56%. Three of the student who took the final exam had stopped doing assignments for several weeks and had very low final exam scores. |
| Analysis Summary | Assignment scores were high for student who did the assignments, but this class had a higher percentage than normal of people who were enrolled and who took the final exam but did not turn in assignments. This class is very assignment driven. On the final exam, students had to determine from the task description which of the topics covered during the semester was appropriate for solving the task. The scores of the final exam queries averaged closer to 50%. The final exam is a paper and pencil exam which is more difficult for students to work out the logic. |
| Next Steps Planned | No answer |
| Learning Outcomes | Most emphasis will be provided for identifying these query patterns. Assignments in the second half of the semester may include tasks from previous units to reinforce pattern detection. |
Changes
| Details | Added discussion of test rows in the Code Review section. Test rows can help student see logical flaws in their queries. Additional demos were provided for the techniques to be learned. |
|---|---|
| Learning Outcomes | All |
Tentative Future Plans
| Term | Fall 2013 |
|---|---|
| Activities |
|
| More Details | Analysis will be based on assignments and tests. Some of these assessments in summary form will be provided to students in the Code review section of the class. |
SLO Details Storage Location
- HARD COPY - In my personal filing system (my office)
- ELECTRONIC COPY - In my electronic filing system (hard drive or web server)