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.

Identify the architecture and protocols that keep networks secure. Understand the role of routers, switches, and firewalls in network security. Tackle network security fundamentals, implementing firewalls and VPNS, intrusion detection and prevention systems (IDPS) and securing wireless networks. 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.

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.

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.

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.

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.

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

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.

Enter the fascinating and emerging field of integrated marketing. Explore how to move potential customers from one media to another, increasing their interest and purchasing. Take home an Integrated Marketing Model to help you choose what’s best for your business and industry. This course can be taken alone or as part of the 3 course Integrated Marketing Certificate. Agenda Unit 1 Moving Inquiries to Customers The purpose and uniqueness of Integrated Marketing. Some 25 marketing options. Choosing the best for you. An Integrated Marketing Model All paths (almost) lead to your website Unit 2 Developing Inquiry Campaigns Choosing your methods Generating inquiries Following up with inquiries Hidden Engagement with ‘Contact Us’ Unit 3 Your Best 5 Digital Marketing Methods The hot 5, and why they work Picking your best 5 digital marketing methods Trending Up Why multiple channels can reach different audiences Unit 4 Integrating Digital with Print Following digital with print Using print to engage your website What goes in print; what goes online The 3 most effective engagement techniques For more information, visit our question and answer page - Click Here.

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.

Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. Learn how to retrieve more meaningful data from tables stored in a database. Explore how to merge data from multiple columns, how to create calculated fields, and how to order and group your results. This course can be taken alone or as part of the 3 course SQL Certificate. Class Details: Unit 5: Creating Calculated Fields and using Aggregate Functions Structured Query Language Review Creating calculated fields Concatenating columns Using aggregate functions Unit 6: Using Clauses in Structured Query Language Using the ORDER BY clause Using the GROUP BY clause Using the GROUP BY clause and WHERE clause Using the HAVING clause Unit 7: Creating Table Joins Creating Inner joins Creating Outer joins Creating Self joins Unit 8: Creating Subqueries Creating subqueries Creating subqueries that contain calculated fields Creating subqueries that contain aggregate functions

Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. In this course, you will discover the power of the relational database, how to create and manage database tables, and how to use SQL SELECT statements to precisely pinpoint and retrieve data from a database. This course can be taken alone or as part of the 3 course SQL Certificate. Class Details: Unit 1: The Relational Database and Structured Query Language The relational database structure Structured Query Language Table creation and data insertion Defining datatypes and constraints Creating Indexes Unit 2: Table Management Table management Adding columns to a table Deleting columns from a table Deleting a table Unit 3: Selecting and Retrieving Data Creating a SELECT statement to retrieve data Using DISTINCT to display unique values in a column Using the AS keyword to create an alternate name for a column Merging columns Unit 4: Filtering Data Creating a WHERE clause Using comparison, character, and logical operators to match conditions Using the IN operator to match a condition Using the BETWEEN operator to match a condition For more information, visit our question and answer page - Click Here.

Discover what motivates each generation at work, what incentives they respond to, and what messages they value. Explore the current motivations of Boomers, Gen Xers and Gen Yers and what messages they value. Then identify practical, how-to tips and techniques for managing Boomers, Gen Xers, and Gen Yers in the workplace. This course can be taken alone or as part of the 3 course Management Certificate. Class Details Unit 1: What makes these generations different The transition from the Industrial Age to the Internet Age How society shapes us Who are the Boomers? Who are Xers? Who is Gen Y? Unit 2: Evolving standards of hard work and success Knowledge work and the value of time Time as key to profitability The focus on outcomes The problem with meetings A new type of leadership Unit 3: What motivates generations at work Monetary and non-monetary rewards Key role of the “boss” A balanced life Lateral career moves Second careers Supporting social causes Retirement reservations Unit 4: Work styles and technology Customizing work styles and processes Peak work time and place A new role for technology and work Working collaboratively Modern recruitment For more information, visit our question and answer page - Click Here.

Get the keys to making online advertising work for you and your organization. Learn about various online advertising options. Discover how you can target local audiences. Explore how you can determine the demographics and even numbers of people you want to reach. No experience necessary. Advanced participant? Your instructor is an online ad expert and can answer your toughest questions. This course can be taken alone or as part of the 3 course Certificate in Digital Marketing. Class Details Unit 1 The evolution of online advertising From mass marketing to targeted marketing The role of search in online advertising Return on investment for online advertising Competing effectively with online advertising Unit 2 Creating Google AdWord Campaigns Determining keywords Selecting your AdWord territory Understanding pricing strategies Creating an AdWord budget and evaluation Unit 3 Improving Online Advertising Results How SEO and online advertising complement each other Testing keywords and related keywords Using Traffic Estimator to improve keyword selection Successful strategies in using online advertising Unit 4 Facebook Ads Understanding Facebook uses and users Using demographics to target Facebook Ads Setting up Facebook Ads Trends and future of online advertising For more information, visit our question and answer page - Click Here.