Cambridge-Isanti Community Education

Designed for non-financial managers, business owners, entrepreneurs, and other decision-makers, this advanced course will take the mystery out of money matters. Learn to assess and analyze the financial information that drives your business. Be empowered to make smart decisions when it comes to budgeting, setting goals, and assessing performance within your own area of influence. This course can be taken alone or as part of the 3 course Certificate in Accounting and Finance For Non-Financial Managers.. Class Details Unit 1: Financial Strategies 1.1 Your Role in Financial Decision Making Who is responsible for the financial decisions in your company? The Goal of Business 1.2 Understand the Language of Finance Accounting as a Language Learn the Language Visual Activity – Accounting Process Accounting and Recordkeeping Systems Self Check – Account Categories 1.3 Read the Story A Word about Financial Concepts ***Financial Concept: The Accounting Equation*** ***Financial Concept: The Matching Principle*** The Common Financial Statements Income Statement The Balance Sheet Statement of Cash Flows 1.4 The Purpose of Financial Statements Unit 2: Financial Dashboard – Introduction to Financial Gauges 2.1 Understand Basic Financial Concepts Introduction The Story Statements Tell ***Financial Concept: The Accounting Equation*** ***Financial Concept: The Profit Matching Principle*** ***Financial Concept: The Fund Matching Principle*** ***Financial Concept: Cash Basis vs. Accrual Basis Accounting Methods*** ***Financial Concept: Cash vs. Profits*** ***Financial Concept: Debt vs. Equity (Optimum Capital Structure)*** 2.2 Financial Strategies Financial strategies stem from business goals Take a Look: Example Financial Strategies 2.3 Financial Gauges Introduction to Financial Gauges Your Financial Gauges Profitability-based gauges Performance-based gauges 2.4 Reading Your Financial Gauges The Story Financial Gauges Tell Research and Analysis Unit 3: Financial Gauges - Profitability 3.1 Profitability Gauges Ratio Analysis Financial Gauge: Net Profit Margin (or) The Bottom Line Financial Gauge Gross Profit Margin Financial Gauge: Operating Margin Using Profitability Ratios 3.2 The Components of Profitability The Origin of Profits Sales and Expenses 3.3 Sales Sales Strategies Pricing Strategies 3.4 Cost of Goods Sold and Cost of Sales Cost of Goods Sold Gross Profit Margin Gross Profit Analysis and Planning Evaluate Profitability of Product or Service Lines 3.5 Expenses Budget vs. Actual Analysis Cost Management and Efficiency Unit 4: Financial Gauges - Performance 4.1 Making Money The Goal of Business Value Growth Company Resources 4.2 Taking Advantage of Assets Tangible vs. Intangible Assets Cash 4.3 Making the Most of Liabilities and Equity Liabilities Equity 4.4 Performance Financial Gauges Financial Gauge: Current and Quick Ratio (Liquidity) Financial Gauge: Return on Assets Financial Gauge: Return on Equity Financial Gauge: Debt to Equity Ratio 4.5 Financial Analysis and Planning Summary Downtown Publishing Financial Performance Analysis Summary For more information, visit our question and answer page - Click Here.

Being engaged with online learners is one of the biggest weaknesses of online teachers. Come discover how to continually engage students and build student success through your interaction, feedback and communication. You will get first hand experience as your instructor models great interaction and engagement, plus you will come away with practical, how-to tips to better engage your online learners. This course can be taken alone or as part of the 3 course Certificate in Online Teaching. Class Details Unit 1: How Continual Engagement Helps You Foster Effective Online Discussions What is continual engagement? Why is continual engagement important? Breaking down the barriers to effective continual engagement in your discussion interaction Unit 2: Building Your Students’ Success through Your Interaction Why continual engagement in online discussion is important to your students’ success Choosing your words carefully in discussion interaction Strategies to use at the beginning of your term Strategies to use as the term gets underway Strategies to use when things get hectic Unit 3: Assessing Your Students’ Performance Giving effective feedback Communicating with students about grades Some special challenges of group work and how to overcome them Unit 4: Keeping Your Communication Skills Sharp How networking with your peers can build your skills Using break times effectively Working with an assistant How online interaction enhances your face-to-face instruction 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.

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.

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.

Mobile games are the fastest-growing segment of the market as more and more people play casual games. Learn the basics of the video game design process, understand the main video game genres, and use a game development application to begin your journey of making games. This course can be taken alone or as part of the 2 course Certificate in Basic Game Design. Class Details: Unit 1: A brief history of Video Game Development Arcades & Consoles From PCs to Multiplayer Play a Game -Game Analysis Game Maker Introduction Unit 2: Player Motivation Geographics, demographics, and psychographics Who Plays Why We Play Game Maker Making Art: About Sprites, Objects, Rooms Unit 3: Platforms, Genres and Story Elements Game Application: The Audience Platforms & Player Modes Story Elements: Premise, Backstory, Synopsis, Theme, & Setting Character Archetypes & Character Development Game Maker: Programming Events & Actions Unit 4: The Production Process Documentation: The Game Design Doc Creating the Team Production Phases Marketing Game Maker: Your First Game

Medical terminology is the first step to any career in the medical field or simply to understand your family’s medical visits. No prior experience is necessary. This highly specialized language involves word building with root words, prefixes, suffixes, and abbreviations. You will leave with a solid foundation of medical language, as well as basic medical billing and coding terminology. After submitting and passing the open-book exam included in the workbook you receive in class, you will earn a Certificate of Completion. This comprehensive course is taught by longtime educator LeeAnne Krusemark, and Credentialed Medical Professional Vanessa Grinnell, RRT. Your Zoom login link will be sent the day before class. If you do not see it in your inbox, please check your spam folder first for an email from the instructor at LeeAnne@KrusemarkGrinnell.com and/or ceregister@c-ischools.org, and then call us for an update if you haven't received it. Questions about our class policies, weather cancelations or accessing online classes? Click here for our Class Info & Policies.

Move your management style and abilities to the cutting-edge of successful practice. Shatter issues and meet both organizational goals and employee satisfaction and productivity. Take advantage of your opportunity to develop new strategies to enhance your management skills. Conquer a new management skillset that will last a lifetime. Advance from challenges to solutions for your organization, and your career. This course can be taken alone or as part of the 3 course Certificate in Workplace Communication. Class Details: Unit 1: Introduction to the Negotiation Your natural bargaining style and how you can strengthen it Understanding winning - the hallmarks of a successful negotiation The steps to planning a successful bargaining process Knowing your power sources Balancing firmness and flexibility Unit 2: Option Building and Boundary Setting Creating goals and priorities in the deal Creating bargaining boundaries How to build your options How to create better options for your opponent, without giving away what you value Unit 3: Managing the Negotiating Process Managing the process Managing yourself Managing the other side Managing relationships Managing communication Unit 4: Black Belt Skills Planning to give more and get more Developing a BATNA, knowing when to employ it Crafting the agreements and commitments Diverting tricky tactics and attempts at dirty dealing

Move your management style and abilities to the cutting-edge of successful practice. Shatter issues and meet both organizational goals and employee satisfaction and productivity. Take advantage of your opportunity to develop new strategies to enhance your management skills. Conquer a new management skillset that will last a lifetime. Advance from challenges to solutions for your organization, and your career. This course can be taken alone or as part of the 3 course Certificate in Workplace Communication. Class Details: Unit 1: Introduction to the Negotiation Your natural bargaining style and how you can strengthen it Understanding winning - the hallmarks of a successful negotiation The steps to planning a successful bargaining process Knowing your power sources Balancing firmness and flexibility Unit 2: Option Building and Boundary Setting Creating goals and priorities in the deal Creating bargaining boundaries How to build your options How to create better options for your opponent, without giving away what you value Unit 3: Managing the Negotiating Process Managing the process Managing yourself Managing the other side Managing relationships Managing communication Unit 4: Black Belt Skills Planning to give more and get more Developing a BATNA, knowing when to employ it Crafting the agreements and commitments Diverting tricky tactics and attempts at dirty dealing