May 02, 2024  
2022-2023 College Catalog 
    
Catalog Navigation
  Catalog Home
  Message from the Chancellor
  Course Descriptions
  General Education Courses
  All Programs
  Admissions, Registration and Records
  Earning a Degree or Certificate
  Faculty
  Compliance Documents
HELP
2022-2023 College Catalog [ARCHIVED CATALOG]

Course Descriptions

Legend for Courses

HC/HN: Honors Course  IN/IH: Integrated lecture/lab  LB: Lab  LC: Clinical Lab  LS: Skills Lab  WK: Co-op Work
SUN#: is a prefix and number assigned to certain courses that represent course equivalency at all Arizona community colleges and the three public universities. Learn more at www.aztransfer.com/sun.
 

Computer Software Applications
  

  • CSA 100 - Computer Literacy

    1 Credits, 1.5 Contact Hours
    .5 lecture periods 1 lab period

    Overview of computer applications and functions. Includes components of a computer system, spreadsheet, database, and word processing use within a workplace. Also includes computer networks for communication and information.

    Recommendation: Completion of basic computer and keyboard skills, completion of REA 091  or satisfactory score on the reading assessment test before enrolling in this course. If any recommended course is taken, see a financial aid or Veteran’s Affairs advisor to determine funding eligibility as appropriate.
    Information: CSA 100 is a one credit version of CIS 104  
      button image Prior Learning and link to PLA webpage

    Course Learning Outcomes
    1. Describe the essential components of a computer system.
    2. Develop basic operating system skills.
    3. Use word processing to compose, file, and retrieve documents.
    4. Create spreadsheets and use basic spreadsheets functions.
    5. Create basic presentations.
    6. Use the Internet for e-mail and basic research using the World Wide Web.
    Outline:
    1. Components of a Computer System
      1. Hardware
      2. Peripheral, Input and Output devices
    2. Operating System Basics
      1. File management
      2. Using windows
      3. Starting applications
    3. Word Processing Fundamentals Within a Workplace
      1. Functions of a word processor
      2. Composing documents on the computer
      3. Saving and opening files
      4. Correcting errors and moving text
    4. Spreadsheet Fundamentals Within a Workplace
      1. Functions of spreadsheet software
      2. Basics of spreadsheet operations
      3. Formats for computerized data displays
      4. Accuracy in entering and retrieving data
    5. Presentation Graphics Fundamentals Within a Workplace
      1. Functions of presentation software
      2. Presentation basic principles
      3. Creating presentations
      4. Saving and opening files
    6. Internet Fundamentals
      1. Using E-mail and online communities
      2. Searching for information
      3. Critical evaluation of Internet information
  

  • CSA 110 - Spreadsheets: Microsoft Excel

    3 Credits, 4 Contact Hours
    2 lecture periods 2 lab periods

    Fundamentals of spreadsheet applications using Microsoft Excel. Includes spreadsheet concepts, formulas and functions, formatting worksheets and cells, working with charts and graphics. Also includes Excel lists, managing multiple worksheets and workbooks, collaborating on a workbook, developing an Excel application, data tables and Scenario management, using Solver, importing data, and advanced functions and filtering.

    Prerequisite(s): MAT 086 or required score on the Mathematics assessment test.
    Recommendation: Completion of WRT 101 , REA 091  or required score on the assessment test before enrolling in this course. If any recommended course is taken, see a financial aid or Veteran’s Affairs advisor to determine funding eligibility as appropriate.
      button image Prior Learning and link to PLA webpage

    Course Learning Outcomes
    1. Describe and demonstrate spreadsheet concepts in Excel.
    2. Create simple formulas using Excel functions.
    3. Format and print worksheets and data.
    4. Create and format charts including graphics.
    5. Plan, create and manage data using Excel’s List features.
    6. Manage multiple worksheets and workbooks.
    7. Perform workbook collaborations and non-interactive Web pages.
    8. Develop an Excel application including data validation and creating macros.
    9. Conduct data analysis using data tables and Scenario Manager.
    10. Solve complex problems using Solver.
    11. Import data from text files, database and queries into Excel.
    12. Demonstrate advanced logical functions and filtering.
    13. Customizing Excel.
    Outline:
    1. Spreadsheet Concepts and Microsoft Excel
      1. Using Excel to manage data
      2. Worksheet navigation and design
      3. Developing a worksheet
      4. Entering and editing data
      5. Working with ranges, rows and columns
      6. Headers and footers
      7. Previewing and printing formulas and worksheets
    2. Formulas and Functions
      1. Excel functions
      2. Relative and absolute references
      3. Paste options
      4. Insert function dialog box
    3. Formatting Worksheets and Cells
      1. Font types and styles
      2. Cells and cell content
      3. Cell borders and backgrounds
      4. Rows and columns
      5. Background images and sheet tabs
      6. The printed worksheet
    4. Working with Charts and Graphics
      1. Creating charts
      2. Embedded charts
      3. Chart styles and types
      4. Modifying a chart
      5. Formatting chart elements
      6. Adding sparklines
    5. Working with Excel Lists
      1. Introduction to lists
      2. Planning and creating a list
      3. Creating a list range
      4. Sorting data
      5. Maintaining a list
      6. Auto filters and custom filters
      7. PivotTables, PivotChart, Slicer
    6. Managing Multiple Worksheets and Workbooks
      1. Grouping worksheets
      2. Referencing cells and ranges
      3. Data consolidation
      4. Using templates
      5. Working with linked workbooks
      6. Using LookUp Tables
    7. Collaborating on a Workbook and Web Page
      1. Auditing formulas
      2. Tracing and fixing errors
      3. Creating a shared workbook
      4. Tracking changes
      5. Merging workbooks
      6. Non-interactive Web pages
      7. Creating and using hyperlinks
      8. Saving a workbook as an XML file
    8. Developing an Excel Application
      1. Validating data entry
      2. Protecting a worksheet and workbook
      3. Naming cells and ranges
      4. Working with macros
      5. Recording and running a macro
    9. Data Tables and Scenario Management
      1. Cost-volume-profit analysis
      2. One and two-variable data tables
      3. Using array formulas
      4. Scenario manager
      5. Creating scenario reports
    10. Using Solver for Complex Problems
      1. Finding a solution
      2. Creating a Solver answer report
      3. Solver models
    11. Importing Data into Excel
      1. Importing text files
      2. Databases and queries
    12. Advanced Functions and Filtering
      1. Excel’s logical functions
      2. Calculating conditional counts and sums
      3. Advanced filtering
      4. Working with financial functions
    13. Customizing Excel
      1. Modifying screen elements such as the QAT, the ribbon, menu, and tabs
      2. Adding tabs to the ribbon
      3. Deleting screen elements
      4. Importing and exporting modification to the Excel screen elements