This workshop is designed for anyone who uses Google Workspace / GMail for professional, educational or personal purposes.  Participants will have hands-on experience managing and cleaning up Google Drive & GMail  focusing on organizational tools with Drive folders, subfolders, naming, sharing & color coding and moving/archiving tips.  If you are new to Google and want to learn more about GMail and Drive,  this is a great opportunity as well.

1.  Strategies to clean up GMail and keep it it under control

2.  Strategies to clean up, organize and manage DRIVE.

BONUS:  

3.  The steps to clean up, close out and archive Google Classrooms.  

Even if you don't use Google Classroom, what you learn to manage Drive & GMail will get your workspace 'in control' and help you keep it that way. 

_______________________________

Registration options:

• Credit card, just select the 'Register' button above.  
• Check payment using this form or email nhtibtc@ccsnh.edu  

Over the last two decades, mindfulness has enjoyed an exponential rise in nearly every facet of society. From healthcare to education, the military to professional sports teams, training in mindfulness is improving people’s physical and psychological health, as well as their performance and life satisfaction. Many business leaders recognize the benefits mindfulness can bring to the workforce, including increased productivity and reduced healthcare costs.

This 8-part series introduces participants to the basics of Communicating Mindfully, a time-tested, internationally respected curriculum that infuses the study of mindfulness with the study of communication and emotional intelligence. Studies have shown participant improvement in all of these areas, suggesting this powerful combination increases a broad array of skills that benefit participants both personally and professionally.  Participants will deepen their understanding and practice of mindful communication through an in-depth look at the ways self-talk, self-concept, and assertive behavior impact communication.

The course is designed around the fact that each moment of our lives is unique and unpredictable. CM  provides participants with the skills they need to accurately assess internal and external factors involved in any given communication experience and make effective choices about how to communicate productively based on that awareness. Through the study of communication theory and mindfulness, participants learn to identify and modify unproductive communication habits, thus increasing their ability to manage stressful situations and improve relationships with others.

Required Text (not included):  Communicating Mindfully, Dan Huston

Communicating Mindfully for the Workplace Schedule

Meeting 1: Getting Started: Beginner’s Mind

Meeting 2: Conversation & Listening Skills: Paying Attention

Meeting 3: Becoming Better Listeners: More Than Meets the Ear

Meeting 4: Nonverbal Behavior & Physical Sensations

Meeting 5: Self-Talk: Getting to Know Ourselves

Meeting 6: Self-Concept: Who Do You Think You Are?

Meeting 7: Assertive Behavior: Tell It Like It Is

Meeting 8: An End and a New Beginning

Online:  July 12th - 23rd, 2021

This course provides infection control guidelines and recommendations for the dental office. The course is based on the CDC infection and prevention guidelines, and includes information on disinfection and sterilization, products, and asepsis protocols. This course fulfills the NH dental infection control requirements for certification and license renewal.

 CEU:  3

INTRO PRICE ONLY $179 - $100 off

Leverage the Power of Google Tools for Productivity & Collaboration - all versions of Google compatible.

Tuesdays & Thursdays, July 13 - July 29  9:00am - 11:00am

Register with Credit Card Here.

Check or PO payment using this form or email nhtibtc@ccsnh.edu     

Google Workspace is an extensive collection of productivity tools. Learning the power and connection of Google tools for organization, collaboration and sharing will amp up your personal  productivity or that of your business or non profit.

Presented in a series of sessions, this comprehensive series is for new and current Google users who want to build their foundational skills. Advanced tips and tricks will be included to individualize the challenge for all user levels. Each session will cover a different app and the fundamental concepts of security, sharing and streamlining workflow.  

The goal for this course is to understand  and gain hands on experience with Gmail, Drive, Calendar, Docs, Sheets and Slides and how these individual apps can be connected to enhance organization, collaboration and sharing in a cloud environment. Related Google services such as Chrome, Photos, Meet, Keep, Tasks, Groups  will be addressed, Participants will have the option of successfully completing follow up activities to earn  the NHTI Google Pro Microcredential.

Outline:

Topic 1:  FUN Da Mentals - Google Environment and Google Drive

Dive into the Google world.   What is G Suite and what does it include - for personal and professional use

• Chrome browser Working with multiple accounts 
• Introduction to sharing, collaborating and 
• Organizing your drive to fit your needs. 
• Issues of security

Topic 2: Making  Gmail Work for You  

Set up your email to focus your time and attention

• Sort and prioritize your mail
• Customize your view your email so it works for you
• Add signatures, away messages
• Manage multiple email accounts
• Organizing Labels, Folders, Stars and more

Topic 3:  Learning to Love Sheets

From Collecting to analyzing data

• Setting up and organizing a sheet
• Manipulating data - sorting, filtering, freezing rows and columns
• AutoSum & Auto Average, suggested formulas and other basic formulas I(Concatenation, 
• Creating charts and graphs
• Collecting data with Forms

Topic 4 Taking Control of Your Time - Calendar, Meet, Keep and Task

Calendar for keeping on top of your life and coordinating with others. 

• Adding reminders and notifications
• Integrating your email
• Managing multiple calendars
• Integrate Calendar, Meet, *Keep and Task
• *Setting up appointment slots

Topic 5 Docs for Sharing and  Collaboration

More than word processing. 

• Sharing and Collaboration through our the Google world
• Giving Feedback
• Interactive documents
• History - Who did what when? (All app)
• * Integrating the world of Microsoft
• Copies templates, signature

Topic 6 Slides - the Grand Master of Layout and Publishing

The ultimate layout and publishing tool

• Slides for presentation from start to presentation
• Combining slides from multiple presentations
• * Using 3rd party resources to smooth the way.
• Ebook, booklets and templates

About the Instructor

Deb Boisvert is an educator/computer professional with over 35 years of experience. She is a Google Level 1 and 2 Educator and a Google Certified Trainer.  She has worked extensively in private and public schools K-16 and with NonProfits. 

 NOTE:  Individuals / Groups that want to register via PO - please email amollica@ccsnh.edu

July 15 & 22, THURSDAYS 8:30am - 12:00pm

Register here.

If you are using a PO or want to register a group, please email nhtibtc@ccsnh.edu    

Excel 102 - The Productivity Bootcamp  

Microsoft Excel has become the main program to handle large amounts of data, charts, financial models, math formulas, reports, and just about everything else pertaining to business.  But using it can still be a mystery.

This training will show you everything you need to know about using Excel and getting more productive and efficient with it.  The topics include:

• Sorts
• Filters
• Advanced Filters
• Subtotals
• Formatted Tables
• The Total Row in Formatted Tables
• Using Slicers in Formatted Tables
• The Sumif, Countif, and Averageif Formulas
• The Vlookup Formulas
• If Formulas
• Date Formulas
• Subtotals
• Charts
• Pivot Tables
• Dashboards in Pivot Tables
• Power Pivot and PowerQuery
• Automating tasks with Macros

 About the Instructor

Tom Fragale is a computer professional with over 30 years of experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across a variety of industries, including manufacturing, banking, pharmaceutical, education, retail, etc.

In today's world, the individual user may be given access to a large database, and they somehow have to make sense of this huge amount of data. This used to be the responsibility of an IT team, but these days the IT teams do not have the resources to write the reports needed by each person. Many databases use the SQL language to retrieve the proper data from the large database. This course shows you how to start writing your own SQL queries.

Topics Include:

• Select statements
• Giving the output field a different name
• Using Where statements to get the exact records you are looking for
• Using Order By statements to sort the data
• Creating Subtotals with the Group By statement
• Introduction to joining tables together

About the Instructor

Tom Fragale is a computer professional with over 30 years of experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across a variety of industries, including manufacturing, banking, pharmaceutical, education, retail, etc.

He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.

Closed for registration.

Microsoft Power BI is a collection of software services, apps and connectors that work together to turn your unrelated sources of data into coherent, visually immersive and interactive insights.  Learn how to import from Excel, Access, Text or Sql Server to manipulate data and create charts or reports.  Topics Include

• What is Power BI?
• The Power BI Parts - Desktop, Service & Mobile
• Power BI concepts - datasets, reports & dashboards
• Capacities - the resources for hosting and delivering Power BI content
• Workspaces - Personal/Collaborative
• Datasets and how they interact with workspaces
• Shared Databases
• Reports - creating and importing to dashboards
• Dashboards - how to create and share
• Data modeling & visualization basics
• Transform, Filter & Clearing Data

About the Instructor

Tom Fragale is a computer professional with over 30 years of experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across a variety of industries, including manufacturing, banking, pharmaceutical, education, retail, etc.

He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.

The Google Educator L1 Bootcamp consists of instructor led hands on, activities that directly supplement Google’s online training and what you need for a successful examination to become a Google L1 Certified Educator. It will solidify your foundation skills for all of the G Suite Apps. 

• Ideal participant has basic proficiency using G Suite.  
• Bootcamp focus is to fill in the gaps and help participants ‘level up so can continue to expand productivity and pedagogy.

Applications covered include:

• Chrome
• Drive
• Docs
• Sheets
• Slides
• Forms
• Sites
• Mail
• Calendar
• Groups
• Meet
• YouTube
• Sites 

Facilitator:  Deb Boisver, Google Certified Trainer

Course will be accessible via your assigned training account.  You will receive your access information one week prior.    Access the L1 Bootcamp here.  (If you get a 404 error, open link an incognito window and log into your training account to access).  

Optional Graduate Credit Add On

We have partnered with EdTechnologySpecialists to offer graduate credit from Colorado State University.  Graduate credit is optional.  If students want graduate credit from CSU, they will enroll and complete the online graduate credit component with instructor Allison Mollica.  Students will create a capstone project that demonstrates proficiency of various Google tools, including but not limited to Drive, Docs, Sheets, Forms, Youtube, Sites, Classroom, Slides, Meet, and others. The project will demonstrate how these tools will ignite learning and communication with students or parents, or both.

Register for the 1-credit graduate component here (optional)