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.

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.