CollegeTransfer.Net

Course Criteria

Add courses to your favorites to save, share, and find your best transfer school.

  • CECM 277: Level I

    3.00 Credits
    Tompkins Cortland Community College

    Word 2003 Level I is a Microsoft Office Specialist preparation workshop designed to teach you proficiency in using beginner Word features and functions such as how to: * word to create, save, and print a document, as well as use the Help system * navigate in a document and use basic editing techniques * selection techniques, copy and move text, and use the Find and Replace commands * modify a document * format characters and paragraphs and work with tabs in a document * create, edit, and enhance tables * add headers and footers and control page layout using margins and page breaks * proof documents using the Spelling and Grammar feature and the Thesaurus * save a Word document as an HTML file, view the HTML file in a browser, insert * hyperlinks in documents, and send Word documents via e-mail Prerequisites: Introduction to Windows or equivalent knowledge.
    ShareCECM 277 - Level I
    Favorite

  • CECM 278: Level II

    3.00 Credits
    Tompkins Cortland Community College

    Word 2003 Level II is a Microsoft Office Specialist preparation workshop designed to teach you proficiency in using beginner Word features and functions, such as how to: " format text in sections and columns " draw and modify tables " import data from Excel into Word " create and use paragraph styles, and use the outline feature, document maps, and auto text entries " create headers and footers, and use the page numbers dialog box " insert graphics, files, WordArt, symbols, and watermarks in a document; " use the drawing canvas and the diagram gallery " use and customize templates to create consistent-looking documents " compare and merge documents, and work with comments " use advanced printing options, and print labels and envelopes Prerequisites: Word Level I or equivalent knowledge.
    ShareCECM 278 - Level II
    Favorite

  • CECM 279: Level III

    3.00 Credits
    Tompkins Cortland Community College

    Word 2003 Level III is a MOS preparation workshop designed to teach you proficiency in using more advanced Word features and functions, such as how to: * use the Mail Merge Wizard to create form letters, add fields to a form letter, use data source files to sort and query data, and create mailing labels * create, modify, protect, and use forms * create a master document, table of contents, table of figures, endnotes and footnotes, index, bookmarks, and cross-references in documents * track changes in a document; create, save, and compare document versions; and insert, edit, and delete comments * record and run macros to automate tasks, modify and delete macros, create and delete custom menus and toolbars, and add buttons to toolbars Prerequisites: Word Level II or equivalent knowledge.
    ShareCECM 279 - Level III
    Favorite

  • CECM 280: Level I

    3.00 Credits
    Tompkins Cortland Community College

    Excel 2003 Level I complies with Microsoft Office Specialist requirements and is designed to teach you proficiency in using beginner Excel features and functions, such as how to: * Start MS Excel and identify the main components of the Excel Window and Excel workbook, and use the Help feature * Enter and edit labels, values, and formulas into worksheet, use the Undo and Redo commands, and find and replace a formula * Move and copy data, insert and/delete ranges, and work with relative and absolute references when creating and copying formulas * Use functions such as SUM, AVERAGE, MIN, and MAX to perform calculations in a worksheet and use the AutoSum feature * Format text, numbers, rows and columns in a worksheet * Preview and control Page Setup options for a worksheet, print a worksheet, and set and clear a print area * Create, format, modify, and print charts based on worksheet data * Save a worksheet as a web page, use the Auto Republish feature, insert and edit hyperlinks in worksheets, and send a workbook via email Prerequisites: Introduction to Windows or equivalent knowledge.
    ShareCECM 280 - Level I
    Favorite

  • CECM 281: Level II

    3.00 Credits
    Tompkins Cortland Community College

    Excel 2003 Level II is a MOS preparation workshop designed to teach you proficiency in using intermediate Excel features and functions, such as how to: * Navigate large worksheets effectively by using magnification, frozen panes and control the printing of large worksheets * Navigate, manage, and print multiple worksheets, link workbooks by using 3-D formulas, and summarize data by using the Consolidate command * Change the settings of Excel and customize toolbars and menus * Format data points, create combination charts and trend lines, and add and format graphic elements * Add borders and shading, apply special formats, create, apply, and modify styles, and change the orientation of cells * Sort lists by columns and filter lists based on complex criteria * Add comments and text boxes, use the auditing features, and protect a worksheet or part of a worksheet * Create and manage custom templates Prerequisites: Excel Level I or equivalent knowledge
    ShareCECM 281 - Level II
    Favorite

  • CECM 282: Level III

    3.00 Credits
    Tompkins Cortland Community College

    Excel 2003 Level III is a MOS preparation workshop designed to teach you proficiency in using more advanced Excel features and functions, such as how to: * use names to assign descriptive labels to cells; use logical and financial functions to calculate values based on conditions * use lookup functions to return values from table * use data tables to view the effects of multiple input values on a formula * use data forms and validation to facilitate data entry in lists * create and use Pivot Tables to analyze and compare large amounts of data * import data from and export data to external databases * use Goal Seek and Solver to perform what-if analyses, and use custom scenarios and views to manage different versions of worksheets * run and record macros to automate complex or repetitive tasks * publish a worksheet as an interactive web page Prerequisites: Excel Level II or equivalent knowledge
    ShareCECM 282 - Level III
    Favorite

  • CECM 283: Level I

    3.00 Credits
    Tompkins Cortland Community College

    Access 2003 Level I is a MOS preparation workshop designed to teach you proficiency in using beginner Access features and functions, such as how to: * use database terminology, plan the design of a database, and use the Help feature * create and save databases, create a table, and set the primary key * use Datasheet view and Design view * modify a table's design; add, delete, sort, and filter records create simple queries and design complex queries to perform calculations * create, use and modify forms * create, modify, and print reports * import and export database objects and XML documents, and link database objects
    ShareCECM 283 - Level I
    Favorite

  • CECM 284: Level II

    3.00 Credits
    Tompkins Cortland Community College

    Access 2003 Level II is a MOS preparation workshop designed to teach you proficiency in using intermediate Access features and functions, such as how to: * normalize tables to reduce redundancy, set relationships between tables, and implement referential integrity * use the Lookup Wizard to create lookup lists in table design view and use sub datasheets to enter data in related tables * create an input mask in design view, use the Input Mask Wizard, set different properties of a field in design view, and set validation rules for entering data in a field * create self-joins, inner joins, and outer joins, create calculated fields in a query, create queries to add, modify, and delete data from tables, and create queries to create a new table * use queries to view summarized and grouped data from tables, create cross tab queries to summarize grouped data, create parameter queries, and set indexes in a table * use controls to add graphics and calculated fields to a form, add combo boxes to a form, and add unbound controls to a form * customize headers and footers in a report, use the Hide Duplicates property in a report, use functions to add calculated values, and use sub reports to view data from related tables in a report * create and modify charts in forms and reports Prerequisites: Introduction to Windows or equivalent knowledge.
    ShareCECM 284 - Level II
    Favorite

  • CECM 285: Level III

    3.00 Credits
    Tompkins Cortland Community College

    Access 2003 Level III is a MOS preparation workshop designed to teach you proficiency in using more advanced Access features and functions, such as how to: * create Pivot Tables and Pivot Charts for analyzing and comparing large amounts of data * create and use an advanced form by adding a tab control, an option group control, and a subform to it * create and use a macro to open database objects and attach a macro to a command button * create and use macros to automate user-interaction by using the Condition column and SetValue action * use Structured Query Language (SQL) to create queries in Access * use hyperlink and data access pages to link an Access database to the Internet or intranet * work with database utilities to optimize resources and secure data, and use security features to encrypt data from other applications * secure a database by setting a password and specifying user-level and object-level permissions Prerequisites: Access Level II or equivalent knowledge.
    ShareCECM 285 - Level III
    Favorite

  • CECM 286: Level I

    3.00 Credits
    Tompkins Cortland Community College

    PowerPoint 2003 Level I is a Microsoft Office Specialist preparation workshop designed to teach you proficiency in using beginner level of PowerPoint features and functions, such as how to: " explore PowerPoint environment group control and use help options " create a new presentation, add new slides, save and update changes, work in the outline tab to rearrange bullets, rearrange and delete slides, and insert slides from another presentation " create objects by using the drawing toolbar, add and edit auto shapes " use the word art toolbar to enhance text in a presentation, and insert and explore clip art on the web pages " add a table, use Microsoft Graph, and create a chart " apply a design template, add, edit and delete a slide master, work with multiple slide masters, adjust the pace of a presentation, and add speaker notes and footers to each slide in a presentation " hide slides, print a presentation, export to Microsoft Word format, save a presentation for web delivery, and add a link to another presentation. Prerequisites: Introduction to Windows or equivalent knowledge.
    ShareCECM 286 - Level I
    Favorite
To find college, community college and university courses by keyword, enter some or all of the following, then select the Search button.
(Type the name of a College, University, Exam, or Corporation)
(For example: Accounting, Psychology)
(For example: ACCT 101, where Course Prefix is ACCT, and Course Number is 101)
(For example: Introduction To Accounting)
(For example: Sine waves, Hemingway, or Impressionism)
Distance:
of
(For example: Find all institutions within 5 miles of the selected Zip Code)