Minneapolis Public Schools

Accelerate your organization's success with AI. Learn how to leverage AI to cut costs, enhance data insights, automate tasks, and optimize efficiency. Master AI concepts, techniques, and strategic planning to drive innovation and position your business for the future. Courses in this certificate must be taken in the following order: Introduction to ChatGPT Intermediate AI AI Planning and Strategies Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ

Adobe Illustrator is the industry standard computer illustration software. Use Illustrator to draw shapes and design logos, flyers, posters, banners, business cards or any other vector graphics for print or web. In this course, you will learn Adobe Illustrator fundamentals to set up a print document and use various tools to draw, type and color all kinds of shapes and illustrations. Learn how to efficiently manage layers and artboards, and create print-ready PDF documents. Software Requirements: Access to Adobe Illustrator software required. More information on Adobe Creative Cloud software can be found at adobe.com This class may be taken individually or as part of the Graphic Design Software Essentials Certificate. Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Unit 1: Getting to Know the Interface and Drawing Tools Interface menus, tools and panels. Working with various drawing and transformation tools Drawing anything from simple to complex shapes and illustrations. Unit 2: Working with Color and Text Working with color panels in the software Creating, managing and applying color and color groups Learning how to type and format text using various text formatting and styling tools and panels. Unit 3: Working with Layers and Pen tool Layers and layer management. Working with the Pen tool. Modifying a drawing using Pen tool options. Unit 4: Working with Artboards Creating and managing multiple Artboards Learning how to layout and design corporate package Business cards, letterhead and envelopes Creating print-ready PDF files

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 as well. This course may be taken individually or as part of the Digital Marketing Certificate. Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: 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

Data Analysis is quickly becoming one of the most sought-after skills in the workplace. Companies have vast amounts of data, but it is rare to have someone with the ability to analyze that data to see trends and make predictions. Add a whole new skill set to your portfolio, and make a big difference in the success of your organization by acquiring data analysis skills. Begin with getting a basic understanding of how to analyze data in a business setting. Then learn how many of your business decisions involve comparing groups for differences. You will know the statistics behind these group differences and relationships. Finally you will find out how to perform inquiries that will be useful to your business or organization, and have the skill necessary to communicate these results through graphs and text that your fellow employees will understand. Whether your business is home based or a large company, this certificate will take you to the next level where important decision-making is concerned. Students need to have an understanding of Microsoft Excel to complete this certificate. This Certificate is comprised of the following courses. (Scroll down for class details): Introduction Intermediate Advanced Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Introduction to Data Analysis 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 Intermediate Data Analysis 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 variable 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 Advanced Data Analysis 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

A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world.Begin with learning how an Excel worksheet is constructed, populated with content, and edited for delivery. Discover how various menu items, commands, settings and processes affects the look of your Excel worksheets and workbooks. Then, increase your efficiency by learning how to organize, display and calculate your data into useful information. Identify different types of data and how data can be best visually represented or formatted, by using different data tool techniques. Finally, you’ll learn a variety of Excel’s most powerful features to analyze data quickly and easily. This Certificate will help you discover how to attractively visualize your data into meaningful information with confidence. Students must have Microsoft Excel installed to complete this certificate. Courses must be taken in order: Mastering Microsoft Excel Intermediate Excel Advanced Excel Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Mastering Microsoft Excel Unit 1: Excel From The Ground Up Why businesses use Excel for spreadsheet management Technical requirements to use Excel (and all Office modules) Launch Excel and create your first Excel worksheet Discover how to protect and save your document Set your document’s Properties and Attributes including Subject, Title and Author Unit 2: Excel Document Creation Explore the different parts of the Excel worksheet and document navigation Understand cells and their makeup Learn how to populate, format and merge cells Create multiple worksheet “workbooks” Learn how to insert comments and check spelling Unit 3: Advanced Features and Functionality Create and manage formulas and functions Filter and sort tables and data Create “live” connections between multiple worksheets Create effective and informative table and charts Unit 4: Excel Management and Sharing Create meaningful file names and understand filing systems to manage Excel documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including setting print areas Learn how to export Excel tables and charts to PowerPoint presentations and Word documents Use Outlook to send Excel worksheets and workbooks to other users Intermediate Excel 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 Advanced Excel 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

Save time, track money, and get important insights with Quickbooks Online. As a small business manager, owner, bookkeeper, or accounting professional, Quickbooks Online is the preferred choice. Benefit from the patches and regular automatic upgrades to the software. Gain a comprehensive understanding of QuickBooks Online and learn how to work with more advanced topics to maximize the benefits of the platform. Courses must be taken in order: Level 1 Level 2 Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Level 1: Unit 1: Introduction to QuickBooks Online Use the interface Edit the Chart of Accounts Make General Journal Entries Memorized Transactions Find and Adjust General Journal Entries Create Journal Reports Create Inventory Items Create Service Items Inventory Report Unit 2: Create and modify supplier records Enter Bills for purchases Enter Checks Find and modify Supplier Bills Midterm Project Unit 3: Create Memorized Transactions Purchase Orders Supplier Reports Payments Supplier Credit Unit 4: Create and modify Customer records Enter Sales Receipts Record Sales Estimates Enter Invoices in Accounts Receivable View, adjust and delete sales Receive Customer Payments Run Customer Reports Final Project Level 2: Unit 1: Company Setup, Banking and Credit Cards Setting up and Customizing Settings Entering Balances – B/L, Customer, Vendor and Inventory Bank Reconciliation Using Credit Card Unit 2: Budgets and Inventory Budgets Tags Adjusting bundles Midterm Project Unit 3: Multiple Currencies Setting up Foreign Currency Updating the Exchange Rate Setting up a Foreign Currency Bank Account Setting up a Foreign Vendor Setting up a Foreign Customer Purchases and Sales using foreign currency Unit 4: Statements, NSF Checks and Bad Debts Preparing Customer Statements NSF cheques Using Projects Final Project

Equip yourself with the foundational knowledge and advanced skills needed to safeguard networks, data, and systems from cyber attacks. Conquer the core principles of cybersecurity, develop strategies to protect networks, and gain hands-on experience in identifying and mitigating cyber threats. Come away with the essential tools and knowledge to succeed in the ever-evolving field of cybersecurity. Courses in this certificate must be taken in the following order: Introduction to Cybersecurity Network Security and Defense Strategies Advanced Cyber Threat Analysis and Mitigation Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ

The Adobe software tools are the leading software for graphic design. Adobe Illustrator is the industry standard computer illustration software. Use Illustrator to draw shapes and design logos, flyers, posters, banners, business cards or any other vector graphics for print or web. Adobe InDesign is the industry standard page-layout program that works with Adobe Illustrator and Photoshop seamlessly. InDesign allows you to create simple to complex multi-page documents such as brochures, flyers, books and magazines. Use Adobe 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. Access to the Adobe software tools required. Courses: Adobe Illustrator Essentials Adobe Photoshop Essentials Adobe InDesign Essentials Software Requirements: Adobe Illustrator, Adobe Photoshop and Adobe InDesign. More information on Adobe Creative Cloud software can be found at adobe.com Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Adobe Illustrator Essentials Unit 1: Getting to Know the Interface and Drawing Tools Interface menus, tools and panels. Working with various drawing and transformation tools Drawing anything from simple to complex shapes and illustrations. Unit 2: Working with Color and Text Working with color panels in the software Creating, managing and applying color and color groups Learning how to type and format text using various text formatting and styling tools and panels. Unit 3: Working with Layers and Pen tool Layers and layer management. Working with the Pen tool. Modifying a drawing using Pen tool options. Unit 4: Working with Artboards Creating and managing multiple Artboards Learning how to layout and design corporate package Business cards, letterhead and envelopes Creating print-ready PDF files Adobe Photoshop Essentials 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 Adobe InDesign Essentials 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.

Learn spreadsheet terminology; how to enter and edit data; modify and format a worksheet; use absolute references; copy and move data using functions and formulas; copying formulas and creating charts. Create, sort and filter a database as well.

Gain insights into your data using business intelligence software – Power Business Intelligence. Power BI is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free. Discover the process of creating interactive reports. Integrate financial, marketing, or any other source data in your accounting system, Excel, or on the Web. Streamline the data to what is needed using Power Query. Create charts, maps, and other visuals to see your data in real time. Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using relationships and DAX (Data Analysis Expressions). Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports and analyze your results. This certificate will enhance your skills in data analysis, giving you greater insight into your organization’s performance and allowing you to make more informed decisions. This Certificate must be taken in the following order: Introduction Intermediate Advanced Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Introduction to Power BI 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 Intermediate Power BI 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 Advanced Power BI 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

Structured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst. You’ll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables. You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You’ll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs. Requirements: Windows 8 or later. Macs are not compatible. Necessary rights (local administrative rights) to install programs on the computer. This Certificate must be taken in the following order: Introduction Intermediate Advanced Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Introduction to SQL 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 Intermediate SQL 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 Advanced SQL Unit 1: 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 2: Creating Advanced Joins Creating inner joins review Creating outer joins review Creating joins with aggregate functions Creating nested joins Unit 3: Creating Union Queries Creating UNION queries Creating UNION ALL queries Creating a WHERE clause and multiple UNION queries Unit 4: Transaction Processing, Stored Procedures, Triggers Implementing transaction processing Implementing stored procedures Implementing triggers