instructional

Instructional Technology Training Workshops

Training Each workshop will take about an hour.

Please check your calendar and call Jiang Tan at -5869
to schedule a workshop at your own convenience!
WD 2007
New Features
 		The biggest change in Word 2007 is the new user interface. Instead of Menu Bars, Tool Bars, and Task Panes, have been replaced by the Ribbon and Office Button. This workshop discusses how to use the Ribbon and Office button in Word, as well as other new features designed to help you produce professional-looking documents.
WD 2007 I


 		Upon successful completion of this course, you will be able to:
  • create a simple document using MS Word 2007, save a document, use some automatic text features for entering text, and access online help.
  • edit a document using a variety of techniques.
  • change the appearance of a document by applying various character formats and effects.
  • change the appearance of a document by applying various paragraph formats and effects.
WD 2007 II




 Upon successful completion of this course, you will be able to:
  • create columns and organize your document in columns
  • add a table to a Word document and use different table features.
  • create a newsletter using columns, sections, and graphics.
  • use Word's templates and wizards, proofing tools, and special characters to efficiently do your work.
  • include comments in a document and compare and merge documents.
  • create and update a Table of Contents
  • use reference and citation
WD 2007 III




 Upon successful completion of this course, you will be able to:
  • enhance a table by sorting and calculating table data, and creating charts based on various table data.
  • insert, manipulate, and format graphic images.
  • use the Mail Merge Wizard to mail merge form letters, complete with mailing labels.
  • create and edit a bookmark and hyperlink,
  • use Drawing tools, SmartArt, WordArt, and Text box.
Excel 2007
New Features

 The most noticeable change in Excel 2007 as in Word is the Ribbon and Office button, which display in place of the familiar toolbars and menus used in the past. in this workshop, we'll discuss some of the new features and how easily you can transit to Excel 07.
Excel 2007 I

 Upon successful completion of this course, you will be able to:
  • Excel 2007 Environment
  • get start with Excel
  • format an Excel worksheet
  • enter and format cell contents
  • navigate within and between worksheets
  • use simple functions to do calculations
Excel 2007 II




 Upon successful completion of this course, you will be able to:
  • use Excel Templates and create your own template.
  • customize Excel by exploring Excel Options
  • manipulate data
  • manipulate workbook
  • work with charts and graphics
  • customize Excel layout
Excel 2007 III Upon successful completion of this course, you will be able to perform calculation such as:
  • calculate Across Worksheets;
  • calculate with Date and Time Functions;
  • calculate with Financial Functions;
  • calculate with Lookup and Reference Functions;
  • calculate with Logical Functions;
Access 2007
New Features
If you’ve switched to Microsoft Access 2007 from an earlier version, you should immediately notice some major changes in the user interface. In this workshop, we’ll walk you through some major new features of Access 2007 such as:
  • Enhanced templates for getting started quickly
  • Easy spreadsheet-style data entry
  • Layout view for designing forms
  • User-oriented Office Ribbon interface
Access 2007 I

Upon successful completion of this course, you will be able to:
  • create simple Access Database
  • understand the concepts of Access Table, Query, Form, and Report.
  • design an Access Table
  • create a simple Query, Form, and Report.
Access 2007 II

Upon successful completion of this course, you will be able to:
  • format an Access Table
  • format data property in design view
  • specify Query questions
  • create a Query, Form, and Report using design Wizard.
Access 2007 III

Upon successful completion of this course, you will be able to:
  • Update an Access Database
  • Create relationship between tables
  • Perform calculation and statistics
  • Integrate Excel tables into Access database
PowerPoint 2007
New Features

 As in other Office 2007 applications, the new user interface gives PPT 07 a new new look. PowerPoint gets arty as mostly commented. This course discusses how to use the new features designed to help you create presentations quickly and easily.
PowerPoint 2007 I
Upon successful completion of this course, you will be able to
  • create a basic presentation:
  • customize your PPT presentation
  • Format slides and text;
  • work with slideshow contents
  • formatting text;
  • print out slides;
  • show your presentation.
PowerPoint 2007 II








 After completing this course, you will be able to:
  • add graphics and editing graphics in slides
  • add SmartArt and Photo Album
  • Use Master slides to provide a standard appearance
  • Add headers and footers to your presentation
  • Apply animation schemes
  • Add sound and video to presentations
  • Add hyperlinks
Gradebook-Excel


This workshop will introduce the techniques of creating a gradebook using Excel. By presetting the formulas, during the whole semester, instructors will only have to enter students' raw score. Excel will calculate the total and convert numeral grades into letter grades automatically at the end of the semester. Using Excel Template will save instructor time entering formulas every semester.
Click here to see a sample Gradebook.

Podcasting
This workshop will show you how to record your speech or lecture into a computer and post it onto a website or your Blackboard course, namely Podcasting.

ANGEL Learning
 ANGEL is our official Course Management System at Cobleskill. If you want to learn how to use the program, please go to this site for schedules: ANGEL Training Schedule