Cambridge-Isanti Community Education

Learn to improve and control processes through hypothesis testing, design of experiments, and statistical process control. Apply the concepts learned in the Introduction and Intermediate Six Sigma Green Belt courses. Finish the course Six Sigma Green Belt Certified. This course can be taken alone or as part of the 3 course Certificate in Six Sigma Green Belt. Class Details Unit 1 Analyze Exploratory Data Analysis Correlation and Regression Hypothesis Testing Basic Concepts Point & Interval Estimation Unit 2 Major Tests Paired-comparison Tests Single-Factor ANOVA Chi-square Unit 3 Improvement Techniques Design of Experiments (DOE) Introduction Terminology Design Types Implement and Validate Solutions Response Surfaces EVOP DOE Improvement Analysis Unit 4 Control Concepts Statistical Process Control (SPC) Objectives and Benefits Rational Subgrouping Application of Control Charts Variable Charts Attribute Charts Analysis of Control Charts Control Plans For more information, visit our question and answer page - Click Here.

Learn about the accounting equation and the five categories involved in every business (Assets, Liabilities, Owner’s Equity, Revenue and Expenses). Discover how to create a chart of accounts for your business. Learn how double entry bookkeeping works and the process of recording debits and credits. Identify, analyze and record transactions using journal entries under the cash basis accounting method. This course can be taken alone or as part of the 3 course Bookkeeping Certificate. Class Details Unit 1: The Accounting Equation and Categories The Accounting Equation The Five Accounting Categories The Chart of Accounts Account Placement Activity ~ Categorizing Accounts Cash Basis Accounting vs. Accrual Basis Accounting Unit 2: Debits and Credits T-Accounts Debits and Credits Double Entry Bookkeeping Analyze Financial Activities (Transactions) Unit 3: Assets, Liabilities, and Owner’s Equity Recording Transactions for Assets Recording Transactions for Liabilities Recording Transactions for Owner’s Equity Unit 4: Revenue and Expenses Recording Transactions for Revenue Recording Transactions for Expenses Activity ~ Recording Transactions

Stay current with this class. Examine the life of an Excel worksheet and workbook, from creation to presentation. Learn how an Excel worksheet is constructed, populated with content, and edited for delivery. Master the options that can take your Excel worksheet from plain, drab numbers to exciting and engaging multimedia. This course can be taken alone or as part of the 3 course Certificate in Mastering Excel. Class Details Unit 1: Excel From The Ground Up Why businesses use Excel for spreadsheet management Technical requirements to use Excel (and all Office modules) Launch Excel and create your first Excel worksheet Discover how to protect and save your document Set your document’s Properties and Attributes including Subject, Title and Author Unit 2: Excel Document Creation Explore the different parts of the Excel worksheet and document navigation Understand cells and their makeup Learn how to populate, format and merge cells Create multiple worksheet “workbooks” Learn how to insert comments and check spelling Unit 3: Advanced Features and Functionality Create and manage formulas and functions Filter and sort tables and data Create “live” connections between multiple worksheets Create effective and informative table and charts Unit 4: Excel Management and Sharing Create meaningful file names and understand filing systems to manage Excel documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including setting print areas Learn how to export Excel tables and charts to PowerPoint presentations and Word documents Use Outlook to send Excel worksheets and workbooks to other users For more information, visit our question and answer page - Click Here.

In this course, you will learn how to post journal entries to the correct general ledger accounts impacted by each transaction. This course will show you how to make sure your general ledger balances at the end of each month by preparing an unadjusted trial balance. You will learn how to look for errors when you don’t balance, and how to determine to correct entries. After posting correcting entries and/or adjusting entries, you will verify debits and credits equal with an adjusted trial balance. This course also goes through the steps of performing monthly bank reconciliations. This course can be taken alone or as part of the 3 course Bookkeeping Certificate. Class Details: Unit 1: The General Ledger What is the General Ledger Why must the general ledger balance Posting to the general ledger Activity ~ Posting to The General Ledger Unit 2: The Unadjusted Trial Balance What is the unadjusted trial balance Verify debit and credit balances Finding errors Activity ~ Find The Errors Unit 3: Correcting Entries and Adjusting Entries Determine correcting entries Adjusting entries and how to prepare them Posting correcting entries and adjusting entries to the general ledger Activity ~ Preparing Entries and Posting to General Ledger Unit 4: The Adjusted Trial Balance Verify the accuracy of the adjusted trial balance Prepare monthly bank reconciliations Activity ~ Prepare a Bank Reconciliation

Data analysis is one of the most sought after skills in the workplace. Companies have vast amounts of data and need people with the ability to analyze it. Get an understanding of how to analyze data in a business setting. This course can be taken alone or as part of the 3 course Certificate in Data Analysis. Class Details Unit 1: Looking for Differences between Groups Two separate groups Two related groups Three or more groups Unit 2: Looking for Relationships Pairs of variables Clusters of variables Predicting one variable from one or more variables Unit 3: Looking at Ratings Tests of difference using ratings Tests of relationship using ratings Unit 4: Looking at How to Report the Results Visual displays How to draft the narrative How to engage your audience For more information, visit our question and answer page - Click Here.

Learn how to organize, display and calculate your data. Find out how to consolidate data proficiently. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Discover how easily pivot tables can be created to quickly summarize large amounts of data. This course can be taken alone or as part of the 3 course Certificate in Mastering Excel. Class Details Unit 1: Organizing Worksheet and Table Data Introduction to tables Formatting tables using table styles Using formulas in tables Sorting and Filtering table data Unit 2: Understanding Popular Excel Functions Understanding Named Ranges Applying business functions Creating functions that handle text Performing basic lookup functions Creating functions that work with dates and times Unit 3: Improving Worksheet Appearance Formatting cells in worksheets Correcting common function errors Creating and using templates Customizing Excel toolbar Unit 4: Analyzing Data Using Data Validation and Pivot Tables Understanding how to convert text to columns Understanding how to analyze spreadsheet data Understanding the basic pivot table layout and key terms Creating and formatting simple pivot tables For more information, visit our question and answer page - Click Here.

Advanced Excel contains tools that can help you prepare your worksheets accurately, examine your data for authentication, and find answers to your most difficult questions. Learn required business functions along with tools required to analyze data efficiently within the workplace. Save time by protecting your valuable data. Discover how to attractively visualize your data into meaningful information with confidence. This course can be taken alone or as part of the 3 course Certificate in Mastering Excel. Class Details Unit 1: Advanced Functions Used To Make Business Decisions Applying multiple criteria to functions Using And criteria Using Or criteria Using And and Or and Not criteria Advanced Logical functions Using If -Then control statements Implementing If functions with Aggregate functions Unit 2: Functions Used to Make Financial Decisions Learning basic financial functions Applying functions to perform loan calculations Computing loan payments Computing interest rate Computing number of payment periods Computing present value of a loan Working with additional functions Unit 3: Applying Different Scenarios Using Excel Data Tools Understanding Different What-If Analysis Tools Performing What-If Analysis to see how data changes outcomes in formulas Using Scenario Manager Using Data Tables Using Goal Seek Applying rules to manage cell data Implement validation rules to avoid invalid entries Entering validation rules Avoiding duplicate data entries Unit 4: Powerful Tools Used to Complete Data Implementation and Analysis Exporting and Importing Data into Workbook Protecting a workbook Making improved business decisions using pivot tables Creating an Excel Dashboard to visually display relevant data For more information, visit our question and answer page - Click Here.

Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using modeling features and relationships. Perform calculations using DAX (Data Analysis Expressions) functions. Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports. This course can be taken alone or as part of the 3 course Power BI Certificate. Class Details Unit 1: Power Query Review the ETL Process Insert columns using different methods Group, Summarize, Pivot, and UnPivot data Merge and Append queries Unit 2: Data Modeling What Data Modeling is Modeling Options Create and manage relationships Create Date table Unit 3: DAX Introduction to DAX Calculate columns and measures Time Intelligence functions Quick Measures Unit 4: Reports Filters versus Slicers Visual Hierarchies and Drill downs Drillthrough Define visual interactions Apply conditional formatting For more information, visit our question and answer page - Click Here.

Expand your knowledge of Power BI Desktop to the highest level. Explore the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results. This course can be taken alone or as part of the 3 course Power BI Certificate. Class Details Unit 1: Power Query Utilize Column profile, distribution, and quality Perform fuzzy match Duplicate versus Reference queries Debug errors Unit 2: Data Modeling What a Star Schema is Understand relationship types Manage relationships Unit 3: DAX Understand contexts CALCULATE function COALESCE function Compute visual totals accurately Unit 4: Reports Insert Objects Create Bookmarks For more information, visit our question and answer page - Click Here.

Identify those skills that all great leaders possess, while learning new skills that will help take you to the next level. Whether you are leading a department or an organization, gain the knowledge you need to be successful. Learn how to incorporate a developed image and communication skills that will rocket you to that next level. This course can be taken alone or as part of the 3 course Certificate in Leadership Development. Class Details Unit 1: Mapping your Career for Success Defining where you want to be in your career in 5, 10, 15 years Setting and monitoring your career goals Establishing a mentor partnership as a start in your professional career Unit 2: Developing your Professional Career through Non-Verbal Communication The difference between verbal and non-verbal communication Conveying the right message with your body language Writing what you think Haptics – Using touch to convey non-verbal communication How to understand others non-verbal communication Unit 3:Image is Everything You are your brand What you wear can determine where you go How to determine if your image is headed in the right direction How your communication and your image should agree with each other Unit 4: Using Social Media to help develop your Professional Career The purpose of Social Media How to use Social Media to create a professional online presence How to avoid negative images trap that many people fall victim to on Social Media For more information, visit our question and answer page - Click Here.

Six Sigma professionals are in demand by organizations around the world. Our Green Belt training teaches participants problem-solving skills, using the DMAIC (Define, Measure, Analyze, Improve and Control) model. After completing this challenging course, Six Sigma Green Belts serve their organizations as a trained specialist able to work on Six Sigma projects that benefit the organization. This course can be taken alone or as part of the 3 course Certificate in Six Sigma Green Belt. Class Details Unit 1 Measure - Data & Process Analysis Process Analysis and Documentation Process Modeling Process Inputs and Outputs Collecting and Summarizing Data Data Types Data Collection Methods Data Accuracy and Integrity Graphical Methods Unit 2 Measure - Probability Probability and Statistics Valid Statistical Conclusions Central Limit Theorem Basic Probability Concepts Unit 3 Probability Distributions Binomial Distribution Poisson Distribution Normal Distribution Chi-square Distribution Student’s t Distribution Unit 4 Measure - Capability & Measurement Measurement System Analysis Process Capability and Performance Process Capability Studies Process Performance vs. Spec Process Capability Indices Short-term vs. Long-term Capability Process Capability for Attributes For more information, visit our question and answer page - Click Here.

Enhance your understanding of program evaluation within the nonprofit context. Find out how to improve your evaluation planning, data collection, data analysis and data use. Special attention will be paid to the real-world challenges that organizations may face when conducting evaluation, including staff time, costs and reporting evaluation results to funders. This course can be taken alone or as part of the 2 course Certificate in Nonprofit Administration. Class Details Unit 1: Introduction to Nonprofit Evaluation & the Logic Model What evaluation is and is not Why evaluation is important to nonprofit organizations and why your funders are asking you for it Planning for evaluation begins when you apply for the grant Types of evaluation, and the approaches best suited to nonprofit programs Planning tools for evaluation – introduction to the logic model Crafting accurate, concise outcome statements Unit 2: Creating an Evaluation Plan What an evaluation plan is and why you need one Using outcomes from our logic model to create your evaluation plan Setting priorities for your evaluation (navigating barriers based on budget, funder requirements, staff time and staff capacity) Creating indicators for your outcomes Defining benchmarks and targets where appropriate Unit 3: Collecting the Data Taking stock of the data you already use Making data collection systematic Choosing and/or creating data collection tools – output information, surveys, interviews, focus groups Unit 4: Analysis, Reporting and Use – Putting it All Together Appropriate analysis of the common data collection tools covered in Unit 3 Common analysis mistakes and how to avoid them Reporting to various stakeholders (funders, donors, Board of Directors and the community) Using data for program improvement For more information, visit our question and answer page - Click Here.

Acquire the fundamentals of the most popular Web 2.0 technologies. Take away a functioning web application hosted on a web server that is both accessible and Search Engine Optimized. This course can be taken alone or as part of the 3 course Certificate in Web Design. Class Details Unit 1: Javascript Expressions and Control Flow Functions, Objects, and Arrays Form Validation and Error Handling Accessing CSS from JavaScript Unit 2: MySQL Install a local testing server Use phpMyAdmin to create MySQL databases and manage users Create MySQL database tables with common field types and options Gain a working knowledge of most common MySQL statements Unit 3: PHP Structure Expressions and functions Objects and arrays Practical use Unit 4: Accessibility and Search Engine Optimization Accessibility Guidelines Accessibility Conformance Search Engine Optimization For more information, visit our question and answer page - Click Here.

Learn how to style web pages using Cascading Style Sheets (CSS) coding language. Topics include using inline, internal, and external CSS, web typography, formatting text, working with web colors, using Google fonts, working with id and class selectors, working with elements, creating page layouts using elements, and CSS box model. This course can be taken alone or as part of the 3 course Coding Certificate. Class Details Unit 1: Getting to Know CSS - about CSS, CSS syntax, CSS types, working with internal CSS, styling text, styling links, styling lists, and styling tables Unit 2: Using External CSS - working with external CSS sheets, styling a multi-page website, Google fonts, and Web colors Unit 3: div Elements - id Selectors, introduction to elements, floating elements, Clearing Unwanted Floated Elements, web page layout using elements Unit 4: More about div Elements - centering a web page, CSS box model, resetting margins and paddings, class selectors, inline CSS, tag For more information, visit our question and answer page - Click Here.

Receive comprehensive and intensive preparation with skills and techniques you can put to use on Monday morning. Discover a workable conflict management model, along with successful and practical conflict management strategies. Learn how to improve your negotiation skills for a win-win outcome. Find out more about yourself and others using personality profiles for better work performance. This is a series of 3 courses. Spring 24 Dates Summer 24 Dates Conflict Management 04/01/24-04/26/24 06/03/24-06/28/24 Negotiation: Get What You Want 05/06/24-05/31/24 07/01/24-07/26/24 Using Personality Profiles for Better Work Performance 06/03/24-06/28/24 08/05/24-08/30/24 For more information, visit our question and answer page - Click Here.

Practice the basic, practical language skills needed to effectively communicate with your Spanish-speaking patients and their families. Whether you need a refresher, or speak no Spanish, this class will give you the skills you need. NOTE: Students will also need to purchase McGraw-Hill Education Complete Medical Spanish, 3rd Edition (less than $15) For more information, visit our question and answer page - Click Here.

Video marketing is the latest hot new marketing trend. Shoppers who viewed product videos were 144% more likely to add the product to their cart. Video with good SEO has a 53% higher chance of showing up on page one of Google searches. When done correctly, video can tell a story, and stories connect people. Video also leads to an emotion ‘trigger’ that plain text cannot do. This is a series of 2 courses. Spring 2024 Dates Summer 2024 Dates Video Marketing 04/01/24-04/26/24 06/03/24-06/28/24 YouTube for Business 05/06/24-05/31/24 07/01/24-07/26/24 For more information, visit our question and answer page - Click Here.

Take away the key practices you need to develop and hone your business writing communication effectively and successfully. Learn best practices for crafting effective, professional business documents. Find out how to avoid grammatical pitfalls and acquire business writing principles that will be good for years to come. This course can be taken alone or as part of the 3 course Certificate in Business Writing. Class Details Unit 1: Writing as a Process Audience, Purpose, and Medium Outlining for Successful Writing Organization Models (Choosing a Model that Works) Principles of Business Communication Unit 2: Written Communication in the Workplace Writing Reports (formal and informal) Drafting and Revision Writing the First Draft Constructing Openings and Closings that Work Unit 3: Writing a Proposal Writing for Your Readers Writing Effective Content Safeguarding Users Ethical Considerations Unit 4: Collaborative Writing and Research Research and Team Writing Collaborating Across Departments Working Through Conflict For more information, visit our question and answer page - Click Here.

A recent study conducted by the American Management Association revealed that out of twenty-five management skills, conflict management was the only one positively correlated to higher earnings and promotion. Discover a workable conflict management model, discuss case studies in conflict management, and then take away successful conflict management strategies to apply in your workplace. This course can be taken alone or as part of the 3 course Certificate in Workplace Communication. Class Details: Unit 1: Understanding Conflict Definition of conflict. The up side of conflict. Describe performance expectations related to conflict. Unit 2: Understanding the Conflict Management Model Using the model Dialog for a conflict conversation When to take action and address a conflict situation Unit 3: Conflict Management Case Studies Review of real world cases Analyze and evaluate the cases Unit 4: Strategies for success Creating a standard of performance Creating your own dialog Applying the model For more information, visit our question and answer page - Click Here.

Enhance your management skills through this course for supervisors, managers, and emerging leaders. Discover the keys for effectively managing your employees. Find out how to create clear expectations, engage and motivate employees, and increase your effectiveness through use of the DiSC personality profile. By the end of the course you will be managing like a pro - quickly and with confidence. This course can be taken alone or as part of the 3 course Management Certificate. Class Details Unit 1: Fundamentals of Management How to determine, set, and communicate job expectations Linking employee behaviors to performance Describing performance expectations Increasing employee commitment and pride and evaluate performance Unit 2: Employee Engagement Motivating and engaging employees to get the job done Tools and techniques to increase employee buy-in and commitment How to communicate with employees and get them involved and engaged in their own performance evaluations Unit 3: Increasing your Success Part 1 Enhancing your ability to manage effectively In-depth analysis of the behaviors of your style Unit 4: Increasing your Success Part 2 Behaviors that inhibit your ability to manage effectively Advanced analysis of the behaviors of your management style For more information, visit our question and answer page - Click Here.