Computer Technology II

Credit: 0.5
Course Preface
Core Code: 32-02-00-00-216
Printable Version: Computer Technology II (pdf)

Course Description
This course applies advanced concepts and principles using word processing, spreadsheets, databases, and electronic presentation software. Students will integrate applications learned. This course builds on skills included in Computer Technology.

Prerequisite: Computer Technology, Computer Technology Concurrent Enrollment, or passed all 3 sections of IC3 Test.

Core Standards of the Course

Standard 1
Students will apply features in a variety of applications.

1. Change size
2. Text wrapping
3. Borders and shading
4. Rotate

Standard 2
Students will build on word processing skills to create and edit documents using advanced features.

1. Create
2. Insert and delete rows/columns
3. Merge and split cells
4. Enhance appearance with borders and shading/color
5. Sort data

1. Hanging indent
2. Footnotes/Endnotes
3. Bibliography/work cited
4. In-text citations

1. Section and page breaks
2. Headers and footers
3. Page numbering
4. Columns
5. Tabs
6. Apply and modify styles

1. Create a data source
2. Create a main document and insert merge fields
3. Merge a main document and data source

Standard 3
Students will build on spreadsheet skills to create and edit worksheets.

1. Cell alignment (horizontal, vertical, rotate, wrap text, merge cells)
2. Number formatting
3. Conditional formatting
4. Insert, move, delete, and copy portions of a worksheet
5. Apply and modify styles
6. Change page orientation
7. Freeze panes and split window
8. Manipulate worksheet tabs (insert, rename, delete, move, color, etc.)
9. Fill data in a row or column (formulas, series, etc.)

1. Create formulas
2. Relative and absolute cell references
3. Functions: MAX, MIN, COUNT, IF, VLOOKUP, HLOOKUP

1. Create charts to appropriately represent data (pie, bar, column, line, etc.)
2. Place chart as an object in current worksheet or in a new sheet
3. Format chart elements (legends, titles, borders, fill, etc.)

1. Sort in ascending/descending order and by multiple fields
2. Define and apply filters
3. Subtotals
4. Lists

1. Fit worksheet to specified number of pages (scaling)
2. Formulas
3. Gridlines and row/column headings
4. Selection of cells
5. Multiple sheets
6. Repeat rows and/or columns

Standard 4
Students will build on electronic presentation skills to create and edit slide shows.

1. Apply appropriate design principles (professional business presentation)
2. Customize slide master
3. Apply custom animation and transitions
4. Insert objects (clipart, picture, table, chart, diagram, sound, and video)
5. Insert hyperlinks and action buttons
6. Add speaker notes to slides

1. Print handouts, speaker notes, and outlines
2. Oral presentation skills

Standard 5
Students will acquire database skills to manage data.

1. Define databases and database management systems
2. Define database terminology (field, record, table, primary key, etc.)
3. Create database
4. Create and enter data in a table
5. Restructure (add and delete fields, change field names and properties, etc.)
6. Preview and print

1. Create in design view and using wizard
2. Edit (add, delete, move, and hide fields)
3. Use criteria (text, wildcard, numeric, compound, and comparison operators)
4. Sort
5. Change field properties
6. Preview and print

1. Create using wizard
2. Preview and print

Standard 6
Students will integrate word processing, spreadsheet, and electronic presentation software.