Mobile One-Stop Center

MOC-1 Computer Classes

Introduction to Personal Computers - Learn about different types of personal computers, input and output devices, how to turn on a computer and identify desktop components, identify the different types of storage devices, apply monitor and desktop settings, practice using a mouse and keyboard and explore built-in applications such as calculator and WordPad (1 day 3 hours).

Data Management – Use Windows Explorer to browse and navigate the My Documents folders, desktop, and My Computer hierarchies, create folders and files on the hard drive, learn to save files and folders to alternate storage devices (flash drives, CDs, etc.), recognizing the difference between save and save as, cutting, copying, pasting, deleting, restoring, and searching for files, and file types and extensions (1 day 3 hours).

Internet Navigation - Learn the basic components of an internet browser, different search engines, conducting an internet search, with special attention to job searching and utilization of the Michigan Talent Bank and how it can assist you in your job search. During the second part of the class, we will focus on creating and using e-mail accounts, including composing an e-mail and sending an attachment. Participants should have at least completed the Introduction to Personal Computers class or have a high comfort level using a personal computer prior to attending this class. (1 day 3 hours)

Microsoft Excel 2010 – Basic - Learn the components of a spreadsheet and workbook, including entering and formatting text and values, formula entry, utilizing built-in mathematical functions to perform calculations in a worksheet, using conditional formatting, creating and modifying charts, and managing large workbooks. Familiarization with the new look of Office 2007, including tabbed browsing and formatting groups, is also covered. (2 days 4 hours)

Microsoft Excel 2010—Intermediate - Learn how to use multiple worksheets and workbooks including linking workbooks and managing workbooks. Complete advanced formatting including special number formats and using styles and themes. Also, learn to outline and consolidate data and create subtotals, naming cells and ranges of cells, analyzing lists, sorting and filtering data, and creating web pages from workbooks and saving in HTML format. (2 days 4 hours)

Microsoft Excel 2010—Advanced - Learn how to use logical functions, math and statistical functions, and financial functions, look up functions, and creating data tables in a worksheet, also how to display and print formulas. Use pivot tables and charts to summarize, analyze, explore, and present summary data. Exporting and importing files and querying external databases, running and recording macros, working with visual basic, conditional formatting with graphics and utilizing smart art graphics will also be covered. (2 days 4 hours)

Microsoft PowerPoint 2010 – Basic - Learn the components of a basic slide show presentation, including formatting text, adding and deleting slides, importing slides from existing presentations, creating visually appealing presentations utilizing word art, adding tables, charts, and pictures to presentations and proofreading and delivering a presentation in front of a live audience. Familiarization with the new look of Office 2007, including tabbed browsing and formatting groups, is also covered. (2 days 4 hours)

Microsoft Word 2010 – Basic - Learn to create and save documents, open a Word document, navigate by using the scrollbars, keyboard and the Go To command, switch document views, selecting certain text, inserting text, dates, symbols and special characters, change the appearance of text utilizing different formatting options, aligning paragraphs, adding borders, bullets and numbered lists, changing indentation, creating new tables and modifying existing tables, proofread a document and use the thesaurus, inserting graphics and clip art into a document. Familiarization with the new look of Office 2007, including tabbed browsing and formatting groups, is also covered. (2days 4 hours)

Microsoft Word 2010—Intermediate – Learn how to create and modify styles and work with sections and columns. Tables will also be covered, including table alignment, shading, sorting, and how to split a table. Prepare and print labels and envelopes, create a document from a template, and use and modify diagrams, text boxes, and word art. This class also covers previewing and saving documents as a webpage using HTML.

Microsoft Word 2010—Advanced – Learn how to perform mail merges, create and use forms, and create master documents that include a table of contents, a table of figures, footnotes, endnotes, an index, bookmarks, cross-references, and Web frames. This class will also cover how to create macros and work with XML documents.