Menu

Discipline

  • Results for SLO Disciplines>

Student Learning Outcomes

Discipline: Certificate: CIS Professional Certificate in Excel and Access - M0690
Course Name Course Number Objectives
Advanced Database Management - Microcomputers CISD 14
  • Students completing CISD 14 - Advanced Database Management - Microsoft Access will be able to apply appropriate Visual Basic for Applications code (VBA) to update Access table data.
  • Students completing CISD 14 - Advanced Database Management - Microsoft Access will use embedded SQL statements within VBA procedures to create and run ad hoc queries for users.
  • Students completing CISD 14 - VBA for Excel and Access will be able to use the Excel Object Model in finding solutions to Excel problems.
  • Students completing CISD 14 - VBA for Excel and Access will be able to incorporate appropriate decision statements in Access VBA.
Database Design CISD 40
  • Students completing CISD 40 - Database Design will be able to apply normalization rules to database design.
  • Students completing CISD 40 - Database Design will be able to create E-R (Entity Relationship) and UML (Unified Modeling Language) diagrams for a given database scenario.
Database Management - Microcomputers CISD 11
  • Students completing CISD 11 - Database Management - Microsoft Access Lecture will be able to use Microsoft Access to create a professional and user-friendly working database with little or no assistance.
  • Students completing CISD 11 - Database Management - Microsoft Access Lecture will be able to create effective queries that answer needed questions.
  • Students completing CISD 11 - Database Management - Microsoft Access Lecture will be able to create effective reports based on given criteria.
  • Students completing CISD 11 - Database Management - Microsoft Access Lecture will be able to create useful and professional-looking mainform/subforms using Access
Database Management - Microsoft Access Lab CISD 11L
  • Students completing CISD 11L - Database Management - Microsoft Access Lab will be able to create tables and set appropriate relationships between them.
  • Students completing CISD11L - Database Management - Microsoft Access Lab will be able to create queries that answer specific questions about the data in the database.
Microsoft Excel CISB 21
  • Students completing CISB 21 - Microsoft Excel will be able to properly format a worksheet, ensuring that it looks professional
  • Students completing CISB 21 - Microsoft Excel will be able to effectively use formulas and functions in worksheets.
VBA for Excel and Access Lab CISD 14L
  • Students completing CISP 14 - Advanced Basic Programming Lecture will be able to create a web site that accesses data from a database.
  • Students completing CISD 14L - VBA for Excel and Access will be able to use the Excel Object Model to populate calculated data into an Excel worksheet cell.
  • Students completing CISD 14L - VBA for Excel and Access will be able to apply appropriate programming structures for decisions in VBA code.