Select Git revision
CourseModel.php
CourseModel.php 148.86 KiB
<?php
require_once ('Unl/Model.php');
class Courses_CourseModel extends Unl_Model
{
static protected $_colleges = array();
static protected $_collegeNames = array();
static protected $_departments = array();
static protected $_hierarchy = array();
static protected $_outcomeShortNames = array(
'SLO1' => 'writing',
'SLO2' => 'communication',
'SLO3' => 'mathematicalReasoning',
'SLO4' => 'scientificReasoning',
'SLO5' => 'historicalPerspective',
'SLO6' => 'humanBehavior',
'SLO7' => 'artisticSignificance',
'SLO8' => 'civics',
'SLO9' => 'humanDiversity',
'SLO10' => 'production'
);
static protected $_outcomeDescriptions = array(
'SLO1' => 'Write texts, in various forms, with an identified purpose, that respond to specific audience needs, incorporate research or existing knowledge, and use applicable documentation and appropriate conventions of format and structure.',
'SLO2' => 'Demonstrate communication competence in one or more of the following ways: (a) by making oral presentations with supporting materials, (b) by leading and participating in problem-solving teams, (c) by employing a repertoire of communication skills for developing and maintaining professional and personal relationships, or (d) by creating and interpreting visual information.',
'SLO3' => 'Use mathematical, computational, statistical, or formal reasoning (including reasoning based on principles of logic) to solve problems, draw inferences, and determine reasonableness.',
'SLO4' => 'Use scientific methods and knowledge of the natural and physical world to address problems through inquiry, interpretation, analysis, and the making of inferences from data, to determine whether conclusions or solutions are reasonable.',
'SLO5' => 'Use knowledge, historical perspectives, analysis, interpretation, critical evaluation, and the standards of evidence appropriate to the humanities to address problems and issues.',
'SLO6' => 'Use knowledge, theories, methods, and historical perspectives appropriate to the social sciences to understand and evaluate human behavior.',
'SLO7' => 'Use knowledge, theories, or methods appropriate to the arts to understand their context and significance.',
'SLO8' => 'Explain ethical principles, civics, and stewardship, and their importance to society.',
'SLO9' => 'Exhibit global awareness or knowledge of human diversity through analysis of an issue.',
'SLO10' => 'Generate a creative or scholarly product that requires broad knowledge, appropriate technical proficiency, information collection, synthesis, interpretation, presentation, and reflection.'
);
static protected $_reinforcementNames = array(
'writing' => 'Writing',
'oralCommunication' => 'Oral Communication',
'visualLiteracy' => 'Visual Literacy',
'historicalPerspectives' => 'Historical Perspectives',
'mathematicsAndStatistics' => 'Mathematics and Statistics',
'criticalThinking' => 'Critical Thinking',
'teamwork' => 'Teamwork',
'problemSolving' => 'Problem Solving',
'ethics' => 'Ethics',
'civics' => 'Civics',
'socialResponsibilities' => 'Social Responsibilities',
'globalAwareness' => 'Global Awareness',
'humanDiversity' => 'Human Diversity'
);
static protected $_activityMap;
const CREDIT_TYPE_SINGLE = 1;
const CREDIT_TYPE_RANGE_MIN = 2;
const CREDIT_TYPE_RANGE_MAX = 3;
const CREDIT_TYPE_SEMESTER_MAX = 4;
const CREDIT_TYPE_DEGREE_MAX = 5;
static public function find($id)
{
$db = Zend_Registry::get('db');
$select = new Zend_Db_Select($db);
$select->from(array('a' => 'creqAssets'));
$select->join(array('g' => 'creqCourseGenerations'), 'a.assetId = g.assetId');
$select->join(array('d' => 'creqCourseDetails'), 'g.courseGenerationId = d.generation');