Cambridge-Isanti Community Education

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

Discover Adobe Illustrator illustration software. Explore Adobe InDesign, the industry standard page-layout program that works with Adobe Illustrator and Photoshop seamlessly. Master Adobe Photoshop to effectively work with images. Software Requirements: Access to Adobe software tools required. For all online Adobe classes, students are responsible for purchasing their own software for their course. Trial versions of Adobe software are sometimes available on the Adobe company website. If you're taking the entire “Graphic Design certificate” you'll need Adobe Illustrator, Adobe Photoshop and Adobe InDesign. Otherwise you may sign up for a single software. More information on Adobe Creative Cloud software can be found at adobe.com This is a series of three classes: Spring 2024 Dates Summer 2024 Dates Adobe Illustrator Essentials 04/01/24-04/26/24 06/03/24-06/28/24 Adobe Photoshop Essentials 05/06/24-05/31/24 07/01/24-07/26/24 Adobe InDesign Essentials 06/03/24-06/28/24 08/05/24-08/30/24 For more information, visit our question and answer page - Click Here.

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.

Discover ways to improve your email promotions, including when and what to email. Learn how to analyze your response rates, and measure against benchmarks for open and click through rates. Master email promotion and responses with tracking and testing. If you are at an advanced level, your instructor is an email 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 Why email marketing Targeting promotions in the Internet Age Return on Investment (ROI) for email promotions The importance of permission marketing, relevant content, and opt-out options Integrating email promotion with other kinds of marketing Unit 2 How email works How commercial email vendors function Analyzing Open, click through and conversion rates Cleaning and updating email lists How HTML and text emails differ Unit 3 Writing email copy Writing a good subject line Writing email body copy Writing response and action copy Design and formatting email promotions Unit 4 Testing and tracking emails Frequency and best times to email How to test different emails Following up on inquiries Creating a one year email marketing plan 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.

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.

Understand the basics of computer programing and various programing languages. New technologies allow people outside of the computer science field to be able to create their own web pages using code. Learn the basics of HTML, CSS, and Java Script, as well as the practical uses for each. This course can be taken alone or as part of the 3 course Coding Certificate. Class Details Unit 1: Introduction to Programming Types of programming languages Practical Uses of Programing Text Editors Unit 2: Basic HTML/CSS Introduction to HTML Introduction to CSS Making a Simple Web Page Unit 3: Drawing and Coloring using Code Elements of Java Script Basic Drawing Using Code Basic Coloring Using Code Unit 4: Basic Animation using Code Uses of Animation Animation Basics Making a Simple Animation 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: Understanding Data Identify sources of Data Discover methods of Collecting Data Examine Quantitative Data Examine Qualitative Data Unit 2: Processing Data Introduction to Statistics Determine the Appropriate Statistical Method for use in various scenarios Identify methods of Sorting and Filtering Data Categorize Data Unit 3: Analyzing Data Discuss Probability and the Normal Distribution Perform Trend Analysis Perform Breakeven Analysis Understand basic Statistical Modelling Unit 4: Interpreting and Presenting Results Design Professional-looking Tables Generate Effective Charts Create Pivot Tables and Pivot Charts Compile a Dashboard for Management For more information, visit our question and answer page - Click Here.

Find your pathway towards your fiction writing goals. Learn the basic building blocks of story: character, plot and setting. Find out the different forms of fiction writing and some of the genres you might like to explore. Class Detials: Unit 1: The building blocks of story Character Conflict Setting Plot and story structure Short story versus novel Who are we writing for? Unit 2: Character and Conflict Protagonists and antagonists Secondary characters Character archetypes Character desires, conflicts and stakes Dialogue Unit 3: Setting and Plot Contemporary versus fantastical and historical settings Setting as character Three act plot structure and the hero’s journey Time jumps and flashbacks Prologues and epilogues Unit 4: Putting it all together Strategies for outlining Character-driven versus plot-driven outlines Overcoming writer’s block Researching markets Creating a marketing plan For more information, visit our question and answer page - Click Here.

Games are increasingly recognized as a tool that can serve many business purposes beyond entertainment. Discover what goes into the design and development of both video and analog games, with a particular focus on the use of games outside of consumer entertainment. Take the first steps into understanding game design and how it can be applied in your field. This course can be taken alone or as part of the 2 course Certificate in Basic Game Design. Class Details: Unit 1: What Makes a Game? Practical Definition for Game The Anatomy of a Game Games and Play Different Types of Games Unit 2: Essentials of Design Getting Beyond a Game Idea Game Verbs and Game Mechanics Documentation Test Early, Test Often Unit 3: Game Design: Solo and in Teams Defining Development Needs Roles in Game Design Finding Design and Development Partners Unit 4: Serious Games & Gamification Games Beyond Entertainment Designing "Serious" Games Gamification Designing Gamification Systems For more information, visit our question and answer page - Click Here.

Power BI (business intelligence) is a complete data analysis and report creation tool that you install for free. Discover how to quickly extract, transform, and load data with just a few clicks. Create interactive visualizations (charts, maps, KPIs) to provide you with insights into your company’s data to make informed decisions. This course can be taken alone or as part of the 3 course Power BI Certificate. Class Details Unit 1: Overview Power BI Components Install Power BI Desktop (free software) Getting started Unit 2: Connect with Data Sources Types of data sources Import Excel and text files Connect to databases (Access) Import data from the Web Unit 3: Transform Data Introduction to Power Query Shape data Filter data Understand the Data Model Unit 4: Creating Reports Overview Create visuals Format reports Share your files For more information, visit our question and answer page - Click Here.

Project management provides visibility of project health to the business and the customer. Gain the skills, tools and templates to confidently develop and maintain a project. This course can be taken alone or as part of the 3 course Certificate in Project Management. Class Details Unit 1: Project Management Overview Project Manager’s Responsibilities & Commitment Certification Requirements & Costs Compensation Project Framework Preview Unit 2: Tools & Templates Project Process Checklist Project Charter Template Project Plan Template Communications Templates Unit 3: Creating a Project Creating a project plan and schedule in MS Project Creating charter and team/stakeholder matrices Creating Change Log Creating a Risk Plan Unit 4: Managing the Project - Prepare a Project Status Deck Creating status deck (format, content, operating rhythm, etc.) Collecting Detail Status Presenting Summary Status Simulating project close-out & celebrate For more information, visit our question and answer page - Click Here.

Six Sigma methods have been successfully deployed in many industries and organizations. This challenging Introduction to Six Sigma Green Belt course teaches critical skills required for Six Sigma practitioners. This first course in the certification program explains the basic terms and proven Six Sigma problem-solving methods, team building tools, and descriptive statistics that are the basis for the statistical tools that contribute to the success of improvement projects and to the overall success of your organization. Topics covered include Lean Principles, Failure Mode Effects Analysis, Team Tools, Project Charters, and Basic Statistical Tools. The instructor uses the “flipped” classroom technique and expects participants to go beyond the classroom and use the internet and other resources to learn the material. This course can be taken alone or as part of the 3 course Certificate in Six Sigma Green Belt. Class Details Unit 1 Six Sigma Goals Value of Six Sigma Origins of Six Sigma Organizational Drivers Goals and Projects Lean Principles Lean Concepts and Tools Non-Value-Added Activities Theory of Constraints Design for Six Sigma (DFSS) DFSS Road Maps Unit 2 FMEA Define - Teams & Customers Process Management for Projects Process Elements Owners and Stakeholders Identify Customers Collect Customer Data Analyze Customer Data Translate Customer Requirements Team Dynamics and Performance Team Stages and Dynamics Six Sigma and Other Team Roles Team Tools Communications Unit 3 Define - Projects, Tools & Results Project Management Basics Project Charter Project Scope Project Metrics Project Planning Tools Project Documentation Project Risk Analysis Project Closure Management and Planning Tools Business Results for Projects Process Performance Unit 4 Descriptive Statistics For more information, visit our question and answer page - Click Here.

t's time you went "social." Go over step-by-step basics for Facebook, Instagram, Snapchat, Twitter and YouTube. Review common questions and insights on social media to get up to speed on the latest buzz words and topics. Learn to share, search and connect as a savvy social media user! This course can be taken alone or as part of the 3 course Certificate in Social Media For Business. Class Details Unit 1: How Marketing has Changed and Where Social Networks Fit? How is marketing changing? Who is your customer & where are they online? What role does content play? What are the trends on the horizon? Unit 2: Where to Start? Strategy, Listening, & Accounts Start with a plan: Developing a social media marketing strategy. Where does listening & engagement fit into strategy? Learning to use some basic tools How are organizations using social media? Unit 3: What Do Social Networks Fit in Your Business? A general overview of social sites that may fit your marketing goals. Where are your customers and how are they using social media? How to set up social network profiles? Can you measure the return on your investment? Unit 4: Using Facebook to Promote Your Brand and Engage Your Customers The Basics of Facebook: Personal & Business Applications How to Set-up Your Facebook Page Using Content and Posts to Boost Engagement Case Studies on How Businesses Use Facebook For more information, visit our question and answer page - Click Here.

Get the info you need to plan and design effective web pages. Come away knowing how to implement web pages by writing HTML and CSS code. Discover ways to enhance web pages with the use of page layout techniques, text formatting, graphics, and images. This course can be taken alone or as part of the 3 course Certificate in Web Design. Class Details Unit 1: The Principles of Web Design Plan the Structure of a Website / File Management Target your audience Designing Effective Web Layout and Navigation Unit 2: Structure vs Presentation Introduction to HTML5 Basic Markup Introduction to CSS3 - Linking and Embedding Stylesheets Unit 3: Web Graphics and Content Understanding web graphics Acquiring images / Copyright law and graphics on the web Optimizing images Adding images to your web page Unit 4: Publishing Your Site Domain Name Registration / Hosting Services Finding the appropriate Hosting space Publishing Website Using FTP-Client For more information, visit our question and answer page - Click Here.

Discover the direct relationship between service skills and career achievement. Be an exceptional service provider. You can help your organization and your career by translating your good service intentions into a workable plan and gain knowledge of ways to consistently deliver great service. The payoff is enormous. This course can be taken alone or as part of the 2 course Certificate in Customer Service. Class Details: Unit 1: Understand Service Matters Longevity and Loyalty Cost of a Lost Customer Engage Your Customer Unit 2: Listen to Your Customer Active Listening Avoid Improper Listening The Power of Feedback Unit 3: Web Sites and Electronic Communication Web-Based Customer Service Disadvantages of Web-Based Customer Service Evaluate Your Web-Based Customer Service Unit 4: Customer Turnoffs Exceed customer expectations Recognize and categorize customer turnoffs Deal with customer expectations and turnoffs For more information, visit our question and answer page - Click Here.

This is the first in a series addressing the development of Generation Y (born 1980-1999) leadership. Find out what it takes to become an effective leader. Discover your style of leadership. Discuss task completion, building relationships with your subordinates, becoming socially perceptive to changes in the workplace, utilizing your emotions in a positive and effective manner, and addressing challenging goals. This course can be taken alone or as part of the 3 course Certificate in Leadership Development. Class Details Unit 1: Introduction to Leadership Principles What does it mean to be a good leader? The multiple approaches to leadership Models of leadership The critical need for Gen Y leadership Unit 2: Recognizing your leadership style Leadership Traits Self Assessment Leadership Style Self Assessment Leadership Skills Self Assessment Task and Relationship Assessment Unit 3: Leadership Special Concerns Handling Conflict in the Workplace Managing Out-group Employees Ethical Considerations Unit 4: Cases in Leadership Case Study 1 Case Study 2 Self-reflection: What type of leader am I? For more information, visit our question and answer page - Click Here.

Enhance your management skills through this course for supervisors, managers, and emerging leaders. Discover the keys for effectively managing your employees. Find out how to create clear expectations, engage and motivate employees, and increase your effectiveness through use of the DiSC personality profile. By the end of the course you will be managing like a pro - quickly and with confidence. This course can be taken alone or as part of the 3 course Management Certificate. Class Details Unit 1: Fundamentals of Management How to determine, set, and communicate job expectations Linking employee behaviors to performance Describing performance expectations Increasing employee commitment and pride and evaluate performance Unit 2: Employee Engagement Motivating and engaging employees to get the job done Tools and techniques to increase employee buy-in and commitment How to communicate with employees and get them involved and engaged in their own performance evaluations Unit 3: Increasing your Success Part 1 Enhancing your ability to manage effectively In-depth analysis of the behaviors of your style Unit 4: Increasing your Success Part 2 Behaviors that inhibit your ability to manage effectively Advanced analysis of the behaviors of your management style For more information, visit our question and answer page - Click Here.

Enhance your management skills through this program for supervisors, managers, and emerging leaders. Find out how to create clear expectations, engage and motivate employees. Increase your effectiveness. Explore the principles of collaborative management and gain insight on how to expand your collaborative skills for the success of your team. Finally, get the keys to manage different generations in your workplace. This is a series of 3 courses. Spring Dates Summer Dates Fee (Single Course Only) Management Boot Camp 4/1/24-04/26/24 06/03/24-06/28/24 $295 Collaborative Management (SLCERT06B1 and SLCERT06B2) 05/06/24-05/31/24 07/01/24-/07/26/24 $245 Managing Generations in the Workplace 06/3/24-606/28/24 08/05/24-08/30/24 $175 For more information, visit our question and answer page - Click Here.