Honors Information Technology 2

BCIT

Curriculum

Course Title: Honors Information Technology 2

Department: BCIT

Units of Study:

• Advanced Database

• Format

• Edit

• Validation

• Queries/Filters

• Reports

• Subtotals

• Mail merge

• Advanced Spreadsheets

• Format

• Edit

• Formulas

• Lookup

• What Ifs

• Nested Ifs

• Pivot tables/charts

• Charting

• Design

• Format

• Advanced Features

• Editing

• Integration

• Paste/Paste special/Paste link

• Document formatting

• ACCESS

• Database design

• Queries

• Forms

• Reports

Curriculum-Based Assessments:

Standardized Assessments:

Description of Course:

Information Technology 2 is a college-level course which emphasizes Microsoft Office Expert skills in Excel. Advanced skills involving formulas, validation, multi-page projects, lookups, spreadsheet format, charting, graphics and integration will be developed. In addition, financial functions such as payment, future value of money and depreciation will be covered. A unit in MS Access (industry’s most used database software) will also be taught.

Throughout the course students will learn the skills needed to become certified in Microsoft Office Excel by completing class projects and practice tests using GMetrix software. Students will have the opportunity to take the Microsoft Office User Specialist Excel test for certification (fee required). The test can be taken at Neshaminy High School in the BCIT Department, as it is an official Microsoft testing site.