Ask Joe
Mt. SAC Important Message

COVID-19 NOTICE: To take classes ON CAMPUS this upcoming Winter 2022 term, vaccinations will be required. Fully online students are exempt from this requirement. Learn about the December 10 deadline for the first dose, exemptions and more in your Mt. SAC email or www.mtsac.edu/covid19

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.