CS 151A - Oracle SQL Databases - Stage 5 - Rose Endres

Assessment

Assessment Methods

Analysis of exam, quiz, or homework items linked to specific SLOs

Assessment DescriptionAnalysis 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 OutcomesALL
Number of Sections1
Number of Instructors1
Number of Students14 active students at final exam

Data Analysis

Data Shared With

Instructors of the same course (at CCSF)

Data Sharing Methods

None

Data SummaryOf the students who completed the assignments, only two assignments had an average score less than 80%. The overall final exam score was 74%.
Analysis SummaryAssignment 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 PlannedMost 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 OutcomesAll

Changes

DetailsAdded 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 OutcomesAll

Tentative Future Plans

TermFall 2013
Activities

Revision of outcomes and assessment methods (measurements)

More DetailsAnalysis 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

Back to Department Overview