Summer Excel classes will be conducted via Zoom online meetings.

This class covers the following excel topics:

Working with Multiple Worksheets and Workbooks Simultaneously:  Use 3-D References, Use Links and External References, Consolidate Data

Using Advanced Worksheet Functions: Conditional & Logical Functions with If / Nested If / And/OR, VLookup, Apply Cell and Range Names

Goal Seek

Conditional Formatting: Creating Rules to Highlight Cells, Using Icon Sets with Inequalities

Presenting Data with Charts:  Using Sparklines, Review Chart Basics, Evaluate Formatting Options, Combine Charts, Add Graphical Elements (Trend line) 

Analyzing Data Using PivotTables, Slicers, and PivotCharts: Create a PivotTable Report, Filter Data Using Slicers, Analyze Data Using PivotCharts

Customizing and Enhancing the Excel Environment: Customize the Excel Environment, Manage Themes, Create and Use Templates, Apply Spreadsheet Security

And More: Controlling Page Breaks, Use Page Setup to Repeat Headings (Rows/Columns), Automate Tasks with a Simple Macro

This course is WIOA Certified.

ESOL classes will be conducted via Zoom online meetings.

This advanced course is designed to facilitate the transition to college level reading and evidence-based writing. Students will use the process approach for writing a five-paragraph essay from primarily non-fiction texts, using the basic academic format (effective introduction with thesis, coherent body paragraphs supported by evidence, and conclusion.) Students will also improve their skills in reading and comprehension, grammar and mechanics, practicing a variety of verb and sentence structures necessary for college writing. This integrated reading and writing course will focus on annotation, summary, and critical response essay writing of at least 5 paragraphs.

Required Textbook:  

Avenues 3 English Skills, 2nd ed. Author: Lynne Gaetz ISBN: 978-2-7613-8422-3

https://www.pearsonerpi.com/en/elt/grammar/avenues-3-2nd-ed-skills-book-etext-my-elab-student-12-month-access-138422

Prerequisite: Students are required to take a reading and writing placement assessment to participate in this non-credit ESOL class. Also, Workforce Development and Academic Success Center staff discretion is taken under advisement.

WDC ESOL Writing & Reading Placement Assessment includes:

• Part 1: Three reading prompts, completing the multiple choice or true/false questions for each.
• Part 2: Choose one of the writing prompts and write a minimum of a 300 word essay.

For more information contact: ManchesterWDC@ccsnh.edu

This course is WIOA Certified

Summer Excel classes will be conducted via Zoom online meetings.

This course expects a base knowledge from participants in using Microsoft Word.  Advanced topics will be covered such as formatting a document, using templates, marking a document, inserting objects, mail merge, and other special features.  This class will take your basic knowledge of Word to a new level.

This course is WIOA Certified.

This course is designed to prepare technicians for the New Hampshire Motor Vehicle State Inspection Test. An In depth analysis of the state laws will be thoroughly discussed and reviewed. Technicians will be taught how to properly perform safety inspections as outlined in the Saf-C 3200 Official Inspection Station Rules. Technicians will perform multiple sample hands on Inspections during this course. This course does not replace the mandatory Inspection Overview Course as cited in Saf-C 3205.03 but is designed to be used in addition to increase your knowledge and understanding during testing. Completing this course does not guarantee that you will pass the New Hampshire Motor Vehicle State Inspection Test.

Summer Excel classes will be conducted via Zoom online meetings.

This class covers the following excel topics:

Getting Started with Excel: Performing Calculations in an Excel Worksheet, Modifying an Excel Worksheet, Modifying the Appearance of a Worksheet, Printing Excel Workbooks, Introduction to Charts & Graphs, Managing an Excel Workbook

Performing Calculations in an Excel Worksheet: Learn How to use Basic Math in Excel, Create Formulas with Sum/Max/Min/Average, Use Formula View, Understand Relative and Absolute References

Modifying an Excel Worksheet: Edit Worksheet Data, Find and Replace Data, Manipulate Worksheet Elements

Modifying the Appearance of a Worksheet: Apply Font Properties, Add Borders and Colors to Cells, Align Content in a Cell, Apply Number Formatting, Apply Cell Styles, Insert Comments

Printing Excel Workbooks: Define the Page Layout, Learn to use Header/Footer, Add File Pathway Documentation, Print 

Introduction to Charts & Graphs: Create and Modify Charts, Use Chart Layout Tools

Managing an Excel Workbook: Manage Worksheets with Data Filters, Apply Multi-Level Sort, Use the Sub-Totals View, Discover Pivot Tables

This course is WIOA Certified.

Class Schedule:

Tues. & Thurs. 5:00 - 8:00pm via online Zoom class
Sat. 8am - 2pm in person with a certified home inspector

Due to the COVID-19 pandemic, we will offer the majority of this course via virtual learning with the instructor using Zoom meeting.  Saturday’s will continue to be in person with a certified home inspector using proper PPE of masks and gloves.

This is a State of New Hampshire and American Society of Home Inspection (ASHI) certified course that provides a comprehensive training program on how to inspect a home in accordance to the Standards of Practice of recognized professional organizations (ASHI, NAHI and NACHI0). Home inspectors provide an important role in the real estate transaction of buying a home. Our 80 hour training program provides you the knowledge to do an intensive home inspection for your client.

This course includes online virtual classroom participation, guest speakers, and hands-on learning with a certified home inspector. Participants shadow with a home inspector while they perform 3 home inspections on different houses during our course.

This course prepares students to take the national test, which is required for certification.

Required Book:

Principles of Home Inspection: Systems & Standards Third Edition

ISBN: 978-1-07-880138-6 

Principles of Home Inspection: Systems & Standards Third Edition Update eBook

ISBN: 978-1-07-880137-9

This course is WIOA Certified.

Summer Word classes will be conducted via Zoom online meetings.

Microsoft Word is a word processing program that allows for the creation of simple and more advanced documents.  This course focuses on the basics of Microsoft Word including opening documents, the toolbar and saving files.  Further, participants will learn about creating documents, formatting, page layout options, how to proof a document and creating tables.

This course is WIOA Certified.

Recording, Mixing, and Mastering Using Modern Digital Technology! Designed for digital audio beginners & intermediates who want to improve their home recording skills or even open their own project studio someday, this 4-week course focuses on using modern technology to make great-sounding recordings. Taught at the NHTunes recording studio in Manchester’s Millyard, students will study audio engineering fundamentals, as well as technology-specific audio applications. To gain 'real-world' experience in audio engineering, students will participate in actual mixing and mastering sessions.

What You'll Learn

• The basic concepts of digital audio recording.
• How to use digital audio software sequencers and plug-ins.
• The principals of, and gain proficiency in mixing and mastering audio.
• How to facilitate productive recording sessions.
• To identify & understand the key areas of the audio signal chain: room, sound source, microphone, preamp, converter, monitors.

Bob Desmarais owns and runs NHTunes, a 1,800+ sq ft studio in the Waumbec Mill which specializes in audio recording and piano, voice, and guitar lessons. A member of the Audio Engineering Society, Bob has been playing guitar professionally for nearly thirty years, and has been recording bands and soloists for nearly a decade. He currently performs in the acoustic duo Sonic Boomers. He has an MBA from SNHU, and a Guitar Certificate from Berklee College of Music.

Required Text: Home Recording: Need-To-Know Essentials To Improve Your Mixes by Robert A Desmarais (ISBN-10: 1516864476 | ISBN-13: 978-1516864478)