Graduates demonstrate Questions on MISC 481 Expectation Standard -- The instructors who Spring 2009, meet and This was our use of appropriate levels of midterm and final for 60% of the students teach DB skills should coordinate DB quantified expectation MIS technical skills in Fall and Winter tested will score 2 or coordinate how these instruction. standards. One problem database quarters, AY0809 higher topics are presented in encountered was the different classes. Fall 2009, implement fact that the way the Students will be able to Given a description of a On the ERD question: More lecture time decisions on DB tests are presented create and link business situation, the 64% scored a 3, 18% and homework in MISC instruction. (online and paper mix) relational database student must properly scored a 2, 18% scored 481 should be devoted makes it difficult to tables, and build queries draw an ERD of a set of a 1 to SQL skills. assess performance that can extract data tables, showing keys, Review our across the classroom on from them attributes, relations and On the SQL query: 45% assessment policies to a single question. The cardinalities. scored a 3, 36% scored see if we should refine objectives tested are a 2, 19% scored a 1 the scoring. core skills for MIS an ERD, with We need to identify professionals and keys, attributes, Conclusion Students those who are having should continue to be – relations and met our expectation problems earlier and assessed periodically. cardinalities, the student standards in both areas. give them additional can write an SQL query The fact that almost instruction. to extract specific 20% of the students fell information. into the lowest category is cause for concern. Students will be scored The discussions on on the accuracy of their scoring the SQL query drawings, and on the question revealed effectiveness of their differences in teaching queries. approaches among instructors, that need to 1 = poor, be addressed. 2= adequate, 3 = excellent
Graduates demonstrate appropriate levels of MIS technical skills in database Students will be able to create and link relational database tables, and build queries that can extract data from them Questions on MISC 481 midterm and final for Fall and Winter quarters, AY0809 Given a description of a business situation, the student must properly draw an ERD of a set of tables, showing keys, attributes, relations and cardinalities. an ERD, with keys, attributes, relations and cardinalities, the student can write an SQL query to extract specific information. Students will be scored on the accuracy of their drawings, and on the effectiveness of their queries. 1 = poor, 2= adequate, 3 = excellent Expectation Standard -- 60% of the students tested will score 2 or higher On the ERD question: 64% scored a 3, 18% scored a 2, 18% scored a 1 On the SQL query: 45% scored a 3, 36% scored a 2, 19% scored a 1 Conclusion – Students met our expectation standards in both areas. The fact that almost 20% of the students fell into the lowest category is cause for concern. The discussions on scoring the SQL query question revealed differences in teaching approaches among instructors, that need to be addressed. The instructors who teach DB skills should coordinate how these topics are presented in different classes. More lecture time and homework in MISC 481 should be devoted to SQL skills. Review our assessment policies to see if we should refine the scoring. We need to identify those who are having problems earlier and give them additional instruction. Spring 2009, meet and coordinate DB instruction. Fall 2009, implement decisions on DB instruction. This was our use of quantified expectation standards. One problem encountered was the fact that the way the tests are presented (online and paper mix) makes it difficult to assess performance across the classroom on a single question. The objectives tested are core skills for MIS professionals and should continue to be assessed periodically.
CBPA%20Assessment%20Report%20AY%202008-18.docx