Cambridge-Isanti Community Education

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.

Acquire expertise in R,F & M Analysis. Understand the 80/20 Principle. Better know the impact of price on sales. Take your knowledge of marketing to a new level. These concepts are what the best marketers use for designing marketing strategies that improve performance and return. This course can be taken alone or as part of the 3 course Integrated Marketing Certificate. Agenda Unit 1 Analyzing Customer Purchasing and Demographics R,F & M Analysis Calculating Customer Lifetime Value Key Demographics to collect, and why The 80/20, AIDA, and 3-30-3 Principles Unit 2 Pricing to Improve Profit Margins Market pricing, price points and listing prices Clustered versus diversified pricing Price increase, and decrease, impact on sales Raising prices: guidelines for when, and how Unit 3 Your Seven Primary Market Segments Boston Consulting Group’s Stars & Dogs Repeat customers versus new customers Determining your seven primary market segments Strategic marketing by market segment Unit 4 The Top 10 Advanced Marketing Concepts The 5 marketing experts you need to know, and why Researching marketing best practice The best marketing books The top ten advanced marketing concepts you must know 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 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.

Discover how to plan, develop and teach an online course. Take home a ten step model for developing your online course. Learn how to create online audio lectures with slide shows. See an animation, drop-and-drag exercise, and dynamic welcome pages. Engage in online discussion with other teachers. An instructor's book, "Advanced teaching online," is included. This course can be taken alone or as part of the 3 course Certificate in Online Teaching. Class Details Unit 1: How the Internet is Changing How We Learn The Top 10 reasons cognitive information is delivered better by the Internet Learning online Learning in-person; what you cannot do on the Internet How young people learn differently online The Brain and Learning online Unit 2: Building Your Online Course The Ten Step Model How knowledge is organized online Building online content Creating audio and video presentations Development time and cost Unit 3: Teaching Your Online Course Facilitating online discussions Creating a safe online learning environment Responding to student questions and needs How much time you should spend online Evaluating your online course Unit 4: Creating Assessment and Measuring Online Learning Designing online assessment Multiple assessments Assessment as a learning tool Grading in the 21st century Best Practices in Online Teaching 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.

Discover how to create a stunning charcuterie board that tastes as good as it looks! In this hands-on class, you’ll learn techniques for arranging meats, cheeses, fruits, and accompaniments into an eye-catching display perfect for entertaining. Bring your own board, we will provide the goodies. Perfect timing for your upcoming Superbowl gatherings. Class will be taking place at the Princeton High School.

Perimenopause typically starts around the age of 35 and lasts 10-15 years. Common symptoms include fatigue, migraines, weight gain, water retention, depression, sleep disturbances, joint aches, hot flashes, fibroids, and exaggerated PMS. Discuss hormone replacement options; acupressure for symptom relief; and more. Leave with multiple tools for restoring health and well-being. Questions about our class policies, weather cancelations or accessing online classes? Click here for our Class Info & Policies.

Such a cute painting. Come join us for a wonderful evening of painting. $29.00 includes instruction and all materials.

Learn how to sew a 10-strip set bargello, suitable for a table runner or a tote bag. Fabric, sewing machines & all other equipment is provided. Fee includes 64 page bargello book & all fabric!

Painting Barn Quilts is a lively class with guided instruction that takes students through the process of creating a professional-looking barn quilt. At the end of the class, students will have their own masterpiece and be the envy of the neighborhood. There is a $65/person supply fee that needs to be paid directly to the instructor on the night of the class.

We write everyday: emails, social media posts, work projects, and even non- fiction or creative writing. Improving is just a matter of knowing some simple tricks to make your writing more impactful and readable, and may help get you a promotion at work or avoid rejection from a publisher. In this hands-on session, there will be writing/editing examples and exercises so you can see in real time how to make sentences flow properly while still maintaining reader interest, and you will leave with a workbook full of writing tips and tricks, which is included in the class fee. The instructor LeeAnne Krusemark is a former journalist, current author and editor, and a nationwide Professor of Publishing at higher learning institutions, including Harvard Adult Education. Your Zoom login link will be sent the day before class. If you do not see it in your inbox, please check your spam folder first for an email from the instructor at LeeAnne@KrusemarkGrinnell.com and/or ceregister@c-ischools.org, and then call us for an update if you haven't received it. Questions about our class policies, weather cancelations or accessing online classes? Click here for our Class Info & Policies.

If your goal is to become a published freelance writer by selling a magazine article, short story , poem or even a novel to a traditional publisher, this comprehensive workshop will guide you to, then past the editor's desk. If you really want to succeed, this step-by-step workshop is a must! Questions about our class policies, weather cancelations or accessing online classes? Click here for our Class Info & Policies.

Online blogging is a great way to get the word out! Learn step-by-step how to start a FREE blog with WordPress and connect it to your domain/website. Discover how to earn an income with your blog. Your Zoom login link will be sent the day before class. If you do not see it in your inbox, please check your spam folder first for an email from the instructor at LeeAnne@KrusemarkGrinnell.com and/or ceregister@c-ischools.org, and then call us for an update if you haven't received it. Questions about our class policies, weather cancelations or accessing online classes? Click here for our Class Info & Policies.

ChatGPT (AI) is here to stay and is the future for writers and content creators. Don’t be left behind! No prior AI experience required. Do you want to learn how to incorporate the power of cutting-edge technology to gain ideas and inspiration, write web content, articles, and even novels or scripts? In this beginner-friendly course, you’ll learn how to: register for a FREE ChatGPT account, input effective writing prompts to avoid nonsense responses, build creative content, from stories to marketing, copy, determine its capabilities and limitations, understand ethical/legal considerations using ChatGPT. There’s no doubt ChatGPT and similar AI systems will force the job market to evolve. It’s crucial for everyone to adapt, learn new skills, and be open to working in collaboration with AI, so start building your expertise in the world of ChatGPT now! The instructor LeeAnne Krusemark is a former journalist, current author and editor, and a nationwide Professor of Publishing at higher learning institutions, including Harvard Adult Education. Informative handouts for future use are included in class fee. The webinar login information will be emailed the day before class. Your Zoom login link will be sent the day before class. If you do not see it in your inbox, please check your spam folder first for an email from the instructor at LeeAnne@KrusemarkGrinnell.com and/or ceregister@c-ischools.org, and then call us for an update if you haven't received it. Questions about our class policies, weather cancelations or accessing online classes? Click here for our Class Info & Policies.

Designed for beginners, you will be speaking and reading Spanish in no time. Practice the basic building blocks of the language and common idiomatic expressions. Gain enough vocabulary and grammar for simple conversations, and learn how to ask and answer questions. Class Details Unit 1: The Alphabet: Vowels and Consonants Ser and Estar How to Ask Questions Vocabulary Unit 2: Colors, Countries and Numbers Colors Countries and Nationalities Numbers Unit 3: More Vocabulary Telling Time The Calendar More Vocabulary Unit 4: Expressions Tener: To have Vocabulary and expressions with tener Estar: To Be Unit 5: Conjugation Conjugation of Regular Verbs AR Verbs ER Verbs IR Verbs Unit 6: Irregular Verbs Hay Irregular Verbs Present Tense Stem-Changing Verbs Unit 7: The Near Future The Near Future Vocabulary Unit 8: Present Progressive More Ar Verbs Vocabulary Present Progressive For more information, visit our question and answer page - Click Here.