Minneapolis Public Schools

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. This course is a comprehensive exploration of InDesign tools and capabilities to create professional documents. Learn how to manage the InDesign environment, create, setup, design, enhance and finalize multi-page documents. Software Requirements: Adobe InDesign. More information on Adobe Creative Cloud software can be found at adobe.com This class can be taken on its own 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 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.

Explore Google's free apps: web-based word processing, spreadsheets and slideshow tools. Learn to convert standard Microsoft Office documents to Google documents and share with others who can view and edit. Requirements: You must have a Gmail account and know your Gmail username and password.

Bring your ideas to life and leave a lasting impression with Microsoft PowerPoint. Master the tools and techniques that turn humdrum slides into dynamic presentations that will captivate your audience. With hands-on practice and real-world examples, learn design principles and multimedia elements such as images, videos, and charts that elevate you to the next level. Acquire critical know-how to deliver your presentations with confidence and ease. Whether you're a beginner or a seasoned user, you'll find new ways to work smarter, not harder. Leave class with in-demand skills and the ability to create professional, visually appealing presentations that will engage your audience and help you stand out. Software requirement: Microsoft PowerPoint This class may be taken alone or as part of the Certificate in Mastering Computer Skills for the Workplace. 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: PowerPoint Overview Why businesses use PowerPoint for presentations Launch PowerPoint and create your first PowerPoint presentation Discover how to protect and save your slides. Set your document’s Properties and Attributes including Subject, Title, and Author Unit 2: PowerPoint Document Creation Explore the different parts of the PowerPoint slide navigation Understand slides and templates, and their makeup Learn how to populate, format, and present slides Create multiple slides and templates Learn how to insert comments and professionally edit Unit 3: Advanced Features and Functionality Create and manage slides Learn to organize slides into sections Create “live” connections between slides and Excel worksheets Create effective and informative slides with tables and charts Unit 4: PowerPoint Management and Sharing Create meaningful file names and understand filing systems to manage PowerPoint 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 print settings

Build on the skills you learned in Excel 1. Practice the PMT loan payment and lookup functions. Also learn how to set data validation rules to control errors, add subtotals to spreadsheets, import a database into Excel and “clean it up" and create and manipulate pivot tables and charts.

Build on your Excel 2 skills, and learn how to set up your data to take full advantage of pivot tables and charts and avoid problems. Learn how to format data, work with more than one field in the values area, pivot fields, add simple and complex calculated fields, create calculated items, build and format a custom dashboard and add slicers.