Wednesdays, 3pm - 5pm on Feb 3rd, 10th and 17th

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 Boisvert 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)

Wednesdays, March 3 - April 7 9:00am - 11:00am 

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.

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.

Register via Ed2Go  Self paced or instructor led option

Many businesses rely on spreadsheets to manage budgets, schedules, and tracking. Microsoft Excel is considered the industry standard for spreadsheets. If you use Excel regularly and want to learn more advanced functions in this powerful software, this course is for you.

You will learn to how harness the power of Excel's data analysis tools and AutoFilter commands and how to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other intermediate functions to your professional skill set. In addition, you will learn to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems.

Includes:

• Charts & Graphs
• Filter
• Sort
• Goal Seeking
• Pivot Tables
• Solver
• Sparklines
• Macros
• Functions
• V Lookup

Register here:  All information & registration via Ed2go

There is a strong demand for Adobe Creative Suite skills. In the Adobe Certified Associate course, you will learn five of the most often-used Adobe programs: Dreamweaver, Illustrator, Photoshop, InDesign, and Animate (formerly Flash). You will read short readings, complete exercises and watch video demos and reviews of exercises, take quizzes and exams, and complete a project.

By focusing on these five programs, you will learn how to put all the parts and pieces together to develop the Adobe Creative Suite skills needed to be professionals in the design field. This course includes a voucher to take the certifying exam. Proctor fees may apply, which are not included.

 https://careertraining.ed2go.com/nhti/training-programs/adobe-certification/?Category=arts-and-design