Prerequisites

CIT 10600

Build upon and use content covered in prerequisite course.
Create a multi-page document with page breaks, section breaks, headers and footers, footnotes, and a bibliography reflecting on new word processing learning.
Generate mail merge documents from a source document and a database.
Create a word processing tutorial that uses graphics and screen shots to explain the steps.

Build upon and use content covered in prerequisite course.
Create, format, and modify tables.
Create charts from numerical data in tables.
Sum numerical data in tables.
Insert linked or embedded objects from another program into a word processing document.
Use VBA to create an automated procedure in a word processing program.

Within each application create and modify charts and/or embed or link charts from other applications.

Build upon and use content covered in prerequisite course.
Use financial functions and data tables to analyze financial data.
Use range names to build formulas and functions.
Use conditional formatting to highlight worksheet components meeting several conditions.
Use printing functions to print multi-page spreadsheets that include row and column headings, gridlines, headers and footers, and print titles.
Protect worksheets.
Use database functions and operations such as sort, filter, query, subtotal, extract, analyze lists of information.
Create a web query to import data for manipulation.
Create templates and build worksheets from the templates.
Group worksheets in one workbook and apply common formatting and formulas.
Link multiple sheets in one work book to a summary sheet in the same workbook.
Link multiple workbooks to a summary workbook.
Create charts from spreadsheet data and enhance with graphic images.

Build upon and use content covered in prerequisite course.
Use good design principles.
Change theme colors and fonts to modify a presentation.
Create custom backgrounds with images and/or colors.
Adjust slide masters for various slide layouts within a presentation.
Create and/or modify graphics and other images.
Hyperlink to slides within a presentation or to files in other applications with/without action buttons.
Run a slide show using hyperlinks.
Create and format tables.
Create charts from numerical data.
Create a slide show tutorial based on researching new graphic presentation software learning and incorporate principles covered in the course.
Critique another students tutorial and report findings in a word processing document.