CIS Training Center

CIS Training Center http://cistraining.unh.edu Upcoming courses and events. en Mon, 23 Nov 2009 08:40:11 GMT Outlook 2007: Level 2: Mon., November 30, 2009, 1:00pm-3:00pm Outlook 2007 has some fantastic new calendaring features. Join us for a hands-on session to learn all about it. You will also learn how to use OWA (Outlook Web Access) to access your Exchange E-mail account from anywhere in the world. Other new features of Outlook 2007 will also be discussed. Topics Covered:<ul><li>Planning a Meeting - View availability of any combination of invitees </li><li>Sending/ Accepting/ Declining meeting invitations</li><li>Outlook Meeting Requests</li><li>Essential Do's and Don'ts</li><li>Creating Recurring Meetings or Appointments</li><li>Scheduling Resources Using Public Folders and Group Folders</li><li>Archiving</li><li>Setting up your SPAM folder</li><li>Delegating access permissions to your calendar</li><li>Using Outlook Web Access and Outlook with VPN to check your E-mail remotely. </li></ul> https://cistraining.unh.edu/sessions/5130.html WebIntelligence: Accessing Finance Reporting: Tue., December 1, 2009, 9:00am-11:00am Training for USNH's web-based reporting tool for Banner Finance data. Users will learn how to access and run parameter-driven reports from the available library of reports, using data from the Banner Finance area. Note: Previously, WebI was supported for use on Windows only, partly because the VPN, which is needed to access WebI, must run on Windows. However, CIS recently committed to supporting dual-platform functionality. Thus, if a user’s Mac is able to run a supported version of Windows, it may be possible to use it for WebI. For more information, call 2-4242.   https://cistraining.unh.edu/sessions/5066.html Banner Student: The Basics: Tue., December 1, 2009, 2:30pm-4:30pm This hands-on session will be a review of the Banner: Student Information System (SIS). Navigating through the system will be emphasized. https://cistraining.unh.edu/sessions/5135.html Introduction to Leopard: Wed., December 2, 2009, 9:00am-11:00am Join us for a demonstration of the new features of Leopard, the newest operating system from Apple. This class is tailored to those who are considering purchasing or have recently upgraded or purchased a new computer with Leopard. Topics include: <ul><li>Navigating and using the new interface</li><li>Minimum hardware requirements to upgrade</li><li>Running Windows on your Mac</li><li>Tips 'n tricks and more</li></ul> https://cistraining.unh.edu/sessions/5180.html WebIntelligence: Accessing UNH Student Reporting: Wed., December 2, 2009, 2:00pm-4:00pm Training for UNH's web-based reporting tool for Banner Student data. Users will learn how to access and run parameter-driven reports from the available library of reports, using data from the Banner Student area. Note: Previously,WebI was supported for use on Windows only, partly because the VPN, which is needed to access WebI, must run on Windows. However, CIS recently committed to supporting dual-platform functionality. Thus, if a user’s Mac is able to run a supported version of Windows, it may be possible to use it for WebI. For more information, call 2-4242. https://cistraining.unh.edu/sessions/5067.html Outlook 2007: Level 1: Fri., December 4, 2009, 9:00am-11:00am This session will present an overview of the various modules in Outlook 2007 followed by hands-on exercises. Exercises include:<ul><li>Creating a Contact </li><li>Sending E-mail with an Attachment</li><li>Creating a Distribution List</li><li>Creating a Task and Setting a Reminder</li><li>Creating a Subfolder</li><li>Setting a Recurring Event </li><li>Planning a Meeting </li></ul> https://cistraining.unh.edu/sessions/5138.html WebIntelligence: Creating UNH Student Reports: Wed., December 9, 2009, 2:00pm-4:00pm In this hands-on session, users will learn the basics of creating a WebIntelligence report in the Java Report Panel, using data from the UNH Student universe. Note: Previously, WebI was supported for use on Windows only, partly because the VPN, which is needed to access WebI, must run on Windows. However, CIS recently committed to supporting dual-platform functionality. Thus, if a user’s Mac is able to run a supported version of Windows, it may be possible to use it for WebI. For more information, call 2-4242. https://cistraining.unh.edu/sessions/5068.html Banner Finance: Accounting Document Processing: Thu., December 10, 2009, 9:00am-11:00am This hands-on course will demonstrate and provide practice for processing, approving, and querying accounting documents such as journal entries and cash receipts using the Banner: Finance system. https://cistraining.unh.edu/sessions/5134.html Banner Finance: Navigation: Fri., December 11, 2009, 8:30am-10:30am This course will show users how to access and log-in to Banner. It will familiarize users with Banner navigation terms such as "next block" and "query enter", and will explain the naming convention for Banner screens and reports. This hands-on session allows users to practice moving through the Banner system and is a prerequisite for the other hands-on training modules. https://cistraining.unh.edu/sessions/5131.html Banner Finance: Requisitions/POs/Change Orders: Fri., December 11, 2009, 10:30am-12:00pm This hands-on course will explain how to create and cancel requisitions using Banner: Finance. It will also show how to modify a purchase order with a change order, how to delete a change order and will cover basic queries used for locating information about requisitions and purchase orders. https://cistraining.unh.edu/sessions/5133.html Excel 2007: Level 2: Mon., December 14, 2009, 9:00am-4:00pm Overview: In this course, students use Excel® 2007 to streamline and enhance spreadsheets with templates, charts, graphics, and formulas. They will apply visual elements and advanced formulas to a worksheet to display data in various formats.<table border="0" width="100%" class="lcTable"><tbody><tr><td>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003010&partNumber=3164LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Calculating Data with Advanced Formulas</td></tr><tr><td style="padding-left: 60px">Manage Cell and Range Names Calculate Data Across Worksheets Use Specialized Functions Analyze Data with Logical and Lookup Functions </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003010&partNumber=3164LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 2: Organizing Worksheet and Table Data </td></tr><tr><td style="padding-left: 60px">Create and Modify Tables Format Tables Sort or Filter Worksheet or Table Data Calculate Data in a Table or Worksheet </td></tr><tr><td style="padding-left: 30px">Lesson 3: Presenting Data Using Charts</td></tr><tr><td style="padding-left: 60px">Create a Chart Modify Charts Format Charts </td></tr><tr><td style="padding-left: 30px">Lesson 4: Analyzing Data Using PivotTables and PivotCharts</td></tr><tr><td style="padding-left: 60px">Create a PivotTable Report Analyze Data Using PivotCharts </td></tr><tr><td style="padding-left: 30px">Lesson 5: Inserting Graphic Objects</td></tr><tr><td style="padding-left: 60px">Insert and Modify Pictures and ClipArt Draw and Modify Shapes Illustrate Workflow Using SmartArt Graphics Layer and Group Graphic Objects </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment</td></tr><tr><td style="padding-left: 60px">Customize the Excel Environment Customize Workbooks Manage Themes Create and Use Templates </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5089.html Essentials for Successful Buying - How to Buy Goods & Services at the University: Tue., December 15, 2009, 10:00am-12:00pm Review purchasing objectives, UNH guidelines and resources available. Topics covered: <ul><li>Determining your needs/requirements </li><li>Identifying suppliers/vendors to meet your needs </li><li>Goods/services available on campus through UNH </li><li>Contracts available through outside vendors </li><li>Vendor relations-getting quotes, negotiating and selecting vendors </li><li>Understanding terms and conditions of a vendor quotation </li><li>Methods available for placing your order </li><li>Independent contractors - contracting for services </li><li>Understanding the bid limit and when a formal bid is required </li><li>Purchasing code of ethics </li><li>Resources available through UNH/USNH Purchasing & Contract Services</li></ul> https://cistraining.unh.edu/sessions/5082.html WebIntelligence: Creating Finance Reports: Wed., December 16, 2009, 9:00am-11:30am In this hands-on session, users will learn the basics of creating a WebIntelligence report in the Java Report Panel, using data from the Finance universe. Note: Previously, WebI was supported for use on Windows only, partly because the VPN, which is needed to access WebI, must run on Windows. However, CIS recently committed to supporting dual-platform functionality. Thus, if a user’s Mac is able to run a supported version of Windows, it may be possible to use it for WebI. For more information, call 2-4242. https://cistraining.unh.edu/sessions/5069.html Xtender Web Access: Accessing Imaged Documents: Thu., December 17, 2009, 9:00am-11:00am In this hands-on session, users will learn the basics of navigating and viewing imaged documents in Xtender Web Access. https://cistraining.unh.edu/sessions/5157.html Banner H/R: Payroll Entry: Mon., December 21, 2009, 1:00pm-3:00pm This hands-on session will cover Positive Pay and Exception Time Entry for USNH employees. https://cistraining.unh.edu/sessions/5137.html Banner Finance: Regular Invoicing: Mon., December 21, 2009, 3:00pm-4:30pm This hands-on course will explain how to process invoices applicable to Purchase Orders, including scheduling payment dates, vendor invoice numbering, enclosures and disbursement codes. Also covered will be credit memos, invoice approvals, and querying invoices. https://cistraining.unh.edu/sessions/5132.html Banner H/R: EPAF Entry: Tue., December 22, 2009, 9:00am-11:00am This hands-on session will review approval categories and associated data required to complete an Electronic Personnel Action Form (EPAF) for USNH employees. https://cistraining.unh.edu/sessions/5136.html Outlook 2007: Level 2: Tue., December 22, 2009, 2:30pm-4:30pm Outlook 2007 has some fantastic new calendaring features. Join us for a hands-on session to learn all about it. You will also learn how to use OWA (Outlook Web Access) to access your Exchange E-mail account from anywhere in the world. Other new features of Outlook 2007 will also be discussed. Topics Covered:<ul><li>Planning a Meeting - View availability of any combination of invitees </li><li>Sending/ Accepting/ Declining meeting invitations</li><li>Outlook Meeting Requests</li><li>Essential Do's and Don'ts</li><li>Creating Recurring Meetings or Appointments</li><li>Scheduling Resources Using Public Folders and Group Folders</li><li>Archiving</li><li>Setting up your SPAM folder</li><li>Delegating access permissions to your calendar</li><li>Using Outlook Web Access and Outlook with VPN to check your E-mail remotely. </li></ul> https://cistraining.unh.edu/sessions/5139.html Crystal Reports XI: Level 1 (2 days): a 2 meeting session, starting with Mon., January 4, 2010, 9:00am-4:00pm Overview: In this course, students will build basic list and group reports that work with almost any database. <table border="0" width="100%" class="lcTable"><tbody><tr><td>Outline:</td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 1: Creating a Report</td></tr><tr><td style="padding-left: 60px">Set Default Report Settings Specify Fields for a New Report Preview a Report Modify Field Display Add a Report Title Position Fields Add Fields from Other Tables </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200002772&partNumber=NH85517S#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Displaying Specific Report Data</td></tr><tr><td style="padding-left: 60px">Find Data Sort Data Filter Data by a Single Criterion </td></tr><tr><td style="padding-left: 30px">Lesson 3: Grouping Report Data</td></tr><tr><td style="padding-left: 60px">Insert a Group Add Summaries Format Summary Information Change Group Options Add a Second-Level Grouping Filter Records by Group Create a Top N Sort Group </td></tr><tr><td style="padding-left: 30px">Lesson 4: Building Formulas</td></tr><tr><td style="padding-left: 60px">Create a Formula Edit a Formula Combine Fields by Formula Delete a Formula Filter Data by Multiple Criteria Modify a Filter Using an OR Operator Create a Parameter Field Account for Null Fields in a Formula </td></tr><tr><td style="padding-left: 30px">Lesson 5: Formatting Reports</td></tr><tr><td style="padding-left: 60px">Remove White Space Insert Page Header/Footer Data Add Borders, Boxes, and Lines Change Field Background Color Change the Margins </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200002772&partNumber=NH85517S#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Enhancing Reports</td></tr><tr><td style="padding-left: 60px">Add a Watermark Insert Objects Using Object Linking and Embedding Modify Formatting Based on Data Value Suppress Report Sections Insert Hyperlinks Hide Blank Report Sections </td></tr><tr><td style="padding-left: 30px">Lesson 7: Creating Pie Charts</td></tr><tr><td style="padding-left: 60px">Create a Pie Chart with a Drill-Down Modify Chart Text Format a Chart Present a Chart by Group </td></tr><tr><td style="padding-left: 30px">Lesson 8: Distributing Data</td></tr><tr><td style="padding-left: 60px">Export to a PDF File Export to a Microsoft Excel File Export to an Access Database File Export a Report Definition Create Mailing Labels </td></tr></tbody></table> https://cistraining.unh.edu/sessions/5094.html Banner Student: The Basics: Wed., January 6, 2010, 1:00pm-3:00pm This hands-on session will be a review of the Banner: Student Information System (SIS). Navigating through the system will be emphasized. https://cistraining.unh.edu/sessions/5147.html Excel 2007: Level 2: Thu., January 7, 2010, 9:00am-4:00pm Overview: In this course, students use Excel® 2007 to streamline and enhance spreadsheets with templates, charts, graphics, and formulas. They will apply visual elements and advanced formulas to a worksheet to display data in various formats.<table border="0" width="100%" class="lcTable"><tbody><tr><td>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003010&partNumber=3164LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Calculating Data with Advanced Formulas</td></tr><tr><td style="padding-left: 60px">Manage Cell and Range Names Calculate Data Across Worksheets Use Specialized Functions Analyze Data with Logical and Lookup Functions </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003010&partNumber=3164LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 2: Organizing Worksheet and Table Data </td></tr><tr><td style="padding-left: 60px">Create and Modify Tables Format Tables Sort or Filter Worksheet or Table Data Calculate Data in a Table or Worksheet </td></tr><tr><td style="padding-left: 30px">Lesson 3: Presenting Data Using Charts</td></tr><tr><td style="padding-left: 60px">Create a Chart Modify Charts Format Charts </td></tr><tr><td style="padding-left: 30px">Lesson 4: Analyzing Data Using PivotTables and PivotCharts</td></tr><tr><td style="padding-left: 60px">Create a PivotTable Report Analyze Data Using PivotCharts </td></tr><tr><td style="padding-left: 30px">Lesson 5: Inserting Graphic Objects</td></tr><tr><td style="padding-left: 60px">Insert and Modify Pictures and ClipArt Draw and Modify Shapes Illustrate Workflow Using SmartArt Graphics Layer and Group Graphic Objects </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment</td></tr><tr><td style="padding-left: 60px">Customize the Excel Environment Customize Workbooks Manage Themes Create and Use Templates </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5097.html InDesign CS3: Level 2: Fri., January 8, 2010, 9:00am-4:00pm <a name="over" title="over"></a>Overview: In this course, students will deploy the advanced InDesign techniques to enhance the look and functionality of their documents. They will use the advanced features of Adobe InDesign CS3 to create and design content for print and web.<table border="0" width="100%" class="lcTable"><tbody><tr><td><a name="syll" title="syll"></a>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003250&partNumber=3287LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Managing Styles</td></tr><tr><td style="padding-left: 60px">Manage Style Overrides Base One Style on Another Apply Styles in a Sequence Import Styles from a Word Document Redefine Styles </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003250&partNumber=3287LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 2: Developing Complex Paths</td></tr><tr><td style="padding-left: 60px">Create Bézier Paths Create Compound Paths Create Clipping Paths Create Type Outlines </td></tr><tr><td style="padding-left: 30px">Lesson 3: Handling Page Elements</td></tr><tr><td style="padding-left: 60px">Place Inline Graphics Manipulate Graphics Handle Text Layout Create Duplicate Items Create Anchored Objects Manage Libraries </td></tr><tr><td style="padding-left: 30px">Lesson 4: Administering External Files</td></tr><tr><td style="padding-left: 60px">Locate Assets Using Adobe Bridge Merge Data Import Layered Files Export PDF Files Export XHTML Files </td></tr><tr><td style="padding-left: 30px">Lesson 5: Working with XML</td></tr><tr><td style="padding-left: 60px">Integrate XML into a Document Import XML Export Documents as XML Files Create a Snippet </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003250&partNumber=3287LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 6: Managing Long Documents</td></tr><tr><td style="padding-left: 60px">Create Hyperlinks Insert Footnotes Insert Text Variables Create the Table of Contents Generate an Index Create Document Sections Create a Book </td></tr><tr><td style="padding-left: 30px">Lesson 7: Adjusting Print Settings</td></tr><tr><td style="padding-left: 60px">Create Print Presets Preview Print Output </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5095.html Banner Finance: Navigation: Mon., January 11, 2010, 1:00pm-3:00pm This course will show users how to access and log-in to Banner. It will familiarize users with Banner navigation terms such as "next block" and "query enter", and will explain the naming convention for Banner screens and reports. This hands-on session allows users to practice moving through the Banner system and is a prerequisite for the other hands-on training modules. https://cistraining.unh.edu/sessions/5143.html Banner Finance: Regular Invoicing: Mon., January 11, 2010, 3:00pm-4:30pm This hands-on course will explain how to process invoices applicable to Purchase Orders, including scheduling payment dates, vendor invoice numbering, enclosures and disbursement codes. Also covered will be credit memos, invoice approvals, and querying invoices. https://cistraining.unh.edu/sessions/5144.html Xtender Web Access: Accessing Imaged Documents: Tue., January 12, 2010, 10:00am-12:00pm In this hands-on session, users will learn the basics of navigating and viewing imaged documents in Xtender Web Access. https://cistraining.unh.edu/sessions/5158.html Outlook 2007: Level 1: Tue., January 12, 2010, 2:30pm-4:30pm This session will present an overview of the various modules in Outlook 2007 followed by hands-on exercises. Exercises include:<ul><li>Creating a Contact </li><li>Sending E-mail with an Attachment</li><li>Creating a Distribution List</li><li>Creating a Task and Setting a Reminder</li><li>Creating a Subfolder</li><li>Setting a Recurring Event </li><li>Planning a Meeting </li></ul> https://cistraining.unh.edu/sessions/5150.html Banner H/R: EPAF Entry: Wed., January 13, 2010, 2:00pm-4:00pm This hands-on session will review approval categories and associated data required to complete an Electronic Personnel Action Form (EPAF) for USNH employees. https://cistraining.unh.edu/sessions/5148.html Excel 2007 - Introduction to VBA: Fri., January 15, 2010, 9:00am-4:00pm In this one-day course, students will learn how to simplify their work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development. Course Outline <table border="0" cellspacing="0" cellpadding="0" width="100%" class="MsoNormalTable" style="width: 100%; border-collapse: collapse"><tbody><tr><td style="background: #fffbd6; border: #ece9d8; padding: 3pt">Lesson 1: Developing Macros<ul><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create a Macro with the Macro Recorder </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Edit a Macro </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Debug a Macro </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Customize the Quick Access Toolbar and Hotkeys</div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Work with Macro Security</div></li></ul></td></tr><tr><td style="background: white; border: #ece9d8; padding: 3pt">Lesson 2: Formatting Worksheets Using Macros<ul><li>Insert Text </li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Format Text </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Sort Data</div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Duplicate Data </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Generate a Report</div></li></ul></td></tr><tr><td style="background: #fffbd6; border: #ece9d8; padding: 3pt">Lesson 3: Creating an Interactive Worksheet<ul><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Determine the Dialog Box Type </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Capture User Input</div></li></ul></td></tr><tr><td style="background: white; border: #ece9d8; padding: 3pt">Lesson 4: Working with Multiple Worksheets<ul><li><div class="MsoNormal" style="margin: 0in 0in 0pt"> Insert, Copy, and Delete Worksheets </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Rename Worksheets </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Modify the Order of Worksheets </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Print Worksheets</div></li></ul></td></tr><tr><td style="background: #fffbd6; border: #ece9d8; padding: 3pt">Lesson 5: Performing Calculations <ul><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create User-defined Functions </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Automate SUM Functions</div></li></ul></td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5110.html Banner H/R: Payroll Entry: Tue., January 19, 2010, 9:00am-11:00am This hands-on session will cover Positive Pay and Exception Time Entry for USNH employees. https://cistraining.unh.edu/sessions/5149.html Outlook 2007: Level 2: Thu., January 21, 2010, 9:00am-11:00am Outlook 2007 has some fantastic new calendaring features. Join us for a hands-on session to learn all about it. You will also learn how to use OWA (Outlook Web Access) to access your Exchange E-mail account from anywhere in the world. Other new features of Outlook 2007 will also be discussed. Topics Covered:<ul><li>Planning a Meeting - View availability of any combination of invitees </li><li>Sending/ Accepting/ Declining meeting invitations</li><li>Outlook Meeting Requests</li><li>Essential Do's and Don'ts</li><li>Creating Recurring Meetings or Appointments</li><li>Scheduling Resources Using Public Folders and Group Folders</li><li>Archiving</li><li>Setting up your SPAM folder</li><li>Delegating access permissions to your calendar</li><li>Using Outlook Web Access and Outlook with VPN to check your E-mail remotely. </li></ul> https://cistraining.unh.edu/sessions/5152.html Dreamweaver CS3: Level 2: Mon., January 25, 2010, 9:00am-4:00pm Overview: In this course, students will use the advanced features of Dreamweaver CS3 to design and develop professional-looking websites.<table border="0" width="100%" class="lcTable"><tbody><tr><td><a name="syll" title="syll"></a>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003192&partNumber=3237LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Working in Code View</td></tr><tr><td style="padding-left: 60px">Use Coding Tools Search for and Replace Code Use Design Notes and Comments </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003192&partNumber=3237LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 2: Formatting with Style Sheets</td></tr><tr><td style="padding-left: 60px">Create CSS Styles Apply External Styles to Multiple Pages Redefine Style Sheets </td></tr><tr><td style="padding-left: 30px">Lesson 3: Creating an Effective User-Navigation Interface</td></tr><tr><td style="padding-left: 60px">Create Rollovers Create a Navigation Bar Add Flash Buttons and Text to a Page Use the Spry User Interface Widgets Add Spry Effects </td></tr><tr><td style="padding-left: 30px">Lesson 4: Working with AP Elements</td></tr><tr><td style="padding-left: 60px">Create AP Elements Control AP Elements Dynamically Insert Rich Media Objects into an AP Element </td></tr><tr><td style="padding-left: 30px">Lesson 5: Automating Tasks</td></tr><tr><td style="padding-left: 60px">Add Library Items from Site Pages Place Library Items onto Site Pages Use Snippets Replay Actions Using the History Panel </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003192&partNumber=3237LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 6: Creating Forms</td></tr><tr><td style="padding-left: 60px">Set Up Forms Add Form Elements Validate Forms </td></tr><tr><td style="padding-left: 30px">Lesson 7: Authoring with XML-Based Data</td></tr><tr><td style="padding-left: 60px">Integrate XML-Based Data Display XML Data Using Spry </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5098.html Excel 2007: Level 3: Tue., January 26, 2010, 9:00am-4:00pm Overview: In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.<table border="0" width="100%" class="lcTable"><tbody><tr><td>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003011&partNumber=3165LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Streamlining Workflow </td></tr><tr><td style="padding-left: 60px">Create a Macro Edit a Macro Apply Conditional Formatting Add Data Validation Criteria Update a Workbook's Properties Modify Excel's Default Settings </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003011&partNumber=3165LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 2: Collaborating with Others </td></tr><tr><td style="padding-left: 60px">Protect Files Share a Workbook Set Revision Tracking Review Tracked Revisions Merge Workbooks Administer Digital Signatures Restrict Document Access </td></tr><tr><td style="padding-left: 30px">Lesson 3: Auditing Worksheets </td></tr><tr><td style="padding-left: 60px">Trace Cells Troubleshoot Errors in Formulas Troubleshoot Invalid Data and Formulas Watch and Evaluate Formulas Create a Data List Outline </td></tr><tr><td style="padding-left: 30px">Lesson 4: Analyzing Data </td></tr><tr><td style="padding-left: 60px">Create a Trendline Create Scenarios Perform What-If Analysis Perform Statistical Analysis with the Analysis ToolPak </td></tr><tr><td style="padding-left: 30px">Lesson 5: Working with Multiple Workbooks </td></tr><tr><td style="padding-left: 60px">Create a Workspace Consolidate Data Link Cells in Different Workbooks Edit Links </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003011&partNumber=3165LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 6: Importing and Exporting Data </td></tr><tr><td style="padding-left: 60px">Export Excel Data Import a Delimited Text File </td></tr><tr><td style="padding-left: 30px">Lesson 7: Using Excel with the Web </td></tr><tr><td style="padding-left: 60px">Publish a Worksheet to the Web Import Data from the Web Create a Web Query </td></tr><tr><td style="padding-left: 30px">Lesson 8: Structuring XML Workbooks</td></tr><tr><td style="padding-left: 60px">Develop XML Maps Import and Export XML Data </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5161.html Banner Finance: Requisitions/POs/Change Orders: Wed., January 27, 2010, 1:00pm-3:00pm This hands-on course will explain how to create and cancel requisitions using Banner: Finance. It will also show how to modify a purchase order with a change order, how to delete a change order and will cover basic queries used for locating information about requisitions and purchase orders. https://cistraining.unh.edu/sessions/5145.html Banner Finance: Accounting Document Processing: Wed., January 27, 2010, 3:00pm-4:30pm This hands-on course will demonstrate and provide practice for processing, approving, and querying accounting documents such as journal entries and cash receipts using the Banner: Finance system. https://cistraining.unh.edu/sessions/5146.html Photoshop CS3: Level 1 (2 days): a 2 meeting session, starting with Thu., January 28, 2010, 9:00am-4:00pm <a name="over" title="over"></a>Overview: In this course, students will use the several tools and features of Photoshop CS3 to work with images.<table border="0" width="100%" class="lcTable"><tbody><tr><td><a name="syll" title="syll"></a>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003193&partNumber=3242LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 1: Exploring the Photoshop Environment</td></tr><tr><td style="padding-left: 60px">Explore the Photoshop Interface Customize the Workspace Explore the Navigation Tools </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003193&partNumber=3242LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Working with Image Areas</td></tr><tr><td style="padding-left: 60px">Select Image Areas Save a Selection Modify a Selection </td></tr><tr><td style="padding-left: 30px">Lesson 3: Working with Layers</td></tr><tr><td style="padding-left: 60px">Create Layers Create Type Layers Transform Layers Alter Type Properties Apply Layer Styles Undo Previous Steps Arrange and Group Layers </td></tr><tr><td style="padding-left: 30px">Lesson 4: Enhancing Images</td></tr><tr><td style="padding-left: 60px">Paint Strokes on an Image Apply Filter Effects Convert an Image to Black and White Blend Layers Merge Layers and Flatten Images </td></tr><tr><td style="padding-left: 30px">Lesson 5: Saving Images for Web and Print</td></tr><tr><td style="padding-left: 60px">Save Images for Use in Print Applications Save Images for the Web Save Images as PDF </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003193&partNumber=3242LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Managing Assets with Adobe® Bridge</td></tr><tr><td style="padding-left: 60px">Explore Adobe Bridge Work with Adobe Bridge Work with Stacks and Filters in Adobe Bridge Apply Metadata and Keywords to Files </td></tr></tbody></table> https://cistraining.unh.edu/sessions/5099.html Powerpoint 2008 - Level 1 (Mac): Fri., February 5, 2010, 9:00am-4:00pm This course teaches the new mac version of Microsoft Office Powerpoint. https://cistraining.unh.edu/sessions/5181.html Adobe Acrobat 9.0: Level 1: Wed., February 10, 2010, 9:00am-4:00pm <a name="over" title="over"></a>Overview: In this course, students will use Adobe® Acrobat® 9.0 to make the information more portable, accessible, and useful to meet the needs of the target audience. <table border="0" width="100%"><tbody><tr><td><a name="syll" title="syll"></a>Outline:</td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 1: Accessing a PDF Document </td></tr><tr><td style="padding-left: 60px">Open a PDF Document Explore the Adobe Acrobat 9 Pro Interface Browse Through a PDF Document </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Creating PDF Documents </td></tr><tr><td style="padding-left: 60px">Create a PDF Document Using Microsoft Applications Create a PDF Document Using the Print Command Create a PDF Document from Web Pages Create a PDF Document Using Email Applications Create a PDF Document Using Acrobat </td></tr><tr><td style="padding-left: 30px">Lesson 3: Navigating to Specific Content in a PDF Document </td></tr><tr><td style="padding-left: 60px">Conduct a Simple Search Use Bookmarks Work with Links Define Articles </td></tr><tr><td style="padding-left: 30px">Lesson 4: Modifying PDF Documents </td></tr><tr><td style="padding-left: 60px">Manipulate PDF Document Pages Edit Content in a PDF Document Add Page Elements Extract Content from a PDF Document </td></tr><tr><td style="padding-left: 30px">Lesson 5: Working with Multiple PDF Documents </td></tr><tr><td style="padding-left: 60px">Organize PDF Documents into a Collection Redact PDF Documents Search Multiple PDF Documents </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Reviewing a PDF Document </td></tr><tr><td style="padding-left: 60px">Initiate a Review Review a PDF Document Compare PDF Documents </td></tr><tr><td style="padding-left: 30px">Lesson 7: Validating a PDF Document </td></tr><tr><td style="padding-left: 60px">Sign a PDF Document Digitally Verify a Digital ID </td></tr></tbody></table> https://cistraining.unh.edu/sessions/5182.html Photoshop CS3: Level 1 (2 days): a 2 meeting session, starting with Thu., February 11, 2010, 9:00am-4:00pm <a name="over" title="over"></a>Overview: In this course, students will use the several tools and features of Photoshop CS3 to work with images.<table border="0" width="100%" class="lcTable"><tbody><tr><td><a name="syll" title="syll"></a>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003193&partNumber=3242LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 1: Exploring the Photoshop Environment</td></tr><tr><td style="padding-left: 60px">Explore the Photoshop Interface Customize the Workspace Explore the Navigation Tools </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003193&partNumber=3242LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Working with Image Areas</td></tr><tr><td style="padding-left: 60px">Select Image Areas Save a Selection Modify a Selection </td></tr><tr><td style="padding-left: 30px">Lesson 3: Working with Layers</td></tr><tr><td style="padding-left: 60px">Create Layers Create Type Layers Transform Layers Alter Type Properties Apply Layer Styles Undo Previous Steps Arrange and Group Layers </td></tr><tr><td style="padding-left: 30px">Lesson 4: Enhancing Images</td></tr><tr><td style="padding-left: 60px">Paint Strokes on an Image Apply Filter Effects Convert an Image to Black and White Blend Layers Merge Layers and Flatten Images </td></tr><tr><td style="padding-left: 30px">Lesson 5: Saving Images for Web and Print</td></tr><tr><td style="padding-left: 60px">Save Images for Use in Print Applications Save Images for the Web Save Images as PDF </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003193&partNumber=3242LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Managing Assets with Adobe® Bridge</td></tr><tr><td style="padding-left: 60px">Explore Adobe Bridge Work with Adobe Bridge Work with Stacks and Filters in Adobe Bridge Apply Metadata and Keywords to Files </td></tr></tbody></table> https://cistraining.unh.edu/sessions/5204.html Excel 2007: Level 1: Mon., February 15, 2010, 9:00am-4:00pm Overview: In this course, students create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks. <table border="0" width="100%" class="lcTable"><tbody><tr><td>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003009&partNumber=3163LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Creating a Basic Worksheet</td></tr><tr><td style="padding-left: 60px">Explore the User Interface and the Ribbon Navigate and Select in Excel Obtain Help Enter Data and Save a Workbook Customize the Quick Access Toolbar </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Performing Calculations</td></tr><tr><td style="padding-left: 60px">Create Basic Formulas Calculate with Functions Copy Formulas and Functions </td></tr><tr><td style="padding-left: 30px">Lesson 3: Modifying a Worksheet</td></tr><tr><td style="padding-left: 60px">Manipulate Data Insert and Delete Cells, Columns, and Rows Search for Data in a Worksheet Spell Check a Worksheet </td></tr><tr><td style="padding-left: 30px">Lesson 4: Formatting a Worksheet</td></tr><tr><td style="padding-left: 60px">Modify Fonts Add Borders and Color to Cells Change Column Width and Row Height Apply Number Formats Position Cell Contents Apply Cell Styles </td></tr><tr><td style="padding-left: 30px">Lesson 5: Printing Workbook Contents</td></tr><tr><td style="padding-left: 60px">Print Workbook Contents Using Default Print Options Set Print Options Set Page Breaks </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Managing Large Workbooks</td></tr><tr><td style="padding-left: 60px">Format Worksheet Tabs Manage Worksheets in a Workbook Manage the View of Large Worksheets </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5183.html Xtender Web Access: Accessing Imaged Documents: Wed., February 17, 2010, 1:00pm-3:00pm In this hands-on session, users will learn the basics of navigating and viewing imaged documents in Xtender Web Access. https://cistraining.unh.edu/sessions/5207.html Dreamweaver CS3: Level 1: Wed., March 3, 2010, 9:00am-4:00pm <table border="0" width="100%" class="lcTable"><tbody><tr><td>Overview: In this course, students will design, build, and upload a website using Dreamweaver.Outline:</td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 1: Getting Started with Dreamweaver</td></tr><tr><td style="padding-left: 60px">Examine the Basic Concepts of Web Designing Explore the Dreamweaver Environment Customize the Workspace </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Creating a Website </td></tr><tr><td style="padding-left: 60px">Define a Website Create a Web Page Format a Web Page Organize Files and Folders Create Templates </td></tr><tr><td style="padding-left: 30px">Lesson 3: Adding Design Elements to Web Pages</td></tr><tr><td style="padding-left: 60px">Insert Images Insert Tables Create Repeating Region Templates </td></tr><tr><td style="padding-left: 30px">Lesson 4: Working with Links</td></tr><tr><td style="padding-left: 60px">Create Hyperlinks Create Email Links Create Image Maps Create Anchors </td></tr><tr><td style="padding-left: 30px">Lesson 5: Working with Frames</td></tr><tr><td style="padding-left: 60px">Create Framesets Enhance Frames </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Uploading a Website</td></tr><tr><td style="padding-left: 60px">Ensure Accessibility Upload Files onto a Site </td></tr></tbody></table> https://cistraining.unh.edu/sessions/5185.html Flash CS3 - Level 1 (2 days): a 2 meeting session, starting with Wed., March 10, 2010, 9:00am-4:00pm In this course, students create Flash-based movies that contain graphics, text, and animations.<table border="0" cellspacing="0" cellpadding="4" style="width: 100%; color: #333333; border-collapse: collapse" id="dnn_ctr2440_XSSmartModule__ctl0_DataList1"><tbody><tr><td style="color: #333333; background-color: #fffbd6">Lesson 1: Exploring Adobe Flash CS3 <li>  Examine Rich Internet Applications</li><li>  Explore the Adobe Flash CS3 Environment</li><li>  Produce a Flash Application File</li> </td></tr><tr><td style="color: #333333; background-color: white">Lesson 2: Working with Graphics <li>  Import Graphics</li><li>  Create Vector Graphics</li><li>  Modify Vector Graphics</li><li>  Organize Content with Layers</li><li>  Modify Colors</li><li>  Convert Graphics to Symbols</li><li>  Create a Mask Effect</li> </td></tr><tr><td style="color: #333333; background-color: #fffbd6">Lesson 3: Managing Text in a Flash Document <li>  Add Text to a Flash Document</li><li>  Set Font Options</li><li>  Add Input Text Using Flash Components</li><li>  Apply a Skin to a Component</li> </td></tr><tr><td style="color: #333333; background-color: white">Lesson 4: Adding Animations to a Flash Document <li>  Create a Frame-by-Frame Animation</li><li>  Create a Motion Tween Animation</li><li>  Create a Complex Motion Tween</li><li>  Control the Timeline with ActionScript</li><li>  Create a Shape Tween Animation</li><li>  Animate Using Timeline Effects</li> </td></tr><tr><td style="color: #333333; background-color: #fffbd6">Lesson 5: Adding Interactivity to Buttons <li>  Create Buttons</li><li>  Control Movies with Button Behaviors</li><li>  Create Navigation Systems</li> </td></tr><tr><td style="color: #333333; background-color: white">Lesson 6: Working with Movie Clips <li>  Add Interactivity with Movie Clips</li><li>  Create a Flash Slide Presentation</li><li>  Apply Effects to Movie Clips</li> </td></tr><tr><td style="color: #333333; background-color: #fffbd6">Lesson 7: Adding Audio to a Movie <li>  Import Audio</li><li>  Control Sound Playback</li><li>  Add Sounds with Behaviors</li> </td></tr><tr><td style="color: #333333; background-color: white">Lesson 8: Adding Video to a Movie <li>  Encode a Video Object</li><li>  Create a Video Object</li> </td></tr><tr><td style="color: #333333; background-color: #fffbd6">Lesson 9: Publishing Flash Documents <li>  Publish a Flash Document</li><li>  Detect the Flash Player Version</li></td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5186.html Xtender Web Access: Accessing Imaged Documents: Tue., March 16, 2010, 1:00pm-3:00pm In this hands-on session, users will learn the basics of navigating and viewing imaged documents in Xtender Web Access. https://cistraining.unh.edu/sessions/5208.html Excel 2007: Level 2: Wed., March 24, 2010, 9:00am-4:00pm Overview: In this course, students use Excel® 2007 to streamline and enhance spreadsheets with templates, charts, graphics, and formulas. They will apply visual elements and advanced formulas to a worksheet to display data in various formats.<table border="0" width="100%" class="lcTable"><tbody><tr><td>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003010&partNumber=3164LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Calculating Data with Advanced Formulas</td></tr><tr><td style="padding-left: 60px">Manage Cell and Range Names Calculate Data Across Worksheets Use Specialized Functions Analyze Data with Logical and Lookup Functions </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003010&partNumber=3164LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 2: Organizing Worksheet and Table Data </td></tr><tr><td style="padding-left: 60px">Create and Modify Tables Format Tables Sort or Filter Worksheet or Table Data Calculate Data in a Table or Worksheet </td></tr><tr><td style="padding-left: 30px">Lesson 3: Presenting Data Using Charts</td></tr><tr><td style="padding-left: 60px">Create a Chart Modify Charts Format Charts </td></tr><tr><td style="padding-left: 30px">Lesson 4: Analyzing Data Using PivotTables and PivotCharts</td></tr><tr><td style="padding-left: 60px">Create a PivotTable Report Analyze Data Using PivotCharts </td></tr><tr><td style="padding-left: 30px">Lesson 5: Inserting Graphic Objects</td></tr><tr><td style="padding-left: 60px">Insert and Modify Pictures and ClipArt Draw and Modify Shapes Illustrate Workflow Using SmartArt Graphics Layer and Group Graphic Objects </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment</td></tr><tr><td style="padding-left: 60px">Customize the Excel Environment Customize Workbooks Manage Themes Create and Use Templates </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5187.html Dreamweaver CS3: Level 2: Wed., March 31, 2010, 9:00am-4:00pm Overview: In this course, students will use the advanced features of Dreamweaver CS3 to design and develop professional-looking websites.<table border="0" width="100%" class="lcTable"><tbody><tr><td><a name="syll" title="syll"></a>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003192&partNumber=3237LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Working in Code View</td></tr><tr><td style="padding-left: 60px">Use Coding Tools Search for and Replace Code Use Design Notes and Comments </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003192&partNumber=3237LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 2: Formatting with Style Sheets</td></tr><tr><td style="padding-left: 60px">Create CSS Styles Apply External Styles to Multiple Pages Redefine Style Sheets </td></tr><tr><td style="padding-left: 30px">Lesson 3: Creating an Effective User-Navigation Interface</td></tr><tr><td style="padding-left: 60px">Create Rollovers Create a Navigation Bar Add Flash Buttons and Text to a Page Use the Spry User Interface Widgets Add Spry Effects </td></tr><tr><td style="padding-left: 30px">Lesson 4: Working with AP Elements</td></tr><tr><td style="padding-left: 60px">Create AP Elements Control AP Elements Dynamically Insert Rich Media Objects into an AP Element </td></tr><tr><td style="padding-left: 30px">Lesson 5: Automating Tasks</td></tr><tr><td style="padding-left: 60px">Add Library Items from Site Pages Place Library Items onto Site Pages Use Snippets Replay Actions Using the History Panel </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003192&partNumber=3237LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 6: Creating Forms</td></tr><tr><td style="padding-left: 60px">Set Up Forms Add Form Elements Validate Forms </td></tr><tr><td style="padding-left: 30px">Lesson 7: Authoring with XML-Based Data</td></tr><tr><td style="padding-left: 60px">Integrate XML-Based Data Display XML Data Using Spry </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5188.html InDesign CS3: Level 1 (2 days): a 2 meeting session, starting with Wed., April 7, 2010, 9:00am-4:00pm Overview: In this course, students work with some of the tools and features to create eye-catching printed documents using InDesign CS3. <table border="0" width="100%" class="lcTable"><tbody><tr><td><a name="syll" title="syll"></a>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003197&partNumber=3241LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 1: Managing the InDesign Environment</td></tr><tr><td style="padding-left: 60px">Explore the InDesign Environment Customize the Workspace Set General and Interface Preferences </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003197&partNumber=3241LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Designing Documents</td></tr><tr><td style="padding-left: 60px">Create a New Document Add Text and Graphics Edit Text Thread Text Frames Convert Other Application Files to InDesign </td></tr><tr><td style="padding-left: 30px">Lesson 3: Enhancing Documents</td></tr><tr><td style="padding-left: 60px">Apply Colors and Swatches Apply Fills, Gradients, and Strokes Format Characters and Paragraphs Create and Apply Styles Search and Replace Text and Characters Develop Layers Apply Transparency and Transparency Flattener Presets </td></tr><tr><td style="padding-left: 30px">Lesson 4: Adding Tables</td></tr><tr><td style="padding-left: 60px">Create a Table Modify a Table Structure Format a Table Create Table and Cell Styles </td></tr><tr><td style="padding-left: 30px">Lesson 5: Finalizing Documents</td></tr><tr><td style="padding-left: 60px">Check Documents for Problems Print a Document Package Files Prepare PDF Files for Web Distribution Export PDF Files for Printing </td></tr></tbody></table> https://cistraining.unh.edu/sessions/5189.html Adobe Acrobat 9.0: Level 2: Mon., April 12, 2010, 9:00am-4:00pm <table border="0" width="100%"><tbody><tr><td><a name="syll" title="syll"></a><a name="over" title="over"></a>Overview: In this course, students use Adobe® Acrobat® 9.0 Pro to convert technical documents to PDF files, enhance and control PDF content accessibility, customize PDF documents for interactive use online, and prepare PDFs for commercial printing. Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003563&partNumber=3367LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 1: Creating PDFs from Technical Documents</td></tr><tr><td style="padding-left: 60px">Create PDF Documents Using Autodesk AutoCAD Measure Technical Drawings </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003563&partNumber=3367LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Enhancing PDF Documents </td></tr><tr><td style="padding-left: 60px">Embed Multimedia Optimize PDF Files Enhance PDF Document Accessibility </td></tr><tr><td style="padding-left: 30px">Lesson 3: Creating Interactive PDF Forms in Adobe LiveCycle Designer</td></tr><tr><td style="padding-left: 60px">Create a PDF Form Add Form Fields Create Calculations Create Buttons Track Forms Compile Returned Forms Organize Compiled Data </td></tr><tr><td style="padding-left: 30px">Lesson 4: Preparing PDF Files for Commercial Printing </td></tr><tr><td style="padding-left: 60px">Examine the Commercial Printing Process Create PDF Files for Prepress Apply Color Management Settings Modify Adobe PDF Settings for Prepress Preview Printed Effects </td></tr><tr><td style="padding-left: 30px">Lesson 5: Finalizing PDF Files for Commercial Printing </td></tr><tr><td style="padding-left: 60px">Preflight Documents Create PDF/X, PDF/A, and PDF/E Compliant Files Create a Composite Create Color Separations </td></tr></tbody></table> https://cistraining.unh.edu/sessions/5190.html Web Development with Cascading Style Sheets: a 2 meeting session, starting with Tue., April 13, 2010, 9:00am-4:00pm In this 2-day course you will use cascading style sheets to design and develop efficient and effective websites. You will learn to control color and typography, create style sheets that cascade according to established guidelines, design content sections using box properties, control your page layouts with CSS positioning, enhance existing design and create alternate style sheets, and link your pages to them to enhance the accessibility and functionality of your websites.Course Outline           <table border="0" cellspacing="0" cellpadding="0" width="100%" class="MsoNormalTable" style="width: 100%; border-collapse: collapse"><tbody><tr><td style="background: #fffbd6; border: #ece9d8; padding: 3pt">Lesson 1: Controlling Color and Typography<ul><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create an Embedded Style Sheet </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Apply Color </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">CSS Comments </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Modify Text Styles </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Modify Font Styles </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create a Linked Style Sheet</div></li></ul></td></tr><tr><td style="background: white; border: #ece9d8; padding: 3pt">Lesson 2: Designing with the Cascade<ul><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create Class Styles Topic </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create ID Styles Topic </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create Contextual Styles Topic </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Target Styles to Elements with Specific Attributes Topic </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create Style Sheets that Cascade Topic </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Import Style Sheets Topic </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create Inline Styles </div></li></ul></td></tr><tr><td style="background: #fffbd6; border: #ece9d8; padding: 3pt">Lesson 3: Designing Content Sections <ul><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Control Margins and Padding </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create Borders </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create Floating Elements </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Control Content Overflow</div></li></ul></td></tr><tr><td style="background: white; border: #ece9d8; padding: 3pt">Lesson 4: Controlling Layout with Positioning<ul><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Control Layout with Absolute Positioning Topic </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create a Fixed Multi-Column Layout Topic </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create a Fluid Multi-Column Layout Topic </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Control Layout with Relative Positioning Topic </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Control the Display of Layered Elements Topic </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Apply Fixed Positioning </div></li></ul></td></tr><tr><td style="background: #fffbd6; border: #ece9d8; padding: 3pt">Lesson 5: Enhancing an Existing Design<ul><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Customize Cursors </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Customize Link Styles </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Customize Forms </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Work with Background Images </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Customize Lists </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create Generated Content</div></li></ul></td></tr><tr><td style="background: white; border: #ece9d8; padding: 3pt">Lesson 6: Creating Alternate Style Sheets<ul><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create Accessible Style Sheets </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Apply User-Defined System fonts and Colors </div></li><li><div class="MsoNormal" style="margin: 0in 0in 0pt">Create a Print Style Sheet</div></li></ul></td></tr></tbody></table> https://cistraining.unh.edu/sessions/5191.html Access 2007: Level 1 (3 days): a 3 meeting session, starting with Tue., April 20, 2010, 9:00am-4:00pm Overview: In the course, students create and modify new databases and their various objects. They learn how to maintain data consistency and integrity, improve queries, forms, and reports, and also integrate Access 2007 with other applications.Lesson 1: Exploring the Microsoft Office Access 2007 Environment; Examine Database Concepts; Explore the User Interface; Explore the Ribbon; Customize the Access Environment; Obtain Help; Use an Existing Access DatabaseLesson 2: Introduction to Relational Databases: The Basics of Relational Databases; Planning the DatabaseLesson 3: Designing a Database; Describe the Relational Database; Design Process; Define Database Purpose; Review Existing Data; Determine Fields; Group Fields into Tables; Normalize Data; Designate Primary and Foreign Keys; Determine Table RelationshipsLesson 4: Designing Tables' Deciding on Tables and Fields; Selecting Primary Key Fields Identifying Table Relationships More on Keys and Relationships Lesson 5: Building a Database; Create a New Database; Create a TableManage Tables; Create a Table Relationship; Save a Database as a Previous VersionLesson 6: Data Normalization; Solving Data Problems; Higher Normal Forms Lesson 7: Managing Data in a Table; Modify Table Data; Sort RecordsWork with Subdata sheetsLesson 8: Querying a Database; Filter Records; Create a Query; Add Criteria to a Query; Add a Calculated Field to a Query; Perform Calculations on a Record GroupingLesson 9: Query Basics; Performing Queries; Multiple Table QueriesLesson 10: More on Queries; Other Types of Queries; SQL Optimizing Query Performance Lesson 11: Designing Forms; View Data Using an Access Form; Create a Form; Modify the Design of a FormLesson 12: Generating Reports; View an Access Report; Create a Report; Add a Custom Calculated Field to a Report; Format the Controls in a Report; Apply an AutoFormat to a Report; Prepare a Report for PrintLesson 13: Data Integrity; Referential Integrity Field-level Integrity; Table-level Integrity; Reviewing and Finalizing the Database DesignLesson 14: Controlling Data Entry; Restrict Data Entry Using Field Properties; Establish a Pattern for Entering Field Values; Create a List of Values for a FieldLesson 15: Joining Tables; Create Query Joins; Join Unrelated Tables; Relate Data Within a Table Lesson 16: Creating Flexible Queries Set; Select Query Properties; Create Parameter Queries; Create Action QueriesLesson 17: Improving Forms; Design a Form Layout; Enhance the Appearance of a Form; Restrict Data Entry in Forms; Add a Command Button to a Form; Create a SubformLesson 18: Customizing Reports; Organize Report Information; Format the Report; Set Report Control Properties; Control Report Pagination; Summarize Report Information; Add a Subreport to an Existing Report; Create a Mailing Label ReportLesson 19: Sharing Data Across Applications; Import Data into Access; Export Data Analyze; Access Data in Excel; Export Data to a Text File; Merge Access Data with a Word Document https://cistraining.unh.edu/sessions/5192.html Xtender Web Access: Accessing Imaged Documents: Fri., April 23, 2010, 1:00pm-3:00pm In this hands-on session, users will learn the basics of navigating and viewing imaged documents in Xtender Web Access. https://cistraining.unh.edu/sessions/5209.html InDesign CS3: Level 2: Wed., April 28, 2010, 9:00am-4:00pm <a name="over" title="over"></a>Overview: In this course, students will deploy the advanced InDesign techniques to enhance the look and functionality of their documents. They will use the advanced features of Adobe InDesign CS3 to create and design content for print and web.<table border="0" width="100%" class="lcTable"><tbody><tr><td><a name="syll" title="syll"></a>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003250&partNumber=3287LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Managing Styles</td></tr><tr><td style="padding-left: 60px">Manage Style Overrides Base One Style on Another Apply Styles in a Sequence Import Styles from a Word Document Redefine Styles </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003250&partNumber=3287LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 2: Developing Complex Paths</td></tr><tr><td style="padding-left: 60px">Create Bézier Paths Create Compound Paths Create Clipping Paths Create Type Outlines </td></tr><tr><td style="padding-left: 30px">Lesson 3: Handling Page Elements</td></tr><tr><td style="padding-left: 60px">Place Inline Graphics Manipulate Graphics Handle Text Layout Create Duplicate Items Create Anchored Objects Manage Libraries </td></tr><tr><td style="padding-left: 30px">Lesson 4: Administering External Files</td></tr><tr><td style="padding-left: 60px">Locate Assets Using Adobe Bridge Merge Data Import Layered Files Export PDF Files Export XHTML Files </td></tr><tr><td style="padding-left: 30px">Lesson 5: Working with XML</td></tr><tr><td style="padding-left: 60px">Integrate XML into a Document Import XML Export Documents as XML Files Create a Snippet </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003250&partNumber=3287LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 6: Managing Long Documents</td></tr><tr><td style="padding-left: 60px">Create Hyperlinks Insert Footnotes Insert Text Variables Create the Table of Contents Generate an Index Create Document Sections Create a Book </td></tr><tr><td style="padding-left: 30px">Lesson 7: Adjusting Print Settings</td></tr><tr><td style="padding-left: 60px">Create Print Presets Preview Print Output </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5193.html Excel 2007: Level 3: Wed., May 5, 2010, 9:00am-4:00pm Overview: In this course, students will learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.<table border="0" width="100%" class="lcTable"><tbody><tr><td>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003011&partNumber=3165LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Streamlining Workflow </td></tr><tr><td style="padding-left: 60px">Create a Macro Edit a Macro Apply Conditional Formatting Add Data Validation Criteria Update a Workbook's Properties Modify Excel's Default Settings </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003011&partNumber=3165LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 2: Collaborating with Others </td></tr><tr><td style="padding-left: 60px">Protect Files Share a Workbook Set Revision Tracking Review Tracked Revisions Merge Workbooks Administer Digital Signatures Restrict Document Access </td></tr><tr><td style="padding-left: 30px">Lesson 3: Auditing Worksheets </td></tr><tr><td style="padding-left: 60px">Trace Cells Troubleshoot Errors in Formulas Troubleshoot Invalid Data and Formulas Watch and Evaluate Formulas Create a Data List Outline </td></tr><tr><td style="padding-left: 30px">Lesson 4: Analyzing Data </td></tr><tr><td style="padding-left: 60px">Create a Trendline Create Scenarios Perform What-If Analysis Perform Statistical Analysis with the Analysis ToolPak </td></tr><tr><td style="padding-left: 30px">Lesson 5: Working with Multiple Workbooks </td></tr><tr><td style="padding-left: 60px">Create a Workspace Consolidate Data Link Cells in Different Workbooks Edit Links </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003011&partNumber=3165LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 6: Importing and Exporting Data </td></tr><tr><td style="padding-left: 60px">Export Excel Data Import a Delimited Text File </td></tr><tr><td style="padding-left: 30px">Lesson 7: Using Excel with the Web </td></tr><tr><td style="padding-left: 60px">Publish a Worksheet to the Web Import Data from the Web Create a Web Query </td></tr><tr><td style="padding-left: 30px">Lesson 8: Structuring XML Workbooks</td></tr><tr><td style="padding-left: 60px">Develop XML Maps Import and Export XML Data </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5194.html Dreamweaver CS3: Level 1: Wed., May 12, 2010, 9:00am-4:00pm <table border="0" width="100%" class="lcTable"><tbody><tr><td>Overview: In this course, students will design, build, and upload a website using Dreamweaver.Outline:</td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 1: Getting Started with Dreamweaver</td></tr><tr><td style="padding-left: 60px">Examine the Basic Concepts of Web Designing Explore the Dreamweaver Environment Customize the Workspace </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Creating a Website </td></tr><tr><td style="padding-left: 60px">Define a Website Create a Web Page Format a Web Page Organize Files and Folders Create Templates </td></tr><tr><td style="padding-left: 30px">Lesson 3: Adding Design Elements to Web Pages</td></tr><tr><td style="padding-left: 60px">Insert Images Insert Tables Create Repeating Region Templates </td></tr><tr><td style="padding-left: 30px">Lesson 4: Working with Links</td></tr><tr><td style="padding-left: 60px">Create Hyperlinks Create Email Links Create Image Maps Create Anchors </td></tr><tr><td style="padding-left: 30px">Lesson 5: Working with Frames</td></tr><tr><td style="padding-left: 60px">Create Framesets Enhance Frames </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Uploading a Website</td></tr><tr><td style="padding-left: 60px">Ensure Accessibility Upload Files onto a Site </td></tr></tbody></table> https://cistraining.unh.edu/sessions/5195.html Xtender Web Access: Accessing Imaged Documents: Thu., May 13, 2010, 9:00am-11:00am In this hands-on session, users will learn the basics of navigating and viewing imaged documents in Xtender Web Access. https://cistraining.unh.edu/sessions/5210.html Adobe Acrobat 9.0: Level 1: Mon., May 17, 2010, 9:00am-4:00pm <a name="over" title="over"></a>Overview: In this course, students will use Adobe® Acrobat® 9.0 to make the information more portable, accessible, and useful to meet the needs of the target audience. <table border="0" width="100%"><tbody><tr><td><a name="syll" title="syll"></a>Outline:</td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 1: Accessing a PDF Document </td></tr><tr><td style="padding-left: 60px">Open a PDF Document Explore the Adobe Acrobat 9 Pro Interface Browse Through a PDF Document </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Creating PDF Documents </td></tr><tr><td style="padding-left: 60px">Create a PDF Document Using Microsoft Applications Create a PDF Document Using the Print Command Create a PDF Document from Web Pages Create a PDF Document Using Email Applications Create a PDF Document Using Acrobat </td></tr><tr><td style="padding-left: 30px">Lesson 3: Navigating to Specific Content in a PDF Document </td></tr><tr><td style="padding-left: 60px">Conduct a Simple Search Use Bookmarks Work with Links Define Articles </td></tr><tr><td style="padding-left: 30px">Lesson 4: Modifying PDF Documents </td></tr><tr><td style="padding-left: 60px">Manipulate PDF Document Pages Edit Content in a PDF Document Add Page Elements Extract Content from a PDF Document </td></tr><tr><td style="padding-left: 30px">Lesson 5: Working with Multiple PDF Documents </td></tr><tr><td style="padding-left: 60px">Organize PDF Documents into a Collection Redact PDF Documents Search Multiple PDF Documents </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Reviewing a PDF Document </td></tr><tr><td style="padding-left: 60px">Initiate a Review Review a PDF Document Compare PDF Documents </td></tr><tr><td style="padding-left: 30px">Lesson 7: Validating a PDF Document </td></tr><tr><td style="padding-left: 60px">Sign a PDF Document Digitally Verify a Digital ID </td></tr></tbody></table> https://cistraining.unh.edu/sessions/5196.html Excel 2007: Level 1: Tue., May 25, 2010, 9:00am-4:00pm Overview: In this course, students create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks. <table border="0" width="100%" class="lcTable"><tbody><tr><td>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003009&partNumber=3163LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Creating a Basic Worksheet</td></tr><tr><td style="padding-left: 60px">Explore the User Interface and the Ribbon Navigate and Select in Excel Obtain Help Enter Data and Save a Workbook Customize the Quick Access Toolbar </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Performing Calculations</td></tr><tr><td style="padding-left: 60px">Create Basic Formulas Calculate with Functions Copy Formulas and Functions </td></tr><tr><td style="padding-left: 30px">Lesson 3: Modifying a Worksheet</td></tr><tr><td style="padding-left: 60px">Manipulate Data Insert and Delete Cells, Columns, and Rows Search for Data in a Worksheet Spell Check a Worksheet </td></tr><tr><td style="padding-left: 30px">Lesson 4: Formatting a Worksheet</td></tr><tr><td style="padding-left: 60px">Modify Fonts Add Borders and Color to Cells Change Column Width and Row Height Apply Number Formats Position Cell Contents Apply Cell Styles </td></tr><tr><td style="padding-left: 30px">Lesson 5: Printing Workbook Contents</td></tr><tr><td style="padding-left: 60px">Print Workbook Contents Using Default Print Options Set Print Options Set Page Breaks </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Managing Large Workbooks</td></tr><tr><td style="padding-left: 60px">Format Worksheet Tabs Manage Worksheets in a Workbook Manage the View of Large Worksheets </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5203.html Dreamweaver CS3: Level 2: Wed., June 2, 2010, 9:00am-4:00pm Overview: In this course, students will use the advanced features of Dreamweaver CS3 to design and develop professional-looking websites.<table border="0" width="100%" class="lcTable"><tbody><tr><td><a name="syll" title="syll"></a>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003192&partNumber=3237LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Working in Code View</td></tr><tr><td style="padding-left: 60px">Use Coding Tools Search for and Replace Code Use Design Notes and Comments </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003192&partNumber=3237LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 2: Formatting with Style Sheets</td></tr><tr><td style="padding-left: 60px">Create CSS Styles Apply External Styles to Multiple Pages Redefine Style Sheets </td></tr><tr><td style="padding-left: 30px">Lesson 3: Creating an Effective User-Navigation Interface</td></tr><tr><td style="padding-left: 60px">Create Rollovers Create a Navigation Bar Add Flash Buttons and Text to a Page Use the Spry User Interface Widgets Add Spry Effects </td></tr><tr><td style="padding-left: 30px">Lesson 4: Working with AP Elements</td></tr><tr><td style="padding-left: 60px">Create AP Elements Control AP Elements Dynamically Insert Rich Media Objects into an AP Element </td></tr><tr><td style="padding-left: 30px">Lesson 5: Automating Tasks</td></tr><tr><td style="padding-left: 60px">Add Library Items from Site Pages Place Library Items onto Site Pages Use Snippets Replay Actions Using the History Panel </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003192&partNumber=3237LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 6: Creating Forms</td></tr><tr><td style="padding-left: 60px">Set Up Forms Add Form Elements Validate Forms </td></tr><tr><td style="padding-left: 30px">Lesson 7: Authoring with XML-Based Data</td></tr><tr><td style="padding-left: 60px">Integrate XML-Based Data Display XML Data Using Spry </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5198.html Photoshop CS3: Level 1 (2 days): a 2 meeting session, starting with Tue., June 8, 2010, 9:00am-4:00pm <a name="over" title="over"></a>Overview: In this course, students will use the several tools and features of Photoshop CS3 to work with images.<table border="0" width="100%" class="lcTable"><tbody><tr><td><a name="syll" title="syll"></a>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003193&partNumber=3242LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 1: Exploring the Photoshop Environment</td></tr><tr><td style="padding-left: 60px">Explore the Photoshop Interface Customize the Workspace Explore the Navigation Tools </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003193&partNumber=3242LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Working with Image Areas</td></tr><tr><td style="padding-left: 60px">Select Image Areas Save a Selection Modify a Selection </td></tr><tr><td style="padding-left: 30px">Lesson 3: Working with Layers</td></tr><tr><td style="padding-left: 60px">Create Layers Create Type Layers Transform Layers Alter Type Properties Apply Layer Styles Undo Previous Steps Arrange and Group Layers </td></tr><tr><td style="padding-left: 30px">Lesson 4: Enhancing Images</td></tr><tr><td style="padding-left: 60px">Paint Strokes on an Image Apply Filter Effects Convert an Image to Black and White Blend Layers Merge Layers and Flatten Images </td></tr><tr><td style="padding-left: 30px">Lesson 5: Saving Images for Web and Print</td></tr><tr><td style="padding-left: 60px">Save Images for Use in Print Applications Save Images for the Web Save Images as PDF </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003193&partNumber=3242LGEE#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Managing Assets with Adobe® Bridge</td></tr><tr><td style="padding-left: 60px">Explore Adobe Bridge Work with Adobe Bridge Work with Stacks and Filters in Adobe Bridge Apply Metadata and Keywords to Files </td></tr></tbody></table> https://cistraining.unh.edu/sessions/5199.html PowerPoint 2007: Level 1: Mon., June 14, 2010, 9:00am-4:00pm Overview: In this course, students will work with Microsoft® Office PowerPoint® 2007 to create electronic presentations.<table border="0" width="100%" class="lcTable"><tbody><tr><td><a name="syll" title="syll"></a>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003016&partNumber=3170LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Getting Started with PowerPoint</td></tr><tr><td style="padding-left: 60px">Explore the User Interface Navigate and View a Presentation Use Microsoft PowerPoint Help Enter Text Save a Presentation </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003016&partNumber=3170LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 2: Creating a Presentation</td></tr><tr><td style="padding-left: 60px">Create a Presentation Edit Text Add Slides to a Presentation Arrange Slides Work with Themes </td></tr><tr><td style="padding-left: 30px">Lesson 3: Formatting Text on Slides</td></tr><tr><td style="padding-left: 60px">Apply Character Formats Apply Paragraph Formats Format Text Placeholders </td></tr><tr><td style="padding-left: 30px">Lesson 4: Adding Graphical Objects to a Presentation</td></tr><tr><td style="padding-left: 60px">Insert Clip Art and Pictures Draw Shapes Insert WordArt </td></tr><tr><td style="padding-left: 30px">Lesson 5: Modifying Objects</td></tr><tr><td style="padding-left: 60px">Work with Objects Change Object Orientation Format Objects Group and Ungroup Objects Arrange Objects </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003016&partNumber=3170LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 6: Adding Tables to a Presentation</td></tr><tr><td style="padding-left: 60px">Create a Table Format Tables Insert a Table from Microsoft Word </td></tr><tr><td style="padding-left: 30px">Lesson 7: Inserting Charts in a Presentation</td></tr><tr><td style="padding-left: 60px">Create a Chart Edit Chart Data Modify a Chart Paste a Chart from Microsoft Excel </td></tr><tr><td style="padding-left: 30px">Lesson 8: Preparing to Deliver a Presentation</td></tr><tr><td style="padding-left: 60px">Review Content Add Transitions Apply an Animation Effect Create Speaker Notes Print a Presentation </td></tr><tr><td> </td></tr><tr><td align="right"> </td></tr></tbody></table> https://cistraining.unh.edu/sessions/5200.html Crystal Reports XI: Level 1 (2 days): a 2 meeting session, starting with Thu., June 17, 2010, 9:00am-4:00pm Overview: In this course, students will build basic list and group reports that work with almost any database. <table border="0" width="100%" class="lcTable"><tbody><tr><td>Outline:</td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 1: Creating a Report</td></tr><tr><td style="padding-left: 60px">Set Default Report Settings Specify Fields for a New Report Preview a Report Modify Field Display Add a Report Title Position Fields Add Fields from Other Tables </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200002772&partNumber=NH85517S#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 2: Displaying Specific Report Data</td></tr><tr><td style="padding-left: 60px">Find Data Sort Data Filter Data by a Single Criterion </td></tr><tr><td style="padding-left: 30px">Lesson 3: Grouping Report Data</td></tr><tr><td style="padding-left: 60px">Insert a Group Add Summaries Format Summary Information Change Group Options Add a Second-Level Grouping Filter Records by Group Create a Top N Sort Group </td></tr><tr><td style="padding-left: 30px">Lesson 4: Building Formulas</td></tr><tr><td style="padding-left: 60px">Create a Formula Edit a Formula Combine Fields by Formula Delete a Formula Filter Data by Multiple Criteria Modify a Filter Using an OR Operator Create a Parameter Field Account for Null Fields in a Formula </td></tr><tr><td style="padding-left: 30px">Lesson 5: Formatting Reports</td></tr><tr><td style="padding-left: 60px">Remove White Space Insert Page Header/Footer Data Add Borders, Boxes, and Lines Change Field Background Color Change the Margins </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200002772&partNumber=NH85517S#top"></a> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Enhancing Reports</td></tr><tr><td style="padding-left: 60px">Add a Watermark Insert Objects Using Object Linking and Embedding Modify Formatting Based on Data Value Suppress Report Sections Insert Hyperlinks Hide Blank Report Sections </td></tr><tr><td style="padding-left: 30px">Lesson 7: Creating Pie Charts</td></tr><tr><td style="padding-left: 60px">Create a Pie Chart with a Drill-Down Modify Chart Text Format a Chart Present a Chart by Group </td></tr><tr><td style="padding-left: 30px">Lesson 8: Distributing Data</td></tr><tr><td style="padding-left: 60px">Export to a PDF File Export to a Microsoft Excel File Export to an Access Database File Export a Report Definition Create Mailing Labels </td></tr></tbody></table> https://cistraining.unh.edu/sessions/5206.html Xtender Web Access: Accessing Imaged Documents: Tue., June 22, 2010, 10:00am-12:00pm In this hands-on session, users will learn the basics of navigating and viewing imaged documents in Xtender Web Access. https://cistraining.unh.edu/sessions/5211.html Excel 2007: Level 2: Wed., June 23, 2010, 9:00am-4:00pm Overview: In this course, students use Excel® 2007 to streamline and enhance spreadsheets with templates, charts, graphics, and formulas. They will apply visual elements and advanced formulas to a worksheet to display data in various formats.<table border="0" width="100%" class="lcTable"><tbody><tr><td>Outline:</td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003010&partNumber=3164LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 1: Calculating Data with Advanced Formulas</td></tr><tr><td style="padding-left: 60px">Manage Cell and Range Names Calculate Data Across Worksheets Use Specialized Functions Analyze Data with Logical and Lookup Functions </td><td align="right"><a href="http://www.newhorizons.com/content/outlineDisplay.aspx?SKU=200003010&partNumber=3164LGEE#top"></a></td></tr><tr><td style="padding-left: 30px">Lesson 2: Organizing Worksheet and Table Data </td></tr><tr><td style="padding-left: 60px">Create and Modify Tables Format Tables Sort or Filter Worksheet or Table Data Calculate Data in a Table or Worksheet </td></tr><tr><td style="padding-left: 30px">Lesson 3: Presenting Data Using Charts</td></tr><tr><td style="padding-left: 60px">Create a Chart Modify Charts Format Charts </td></tr><tr><td style="padding-left: 30px">Lesson 4: Analyzing Data Using PivotTables and PivotCharts</td></tr><tr><td style="padding-left: 60px">Create a PivotTable Report Analyze Data Using PivotCharts </td></tr><tr><td style="padding-left: 30px">Lesson 5: Inserting Graphic Objects</td></tr><tr><td style="padding-left: 60px">Insert and Modify Pictures and ClipArt Draw and Modify Shapes Illustrate Workflow Using SmartArt Graphics Layer and Group Graphic Objects </td><td align="right"> </td></tr><tr><td style="padding-left: 30px">Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment</td></tr><tr><td style="padding-left: 60px">Customize the Excel Environment Customize Workbooks Manage Themes Create and Use Templates </td></tr></tbody></table>  https://cistraining.unh.edu/sessions/5202.html