This course is being rescheduled to FALL 2021.  Please email nhtibtc@ccsnh.edu if you would like to be notified when it become open for registration.

Using Data to Make Powerful Decisions

Advances in computing power have led to a massive explosion in the amount of data available for analysis.  But many businesses don’t take advantage of the opportunities for analyzing their data, and miss out on opportunities to improve their bottom line.  

This series covers an introduction to analytics and  common analytics tools and methods, providing  today’s professionals with an understanding of what it means to lead with data while actively working with visual datasets to develop best practices to tell a story or make an impact.   The program wraps up with the importance of understanding people analytics and forecasting in order to create effective action plans.  

Data Analytics for Leaders MicroCredential Certificate

By completing all sessions and intersession activities delegates will be awarded the Data Analytics for Leaders Microcredential Certificate. 

Workshop Descriptions

Session 1:  Introduction to Data Analytics for Leaders  

We can’t escape the presence of data in the media these days.  Advances in computing power have led to a massive explosion in the amount of data available for analysis.  But many businesses don’t take advantage of the opportunities for analyzing their data, and miss out on opportunities to improve their bottom line.   This first session will introduce leaders to what analytics is, and to common tools and methods used to perform analytics and convey results.  We’ll review examples in Descriptive, Predictive and Prescriptive analytics with an emphasis on concrete examples from business. 

Session 2: Data Literacy for Leaders 

Description:  As a leader responsible for the success of your organization, you need to be able to understand and take full advantage of your data.   But where do you start?  And how do you know which data you can trust? We’ll build on the concepts from Session 1 to address these questions, and chart a path forward to strategic use for yourself and for your team.

Session 3:  Storytelling Through Data Visualization / Communicate for Impact      

Description:  Numbers don’t tell the whole story.  They require context, they require an understanding of your business, and they require critical thinking.  In this session we’ll review best practices for presenting data through visual methods including graphs, infographics, and dashboards.  We’ll weigh the pros and cons of each, and discuss the merits of different types of charts, graphs and visuals to deliver your message.  

Session 4:   People Analytics   

Description:  Researchers are finding more and more evidence that leveraging human capital improves a company’s performance - its stock price, its customer satisfaction, its employee retention, and others.  As a leader responsible for the success of your organization, you need to be able to leverage data to take full advantage of this resource. We’ll discuss examples of how data and analytics can help leaders understand the value of an engaged employee, recognize factors that lead to employee turnover, predict the future productivity of job applicants, and proactively uncover sources of top-caliber talent. 

Session 5:  Forecasting Basics & Pitfalls  

Description:  One especially helpful use of analytics for business is forecasting.  We’ll review several types of forecasting that are regularly employed by businesses, time-series (trend lines, moving averages)  and associative (correlation, regression).   No method is perfect, however, and we’ll discuss the advantages of each as well as the drawbacks.  We’ll also look at some of the common pitfalls that both analysts and decision-makers make, and suggest ways to mitigate for that.

Session 6:  Putting It All Together:  KPIs, Building an Action Plan, and Google Analytics  

Description:  Our final session will consolidate what we’ve covered into a plan for action going forward.  We’ll walk through how to determine what metrics and analyses are the important ones for you to focus on in your business, depending on what your goals are.  Using Google Analytics as an example, we’ll identify the metrics that you’ll want to be keeping your eyes on within your organization, what questions they can (and can’t!) answer, and what analyses you’ll need to be receiving on a regular basis.  We’ll discuss building the internal structure that will deliver these metrics and analyses to you, from reporting programs to the skills needed by your team members.

______________________________________________

About Julie Alig, Ph.D.

Julie Alig is a data geek who’s passionate about telling stories and works with organizations, businesses, non-profits, colleges and universities, and other groups to uncover the stories in their data, using statistics and visualizations. Armed with this knowledge, they make strong, strategic decisions to move forward.  She earned her Doctorate in Political Science from the University of Chicago, and was awarded a Fulbright Scholarship to conduct her dissertation field research in Stuttgart, Germany.  She graduated cum laude from Columbia College in New York City with a Bachelor’s in History and French Literature.  She lives in Manchester with her husband and two children.

Wednesdays, 3pm - 5pm, March 3rd, 10th & 17th

Distinguish yourself as a super user with immersed integration & beyond the core

If you're an educator who is a super user and enthusiast of Google tools in the classroom, this certification proves your expertise.  The training will host a series of online activities to build your skills with core and extended tools such as 

• Blogger
• Google Search
• Scholar
• YouTube Editing
• Advanced Docs, Sheets, Slides, Forms, Classroom & Sites

Take your core knowledge to the next level by learning new ways to use the tools to innovate, engage, create, & collaborate!  

Facilitated by Google Certified Trainer, Deb Boisvert

_______________________________________________________

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)

____________

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

2 Sessions - 3.5 hours each

March 4th and March 11th 2021, 1:00 pm - 4:30 pm

Introduction to Topic:

Professionals working with data and numbers need working knowledge of spreadsheet applications.  If your organization uses Microsoft Excel a hands-on course that teaches how to set up and work with fully formatted worksheets is a must. 

Excel 101 Topics: 

Topic 1:  Introduction to Excel – the basics

Delegates will get a working understanding of the Excel interface to learn the essentials of creating and setting up workbooks, worksheets and working with data.  Topics covered include:

• Terminology – Workbook, worksheets, cells, ribbon
• Tour of Excel screen
• Moving around the Excel interface
• Entering Data
• Select ALL
• Changing Column Widths
• Speed Fill / Auto Fill
• Fill down and fill across
• Inserting rows and columns
• Performing basic calculations
• Creating hyperlinks to the web, files, cells, 

Topic 2:  Working with Numbers  

In this session, delegates will practice working with formulas to unleash the power of how Excel spreadsheets.  Topics covered include:

• More Basic calculations
• Speed fill with a formula
• Auto Sum
• Auto Average
• MIN
• MAX
• Basic Formulas
• Speed fill with a formula
• Relative Formulas
• Absolute formulas

Topic 3:  Formatting Sheets    

Representing data visually is an important element of working with Excel.  In this session participants will learn about options for formatting, sorting and filter and creating visual representations of data.  Topics include:

• Managing Sheets
• Using Comments
• Printing and page setup options
• Sorting basics
• Filtering basics
• Subtotals
• Charts
• Formatting the spreadsheet
• Conditional Formatting
• Formatting cells for number, calendar, currency, decimal

Topic 4 Managing Sheets   

A workbook can contain many sheets.  Leveraging the use of multiple sheets in a single workbook can increase productivity and overall impact of spreadsheets.    Topics include:

• Adding Sheets
• Deleting Sheets
• Changing a Sheets name
• Changing a Sheets color
• Moving Sheets
• Copying Sheets
• Navigating Sheets
• Linking Formulas from 1 sheet to another

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.

2 Sessions - 3.5 hours each

March 18th and March 25th 2021, 1:00 pm - 4:30 pm

Excel 102 - The Productivity Bootcamp  

Description:    

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.

Leverage the Power of G Suite Tools for Productivity & Collaboration

6 Session - 2 hours (1.5 instruction .5 guided application)

Thursdays, Apr 1, 8, 15, 22 29 & May 6, 9:00 am - 11:00 am 

G Suite is an extensive collection of productivity tools. Learning the power and connection of G Suite 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 G Suite 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 G Suite 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, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel. 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

HR Essentials!  Using Data to Make Powerful Decisions

Researchers are finding more and more evidence that leveraging human capital improves a company’s performance – its revenue, customer satisfaction, employee retention, and ability to attract new employees, among others.   As a leader responsible for the success of your organization, you need to be able to leverage data to take full advantage of this valuable resource.  This 6-week microcredential course will equip you with the skills and knowledge you need to begin doing just that.  In non-technical language, this introduction to the emerging field of “People Analytics” will review the basics of the theory, practice and terminology of people-centered analytics in organizations today.

Presented in six (6) two (2) hour sessions, you’ll learn what metrics are the most important to focus on for your organization, and importantly, which analytics are the most appropriate to use when answering the questions facing you and your colleagues.  We’ll address the challenge of data silos and of “messy data,” and review the lifecycle of an analytics project from conception to delivery of results.  Use cases will be drawn from areas including talent acquisition, employee retention, workforce planning, employee engagement, and compensation.  Finally, ethical considerations surrounding the use of employee data will be addressed. 

You’ll come away from this course with the ability to improve your decision-making by optimizing the use of data, analytical methods, and especially your human capital.

Data Analytics for HR Professionals MicroCredential 

Participants must complete all sessions in order to be awarded a certificate of successful completion. Participants are surveyed anonymously in advance of the training so as to give instructors a better sense of the participant’s background and expectations. Participants are also surveyed at the end of the program to determine the program's impact and to allow for feedback in order to continuously improve the program. 

Who Should Attend

This microcredential course is primarily designed for the Director level and above; for functional area leaders; general management; and C-suite executives who want to learn how to drive business results by incorporating human resources data and analysis into decision-making.

Participants should possess strong management and communication skills, as well as a basic working knowledge of Microsoft Excel.  No previous knowledge of or experience with statistics or analytics is required, though statistical tools and methods will be mentioned as appropriate in discussions of HR topics.

Workshop Descriptions

Session 1:  Analytics, and What It Can Contribute to HR; Descriptive, Predictive, etc.

Session 2:  Talent Acquisition

Session 3:  Retention and Turnover

Session 4:  Employee Engagement

Session 5:  Diversity and Inclusion; HR Metrics

Session 6:  Data to Action:  Persuasive Storytelling and Ethical Considerations

_____________________________________________

About Julie Alig, Ph.D.

Julie Alig is a data geek who’s passionate about telling stories and works with organizations, businesses, non-profits, colleges and universities, and other groups to uncover the stories in their data, using statistics and visualizations. Armed with this knowledge, they make strong, strategic decisions to move forward.  She earned her Doctorate in Political Science from the University of Chicago, and was awarded a Fulbright Scholarship to conduct her dissertation field research in Stuttgart, Germany.  She graduated cum laude from Columbia College in New York City with a Bachelor’s in History and French Literature.  She lives in Manchester with her husband and two children.

NHTI is proud to sponsor the 2nd annual Virtual Learning Summit kicking off on August 2nd, with a full day of concurrent sessions on August 3rd.

This virtual conference features expert keynotes, break-out sessions, and discussions designed especially for teachers & administrators.  

The Virtual Learning Summit brings enthusiastic and innovative educators together to ignite learning with creative, effective and practical ways using educational technology with sound pedagogy. 

• Leverage distance learning on the fly with less stress
• Advance your video creation skills
• Learn ways to hack the tools you have at your fingertips
• Upskill with all things G Suite for Learning including NEW MEET!
• FlipGrid, Screencastify, PearDeck and other integrations 

No matter where you are in your journey using G Suite and other technology tools and techniques, you will instantly be inspired and learn ways to make your job more fulfilling and your students successful in their learning endeavors!    

Virtual Conference Kickoff with Networking, Prizes & Keynote Monday  8/2

Breakout session options to learn, try & apply all day Tuesday 8/3

Registration only $149

Sessions are led by highly qualified, practicing educators and edtech leaders who are also Google Certified Trainers.  

We accept PO's!  Register now & pay later.  Just select check option upon checkout.

Groups of 10 or more are only $99 ea.  Email nhtibtc@ccsnh.edu to register your group today!

ONDEMAND - Instructor Led, pick your start date!  Register here.

Accounting Fundamentals covers all the bases, from writing checks to preparing an income statement and closing out accounts at the end of each fiscal period. Whether you're a sole proprietor looking to manage your business finances or you simply want to gain an understanding of accounting basics for career advancement or for personal use, this course will give you a solid foundation in financial matters.

Accounting Fundamentals II will provide you with a solid understanding of corporate accounting practices. You will learn key topics including as special journals, uncollectible accounts receivable, notes and interest, accrued revenue and expenses, dividends, retained earnings and more.

This QuickBooks Online will teach you how to manage your business financials with QuickBooks Online. You will learn to use key features of QuickBooks Online and gain hands-on experience creating invoices, receipts, and statements; track payables, inventory, and receivables; generating reports; and more. Whether you're new to QuickBooks or need a quick refresher, this course will empower you to take control of your business's financial accounting.

Learn to manage the financial aspects of your small business quickly and efficiently using QuickBooks Online. With this online version, you get all the advantages of computing in the cloud, so that your accounting files will be available to you virtually anytime, anywhere. This course is going to dive a bit deeper into some of the more intermediate-level features of the QuickBooks Online (QBO) program—from tracking product and service items and managing inventory to customizing sales forms.

Please complete the courses in the bundle two months apart to avoid overlapping. Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.