CIS 102: Advanced Excel (v.1)
Issued by
Year Up
Students apply logical, statistical, financial, and date functions to data; create custom conditional formatting rules based on formulas; apply data validation techniques to reduce errors in data entry; export and import data to and from various formats; apply HLOOKUP and VLOOKUP to find an approximate or specific match based upon conditions; perform what-if and and/or analysis in Excel; create and modify basic pivot charts and tables; and record basic Excel macros to automate sequences.
Additional DetailsEarning Criteria
-
Methods of assessment include quizzes, written papers, presentations, performance rubrics (checklists), examinations, case studies, and group projects with a minimum passing score of 70 percent.
-
Methods of instruction include audiovisual materials, case studies, classroom exercises, computer-based training, discussion, laboratory, learner presentations, lecture, and practical exercises.
Endorsements
-
American Council on Education
This credential has been successfully evaluated by the American Council on Education for college credit and workplace competencies. It is recommended for a total of 3 college credits. For more information about ACE CREDIT evaluations, visit www.acenet.edu. -
American Council on Education
3 semester hours in computer information systems, management information systems, or information technology in the lower-division undergraduate category