Classroom and Office Technologies
 

Instructional Technology Training Workshops

Each workshop will last for an hour. Please check your calendar and
fill the form with the time convenient for you!
Click here to Register

SUNY Cobleskill
 
Blackboard Entry
 
Faculty Banner Web
   
IT Services
 
SUNY Training Center
   
Employee SharePoint
 
Student SharePoint
 
Sign up Online
 
Workshop Outlines


State University of New York

WD 2007
New Features
 

 Register

 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


 

Register

 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.

WD 2007
II


 




 Register

 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


 



Register

 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

 Register

 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

 

 


Register

 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




Register

 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

 



Register

 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



 

Register

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




Register

 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




Register

 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




Register

 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

Register

 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
 

 




Register

 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








Register

 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




 Register

 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.
 

Blackboard
Gradebook

 Register

 The Blackboard Gradebook enables Instructors to manage Gradebook display settings and options, grade weighting, and grade downloads and uploads. It also opens to the View Spreadsheet page where organizing grades can be made easier. This workshop will introduce these features.

Podcasting


 Register

 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.

Back to the top

Please fill the form to Register
 
First Name:
 Last Name: Phone: Email: Dept
Workshop: Month/Date
 Time: e.g. 8:00-9:00 Comments:    
 

            

 

SUNY Cobleskill  |  Blackboard Entry  |  Cobleskill WebMail  |  Faculty Banner Web  |  Information Technology (ITS)  |  SUNY Training Center  |  Workshop Outlines|