CS 151A - Oracle SQL 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 | 14 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, only two assignments had an average score less than 80%. The overall final exam score was 74%. |
Analysis Summary | Assignment scores were high and show that students can write queries on the specified topics of the current unit. 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 60%. The final exam is a paper and pencil exam which is more difficult for students to work out the logic. |
Next Steps Planned | 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. |
Learning Outcomes | All |
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 | Revision of outcomes and assessment methods (measurements) |
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)