CMIS 250 - Microcomputer Spreadsheets

3 Credit: (3 lecture, 0 lab, 0 clinical) 3 Contact Hours: [CMIS 115 ]

1. Create worksheets to be used in an XML file.
2. Apply Web techniques to publish spreadsheets.
3. Develop interactive and noninteractive spreadsheets.

Goal 2:  Create customized charts.

1. Change color options for chart objects.
2. Apply clip art and pictures.
3. Utilize rotation and explosion to better view graphical elements.

Goal 3:  Incorporate the use of database techniques to evaluate data.

1. Create data tables to be used as a database.
2. Apply data filters.

1. Create filters which filter the data directly.
2. Create filters which extract the data to a separate location on the spreadsheet.
3. Develop filters which incorporate compound conditions.

3. Employ the use of pivot tables to cross-tabulate data.
4. Chart pivot table data using a pivot chart.

Goal 4:  Produce spreadsheets which access data outside of a single spreadsheet.

1. Create consolidated spreadsheets which combine data from multiple spreadsheets.
2. Develop workbooks which link data from other workbooks.
3. Use hyperlinks to access web resources and data.

Goal 5:  Apply spreadsheet auditing tools.

1. Use tracing tools to evaluate formula dependents.
2. Use tracing tools to track precedent cells.

Goal 6:  Develop Visual Basic applications to automate spreadsheets.

1. Create an automated macro using the record function.
2. Develop a macro to automatically transfer data within a worksheet.
3. Create a macro to protect and unprotect sections within a worksheet.
4. Create a macro which is associated with a button placed on a worksheet.

Goal 7:  Employ analysis methods to evaluate data for decision support.

1. Create multiple scenarios using scenario management tools.
2. Use solver to solve for complex data solutions.
3. Determine cost-volume-profit analysis.
4. Develop spreadsheets to determine break-even analysis.
5. Create data tables using one and two input analysis.