SQL / 28-Oct-2009
PROGRAMMING:
28-Oct-2009
SQL
PROGRAM LEARNING OUTCOMES ASSESSMENT
S
ETTINGActivity: CIS Department Meeting - Review of Programming and Database SLOs Participants
Faculty: Sanya Soyemi, Don Jenkins, Bil Bergin Staff: Lynn Mann
Industry: Amrik Randhawa
Action: Accepted Added Assessed Deactivate Modified Not Reviewed
P
ROGRAMA
SSESSMENT Rational:Evaluated SQL Programming track
Discussed the success of the program. In our last review we recommended including MySQL database technologies in the two course track. We have updated the course learning activities and students were very happy with the experience with that platform
Noted fewer students move onto level 2
Considered industry requirements and popularity of MS SQL Server Recommendations:
1. Gather information on why students enroll in level 1 to help us better understand why our expectations of 100% of students moving onto level 2 is not realized
2. Investigate and plan for fall 2010 incorporation of Oracle 11g
SQL / 22-May-2007
PROGRAMMING:
22-May-2007
SQL
PROGRAM LEARNING OUTCOMES PROGRAM ASSESSMENT
S
ETTINGActivity: CIS Department Meeting - Review of Programming and Database SLOs Participants: Nick Abbondanza, Lynn Mann, Don Jenkins, Bil Bergin
Action: Accepted Added Assessed Deactivate Modified Not Reviewed
P
ROGRAMA
SSESSMENT Rational: Evaluated SQL program.• Discussed concerns about low enrollments of the database programs.
• The programs are needed - advisory committees, Bureau of Labor statistics and community
member
• Look for ways to advertise merits of the programs
• Additional platforms could serve as an enticement
Recommendations:
1. Incorporate MS SQL Server and/or other database platforms into the course work.
2. Develop program/department-level SLO's for documenting SQL and other programming
language courses.
3. Curriculum changes that were suggested in department review have begun to be
SQL / 15-May-2006
PROGRAMMING:
15-May-2006
SQL
PROGRAM LEARNING OUTCOMES
PROGRAM REVIEW
S
ETTINGActivity: CIS Department Meeting - Review of SQL Program Certificate Participants: Nick Abbondanza (Student), Steve Fahlbusch, Don Jenkins, Bil Bergin
A
GENDAAction: Added Modified Delete Accepted Not Reviewed Assessment
Curriculum Changes
We discussed the merits of further distinguishing the single-table / multi-table usages between the two classes. It might also be worthwhile to address SQL tuning strategies in the level 2 course. These items might require a change to the outline of record for the courses and will be discussed as an information item at our next department meeting.
All programming assignments for the level one course, CSIS 114A SQL Programming - Level 1, were evaluated and judged to be very good measures of concept mastery for the level one course.
The level two programming assignments were also good measures of programming mastery. The level two course, CSIS 124A SQL Programming - Level 2, includes a technical communication component and in our discussions we noted a variance in the work products that were submitted, and how those items were evaluated.
We need to define more consistent objectives and prepare a more useful rubric.
SQL is an industry standard programming language however each database vendor offers their own significant enhancements to the language. All participants in this review felt it would be advantageous to extend the computing resources and to modify the programming assignments such that students would gain experience with other (i.e. non-Oracle) database products.
As a result of this discussion the department will re-task one of our Oracle database servers to the MySQL database platform and we will begin incorporating this DBMS into the SQL programming curriculum.
SQL / 28-April-2005
PROGRAMMING:
28-April-2005
SQL
PROGRAM LEARNING OUTCOMES DEVELOPMENT
S
ETTING Activity: CIS Department MeetingParticipants: Ron Bowman, Mark Dumas, Don Jenkins, Dottie Smith, Ted Tielens, Ric Williams, Bil Bergin
Action: Added Modified Delete Accepted Not Reviewed
P
ROGRAMM
ATRIX114A
124A
List and describe the different categories of SQL commands
Construct and use relations, set-theoretic operations and relation-theoretic operations in therelational algebra.
Prepare and map elements and constructs in the relational algebra into SQL language elements.
Evaluate and improve a data model using the rules of normalization.
Create a database using the SQL data definition language
Write single and multiple table queries using the SQL data manipulation language elements
Update rows, add rows and delete rows from database tables using the DML elements of SQL
Prepare SQL statements that will perform complex joins using data manipulation language elements.
Evaluate SQL commands for processing efficiency.
Evaluate and improve a data model using the higher-order rules of normalization.
Understand common uses of database triggers and stored procedures.
Use the data control language elements of SQL to support database administration tasks related toSQL / 07-April-2005
PROGRAMMING:
07-April-2005
SQL
PROGRAM LEARNING OUTCOMES DEVELOPMENT
S
ETTINGActivity: Acquired from CIS Program Review developed 2004-2005 Participants: Bil Bergin
P
ROGRAMM
ATRIX114A
124A
List and describe the different categories of SQL commands
Construct and use relations, set-theoretic operations and relation-theoretic operations in therelational algebra.
Prepare and map elements and constructs in the relational algebra into SQL language elements.
Evaluate and improve a data model using the rules of normalization.
Create a database using the SQL data definition language
Write single and multiple table queries using the SQL data manipulation language elements
Update rows, add rows and delete rows from database tables using the DML elements of SQL
Prepare SQL statements that will perform complex joins using data manipulation language elements.
Evaluate SQL commands for processing efficiency.
Evaluate and improve a data model using the higher-order rules of normalization.