Cambridge-Isanti Community Education

InDesign allows you to create simple to complex multi-page documents such as brochures, flyers, books and magazines. Explore InDesign tools and capabilities to create professional documents. Learn how to manage the InDesign environment, create, setup, design, enhance and finalize multi-page documents. Access to Adobe InDesign software required This course can be taken alone or as part of the 3 course Graphic Design Software Essentials Certificate. Class Details Unit 1: Getting to Know the Interface and Setting up a Document Interface menus Tools Panels Starting and setting up a multi-page document in InDesign Unit 2: Working with Objects and Color Learning to work with color panels Creating, managing and applying color to elements Inserting and managing images and illustrations into an InDesign document Unit 3: Working with Text Learning about insert and flow text to multiple pages Managing long text documents Text editing in InDesign documents Unit 4: Typography Advance typography tools and menus Character and paragraph settings and styles Creating print-ready PDF files. For more information, visit our question and answer page - Click Here.

Learn all the basics of Photoshop to effectively work with selection and editing tools, layers, and masks to edit, retouch and enhance existing images or create your own composite digital art work. Impress your business organization, friends and family by enhancing their photos and create magazine cover quality enhanced images. Access to Adobe Photoshop software required. This course can be taken alone or as part of the 3 course Graphic Design Software Essentials Certificate. Class Details Unit 1: Getting to know the Interface and Selection Tools Interface menus Tools Panels Working with the various Selection tools Unit 2: Working with Layers and Masks Layers and layer management Non- destructive editing using masks How to type and format text Using various type formatting and style tools and panels Unit 3: Image Correction & Enhancement Photo correction and enhancement tools Crop, dodge and burn Recoloring, retouching Healing brushes Unit 4: Using the Drawing Tools How to use the Pen tool Other drawing tools in Photoshop Advanced drawing and selection File formats How to save files for print or web 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: Developing a Survey Purposes of surveys Fundamentals of Survey Research Ethical Considerations Likert Scales Unit 2: Comparing Means Chi-Square Statistical Significance Communicating Results Graphically and Textually Practical Problems involving Means Comparisons Unit 3: Finding Differences between Groups ANOVA Post Hoc Comparisons Communicating Results Graphically and Textually Practical Problems Involving ANOVA Unit 4: Individual Research Inquiries Developing Research Questions Setting Up Study Communicating Results Graphically and Textually 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.

A project and activity based course, you will get the opportunity to practice with Google Analytics for more advanced learning and skill development. Implement Google Analytics for your website. Gain the skills necessary for employing this most useful tool. This course can be taken alone or as part of the 2 course Google Analytics Certificate. Class Details Unit 1: Google Analytics Setup Your Google Analytics Account Navigating Google Analytics Google Analytics Reports and Dashboards Unit 2: Google Analytics Reports Acquisition Reports Behavior Reports Conversions Unit 3: Google Analytics Data Collection Categorizing Users and Sessions Applying Configuration Settings Generating Reports Unit 4: Creating Custom Dimensions and Metrics Analyzing Data Event Tracking Applying Demographic Filters 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.

Learn how to write more advanced SQL queries for enhanced decision making. Discover how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. Learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution. This course can be taken alone or as part of the 3 course SQL Certificate. Class Details: Unit 9: Creating Advanced Subqueries Structured Query Language Review Using the IN keyword to link queries Using the EXISTS keyword to link queries Using the ANY keyword to link queries Using the ALL keyword to link queries Unit 10: Creating Advanced Joins Creating inner joins review Creating outer joins review Creating joins with aggregate functions Creating nested joins Unit 11: Creating Union Queries Creating UNION queries Creating UNION ALL queries Creating a WHERE clause and multiple UNION queries Unit 12: Transaction Processing, Stored Procedures, Triggers Implementing transaction processing Implementing stored procedures Implementing triggers For more information, visit our question and answer page - Click Here.

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 responsive Web design which enables Web designers and developers to build and maintain a single website to serve all kinds of devices sizes: smartphones, tablets, laptops and more. This course can be taken alone or as part of the 3 course Certificate in Web Design. Class Details Unit 1: Responsive Web Design Planning your layout Creating HTML containers, content, and links Unit 2: Responsive Web Design - Styling Creating and styling the layout with CSS Creating a menu system Styling headings, body text, and footers Unit 3: Responsive Web Design – Styling the Navigation & Making Adjustments Making layout adjustments for different screen sizes Swapping high-resolution graphics for Retina displays Making sure content is printable Where to go for more information Unit 4: Responsive Web Design / Additional Frameworks What is Bootstrap Creating a basic template Reviewing basic styles and typography Where to go for more information For more information, visit our question and answer page - Click Here.

Acquire the basic skills to boost your web site traffic, including how to analyze your visitor traffic, how to use search engine optimization to get greater visibility and exposure in Google searches, and how to redesign your web site copy to increase your visitors and results. No experience necessary, but if you are at an advanced level, your instructor is an SEO expert and can answer your toughest questions. This course can be taken alone or as part of the 3 course Certificate in Digital Marketing. Agenda Unit 1 Why web site analysis works Why web site managers analyze their visitor traffic Creating goals and objectives for your web site Understanding the web site visitor experience How data analysis can improve web site outcomes Unit 2 How Google Analytics functions Setting up Google Analytics accounts Analyzing traffic sources and visitor traffic Redesigning pages to improve retention Testing web site versions with Google Optimizer Unit 3 Search Engine Optimization Understanding how page ranking and positions are determined Redesigning the title bar, alt tags, heading area, and links your URL Keyword density and rewriting web page copy Strategies to improve your page rank Unit 4 Moving to Web 2.0 Generation Y and the Web 2.0 Attitude Developing user-created content Creating interactive web sites The future of web sites 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.

Cash is arguably the most important factor in business success. It is the non-financial manager who really makes a difference in the day-to-day cash activities. Discover how to maximize cash flow, learn the importance of cash and find out your role in cash flow success. 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: Cash Flow Strategies Why cash is so important in business What are the cash-critical stages in business What internal sources of cash are possible What potential external sources of cash there are Unit 2: Reporting and Evaluating Cash Flow Review of the Cash Flow Statement Review of Projected Cash Flow Report What the Cash Cycle communicates What improvements can be made to shorten the cash cycle Calculating cash cycle Unit 3: Projecting Cash Needs How much cash the business needs When cash injections are needed Which cash needs will internal sources be able to cover Which cash needs must be met through external sources Making comparisons with other businesses in the same industry Unit 4: Funding Requests What debt sources of cash are possible What are the potential equity sources of cash What requirements different funding sources have Making a pitch to investors Approaching potential lenders for financing For more information, visit our question and answer page - Click Here.

Discover how to create a worksheet used to adjust account balances and prepare financial statements. Use your financial statements to measure performance, make improvements and set goals. Finally, learn how to close your books and prepare them for the next accounting period; this is done by journalizing and posting closing entries. This course can be taken alone or as part of the 3 course Bookkeeping Certificate. Class Details: Unit 1: Prepare a Worksheet What is a worksheet Columns included in the worksheet Completing each column Unit 2: The Income Statement Review the worksheet columns for the Income Statement Prepare the income statement Determine a profit or loss Unit 3: The Balance Sheet Review the worksheet columns for the Balance Sheet Prepare the balance sheet Unit 4: Closing Entries and Statement of Changes in Owner’s Equity Prepare post-closing entries for revenue and expense accounts Prepare a statement of changes in owner’s equity Applying year-end steps monthly or quarterly For more information, visit our question and answer page - Click Here.

Collaborative skills are essential to harness the energy of groups and teams for maximum performance and productivity. Knowledge of collaborative skills will enable you to gain participation quickly, get input and buy-in for building consensus and get projects completed. Explore the principles of collaborative management and gain insight on how to expand your collaborative skills for the success of your organization. This course can be taken alone or as part of the 3 course Management Certificate. Class Details Unit 1: Principles of collaboration in management Defining principles of collaboration Emotions, self-mastery and collaboration Redirecting teams and group collaboration Conflict management and facilitation Unit 2: Relationship building Building relationships fundamentals Renegotiating failed relationships Managing collaborative potentials Unit 3: Strategies to tap into group collaborative potential Harnessing collaborative energy Responsible communication Managing collaboration for performance Unit 4: Your action plan for collaborative management Setting your management goals Identify and utilize collaborative resources Creating a collaborative management action plan For more information, visit our question and answer page - Click Here.

Learn how to develop a web course, the principals behind the adoption of technology innovation, and the nature of the online learning environment. Get tips for planning your online course, identifying resources and design guidelines. Discuss the phases of design and development, motivating student-to-student interaction and how to manage it. Get the latest information on copyright issues, assessment and evaluation. This course can be taken alone or as part of the 3 course Certificate in Online Teaching. Agenda Unit 1: Overview of the Online Instructional Environment Internet basics Principles behind the adoption of technology innovation The nature of the online learning environment Unit 2: Envisioning Your Online Course Types of web courses Preparing for the move to the Web Analyzing your current course Planning your web course Identifying resources Design guidelines Unit 3: Developing a Web course Team vs. Individual approach to development Phases of design and development Models of web courses Unit 4: Online Interaction Online collaboration Creating an interactive environment Motivating student-student interaction Managing interaction Unit 5: Issues in the Web Environment Managing email Facilitating discussions Class size Copyright For more information, visit our question and answer page - Click Here.

For future and emerging leaders in Gen Y, discover the key concepts of being a leader and the best strategies for developing your leadership skills and influence. Learn the unspoken secrets leaders know and the strategies they employ/exhibit in for influencing others. This course can be taken alone or as part of the 3 course Certificate in Leadership Development. Class Details Unit 1: Making Leadership Happen What leaders do, and don’t do What Leaders Believe Attributes of leaders: what characteristics leaders have that others don’t Making it happen: becoming a leader Leadership procedures and processes, how leaders work Unit 2: Attending Meetings: Where the Action Is How to attend a meeting when you are not the leader The dynamics of meetings Recognizing the players in a meeting How to study. The unspoken cues of body language, silence, objections, Studying/Reading the leader in a meeting Unit 3: The Secrets of Leading Successful Meetings Creating your meeting agenda and objective The 5 Secrets of leading an outcome oriented meeting Getting something passed Understanding meeting procedures: Bob’s Process Model Unit 4: Change: How to Influence Others Creating the argument Delivering the case Gaining support, before, during, and after meetings Taking leadership 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.

Whether you are sending out a press release, communicating internally with a memo or promoting your own skills on LinkedIn, strong writing skills are the key to success. Come away with the tools and techniques you need to improve your copywriting skills and learn how to avoid the common writing mistakes that can hold you back. This course can be taken alone or as part of the 3 course Certificate in Business Writing. Class Details Unit 1: Copywriting Essentials How to tell the difference between bad copy and good copy The art of the perfect sentence Developing your message Crafting your document roadmap Adapting your style to the audience and message Unit 2: Getting to the Point Clarity and brevity: Less is more Active vs. Passive Voice Cutting the clutter Using concrete examples and avoiding unwarranted superlatives Unit 3: Self Editing Leaving yourself time for revisions Avoiding common grammar mistakes and punctuation pitfalls Subject, verb and object agreement Fact checking The benefits of having an in-house style guide Unit 4: Creating Attention-grabbing Press Releases Writing benefit-driven copy Setting the right tone Language to use and language to avoid Writing a great headline For more information, visit our question and answer page - Click Here.

Entrepreneurs must know how to effectively market their product or service. Learn a step by step approach to attract and keep customers, all within a realistic budget. Discover how to build a strong brand, analyze which tactics to use, and implement your marketing plan. Take away practical marketing tips and tools that you can use to improve your marketing efforts. This course can be taken alone or as part of the 3 course Entrepreneurship Certificate. Class Details: Unit 1: The Customer as the Driver Marketing Decisions Framework Positioning Your Product or Service Marketing Strategies and Goals Unit 2: Communicating Value to Customers Key Selling Messages Creating Emotional Connections Personal Selling Networking: Your 30-Second Introduction Unit 3: Creating a Strong Brand Managing the Marketing Mix Marketing on a Shoestring Budget Your Marketing Calendar Implementing Your Plan Unit 4: Building Customer Relationships Tools to Meet Your Strategic Goals Online Opportunities and Social Media Checklist Generating Buzz: Word-of-Mouth Marketing Measuring Effectiveness

Transform your customer service into something extraordinary. Extraordinary customer service comes from focusing on the few essential elements that yield big results. Discover how easy it is to tweak your customer service from the ordinary to the extraordinary. Create a customer service plan that focuses on the key elements to get you started on your pathway to success. This course can be taken alone or as part of the 2 course Certificate in Customer Service. Class Details: Unit 1: Understanding Your Customer Why customer service is important Knowing your customer Customers are constantly evaluating you Basic customer service skills you may not have thought of Unit 2: Setting Customer Expectations Analyzing customer contacts Developing internal customer targets How to easily exceed your customers' expectations Unit 3: Developing Effective Processes What is working for your customers Re-engineering your process Ways to give the best information Handling complaints Unit 4: Marking Customer Service Extraordinary Tweaking the customer's experience Telling the world how great you are Having fun For more information, visit our question and answer page - Click Here.

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.

Discover how girls learn. Take away 10 top tips for helping girls learn more, and the 5 tips to help girls succeed more. Then discover how boys learn. Take away 10 top tips for helping boys learn more, and the 5 tips to help boys succeed more. Get info about research not available anywhere else. This course can be taken alone or as part of the 3 course Certificate in Learning Styles. Class Details Unit 1: The Brain and Gender Differences The brain and learning The female brain The male brain Summary of neurological and hormonal differences Unit 2: Helping Girls Learn More How girls learn Classroom techniques and activities that help girls learn Helping girls with spatial skills and STEM The 10 strategies for helping girls learn more Unit 3: Helping Boys Learn More How boys learn Classroom techniques and activities that help boys learn Helping boys with language skills The 10 strategies for helping boys learn more Unit 4: Helping Both Girls and Boys Succeed More Helping girls succeed in the workplace Helping boys succeed with college Grading learning and knowledge Gender neutral grading 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