May 15, 2024  
2022-2023 Course Catalog 
    
2022-2023 Course Catalog [ARCHIVED CATALOG]

Course Descriptions and Outlines


  

  

MnTC Course List   

 

Automotive Service Technology

  
  • AST 2025 - Cooling System Service

    Credits: 2
    Hours/Week: Lecture 1 Lab 2
    Course Description: This course covers the operation and service of the cooling system. Cooling system service and coolant recovery/recycling procedures will be performed. Students must be able to perform physical tasks to complete course requirements.
    MnTC Goals
    None

    Prerequisite(s): AST 2015  and instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Cooling System Theory
    2. Coolants
    3. Belts and Hoses
    4. Block Heaters
    5. System Service
    6. Coolant Recovery/Recycling
    7. NATEF Tasks
    8. Safety

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe safety precautions.
    2. identify cooling system components.
    3. describe the cooling system operational theory.
    4. perform cooling systems service procedures.
    5. perform cooling system inspection and maintenance.
    6. perform coolant exchange using service equipment.
    7. describe coolant recycling procedures.
    8. perform NATEF tasks during cooling system service.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • AST 2035 - Emission Control

    Credits: 4
    Hours/Week: Lecture 2 Lab 4
    Course Description: This course covers the need for vehicle emission control. A complete description of the function and operation of most common emission control devices will be addressed. Testing of emission control devices will be performed. Students must be able to perform physical tasks to complete course requirements.
    MnTC Goals
    None

    Prerequisite(s): AST 2025  and instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Identify need for Emission Control
    2. OBD II
      1. Standardized terms
      2. Code format/ freeze frame
      3. Data link connector
      4. Diagnostics/monitors
      5. Enable criteria /trip/warm-up cycles
      6. Readiness Monitors
      7. MIL operation
      8. Permeant codes
      9. Bi-directional codes
      10. Control module identification
    3. Exhaust Gas Composition
    4. Component/System Testing
      1. PCV
      2. EGR
      3. EVAP
      4. AIR
      5. Catalyst
      6. Variable valve timing
      7. Thermostat
    5. Diagnostics/ Monitors
      1. Continuous
      2. Comprehensive
      3. Components
      4. Misfire
      5. Fuel Trim
      6. Once per trip, CAT, EGR, EVAP, AIR
    6. Legal Issues
      1. Tampering
      2. Used Converters
    7. Emission Warranties
    8. NATEF Tasks
      1. Completion of NATEF tasks associated with course
    9. Safety
      1. General shop
      2. Precautions relative to course
    10. Fuel trim control
      1. Oxygen sensor operation
      2. Fuel mapping
      3. Fuel trim theory & operation

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe the safety precautions associated with course. .
    2. describe the need for emission control.
    3. describe OBD II standardization and requirements.
    4. describe OBD II Diagnostics/ Monitors.
    5. describe MIL operation.
    6. test emission control components using a Scan Tool.
    7. identify defective emission control components.
    8. describe legal issues concerning emission control tampering.
    9. perform NATEF tasks during emission component testing.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • AST 2045 - Computerized Engine Control

    Credits: 4
    Hours/Week: Lecture 2 Lab 4
    Course Description: This course covers the fundamentals of the microcomputer system used to control the automotive engine. Concepts covered include: central processing, memory/storage devices, input/output devices, adaptive strategy, and on-board diagnostics. Computer scanners will be used to test and analyze the engine control computer system. Students must be able to perform physical tasks to complete course requirements.
    MnTC Goals
    None

    Prerequisite(s): AST 2035  and instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Overview of computerized engine control
    2. Actuators or Outputs
      1. Solenoids
      2. Relays
      3. Motors
      4. Light Bulbs
      5. Generator Field
      6. Coil on Plug
    3. Sensors or Inputs
      1. Thermistors
      2. Potentiometers
      3. Rheostats
      4. Switches
      5. Pressure sensors
      6. Piezo electric devices
      7. Oxygen sensors
      8. Position sensors
    4. Computer Components
      1. Microprocessor
      2. RAM
      3. ROM
      4. EEPROM
      5. Clock
      6. High/Low side drivers
    5. Data Stream
      1. Communications protocol
      2. Bit
      3. Byte
      4. Baud Rate
      5. Can Bus
    6. Software updates
      1. Reflashing Modules
    7. Computer Scan Tools
      1. Practice using various scan tools to diagnose problems
    8. NATEF Tasks
      1. Completion of NATEF tasks associated with course.
    9. Safety
      1. General Shop
      2. Precautions relative to course.

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe safety precautions associated with course.
    2. describe the operation of a computerized engine control system.
    3. identify computer inputs and outputs.
    4. interpret computerized engine control wiring diagrams.
    5. locate computer system components.
    6. identify common computer electronic components.
    7. identify the diagnostic functions of a typical scan tool.
    8. interpret computer data using a scan tool.
    9. test sensors and actuators circuits.
    10. perform NATEF tasks when testing engine control computer systems.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • AST 2055 - Electronic Fuel Injection

    Credits: 3
    Hours/Week: Lecture 2 Lab 2
    Course Description: This course covers the operation and service of electronic fuel injection systems. System testing and necessary repairs will be performed. Students must be able to perform physical tasks to complete course requirements.
    MnTC Goals
    None

    Prerequisite(s): AST 2045  and instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Benefits of fuel injection
      1. Less parts
      2. Better atomization
      3. Cold drivability
    2. Intake Manifolds
      1. Dry
      2. Wet
    3. Types of fuel systems
      1. Two line
      2. One line
    4. Fuel system components
      1. Tank and Lines
      2. Regulator
      3. Injectors
      4. Fuel Pump
    5. Fuel pressure regulation
    6. Fuel pressure and component testing
    7. Idle speed control
      1. Electronic throttle control
    8. Safety
      1. General shop
      2. Precautions relative to course
    9. Direct injection systems
      1. high pressure fuel pumps
      2. high pressure fuel injectors & drivers pressure sensors
      3. specialty tools
      4. safety procedures surrounding high pressure components

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe safety precautions associated with course.
    2. identify fuel system components.
    3. locate fuel system components.
    4. perform fuel pressure testing.
    5. test fuel system components.
    6. diagnose fuel injection problems.
    7. replace defective components.
    8. perform NATEF tasks during fuel system testing completing

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • AST 2065 - Engine Performance Maintenance

    Credits: 4
    Hours/Week: Lecture 2 Lab 4
    Course Description: This course covers ignition system theory, testing and repair procedures, four-gas analysis and engine performance maintenance. Engine performance maintenance using a variety of diagnostic test equipment will be performed. Students must be able to perform physical tasks to complete course requirements.
    MnTC Goals
    None

    Prerequisite(s): AST 2055  and instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Ignition system components and functions
    2. Distributor ignition system components
    3. Ignition system theory and operation
    4. Electronic ignition system components
    5. Test Equipment Use
    6. Test result interpretation
    7. Engine Maintenance Procedures
    8. Safety

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe safety precautions associated with course.
    2. operate engine performance test equipment.
    3. perform engine performance tests.
    4. interpret engine performance test results.
    5. perform engine performance maintenance.
    6. perform NATEF tasks during engine performance maintenance.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • AST 2075 - Supplemental Computer Systems

    Credits: 2
    Hours/Week: Lecture 1 Lab 2
    Course Description: In this course, students will study supplemental computer systems used to control inflatable restraint systems. Repair and diagnostic procedures will be performed on live vehicles. Students must be able to perform physical tasks to complete course requirements.
    MnTC Goals
    None

    Prerequisite(s): AST 2065  and instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Inflatable restraint system components
    2. Inflatable restraint system operation
    3. Inflatable restraint system test
    4. Interpret test results
    5. Completion of NATEF tasks associated with course
    6. Safety
    7. Safety precautions and procedures

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe the safety precautions associated with course.
    2. perform diagnostic tests inflatable restraint systems.
    3. interpret diagnostic test results.
    4. perform repair procedures on supplemental computer systems.
    5. perform NATEF tasks applicable to course.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • AST 2085 - Air Conditioning

    Credits: 3
    Hours/Week: Lecture 2 Lab 2
    Course Description: This course covers the fundamentals and service of the automotive air conditioning system. Topics include system operation, recovery/recycling of 134A, system charging, leak detection, performance testing, and retrofitting. Air conditioning service using typical service equipment will be performed. Students must be able to perform physical tasks to complete course requirements.
    MnTC Goals
    None

    Prerequisite(s): AST 2075  and instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Operational theory
    2. Component replacement
    3. Service procedures
    4. Service equipment
    5. Retrofitting
    6. ASE recovery/recycling certification
    7. Completion of NATEF tasks associated with course
    8. Safety

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe safety precautions associated with course.
    2. identify air conditioning system components.
    3. describe the operational theory of an air conditioning system.
    4. perform air conditioning service using typical service equipment.
    5. perform recovery/recycling procedures.
    6. diagnose typical air conditioning problems.
    7. describe retrofit procedures.
    8. perform NATEF tasks during air conditioning service

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • AST 2095 - New Automotive Technology

    Credits: 3
    Hours/Week: Lecture 2 Lab 2
    Course Description: This course focuses on new and evolving technologies in the automotive industry. Topics include new equipment, vehicle systems, and service procedures. Students must be able to perform physical tasks to complete the course requirements.
    MnTC Goals
    None

    Prerequisite(s): AST 1005 , AST 1085 , AST 1095 , AST 1015 , AST 1045 , AST 1085 , and AST 1095  and instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. New vehicle technology
    2. New industry trends
    3. New service procedures
    4. New service equipment
    5. Advanced driver assistance systems
    6. Digital oscilloscope usage

    Learning Outcomes
    At the end of this course students will be able to:

    1. identify new technology on modern vehicles.
    2. demonstrate proper service procedures to diagnose and repair new systems and components found on modern vehicles.
    3. demonstrate the proper use of a digital oscilloscope during electrical system diagnosis.
    4. calibrate advanced driver assistance systems.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration


Biology

  
  • BIOL 1010 - Biological Foundations of Biofabrication

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course introduces students without a biology background to basic biological concepts required to succeed in subsequent courses for the biofabrication certificate.  The course provides a working understanding of the scientific method, proper use of biological laboratory equipment including microscopes, pipettes, and bioprinter, principles of biochemistry, properties of biological molecules, cell and tissue structure, and cells used to 3D print biological material.  The course includes hands-on projects applying the biological principles learned to the field of biofabrication.
    MnTC Goals
    None

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Process of science to answer questions related to biofabrication.
    2. Characteristics of strong experimental design, including identification and control of variables that affect the process of biofabrication.
    3. Proper light microscope and pipetting technique used in examining cells and creating cell cultures and bioinks.
    4. Importance of water and buffers in cell culture and biofabrication.
    5. Polymers and properties of biological molecules as related to bioinks.
    6. Basic cell structure and organelles of the cell
    7. Cell transport mechanisms including diffusion/osmosis that constrain biofabricated constructs.
    8. Cell reproduction as related to biofabrication.
    9. Energy metabolism in cells as it pertains to survival of biofabricated constructs.

    Learning Outcomes
    At the end of this course, students will be able to:

    1. develop a well-designed experiment to answer a scientific question related to biofabrication.
    2. make data-driven decisions related to the process of biofabrication.
    3. properly utilize microscope and other equipment to perform experiments and gather data, and differentiate between major cell types and structures as required in biofabrication.
    4. describe the basic structure and properties of matter as they pertain to the molecules that make up the cells utilized in biofabrication.
    5. apply knowledge of basic cell structure and the functions cells perform to reproduce and maintain homeostasis to problems related to viability of bioprinted cells.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BIOL 1020 - Biology Concepts

    Credits: 4
    Hours/Week: Lecture 3 Lab 2
    Course Description: This is a lab science course dealing with the basic concepts of general biology including cell biology, energy capture and utilization, heredity, origin and descent of life, classification of organisms, and environmental relationships of living things. Laboratory experiences are provided to acquaint students with basic lab methods and techniques.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: High school chemistry or CHEM 1020  or equivalent.

    Major Content
    1. Characteristics of life
    2. Organization of life Evolution
    3. Food chains and food webs
    4. Harvest of energy to sustain life
    5. Reproduction
    6. Heredity
    7. Evolution

    Learning Outcomes
    At the end of this course students will be able to:

    1. Demonstrate understanding of the scientific method, scientific inquiry, and development of scientific theories.
    2. Discuss how biology can be a way of seeking knowledge about oneself and ones place in nature.
    3. Demonstrate a mastery of biological concepts and principles, biological vocabulary, and biological laws and theories.
    4. Explain the basic concepts and functions of biological systems.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 02. Formulate and test hypotheses by performing laboratory, simulation, or field experiments in at least two of the natural science disciplines. One of these experimental components should develop, in greater depth, students’ laboratory experience in the collection of data, its statistical and graphical analysis, and an appreciation of its sources of error and uncertainty. 03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.


    Courses and Registration

  
  • BIOL 1021 - Biology of Women

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course investigates male and female reproductive anatomy and physiology, the basis of scientific inquiry and investigation, analysis of scientific data, and sexual and reproductive biology of women and men including contraception, pregnancy, childbirth, and infertility. The biology of cancers, sexually transmitted diseases and infections, and systemic chronic diseases throughout the lifespan is also included. Lab-like experiences and simulations are part of the course. Course is open to both women and men.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: High school biology or BIOL 1020  

    Major Content
    1. How science works. The scientific method of inquiry and investigation.
    2. The development of scientific theories
    3. Sexual and reproductive dimensions of womens and mens health.
    4. The reproductive anatomy and physiology of women and men, including development throughout the lifespan
    5. Biologic basis of sexually transmitted diseases and infections
    6. Physiology and treatment of various menstrual disorders
    7. Anatomy and physiology of pregnancy, childbirth, and infertility
    8. Action and physiology of various contraceptive methods, their actions, effectiveness, and epidemiology
    9. Understanding the biologic basis for and the prevention of cancers and systemic chronic diseases throughout the female lifespan

    Learning Outcomes
    At the end of this course students will be able to:

    1. demonstrate understanding of the scientific method, scientific inquiry, and development of scientific theories.
    2. explain sexual and reproductive anatomy and physiology of women and men.
    3. analyze various contraceptive methods, their action, effectiveness, and epidemiology.
    4. describe the stages of pregnancy and childbirth.
    5. analyze and explain womens and mens reproductive health diseases or issues; including infertility, cancers, sexually transmitted diseases and infections.
    6. analyze societal issues of biology which are specific to women or men.
    7. evaluate evidence presented as it pertains to gender-specific biological issues; make informed judgments about these issues.
    8. analyze a set of data and make valid conclusions concerning the data.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.


    Courses and Registration

  
  • BIOL 1022 - Human Biology Lab

    Credits: 1
    Hours/Week: Lecture None Lab 1
    Course Description: This course is an applied lab focused on the human organ systems and designed to supplement learning in BIOL 1024, which is a survey of the human organ systems by structure and function. Organ systems include integumentary, skeletal, muscular, nervous, endocrine, circulatory, respiratory, digestive, urinary, and reproductive. The scientific method of inquiry, human reproduction, development, and heredity are other topics integrated into the biology of the human body. This course is designed for students who wish to gain a better understanding of the biology of the human body, including liberal arts majors.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): BIOL 1024  or concurrently enrolled.
    Note: Students concurrently enrolled in prerequisite course must contact Records Office for verification.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Histology: Tissue form, function, and organization
    2. Form, function, and diseases associated with human organ systems listed below:
    3. Integumentary system: the skin and its derivatives for protection
    4. The scientific method of inquiry and investigation and the development of scientific theories from information gained by using the scientific method
    5. Skeletal system: the bones, cartilage, ligaments, and other tissues for structure and support
    6. Cardiovascular system: the heart, blood vessels, and blood for transportation
    7. Digestive system: the gastrointestinal tract and associated digestive organs for nutrition and waste removal
    8. Endocrine system: the glands of internal secretion and hormone products for chemical regulation
    9. Lymphatic system: the lymphatic organs for collection and cleansing of interstitial fluid and mechanisms for defense against disease (immunity)
    10. Muscular system: the muscles, tendons, and other tissues for locomotion
    11. Nervous system: the central nervous system (brain and spinal cord) and the peripheral nervous system for responsiveness, communication
    12. Respiratory system: the lungs, bronchial tubes, and related structures for gas exchange
    13. Sensory mechanisms: somatic receptors to collect sensory information from the body and special senses that allow for smell, taste, sight, hearing, and equilibrium
    14. Urinary system: the kidneys and associated structures for excretion
    15. Reproductive system: the gonads, ducts, and accessory structures for sexual reproduction, development, and heredity

    Learning Outcomes
    At the end of this course, students will be able to:

    1. explain the relationship between form and function of human organ systems.
    2. describe how human organ systems integrate for overall form and function.
    3. describe how various diseases affect human organ systems function and overall body function.
    4. explain relevant scientific theories.
    5. explain the methods of scientific inquiry.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 02. Formulate and test hypotheses by performing laboratory, simulation, or field experiments in at least two of the natural science disciplines.  One of these experimental components should develop, in greater depth, students’ laboratory experience in the collection of data, its statistical and graphical analysis, and an appreciation of its sources of error and uncertainty.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BIOL 1023 - Introduction to Forensic Biology

    Credits: 4
    Hours/Week: Lecture 3 Lab 2
    Course Description: This course deals with many of the basic concepts of general and human biology and chemistry, including a survey of various areas of forensic biology. Topics include DNA structure and analysis, analysis of skeletal evidence, biological trace evidence, blood and other body fluids, fingerprinting, and an overview of the human organ systems connected to these kinds of evidence.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Structure and function of organic molecules
    2. Properties of water
    3. Structure and function of cells
    4. Cellular reproduction
    5. Definition of science, biology, and forensic science
    6. History of the development of biology and forensic science
    7. Characteristics of tissues, hairs, DNA
    8. Other methodologies as they arise in the field(s)

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe the historic development of biology and forensic science.
    2. demonstrate the proper use of a compound microscope, stereomicroscope, and awareness of the principles of other types of microscopes including comparison, phase contrast, and electron microscopes.
    3. analyze the applications of science in society, e.g., the application of the scientific method to our daily lives as well as to the legal system (such as understanding the biology of and validity DNA in medical and legal proceedings).
    4. explain how to collect and preserve biological materials for scientific investigation.
    5. describe the physiological effects of various environmental and chemical agents, including disease-causing organisms, toxins, poison, medications, and illicit drugs.
    6. identify basic concepts of biology and chemistry, especially as they apply to the human body, including cell structure and function, biology of and analysis of DNA, and biological properties of blood and other body fluids.
    7. describe selected principles that have been developed through the work of relevant scientists.
    8. describe the structures and functions of the basic tissue types and of each of the body’s organs and organ systems.
    9. explain cellular reproduction, including cell division, the genetic code, DNA replication, and protein synthesis.
    10. explain the basic structure and function of human organ systems.
    11. explain the methods of scientific inquiry.
    12. explain changes that occur in biological systems as they decompose and factors that affect decomposition.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 02. Formulate and test hypotheses by performing laboratory, simulation, or field experiments in at least two of the natural science disciplines. One of these experimental components should develop, in greater depth, students’ laboratory experience in the collection of data, its statistical and graphical analysis, and an appreciation of its sources of error and uncertainty. 03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.


    Courses and Registration

  
  • BIOL 1024 - Human Biology

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course is a survey of the human organ systems by structure and function. Organ systems include integumentary, skeletal, muscular, nervous, endocrine, circulatory, respiratory, digestive, urinary, and reproductive. The scientific method of inquiry, human reproduction, development, and heredity are other topics integrated into the biology of the human body. This course is designed for students who wish to gain a better understanding of the biology of the human body, including liberal arts majors. This course will include lab-like experiences.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher. 
    Corequisite(s): None
    Recommendation: High school biology or BIOL 1020  

    Major Content
    1. Histology: Tissue form, function, and organization
    2. Form, function, and diseases associated with human organ systems listed below:
    3. Integumentary system: the skin and its derivatives for protection
    4. The scientific method of inquiry and investigation and the development of scientific theories from information gained by using the scientific method
    5. Skeletal system: the bones, cartilage, ligaments, and other tissues for structure and support
    6. Cardiovascular system: the heart, blood vessels, and blood for transportation
    7. Digestive system: the gastrointestinal tract and associated digestive organs for nutrition and waste removal
    8. Endocrine system: the glands of internal secretion and hormone products for chemical regulation
    9. Lymphatic system: the lymphatic organs for collection and cleansing of interstitial fluid and mechanisms for defense against disease (immunity)
    10. Muscular system: the muscles, tendons, and other tissues for locomotion
    11. Nervous system: the central nervous system (brain and spinal cord) and the peripheral nervous system for responsiveness, communication
    12. Respiratory system: the lungs, bronchial tubes, and related structures for gas exchange
    13. Sensory mechanisms: somatic receptors to collect sensory information from the body and special senses that allow for smell, taste, sight, hearing, and equilibrium
    14. Urinary system: the kidneys and associated structures for excretion
    15. Reproductive system: the gonads, ducts, and accessory structures for sexual reproduction, development, and heredity

    Learning Outcomes
    At the end of this course students will be able to:

    1. explain the relationship between form and function of human organ systems.
    2. describe how human organ systems integrate for overall form and function.
    3. describe how various diseases affect human organ systems function and overall body function.
    4. explain relevant scientific theories
    5. explain the methods of scientific inquiry.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.


    Courses and Registration

  
  • BIOL 1025 - Field Biology

    Credits: 4
    Hours/Week: Lecture 3 Lab 2
    Course Description: This is a lab science course dealing with interrelationships between environmental influences and organisms as well as surveying flora and fauna. Concerns considered include climate change, ozone depletion, ground water contamination, acid rain, and hazardous waste disposal. This is an experience-centered course in which students have the opportunity to learn fundamental environmental principles, basic concepts of biology, and conservation through integrated laboratory and lecture presentation and field work. This is a lab science general education course.
    MnTC Goals
    3 Natural Science, 10 People/Environment

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: High school biology or BIOL 1020  or equivalent.

    Major Content
    1. Environmental problems
    2. Ecological principles
    3. Biodiversity
    4. Natural resources
    5. Pollution
    6. Sustainability

    Learning Outcomes
    At the end of this course students will be able to:

    1. explain relationships between the plant and animal world and the influence of the environment on all levels of plant and animal organization.
    2. discuss the principles and techniques of systematics using flora and fauna and the principles governing distribution of organisms
    3. explain changes of living things through time, e.g., ecological succession.
    4. describe attitudes which lead to constructive action on social and economic problems of wide concern, e.g., conservation.
    5. discuss ones place in the total picture and health of the natural world.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.
    Competency 2 (7-10)
    10. 01. Explain the basic structure and function of various natural ecosystems and of human adaptive strategies within those systems.
    10. 02. Discern patterns and interrelationships of bio-physical and socio-cultural systems.
    10. 04. Evaluate critically environmental and natural resource issues in light of understandings about interrelationships, ecosystems, and institutions.
    10. 05. Propose and assess alternative solutions to environmental problems.


    Courses and Registration

  
  • BIOL 1027 - Climate Change Biology

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course deals with the effects of climate change on various biological species and ecosystems. Topics include basic biology concepts including characteristics and organization of life, ecosystems, biogeochemical cycles, basic climate change science, and how various organisms are responding to it. Students will form eco-teams”, a type of non-traditional lab component to the course, in which they will calculate their carbon footprints and analyze and determine ways to decrease their environmental impact. Students will explore practical ways to live more sustainably and how to be responsible citizens in regard to sustainability; all of which can improve one’s quality of life, slow climate change, and help protect present and future generations of humans and other species.
    MnTC Goals
    3 Natural Science, 10 People/Environment

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Organization of life
    2. Characteristics of life
    3. Energy of life (cellular respiration, photosynthesis)
    4. Ecosystems
    5. Biogeochemical cycles
    6. Greenhouse effect, natural versus enhanced
    7. Carbon footprint
    8. Basic science of climate change
    9. Effects of climate change on biodiversity in general and on selected species and ecosystems (e.g., species range shifts, ocean chemistry changes, sea level changes, freshwater changes, changes in pests and pathogens, endangerment and extinctions)
    10. Responses of species to climate change, including species native to Minnesota
    11. Sustainable living
    12. International policy and collaboration for solutions
    13. Practical (and not so practical) ways to live more sustainably
    14. Group and individual planning, taking planned actions, and assessing resulting decrease in individual environmental impact

    Learning Outcomes
    At the end of this course students will be able to:

    1. explain the basic organization of biology. (atoms, molecules, cells, tissues, organs, organisms, populations, communities, ecosystems, biosphere)
    2. describe the effects of climate change on living organisms and ecosystems
    3. explain relationships between climate change and agriculture, deforestation, burning of fossil fuels, and human population growth
    4. apply several aspects of sustainable living to one’s personal life through working as part of an Eco-Team.
    5. explain how our culture needs to shift its assumptions about what a good quality of life really is and how to influence and help bring about changes needed to bring about this shift
    6. assess the consequences of global environmental change for people, for ecosystems, and for the biosphere
    7. explain the importance of ones place in the total picture and health of the natural world and of society
    8. explain the basic biogeochemical cycles
    9. describe the major ecosystems
    10. calculate individual carbon dioxide equivalents emissions (carbon footprint)
    11. develop and implement plans to reduce carbon footprint
    12. explain the difference between the natural greenhouse effect and the enhanced (anthropogenic) carbon cycle
    13. explain the basic characteristics of life

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.
    Competency 2 (7-10)
    10. 02. Discern patterns and interrelationships of bio-physical and socio-cultural systems.
    10. 03. Describe the basic institutional arrangements (social, legal, political, economic, religious) that are evolving to deal with environmental and natural resource challenges.
    10. 05. Propose and assess alternative solutions to environmental problems.
    10. 06. Articulate and defend the actions they would take on various environmental issues.


    Courses and Registration

  
  • BIOL 1029 - Microbes and Society: An Introduction to Microbiology

    Credits: 4
    Hours/Week: Lecture 3 Lab 2
    Course Description: This course introduces students to the biology of the major microbial groups, their role in our everyday existence, and the methods of scientific inquiry. The lecture provides a global, cultural, and societal perspective on the roles microorganisms play in human civilizations. Contemporary topics, such as genetic engineering, bioterrorism, antibiotic resistance, biotechnology, emerging infectious diseases, and the consequences of public policies on the emergence, spread, and control of infectious disease will be examined. The laboratory will acquaint students with basic techniques used in the handling of microorganisms, and investigate the properties and uses of microbes. This course is intended for students who require a laboratory science course to fulfill general education or degree requirements. This course is not intended for students who require a microbiology course for Nursing, Pharmacy, Dental Hygiene or other allied health programs. 
    MnTC Goals
    3 Natural Science, 10 People/Environment

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Historical roots of microbiology: 1600s to the present day
    2. Microbial classification systems, nomenclature, microscopy
    3. Bacteria: structure and physiology, important bacterial groups
    4. Viruses: structure, replication, role in cancer
    5. Prions: structure, mechanisms of disease causation
    6. Protists: amoebas, flagellates, ciliates, sporozoa, unicellular algae, slime molds, water molds
    7. Fungi: classification, structure, growth, beneficial types, pathogenic types
    8. Microbial growth and metabolism
    9. Microbial genetics: genomes, transcription, translation, genetic regulation, genetic mutations, genetic recombination, genetic engineering
    10. Control of microbes and infectious diseases: physical and chemical methods, and the legal, political, social and economic issues concerning antibiotic resistance and vaccines
    11. Cultural perspective on the use of microbes in food production: wine, vinegar, bread, cheese, olives, sausages, sauerkraut, soy sauce, pickles, beer, brandy, cocoa, chocolate, coffee, and others.
    12. Food safety and food preservation: food spoilage, methods of food preservation, programs for preventing foodborne disease
    13. Genomics: methodology, microbial genomes, Human Genome Project
    14. Biotechnology and industrial use of microbes throughout the world: pharmaceuticals, antibiotics, vaccines, DNA analysis and fingerprinting, enzymes, organic acids, vitamins, hormones, steroids.
    15. Microbes and global agriculture: nitrogen cycle, ruminant digestion, dairy production, insecticides, herbicides, genetically modified foods, food based vaccines.
    16. Microbes and the global ecosystem: biogeochemical cycles, water, sewage, and waste treatment, bioremediation, detection of microbial pollution
    17. Immunology: relationships between humans and microbes, establishment of disease, nonspecific resistance to disease, cell-mediated immunity, antibody-mediated immunity, hypersensitivities, vaccinations
    18. Viral, fungal, prion, protozoal, and bacterial diseases of humans
    19. Bioterrorism: history, categories, major microbes of interest, detection, and countermeasures
    20. Social, environmental and political factors contributing to the emergence and reemergence of infectious diseases
    21. Global, cultural, social, environmental and political factors contributing to the emergence and reemergence of infectious diseases and the evolving institutional arrangements
    22. Global, national and local efforts designed for emerging and reemerging infectious diseases: HIV and AIDS, prion diseases and transfer to humans, tuberculosis, and others
    23. General laboratory procedures and lab safety
    24. The scientific method and microbiology
    25. Use of the compound microscope
    26. Staining techniques
    27. Techniques for bacterial cultures: streak plates, broth cultures, agar slants.
    28. Characteristics of major bacterial groups such as Staphylococcus, Streptococcus, Bacillus, Lactobacillus, Clostridium
    29. Biochemical characteristics of bacteria and their use in the identification of unknown bacteria
    30. Evaluation of physical and chemical agents for controlling microbial growth
    31. Determining the sensitivity and resistance of bacteria to antibiotics
    32. Microbiology of foods: preservation, fermentation and plate counts
    33. Microbiology of dairy products: natural bacterial content of milk, preparation of yogurt
    34. Microbiology of water: detection of microbes, preparation of a biofilm
    35. Microbiology of soil: Isolation of bacteria from soil, antibiotic production from soil bacteria, microbial ecology in the soil
    36. Mutating bacterial genomes
    37. Immunological techniques for the determination of blood type and diagnosis of microbial diseases (simulation)
    38. Use of biotechnology based laboratory techniques for the identification of individuals infected with an agent used in a bioterrorism attack (simulation)

    Learning Outcomes
    At the end of this course students will be able to:

    1. explain the methods of scientific inquiry, the scientific method, and the development of scientific theories.
    2. explain the structures, reproductive methods, and functions of bacteria, algae, viruses, protists, helminths, fungi, and prions.
    3. describe the central role of microbes in the functioning of earth’s ecosystems including their role in energy production, decomposition, and biogeochemical recycling.
    4. analyze the roles of microbes in food production, agriculture, industry, bioremediation, biotechnology, genetic engineering and biological research from a global, environmental and social perspective.
    5. interpret the effect of environmental conditions on the growth and control of microorganisms.
    6. describe the association of microbes with humans, the microbial mechanisms of disease, and the human response to microbial infections from a biological and public health viewpoint.
    7. analyze the global, cultural, social, environmental and political factors contributing to the emergence of infectious diseases.
    8. analyze the consequences of public policy decisions on environmental and human health and institutional arrangements that are evolving to deal with these challenges.
    9. demonstrate proper laboratory techniques in the handling of microorganisms.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 02. Formulate and test hypotheses by performing laboratory, simulation, or field experiments in at least two of the natural science disciplines. One of these experimental components should develop, in greater depth, students’ laboratory experience in the collection of data, its statistical and graphical analysis, and an appreciation of its sources of error and uncertainty. 03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.
    Competency 2 (7-10)
    10. 01. Explain the basic structure and function of various natural ecosystems and of human adaptive strategies within those systems.
    10. 02. Discern patterns and interrelationships of bio-physical and socio-cultural systems.
    10. 03. Describe the basic institutional arrangements (social, legal, political, economic, religious) that are evolving to deal with environmental and natural resource challenges.
    10. 04. Evaluate critically environmental and natural resource issues in light of understandings about interrelationships, ecosystems, and institutions.
    10. 05. Propose and assess alternative solutions to environmental problems.


    Courses and Registration

  
  • BIOL 1033 - Introduction to Human Genetics

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This introductory non-laboratory Biology course is designed to expose students to a wide range of topics surrounding genetics. Topics covered include: cell structure and function, cell reproduction, organismal reproduction, gene transfer, Mendelian genetics, mutations, and developmental genetics. Techniques used to study human genetics and reproduction will also be discussed. Ethical implications of gene manipulation will be interwoven throughout the course. This course will contain lab-like experiences although it is not a traditional lab course.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Cell reproduction
    2. Cell structure and function
    3. Ethical implications of gene manipulation
    4. Genetic manipulation techniques
    5. Genetics of cancer
    6. Genetics of immunity
    7. How science “works”
    8. Human Genome Project
    9. Human reproduction
    10. Mendelian inheritance
    11. Non-mendelian inheritance
    12. Pedigrees
    13. Population genetics
    14. Relationship between genetics and evolution
    15. Use of genetic data

    Learning Outcomes
    At the end of this course students will be able to:

    1. explain the process of cell reproduction.
    2. describe basic cell structures and their functions.
    3. explain the genetics involved in immunity.
    4. describe basic gene manipulation techniques.
    5. explain the genetics involved in cancer.
    6. use basic genetic terminology.
    7. explain the implications of gene manipulation on individual, population, societal, and ecological levels.
    8. explain the process of organismal reproduction.
    9. explain Mendelian inheritance principles.
    10. describe non-Mendelian inheritance patterns.
    11. describe a pedigree.
    12. analyze human genetic data to determine probable inheritance patterns.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.


    Courses and Registration

  
  • BIOL 1041 - Principles of Biology I

    Credits: 5
    Hours/Week: Lecture 4 Lab 3
    Course Description: This is a lab science course that provides a general introduction to biological principles. Topics include basic chemistry, biological molecules, cell structure, metabolism, cell reproduction, molecular biology, genetics, and evolution. Laboratory exercises provide students the opportunity to better understand basic biological principles through scientific practice in hypothesis-development, experimental design, data collection and analysis.  Students will also gain experience with commonly-used biological instruments and equipment.  This laboratory science course is primarily intended for biology or biology-related majors, health-related pre-professionals, and other related liberal arts majors.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher. BIOL 1020  with a grade of C or higher OR CHEM 1020  or higher with a grade of C or higher OR one year each of High School Biology AND High School Chemistry with grades of C or higher within the last three years OR Instructor consent.
    Corequisite(s): None
    Recommendation: BIOL 1020  AND CHEM 1020  or higher, OR one year each of High School Biology AND High School Chemistry with grades of C or higher within the last three years.

    Major Content
    1. Introduction to Biology as a Science
    2. Scientific Inquiry and Investigation:  Hypothesis formation, Experimental Design, and Data Analysis
    3. Chemistry of Life:  Atoms, Bonding, Characteristics of Water and Macromolecules
    4. Cell Structure and Function: Cell theory, Prokaryotic vs. Eukaryotic, Plasma membrane, Nucleus, Cytoplasm and Organelles
    5. Enzymes and Cell Metabolism:  Energy Transformations, Enzyme structure and Function, ATP, Photosynthesis, and Cellular Respiration
    6. Cell Division:  Mitosis, Meiosis, and Control of Cell Division
    7. Molecular biology: Structure and Function of DNA, Protein Synthesis, DNA technology
    8. Genetics and Inheritance: Mendelian Rules, Punnett Squares, Pedigrees, Complex Inheritance Patterns
    9. Evolution: Theory and Evidence, Mechanisms of Microevolution, Macroevolution, Phylogenetic Inference

    Learning Outcomes
    At the end of this course students will be able to:

    1. explain basic principles of biochemistry, biological molecules, cell structure and organelle function, metabolism, genetics, and evolution.
    2. apply basic principles of biochemistry, cell structure and organelle function, metabolism, genetics, and evolution to specific situations.
    3. demonstrate understanding of major scientific theories in biology. 
    4. formulate and test hypotheses by designing and/or performing laboratory experiments that include data collection and interpretation, statistical analysis, graphical presentation of results, quantitative reasoning, and interpretation of sources of error and uncertainty.
    5. distinguish between primary and secondary scientific literature.
    6. identify characteristics of strong experimental design.
    7. analyze and interpret primary literature related to biology, including critique of experimental design.
    8. communicate experimental findings both orally and in writing.
    9. use the compound light microscope and other biological laboratory equipment within the context of laboratory investigations.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 02. Formulate and test hypotheses by performing laboratory, simulation, or field experiments in at least two of the natural science disciplines. One of these experimental components should develop, in greater depth, students’ laboratory experience in the collection of data, its statistical and graphical analysis, and an appreciation of its sources of error and uncertainty. 03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.


    Courses and Registration

  
  • BIOL 1042 - Principles of Biology II

    Credits: 5
    Hours/Week: Lecture 4 Lab 3
    Course Description: This is a lab science course dealing with ecology and a taxonomic survey of the major groups of organisms. It is a continuation of BIOL 1041  . Topics include phylogeny, morphology, development, and structure-function relationships of viruses, bacteria, protistans, plants, fungi, and animals, as well as ecology at the population, community, and ecosystem levels. Laboratory exercises consist of observations and investigations of ecological interactions as well as practical identification of various organisms and structures.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): BIOL 1041  with a grade of C or higher
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Taxonomy and distinguishing features of major life forms
      1. prokaryotic diversity
      2. protist diversity
      3. fungal diversity
      4. plant diversity and evolution
      5. metazoan body plans and animal diversity (may include dissection)
    2. Behavioral Ecology
    3. Population Ecology
    4. Community Ecology
    5. Ecosystem Ecology
    6. The Biosphere

    Learning Outcomes
    At the end of this course students will be able to:

    1. demonstrate understanding of scientific method, scientific inquiry, and development of scientific theories.
    2. describe the distinguishing characteristics of the major groups of organisms.
    3. explain the probable phylogenetic relationships among these groups.
    4. describe the life cycles of organisms which are representative of these groups.
    5. identify important structures and functions in these organisms.
    6. distinguish characteristics of major groups of viruses.
    7. describe the differences between prokaryotes and eukaryotes.
    8. explain the interaction/interdependence of various groups of organisms.
    9. distinguish among factors that influence ecological population growth or decline.
    10. explain interactions between and among members of an ecological community.
    11. describe the movement of energy through ecosystems.
    12. apply concepts, knowledge, and vocabulary of biology at the level necessary for success in subsequent biology course for science majors.
    13. demonstrate quantitative reasoning skills.
    14. demonstrate dissection skills necessary for examination of internal anatomy of preserved specimens.
    15. demonstrate microscopy skills necessary for observation of living organisms.
    16. formulate and test hypotheses and communicate experimental findings.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.


    Courses and Registration

  
  • BIOL 1790 - Independent Study

    Credits: 1-3
    Hours/Week: Lecture None Lab None
    Course Description: This variable-credit elective course emphasizes the student’s independent search for advanced knowledge as well as additional hands-on skills beyond current Biology course offerings. The student and instructor will devise a formal plan of study to satisfy credit workload requirements within the semester timeline.
    MnTC Goals
    None

    Prerequisite(s): Instructor and dean consent dean.
    Corequisite(s): None
    Recommendation: BIOL 1020 

    Major Content
    To be determined by the student and instructor on an individual basis.
    Learning Outcomes
    At the end of this course students will be able to:

    1. demonstrate advanced knowledge of the subject area identified in the learning plan.
    2. explain results of the independent study in a formal presentation to the instructor and/or a Biology class.
    3. reflect on personal growth in the subject area identified in the plan.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BIOL 2010 - Cell and Tissue Biology for Biofabrication

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course provides students earning the biofabrication certificate a foundation in cell and tissue biology required to succeed in the field of biofabrication.  The course covers cell and tissue types, including those used in bioprinting, components of the extracellular matrix, factors that influence cell and tissue maturation, bioink components, sterile technique, staining, imaging, and microscopy, biohazardous materials and safety, and steps involved in 3D printing biological material.  Culturing cells and tissues requires adherence to aseptic or sterile technique.  The course includes a variety of hands-on projects applying knowledge of cells and tissues to the field of biofabrication.
    MnTC Goals
    None

    Prerequisite(s): BIOL 1010  or BIOL 1020  or BIOL 1041  with a grade C or higher
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Review of cell components, including the importance of the extracellular matrix
    2. Basic tissue structure and different types of tissues
    3. Factors that influence cell and tissue maturation
    4. Cell and tissue culture methods
    5. Physiological limits of diffusion as it relates to bioprinting
    6. Process of bioink preparation, different types of bioinks, crosslinking techniques, including review of polymers
    7. Microscopy and imaging techniques, including anatomical planes and staining for cell viability
    8. Sterile technique in a variety of settings
    9. Biohazards of using living tissues

    Learning Outcomes
    At the end of this course, students will be able to:

    1. classify the various cell types used in tissue culture and 3D bioprinting, including embryonic, induced embryonic, and pluripotent stem cells. 
    2. distinguish between various tissue types, including the challenges to bioprinting each type
    3. analyze the advantages and disadvantages of various bioinks used in bioprinting to determine appropriate bioink for a particular 3D construct.
    4. compare and perform advanced forms of staining, imaging, and microscopy used in cell and tissue culture for 3D bioprinting.
    5. explain factors that influence cell and tissue maturation.
    6. demonstrate proper handling of biohazardous material.
    7. demonstrate proper and consistent use of sterile technique
    8. apply content knowledge and skills to print a project made of biological material.
    9. analyze printed project for viability and maturation using appropriate stains and microscopy.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BIOL 2028 - Ecology

    Credits: 4
    Hours/Week: Lecture 3 Lab 1
    Course Description: This is a lab-science course covering the concepts of ecology including physical factors of organisms, population regulation and interactions, nutrient cycling and energy flow, community change and succession. Natural and human disturbances of ecosystems and the concept of sustainability will also be within the concepts of ecology. The major biomes will be explored in relationship to these concepts. Students will also explore the interactions of humans and their environment through Service Learning and active participation in field projects.
    MnTC Goals
    3 Natural Science, 10 People/Environment

    Prerequisite(s): BIOL 1020   or BIOL 1041  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. History and development of ecology as a science
    2. Patterns of biological diversity
    3. Ecosystem ecology: energetics; decomposition, nutrient cycles and biogeochemical cycles
    4. Population ecology: properties and growth, species interactions
    5. Disturbance and climate change; the physical environment
    6. Adaptation and natural selection
    7. Life history and intraspecific population regulation
    8. Behavioral ecology
    9. Community ecology: structure and dynamics, species interactions
    10. Selected ecological biogeography

    Learning Outcomes
    At the end of this course students will be able to:

    1. apply knowledge of the relationships of organisms with their environment at the level of the individual, population, community, ecosystem, and biosphere.
    2. evaluate ecological processes and interactions.
    3. select a sampling method plan, a sampling regime and apply relevant statistical tests to ecological data.
    4. formulate a working hypothesis in the context of an ecological experiment.
    5. design and analyze an ecological experiment.
    6. organize and draft formal scientific writing.
    7. edit and revise formal scientific writing.
    8. incorporate and cite information and ideas from primary literature into writing.
    9. evaluate and reflect on the value of ecological modeling, monitoring, and restoration to human society.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.
    Competency 2 (7-10)
    10. 01. Explain the basic structure and function of various natural ecosystems and of human adaptive strategies within those systems.
    10. 02. Discern patterns and interrelationships of bio-physical and socio-cultural systems.
    10. 04. Evaluate critically environmental and natural resource issues in light of understandings about interrelationships, ecosystems, and institutions.
    10. 05. Propose and assess alternative solutions to environmental problems.


    Courses and Registration

  
  • BIOL 2031 - Human Anatomy and Physiology I

    Credits: 4
    Hours/Week: Lecture 3 Lab 2
    Course Description: This is the first of a two-semester lab science course. Human anatomy and physiology are studied using a body systems approach, with emphasis on the interrelationships between form and function at the gross and microscopic levels of organization. Homeostasis is an integrating theme throughout this course. Subjects considered include basic anatomical and directional terminology, fundamental concepts and principles of cell physiology, histology, and the integumentary, skeletal, muscular, endocrine, nervous, and hematopoietic systems. This course is intended for anyone interested in gaining a better understanding of the anatomy and functioning of the human body.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher. BIOL 1020  with a grade of C or higher AND CHEM 1020  with a grade of C or higher OR one year each of High School Biology AND High School Chemistry with grades of C or higher within the last three years OR instructor consent.
    Corequisite(s): None
    Recommendation: BIOL 1041  and CHEM 1041 

    Major Content
    1. Body Plan and Organization
    2. Homeostasis
    3. Chemistry and Cell Physiology
    4. Histology
    5. Integumentary System
    6. Skeletal System
    7. Muscular System
    8. Special Senses
    9. Endocrine System
    10. Hematopoietic System

    Learning Outcomes
    At the end of this course students will be able to:

    1. Apply descriptive anatomical and directional terminology
    2. Identify cellular structures and explain their respective functions.
    3. Identify and describe the basic tissues of the body, their locations, and explain their functions.
    4. Identify and describe the major gross and microscopic anatomical components and functions of the integumentary system.
    5. Identify and describe the major gross and microscopic anatomical components of the skeletal system and explain their functional roles in osteogenesis, repair, and body movement.
    6. Identify and describe the major gross and microscopic anatomical components of the muscular system and explain their functional roles in body movement, maintenance of posture, and heat production.
    7. Identify and describe the major gross and microscopic anatomical components of the eye and ear and explain their functional roles in vision, hearing and equilibrium. Students should also be able to identify and locate the receptors responsible for olfaction and gustation and briefly describe the physiology of smell and taste.
    8. Identify and describe the major gross and microscopic anatomical components of the nervous system and explain their functional roles in communication, control, and integration.
    9. Identify and describe the major gross and microscopic anatomical components of the endocrine system and explain the functional roles of their respective hormones in communication, control, and integration.
    10. Explain the basic concept of homeostasis and how homeostatic mechanisms apply to body systems.
    11. Describe the general function of blood as a component of the cardiovascular system.
    12. Explain blood grouping antigens and apply to compatibility of blood transfusions.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 02. Formulate and test hypotheses by performing laboratory, simulation, or field experiments in at least two of the natural science disciplines. One of these experimental components should develop, in greater depth, students’ laboratory experience in the collection of data, its statistical and graphical analysis, and an appreciation of its sources of error and uncertainty. 03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.


    Courses and Registration

  
  • BIOL 2032 - Human Anatomy and Physiology II

    Credits: 4
    Hours/Week: Lecture 3 Lab 2
    Course Description: This is the second of a two-semester lab science course. Human anatomy and physiology are studied using a body systems approach, with emphasis on the interrelationships between form and function at the gross and microscopic levels of organization. Homeostasis is an integrating theme throughout this course. Subjects considered include the cardiovascular system, lymphatic system and immunity, respiratory system, digestive system and metabolism, urinary system, fluid/electrolyte and acid/base balance, and reproductive systems. This course is intended for anyone interested in gaining a better understanding human anatomy and body functions.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): BIOL 2031  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Cardiovascular System
    2. Lymphatic System
    3. Respiratory System
    4. Digestive System and Metabolism
    5. Urinary System
    6. Fluid/Electrolyte and Acid/Base Balance
    7. Reproductive Systems

    Learning Outcomes
    At the end of this course students will be able to:

    1. Identify and describe the major gross and microscopic anatomical components of the cardiovascular system and their functional roles in transport and hemodynamics.
    2. Identify and describe the major gross and microscopic anatomical components of the lymphatic system and their functional roles in fluid dynamics and immunity.
    3. Identify and describe the major gross and microscopic anatomical components of the respiratory system and their functional roles in breathing/ventilation and in the processes of external and internal respiration.
    4. Identify and describe the major gross and microscopic anatomical components of the digestive system and their functional roles in digestion, absorption, nutrition, metabolism, excretion and elimination.
    5. Identify and describe the major gross and microscopic anatomical components of the urinary system and their functional roles.
    6. Identify and describe the physiology of the homeostatic mechanisms that control fluid electrolyte and acid base balance.
    7. Identify and describe the major gross and microscopic anatomical components of the male and female reproductive systems and their functional roles in reproduction and inheritance.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 02. Formulate and test hypotheses by performing laboratory, simulation, or field experiments in at least two of the natural science disciplines. One of these experimental components should develop, in greater depth, students’ laboratory experience in the collection of data, its statistical and graphical analysis, and an appreciation of its sources of error and uncertainty. 03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.


    Courses and Registration

  
  • BIOL 2035 - Microbiology

    Credits: 3
    Hours/Week: Lecture 2 Lab 3
    Course Description: This is a lab science course that surveys the major groups of microorganisms with an emphasis on their structural characteristics, factors affecting growth and reproduction, interactions with host organisms and physical and chemical methods of control. Issues related to antibiotic use and infectious diseases are included. The laboratory portion includes experiences in the safe handling of microorganisms, and methods for the culture, visualization, and identification of known and unknown microorganisms.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): BIOL 2032  with a grade of C or higher or concurrently enrolled.
    Note: students concurrently enrolled in prerequisite course must contact Records Office for verification.
     
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Introduction
    2. Laboratory Techniques for Studying Microorganisms
    3. Prokaryotes and Eukaryotes
    4. Viruses and Prions
    5. Physical and Chemical Control of Microbes
    6. Interaction of Microorganisms and the Host Organism
    7. Case Studies of Infectious Diseases

    Learning Outcomes
    At the end of this course students will be able to:

    1. Demonstrate the proper classification and nomenclature of microorganisms
    2. Compare and contrast the structures, functions, and replication of microorganisms
    3. Explain how microorganisms adapt to their environment through genetic changes and the significance of these changes
    4. Describe the methods for culture and visualization of microorganisms
    5. Determine appropriate physical and chemical methods for the control of microorganisms
    6. Explain the mechanisms of action of antimicrobial drugs, interactions between drugs and host, and the development and effects of antibiotic resistance
    7. Explain the general process for the establishment, progress, and transmission of infections
    8. Describe the components and functioning of the nonspecific and specific mechanisms of host defense
    9. Explain the application of immunologic principles for the detection and identification of microorganisms
    10. Compare and contrast normal and abnormal host cell response to microbial infection
    11. Identify key environmental, political, and social factors contributing to the spread and treatment of microbial diseases using real world and simulated case studies
    12. Demonstrate laboratory skills in aseptic technique, microscopy, culture, isolation, and identification of microorganisms

    Competency 1 (1-6)
    03. 02. Formulate and test hypotheses by performing laboratory, simulation, or field experiments in at least two of the natural science disciplines. One of these experimental components should develop, in greater depth, students’ laboratory experience in the collection of data, its statistical and graphical analysis, and an appreciation of its sources of error and uncertainty. 03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.


    Courses and Registration

  
  • BIOL 2038 - Genetics

    Credits: 4
    Hours/Week: Lecture 3 Lab 1
    Course Description: This advanced Biology course introduces and reinforces genetic principles for Biology majors. This course covers the nature of genetic information at the molecular, cellular, organismal, and population level.  Topics include gene expression, heredity, genetic variation, population genetics, and lab techniques unique to genetics.  This course uses molecular biology and basic recombinant DNA techniques to apply modern techniques of genetics, including gene mapping, cloning, genome manipulation, and mutation. Lab includes hands-on experience in the safe handling and manipulation of model organisms. Intended for biology and life sciences majors.
    MnTC Goals
    None

    Prerequisite(s): BIOL 1041  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. DNA Structure and Function
    2. Cell cycle
    3. Mitosis
    4. Meiosis
    5. Mendelian principles
    6. Analysis of inheritance
    7. Multi-gene expression
    8. Non-Mendelian inheritance
    9. Gene mapping
    10. Cytogenetics
    11. Chromosomal abnormalities
    12. Genome organization in viruses, prokaryotes, and eukaryotes
    13. DNA replication
    14. Transcription
    15. Translation
    16. Mutations
    17. Population Genetics
    18. Evolutionary Genetics
    19. Developmental Genetics
    20. Medical Genetics
    21. Current Issues and Bioethics
    22. Molecular biology methods
    23. Recombinant DNA
    24. Model organisms

    Learning Outcomes
    At the end of this course students will be able to:

    1. analyze experimental data in reference to ecological, social, economic, ethical, and cultural implications.
    2. analyze genetic information using a pedigree analysis, test crosses, back crosses, complementation tests, and chi-square tests.
    3. communicate and work productively with others in designing, conducting, and evaluating projects or experiments.
    4. compare and contrast nuclear and non-nuclear genetic information.
    5. compare and contrast the nature of genetic information at the cellular, organismal, and population level.
    6. compare and contrast the structure and function DNA and RNA molecules.
    7. compare and contrast viral, prokaryotic, and eukaryotic chromosomal organization.
    8. compare and contrast viral, prokaryotic, and eukaryotic genes.
    9. compare gene linkage and genetic map distances.
    10. contrast cell cycle events in meiosis and mitosis.
    11. describe the biochemical and genetic mechanisms behind epistasis, pleiotropy, and quantitative traits.
    12. describe the mechanisms of mutations.
    13. differentiate between a gene and an allele.
    14. explain how non-random mating affects allele and genotype frequencies using the Hardy-Weinberg Equilibrium (HWE) in the context of evolution.
    15. explain Mendelian inheritance patterns at the cellular and organismal levels.
    16. explain the inheritance of germline mutations, somatic mutations, and epigenetic states.
    17. explain the process of DNA replication.
    18. explain the regulation of genetic information from DNA to mRNA to protein.
    19. explain the role of genetic expression in cell differentiation.
    20. explain, in written and oral format, experimental data and analyses from own and others’ experiments.
    21. identify the role of genes and their interaction with the environment to produce a phenotype.
    22. identify the roles of DNA modification, histone modification, and non-coding RNA in epigenetic inheritance.
    23. recognize all living organisms share a common ancestor and that species evolve over time. 
    24. theorize how new species can arise when allele frequencies change due to mutation, natural selection, gene flow, and genetic drift.
    25. use model organisms to study human genes and human genetic diseases.
    26. utilize other disciplines as sources of context and skills to inform the learning and work they are engaged in.
    27. use computers to access information from online databases, in data analysis and in the simulation of biological systems.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BIOL 2996 - Undergraduate Research in Biology

    Credits: 1-4
    Hours/Week:
    Course Description: In this course, students are supervised as they conduct original primary research on a particular topic or in a specific field in biology.  Students perform experimental research and work toward completion of a research project as part of the coursework.   The course may be repeated up to a total of 12 credits.
    MnTC Goals
    None

    Prerequisite(s): Instructor consent
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Experimental or Project design
    2. Data analysis
    3. Problem solving
    4. Communication of scientific findings

    Learning Outcomes
    At the end of this course, students will be able to:

    1. analyze complex problems found in existing literature related to the topic of study.
    2. articulate a clear research question and formulate a hypothesis.
    3. apply basic experimental design concepts to the specific issues related to the topic of study.
    4. analyze the benefits and drawbacks of new and existing research methods presented.
    5. demonstrate appropriate research methodologies.
    6. explain their research to others in the field and to broader audiences.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration


Business Management

  
  • BMGT 1005 - Personal Financial Planning

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course covers the challenges that individuals face in the financial planning process and potential solutions to those issues. Topics include budgeting income, individual taxation, consumer loans, student loans, bank accounts, investment products, disability plans, retirement plans, and estate planning.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Overview of financial planning
    2. Income budgeting and techniques
    3. Tax advantaged expenditures and investments
    4. Bank services and products
    5. Stocks, Bonds, Annuities, and Mutual Funds
    6. Disability income planning
    7. Life Insurance planning
    8. Retirement planning
    9. Estate planning

    Learning Outcomes
    At the end of the course the student will be able to:

    1. explain the need for financial planning.
    2. plan a budget.
    3. evaluate the advantages and  disadvantages of consumer and student loans.
    4. identify the benefits and limitations of bank accounts.
    5. identify various investment objectives and products.
    6. explain the need for disability planning and potential solutions.
    7. identify life insurance needs and products.
    8. determine retirement planning needs and products.
    9. identify estate planning issues and documents.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BMGT 1020 - Introduction to Business

    Credits: 3
    Hours/Week: Lecture None Lab None
    Course Description: This course is a study of contemporary business concepts in the areas of economics, business formation, management, marketing, accounting, finance and the future scope of business. The emphasis of the course includes learning business terminology and understanding applications of concepts in the business world. The perspective includes business interrelationships within the economic, legal, technological, competitive, social, and global environments.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Trends Affecting Business
    2. Economic Issues Affecting Business
    3. World Economic Systems
    4. Forms of Ownership
    5. Entrepreneuring and Franchising
    6. Small Business Management
    7. Management and Leadership
    8. Organizing a Business
    9. Production and Operations Management
    10. Motivation
    11. Human Resource Management
    12. Marketing Fundamentals
    13. Product Development and Pricing
    14. Distribution
    15. Promotion
    16. Accounting Fundamentals
    17. Financial Management
    18. Stocks and Bonds
    19. Money and Financial Institutions
    20. Risk Management
    21. Legal, Ethical, and Socially Responsible Management
    22. International Business

    Learning Outcomes
    At the end of this course students will be able to:

    1. define basic business terminology.
    2. describe business activities related to business formation, marketing, management and finance.
    3. analyze business opportunities and constraints in the contexts of social, economic, legal, technological, competitive and global environments.
    4. critique business literature.
    5. discuss various specialty areas: accounting, management, marketing, and office technology.
    6. explore career opportunities in business.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BMGT 1790 - Independent Study

    Credits: 1-3
    Hours/Week: Lecture None Lab None
    Course Description: This variable-credit elective course emphasizes the student’s independent search for advanced knowledge as well as additional hands-on skills beyond business management program offerings. The student and instructor will devise a formal plan of study to satisfy credit workload requirements within a one semester timeframe.
    MnTC Goals
    None

    Prerequisite(s): Instructor and dean consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    To be determined by the student and instructor on an individual basis.
    Learning Outcomes
    At the end of this course students will be able to: To be determined on individual basis according to the nature of the independent study.
    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BMGT 2030 - Principles of Management

    Credits: 3
    Hours/Week: Lecture None Lab None
    Course Description: This course is a study of the foundations, principles, and functions of management. The emphasis is on planning, organizing, staffing, leading, and controlling resources in organizations. Managerial strategies and decision models are analyzed, including considerations of demographics, diversity, and globalization.
    MnTC Goals
    None

    Prerequisite(s): None.
    Corequisite(s): None
    Recommendation: BMGT 1020  

    Major Content
    1. Historical and Contemporary Management Theories
    2. Manager as a Decision Maker
    3. Objectives, Strategies, and Policies
    4. Planning: The Fundamental Function
    5. Management Organization Structure and Design
    6. Motivation Concepts
    7. Communication in Organizations
    8. Work Groups and Teams
    9. Managing Conflict and Change
    10. Effective Leadership Behavior
    11. Performance Reviews Strategies and Motivational Rewards
    12. Social Responsibility and Ethics Management
    13. Demographic, Globalization, and Diversity Management Strategies

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe the four functions of management (planning, organizing, leading and controlling) and the type of executive management actives associated with each.
    2. explain the historical and philosophical origins of management.
    3. apply current management theories and practices.
    4. explain the structure and design of organizations, and how managers effectively perform in this type of setting in order to accomplish goals.
    5. describe the types and utility of systems and analyze how they are used to monitor and support achievement of strategic and tactical plans made by management.
    6. apply the principles and practices of decision-making skills to activities and individual in “real-world” managerial environments.
    7. identify the major ethical approaches, apply them to business situations and analyze their impact on management behavior.
    8. analyze the personal traits and skills of effective leaders.
    9. describe motivation in the workplace and apply motivation concepts to suggest improvements in the workplace.
    10. recognize and analyze the nature and role of organizational culture within an organization.
    11. discuss how managers lead the process of organizational change.
    12. analyze the advantages, disadvantages, and best practices of utilizing teams within organizations.
    13. analyze the impact of changing demographics, increasing diversity, and globalization on the management process.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BMGT 2035 - Human Relations in Business

    Credits: 3
    Hours/Week: Lecture None Lab None
    Course Description: This course covers the creation and maintenance of well-managed working relationships in all types of organizations. The course includes a comprehensive discussion of the background and basis for human relations. Three core human relations skills are developed-motivation, leadership and communication. Additional aspects of human behavior in the work environment are explored including team building, the human/technology interface, and managing change.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. The Nature of Human Relations
    2. Fundamentals of Motivation
    3. Individual Behavior
    4. Group Behavior
    5. Informal Organization
    6. Technology and People at Work
    7. Productivity and Quality Improvement
    8. Job Redesign and Enrichment
    9. Leadership
    10. Developing, Appraising and Rewarding Personnel
    11. Communication
    12. Conflict and Change Management

    Learning Outcomes
    At the end of this course students will be able to:

    1. apply human relations skills: motivation, leadership, and communication.
    2. develop human resources that enhance the potential for organizational and individual long-term success.
    3. provide managerial counseling to troubled workers.
    4. resolve work-related conflicts.
    5. manage change to benefit the organization and individuals.
    6. explain the importance of well-managed relationships at all levels of the organization.
    7. analyze individual and group behavior in organizational settings.
    8. design jobs using human and/or technology-intensive processes.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BMGT 2040 - Human Resources Management

    Credits: 3
    Hours/Week: Lecture None Lab None
    Course Description: This course is a study of the importance of human resource management in contributing to the achievement of organizational objectives. Topics include the principle functions performed in human resource management such as planning and recruitment, training and career development, compensation and security, productive work environments, and employee-management relations. Students study leaders who have contributed to the field as well as the various regulations, laws, events, and forces that have an impact upon it.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. The Development and Role of Human Resources Managers
    2. Structure and Program for Managing Human Resources
    3. Personnel Planning and Recruitment
    4. Selecting Personnel
    5. Personnel Testing
    6. Employee Development
    7. Developing Managers
    8. Performance Evaluation and Personnel Actions
    9. Supervising Personnel
    10. Collective Bargaining Agreements
    11. Resolving Labor Relations Problems
    12. Compensation, Incentive, and Benefit Plans
    13. Safety and Health
    14. Appraisal and Research
    15. Global Human Resources Management

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe the responsibilities of a human resource department. for the 21st century.
    2. execute the recruitment, selection, orientation, training, evaluation, and compensation processes.
    3. offer solutions to each of the major human resources challenges for the 21st century.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BMGT 2045 - Leading Innovation and Change

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course focuses on the practices necessary to stimulate and manage innovation in a business. The course introduces methods and tools for developing new ideas and transforming them into marketable projects.  Topics include frameworks and methods for designing, developing, and implementing innovation in real work situations. The aim of the course is to provide students with the perspective and skill base necessary to manage innovation-focused projects, people, and ventures.  The course emphasizes how innovation tools and methods can be successfully employed in real work situations.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Innovation management
    2. Innovation methodologies
    3. Innovation tools and practices
    4. Innovation theories
    5. Fundamentals of change management and its relevance to innovation
    6. Organizational structures and strategies in innovation
    7. Innovation and economic competitiveness
    8. Effective leadership of systemic organizational change
    9. Nature and history of innovation
    10. Balancing innovation execution within organizations
    11. When to abandon ideas in organizations

    Learning Outcomes
    At the end of this course students will be able to:
    1. explain innovation management.
    2. apply creative problem solving and idea generation models.
    3. describe innovation tools and the challenges involved in employing them.
    4. apply current state business challenges through an innovation methodology.
    5. analyze business challenges involving innovation management.
    6. evaluate innovation policies and practices in organizations, especially from an organizational culture and leadership point of view.
    7. explain why innovation is essential to organizational strategy - especially in a global environment.
    8. describe the factors that increase the likelihood of successful transition from innovation to execution.
    9. describe the roles played by organizational design factors in innovation.
    10. explain effective leadership approaches and cultures for fostering innovation.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BMGT 2051 - Legal Environment of Business

    Credits: 3
    Hours/Week: Lecture None Lab None
    Course Description: This course is a study of the principles, rules, and logic of business law and its relation to the social, economic, and moral forces underlying justice in our society. It provides an overview of the legal system including basic laws, contracts, constitutional law, and tort law.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. General overview of the legal system
      1. The nature of law
      2. Common law, Statutory law, Administrative law, and Constitutional Powers and Liberties
    2. Tort Law
      1. The basis of Tort law
      2. Intentional Torts against persons and property and associated criminal consequences
      3. Unintentional Torts (Negligence)
      4. Strict liability theories
      5. Prevention of and defenses for Tort actions
    3. Contract Law
      1. Definition and function of contracts
      2. The nature and classification of contracts
      3. Requirements of a contract
      4. Interpretation of contracts
      5. Contrast of common law and U.C.C. requirements
      6. Contract formation (offer, acceptance, and consideration)
      7. Contractual capacity
      8. Non-compete clauses
      9. Mistake and misrepresentation
      10. The Statute of Frauds
      11. The Parole Evidence Rule
      12. Breach and Remedies
      13. Damages, Injunctions, and Specific Performance
      14. Reformation, Rescission, Restitution, Alternative Dispute Resolution (ADR)

    Learning Outcomes
    At the end of this course students will be able to:
    1. explain the main elements of the American legal system and how it functions within the federal system of government.
    2. describe the rights and limitations found in the Constitution.
    3. discuss the main sources of legal authority, which may include constitutions, treaties, statutes, cases, regulations, and decrees.
    4. recognize and apply legal terminology in an appropriate context.
    5. recognize and apply the fundamentals of legal reasoning.
    6. describe legal situations which impact businesses, which may include criminal law, civil law, contracts, torts, business organizations, intellectual property, employment law, the legal and regulatory environment of business (local, national and global), Uniform Commercial Code, and alternative forms of dispute resolution.
    7. analyze fact patterns to identify legal issues and their impact on associated stakeholders.
    8. analyze legal issues through the application of primary and secondary sources of law.
    9. explain the functions of courts and other non-judicial tribunals in the resolution of disputes.
    10. recognize the philosophies of law and the resolution of ethical dilemmas.
    11. analyze and defend alternative outcomes in legal cases through oral and written communication.
    12. identify and apply the use of legal and business data bases.
    13. recognize the global and culturally diverse context in which business and business law functions.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BMGT 2060 - Business Communications

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course covers the theory and processes of business communications.  It concentrates on building skills business professionals use to successfully communicate in the workplace. Topics include etiquette, interviewing, small and large group meetings, presentations, and business correspondence.  This course examines nonverbal, intercultural, technological and ethical aspects of business communications.  Students will develop search skills for career entry or advancement.
    MnTC Goals
    None

    Prerequisite(s): ENGL 1021 
    Corequisite(s): None
    Recommendation: CAPL 1010  or PowerPoint proficiency.

    Major Content
    1. Business Communication Models and Challenges
    2. Communication with Teams
    3. Listening Effectively
    4. Nonverbal Communication
    5. Oral Presentations
    6. Presentations with Slides and other Visuals
    7. Employment Search Process
    8. Conducting Interviews on the Job
    9. Business Correspondence
    10. Intercultural Communication
    11. Business Etiquette and Business Appearance
    12. Technology to Enhance Business Communications

    Learning Outcomes
    At the end of this course students will be able to:

    1. identify business communication processes and concepts.
    2. explain intercultural, technological, and ethical aspects of communicating with stakeholders.
    3. choose appropriate communication strategies.
    4. describe the ways business professionals communicate nonverbally.
    5. demonstrate effective listening habits.
    6. prepare employment application materials.
    7. plan, write, and complete routine, positive, negative, and persuasive correspondence.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • BMGT 2095 - International Business

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course is a study of the key concepts and issues involved in the conduct of international business. Topics will include an examination of international economics and politics, comparative management styles and methods, international marketing and finance, business transactions in the major trading regions of the world, and ethical and cultural issues involved in international business.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: ECON 1021  

    Major Content
    1. The Goals and Functions of Financial Management
    2. Review of Accounting
    3. Financial Analysis
    4. Financial Forecasting
    5. Operating and Financial Leverage
    6. Current Asset Management
    7. The Capital Budgeting Decision
    8. Capital Markets
    9. Long-Term Debt and Lease Financing
    10. Common and Preferred Stock Financing
    11. Dividend Policy and Retained Earnings
    12. External Growth through Mergers
    13. International Financial Issues

    Learning Outcomes
    At the end of this course students will be able to:

    1. analyze financial statements.
    2. determine present and future values of lump sums and annuities.
    3. complete capital budgets using net present value and internal rate of return methods.
    4. evaluate debt and equity financing methods.
    5. describe capital structures, risk-return relationships and financial markets
    6. complete ratio and trend analysis.
    7. execute financial planning through forecasting and budgeting.
    8. evaluate breakeven and complete operating and financial leverage analyses.
    9. select appropriate sources of financing for short- and long-term purposes.
    10. manage firm’s current and fixed assets.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration


Career Studies

  
  • CRRS 1005 - Career Exploration and Planning

    Credits: 1
    Hours/Week: Lecture None Lab None
    Course Description: This course guides students in the general exploration of appropriate career and educational options. Through assessment of interests, personality, skills, and values, students will examine themselves and explore their personal, career, and educational goals. Restriction: Cannot be taken for credit if credit has been received for CRRS 1010 .
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. The career planning process
    2. Understanding yourself
    3. Understanding the work world
    4. Understanding the world of education and training
    5. Goal-setting process
    6. Decision-making process
    7. Education plan and career plan development

    Learning Outcomes
    At the end of this course, students will be able to:

    1. discuss the career planning process.
    2. identify interests, personality, skills, and values related to career choice.
    3. describe the decision-making process.
    4. describe the goal-setting process.
    5. identify obstacles related to making career decisions.
    6. identify, research, and evaluate occupational options.
    7. identify, research, and evaluate educational options.
    8. develop a plan for reaching educational and career goals.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CRRS 1010 - Career and Life Planning

    Credits: 2
    Hours/Week: Lecture None Lab None
    Course Description: This course guides students through the lifelong career exploration and decision-making process, using various career planning strategies and resources. It includes an examination of individual strengths, personality types, interests, values, and skills. Student will explore the world of work, examine educational options, and establish specific goals. The course presents processes for determining what gives meaning to students’ lives and integrating the work role with other life roles.
    Restriction: Cannot be taken for credit if credit has been received for CRRS 1005 .
    MnTC Goals
    None

    Prerequisite(s): Course placement into ENGL 0950  and RDNG 0950  or above OR completion of RDNG 0940  with a grade of C or higher OR course placement into ESOL 0051  and ESOL 0052  and ESOL 1033  OR completion of ESOL 0041  with a grade of C or higher and ESOL 0042  with a grade of C or higher and ESOL 0043  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Introduction Career development theory Career decision-making as a process Decision-making styles and obstacles
    2. Life Roles Integrating work, family, and leisure Social influences toward career choice
    3. Putting It All Together Goal-setting Educational/career planning Job search, resume writing, and interviewing skills
    4. Self-awareness and career choice Identify interests, skills, values and how they relate to the work world Personal growth and change Communication skills for work and life
    5. World of Work Classifying work environments Gathering occupational information Career resources

    Learning Outcomes
    At the end of this course students will be able to:

    1. discuss fundamental career development concepts
    2. discuss the lifelong career decision-making process.
    3. identify interests, personality types, skills, and values that affect career choice.
    4. identify cultural and social influences that affect career choice.
    5. discuss integration of work roles with other life roles.
    6. demonstrate effective job search skills
    7. formulate an education plan
    8. formulate career goals and plan.
    9. use a variety of career resources including the GPS LifePlan.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration


Center for Manufacturing and Applied Engineering

  
  • CMAE 1514 - Safety Awareness

    Credits: 2
    Hours/Week: Lecture 2 Lab None
    Course Description: This course is designed to align with the National Skill Standard assessment and certification system for Safety Awareness. The course curriculum is based upon federally-endorsed national standards for production workers. This course will introduce OSHA standards relating to personal protective equipment, Hazard Communication, tool safety, confined spaces, electrical safety, emergency responses, lockout/tagout, and others.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Workplace characteristics: impact on economy; systems of safety; role of production workers; external and internal customers.
    2. Safety assessments: identification of potential hazards; processes related to reporting potential hazards; safety documentation and policies; relevant laws and regulations in regards to inspections; inspection schedules, procedures, documentation and record storage.
    3. Emergency drills: training and certifications; responding to fire and electrical emergencies; relationship between emergency response compliance and regulatory policies; documentation process for drills and incidents.
    4. Identification of unsafe conditions: conditions that present a threat; documentation and corrective actions related to threats; consultation with appropriate parties; taking corrective actions; tracking and reporting.
    5. Safety training: orientation characteristics; processes for employees to raise safety concerns; personal protective equipment; documentation processes for orientations; alignment with laws, policies, and regulations.
    6. Safe use of equipment: ergonomic safety; communication regarding safety and material handling; use of evaluations to improve training materials; effective techniques for safe use of equipment.
    7. Processes to support safety: consultation with health and safety representatives; creating safer, more effective work environment; safety, quality and productivity issues.
    8. Maintenance, installation and repair safety requirements: communication; job safety analyses; hazardous materials procedures and policies; documentation such as Material Safety Data Sheets and right-to-know policies.
    9. Safe equipment and operator performance: process of regular monitoring; reporting of unsafe conditions or circumstances; Equipment and tool checks to ensure compliance; importance of inclusion of data in OSHA recordables.
    10. Safety-enhancing workplace practices: role of clear communication; effective teamwork; proper production job assignments, efficient training program for enhancing workplace practices.

    Learning Outcomes
    At the end of this course students will be able to:

    1. explain characteristics of working in a safe and productive manufacturing workplace.
    2. describe process for performing safety and environmental assessments.
    3. identify procedures related to performing emergency drills and participating on emergency teams.
    4. identify potential unsafe conditions and corrective actions.
    5. discuss safety training for manufacturing employees.
    6. explain proper safe use of equipment.
    7. describe processes and procedures that support safety in a work environment.
    8. summarize safety and health requirements for maintenance, installation, and repair.
    9. identify aspects of safe equipment and operator performance.
    10. recognize effective, safety-enhancing workplace practices.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CMAE 1518 - Manufacturing Processes and Production

    Credits: 2
    Hours/Week: Lecture 2 Lab None
    Course Description: This course covers Just-In-Time (JIT) manufacturing principles, basic supply chain management, communication skills, and customer service. The course curriculum is based upon federally-endorsed national standards for production workers. It is designed to align with the National Manufacturing Skill Standards Council’s (MSSC) assessment and certification system for Manufacturing Processes.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Customer needs: internal customers; product aspects and printed specifications; review of customer needs; communication of needs to others including shift-to-shift, co-workers, and managers; proactively meeting customer needs.
    2. Resources: checking raw materials and tools and equipment against work orders; communication of production discrepancies; placement of resources at the workstation; scheduling workers.
    3. Set-up of equipment: adjustment to equipment prior to service; set-up meeting process requirements; production specifications; documentation of set-up procedures; ergonomic, health, safety, and environmental standards
    4. Production goals: specific, measurable and achievable goals; alignment with customer and business needs; relationship between goals and team objectives; communication of team goals
    5. Job assignments: matching skills to assignments; maximization of available skills; relationship between job assignments and customer needs; effective notification of workers regarding job assignments
    6. Work flow: meeting production schedules; notification regarding schedule requirements; efficient production work flow; minimizing downtime; active participation in problem-solving groups
    7. Communication: reflects knowledge of production requirements, levels, and product specification, delivery issues, schedules; demonstration knowledge of customer needs; initiation of communication that is cross-functional, timely, accurate; relevance to production and products; tracking communications
    8. Processes: process control data needed; manufacturing process cycle time; ensure product meets specifications; labeling of products; compliance with health, safety, environmental policies and practices
    9. Documentation and compliance process: compliance documentation; obtaining ‘sign off’; process for labeling products for compliance and non-compliance
    10. Shipping product: procedure to ensure packaging materials meet shipping specification, labeling, safety requirements; documentation for packaging and shipping; communication of product availability; checking of packaging instructions against work order; storage and staging procedure for shipping; laws and regulations regarding labeling, packaging, transporting product; material handling procedures to prevent product damage

    Learning Outcomes
    At the end of this course students will be able to:

    1. explain aspects of identifying customer needs.
    2. discuss how to determine resources available for the production process.
    3. identify set-up and verification of equipment for the production process.
    4. describe the process of setting team production goals.
    5. explain job assignments.
    6. identify work flow with team members and other work groups.
    7. discuss communication of production, material requirements, and product specifications.
    8. explain how to perform, monitor, and document the process to make the product.
    9. identify documentation and compliance process in regards to customer requirements.
    10. explain the process of preparing the final product for shipping or distribution.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CMAE 1522 - Quality Practices

    Credits: 2
    Hours/Week: Lecture None Lab None
    Course Description: This course is designed to align with the National Skills Standards Council’s assessment and certification system for Quality Practices. The course curriculum is based upon federally-endorsed national standards for production workers. Emphasis is placed on continuous improvement concepts and how they relate to a quality management system. Students will be introduced to a quality management system and its components. These include corrective actions, preventative actions, control of documents, control of quality records, internal auditing of processes, and control of non-conforming product.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Audit activities: characteristics of audit data; audit forms workflow; assessment and documentation of quality standards; audit process and procedures
    2. Data collection: calibration schedule; instrument certification; step for recalibration of instruments
    3. Continuous improvement: role of observation, data review, and analysis; measurable and data-driven benefits; soliciting and receiving suggestions
    4. Inspection: scheduling considerations for sampling and inspection; selection of inspection tools and procedures; materials specifications; identification of products that don’t meet specifications; spot-checks; creation and reporting of inspection documentation
    5. Documentation: completion and accuracy; evaluating and interpreting information; sharing data; analytical tools including statistical process controls; storage and time frames for reports
    6. Communication: review of problems with production operators; communication of quality problems with appropriate parties; documentation and reporting
    7. Correction actions: identification and communication; recommendations for action; timeliness of adjustments; documentation of adjustments and quality checks; implementation of quality improvements in standardized manner
    8. Record outcomes: appropriate standards in maintaining records; charting of outcomes; analyze data for accuracy, reporting procedures for quality performance data; comparison of previous issues and current situations
    9. Blueprint reading: create visualization of objects; identify blueprint features; comprehend dimensions in a drawing; functions of sectional drawings
    10. Measurement systems: convert between US and metric systems; machinist’s rule and tape measure usage; caliper and micrometer measurements; digital gauge measurements.

    Learning Outcomes
    At the end of this course students will be able to:

    1. explain periodic or statistically based internal quality audit activities.
    2. describe checking and documentation of calibration of gages and other data collection equipment
    3. explain continuous improvement.
    4. discuss inspection of materials and product/process at all stages to ensure they meet specifications.
    5. describe documentation of results of quality tests.
    6. explain communication regarding quality problems.
    7. identify corrective actions to restore or maintain quality
    8. explain how to properly record process outcomes and trends.
    9. identify fundamentals of blueprint reading
    10. use common measurement systems and precision measurement tools.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CMAE 1526 - Maintenance Awareness

    Credits: 2
    Hours/Week: Lecture 2 Lab None
    Course Description: This course is designed to align with the National Skills Standard assessment and certification system for Maintenance Awareness. The course curriculum is based upon federally-endorsed national standards for production workers. The Maintenance Awareness course introduces the concepts of Total Productive Maintenance and preventative maintenance. Students are introduced to lubrication, electricity, hydraulics, pneumatics, and power transmission systems.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Preventative maintenance: preparation and scheduling; documentation; communication of procedures, forms, and follow-up
    2. Routine repair: necessary supplies; repair and preventative maintenance schedules, needs, supplies; safety procedures for doing repairs
    3. Monitoring indicators: comparison of current performance to optimal operations; investigation and correction of equipment conditions; monitoring of equipment; documentation steps
    4. Housekeeping: storage of tools and materials; recognition of unsafe conditions; correction action steps; clean workstation aspects; housekeeping inspections; organization of workstations
    5. Maintenance issues: electrical, pneumatic, hydraulic, machine automation systems; lubrication processes, bearings, and couplings, belts and chain drives; high vacuum and laser systems; components of Total Productive Maintenance
    6. Documentation: up-to-date documentation; processes for ensuring repair history is complete and accurate

    Learning Outcomes
    At the end of this course students will be able to:

    1. explain performance of preventative maintenance.
    2. describe the concepts of routine repair.
    3. discuss monitoring indicators to ensure correct operations.
    4. describe performance of housekeeping to maintain production schedule.
    5. recognize potential maintenance issues with basic production systems.
    6. recognize the importance of documentation within a maintenance system.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration


Chemistry

  
  • CHEM 1020 - Chemistry Concepts

    Credits: 4
    Hours/Week: Lecture 3 Lab 2
    Course Description: This course deals with the basic concepts of chemistry. Topics include general properties of matter, the development of the model of the atom, nuclear chemistry, basics of chemical bonding, chemical equations and their uses, acids and bases, oxidation-reduction, and an introduction to organic chemistry. The laboratory portion of the course introduces students to basic equipment and procedures used in the science laboratory and provides an opportunity to observe some of the concepts discussed in the classroom. This course is intended for students who have not had a high-school chemistry course within the last three years.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): Placement into MATH 0070  or above, or completion of MATH 0030  or MATH 0060  with a grade of C or higher. Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Matter & Energy
    2. Chemical Bonding
    3. Chemical Equations
    4. Measurements
    5. Names and Formulas
    6. Organic Chemistry
    7. Reactions of Protons and Electrons
    8. States of Matter
    9. The Atom

    Learning Outcomes
    At the end of this course students will be able to:

    1. Demonstrate understanding of basic chemical vocabulary, concepts, laws, and theories
    2. Solve basic chemistry problems using resource materials.
    3. Communicate basic chemical ideas clearly.
    4. Use basic laboratory equipment properly.
    5. Investigate matter and its interactions using the scientific method.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 02. Formulate and test hypotheses by performing laboratory, simulation, or field experiments in at least two of the natural science disciplines. One of these experimental components should develop, in greater depth, students’ laboratory experience in the collection of data, its statistical and graphical analysis, and an appreciation of its sources of error and uncertainty. 03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.
    03. 04. Evaluate societal issues from a natural science perspective, ask questions about the evidence presented, and make informed judgments about science-related topics and policies.


    Courses and Registration

  
  • CHEM 1041 - Principles of Chemistry I

    Credits: 5
    Hours/Week: Lecture 5 Lab 3
    Course Description: This is the first course in a two-course introduction to chemistry. Students will investigate the basic concepts of chemistry, including atomic theory and structure, chemical nomenclature, chemical equations and stoichiometry, electron configuration and periodicity, chemical bonding, molecular structure, enthalpy changes associated with chemical reactions, the behavior of gases, and an introduction to organic chemistry. Quantitative laboratory experiments emphasize observation, organization of data, and analysis of data. This course is intended for students who need a course in general chemistry to fulfill a requirement for a variety of majors such as: chemistry, medicine, biology, nursing, dentistry, physical therapy and liberal arts.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): Course placement into MATH 1061  or above, or completion of MATH 0070  with a grade of C or higher. Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Matter and Measurement
    2. Atomic Structure
    3. Chemical Bonding and Molecular Structure
    4. Chemical Equations and Stoichiometry
    5. Electron Configuration and Periodicity
    6. Gases
    7. Thermochemistry
    8. Inorganic Nomenclature
    9. Introduction to Organic Chemistry
    10. Reactions in Aqueous Solution

    Learning Outcomes
    At the end of this course students will be able to:

    1. determine the number of significant digits in a number, and round measured and calculated results to the appropriate number of significant digits.
    2. apply dimensional analysis with proper attention to units and significant figures.
    3. describe and apply the scientific method.
    4. name or provide formulas for molecular and ionic compounds, including those with polyatomic ions.
    5. describe electrons, protons, and neutrons, and the general structure of the atom.
    6. define isotope and determine the atomic number, mass number, and number of neutrons for a specified isotope.
    7. identify the atomic number and atomic mass for any element, given a periodic table.
    8. calculate the average atomic mass of an element from isotopic abundances and masses.
    9. correlate wavelength, frequency, and energy of light with electron energy level transitions in an atom using the Bohr model.
    10. apply the wave-particle duality and the uncertainty principle to describe properties of electrons.
    11. apply the results of the Schrödinger model of the atom to assign quantum numbers to electrons and write electron configurations of multi-electron atoms and ions.
    12. identify valence and core electrons, and predict trends in atomic size, ionization energy, electron affinity, and charges on main-group ions.
    13. use Avogadro’s number to calculate the number of particles.
    14. balance chemical equations and perform stoichiometry calculations, including limiting reagent and percent yield calculations.
    15. determine the empirical formula of an unknown compound from percent mass data.
    16. use molarity in calculations involving solutions, including dilution and titration calculations.
    17. identify insoluble ionic compounds, strong and weak acids and bases, and oxidizing and reducing agents in precipitation, acid-base neutralization, and oxidation-reduction reactions.
    18. write molecular, total, and net ionic equations for precipitation and acid-base reactions.
    19. explain and write a formula for the First Law of Thermodynamics.
    20. determine the amount of heat associated with reacting a specified mass of reactant for a reaction with a given enthalpy change.
    21. use heat capacity or specific heat to relate the amount of heat associated with a temperature change for a substance.
    22. use Hess’s Law or enthalpies of formation to determine the enthalpy change for a reaction.
    23. describe bonding in pure covalent, polar covalent, and ionic compounds.
    24. draw Lewis structures for compounds including resonance, formal charge, and exceptions to the octet rule.
    25. use VSEPR theory and Valence Bond Theory to predict molecular shape, polarity, and bonding.
    26. explain the postulates of the kinetic molecular theory of gases.
    27. use the ideal gas law and the combined gas law in calculations.
    28. apply Dalton’s Law to determine the mole fraction, partial pressures, and total pressure of a gas mixture.
    29. use chemicals and basic laboratory equipment safely and with proper technique.
    30. record observations and analyze the results of experiments.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 02. Formulate and test hypotheses by performing laboratory, simulation, or field experiments in at least two of the natural science disciplines. One of these experimental components should develop, in greater depth, students’ laboratory experience in the collection of data, its statistical and graphical analysis, and an appreciation of its sources of error and uncertainty. 03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.


    Courses and Registration

  
  • CHEM 1042 - Principles of Chemistry II

    Credits: 5
    Hours/Week: Lecture 5 Lab 3
    Course Description: This course is a continuation of CHEM 1041 . Students will investigate intermolecular forces, solid state structure, properties of solutions, chemical kinetics, chemical equilibria, acids and bases, electrochemistry, chemical thermodynamics, and nuclear chemistry.  The laboratory work emphasizes observation, organization of data, analysis of data, and experimental design.  This course is intended for students who need a second course in general chemistry to fulfill a requirement for a variety of majors such as:  chemistry, medicine, biology, nursing, dentistry, physical therapy and liberal arts.
    MnTC Goals
    3 Natural Science

    Prerequisite(s): CHEM 1041  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Intermolecular forces
    2. Solid state structure
    3. Acids, bases, and their equilibria
    4. Solubility equilibria
    5. Chemical equilibria
    6. Chemical kinetics
    7. Chemical thermodynamics
    8. Electrochemistry
    9. Properties of solutions
    10. Nuclear chemistry

    Learning Outcomes
    At the end of this course students will be able to:

    1. identify the dominant intermolecular force present in a molecular compound.
    2. make qualitative predictions (rankings) concerning the physical properties of various liquids based on their intermolecular forces.
    3. describe the molecular interactions that differentiate solids, liquids, and gases.
    4. describe and calculate the energies of phase changes and interpret phase diagrams.
    5. describe the energetics of solution formation.
    6. calculate and convert between the solution concentrations of percent, molarity, molality, and mole fraction.
    7. describe the colligative properties of solutions and perform calculations regarding them.
    8. determine the rate law of a reaction using the method of initial rates.
    9. apply the integrated rate law and half-life equations for zero-order, first-order, and second-order reactions.
    10. describe how temperature, activation energy, and molecular orientation influence reaction rates.
    11. determine the rate law from a reaction mechanism.
    12. describe how a catalyst influences the rate of a reaction.
    13. write equilibrium constant expressions for chemical equations and find equilibrium
    14. concentrations from initial concentrations and the equilibrium constant.
    15. determine the effect of concentration change, volume change, temperature change, and addition of a catalyst on equilibrium using Le Chatelier’s Principle.
    16. define and identify acids and bases using the Arrhenius, Brønsted-Lowry, and Lewis definitions.
    17. analyze equilibria of acids and bases using acid/base dissociation constants.
    18. calculate pH of acids, bases, and buffers solutions and construct acid/base titration curves.
    19. calculate the solubility product constant from solubility data.
    20. determine the solubility of a substance in water and in the presence of a common ion using the solubility product constant.
    21. describe the factors the affect solubility, including a common ion, pH, and complex ion formation.
    22. determine oxidation numbers and balance redox reactions in acidic or basic solutions.
    23. calculate standard potentials for electrochemical cells and relate to standard free energy, potentials under nonstandard conditions, and the equilibrium constant.
    24. calculate enthalpy change, entropy change, and free energy change for phase transitions and chemical reactions, using appropriate standard values from thermodynamic tables.
    25. relate the change in thermodynamic quantities such as describe how enthalpy, entropy, and free energy influence the spontaneity of a reaction.
    26. predict the sign of the change in entropy for reactions and phase transitions based on qualitative reasoning.
    27. relate thermodynamic quantities to the value of the equilibrium constant for a reaction.
    28. write balanced nuclear equations.
    29. identify types of nuclear reactions, including radioactive decay, fission, and fusion.
    30. analyze first-order decay of radionuclides.
    31. use chemicals and basic laboratory equipment safely and with proper technique.
    32. effectively communicate lab procedures, observations, and results both orally and in writing.
    33. interpret and analyze qualitative observations and quantitative results from the laboratory.

    Competency 1 (1-6)
    03. 01. Demonstrate understanding of scientific theories.
    03. 02. Formulate and test hypotheses by performing laboratory, simulation, or field experiments in at least two of the natural science disciplines. One of these experimental components should develop, in greater depth, students’ laboratory experience in the collection of data, its statistical and graphical analysis, and an appreciation of its sources of error and uncertainty. 03. 03. Communicate their experimental findings, analyses, and interpretations both orally and in writing.
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CHEM 1790 - Independent Study

    Credits: 1-3
    Hours/Week: Lecture None Lab None
    Course Description: This variable-credit elective course emphasizes the student’s independent search for advanced knowledge as well as additional lab and/or class work in an area of chemistry outside that covered in the regularly scheduled courses. The student and instructor will devise a formal plan of study to satisfy credit workload requirements within a one-semester (or summer session) timeline.
    MnTC Goals
    None

    Prerequisite(s): CHEM 1041  with a grade of C or higher and instructor and dean consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Defining a chemical question or problem
    2. Outlining an approach to studying the question
    3. Implementing their research or inquiry
    4. Assessing and revising effectiveness of the approach
    5. Evaluating results of their studies
    6. Presenting results in written, oral, or poster format.

    Learning Outcomes
    At the end of this course students will be able to:

    1. demonstrate advanced knowledge of the subject area identified in the learning plan.
    2. explain results of the independent study in oral, written, and/or poster format
    3. reflect on personal and intellectual growth in the subject area identified in the plan.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CHEM 2041 - Organic Chemistry I

    Credits: 5
    Hours/Week: Lecture None Lab None
    Course Description: This course is an introduction to organic chemistry. Topics include a review of covalent bonding, acid-base chemistry, reaction energetics, and an introduction to organic functional groups, stereochemistry, and substitution reactions. The laboratory work provides an introduction to laboratory techniques used in organic chemistry synthesis, and the use of chromatography and spectroscopy in the analysis of organic compounds.
    MnTC Goals
    None

    Prerequisite(s): CHEM 1042  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content

    1. Structure of Organic Molecules
    2. Acid Base Properties of Organic Molecules
    3. Structural Representation and Interpretation
    4. Reaction Representation and Interpretation
    5. Nomenclature
    6. Isomerism
    7. Reactions of Organic Molecules

     
    Learning Outcomes
    At the end of this course students will be able to:

    1. predict properties and reactivity of organic molecules using concepts of molecular structure, formal charge, and resonance
    2. translate between compound names and representations of structure
    3. analyze the relative energies of molecular structures
    4. create and employ 3-dimensional structures to determine the constitutional and stereochemical isomeric relationships between molecules
    5. identify various functional groups within complex molecules, correlate physical properties with functional group structure, and predict relevant reactions each functional group will undergo
    6. predict the products of acid-base, substitution, elimination, and addition reactions through the application of thermodynamic and kinetic principles
    7. create logical synthetic strategies by combining reactions into practical multi-step sequences
    8. propose reaction mechanisms using the curved-arrow formalism
    9. employ data from IR and NMR spectroscopy to identify organic compounds, and develop an understanding of how each of these analytical techniques work
    10. determine the identity of organic samples through physical and spectroscopic methods
    11. determine the qualitative and quantitative purity of organic samples through physical and spectroscopic methods

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CHEM 2042 - Organic Chemistry II

    Credits: 5
    Hours/Week: Lecture None Lab None
    Course Description: This course is a continuation of CHEM 2041 . Topics include the study of the properties and reaction of carbonyl compounds, alkenes, aromatic compounds, and free radicals. Applications of organic chemistry, including polymers, natural products, and photochemistry, will be introduced and discussed. The laboratory work will include examples of these reactions and the chemical and instrumental identification of organic compounds.
    MnTC Goals
    None

    Prerequisite(s): CHEM 2041  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Functional groups, nomenclature and preparation
    2. Structure and reactivity
    3. Organometallic compounds
    4. Conjugated carbonyls
    5. Aromatic compounds
    6. Reaction representation and interpretation
    7. Introduction to macromolecules
    8. Reactions of organic molecules
    9. Reaction considerations
    10. Spectroscopy: theory, interpretation, and elucidation

    Learning Outcomes
    At the end of this course students will be able to:

    1. evaluate  the advantages and limitations of the various forms of chromatography
    2. employ the various forms of spectroscopy, evaluate the information each provides, and assess the limitations of each
    3. predict properties and reactivity of organic molecules using concepts of molecular structure, formal charge, and resonance
    4. translate between compound names and representations of structure
    5. create and employ 3-dimensional structures to determine the constitutional and stereochemical isomeric relationships between molecules
    6. identify various functional groups within complex molecules, correlate physical properties with functional group structure, and predict relevant reactions each functional group will undergo
    7. predict the products of oxidation, reduction, aromatic substitution, nucleophilic acyl addition, nucleophilic acyl substitution, and alpha carbon (enol and enolate) reactions through the application of thermodynamic and kinetic principles
    8. create logical synthetic strategies by combining reactions into practical multi-step sequences
    9. propose reaction mechanisms using the curved-arrow formalism
    10. employ data from NMR, IR, and UV-VIS spectroscopy and mass spectrometry to identify compounds and demonstrate an understanding of how each of these analytical techniques work
    11. identify structures and functions of macromolecules

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration


Chinese

  
  • CHIN 1011 - Beginning Chinese I

    Credits: 5
    Hours/Week: Lecture 5 Lab None
    Course Description: This course is an introduction to Mandarin Chinese language and culture. Fundamental grammar, correct oral-expression, aural comprehension, and reading are stressed. Weekly listening and laboratory work are required. An introduction to Chinese culture is also included. NOTE: Students who have completed any Chinese language course should contact the instructor.
    MnTC Goals
    6 Humanities/Fine Arts, 8 Global Perspective

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Chinese phonetic system

    1. Initials
    2. Finals
    3. Tone marks
    4. Pinyin rules

    2. Chinese Characters

    1. The Chinese writing system
    2. Strokes of Chinese characters
    3. Chinese radicals

    3. Grammar

    1. Order of the sentences
    2. Question sentences format
    3. Adverb position
    4. Adjectives position
    5. Preposition phrase
    6. Tense

    4. Topics

    1. Greetings: Introduce self and people
    2. Talking about family
    3. Date and time
    4. Hobbies
    5. Visit friend
    6. Making appointments

    5. Chinese Culture

    1. The origin of Chinese Language
    2. The evolution of Chinese Characters/Scheme for the Chinese Phonetic Alphabet
    3. How to use Chinese App
    4. Personal Names
    5. Forms of Address for family and relatives
    6. Chinese Zodiac
    7. Chinese music
    8. Chinese Tea Culture
    9. Chinese festival

    Learning Outcomes
    At the end of this course students will be able to:

    1. Demonstrate speaking and listening skills in paired and group activities.
    2. Demonstrate written ability in the form of short essays, letters, and journal entries.
    3. Demonstrate rudimentary reading skills by read real life related Chinese cultural pieces.
    4. Discuss cultural aspects of contemporary Chinese community in the United States and Canada.

    Competency 1 (1-6)
    06. 01. Demonstrate awareness of the scope and variety of works in the arts and humanities.
    06. 02. Understand those works as expressions of individual and human values within an historical and social context.
    06. 04. Engage in the creative process or interpretive performance.
    Competency 2 (7-10)
    08. 02. Demonstrate knowledge of cultural, social, religious and linguistic differences.
    08. 03. Analyze specific international problems, illustrating the cultural, economic, and political differences that affect their solution.
    08. 04. Understand the role of a world citizen and the responsibility world citizens share for their common global future.


    Courses and Registration

  
  • CHIN 1012 - Beginning Chinese II

    Credits: 5
    Hours/Week: Lecture 5 Lab None
    Course Description: This course is the second course in a beginning sequence and a continuation of CHIN 1011 . Continued development of all four language skills (speaking, listening comprehension, writing and reading) is stressed. Weekly listening and laboratory work are required. A further exploration of Chinese culture is included.
    MnTC Goals
    6 Humanities/Fine Arts, 8 Global Perspective

    Prerequisite(s): CHIN 1011  
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Chinese Characters:

    1. Chinese Language and Writing System
    2. Chinese radicals

    2. Grammar:

    1. Sentences with Particle le
    2. Descriptive Complements
    3. Modal Verbs
    4. Double Objects
    5. The de structure
    6. Series of Verbs/Verb Phrases
    7. Measure words
    8. Topic comment sentences
    9. Adverbs
    10. Prepositional Phrases
    11. Comparative Sentences with bi
    12. Resultative Complements
    13. Reduplication of Adjectives

    3. Topics:

    1. Studying Chinese
    2. School life
    3. Shopping
    4. Transportation
    5. Talking about the weather
    6. Dinning

    4. Chinese Culture:

    1. Chinese calligraphy
    2. Chinese Festival
    3. Chinese phone etiquette
    4. Chinese letter format
    5. Capital of China: Beijing
    6. Special features of Chinese universities
    7. Chinese cuisine
    8. Chinese geography
    9. Ethnic groups in China

    Learning Outcomes
    At the end of this course students will be able to:

    1. demonstrate elementary reading and writing skills in Mandarin Chinese
    2.  understand and use essential grammatical structures
    3. develop the skills necessary to comprehend the general meaning of basic oral and written texts in Chinese
    4. broaden their understanding of and appreciation for Chinese culture

    Competency 1 (1-6)
    06. 01. Demonstrate awareness of the scope and variety of works in the arts and humanities.
    06. 02. Understand those works as expressions of individual and human values within an historical and social context.
    06. 04. Engage in the creative process or interpretive performance.
    Competency 2 (7-10)
    08. 02. Demonstrate knowledge of cultural, social, religious and linguistic differences.
    08. 03. Analyze specific international problems, illustrating the cultural, economic, and political differences that affect their solution.
    08. 04. Understand the role of a world citizen and the responsibility world citizens share for their common global future.


    Courses and Registration


Communication

  
  • COMM 1021 - Fundamentals of Public Speaking

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course focuses on learning techniques for effective public speaking in academic, business, professional, and community settings. Students practice these skills by preparing and presenting informative and persuasive oral presentations in class. Course topics include audience analysis, ethics, speech purpose, organization, delivery, visual aids, outlining, and speaker evaluation.
    MnTC Goals
    1 Communication, 9 Ethical/Civic Responsibility

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Ethical public speaking
    2. Communication Models
    3. Communication apprehension
    4. Delivery techniques
    5. Gathering materials
    6. Methods of Persuasion
    7. Outlining
    8. Speech organization
    9. Speech purpose and audience
    10. Types of informative speeches
    11. Types of persuasive speeches
    12. Visual aids

    Learning Outcomes
    At the end of this course students will be able to:

    1. demonstrate appropriate topic selection, audience analysis, organization, and content development in a speaker-audience setting.
    2. utilize appropriate research strategies to discover and ethically integrate supporting materials from diverse sources and points of view.
    3. demonstrate the ability to listen, analyze, and provide feedback on public discourse
    4. use audio/visual aids in their speeches
    5. create and perform informative and persuasive messages.
    6. demonstrate improved strategies to decrease communication apprehension, particularly public speaking apprehension.
    7. practice effective verbal and nonverbal delivery techniques that are well suited to the occasion and audience.

    Competency 1 (1-6)
    01. 01. Understand/demonstrate the writing and speaking processes through invention, organization, drafting, revision, editing and presentation.
    01. 02. Participate effectively in groups with emphasis on listening, critical and reflective thinking, and responding.
    01. 03. Locate, evaluate, and synthesize in a responsible manner material from diverse sources and points of view.
    01. 04. Select appropriate communication choices for specific audiences.
    01. 05. Construct logical and coherent arguments.
    01. 06. Use authority, point-of-view, and individual voice and style in their writing and speaking.
    01. 07. Employ syntax and usage appropriate to academic disciplines and the professional world.
    Competency 2 (7-10)
    09. 03. Analyze and reflect on the ethical dimensions of legal, social, and scientific issues.
    09. 04. Recognize the diversity of political motivations and interests of others.
    09. 05. Identify ways to exercise the rights and responsibilities of citizenship.


    Courses and Registration

  
  • COMM 1031 - Interpersonal Communication

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course focuses on basic communication theories and concepts, and the practice of interpersonal communication skills. Topics include the self and others as communicators, verbal and nonverbal messages, listening, conflict management, self-disclosure, and the dynamics of human relationships. The course content applies to everyday communication situations at home and on the job.
    MnTC Goals
    1 Communication, 7 Human Diversity

    Prerequisite(s): Course placement into ENGL 0950  and RDNG 0950  or above OR completion of RDNG 0940  with a grade of C or higher OR course placement into ESOL 0051  and ESOL 0052  and ESOL 1033  OR completion of ESOL 0041  with a grade of C or higher and ESOL 0042  with a grade of C or higher and ESOL 0043  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: Eligible for college-level Reading and English.

    Major Content
    1. Basic concepts in the communication process
    2. Conflict and conflict management
    3. Diversity issues
    4. Emotional messages
    5. Listening
    6. Nonverbal messages
    7. Online communication
    8. Perception
    9. Relationship development
    10. Self Disclosure
    11. Self-concept/Self-esteem
    12. Verbal messages (language)

    Learning Outcomes
    At the end of this course students will be able to:

    1. identify basic theories and concepts in the processes of interpersonal communication.
    2. analyze the role of verbal and nonverbal communication in various interpersonal episodes and diverse contexts.
    3. identify skill sets in managing active listening, perception, disclosure, and conflict.
    4. articulate the role of interpersonal processes in the development and maintenance of relationships.
    5. identify barriers that impede effective interpersonal communication.
    6. engage in reflection of one’s own interpersonal communication strengths and weaknesses.

    Competency 1 (1-6)
    01. 02. Participate effectively in groups with emphasis on listening, critical and reflective thinking, and responding.
    01. 04. Select appropriate communication choices for specific audiences.
    01. 06. Use authority, point-of-view, and individual voice and style in their writing and speaking.
    01. 07. Employ syntax and usage appropriate to academic disciplines and the professional world.
    Competency 2 (7-10)
    07. 01. Understand the development of and the changing meanings of group identities in the United States’ history and culture.
    07. 03. Analyze their own attitudes, behaviors, concepts and beliefs regarding diversity, racism, and bigotry.
    07. 05. Demonstrate communication skills necessary for living and working effectively in a society with great population diversity.


    Courses and Registration

  
  • COMM 1041 - Small Group Communication

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course focuses on communication in small groups. Topics include small group communication theory and effective interpersonal skills; group leadership, cohesion, and emergence roles; conflict management; problem-solving and decision-making; planning and conducting meetings; and parliamentary procedure. The course content applies to everyday situations in the community and workplace, with emphasis on practical application and practice of oral skills. Some group meetings and activities outside scheduled class hours are required.
    MnTC Goals
    1 Communication, 9 Ethical/Civic Responsibility

    Prerequisite(s): Course placement into ENGL 0950  and RDNG 0950  or above OR completion of RDNG 0940  with a grade of C or higher OR course placement into ESOL 0051  and ESOL 0052  and ESOL 1033  OR completion of ESOL 0041  with a grade of C or higher and ESOL 0042  with a grade of C or higher and ESOL 0043  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: Eligible for college-level Reading and English.

    Major Content
    1. Group formation and development
    2. Communication skills in groups
    3. Conducting meetings, including procedures, agendas, minutes, and parliamentary procedure
    4. Conflict and cohesion
    5. Decision-making and problem solving
    6. Group presentations
    7. Groups in the community and workplace
    8. Leadership

    Learning Outcomes
    At the end of this course students will be able to:

    1. explain small group communication processes.
    2. develop skill sets in applying principles and practices of small group communication.
    3. manage the interpersonal dynamics of small group communication.
    4. demonstrate principles of leadership in the group process.
    5. develop skill sets in group problem-solving and decision-making to achieve desired goals.
    6. apply ethical issues and responsibilities of groups and their members to community and workplace.
    7. critically analyze small group communication.

    Competency 1 (1-6)
    01. 01. Understand/demonstrate the writing and speaking processes through invention, organization, drafting, revision, editing and presentation.
    01. 02. Participate effectively in groups with emphasis on listening, critical and reflective thinking, and responding.
    01. 03. Locate, evaluate, and synthesize in a responsible manner material from diverse sources and points of view.
    01. 04. Select appropriate communication choices for specific audiences.
    01. 05. Construct logical and coherent arguments.
    01. 07. Employ syntax and usage appropriate to academic disciplines and the professional world.
    Competency 2 (7-10)
    09. 01. Examine, articulate, and apply their own ethical views.
    09. 02. Understand and apply core concepts (e.g. politics, rights and obligations, justice, liberty) to specific issues.
    09. 03. Analyze and reflect on the ethical dimensions of legal, social, and scientific issues.
    09. 05. Identify ways to exercise the rights and responsibilities of citizenship.


    Courses and Registration

  
  • COMM 1051 - Intercultural Communication

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: Study cultural differences and how they affect communication and cause misunderstanding. Are people really different from one another or are they basically alike? Topics include the role of culture in human behavior; references to a wide range of specific cultural groups; cultural aspects of domestic and international business; issues in refugee/immigrant resettlement and adaptation; and intercultural relationships. Materials/activities include reading, films, class discussions, group events, personal interviews.
    MnTC Goals
    1 Communication, 8 Global Perspective

    Prerequisite(s): Course placement into ENGL 0950  and RDNG 0950  or above OR completion of RDNG 0940  with a grade of C or higher OR course placement into ESOL 0051  and ESOL 0052  and ESOL 1033  OR completion of ESOL 0041  with a grade of C or higher and ESOL 0042  with a grade of C or higher and ESOL 0043  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: Eligible for college-level Reading and English.

    Major Content
    1. Definitions: communication, intercultural communication, culture
    2. Concepts: connection between culture and communication, dimensions of difference, cultural generalizations
    3. Crossing cultural boundaries: culture shock; images; the experience of tourists, expatriates, and refuges/immigrants.
    4. Culture-general theory: models, cultural-variability scales.
    5. Culture-specific analysis: description, differences, and comparisons.
    6. Culture-specific interactions
    7. Doing business across cultures: local, national, global levels.
    8. Intercultural relationships.

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe how cultural identity shapes, and is shaped by, communication.
    2. compare/contrast patterns of thought, value, belief and behavior (verbal and nonverbal) exhibited in different cultures.
    3. define the role of perception and bias in intercultural communication interactions.
    4. articulate the skills needed to manage various intercultural communication contexts
    5. communicate with those of cultural groups other than their own.
    6. assess on one’s own personal intercultural communication competency.
    7. explain the need for intercultural communication competency in our global and ever-changing world.

    Competency 1 (1-6)
    01. 02. Participate effectively in groups with emphasis on listening, critical and reflective thinking, and responding.
    01. 03. Locate, evaluate, and synthesize in a responsible manner material from diverse sources and points of view.
    01. 04. Select appropriate communication choices for specific audiences.
    01. 07. Employ syntax and usage appropriate to academic disciplines and the professional world.
    Competency 2 (7-10)
    08. 02. Demonstrate knowledge of cultural, social, religious and linguistic differences.
    08. 03. Analyze specific international problems, illustrating the cultural, economic, and political differences that affect their solution.
    08. 04. Understand the role of a world citizen and the responsibility world citizens share for their common global future.


    Courses and Registration

  
  • COMM 1053 - Communication, Travel and Tourism

    Credits: 1
    Hours/Week: Lecture 1 Lab None
    Course Description: This course is an introduction to being a cross-culturally effective traveler: intercultural communication applied to international travel. Topics include world tourism, its positive and negative effects on individuals and countries; tourism as an instrument of national development; appropriate everyday tourist behaviors; and survival skills for any trip abroad. For all students, especially those going overseas on business, for pleasure, or to study. Offered S, F.
    MnTC Goals
    1 Communication, 8 Global Perspective

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Introduction to international travel
    2. Advertising in the tourism industry
    3. Cross-cultural effects of international travel
    4. Guest know thyself: Culture-general skills
    5. Guest, know everything else: Survival skills for international travel
    6. Guest, know thy host: Culture-specific knowledge
    7. Host and guests: Tourism in perspective
    8. Intercultural communication applied to international travel
    9. The impact of tourism on developing countries
    10. The role of tourism as an instrument of national development

    Learning Outcomes
    At the end of this course students will be able to:

    1. Explain effective communication behaviors in an international context.
    2. Compare and contrast the behaviors, values, and beliefs of specific world cultural groups.
    3. Analyze tourism as a major global industry and the social and economic impact of that industry on developing countries.
    4. Organize an international itinerary through research using a range of print and electronic sources.
    5. Evaluate skills necessary for successful and rewarding international study and travel.

    Competency 1 (1-6)
    01. 02. Participate effectively in groups with emphasis on listening, critical and reflective thinking, and responding.
    01. 03. Locate, evaluate, and synthesize in a responsible manner material from diverse sources and points of view.
    01. 04. Select appropriate communication choices for specific audiences.
    01. 07. Employ syntax and usage appropriate to academic disciplines and the professional world.
    Competency 2 (7-10)
    08. 02. Demonstrate knowledge of cultural, social, religious and linguistic differences.
    08. 03. Analyze specific international problems, illustrating the cultural, economic, and political differences that affect their solution.
    08. 04. Understand the role of a world citizen and the responsibility world citizens share for their common global future.


    Courses and Registration

  
  • COMM 1061 - Introduction to Mass Communication

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course focuses on the historical, cultural, economic, and political impact of mass communication on individual media consumers and on American and global cultures. Topics may include corporate control, the role of government, freedom of expression, values and ethics, journalism, advertising, public relations, and media effects. Specific media industries, including radio, television, movies, newspapers, books, magazines, and the internet, will be examined.
    MnTC Goals
    5 History/Social/Behavioral Science, 9 Ethical/Civic Responsibility

    Prerequisite(s): Course placement into ENGL 0950  and RDNG 0950  or above OR completion of RDNG 0940  with a grade of C or higher OR course placement into ESOL 0051  and ESOL 0052  and ESOL 1033  OR completion of ESOL 0041  with a grade of C or higher and ESOL 0042  with a grade of C or higher and ESOL 0043  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: Eligible for college-level Reading and English.

    Major Content
    1. Concepts and definitions of Mass Communication
    2. First Amendment Issues
    3. Electronic and Digital Media Industries
      1. Radio (including internet radio)
      2. Television (including satellite and digital television)
      3. Movies
      4. Music and sound recordings (including digital distribution systems)
      5. Internet and the World Wide Web
      6. Convergence between analog and digital media
      7. Other (e.g. Video Games, Emerging techonologies and media)
    4. Media Economics
    5. Media Effects Theories
    6. Media Regulation and Controls
    7. Print Media Industries
      1. Books
      2. Newspapers
      3. Magazines

    Learning Outcomes
    At the end of this course students will be able to:

    1. Identify basic concepts of mass communication/mass media relative to the historical, cultural, economic, and political issues surrounding these concepts
    2. Analyze competing interests underlying mass media content, administration, and regulation.
    3. Evaluate the impact of media industries on media consumers and on American and global cultures.

    Competency 1 (1-6)
    05. 01. Employ the methods and data that historians and social and behavioral scientists use to investigate the human condition.
    05. 02. Examine social institutions and processes across a range of historical periods and cultures.
    05. 03. Use and critique alternative explanatory systems or theories.
    05. 04. Develop and communicate alternative explanations or solutions for contemporary social issues.
    Competency 2 (7-10)
    09. 01. Examine, articulate, and apply their own ethical views.
    09. 02. Understand and apply core concepts (e.g. politics, rights and obligations, justice, liberty) to specific issues.
    09. 03. Analyze and reflect on the ethical dimensions of legal, social, and scientific issues.


    Courses and Registration

  
  • COMM 2011 - Interviewing

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course focuses on developing a working knowledge of the interview process and the communication skills necessary to effectively interview. Students will develop and conduct several types of interviews, which may include oral history, journalistic, research, persuasive, and employment interviews. Students communication skills, including effective listening, appropriate responding, nonverbal communication, perception, and empathy, will be examined, practiced, and evaluated.
    MnTC Goals
    1 Communication, 9 Ethical/Civic Responsibility

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: ENGL 1020  with a grade of C or higher OR ENGL 1021  with a grade of C or higher  or concurrently enrolled.

    Major Content
    1. Communication models and principles
    2. Communication skills: Effective listening Appropriate responding Nonverbal communication issues Role of perception Role of empathy
    3. Culture and gender issues
    4. Electronic interviews
    5. Ethical and legal considerations in interviewing
    6. Interview questions and other techniques
    7. Interview structure and process
    8. Qualitative/quantitative research
    9. Relational dimensions
    10. Types of interviews: Oral History/Narrative Journalistic Research/Survey Persuasive Employment Specialized: health care, counseling, interrogation

    Learning Outcomes
    At the end of this course students will be able to:

    1. Identify the interview structure and process.
    2. Conduct various types of interviews.
    3. Use appropriate communication skills.
    4. Evaluate their own and others’ interviews.
    5. Prepare effective interview questions.

    Competency 1 (1-6)
    01. 01. Understand/demonstrate the writing and speaking processes through invention, organization, drafting, revision, editing and presentation.
    01. 02. Participate effectively in groups with emphasis on listening, critical and reflective thinking, and responding.
    01. 03. Locate, evaluate, and synthesize in a responsible manner material from diverse sources and points of view.
    01. 04. Select appropriate communication choices for specific audiences.
    01. 05. Construct logical and coherent arguments.
    01. 07. Employ syntax and usage appropriate to academic disciplines and the professional world.
    Competency 2 (7-10)
    09. 01. Examine, articulate, and apply their own ethical views.
    09. 02. Understand and apply core concepts (e.g. politics, rights and obligations, justice, liberty) to specific issues.
    09. 03. Analyze and reflect on the ethical dimensions of legal, social, and scientific issues.


    Courses and Registration

  
  • COMM 2033 - Nonverbal Communication

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: Effective communication requires an understanding of nonverbal messages. Students will study a variety of nonverbal communicators, including gestures, facial expression, appearance, vocal cues, space, and time. This course is intended to help students understand and analyze their own and others’ nonverbal communication in interpersonal, intercultural, and workplace relationships.
    MnTC Goals
    1 Communication, 7 Human Diversity

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: ENGL 1020  with a grade of C or higher OR ENGL 1021  with a grade of C or higher  or concurrently enrolled.

    Major Content
    1. Definitions and functions of nonverbal communication
    2. Methods for improving nonverbal skills
    3. Nonverbal Communicators: Environment Territory/Space Time Appearance Gestures Touch Facial Expression Eye Behaviors Vocal Cues
    4. Nonverbal behaviors in communication contexts: Interpersonal/Gender Intercultural Workplace
    5. Nonverbal communication theories
    6. Role of nonverbal communication in the communication process

    Learning Outcomes
    At the end of this course students will be able to:

    1. Identify types of nonverbal communicators and their effects on the communication process.
    2. Analyze their own and others’ nonverbal communication behaviors
    3. Compare and contrast nonverbal behaviors in a variety of communication contexts.

    Competency 1 (1-6)
    01. 02. Participate effectively in groups with emphasis on listening, critical and reflective thinking, and responding. 01. 03. Locate, evaluate, and synthesize in a responsible manner material from diverse sources and points of view. 01. 04. Select appropriate communication choices for specific audiences. 01. 07. Employ syntax and usage appropriate to academic disciplines and the professional world.
    Competency 2 (7-10)
    07. 01. Understand the development of and the changing meanings of group identities in the United States’ history and culture.
    07. 02. Demonstrate an awareness of the individual and institutional dynamics of unequal power relations between groups in contemporary society.
    07. 03. Analyze their own attitudes, behaviors, concepts and beliefs regarding diversity, racism, and bigotry.
    07. 05. Demonstrate communication skills necessary for living and working effectively in a society with great population diversity.


    Courses and Registration

  
  • COMM 2051 - Minnesota’s New Immigrants: Communication, Culture and Conflict

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: Minnesota’s recent immigrant/refugee population is markedly different from that of the rest of the U.S., with proportionately significant numbers of Hmong, Somalis, Liberians, and Tibetans among others. In this course we study some of the more visible groups and the regions they come from: Southeast Asia, Horn of Africa, West Africa, Latin America, former Soviet Union/Eastern Europe. Why did they leave their homeland? What culture and communication did they bring with them? What communication adjustment and cultural conflicts do they experience? What are some important issues for their lives in Minnesota as they communicate with the larger society? Materials/activities include readings, films, discussions, interviews, and guest speakers/on-site visits when possible.
    MnTC Goals
    5 History/Social/Behavioral Science, 7 Human Diversity

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: ENGL 1020  with a grade of C or higher OR ENGL 1021  with a grade of C or higher  or concurrently enrolled.

    Major Content
    1. Introduction to course
      1. Trends in international migration
      2. Immigrant vs. refugee/asylee status.
      3. Crisis and response: The U.S. reaction to current conditions.
    2. Patterns of Minnesota immigration.
      1. Changing populations since 1990.
      2. Important demographic characteristics.
      3. Issue facing Twin Cities and outstate immigration/refugee groups.
      4. Implications for public policy.
    3. Southeast Asia/Hmong.
      1. Introduction to topic: Historical background.
      2. Class discussion: Communication, culture clash, and adaptation.
    4. Horn or Africa/Somali.
      1. Introduction to topic: Historical background.
      2. Class discussion: Communication, culture clash, and adaptation.
    5. West Africa/Liberian.
      1. Introduction to topic: Historical background.
      2. Class discussion: Communication, culture clash, and adaptation.
    6. Latin America/Mexican
      1. Introduction to topic: Historical background.
      2. Class discussion: Communication, culture clash, and adaptation.
    7. Former Soviet Union, Eastern Europe/Russian, Bosnian.
      1. Introduction to topic: Historical background.
      2. Class discussion: Communication, culture clash, and adaptation.

    Learning Outcomes
    At the end of this course students will be able to:

    1. Describe basic cultural and communication features of the target groups and geographic areas.
    2. Recount conditions in these areas which forced or motivated people to come to the U.S. and Minnesota.
    3. Analyze major issues of the immigrant/refugee experience with reference to communication and culture.
    4. Describe key communication dynamics within a given immigrant/refugee community (intra-), and between that community and the larger host culture (inter-).
    5. Analyze how intercultural communication concepts (e.g. U-curve hypothesis) can contribute to immigrant/refugee adaptation and adjustment.
    6. Explain how the immigrant experience is communicated and interpreted in contemporary films.
    7. Display some measure of change in intercultural attitude and/or behavior through either self-report or pretest/posttest instrument.

    Competency 1 (1-6)
    05. 01. Employ the methods and data that historians and social and behavioral scientists use to investigate the human condition.
    05. 02. Examine social institutions and processes across a range of historical periods and cultures.
    05. 04. Develop and communicate alternative explanations or solutions for contemporary social issues.
    Competency 2 (7-10)
    07. 01. Understand the development of and the changing meanings of group identities in the United States’ history and culture.
    07. 03. Analyze their own attitudes, behaviors, concepts and beliefs regarding diversity, racism, and bigotry.
    07. 04. Describe and discuss the experience and contributions (political, social, economic, etc.) of the many groups that shape American society and culture, in particular those groups that have suffered discrimination and exclusion.
    07. 05. Demonstrate communication skills necessary for living and working effectively in a society with great population diversity.


    Courses and Registration

  
  • COMM 2071 - Communication and Gender

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course studies how communication and culture create, maintain, and influence perceptions of gender. Patterns of womens and mens communication, why these patterns differ, and how communication differences are perceived will be emphasized. Various communication contexts covered in this course will include the family, friendship, romantic relationships, education, the workplace, and the media.
    MnTC Goals
    1 Communication, 7 Human Diversity

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: ENGL 1020  with a grade of C or higher OR ENGL 1021  with a grade of C or higher  or concurrently enrolled.

    Major Content
    1. Definitions: feminism, gender, culture and communication
    2. Gender communication in education, organizations and the media
    3. Gender development through communication and culture
    4. Nonverbal differences in womens and men¿s communication
    5. Power, violence, and activism as forms of gender communication
    6. Relational differences: family, friendship, and romance
    7. Rhetorical aspects of gender
    8. The process of communication
    9. Verbal differences in womens and men’s communication

    Learning Outcomes
    At the end of this course students will be able to:

    1. Analyze how communication and culture create, maintain, and influence perceptions of gender.
    2. Explore different patterns in womens and mens communication, why these patterns differ, and how these differences are perceived in various contexts.
    3. Identify ways students communication patterns reinforce and/or change cultural expectations of gender.
    4. Communicate more effectively and constructively with others whose ways of communicating are different from their own.

    Competency 1 (1-6)
    01. 02. Participate effectively in groups with emphasis on listening, critical and reflective thinking, and responding.
    01. 03. Locate, evaluate, and synthesize in a responsible manner material from diverse sources and points of view.
    01. 04. Select appropriate communication choices for specific audiences.
    01. 06. Use authority, point-of-view, and individual voice and style in their writing and speaking.
    01. 07. Employ syntax and usage appropriate to academic disciplines and the professional world.
    Competency 2 (7-10)
    07. 01. Understand the development of and the changing meanings of group identities in the United States’ history and culture.
    07. 02. Demonstrate an awareness of the individual and institutional dynamics of unequal power relations between groups in contemporary society.
    07. 03. Analyze their own attitudes, behaviors, concepts and beliefs regarding diversity, racism, and bigotry.
    07. 04. Describe and discuss the experience and contributions (political, social, economic, etc.) of the many groups that shape American society and culture, in particular those groups that have suffered discrimination and exclusion.
    07. 05. Demonstrate communication skills necessary for living and working effectively in a society with great population diversity.


    Courses and Registration

  
  • COMM 2081 - Health Communication

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course explores the vital relationship between health and communication. Topics include the study of personal, cultural, and political contexts in examining the theories of health communication to improve health literacy throughout a lifetime of change. This course applies to health communication situations at home and on the job.
    MnTC Goals
    1 Communication, 7 Human Diversity

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: ENGL 1020  with a grade of C or higher OR ENGL 1021  with a grade of C or higher  or concurrently enrolled.

    Major Content
    1. An introduction to health communication
      1. Overview of communication theory
      2. Development of health communication as a field of study
      3. The history of health communication
    2. Roles & Interpersonal contexts in health communication
      1. Patient/client perspectives
      2. Caregiver/provider/health professional perspectives
      3. The patient/client and caregiver/provider/professional interpersonal relationship
      4. Conflict management
    3. Societal & Intercultural contexts in health communication
      1. Social support & emotional labor
      2. Advocacy
      3. Cultural conceptions of health and illness
    4. Organizational & Technological influences on health communication
      1. Leadership & teamwork
      2. Media influences on health communication
      3. Governmental influences on health communication

    Learning Outcomes
    At the end of this course students will be able to:

    1. apply the major communication concepts and theories to the study of health communication.
    2. analyze their own and others communication behaviors in a variety of health contexts.
    3. demonstrate effective communication skills for engaging in a health care context within a diverse society.
    4. explain how health communication theories apply to media, governmental, and socio-political contexts.
    5. write and speak clearly, effectively and professionally about health communication issues, concepts, and theories.

    Competency 1 (1-6)
    01. 01. Understand/demonstrate the writing and speaking processes through invention, organization, drafting, revision, editing and presentation.
    01. 02. Participate effectively in groups with emphasis on listening, critical and reflective thinking, and responding.
    01. 03. Locate, evaluate, and synthesize in a responsible manner material from diverse sources and points of view.
    01. 04. Select appropriate communication choices for specific audiences.
    01. 07. Employ syntax and usage appropriate to academic disciplines and the professional world.
    Competency 2 (7-10)
    07. 02. Demonstrate an awareness of the individual and institutional dynamics of unequal power relations between groups in contemporary society.
    07. 03. Analyze their own attitudes, behaviors, concepts and beliefs regarding diversity, racism, and bigotry.
    07. 05. Demonstrate communication skills necessary for living and working effectively in a society with great population diversity.


    Courses and Registration

  
  • COMM 2099 - Communication Certificate Capstone

    Credits: 1
    Hours/Week: Lecture 1 Lab None
    Course Description: This course will give students an opportunity to review communication courses successfully completed in the certificate program. Students will reflect on how these courses have enhanced their current level of knowledge and skills and demonstrate how they have achieved the Communication Student Competencies defined in the Minnesota Transfer Curriculum. In addition, students will work with the course instructor to explore future career and academic goals as related to the Communication Certificate.
    MnTC Goals
    None

    Prerequisite(s): Instructor consent
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Review employment resources
    2. Overview of eFolio requirements
    3. Synthesis and reflection of Communication courses
    4. Common degree options for further Communication study
    5. Review code of ethics common to discipline and profession
    6. eFolio
      1. Development
        1. Design elements
        2. Content components
      2. Effective use

    Learning Outcomes
    At the end of this course students will be able to:

    1. demonstrate ability to work independently.
    2. evaluate their development in the Communication Certificate program.
    3. synthesize information from their Communication courses for personal, professional, or academic purposes.
    4. evaluate employment and degree opportunities available to them.
    5. use effective written, presentational, and technological skills to demonstrate proficiency of MnTC communication competencies: Demonstrate the writing and speaking processes through invention, organization, drafting, revision, editing, and presentation. Participate effectively in groups with emphasis on listening, critical and reflective thinking, and responding. Locate material from diverse sources and points of view, evaluate, and synthesize in a responsible manner. Select appropriate communication choices for specific audiences. Construct logical and coherent arguments.
    6. Use authority, point-of-view, and individual voice and style in their writing and speaking. Employ syntax and usage appropriate to academic disciplines and the professional world.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • COMM 2780 - Communication Internship

    Credits: 1-3
    Hours/Week: Lecture None Lab None
    Course Description: This course provides students with the opportunity to apply knowledge and skills learned in their Communication courses. Students will work in a professional environment while applying a variety of communication concepts, theories, and/or skills. May be repeated with faculty consent for up to 6 credits total.
    MnTC Goals
    None

    Prerequisite(s): Completion of COMM 1021  or COMM 2011  with a grade of C or higher. Completion of a second COMM course, not listed above, with a grade of C or higher. Consent of instructor.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Ethical and legal considerations
    2. Expectations of student
    3. Expectations of Internship site
    4. Expectations of faculty/college
    5. Communication course concepts, theories, and/or skills at internship site
    6. Importance of professional resources/connections
    7. Strengths and areas needing improvement
    8. Value of evaluation: self and other’s

    Learning Outcomes
    At the end of this course students will be able to:

    1. apply Communication course skills, concepts, and/or theories to professional settings.
    2. demonstrate networking skills.
    3. describe the demands of specific communication-related positions.
    4. develop effective workplace skills.
    5. evaluate whether this work setting/position is suitable to personal/professional goals.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • COMM 2790 - Special Topics

    Credits: 1-3
    Hours/Week: Lecture None Lab None
    Course Description: This course covers topics of special interest in Communication which may vary.
    MnTC Goals
    None

    Prerequisite(s): Course placement into college-level English and Reading OR completion of ENGL 0950  with a grade of C or higher OR completion of RDNG 0940  with a grade of C or higher and qualifying English Placement Exam OR completion of RDNG 0950  with a grade of C or higher and ENGL 0090  with a grade of C or higher OR completion of ESOL 0051  with a grade of C or higher and ESOL 0052  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: ENGL 1020  with a grade of C or higher OR ENGL 1021  with a grade of C or higher  or concurrently enrolled.

    Major Content
    To be determined based on the topic and by the instructor.
    Learning Outcomes
    At the end of this course students will be able to: To be determined based on the topic and by the instructor.
    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration


Computer Application Technology

  
  • CAPL 1010 - Introduction to Software Applications

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This introductory course is an overview of the following Microsoft Office programs: Microsoft Word-a word processing program; Microsoft Excel-an electronic spreadsheet; Microsoft Access-a database program; and Microsoft PowerPoint-a presentation graphics program. Students reinforce their skills by completing assignments that integrate the applications. This course emphasizes hands-on computer applications. This course requires basic computer competency (use of keyboard, mouse, and Windows).
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: OFFT 1001

    Major Content
    1. Word
    2. Integration of Word and Excel
    3. Integration of Word, Excel, and Access
    4. Integration of Word, Excel, Access, and PowerPoint
    5. PowerPoint
    6. Access
    7. Excel
    8. Access
    9. PowerPoint
    10. Integration of Word and Excel
    11. Integration of Word, Excel, and Access
    12. Integration of Word, Excel, Access, and PowerPoint

    Learning Outcomes
    At the end of this course students will be able to:

    1. create/save/retrieve/edit/print documents.
    2. use spelling/thesaurus/grammar features.
    3. apply font features.
    4. utilize existing templates.
    5. create lists with bullets and numbers
    6. apply borders and shading
    7. create tables
    8. set and modify document margins and layout.
    9. insert page breaks/page numbers/headers/footers
    10. copy/move/find/replace text.
    11. insert and modify Pictures and WordArt
    12. open/save/preview/print worksheet with Excel
    13. create and edit worksheets
    14. format a worksheet
    15. use functions and formulas
    16. work with charts¿plan, create, edit, enhance & print
    17. integrate Word & Excel
    18. create a database
    19. create & modify forms.
    20. create & modify reports
    21. integrate Word, Excel, and Access.
    22. create & modify a presentation
    23. enhance an existing presentation
    24. integrate Word, Excel, Access & PowerPoint
    25. enter & edit data in tables.
    26. modify, sort, filter & query tables.
    27. integrate Word, Excel, and Access.
    28. create & modify a presentation.
    29. enhance an existing presentation.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CAPL 1021 - Microsoft PowerPoint

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course covers the creation, integration, and customization of professional-looking slide presentations. Skills presented include using design templates and auto layouts, working within different PowerPoint views, enhancing presentations using pictures and other graphical elements such as textboxes, SmartArt, shapes, and WordArt. Other topics covered are applying custom animations and animation schemes, modifying visual elements and presentation formats, running a slide show with hyperlinks and action buttons, creating a self-running presentation, customizing a template and using masters, developing a presentation with content from outside sources including tables and charts, and organizing slides and creating a photo album. This course requires keyboarding skills (30 wpm or higher).
    MnTC Goals
    None

    Prerequisite(s): OFFT 1001  or instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Collaborating on and Delivering a Presentation
    2. Creating a Self-Running Presentation Containing Animation
    3. Creating and Editing a Presentation with Pictures
    4. Customizing a Presentation with Customized Slide, Handout, and Notes Masters
    5. Developing a Presentation with Content from Outside Sources
    6. Enhancing a Presentation with Pictures, Shapes, and WordArt
    7. Modifying a Presentation with Customized Text Boxes, SmartArt, and Shapes
    8. Navigating Presentations Using Hyperlinks and Action Buttons
    9. Organizing Slides and Creating a Photo Album
    10. Reusing a Presentation and Adding Media and Animation
    11. Working with Information Graphics

    Learning Outcomes
    At the end of this course students will be able to:

    1. modify a presentation.
    2. customize a presentation.
    3. create a presentation from a template and from an existing presentation.
    4. develop a presentation with content from outside sources.
    5. deliver presentations.
    6. add textual information.
    7. organize slides and create a Photo Album.
    8. prepare a presentation for distribution.
    9. add visual elements.
    10. add data from other sources.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CAPL 1022 - Microsoft Outlook

    Credits: 1
    Hours/Week: Lecture None Lab None
    Course Description: This course uses Microsoft Outlook as an information management tool for business and personal use. This software includes a calendar feature, task and contact management, note taking, a journal, web browsing, and e-mail.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Contacts
    2. Calendar
    3. Signatures
    4. Tasks

    Learning Outcomes
    At the end of this course students will be able to:

    1. manage appointments.
    2. manage tasks.
    3. create notes.
    4. use the journal.
    5. compile an e-mail address book.
    6. create and send a message.
    7. manage e-mail folders.
    8. create a signature.
    9. receive and reply to a message.
    10. forward a message.
    11. send messages with an attachment.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CAPL 1023 - Microsoft Word

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course uses a comprehensive word processing program to create and edit professional-looking business documents. Students create letters, memos, announcements, resumes, fax cover sheets, mailing labels, mail-merge documents, and other types of business documents. This course requires basic computer competency (use of keyboard, mouse, and Windows).
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: OFFT 1001

    Major Content
    1. Word document
    2. Mail-merge documents
    3. Mailing labels, envelopes, directories
    4. Newsletters
    5. Online forms
    6. Tables of Contents, Indexes
    7. Tables and charts
    8. Columns
    9. Macros
    10. Styles and templates
    11. Watermarks
    12. Sort lists, paragraphs, tables
    13. Check for issues (Accessibility, Compatibility, and Inspect Document)

    Learning Outcomes
    At the end of this course students will be able to:

    1. Create, save, print, retrieve, and edit documents.
    2. Create an online form
    3. Create styles and templates
    4. Create a document with table, charts, and watermarks
    5. Create a professional newsletter.
    6. Check for issues (accessibility checker, compatibility checker, document inspector.
    7. Demonstrate use of Word commands
    8. Generate form letters, mailing labels, envelopes, and directories using variable data
    9. Create and modify table of contents, indexes, and use bookmarks

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CAPL 1025 - Microsoft Excel

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course covers spreadsheet software that enables the student to organize data, work with formulas, charts and graphics, work with reports, and develop a professional worksheet. Other topics include: Excel lists, use of multiple worksheets/workbooks, Pivot Table and Pivot Charts. The students will apply critical thinking and problem-solving skills to real-life spreadsheet projects.
    MnTC Goals
    None

    Prerequisite(s): CAPL 1010  or instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Workbooks/Worksheets
    2. Functions: AVERAGE, MIN, and MAX functions
    3. Charts
    4. Financial functionsPMT, PV, IPMT
    5. Logical functions IF, TODAY, WORKDAY
    6. AutoFilters and Custom AutoFilters
    7. Data form
    8. Excel Lists including subtotals, AVG, MAX, MIN, Grand Total
    9. Hyperlinks
    10. Look-up tables VLOOKUP, HLOOKUP
    11. Multiple workbooks¿linked
    12. Pivot Charts
    13. Pivot tables
    14. Query wizard
    15. Range names
    16. Summary Page
    17. Text file

    Learning Outcomes
    At the end of this course students will be able to:

    1. create simple spreadsheets.
    2. format data using fonts, sizes, borders and backgrounds.
    3. create a header and footer.
    4. create column and 2-D and 3-D pie charts; resize and move embedded charts.
    5. modify the properties of the chart.
    6. format chart; insert drawing objects.
    7. sort, filter data and insert subtotals in a list.
    8. use a data form to enter, search for, edit, and delete records.
    9. summarize a list using a PivotTable and a PivotChart.
    10. format and edit worksheets.
    11. modify the worksheet.
    12. use charting features.
    13. use functions, macros, and a customized toolbar.
    14. Insert text, values, and formulas.
    15. Insert, delete, resize, and freeze worksheet rows and columns.
    16. Insert, move, rename, spell check, and print worksheets.
    17. copy and paste formulas and functions.
    18. work with absolute and relative references.
    19. use logical and date functions.
    20. create and apply styles and AutoFormat to a table.
    21. audit, trace, and fix formulas.
    22. consolidate information from multiple worksheets and workbooks.
    23. create a lookup table.
    24. create a workbook template.
    25. create validation rules.
    26. merge workbooks.
    27. create, assign, edit, and print macros.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CAPL 1027 - Microsoft Access

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course covers the newest version of database software that allows the student to create and build databases, define table structures, maintain and query databases, create and use forms and reports, enhance databases using advanced tools, integrate, analyze, and automate tasks, and secure a database. The students will apply critical thinking and problem-solving skills to real-life database projects.
    MnTC Goals
    None

    Prerequisite(s): CAPL 1010  or instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Database concepts and terminology
    2. Building a relational database
    3. Database and table modifications
    4. Query a database
    5. View/organize/locate information
    6. Calculated controls
    7. Calculations in a Query
    8. Cross tab query
    9. Find duplicates and unmatched queries
    10. Indexes
    11. Integrate information from other applications
    12. Join tables
    13. Look-up field in table
    14. Multi-table Query
    15. Mailing labels
    16. Action queries
    17. Advanced table relationships
    18. Automating tasks with macros
    19. Create custom forms and reports
    20. Create form and reports
    21. Sharing, integrating, and analyzing data

    Learning Outcomes
    At the end of this course students will be able to:

    1. Create and modify databases, forms, and reports
    2. Define table relationships
    3. Filter data in a table and form
    4. Plan and design custom forms and report
    5. Create simple and complex queries
    6. Enhance table design
    7. Automate tasks with macros
    8. Secure a database

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CAPL 2020 - Desktop Publishing

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: In this course, students use advanced features and design concepts to create a portfolio of a variety of business and personal publications. Document examples include conference signs, cover sheets, fax sheets, agendas, memos, letterheads, envelopes, business cards, calendars, address labels, personal stationery, and certificates. This course emphasizes hands-on computer skills in real-world situations. This course requires basic computer competency (use of keyboard, mouse, and Windows).
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: OFFT 1001

    Major Content
    1. Desktop publishing process
    2. Basic elements of a newsletter
    3. Brochures and booklets
    4. Internal documents
    5. Letterheads, envelopes, and business cards
    6. Newsletter design elements
    7. Personal documents (calendars, CD case covers, personal stationery/envelopes)
    8. Promotional documents
    9. Specialty promotional documents (tickets, certificates, etc.)

    Learning Outcomes
    At the end of this course students will be able to:

    1. Demonstrate competence at desktop publishing using Microsoft Publisher and Microsoft Word software
    2. Demonstrate basic knowledge of layout, typography, and graphics.
    3. Create letter-fold and single-fold brochures, specialty promotional documents, such as tickets, postcards, business greetings cards, names tags, invitations, and newsletters using a variety of page layouts and design techniques.
    4. Apply the concepts and techniques of publishing learned in this course to personal computer projects
    5. Evaluate design elements in a desktop published document for the appropriate use of focus, balance, proportion, contrast, directional flow, consistency, color and page layout.
    6. Build a portfolio of documents and design elements.
    7. Create calendars, CD covers, personal address labels, and award certificates using a variety of graphic features.
    8. Create business letterheads, envelopes, and business cards using a variety of templates, fonts, and ruled lines.
    9. Use word processing software and publishing software to save text.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration


Computer Science

  
  • CSCI 1000 - Computational Thinking and Problem Solving

    Credits: 4
    Hours/Week: Lecture 4
    Course Description: Computational thinking is an emerging skill in the 21st century. This course helps students develop that skill. The course introduces the basic mathematical principles underlying computational thinking. Course topics include data representation, communication, and processing and how they affect computation. Course activities engage students in analyzing a problem, developing an effective algorithm, and then collaboratively applying appropriate techniques and resources to devise a solution in light of societal, economic, and ethical issues.
    MnTC Goals
    None

    Prerequisite(s): Course placement into MATH 0070  or higher, or completion of MATH 0030  with a grade of C or higher
    Corequisite(s): None
    Recommendation: Basic ability to operate a computer and use the Internet.

    Major Content
    1. Computational design and development methods
    2. Collaborative methods in software design and development
    3. Data representation, storage, and use
      1. Numeric
      2. Graphics
      3. Sound
    4. Algorithms and programming
      1. Develop and implement algorithms
      2. Develop programs that incorporate abstractions
      3. Evaluate and test algorithms
    5. Networks and computing systems
      1. Cloud
      2. Mobile
      3. Local
    6. Collaborative and ethical computing culture
    7. Impact of computing
      1. social
      2. ethical
      3. privacy
      4. automation and digitization

    Learning Outcomes
    At the end of this course students will be able to:
    1. select the appropriate development approach for a given problem.
    2. work collaboratively in developing a computational solution.
    3. choose the appropriate data type to represent a particular information source.
    4. describe how data is stored, transformed, and used.
    5. apply the appropriate computational and mathematical algorithms to a given problem.
    6. implement algorithms using basic programming constructs and mathematical formulas.
    7. analyze algorithms for mathematical complexity in time and space.
    8. compare different data communication technologies.
    9. describe different computational systems (e.g., cloud, mobile, local) and technologies (e.g. AI, data science, quantum computing).
    10. describe the best personal and societal practices for dealing with critical privacy, security, and ethical issues.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 1011 - Introduction to Game Programming

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: What goes into creating a computer game? This course, for students with no programming background, explores fundamental game elements such as sprites, basic animation, collision detection, event-response mechanisms, and sound. Students will use game development software to create complete games of varying complexity. By using programming scripts the games’ complexity will be limited only by the students’ imagination and ingenuity.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: Basic computer competency (use of keyboard, mouse, Windows).

    Major Content
    1. History of computer games
    2. Skill set of a computer game developer
    3. Basic building blocks of a computer game
      a. Objects
      b. Sprites
      c. Events
      d. Sounds
      e. Scripts
      f. Rooms/levels
    4. Building a simple game
      1. Introduction to game development software
      2. Sprite creation
      3. Object creation
        1. Object attributes
        2. Object actions and interactions
      4. The “game loop”
      5. Event programming
      6. User interactions
      7. Generating randomly occurring events
    5. Game categories
      1. Building a maze game
      2. Building an action game
      3. Building a multi-player game
        1. Cooperative multi-player
        2. Competitive multi-player
    6. Intermediate-level programming topics
      1. Using inheritance to simplify object creation
      2. Using a controller object
      3. Creating scripts to extend the capabilities of the game development system
        1. Creating functions
        2. Using variables, decisions and loops
        3. Incorporating scripts into the game
        4. Debugging scripts 
    – Plus one of the following at the discretion of the instructor –
    1. Introduction to other game development environments
      1. Introduction to other game development environments
        1. Comparison of popular game development programming languages
          1. C/C++
          2. Java
          3. C#
          4. Blitz Basic
          5. Dark Basic
        2. Game engines
          1. What a game engine is
          2. Comparison of popular game engines in use
    –OR–
     
    1. The future of computer games
      1. Game immersion and where it is headed
      2. Games as teaching/learning tools
      3. Games as simulators
      4. Games as healing tools
      5. Social impact of games
        1. Do violent games foster aggressiveness?
        2. Are games addictive?

    Learning Outcomes
    At the end of this course students will be able to:

    1. Extend the complexity of a games logic through the use of scripts
    2. Explain why scripting is necessary to extend a game development systems capabilities
    3. Employ inheritance to simplify the creation of related game objects
    4. Identify the key programming elements used in the development of a computer game
    5. Construct games that include multiple rooms and levels
    6. Create multi-player games
    7. Create complete examples of arcade-style games using a game development utility

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 1020 - Introduction to Personal Computers and Information Systems

    Credits: 3
    Hours/Week: Lecture None Lab None
    Course Description: This course is intended to give the layperson an understanding of personal computers and information systems. Computer concepts and applications are covered. The concepts will include basic information about how personal computers, networks, and software work. Enterprise information systems and technologies will be discussed. Additional topics include security, privacy, ethics, information literacy, and technological trends. Students will gain hands-on experience using current business applications (such as word processing, database, spreadsheet, and presentation software).
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: Basic computer competency (use of keyboard, mouse, Windows).

    Major Content
    1. Input and output
    2. Processor/memory
    3. Storage
    4. Data communications
    5. System software
    6. Application software
    7. Security, backup
    8. Privacy, ethics
    9. Word processing application
    10. Spreadsheet application
    11. Database application
    12. Presentation graphics application
    13. Internet concepts, use and information retrieval
    14. File system application
    15. Professional design standards

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe the basic hardware (input, output, and storage) components and software (operating and application) used in Windows and the internet environment.
    2. demonstrate  effective use of computer system hardware and operating and application software.
    3. apply the ability to organize files by creating folders and managing (copy, move, rename, and delete) files.
    4. describe computer security, safety, ethics, and privacy concepts and issues and explain how they relate to using computers effectively.
    5. demonstrate effective techniques for internet access and information retrieval.
    6. apply procedures to create documents, worksheets, databases, and presentations suitable for coursework, personal, and professional purposes.
    7. apply word processing, spreadsheet, database, and presentation software to solve business problems.
    8. apply e-mail software for professional, effective communication.
    9. apply the ability to create, design, and maintain databases by creating tables, queries, reports, and forms while following professional design standards.
    10. apply the ability to create, format, analyze, save, and print spreadsheets while following professional design standards.
    11. apply the ability to create, format, save, and print word processing documents while following professional design standards.
    12. apply the ability to create, format, save, and print presentations while following professional design standards.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 1021 - Spreadsheet & Database Software

    Credits: 3
    Hours/Week: Lecture None Lab None
    Course Description: This course teaches the theory and application of spreadsheet and database management software. The current software technologies will be used to demonstrate these concepts and principles. Students will study and apply spreadsheet concepts such as data lists, pivot tables, one-variable and two-variable input tables, importing data, and the creation of spreadsheet applications using a programming language. Students will study and apply database concepts such as table relationships, queries, forms and reports, macros, and the creation of database applications using a programming language. The intent of this course is to prepare students to be able to customize spreadsheet and database software applications.
    MnTC Goals
    None

    Prerequisite(s): CSCI 1020  and CAPL 1010  or instructor consent.
    Corequisite(s): None
    Recommendation: Basic knowledge of Microsoft Windows, introductory knowledge of spreadsheets and databases.

    Major Content
    1. Database Software Concepts And Principles Using A Programming Language In A Database Environment: Events, Procedures, Modules
    2. Database Software Concepts And Principles Principles Of Database Design: Relationships, E-R Diagrams, Integrity, Anomalies, Normalization The Use Of Queries To Extract Organization Information: Crosstab Queries And Others The Use Of Forms To Find And Maintain Table Data Customizing Reports And Integrating Database Software With Other Programs Other Customization Features Structured Programming Techniques World Wide Web Concepts And The Maintenance Of Database Tables Via HTML Documents Macros And Other Automating Features
    3. Integration Transfer Of Spreadsheet Data To A Database Transfer Of Database Data To A Spreadsheet Object Linking And Embedding (OLE)
    4. Spreadsheet Software Concepts And Principles Use Of Charts To Display Organization Data Tools For Extracting Management Data: Lists, Filters, Pivot Tables Integrating Spreadsheet Software With Other Programs And The World Wide Web The Use Of Multiple Worksheets And Look-Up Tables To Extract Organization Data How Data Tables, Solver, And Scenario Management Can Be Used In Cost-Volume-Profit Analysis Automating Tasks Using Macros And Other Automating Features Structured Programming Techniques Using A Programming Language In A Spreadsheet Environment: Objects, Prop

    Learning Outcomes
    At the end of this course students will be able to:

    1. To teach the concepts and techniques of database management software.
    2. To teach the customizing and automating features of spreadsheet software.
    3. To teach the customizing and automating features of database management software.
    4. To teach the concepts and techniques of spreadsheet software.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 1022 - Introduction to Power Apps

    Credits: 4
    Hours/Week: Lecture 4
    Course Description: Power Apps is a new, exciting, development tool to create portable software applications that can automate and facilitate business processes. This course introduces students to programming concepts by using Power Apps. Course activities involve the use of Power Apps and programming to create dynamic applications that can import, transform, analyze, and present data to derive rich business intelligence. This course also introduces students to related concepts and tools such as AI Builder, Power BI, Power Automate and Microsoft Dataverse.
    MnTC Goals
    None

    Prerequisite(s): Course placement into MATH 0070  or higher or completion of MATH 0030  with a grade of Cor higher.
    Corequisite(s): None
    Recommendation: Basic ability to operate a computer and use the Internet.

    Major Content
    1. Overview
      1. Licensing and subscription
      2. Technical requirements
      3. History
      4. Interface
      5. What is a Power App?
        1. How they are created
        2. How they are used
      6. Relationship with Microsoft applications
    2. Installation and configuration
    3. Formulas and programming
      1. Working with text, dates and numbers
      2. Data Types
      3. Variables
      4. Conditionals
      5. Iteration
      6. Functions
      7. Common algorithms
    4. App concepts, objects and parts
      1. Controls
      2. Forms
      3. Connectors
      4. Tables
      5. Rows
      6. Collections
    5. Working with data
      1. Data sources
        1. Sharepoint
        2. SQL Server
        3. Onedrive
        4. Dataverse
      2. Retrieving data
      3. Searching
      4. Joining
    6. Canvas Apps
      1. Templates and layouts
      2. Screen designs
    7. Apps from Sharepont
    8. Model-driven apps
      1. Using the Designer
      2. Working with data
      3. Implementing business flows
    9. Portal apps
      1. Creating a portal
      2. Securing a portal
      3. Creating web forms
      4. Working with Data
    10. Using Power Automate
      1. Creating and managing flows
      2. Calling flows
      3. Working with data
    11. Administration
      1. Transferring apps and data
      2. Administering security
      3. Sharing with tenants
      4. Environments

    Learning Outcomes
    At the end of this course students will be able to:
    1. create applications using Power Apps, Power FX, and related tools.
    2. develop an algorithm to solve a given problem.
    3. configure Power Apps and related tools, and data sources during subscription and
      installation.
    4. describe the relationship between Power Apps and other applications.
    5. create tenants and environments to share apps securely and collaboratively.
    6. connect different data sources for use by the app.
    7. configure different data sources for use by the app.
    8. incorporate data search and retrieval features into the app.
    9. create client and portable apps using a variety of methods.
    10. manage applications using administrative tools.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 1050 - Internet Essentials: Concepts, Use and Design

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course provides a comprehensive overview of the Internet. Students begin by examining the hardware and software technologies that support the Internet such as TCP/IP, HTML and JavaScript. This is followed by learning about many of the current features such as compression, search, e-mail, file transfer and internet conferencing. Concepts and guidelines are presented for internet security, privacy and safety. Students are introduced to web site design, management and search engine optimization (SEO). Current technologies, such as web browsers, content management systems (e.g. Wordpress, Joomla) and/or web-based tools are used to demonstrate the concepts and develop student proficiency.
    MnTC Goals
    None

    Prerequisite(s): None
    Corequisite(s): None
    Recommendation: Basic computer competency (use of keyboard, mouse, Windows).

    Major Content
    1. Theory and application of Internet use
      1. Role of the ISP/choosing an account
      2. Installing dial-up software, TCP/IP, PPP, web browser
      3. Theory and application of access technology
      4. Multimedia formats, their delivery and display
      5. Internet conferencing & instant messaging
      6. Telnet, FTP
    2. How the Internet works
      1. Overview of webs, web servers
      2. Client Hardware/software requirements
      3. Types of connections/transmission technologies
      4. Other network hardware (e.g. routers, gateways)
      5. Client/server architectures
      6. Introduction to transmission technologies
      7. Web server hardware and software technologies
    3. Use of the Internet in ECommerce
      1. B2C concepts and examples
      2. B2B concepts and examples
      3. C2C concepts and examples
      4. E-money and EBPP (Electronic Bill Presentation and Payment)
      5. Revenue models
      6. Commercial products and services to establish an e-commerce site
    4. IV. Web Markup Languages
      1. HTML
      2. XML
    5. Web Development Tools
      1. Client-side scripting languages:
      2. Server-side languages, applets and controls
      3. Database access
      4. Different development tools & environments
    6. Theory and application of Web content creation and management
      1. Format and structure of a web site
      2. Principles and application of web site design, creation, maintenance
      3. Publishing webs and remote administration
      4. Forms and different ways to handle form input
      5. User authentication and security
      6. Collaborative creation and version control
      7. Database use and access
      8. Web metrics and analytic tools
      9. Site monitoring
      10. Inclusion of simple scripts and controls
      11. Different tools for web site maintenance/reporting
      12. Web site hosting services

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe how information is created, stored, transmitted and accessed on the internet.
    2. perform advanced searches for information on the Internet.
    3. use a variety of internet applications and tools such as internet conferencing, list servers, peer-to-peer networking and secure e-mail.
    4. describe the types of internet security breaches, such as viruses, worms, spyware and “phishing” hoaxes, that may be encountered when using e-mail or performing file downloads
    5. describe safeguards that can be taken to minimize the security concerns given in the previous objective.
    6. differentiate the various forms of e-commerce found on the Internet, including Business-to-Customer, Business-to-Business, and Customer-to-Customer.
    7. describe the tools and technologies involved in the implementation of e-commerce sites
    8. use the steps and processes involved in designing, developing and maintaining a web site.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 1058 - Introduction to Programming with JavaScript

    Credits: 3
    Hours/Week:
    Course Description: Course activities focus on the use of the JavaScript language to introduce programming and Computer Science to students.   Students will be introduced to common algorithms, computational thinking and design techniques. Fundamental programming structures and tools will be used to implement designs. Course activities focus on the use of JavaScript to design, code, debug, and test introductory web applications.  Related topics and techniques such as HTML and CSS will be presented.  Effective practices of documentation and programming style will be used. 
    MnTC Goals
    None

    Prerequisite(s): Course placement into MATH 0070  or higher or completion of MATH 0030  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: Basic ability to operate a computer and use the Internet.

    Major Content
    1. Overview of computer operation, programs, and programming
    2. Introduction to programming tools including editors, compilers, debuggers
    3. Algorithms, abstraction and computational thinking
    4. Introductory program design principles and techniques
    5. Programming concepts and structures including data types, variables, arrays, control statements, loops, functions and I/O
    6. Effective practices for documentation, programming style and formatting
    7. Introductory web application concepts and techniques

    Learning Outcomes
    At the end of this course, students will be able to:

    1. describe the basic concepts of computer operation, software and programming languages.
    2. use appropriate techniques and basic algorithms to design an efficient solution for a given programming problem.
    3. utilize programming tools such as an editor, compiler and debugger to implement coding designs.
    4. describe programs and algorithms using flowcharts and pseudocode.
    5. utilize appropriate programming structures including variables, arrays, control statements, loops, functions and to implement designs of moderate complexity.
    6. utilize client scripting, html, CSS to create introductory web applications.
    7. employ effective documentation, programming style and formatting in program listings.
    8. use i/o commands to implement basic file operations and effective user interfaces.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 1060 - Introduction to Programming with Python

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: Course activities focus on the use of the Python language to provide a comprehensive introduction to fundamental programming concepts for students interested in exploring computer programming for the first time. Program logic, algorithm design, and fundamental programming structures are emphasized.  Course activities focus on the use of Python to design, code, debug, and test programs of moderate complexity. Gaining knowledge of these concepts and techniques will prepare the beginning student to learn additional programming languages.
    MnTC Goals
    None

    Prerequisite(s): Course placement into MATH 0070  or above or completion of MATH 0030  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: Basic computer competency (use of keyboard, mouse, Windows).

    Major Content
    1. Overview and introduction
      1. Basic overview of computer operation
      2. Programs and programming languages
      3. Program creation and translation process
      4. Algorithms
    2. Programming structures (presented using both flowcharts and programming language)
      1. Variables and data types
      2. Simple input and output
      3. Mathematical operators and expressions
      4. Logical operator and relational expressions
      5. Conditional statements including if and switch
      6. Loops including for and while loops
      7. Simple data structures
        1. Single and multi-dimensional arrays
        2. Structures
        3. Applications and programming techniques
      8. Functions
        1. Function definitions and prototypes
        2. Parameter passing and returning values
        3. Use in modular decomposition
      9. Simple file input and output
    3. Program development
      1. Basic program design using flowcharts and pseudocode
      2. Techniques for debugging and testing.
      3. Effective documentation and programming style
    4. Programming tools including compiler, editor, flowcharts.

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe the difference between a program’s logic and its syntax.
    2. describe essential programming concepts including variables, conditions, loops and input/output.
    3. write flowcharts that completely and accurately describe an algorithm.
    4. describe more advanced programming concepts including procedures, arrays and the use of files.
    5. write, compile, and run programs that include fundamental programming elements such as variable declarations, repetitions and procedure calls.
    6. describe event-driven programming.
    7. describe the relationship between event-driven programming and writing a program that utilizes a graphical user interface (GUI) or graphical environment.
    8. use a variety of debugging techniques (e.g., single-stepping and break-pointing) to successfully debug programs.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 1071 - Introduction to Computing and Problem Solving

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: This course introduces students to the field of Computer Science.  The course will present an overview of the many different areas which make up this diverse field.   Fundamental concepts and practices employed in the field will be introduced.  Knowledge about problem solving, programming, working with and representing data and understanding computers and the Internet will be gained through first-hand experience.  Current and future technological trends such as cloud computing, data analytics and artificial intelligence will be presented.  Societal and ethical issues such as privacy, security and automation will also be addressed.
    MnTC Goals
    None

    Prerequisite(s): Course placement into MATH 0070  or above or completion of MATH 0030  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: Basic computer competency (use of keyboard, mouse, Windows).

    Major Content
    1. Concept of an algorithm as a basis for computer science
    2. Algorithm design, use in problem-solving, and basic performance metrics
    3. Overview of programming languages and paradigms
    4. Common programming structures and their use in algorithms
    5. Introduction to binary numbers
    6. Introduction to Boolean algebra
    7. Introduction to database concepts and practices
    8. Introduction to computer system organization
    9. Introduction to data communications and networks
    10. System software (including operating systems, language translation)
    11. Emerging technologies (e.g. cloud computing, data analytics, mobile computing, internet of things, and artificial intelligence)
    12. Application software including database, internet, and electronic commerce
    13. The role of games, simulation, and virtual reality in society
    14. Overview of occupations in computing-related fields
    15. Security, privacy, ethics, and other societal and legal issues
    16. Digital systems evolution and impact on society and the economy

    Learning Outcomes
    At the end of this course, students will be able to:

    1. describe algorithms and their role in solving problems.
    2. develop or select appropriate algorithmic solutions to solve programming problems.
    3. express algorithms using pseudocode, flow-charts or other design notation.
    4. demonstrate knowledge of common algorithms, such as binary search, finding the minimum/maximum value in a list, and quadratic sort.
    5. implement algorithms with a high-level programming language and provide simple documentation.
    6. express numbers in binary format.
    7. express and simplify Boolean expressions.
    8. apply database management and SQL concepts and techniques to design, create, query and modify a database.
    9. describe the von Neumann architecture and interaction between the processor and memory.
    10. explain how data communication works and give examples of networks.
    11. explain the role of the operating system in a digital system.
    12. describe emerging technologies such as cloud computing, artificial intelligence, data analytics and others.
    13. describe different types of application software including database, internet, and games.
    14. assess security and privacy threats and describe measures to prevent them.
    15. describe the evolution of digital systems and their past, present, and potential future impact on human society.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 1081 - Programming Fundamentals

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: This course introduces the fundamental concepts, structures, and techniques of programming.  Topics include introduction to algorithms, design and development, and the fundamental constructs of programming and data.  Students will use a modern integrated development environment to create complex, multi-file projects.  The course also introduces students to numerical applications (using MATLAB), machine architecture and object-oriented programming.  Differences between the C and C++ language are presented.
    MnTC Goals
    None

    Prerequisite(s): Course placement in MATH 1061  or above, or completion of MATH 0070  with a grade of C or higher or instructor consent.
    Corequisite(s): None
    Recommendation: CSCI 1058  or CSCI 1060  or a beginning course in programming

    Major Content
    1. Overview of programming languages and survey of programming paradigms
    2. The program creation process including editing, pre-processing, compiling, linking, executing
    3. Introduction to machine level organization and representation of numeric and text data
    4. Syntax and semantics of fundamental programming constructs including variables, operators, expressions, assignments, conditional and iterative control structures, functions, I/O, files, objects
    5. Creation of multi-file programming projects
    6. Fundamental data types and structures including primitive types, pointers, arrays, structures and strings
    7. Basic algorithms and their application to solve programming problems
    8. Use of a modern integrated development environment including compiler, debugger, test and project management tools
    9. Language support for numerical computing and engineering applications
    10. Introduction to fundamental design concepts including requirements analysis, structured design, modular decomposition, structure charts, pseudocode.
    11. Introduction to MATLAB numerical computing tool and creation of simple programs to solve basic problems.
    12. C Programming language
    13. Introduction to object-oriented programming

    Learning Outcomes
    At the end of this course students will be able to:

    1. develop a program of moderate complexity.
    2. explain fundamental programming constructs, data types and structures through their appropriate use in programs or program segments.
    3. use appropriate algorithms and problem-solving techniques in program development.
    4. use a programming development environment and associated tools in creating programs.
    5. explain related concepts such as computer architecture, data representation,  program translation and run-time models.
    6. use appropriate language features to solve engineering and scientific problems. 
    7. write a simple MATLAB application to solve a numerical computing problem.
    8. convert a C++ program to an equivalent program in C.
    9. explain what an object is and how it relates to a class.
    10. write methods that get, set and test object data.
    11. develop a simple object-oriented program.
    12. apply consistent documentation and program style standards that contribute to the readability and maintainability of software
    13. write programs that uses file I/O to provide persistence across multiple executions.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 1082 - Object-Oriented Programming

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: This course presents the concepts of object-oriented programming to students with a background in the procedural paradigm. It begins with a review of standard control structures and data types. It then moves on to introduce the object-oriented programming approach, focusing on the definition and use of classes along with related principles such as encapsulation, inheritance and polymorphism.  Object-oriented applications such as GUI, client-server and multi-threaded programs will be created.  Software engineering practices such as version control, unit testing and design patterns will be introduced.
    MnTC Goals
    None

    Prerequisite(s): CSCI 1081  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Review of control structures, functions, and primitive data types
    2. Object-oriented programming: Object-oriented design; encapsulation and information hiding; separation of behavior and implementation; classes, subclasses, and inheritance; polymorphism; class hierarchies; exception-handling
    3. Object-oriented design concepts and techniques including use of a modeling language such as UML and use of patterns
    4. Fundamentals of event-driven programming
    5. Introduction to computer graphics: Using a simple graphics API
    6. Human-computer interaction: Introduction to design issues
    7. Virtual machines: The concept of a virtual machine; hierarchy of virtual machines; intermediate
    8. Introduction to language translation: Comparison of interpreters and compilers; language translation phases; machine-dependent and machine-independent aspects of translation
    9. Software maintenance; characteristics of maintainable software; software reuse
    10. Client-server network protocols and applications
    11. Concurrency and multi-threaded processes.
    12. Unit-testing for program correctness
    13. Common design patterns
    14. Basic security practices in software development

    Learning Outcomes
    At the end of this course students will be able to:

    1. use object-oriented principles and concepts to design, develop, code and test a program of moderate complexity.
    2. use a modeling language to facilitate program design.
    3. use fundamental object-oriented constructs, structures, and techniques in programs or program segments.
    4. use object-oriented classes and tools as well as basic user-interface design principles to develop event-driven, graphical user applications.
    5. explain additional concepts such as virtual machines, intermediate-languages, interfaces, generics, exception-handling, inheritance, polymorphism.
    6. explain how object-oriented features can promote reusability and software-engineering.
    7. manage and coordinate revisions to a software project using revision control software.
    8. develop a concurrent, multi-threaded application.
    9. use common communication protocols to develop client-server applications.
    10. create and use unit tests to demonstrate program correctness
    11. select appropriate design patterns for common programming problems
    12. use appropriate techniques to ensure secure applications.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2005 - Internet Programming: Client-Side Scripting and Applications

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: This course focuses on how to design and implement information services over the Internet from the client side. The course focuses on both usability and client-side scripting. Current technologies such as HTML5, Cascading Style Sheets (CSS3), the DOM, XML and JavaScript will be used to develop Internet client applications. Principles of interface design and human factors will be used to improve usability. Ethical issues and information security principles related to web design will be presented. This course requires working knowledge of a contemporary programming language such as Java, C++ or Visual Basic.
    MnTC Goals
    None

    Prerequisite(s): CSCI 1058  or CSCI 1060  or CSCI 1071  or CSCI 1081  or CSCI 1082  or instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Brief review of the client-server model used on the Internet
    2. User interface design:
      1. Human factors analysis
      2. Principles of good user interface
    3. Security practices and policies
    4. Ethical issues including data privacy concerns
      1. HTML5
      2. What HTML5 is used for
      3. Differences between HTML4 and HTML5 
      4. Differences between HTML5 and XHTML
      5. Basic HTML5 markup for specifying headers, paragraphs, tables, lists, images, hyperlinks, forms
    5. Cascading Style Sheets (CSS)
      1. What CSS is used for
      2. The three ways of specifying style sheets-inline, embedded, and external-and how their information cascades
      3. Using CSS3 to format text, set background images and colors, position page elements, and make other changes.
      4. The “box model” and how it affects the flow of text
      5. Differences between CSS2 and CSS3
    6. JavaScript
      1. Overview of the language’s syntax
      2. Variables and how to perform arithmetic
      3. Flow control statements
        1. If-then-else
        2. Looping
        3. Switch
      4. Writing and using functions
      5. Using arrays
      6. Using JavaScript’s built-in objects
      7. Manipulating cookies
      8. Responding to events
    7. The Document Object Model (DOM)
      1.  What it is and how it can be used to access and modify any part of a web page
      2. Using JavaScript to manipulate the DOM
        1. Dynamic content
        2. Dynamic styles
    8. XML
      1. What XML is used for
      2. The difference between well-formed and valid XML documents
      3. Namespaces
      4. Writing and using a Document Type Definition to validate an XML document
      5. Writing and using an XML Schema to validate an XML document
      6. Having a web page access data stored in an XML file
    9. Developer-specific tools available in current browsers.

    Learning Outcomes
    At the end of this course students will be able to:

    1. analyze ethical issues involved in web application development, including data privacy concerns.
    2. create DTD (Document Type Definition) and XML Schema files that can be used to validate an XML file.
    3. create a web page that retrieves and displays data from a valid XML file .
    4. create dynamic and interactive web pages that include JavaScript programs.
    5. create usable web pages using human factors and principles of interface design.
    6. create web pages using HTML5 to identify the page’s structure and CSS3 (Cascading Style Sheets) to specify the content’s presentation.
    7. create well-formed XML documents.
    8. incorporate security practices and policies into the web design.
    9. verify user-entered data before they are forwarded to the web server that include JavaScript programs.
    10. write JavaScript programs that can access the web page’s DOM (Document Object Model) to dynamically modify the page’s structure (HTML) and appearance (CSS).
    11. write JavaScript programs that respond to user-initiated events such as mouse clicks and form submissions.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2006 - Internet Programming: Server-side Applications

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: This course focuses on the server-side components involved in developing Internet programs. The course will examine some of the current languages, interfaces and technologies used to develop server-based applications that work in concert with client-side logic. Server-side scripting languages such as PHP will be used with a database (such as MySQL) to create database-driven websites. Concepts and techniques to implement secure websites will be presented.
    MnTC Goals
    None

    Prerequisite(s): CSCI 2005  with a grade of C or higher or instructor consent.
    Corequisite(s): None
    Recommendation: Introductory knowledge of database concepts and techniques.

    Major Content
    1. Overview of web servers in common use (IIS, Apache, GWS¿)
      1. Unique capabilities of each
      2. Advantages and disadvantages of each
    2. PHP Language
      1. Basic syntax
      2. Data types, operators, decision making and looping
      3. Arrays and Hashes
      4. Regular expressions and strings
      5. Functions
      6. Object-oriented PHP
      7. Error and exception handling
      8. File operations
    3. Review of Internet Theory
      1. The client/server model on the Internet
      2. The division of labor: client-side application responsibility vs server-side application responsibility
      3. The HTTP request/response protocol
    4. Database concepts and techniques
      1. Fundamental terminology and DB components
      2. Database design
      3. Database creation
      4. SQL Query fundamentals
      5. Accessing the database using PHP
    5. Web security concepts and techniques
      1. Type of ecommerce sites and threats
      2. Common security problems and solutions
      3. Techniques for authentication
      4. Techniques for secure transaction
    6. Advanced PHP Techniques
      1. Effective debugging techniques
      2. Techniques to access the server file system
      3. Session control
      4. Techniques to access date and time
    7. Creating a large, sophisticated PHP and database-driven project.
      1. Techniques for working on a large project
      2. Capstone project

    Learning Outcomes
    At the end of this course students will be able to:

    1. design and create a relational database, and access it via PHP scripts and queries to retrieve and store data that is a component of a dynamic website.
    2. design, develop, test and debug server-side scripts written in PHP that can deliver dynamic content to a web page.
    3. describe the logical model used for client-server interaction on the Internet.
    4. differentiate the processing responsibilities typically assigned to client logic and server logic.
    5. incorporate Asynchronous JavaScript technology in a website to provide asynchronous, partial-page updates to web pages.
    6. describe common website security threats and incorporate appropriate security measures to implement secure transactions.
    7. use course concepts and techniques to build a sophisticated, secure, dynamic client/server application.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2010 - BattleCode

    Credits: 1
    Hours/Week: Lecture 1 Lab None
    Course Description: This course is taught as an artificial intelligence programming contest in Java. Students work individually or in teams to program virtual robots to play Battlecode, a real-time strategy game. Commands and features to control the robots and interact with the virtual environment will be presented.  Supporting concepts in AI, concurrency, and communication will be introduced.  Students will complete a final project which is a program which controls their robots.  Student robots are then combined to compete against each other in a live Battlecode tournament. This course requires thorough knowledge of Java programming language.
    MnTC Goals
    None

    Prerequisite(s): CSCI 1081  or instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Overview of BattleCode software and process
    2. BattleCode concepts including objectives, maps, players, actions, timing
    3. BattleCode programming interface and tools
    4. Tip and hints for effective strategies
    5. AI concepts and techniques in gaming
    6. Communication concepts and techniques
    7. Concurrent process creation and coordination in a multi-tasking environment
    8. Performance metrics used to analyze software performance
    9. Collaboration and version control software
    10. Design, debugging and documentation in large concurrent applications

    Learning Outcomes
    At the end of this course, students will be able to:

    1. demonstrate an understanding of the BattleCode game including objectives, maps, rules, process, players, and actions.
    2. learn the battlecode programming interface and tools and how they interact with Java
    3. develop an effective strategy given parameters of the competition.
    4. use principles of artificial intelligence, concurrency and communication to implement an effective strategy for a robot army.
    5. utilize effective design, documentation and debugging practices to produce effective code.
    6. collaborate with others in a team using version control software.
    7. analyze tournament results and describe improvements or optimizations in design.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2014 - Discrete Structures of Computer Science

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: This course covers discrete mathematical techniques and structures used in computer science. The content stresses problem solving techniques that involve the use of logic, various methods of proof, and sets. Topics of particular interest to computer scientists include big-O notation, recursion, and the fundamentals of trees and graphs.
    MnTC Goals
    None

    Prerequisite(s): Course placement into MATH 1081  or completion of MATH 1061  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Logic and proof
    2. Mathematical induction, including both strong and weak induction
    3. Elementary set theory
    4. Relations and functions
    5. Recurrence relations
    6. Elementary number theory and applications
    7. Elementary graph theory and applications
    8. Combinatorics and probability
    9. Algorithm analysis

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe how symbolic logic can be used to model real-life situations or applications, including those arising in computing contexts such as software analysis (e.g., program correctness), database queries, and algorithms.
    2. examine the logical validity of arguments and proofs as they apply to Boolean expressions.
    3. apply mathematical induction and other techniques to prove mathematical results.
    4. perform computations using recursively defined functions and structures.
    5. solve problems involving sets, relations, functions, and congruences.
    6. illustrate the basic terminology and properties of graphs and trees.
    7. use graphs and trees to solve problems algorithmically.
    8. use methods of combinatorics to solve counting and basic probability problems.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2016 - Introduction to the Organization of Computer Systems

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: This course is an introduction to hardware/software components of a computer system. Topics covered will include data representation, computer arithmetic, basic logic design, machine-level programs, instruction set architectures, processor and memory organization, storage hierarchy, optimization techniques and future trends. Students will write programs in a low-level language, such as assembly language.
    MnTC Goals
    None

    Prerequisite(s): CSCI 1082  with a grade of C or higher or instructor consent.
    Corequisite(s): None
    Recommendation: CSCI 1020 

    Major Content
    1. Evolution of computer architecture and influence on development of systems; future trends
    2. Boolean algebra and simplification, simple combinational and sequential logic design, and implementation
    3. Binary representation of different types of data; numeric data representation including signed and unsigned integers and floating point formats
    4. Basic operation and organization of the Von Neumann machine including cpu, memory, buses, and fetch/execute cycle; Von Neumann bottleneck; memory types and organization; interleaving
    5. Machine language concepts and characteristics including instruction formats, addressing modes, RISC versus CISC, and relationship to logic circuits
    6. Assembly language programs including standard programming structures, subroutines, I/O and macros; conversion process from higher-level language to assembly language to machine language
    7. Storage system concepts, types and operations; characteristics of media formats and tradeoffs; access time, throughput, bandwidth
    8. Storage hierarchy pyramid and operation; principle of locality
    9. Memory cache concepts and operations; different types of cache including direct, associative, and set associative; write policies and cache coherency in SMP systems
    10. Virtual memory techniques and concepts including segmentation and paging
    11. I/O: fundamental concepts including handshaking, buffering, programmed I/O, and interrupts
    12. Buses: bus protocols, arbitration, and direct-memory access (DMA)
    13. Improving performance through superscalar, pipelining, multi-threading, vector processors, GPUs and other concurrent techniques
    14. Pipelining operation and hazards; optimization techniques such as branch prediction and speculative and out-of-order execution
    15. Flynn’s revised taxonomy including SISD, SIMD, MISD, and MIMD; categorize current systems in this taxonomy
    16. Quantum computing, neural networks, DNA data storage and other emerging technologies

    Learning Outcomes
    At the end of this course students will be able to:

    1. design and implement simple combinational and sequential logic circuits.
    2. represent numeric and text data in current standard formats and convert between numeric formats.
    3. describe instruction execution cycle and how the processor and memory work
    4. describe machine instruction formats and discuss features and differences of instruction set formats and architectures.
    5. write assembly language programs that incorporate standard programming structures, subroutines, i/o and macros.
    6. describe the memory hierarchy including different levels and optimization strategies such as cache and virtual memory.
    7. discuss different i/o and storage devices and mechanisms including bus protocols, interrupts, and interfaces
    8. discuss concurrency techniques to bypass performance bottleneck including pipelining, superscalar, multi-core, and multi-threading
    9. list and compare the different architecture categories and describe emerging technologies.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2033 - Elementary Computational Linear Algebra

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: This course is an introduction to the numerical methods of Linear Algebra and their application to solving computational problems. Topics covered will include matrices, linear transformations, linear vector spaces, inner product spaces, systems of linear equations, Eigenvalues, and singular values. Algorithms and computational matrix methods will be presented using MATLAB. Matrix methods will be used to solve a variety of computer science problems.
    MnTC Goals
    None

    Prerequisite(s):  CSCI 1058  or CSCI 1060  or CSCI 1071  or CSCI 1081  or CSCI 1082  or instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Vectors; linear combinations; matrices; matrix operations
    2. Elementary linear mappings; applications in graphics and statistics
    3. Systems of linear equations; applications
    4. Theory of linear equations: complexity, operation counts; applications
    5. Vector spaces; abstract linear spaces; subspaces; linear dependence; basis and dimensions; row reduced form; null space; range; Applications
    6. Determinants Theory; Proofs; Applications
    7. Inner Products.; Orthogonality; Least Squares; Norms, Condition Numbers, and Numerical Stability; Applications
    8. Abstract linear transformations; Applications
    9. Eigenvalues. Spectra of Symmetric matrices; Diagonalization of symmetric matrices; Applications
    10. Singular Value Decomposition; Applications

    Learning Outcomes
    At the end of this course students will be able to:

    1. demonstrate an understanding of the basic theorems and techniques of linear algebra
    2. develop the numerical methods which approximate linear algebraic equations
    3. create and apply appropriate algorithms and numerical methods to solve a variety of problems
    4. use Matlab (or similar tool) to implement algorithms and computational methods
    5. use symbolic methods to identify and solve linear algebraic problem

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2041 - Advanced Programming Principles

    Credits: 4
    Hours/Week: Lecture 4
    Course Description: This course covers the principles and techniques for creating correct, robust, modular programs. Topics include computing with symbolic data, recursion/induction, functional programming, impact of evaluation strategies and parallelism. Additional topics include organizing data/computations around types, search-based programming, concurrency and modularity.
    Prerequisite(s): CSCI 1082 - Object-Oriented Programming   and CSCI 2014 - Discrete Structures of Computer Science  with grades of C or higher.
    Major Content
    1. Introduction to functional programming: primitive types and operators, let bindings, lambda expressions, recursion
    2. Conditional expressions, pattern matching, iteration and recursion, tuples and lists
    3. User-defined data types, product and sum types, inductive types
    4. Higher-order functions, currying, closures, polymorphism
    5. List-processing functions: map, filter, fold, reduce; relationship between functions
    6. Program representation and evaluation.
    7. Type checking and type inference.
    8. Evaluation strategies: call-by-name, call-by-value, lazy evaluation
    9. Evaluation control: exceptions, continuations, delayed evaluation
    10. Evaluation of program correctness using natural and structural induction”
    11. Types and imperative programming: side effects, references, mutable data structures, and algorithms
    12. Modularity and data abstraction mechanisms
    13. Optional topics: search, program representation, concurrency, proof techniques

    Learning Outcomes
    At the end of this course, students will be able to:

    1. write, and debug simple functional programs for recursive computations on lists, trees, strings, and numeric types.
    2. use inductive, polymorphic, and hierarchical abstract data types to organize program data and efficiently solve computational problems.
    3. explain the benefits and limitations of type systems, as well as the common program errors that can be eliminated using strong type systems.
    4. explain how manipulating functions as values and the use of higher-order functions can be used to solve appropriate algorithmic problems.
    5. explain how common list-processing functions (such as map, fold, reduce, and filter) are used and implemented in order to be the best for a given algorithmic task.”
    6. explain the impact of different approaches to program evaluation and methods to manipulate the order of evaluation in programs, such as continuations, exceptions, tail recursion, and streams.
    7. explain and differentiate program organization and reuse mechanisms such as polymorphism, modules, namespaces, private internals, classes, and nesting.


    Courses and Registration

  
  • CSCI 2050 - Database Management Systems

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: The course covers the concepts and techniques for designing, creating, and managing databases.  The relational model is emphasized, along with its associated design techniques, such as E-R Model, normalization, and decomposition.  Structured Query Language (SQL) is covered in depth and used to implement, query, and modify databases.   Topics include query optimization, transaction management, backup, security, and privacy, as well as additional architectures such as distributed, object-oriented, and client/server.  Additional architectures such as distributed, object-oriented database, and client/server are explained.  Course activities include the creation of front-end database applications that use modern interface design, using an industry-current database such as MySQL.  An industry current database such as MySQL will be used in the course. This course requires thorough knowledge of an object-oriented programming language such as Java or C++ .
    MnTC Goals
    None

    Prerequisite(s): CSCI 1081  or CSCI 1082  or instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. The Relational Database Model
    2. SQL Language
    3. Relational Database Design
    4. The E-R Model
    5. Physical Storage and File Structure
    6. Query Processing
    7. Query Optimization
    8. Transaction Management & concurrency control
    9. Recovery and Backup
    10. Database-System Architectures
    11. Data Warehousing and Mining
    12. Object-Based Databases
    13. NoSQL Databases
    14. SQL Language
    15. Indexing
    16. Front-end Applications
    17. Comparison of Alternative Architectures
    18. Relational Algebra
    19. Database Administrator Responsibilities

    Learning Outcomes
    At the end of this course students will be able to:

    1. create conceptual, logical, and physical entity relationship diagrams based on requirements.
    2. apply the appropriate design process and techniques (such as normalization) to create an optimal database
    3. use SQL to create, modify, and query relational databases.
    4. demonstrate principles for effective transaction management, concurrency control, and recovery.
    5. describe techniques for creating data warehouses and mining them for information.
    6. compare different database architectures including relational, distributed, object-oriented and NoSQL.
    7. create indices that promote optimal database access and queries.
    8. describe query processing .
    9. implement query optimizations.
    10. create user-friendly front-end applications that implement HCI principles.
    11. describe the relationship between queries and relational algebra operators.
    12. describe the role and responsibilities of database administrator.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2051 - Database Management Systems 2

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course presents advanced database management systems (DBMS) concepts and applications. It emphasizes topics essential for creating, maintaining, and using a multi-user client-server database system. These include configuration, optimization, security, backup, replication, and troubleshooting. Students will complete hands-on exercises using a current client/server database system.
    MnTC Goals
    None

    Prerequisite(s): CSCI 2050   with a grade of C or higher or instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. DBMS planning
    2. DBMS design
    3. DBMS creation, configuration, modification
    4. Tables, indices, views, reports
    5. Automation using procedures, scripts, triggers
    6. User administration and security
    7. Transaction management
    8. Query optimization
    9. Backup and recovery
    10. Performance monitoring and optimization
    11. Data import/export/transformation
    12. Reliability and availability
    13. Replication
    14. Maintenance

    Learning Outcomes
    At the end of this course students will be able to:

    1. determine resource and capacity  requirements.
    2. use appropriate techniques to design, create, and configure an optimal database to meet requirements.
    3. import or convert data from a variety of formats.
    4. analyze security issues in order to incorporate effective security measures.
    5. create and manage tables, indices, views.
    6. optimize queries using appropriate tools and techniques.
    7. establish effective procedures to ensure data integrity.
    8. automate database operations through the use of procedures, functions, and triggers.
    9. use appropriate tools and policies to administer users and operations.
    10. implement a backup strategy in order to backup and restore a database.
    11. monitor performance and use optimization techniques to achieve high availability and throughput.
    12. migrate data into databases.
    13. replicate data from one DBMS to another.
    14. use appropriate tools to ensure effective transaction capture and backup.
    15. conduct periodic maintenance.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2061 - Python for Programmers

    Credits: 2
    Hours/Week: Lecture 2 Lab None
    Course Description: This course introduces students to the concepts, syntax, style, and library system of the Python programming language.  Course activities will include the creation of complex programs using advanced features of the language and library.  It is intended only for students who already have a background in Object-Oriented programming in another language.  A knowledge level equivalent to that obtained through successful completion of CSCI 1081  and CSCI 1082  will be assumed.
    MnTC Goals
    None

    Prerequisite(s): CSCI 1082  with a grade of C or higher or instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Simple data types
    2. Built-in data structure
    3. Control and interation structures
    4. Functions
    5. Object-oriented features
    6. Exception handling
    7. File operations
    8. Exception Handling
    9. Python libraries
    10. Security techniques
    11. GUI development
    12. Database creation and access
    13. Web applications

    Learning Outcomes
    At the end of this course students will be able to:

    1. describe similarities and differences between basic Python programming structures and their equivalents in other languages.
    2. use tuples, lists, dictionaries. Iterators, generators and other Python data structures to store, manipulate and manage data.
    3. develop an object-oriented program that uses inheritance, polymorphism and dynamic allocation.
    4. validate user data and incorporate fault tolerance through exception handling.
    5. employ basic preventive measures to produce a secure application.
    6. create a GUI application with good interface design.
    7. develop a database application  that can create, store and manage data and files.
    8. develop a web application.
    9. use the standard Python libraries and import external libraries to automate application development.
    10. create and import modules and packages.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2082 - Data Structures and Algorithms

    Credits: 3
    Hours/Week: Lecture 3 Lab None
    Course Description: This course builds on the foundation provided by the CSCI 1081 , CSCI 1082  sequence to introduce the fundamental concepts of data structures and the algorithms that proceed from them. Topics include generic programming, recursion, the underlying philosophy of object-oriented programming, fundamental data structures (including stacks, queues, linked lists, and trees) and the basics of algorithmic analysis.
    MnTC Goals
    None

    Prerequisite(s): CSCI 1082  with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Fundamental computing algorithms, e.g O(N log N) sorting algorithms; tree-processing algorithms
    2. Asymptotic algorithm complexity analysis
    3. Recursion: The concept of recursion, recursive mathematical functions, simple recursive procedures, divide-and-conquer strategies, recursive backtracking, implementation of recursion
    4. Algorithmic strategies, e.g. Brute-force algorithms; greedy algorithms; divide-and conquer; backtracking; branch-and-bound; heuristics; pattern matching and string/text algorithms; numerical approximation algorithms
    5. Generic programming and the use and creation of template data structures
    6. Fundamental data structures, e.g. Stacks, queues, linked lists, trees
    7. Fundamental computing algorithms, e.g simple searching and sorting algorithms (linear and binary search, selection, bubble, and insertion sort)

    Learning Outcomes
    At the end of this course students will be able to:

    1. apply object-oriented principles to the development and use of algorithms and data-structures.
    2. calculate time and space complexity of data structures and algorithms and be able to use these complexities to choose the most appropriate for a given problem environment.
    3. create and use templated (generic) classes and methods.
    4. demonstrate knowledge of algorithms associated with different data structures.
    5. demonstrate knowledge of recursion by describing common applications and by effectively using it to solve problems.
    6. use appropriate algorithms to solve common computing problems.
    7. use fundamental data structures such as stacks, queues, linked-lists, and trees to represent data and meet application requirements.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2091 - C# Language and the .NET Framework

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: This course introduces the C# programming language and .NET framework. The course will present C# language features designed to create a sequence of programs of increasing complexity. C# language features covered will include basic constructs, object-oriented features, exception handling and the LINQ language. Then, an overview of the .NET framework will be presented. Finally, students will use C# in conjunction with .NET to create sophisticated GUI programs that access data and the web. This course requires thorough knowledge of an object-oriented programming language such as Java or C++.
    MnTC Goals
    None

    Prerequisite(s): CSCI 1081  or instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Basic constructs and features including operators, basic types, instance variables, strings, arrays, control and iterative statements, files, I/O
    2. Classes, Objects, Methods, Properties, Attributes,
    3. Inheritance, Polymorphism, Interfaces
    4. Exception Handling
    5. Introduction to .NET, CIL, CLR, Framework Class Library, common types
    6. Graphical user interfaces with Windows Forms or WPF
    7. LINQ and use with .NET collections, SQL Server, ADO.NET, XML
    8. Collections
    9. Introduction to Web application development, ASP.net and Web Services

    Learning Outcomes
    At the end of this course students will be able to:

    1. create a web application or service.
    2. describe the structure and function of .NET including CIL, CLR, framework class and common types.
    3. design an application with a graphical user interface.
    4. design and develop object-oriented applications that utilizes inheritance, polymorphism and interfaces.
    5. embed exception-handling mechanisms to catch and debug errors.
    6. query and manage data stored in a collection, database or web using LINQ.
    7. write a program of moderate complexity using C# basic constructs and features.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2094 - Mobile Application Development with Android

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: This course teaches a student how to develop mobile applications for the Android operating system. Students will use state-of-the-art development tools to develop, debug, test and deploy applications of moderate complexity. Course topics will include how to incorporate Android features such as touch, motion, communication, multi-threading, audio and video to create applications that take full advantage of mobile device capabilities. Techniques for accessing data from databases and content providers will also be presented. This course requires thorough knowledge of Java programming language.
    MnTC Goals
    None

    Prerequisite(s): CSCI 1082  or instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Introduction to Android operating system, apps, packaging, Google Play
    2. Android developer tools, Eclipse, Android studio
    3. Event handling
    4. GUI design and development using layouts, widgets, menus, preferences, themes, fragment
    5. Threads, intents, activities and concurrent execution
    6. Touch/Gesture Processing
    7. Assets, graphics, audio and animation
    8. Utilizing the accelerometer in applications
    9. Services and notifications
    10. Accessibility, Internationalization
    11. Databases, adapters and content providers

    Learning Outcomes
    At the end of this course students will be able to:

    1. access data stored in databases and from content providers.
    2. capture and utilize accelerometer input.
    3. create a multi-threaded application using intents, activities and broadcast receivers.
    4. develop services and notifications.
    5. develop, debug and test an Android application.
    6. implement a graphical user interface using layouts, menus, preferences, themes.
    7. incorporate touch and gestures into the user interface.
    8. use Android development tools to implement Android language features.
    9. use assets, graphics and audio in an application.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2095 - Mobile Application Development with iOS

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: This course focuses on how to develop mobile applications for the iOS platform. Students use state-of-art development tools to develop, debug, test, and deploy applications of moderate complexity. Course topics include how to incorporate iOS features such as touch, motion, communication, multi-threading, audio, and video to create applications that take full advantage of mobile device capabilities. Techniques for accessing persistent data are presented. This course requires thorough knowledge of any object-oriented programming language.
    MnTC Goals
    None

    Prerequisite(s): CSCI 1082  or instructor consent.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Introduction to iOS operating system, apps, packaging, Apple Store
    2. iOS programming language
    3. Using IDE for iOS development
    4. Event handling and interactive applications
    5. IOS Navigation and Interface Design
    6. Persistent Data in iOS
    7. Tables in iOS: Navigation and Information
    8. Maps and Locations in iOS
    9. Access to Hardware and Sensors in iOS
    10. App monetization strategies
    11. Publishing iOS apps
    12. Accessibility
    13. Internationalization

    Learning Outcomes
    At the end of this course students will be able to:
    1. use iOS development tools to implement iOS language features.
    2. develop, debug, and test an iOS application.
    3. design and implement user interface views.
    4. incorporate touch and gesture into the user interface.
    5. activate the interface.
    6. access persistent data.
    7. demonstrate knowledge of navigation and information.
    8. use core motion for accelerometer data.
    9. demonstrate knowledge of techniques to publish and monetize applications.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2096 - Cross-Platform Mobile Development

    Credits: 4
    Hours/Week: Lecture 4 Lab None
    Course Description: This course focuses on how to design and implement applications for deployment on different mobile devices. This course introduces one of the available frameworks to target multiple mobile platforms such as iOS, Android, and Windows using a single codebase. Topics include the standard web technologies - HTML5, CSS3, and JavaScript.
    MnTC Goals
    None

    Prerequisite(s): CSCI 2094 or 2095 with a grade of C or higher.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Introduction, rationale, and economics for cross-platform mobile apps development
    2. Design, develop, document and test a cross platform applications
    3. Frameworks available to develop cross-platform mobile applications
    4. Process of developing cross-platform mobile applications
    5. Hardware capabilities of mobile devices
    6. Implementation
    7. App design issues and considerations
    8. Persistent data
    9. Security considerations
    10. Testing and Result

    Learning Outcomes
    At the end of this course students will be able to:

    1. develop cross-platform applications.
    2. employ the technology and principles required for cross-platform operation.
    3. leverage current web technologies to create effective compatible applications.
    4. design, implement, and deploy a mobile application targeted for various platforms.
    5. use off-the-shelf UI (User Interface) frameworks to design applications that are user friendly and that can improve the user’s experience.
    6. explain the security risks facing the mobile applications.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

  
  • CSCI 2211 - Data Science and Visualization

    Credits: 4
    Hours/Week:
    Course Description: This course introduces students to the conceptual foundations and applications of data science. Programming, mathematical, and statistical techniques will be used to analyze and visualize a variety of large-scale data sets. Students will gain hands-on practice in data analysis and visualization. Topics include ethical issues with the use of data, statistical programming language, such as R, for data analysis, and visualizations for presenting the results of data analysis.
    MnTC Goals
    None

    Prerequisite(s): MATH 1025  with a grade of C or higher or concurrently enrolled.
    Corequisite(s): None
    Recommendation: None

    Major Content
    1. Overview of data science concepts, application, and use
    2. Introduction to data analysis tools such as R and RStudio
    3. Overview of current packages and basic techniques for use
    4. Programming concepts such as variables, control statements, loops, etc.
    5. Techniques to import, clean, and prepare data
    6. Introduction to Data frames, including manipulation, merging, and missing data
    7. Creating and using basic vector and matrix operations
    8. Generating descriptive statistics and using basis functions
    9. Different visualization techniques including graphs, tables, charts, and plots such as dot, pie, bar, histogram, mosaic, scatter, correlation, sunflower, box, line, and bag charts
    10. Emerging ethical issues with the use of data

    Learning Outcomes
    At the end of this course, students will be able to:

    1. import, prepare, and analyze data from different sources.
    2. clean and prepare data for analysis using statistical programming language such as R.
    3. summarize and present data in simple and easy-to-understand visualizations.
    4. apply effective visualization concepts and principles.
    5. discuss emerging ethical challenges with the use of data.
    6. collaborate with others on team projects and written and oral reports.
    7. describe the general types of data science analytics and their use in different organizational structures.
    8. use visualization to observe patterns of data, identify outliers and influential points, and understand import features of the data.
    9. use exploratory data visualization to help see the details of the data.
    10. apply programming techniques such as conditionals, loops, functions and input and output to analyze data.

    Competency 1 (1-6)
    None
    Competency 2 (7-10)
    None


    Courses and Registration

 

Page: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11