This course builds on the foundations acquired in CIS 111. Students learn complex spreadsheets and database processing through realistic business scenarios. For spreadsheet processing, topics include financial functions, amortization schedules, connecting multiple worksheets and workbooks, database functions, goal Seek, solver, data analysis tools, sorting, querying tables, Pivot Tables, importing data, data cleansing, and data transforming. The course also covers the concepts of data analysis and Power Query to prepare students for modern data-driven decision-making. For database processing, topics include report and form creation, multiple-table form techniques, advanced report generation techniques, insertion of combo boxes and command buttons features, multiple page form creation, and form navigation using macros. The course assists students in preparation for the Microsoft Office Specialist (MOS) certification exam. This course leverages Microsoft’s latest AI-powered tools, such as Copilot in Microsoft 365, to help support student learning.
Area
Computer Information Systems
Course Number
CIS 112
Semester Offered
F/S/SU
Credits
3
Prerequisites
CIS 111, Placement into college level English, MAT 095 with a grade of "C" or higher or QMAT placement score > 21