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

Unlock the lucrative world of ghostwriting and become the invisible voice behind powerful stories. This comprehensive class reveals how to build strong client relationships, protect confidentiality, and capture your clients’ unique voices with authenticity and flair. You’ll explore diverse ghostwriting projects, master pricing strategies, navigate contracts with confidence, and learn how to build a thriving, well- paid career that keeps the work—and the income—flowing. The instructor LeeAnne Krusemark is a former journalist, current author and editor, and a nationwide Professor of Publishing at higher learning institutions, including Harvard Adult Education. Informative handouts for future use are included in class fee. The webinar login information will be emailed the day before class. 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.

Understand the basics of HTML coding language. Learn to build simple web pages by hand coding, use HTML tags to create paragraphs, heading, lists, links, insert images and tables and more. Discover how to create a simple multi-page website with images, text and a navigation bar. This course can be taken alone or as part of the 3 course Coding Certificate. Class Details Unit 1: HTML Basic Tags naming convention, tags: h, p, b, i, u, hr, br, attributes Unit 2: More HTML Tags links, lists, tables Unit 3: Images, directory structure Unit 4: Creating a multipage website, domains, hosting, pointing, FTP For more information, visit our question and answer page - Click Here.

You don’t need to be famous to have a legacy to leave behind. Create an inspirational autobiography for family, friends, and others. Learn how to recall vivid memories, analyze events and people that shaped who you are, and bring your story to life. Your handout, included in the class fee, will have an outline to help you organize and write your memoir step-by-step. Printing/publishing options will also discussed. The instructor LeeAnne Krusemark is a former journalist, current author and editor, and a nationwide Professor of Publishing at higher learning institutions, including Harvard Adult Education. 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.

Learn the top five considerations when starting a social network as well as tips to manage an online community. Identify how to manage this influx of information created by the new media revolution. Discover what you might be doing wrong in social media as well as essential policies to have in place for your employees and company. This course can be taken alone or as part of the 3 course Certificate in Social Media For Business. Class Details Unit 1: Running a Community and Creating Your Own Social Network Using Ning Online Communities and Creating Your Own Social Network with Ning Top 5 Considerations When Starting a Social Network What Goes into Build a Great Social Network What is an online community manager What is Ning and How to Use the Platform Examples of Companies Using Ning Unit 2: What Tools to Use for Your Organization What tools and platforms will help get content on the web Readings on top new tools to consider How to select which tool to use How video fits into online marketing Organizing and collaborating with Google products How to take advantage of mobile and local in applications and search Unit 3: Integrating Social Platforms into Your Web Site Discovering how web design has changed and what is needed for true integration Understanding elements on websites that increase interaction, engagement, search engines findability Learn best practices for website usability and landing page design Discuss how your sites compare and generate next steps that will improve your business Unit 4: Developing a Manageable Work Flow: Time, Resources, Policies, and Trends Developing a Manageable Work Flow Time and Resources: How do you know where to spend your time? Target Social Media Influencers to Boost Traffic and Sales Is Your Company Ready for Social Media or Are They Holding You Back? Trends - What's Next or Are We Still Working on Last Year's Trends? Social Media Policies and Planning For A Crisis For more information, visit our question and answer page - Click Here.

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

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.

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.