Computer Applications

CAP 101- Computer Applications

  • Identify topics through research and use the appropriate application to summarize data accurately
  • Create professional documents using standard industry software
  • Analyze, organize and verify quantitative data accurately in appropriate formats
  • Organize and share data using collaborative applications
  • Design and present information professionally using business applications

CAP 103- Computers for Technology

  • Identify scientific topics through research and use the appropriate application to summarize data accurately
  • Create professional documents using standard industry software
  • Design a research study applicable to biotechnology or other science fields
  • Analyze quantitative data accurately in biotechnology/science appropriate industry formats
  • Present the findings of the research study

CAP 154- Word Processing Applications

  • Apply advanced word processing concepts and procedures such as design and manage master documents and subdocuments
  • Create reusable content and construct a document with building blocks and theme templates
  • Design and modify a word table with advanced features and properties
  • Apply advanced skills to create customized forms, merge data source with main document, and insert text boxes/shapes, graphic and video content

CAP 155- Spreadsheet Applications

  • Apply spreadsheet financial formulas and functions to determine loan payments, future values of investments, and loan amortization to calculate the principal repayment of a loan over a period of time
  • Apply spreadsheet database functions to sort, query, and analyze database table data
  • Utilize the spreadsheet charts feature to display data graphically, simulate interest rates, illustrate key points, and make numbers easier to understand
  • Develop macros to automate multiple common repetitive tasks into one-step keystrokes
  • Create and organize related spreadsheet data into a structured database table
  • Create pivot tables scenarios to analyze, compare, and extract large database fields into unique values

CAP 156- Database Applications

  • Apply advanced concepts and procedures of data types and their role in the development of table structure
  • Apply advanced concepts and procedures of referential integrity, and the importing and exporting of data between office applications
  • Construct tables with advance features and properties
  • Create advance queries, forms and reports, and enhance table design

 

Last Modified: 2/7/24