HomeMy WebLinkAboutCalifornia State University San Marcos; 2021-04-19;City Attorney Approved Version 6/12/18 1
AGREEMENT FOR TRAINING SERVICES CALIFORNIA STATE UNIVERSITY SAN MARCOS THIS AGREEMENT is made and entered into as of the day of , 2021, by and between the CITY OF CARLSBAD, a municipal corporation, ("City"), and The Trustees of the California State University on behalf of California State University San Marcos ("Contractor"). RECITALS A. City requires the professional services of a contractor that is experienced in providing Microsoft Office training courses. B. Contractor has the necessary experience in providing professional services and advice related to providing Microsoft Office training courses. C. Contractor has submitted a proposal to City and has affirmed its willingness and ability to perform such work.
NOW, THEREFORE, in consideration of these recitals and the mutual covenants contained herein, City and Contractor agree as follows:
1. SCOPE OF WORK City retains Contractor to perform, and Contractor agrees to render, those services (the
"Services") that are defined in attached Exhibit "A", which is incorporated by this reference in accordance with this Agreement’s terms and conditions. 2. STANDARD OF PERFORMANCE While performing the Services, Contractor will exercise reasonable professional care and skill and will use reasonable diligence and best judgment while exercising its professional skill and expertise. 3. TERM The term of this Agreement will be effective for a period of one year from the date first above written. The City Manager may amend the Agreement to extend it for two (2) additional one (1) year periods or parts thereof. Extensions will be based upon a satisfactory review of Contractor's performance, City needs, and appropriation of funds by the City Council. The parties will prepare a written amendment indicating the effective date and length of the extended Agreement.
4. TIME IS OF THE ESSENCE Time is of the essence for each and every provision of this Agreement.
5. COMPENSATION The total fee payable for the Services to be performed during the initial Agreement term will be
fifty thousand dollars ($50,000). No other compensation for the Services will be allowed except for items covered by subsequent amendments to this Agreement. If the City elects to extend the Agreement, the amount shall not exceed fifty thousand dollars ($50,000) per Agreement year. 6. STATUS OF CONTRACTOR
Contractor will perform the Services in Contractor's own way as an independent contractor and in pursuit of Contractor's independent calling, and not as an employee of City. Contractor will be under control of City only as to the result to be accomplished, but will consult with City as
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
April 19
City Attorney Approved Version 6/12/18 2
necessary. The persons used by Contractor to provide services under this Agreement will not be considered employees of City for any purposes.
The payment made to Contractor pursuant to the Agreement will be the full and complete compensation to which Contractor is entitled. City will not make any federal or state tax withholdings on behalf of Contractor or its agents, employees or subcontractors. City will not be required to pay any workers' compensation insurance or unemployment contributions on behalf of Contractor or its employees or subcontractors. Contractor agrees to indemnify City within thirty (30) days for any tax, retirement contribution, social security, overtime payment, unemployment payment or workers' compensation payment which City may be required to make on behalf of Contractor or any agent, employee, or subcontractor of Contractor for work done under this Agreement. At the City’s election, City may deduct the indemnification amount from any balance owing to Contractor. 7. SUBCONTRACTING Contractor will not subcontract any portion of the Services without prior written approval of City.
If Contractor subcontracts any of the Services, Contractor will be fully responsible to City for the acts and omissions of Contractor's subcontractor and of the persons either directly or indirectly employed by the subcontractor, as Contractor is for the acts and omissions of persons directly
employed by Contractor. Nothing contained in this Agreement will create any contractual relationship between any subcontractor of Contractor and City. Contractor will be responsible for payment of subcontractors. Contractor will bind every subcontractor and every subcontractor of
a subcontractor by the terms of this Agreement applicable to Contractor's work unless specifically noted to the contrary in the subcontract and approved in writing by City. 8. OTHER CONTRACTORS The City reserves the right to employ other Contractors in connection with the Services. 9. INDEMNIFICATION Contractor agrees to indemnify and hold harmless the City and its officers, officials, employees and volunteers from and against all claims, damages, losses and expenses arising out of the performance of the work described herein caused by any negligence, recklessness, or willful misconduct of the Contractor, any subcontractor, anyone directly or indirectly employed by any of them or anyone for whose acts any of them may be liable. City agrees to indemnify and hold harmless the Contractor and its officers, officials, employees
and volunteers from and against all claims, damages, losses and expenses arising out of the performance of the work described herein caused by any negligence, recklessness, or willful misconduct of the City, any subcontractor, anyone directly or indirectly employed by any of them
or anyone for whose acts any of them may be liable. 10. INSURANCE
Both Parties will obtain and maintain for the duration of the Agreement and any and all amendments, insurance against claims for injuries to persons or damage to property which may arise out of or in connection with performance of this agreement. The City acknowledges and accepts that the Contractor is self-insured. 10.1 Coverage and Limits.
Both Parties will maintain the types of coverage and minimum limits indicated below. These minimum amounts of coverage will not constitute any limitations or cap on either Party’s indemnification obligations under this Agreement. The full limits available to the named insured shall also be available and applicable to the other Party as an additional insured.
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
City Attorney Approved Version 6/12/18 3
10.1.1 Commercial General Liability (CGL) Insurance. Insurance written on an “occurrence” basis, including personal & advertising injury, with limits no less than $2,000,000 per occurrence. If a general aggregate limit applies, either the general aggregate limit shall apply separately to this project/location or the general aggregate limit shall be twice the required occurrence limit. 10.1.2 Automobile Liability. (if the use of an automobile is involved for Contractor's work for City). $2,000,000 combined single-limit per accident for bodily injury and property damage. 10.1.3 Workers' Compensation and Employer's Liability. Workers' Compensation limits as required by the California Labor Code. 10.1.4 Professional Liability. Errors and omissions liability appropriate to each Party’s profession with limits of not less than $1,000,000 per claim. Coverage must be maintained for a period of five years following the date of completion of the work.
10.2 Additional Provisions. Both Parties will ensure that the policies of insurance required under this Agreement contain, or are endorsed to contain, the following provisions:
10.2.1 Each Party will be named as an additional insured on Commercial General Liability which shall provide primary coverage to the other Party.
10.2.2 Both Parties will obtain occurrence coverage, excluding Professional Liability, which will be written as claims-made coverage. 10.2.3 This insurance will be in force during the life of the Agreement and any extensions of it and will not be canceled without thirty (30) days prior written notice to other Party sent by certified mail pursuant to the Notice provisions of this Agreement. 10.3 Providing Certificates of Insurance and Endorsements. Prior to execution of this Agreement, Both Parties will furnish certificates of insurance and endorsements to the other Party. 12. ACCOUNTING RECORDS Contractor will maintain complete and accurate records with respect to costs incurred under this Agreement. All records will be clearly identifiable. Contractor will allow a representative of City
during normal business hours to examine, audit, and make transcripts or copies of records and any other documents created pursuant to this Agreement. Contractor will allow inspection of all work, data, documents, proceedings, and activities related to the Agreement for a period of three
(3) years from the date of final payment under this Agreement. 15. NOTICES
The name of the persons who are authorized to give written notice or to receive written notice on behalf of City and on behalf of Contractor under this Agreement. For City For Contractor
Name Maria Callander Name Maria Froehle
Title IT Director Title Contract Analyst
Department Information Technology Address 333 S Twin Oaks Valley Rd
San Marcos, CA
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
City Attorney Approved Version 6/12/18 4
Address 1635 Faraday Avenue Phone No. 760-750-4468
Carlsbad, CA 92008 Email mfroehle@csusm.edu
Phone No. 760-602-2454
Each party will notify the other immediately of any changes of address that would require any notice or delivery to be directed to another address. 17. GENERAL COMPLIANCE WITH LAWS Both Parties will keep fully informed of federal, state and local laws and ordinances and
regulations which in any manner affect those employed by either Party, or in any way affect the performance of the Services by Contractor. Both Parties will at all times observe and comply with these laws, ordinances, and regulations and will be responsible for the compliance of Contractor's services with all applicable laws, ordinances and regulations. Contractor will be aware of the requirements of the Immigration Reform and Control Act of 1986 and will comply with those requirements, including, but not limited to, verifying the eligibility for employment of all agents, employees, subcontractors and consultants whose services are required by this Agreement. 18. DISCRIMINATION AND HARASSMENT PROHIBITED
Both Parties will comply with all applicable local, state and federal laws and regulations prohibiting discrimination and harassment. 19. DISPUTE RESOLUTION If a dispute should arise regarding the performance of the Services the following procedure will be used to resolve any questions of fact or interpretation not otherwise settled by agreement
between the parties. Representatives of Contractor or City will reduce such questions, and their respective views, to writing. A copy of such documented dispute will be forwarded to both parties involved along with recommended methods of resolution, which would be of benefit to both
parties. The representative receiving the letter will reply to the letter along with a recommended method of resolution within ten (10) business days. If the resolution thus obtained is unsatisfactory to the aggrieved party, a letter outlining the disputes will be forwarded to the City Manager. The City Manager will consider the facts and solutions recommended by each party and may then opt to direct a solution to the problem. 20. TERMINATION In the event of the Contractor's failure to prosecute, deliver, or perform the Services, City may terminate this Agreement for nonperformance by notifying Contractor by certified mail of the termination. If City decides to abandon or indefinitely postpone the work or services contemplated by this Agreement, City may terminate this Agreement upon written notice to Contractor. Either party upon tendering thirty (30) days written notice to the other party may terminate this Agreement. Contractor will be paid for work performed to the termination date; however, the total
will not exceed the lump sum fee payable under this Agreement. . 21. COVENANTS AGAINST CONTINGENT FEES Contractor warrants that Contractor has not employed or retained any company or person, other than a bona fide employee working for Contractor, to solicit or secure this Agreement, and that
Contractor has not paid or agreed to pay any company or person, other than a bona fide
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
City Attorney Approved Version 6/12/18 5
employee, any fee, commission, percentage, brokerage fee, gift, or any other consideration contingent upon, or resulting from, the award or making of this Agreement. For breach or violation
of this warranty, City will have the right to annul this Agreement without liability, or, in its discretion, to deduct from the Agreement price or consideration, or otherwise recover, the full amount of the fee, commission, percentage, brokerage fees, gift, or contingent fee. 22. CLAIMS AND LAWSUITS
By signing this Agreement, Contractor agrees that any Agreement claim submitted to City must be asserted as part of the Agreement process as set forth in this Agreement and not in anticipation of litigation or in conjunction with litigation. Contractor acknowledges that if a false claim is submitted to City, it may be considered fraud and Contractor may be subject to criminal prosecution. Contractor acknowledges that California Government Code sections 12650 et seq., the False Claims Act applies to this Agreement and, provides for civil penalties where a person knowingly submits a false claim to a public entity. These provisions include false claims made with deliberate ignorance of the false information or in reckless disregard of the truth or falsity of information. If City seeks to recover penalties pursuant to the False Claims Act, it is entitled to
recover its litigation costs, including attorney's fees. Contractor acknowledges that the filing of a false claim may subject Contractor to an administrative debarment proceeding as the result of which Contractor may be prevented to act as a Contractor on any public work or improvement for
a period of up to five (5) years. Contractor acknowledges debarment by another jurisdiction is grounds for City to terminate this Agreement. 23. JURISDICTION AND VENUE Any action at law or in equity brought by either of the parties for the purpose of enforcing a right or rights provided for by this Agreement will be tried in a court of competent jurisdiction in the County of San Diego, State of California. 24. PAYMENT TERMS City agrees to pay all undisputed invoices, or undisputed parts of invoices, in full within 30 days. 25. FORCE MAJEURE Neither party shall be liable to the other Party for any delay for reason of its inability, due to causes beyond its reasonable control, to obtain the necessary materials, or facilities; or for the delay, interference or interruption of the services to be rendered pursuant to this Agreement due to the elements, equipment malfunction, acts of God, acts of civil or military authorities, fires, floods, epidemics, quarantine restrictions, wars, riots, strikes, labor difficulties, accidents to
machinery, delays in transportation, reasons of force, mayhem, or any other similar or dissimilar causes beyond the control of either party. In the event that CSUSM considers it necessary or prudent to cancel this
Agreement due to circumstances related to the COVID-19 outbreak, CSUSM may do so by providing seventy-two (72) hours prior written notice of cancellation to City of Carlsbad.
26. SUCCESSORS AND ASSIGNS
It is mutually understood and agreed that this Agreement will be binding upon City and Contractor and their respective successors. Neither this Agreement nor any part of it nor any monies due or to become due under it may be assigned by Contractor without the prior consent of City, which
shall not be unreasonably withheld. 27. ENTIRE AGREEMENT
This Agreement, together with any other written document referred to or contemplated by it, along with the purchase order for this Agreement and its provisions, embody the entire Agreement and
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
City Attorney Approved Version 6/12/18 6
understanding between the parties relating to the subject matter of it. In case of conflict, the terms of the Agreement supersede the purchase order. Neither this Agreement nor any of its provisions
may be amended, modified, waived or discharged except in a writing signed by both parties. 28. AUTHORITY The individuals executing this Agreement and the instruments referenced in it on behalf of Contractor each represent and warrant that they have the legal power, right and actual authority to bind Contractor to the terms and conditions of this Agreement. CONTRACTOR CITY OF CARLSBAD, a municipal corporation of the State of California
By: By:
(sign here) Assistant City Manager
(print name/title)
ATTEST:
By:
(sign here) BARBARA ENGLESON
City Clerk
(print name/title)
. APPROVED AS TO FORM: CELIA A. BREWER, City Attorney BY: _____________________________ Assistant City Attorney
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
Contract AnalystMaria Froehle
for
City Attorney Approved Version 6/12/18 7
EXHIBIT “A” SCOPE OF SERVICES
PROGRAM OVERVIEW
Contractor shall provide various Microsoft Office applications trainings (“Courses”) as requested by the City. These Courses will be selected from the Software Applications Course Catalog that is included as Exhibit B, which by this reference is incorporated herein and made part of this agreement. Or, if requested, additional Courses not included in the catalog may also be considered and added by mutual agreement .
INTENDED AUDIENCE These Courses will be offered to the employees of various departments for the City. Maximum of 20 students in each Course cohort.
PROGRAM DESCRIPTION Course topic areas that have been identified as potential offerings include:
Microsoft Excel topics (3 hours each) Microsoft Word topics (3 hours each) Microsoft Outlook topics (3 hours each)
Microsoft Powerpoint topics (3 hours each) Visio topics (6 hrs) Adobe Applications and toics (6 hours each) Full course descriptons of the various Courses can be found in Exhibit B. Class content for each Course will be developed and tailored to match the intended audience’s learning expectations. Contractor will assist in the assessment of the intended audience (skill
level experience, software versions, etc.) so that content is immediately applicable to job responsibilities.
LEAD INSTRUCTOR
Shannon Hoolihan has worked in the software training industry since 1992. She is a
professional instructor teaching a variety of software packages ranging from introduction through advanced levels of the Microsoft Office Suite including Microsoft Project and Microsoft Access. She also teaches courses in the Adobe Suite of software including Dream Weaver and
Photoshop. Shannon’s educational accomplishments include, a bachelor’s degree in Journalism from the University of Nevada, Reno and she is certified Microsoft Train-the-Trainer Trainer. Additional instructors will be identified as needed.
PROGRAM LOGISTICS Duration: 3 hour virtual courses will meet two times for 1.5 hours (3 hours total) 3 hour on-site courses will meet one time for 3 hours (3 hours total)
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
City Attorney Approved Version 6/12/18 8
6 hour virtual courses may meet four times for 1.5 hours (6 hours total) 6 hour on-site courses may meet two times for 3 hours (6 hour total)
Location*: Live virtual via Zoom and/or onsite as requested and allowable by the City of Carlsbad Dates: Dates to be mutually decided based upon need and request. Schedules to be developed on a quarterly basis with option to add additional Courses as needed. Times: Morning and afternoon sessions with times to be mutually decided based upon City schedule Room Setup*: N/A A/V*: N/A *Room location, set up, audio-visual equipment and participant refreshments are the responsibility of the client if not held onsite at CSUSM EL.
Contractor’s Online Access: Contractor will create individual topic/Course community containers utilizing the Contractor’s platform. Course materials, additional handouts and Zoom link will be available to participants for viewing and downloading for a period of six-months after
the start date of each class. Onsite Material Access. Hardcopy course materials will be delivered prior to the start date of
each course. FEES 1. Each 3 hour Course (virtual or onsite) is $3,500. The class cohort shall not exceed 20 students. 2. Each 6 hour Course (virtual or onsite) is $7,000. The class cohort shall not exceed 20 students. 3. Fees include preliminary meeting(s) with Contractor program director and program facilitator(s) to discuss particulars and objectives of the program, all electronic version materials (if applicable), parking (when at Contractor campus), program supplies, individual and summarized program evaluations, participant certificates of completion, all instructor fees and related expenses. Catering charges billed separately (if applicable). 4. Contractor to bill the City at the end of each month to include all monthly Course
offerings
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors.
SOFTWARE APPLICATIONS COURSE CATALOG
Exhibit "B"
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 2
CONTENTS
Microsoft Applications .................................................................................................................... 5
Windows Courses ............................................................................................................................ 5
Windows 10 What’s new ............................................................................................................ 5
Windows 10 The Fundamentals And Working With Apps .......................................................... 8
Windows 10 Folders, Files and Personalizing Windows ........................................................... 10
Windows 10 Maintaining Your Computer................................................................................. 12
Excel Courses ................................................................................................................................ 14
Excel Fundamentals 101 and Intro to Formulas ....................................................................... 14
Excel 102 Moving Beyond the Basics Editing and Basic Formatting ......................................... 16
Excel Charting and Graphics ...................................................................................................... 19
Excel Formulas, Formulas, Formulas Part 1 .............................................................................. 20
Excel Formulas, Formulas, Formulas Part 2 .............................................................................. 22
Excel Macros and Templates ..................................................................................................... 24
Excel Lists and Pivot Tables ....................................................................................................... 25
Outlook Courses ............................................................................................................................ 26
Outlook 101 Fundamentals ....................................................................................................... 26
Outlook 102 Moving Beyond the Basics ................................................................................... 28
Outlook People, Calendar, Tasks and Notes ............................................................................. 30
Advanced Mail and Calendar .................................................................................................... 32
Outlook Controlling an Out-Of-Control Inbox ........................................................................... 35
Word Courses ................................................................................................................................ 37
Word Fundamentals .................................................................................................................. 37
Word Working With and Editing Text ....................................................................................... 39
Word Formatting Text and Paragraphs ..................................................................................... 41
Word Formatting the Page ........................................................................................................ 42
Word Tables .............................................................................................................................. 44
Word Graphics ........................................................................................................................... 45
Word Styles, Themes, and Templates ....................................................................................... 47
Word Long Documents.............................................................................................................. 48
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 3
Word Working With Complicated Documents ......................................................................... 49
Word Templates and Macros .................................................................................................... 49
Word Mail Merge and Newsletters ........................................................................................... 49
PowerPoint Courses ...................................................................................................................... 51
PowerPoint The Basics .............................................................................................................. 51
PowerPoint Advanced Features ................................................................................................ 51
Access Courses .............................................................................................................................. 52
Access Level 1 ............................................................................................................................ 52
Access Level 2 ............................................................................................................................ 53
Project Courses ............................................................................................................................. 54
Project Level 1 ........................................................................................................................... 54
Project Level 2 ........................................................................................................................... 54
Visio Courses ................................................................................................................................. 55
Visio Professional Level 1 .......................................................................................................... 55
Google Apps .................................................................................................................................. 56
Google Drive Courses .................................................................................................................... 56
Google Drive Part 1 ................................................................................................................... 56
Google Drive Part 2 ................................................................................................................... 57
Google Slide Courses ..................................................................................................................... 59
Google Slides Fundamentals, Editing & Organizing a Presentation.......................................... 59
Google Slides-Formatting, Themes, Graphics and Animations ................................................. 61
Google Slides-Inserting Objects, Delivering a Presentation and collaborating ........................ 63
Google Sheets Courses ................................................................................................................. 65
Google Sheets Fundamentals and Editing ................................................................................ 65
Google Sheets Formatting ......................................................................................................... 68
Google Sheets Formulas and Functions .................................................................................... 69
Google Sheets Managing Sheets and data ................................................................................ 71
Google Sheets Inserting objects ................................................................................................ 72
Google Sheets Share, Collaborate, and Convert ....................................................................... 73
Google Docs Courses .................................................................................................................... 74
Google Docs Fundamentals and editing ................................................................................... 74
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 4
Google Docs formatting text and paragraphs ........................................................................... 76
Google Docs formatting the page and inserting objects .......................................................... 77
Google Docs Inserting tables, Sharing, and Collaborating ........................................................ 79
GMAIL Courses .............................................................................................................................. 81
GMAIL Reading, Composing and sending email ....................................................................... 81
GMAIL Organizing your inbox ................................................................................................... 83
GMAIL Customize Email settings ............................................................................................... 85
Adobe Applications ....................................................................................................................... 86
Acrobat Courses ............................................................................................................................ 86
Adobe Acrobat Level 1 .............................................................................................................. 86
Adobe Acrobat Level 2 .............................................................................................................. 86
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 5
MICROSOFT APPLICATIONS WINDOWS COURSES WINDOWS 10 WHAT’S NEW LENGTH 90 MINUTES COURSE DESCRIPTION
In this course, we’ll focus on the new and redesigned features in Windows 10. You’ll
learn about the Start Menu, the Action Center, Cortana, the Edge web browser, and
the Settings app. You’ll also learn about using multiple desktops, tablet mode, and
other new features WHAT’S NEW
• What's New in Windows
• The Start Menu
o Open the Start Menu
o View Account Commands
o Open Apps
o Pin Apps to the Start Menu
o Remove a Pinned App
o Resize an App Tile
o Resize the Start Menu
o Name a Tile Group
o Move an App Tile
o Turn Off a Live Tile
o Add Favorite Folders to the Start Menu
• The Action Center
o Open and Close the Action Center
o Open and View a Notification
o Dismiss a Notification
o Open a Quick Action
o Customize Quick Actions
o Rearrange Quick Actions
o Set Priorities for Notifications
o Configure the Amount of Visible Notifications
• Cortana
o Set Up Cortana
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 6
o Lock Screen Availability
o Search with Cortana
o Send Texts Using Cortana
o Speak to Cortana
o Customize Cortana
o Limit Information Collected by Cortana
o Clear Cortana's Memory
o Hide Cortana
o Restore Cortana
• Microsoft Edge
o Open Edge and Search in Edge
o Ask Cortana About a Web Image
o Add a Favorite Webpage
o View Favorite Webpages
o Change Your Startup Page
o Pin a Webpage to the Start Menu
o Use Reading Mode
o Add a Webpage to the Reading List
o View the Reading List
o Remove a Favorite or Article
o Create a Web Note
o Share a Web Note
o Add Browser Extensions
• Use Multiple Desktops
o View Windows and Desktops
o Add a Desktop
o Move Windows Between Desktops
o Remove a Desktop
o Tablet Mode
o Enable Tablet Mode
o Use the Start Menu
o Switch Between Apps
o Close an App
o Hide the Taskbar
o Turn Tablet Mode Off
• The Settings App
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 7
o Access the Settings App
o Change an App Theme Color
o Set Up Active Hours
o Project to Your Device
• Quick Access
o Pin a Folder
o Remove a Pinned Folder
• Quick Assist
o Quick Assist
• Windows Ink
o Windows Ink
• Windows Hello
o Use Windows Hello
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 8
WINDOWS 10 THE FUNDAMENTALS AND WORKING WITH APPS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
If you’re new to Windows, this course will cover a few of the basics. You’ll learn how to start
and sign in to Windows, how to open and close apps, and how to use apps by getting familiar
with common app window elements. You’ll also learn how to connect to a network, how to
install apps from the Microsoft Store, and how to shut down Windows when you’re finished
using your computer
While each app in Windows is different, they generally function the same. This course also
covers the basics of using various apps, starting with an overview of some basic command
controls you’ll use. You’ll learn how to move and resize app windows, and switch between app
windows as well. Finally, you’ll learn how to update apps and uninstall apps you no longer need THE FUNDAMENTALS
• Starting Windows
o Start Windows
• Open and Close Apps
o Open and Close an App
• Program Windows
o Control Buttons
o Minimize a Window
o Maximize a Window
o Close a Window
o Use the Ribbon
• Connect to a Network
o Connect to a Network
• Install Apps from the Microsoft Store
o Install an App
• Shut Down Your Computer
o Shut Down Your Computer WORK WITH APPS
• Command Controls
o Option Buttons
o Check Boxes
o List Boxes
o Sliders
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 9
o Drop-down Menus
• Resize and Move Windows
o Move a Window
o Resize a Window
o Snap a Window
• Switch Between Windows
o Switch Between Windows
o Switch Between Multiple App Windows
o View All Open Windows
• Update Apps
o Update an App
• Uninstall Apps
o Uninstall an App
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 10
WINDOWS 10 FOLDERS, FILES AND PERSONALIZING WINDOWS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
If you have a lot of files on your computer, they can get tough to find if you don’t keep them
organized! That’s why it’s important to know how to manage folders and files in Windows.
In this course, you’ll learn how to use the File Explorer to view files and folders. You’ll also learn
how to search for files, how to customize the icons and shortcuts on your desktop, and how to
send files to (and retrieve them from) the Recycle Bin FOLDERS AND FILES
• File Explorer
o Open File Explorer
o The Address Bar
o Back, Forward, and Up Buttons
o Navigation Pane
o The Ribbon
• Organize Folders and Files
o Move or Copy Folders and Files
o Use Click and Drag to Move Folders and Files
o Rename Folders and Files
• Libraries
o Add Libraries to the Navigation Pane
o Add a Folder to a Library
o Create a Library
• Find Files
o Search for Files
o Change Search Locations
o Refine Search
o Opening a File Location
• OneDrive Files
o Access Personal OneDrive Files
o Edit OneDrive Settings
• File Explorer Views
o File Explorer Views
• Compressed Files or Folders
o Compress Files or Folders
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 11
o View Compressed Files
o Extract a Compressed Folder
• Desktop Icons and Shortcuts
o Create a Shortcut
o Sort Your Desktop
• Recycle Bin
o Delete a File or Folder
o Restore a File or Folder
o Empty the Recycle Bin PERSONALIZE WINDOWS
• Backgrounds and Colors
o Personalization Settings
o Change the Desktop Background
o Change the Accent Colors
• Customize the Taskbar
o Pin a Running App to the Taskbar
o Pin an App from the Start Menu to the Taskbar
o Unpin an App from the Taskbar
o Customize System Icons
• Move and Resize the Taskbar
o Move the Taskbar
o Resize the Taskbar
o Lock the Taskbar
o Hide the Taskbar
• Personalize the Lock Screen
o Customize the Lock Screen
o View the Lock Screen
• User Accounts
o Customize Account Settings
o Add a PIN
o Add or Manage Other Accounts
o Synchronize Settings Between Devices
o Switch User Accounts
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 12
WINDOWS 10 MAINTAINING YOUR COMPUTER LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
In order to stay at peak performance, your computer will need regular maintenance. These
tasks will vary from simple monitoring and updating to more advanced tasks, such as data
backup and system restore.
In this module, you’ll learn how to update Windows, how to view and manage tasks in the Task
Manager, and some tips to keep your computer’s battery life up. You’ll also learn how to back
up your data, restore Windows from a restore point, how to scan for viruses, and how to
manage your privacy settings. MAINTAIN YOUR COMPUTER
o Maintain Your Computer
o Controlling Your Battery
o Add a Wireless Display or Audio Device
o Add Another Type of Device
o Remove a Device
o Customize Your Computer Display
• Windows Updates
o Check for Updates
o Change Windows Update Settings
• Task Manager
o Open Task Manager
o End a Task
o View Computer Performance
o Disable Start-up Programs
• Improve Battery Life
o Adjust Battery Saver
o Adjust Screen Brightness
o Adjust Power and Sleep Settings
• Back Up Data
o Add a Backup Drive
o Customize a Backup
o Restore Your Files
• System Restore
o System Recovery Options
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 13
o Turn on System Protection
o Create a Restore Point
o Restore from a Restore Point
• Make Windows Secure
o Open Windows Defender Security Center
o Security Categories
o Run a Virus Scan
o Remove a Virus
• Privacy Settings
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 14
EXCEL COURSES EXCEL FUNDAMENTALS 101 AND INTRO TO FORMULAS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Microsoft Excel is a powerful spreadsheet application that provides quick and accurate
numerical calculations and helps make data look sharp and professional. The uses for Excel are
limitless: businesses use Excel for creating financial reports; scientists use Excel for statistical
analysis; and families use Excel to help manage their investment portfolios.
This course will help you get started with Excel. Learn how to create a new workbook, navigate
a worksheet and save your work so nothing is lost. EXCEL FUNDAMENTALS
• Excel Overview
o What Is Excel?
o Tour of the Excel Screen
• The Excel Ribbon
o Expanding and Collapsing the Ribbon
o Ribbon Display Options
o Accessing the Ribbon using the Keyboard
• Sheet vs. Workbook
• Excel File Formats
• New Workbooks
• Searching for an Online Template
o Using the Suggested Searches Option
o Pinning Templates or Recently Used Files
o Unpinning Templates or Recently Used Files
• Open Workbooks
• Understanding the Excel Mouse Shapes
• Entering Data into an Excel Worksheet
o Entering Data
• Print
o Preview and Print a Worksheet
o Specify Printing Options
o Customizable Print Options
• Help
o The Tell Me Field
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 15
o The Help Pane
• Close and Exit
• Close a Workbook
• Save Workbooks
o Saving a Workbook
o From the Quick Access Toolbar
o From the File Tab
o Saving a Workbook under a Different Name
o From the File Tab
• Close Workbooks
o From the File Tab
o From the Ribbon INTRODUCTION TO FORMULAS
• Formula Rules
• Formula Creation Methods
o Typing Method
o Pointing Method
• Using Sum
o Sum Function
o AutoSum
o Using AutoSum on the Ribbon
o AutoSum Tool
• Average Function
• Current Date & Time Functions
o Current Date
o Current Date and Time
o Changing a Date’s Format
• The Fill Handle
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 16
EXCEL 102 MOVING BEYOND THE BASICS EDITING AND BASIC FORMATTING LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
This course is a continuation of the Excel Fundamentals 101 class and is designed for
those who are currently using Microsoft Excel and want to expand their knowledge
and want to become more proficient with the software EDIT A WORKBOOK
• Select Cells and Ranges
o Select a Cell
o Select Rows
o Select Column
o Select a Cell Range
o Select the Entire Worksheet
o Select Non-Adjacent Cells
• Edit Cell Data
o Enter Cell Data
o Replace Cell Data
o Delete Cell Data
o Edit Cell Data
• Cut, Copy, and Paste
o Copy and Paste
o Cut and Paste
o Move Using Drag and Drop
• Undo, Redo, and Repeat
o Undo
o Undo Multiple Actions
o Redo
o Repeat
• More Pasting Options
o Transpose Data
o Paste Values
o Paste Formats
o Advanced Paste Special Commands
o Paste Special Options
• Insert and Move Cells
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 17
o Insert Cells
o Insert Rows or Columns
o Move Cells
o Delete Cells
o Delete Cells
o Delete Rows and Columns
• Check Spelling
o Find and Replace Text
o Find Text
o Replace Text
o Advanced Find and Replace
o Advanced Find and Replace Options
• Hide Columns and Rows
o Hide Rows or Columns
o Unhide Rows or Columns
• Document Properties
o View Document Properties
o Edit Document Properties
o Add an Author
o Advanced Properties BASIC FORMATTING
o Format Text
o Change Fonts
o Apply Bold, Italic, or an Underline
o Change Font Size
o Change Font Color
o Format a Part of a Cell
• Align and Merge Cells
o Change Cell Alignment
o Indent a Cell’s Content
o Wrap Text in a Cell
o Merge Cells
o Split Merged Cells
• Format Numbers and Dates
o Format a Number or Date
o Advanced Number Formats
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 18
o Create a Custom Number Format
• Borders and Background Colors
o Add a Cell Border
o Advanced Border Options
o Add a Cell Shading
• Copy Formatting
o Copy Cell Formatting
• Row Heights and Column Widths
o Adjust Column Width
o Adjust Row Height
o AutoFit Columns or Rows
o Set a Row or Column Value
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 19
EXCEL CHARTING AND GRAPHICS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION LENGTH 3 HOURS
In this class you will learn to streamline repetitive tasks and display spreadsheet data in more
visually effective ways In this course, you will use Microsoft Office Excel to apply visual
elements and formulas to a worksheet and display data in various formats to streamline and
enhance your spreadsheets with charts, graphics, and formulas The target students for this
course are students who desire to gain the skills necessary to create data and present it in a
chart In addition, this course teaches how to use other visual elements such as Clipart and
SmartArt.
• Introduction to Charts
• Excel Charts Overview
• Creating a Chart
• Selecting a Chart
• Printing a Chart
• Linking data to the Char
• Switch Row/Column
• Alternate Methods for Data
• Formatting Charts
• Working with Graphic Objects
• Understanding Graphic Types
• Inserting Pictures into the Spreadsheet
• Inserting Online Pictures
• Sizing and Moving Objects
• Inserting Shapes
• Inserting Text Boxes
• Insert WordArt
• Selecting and Deselecting Objects
• Selecting a Text Box
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 20
EXCEL FORMULAS, FORMULAS, FORMULAS PART 1 LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
We will dedicate the entire course to working with Microsoft Excel formulas. You should be
familiar with the basics of MS Excel before attending this course. Some formulas covered are
SUM, AVERAGE, MIN, MAX, COUNT, COUNTIF, COUNTSUM, VLOOKUP, HLOOKUP, IF, SUMIF,
PMT, FV and more.
• Introduction to Formulas
o Formula Rules
o Typing Method
o Pointing Method
o Working with the Basic Functions
• Sum Function
o AutoSum
o AutoSum Tool
• Copying Formulas with the Fill Handle
• Average Function
• Absolute and Relative Cell References
o Absolute vs Relative Cell References
o Switch between relative, absolute, and mixed references
• Current Date & Time Functions
o Current Date
o Current Date and Time
• Other Useful Functions
o Minimum Function
o Maximum Function
o Count Function
o CountA Function
o CountBlank Function
o SumIf Function
o AverageIf Function
o CountIf Function
o PMT Function
• Excel Information and Logical Functions
o IF Function
o OR Function
o AND Function
• Creating Formulas Between Sheets
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 21
o Grouping Sheets
o Group selected worksheets
o Ungroup selected worksheets
o Group all worksheets
o Ungroup all Worksheet
o Creating Links Between Worksheets and Workbooks
o Create a Formula to Calculate Between Multiple Worksheet
• Linking Worksheets
• Linking Workbooks
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 22
EXCEL FORMULAS, FORMULAS, FORMULAS PART 2 LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
This is a continuation of the Formulas Part 1 class This class will cover named ranges, math
functions such as Round and Round Up, Vlookup and HLookup, Text Functions, and finally Date
and Time functions.
• Working with Named Ranges
o Named Ranges
o Named Range Scopes
o Creating a Workbook Scope Named Range
o Name Manager
o Apply Names
• Math Functions
o Round Function
o Int Function
o RoundUp Function
o RoundDown Function
o Ceiling Function
o Floor Function
• Lookup Functions
o VLOOKUP Function
o HLOOKUP Function
• Text Functions
o LEN Function
o UPPER Function
o LOWER Function
o Proper Function
o LEFT Function
o RIGHT Function
o MID Function
o TEXT Function
o REPLACE Function
o CONCATENATE Function
• Time Functions
o TODAY Function (Review)
o NOW Function (Review)
o Time Function
o TimeValue Function
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 23
o Hour Function
o Minute Function
o Working with Time in Formulas
o Mod Function with Time
o Using the [h]:mm Custom Format With Time Calculations
o Time Workbook Templates
• ISERROR Function
• ISERR Function
• IFERROR Function
• ISBLANK Function
• ISNUMBER Function
• ISTEXT Function
• More Date Functions
o DATE Function
o DATEVALUE Function
o MONTH Function
o DAY Function
o YEAR Function
o NETWORKDAYS Function
o NETWORKDAYS.INTL Function
o WORKDAY Function
o WORKDAY.INTL Function
o WEEKDAY Function
o WEEKNUM Function
o EDATE Function
o EOMONTH Function
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 24
EXCEL MACROS AND TEMPLATES LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
What is a macro? Do you find yourself repeating the same commands over and over again in
Excel? Macros are like mini programs that enable you to automate tasks We will dedicate the
entire course to working with Microsoft Excel macros You should be familiar with the basics of
MS Excel before attending this course
In addition to Macros, templates will also be covered. To save time or to promote
standardization, you can save a workbook as a template A template is a workbook that you
create and use as the basis for other similar workbooks You can create templates for
workbooks and worksheets that you can use to create other workbooks
• Excel Macros
o About Excel Macros
o Storing Excel Macros
o Recording Macros
o Running a Macro
o Deleting a Macro
o Showing the Personal Workbook
o Opening the Personal Workbook
o Trust Center
o Setting Up a Trusted Location
o Organizing Macros
• Creating a Custom Ribbon
• Quick Access Toolbar
• Adding Keyboard Shortcuts to Macros
• Adding Buttons on a Worksheet
• Protecting Worksheets, Workbooks, and Data Validation
o About Protecting Worksheets
o Unlocking & Locking Cells
o Protecting the Worksheet
o Protecting the Workbook
o Data Validation
• Creating Excel Templates
• Saving an Excel Workbook as a Template
• Creating a New Workbook from a Template
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 25
EXCEL LISTS AND PIVOT TABLES LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
This course is designed for individuals who need to analyze Microsoft Excel data Do you work
with long lists of data? Do you need to sort, filter and extract this data? We will cover
everything you will want to know about Excel lists including sorting, subtotaling and pivot
tables.
• Sorting Data
o Simple Sort
o Multi-Level Sort
o Sorting Options
• Filtering Data
• Excel Tables
o About Tables
o Creating a Table
o Filtering and Sorting Table Data
o Working with the Table Tools
o Writing Formulas Using Structured Reference Syntax
o External Table Data Group
• Subtotals
o Data Subtotals
o Expanding and Collapsing the Subtotals
o Adding an Additional Calculation to the Subtotals
o Removing Subtotals
o Subtotal Function
• Introduction to PivotTables
o What Are PivotTables
o Create and Modify a PivotTable
o Changing the PivotTable Fields Display
o Advanced PivotTables and PivotCharts
o PivotTable Report Filters
o Showing Report Filter Page
o Creating a PivotChart
o Inserting a Slicer
o Inserting a Timeline
o Grouping PivotTable Data
o Creating a Calculated Field
o Change the PivotTable name
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 26
o Generate GetPivot OUTLOOK COURSES OUTLOOK 101 FUNDAMENTALS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Microsoft Outlook lets you send and receive email messages, schedule appointments, keep
track of tasks, and organize your contacts and addresses.
This course introduces the Outlook fundamentals. You will learn how to find your way around
the Outlook screen and item windows. You will learn the basics of working with Outlook mail. OUTLOOK FUNDAMENTALS
• Understand the Screen
• Navigate Outlook
o Use the Navigation Bar
o Customize the Navigation Bar
o Use the Folder Pane
• Items
• Search
o Search Items
o Refine Search Results
• Delete and Restore Items
o Delete an Item
o Restore an Item
• Use the View Tab
o Change Views
o Folder Pane
o Reading Pane
o To-Do Bar
o People Pane
• The Quick Access Toolbar
o Use the Quick Access Toolbar
o Add a Button to the Quick Access Toolbar
o Customize the Quick Access Toolbar
o Remove a Button from the Quick Access Toolbar
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 27
• Print
o Print Outlook Items
• Help
o The Tell Me Field
o The Help Pane USING MAIL
• Understand the Message Window
• Compose Email
o Compose and Send a Message
• Read Email
o The Reading Pane
o Open in an Email Window
o Download Pictures in Emails
o Read and Unread Mail
• Reply and Forward
o Reply to an Email
o Forward an Email
• Format Email
o Change Message Format
o Change Font
o Change Font Size
o Change Font Color
o Font Styles and Text Effects
o Remove Message Formatting
o Work with Attachments
o Attach a File
o Preview Attachments
o Open an Attachment
o Save Attachments
o Remove Attachments
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 28
OUTLOOK 102 MOVING BEYOND THE BASICS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Sending and receiving emails is by far the most used aspect of Outlook. You currently use
Outlook for the basics of sending email. In this course you will start to move beyond the basics.
You will learn how to search for things, delete items, and access Outlook’s help features. This
course will also show you how to read, send, sort, and forward email. You’ll also learn how to
personalize your messages with different formatting options, pictures, attachments, and
signatures
• Work with Pictures
o Insert a Picture
o Format a Picture
• Work with Hyperlinks
o Add a Hyperlink
• Check Spelling and Grammar
o Use AutoCorrect
o Spelling and Grammar Errors
o Correct a Spelling or Grammar Error
o Ignore a Spelling or Grammar Error
o Add a Word to the Dictionary
o Change Spelling Options
• Drafts and Sent Items
o Save a Draft
o Open a Draft
o View Sent Items
o View the Outbox
• Deal with Junk Email
o Mark a Message as Junk
o View Junk Mail
o Mark a Message as Not Junk
• Conversations
o Turn on Conversation View
o Expand a Conversation
o Optimize Conversation View
o Ignore a Conversation
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 29
• Sort and Filter Email
o Enable Focused Inbox
o Switch Between Focused and Other
o Move Email Between Focused and Other
o Disable Focused Inbox
o Filter by Read Status
o Sort by Common Criteria
o Advanced Sort
• Signatures
o Create a Signature
o Enter a Signature Manually
o Set Signature Defaults
• Automatic Replies
o Send Automatic Replies
• Email Options
o Specify Message Priority
o Specify Message Options
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 30
OUTLOOK PEOPLE, CALENDAR, TASKS AND NOTES LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Outlook’s Contacts list is a database that keeps track of names, addresses, phone numbers, and
other information in the People menu. Once you have entered a person’s name and details into
Outlook, the possibilities are endless. You can instantly find, share, edit, and sort contact
information—or even connect your list with social networks.
Other than email, the calendar is one of the most-used tools in Microsoft Outlook. The calendar
lets you keep track of appointments, such as a visit to the dentist, and events, such as a
vacation. It’s easy to add or reschedule an appointment or event in the calendar. After you’ve
entered your schedule into the calendar, you can display it in a variety of views.
Even if you’re not the most organized person, you probably scrawl a to-do list on a piece of
paper once in a while to help you remember everything that you have to do. Creating and
completing tasks in Outlook is better for keeping organized than writing them on paper. PEOPLE
• Add Contacts
o Add a New Contact
o Add a Contact from the Address Book
o Add a Contact from an Email
• Import Contacts
• Use the Address Book
o View the Address Book
o Address Book Actions
• View and Search Contacts
o View the People Pane
o View the Contact
o Change How Contacts are Listed
o Search Contacts
• Edit and Delete Contacts
o Edit a Contact
o Delete a Contact
• Tag Contacts
o Create Custom Categories
o Apply a Tag
o Search for Tags
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 31
• Sort Contacts
o Sort Contacts
o Sort in Groups
• Share Contacts
o Share a Single Contact
o Share All of Your Contacts
• Create Contact Groups
o Create a Contact Group
o Communicate with a Contact Group
• Modify Contact Groups
o Add Contacts to an Existing Contact Group
o Add Notes to a Contact Group
• Delete Contact Groups
o Remove Contacts from a Contact Group
o Delete a Contact Group TASKS
• Create and Complete Tasks
o Add a Task
o Update a Task
o Mark as Complete
• View Tasks
o View Tasks in the To-Do Bar
o View Task Lists
o Sort Tasks
o Change Views
• Recurring Tasks
o Create a Recurring Task
• Assign Tasks
o Assign a Task
o Accept or Decline an Assigned Task NOTES
• Create and Organize Notes
o View Notes
o Create a New Note
o Categorize a Note
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 32
o Change the Note View
o ADVANCED MAIL AND CALENDAR LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION ADVANCED MAIL
• Quick Steps
o Set Up Quick Steps
o Add a New Quick Steps
o Edit Quick Steps
• Quick Parts
o Create a Quick Part
o Use a Quick Part
• Redirect Replies
o Direct a Message’s Replies
• Recall Messages
o Recall a Message
o Check for Recall Success
• Create a Rule
o Create a Rule Based on an Email
o Create a Rule from Scratch
• Manage Rules
o Edit a Rule
o Delete a Rule
• Advanced Find
o Use Advanced Find
• Save Messages in Alternate Formats
o Save a Message as Another File Type
• Customize Response Formatting
o Change Response Font
o Change Response Format
• Share Your Email
o Delegate Mail Folders
o Access Shared Folders
• Themes and Stationery
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 33
o Use a Theme or Stationery Once
o Use Theme Styles
o Set Defaults
• Email Settings
o Configure Email Setting
• Add Additional Accounts
o Add an Account
• Manage Additional Accounts
o View Emails by Inbox
o Specify Where Email is Sent From
o Change the Default Account
o Use Multiple Accounts in the Calendar
o Use Multiple Accounts with your Contacts
• Track and Vote
o Send a Poll
o Track Votes ADVANCED CALENDAR
• Schedule Meeting Rooms
o Schedule a Resource
o Use Room Finder
o Find Room Times with the Scheduling Assistant
• Forward Calendar Items
o Forward a Calendar Item
o Send Calendar Information
• Share Your Calendar
o Open a Shared Calenda
o Send a Sharing Invitation
• Send Your Calendar
o Send Your Calendar in an Email
• Work with Multiple Calendars
o Add New Calendars
o View Multiple Calendars
o Overlay Calendars
o Delete a Calendar
• Calendar Settings
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 34
o Configure Calendar Settings MANAGE INFORMATION
• Use Categories
o Categorize an Item
o Rename a Category
o Create a New Category
o Delete a Category
o Sort by a Category
• Folders
o Create a Folder
o Move Items to a Folders
o Edit a Folder
o Delete a Folder
• Search Folders
o Create a Search Folder
o Use a Search Folder
• View Old Mail
o View Old Mail
o Cached Exchange Mode
• Clean Up Messages
o Clean Up a Conversation
o Clean Up a Folder
o Mailbox Cleanup
• Archive Information
o Run Archive Manually
o Set up AutoArchive
o Adjust Folder Settings
o Access Archived Items
• Export Information
o Export Data from Outlook
• Import Information
o Import Data to Outlook
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 35
OUTLOOK CONTROLLING AN OUT-OF-CONTROL INBOX LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
This course is designed for the individual who has been using Microsoft Outlook
extensively but wants to learn the tricks that can make life easier and your work day
more efficient. This fast-paced course will cover topics you are already using in
Outlook but in a more efficient way.
• Getting Started with Outlook
o Navigate the Outlook Interface
• Working with the Quick Access Toolbar
• The Outlook Ribbon
• Work with Messages
o Creating a New E-Mail Message
o Turn on BCC for All Message
o Replying and Forwarding a Message
o Formatting Messages
o Check Spelling and Grammar
o Format Message Content
• Working with Attachments and Illustrations
• Attach Files and Items
• Attaching Outlook Items
• Add Illustrations to Messages
• Manage Automatic Message Content
• Send automatic out of office replies from Outlook
• Turn off automatic out-of-office replies
• Customizing Message Options
• Customize Reading Options
• Track Message
• Recall and Resend Messages
• Organizing Messages
• Mark Message
• Flagging Emails
o Flag email messages for follow up
o Flag to remind recipients to follow u
o Flag to remind you to follow up
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 36
o Flag to remind you and recipients to follow up
• Modify Message Settings and Options
• Use Voting Buttons
• Review the voting responses
o Track and print poll results
• Save Sent Items to
o Delay Delivery
o Direct Replies To
• Organize Messages Using Folders
• QuickParts
o Create a reusable building block
o Find and Use a QuickPart
o Rename a Building Block
o Delete a building block
• Organizing, Searching, and Managing Message
o Group and Sort Messages
• Search Outlook Items
• Filter and Manage Messages
• Managing Your Mailbox
• Use the Junk E-Mail Filter to Manage Messages
• Manage Your Mailbox
• Automating Message Management
o Use the Rules Wizard to Organize Messages
o Create and Use Quick Steps
• Creating an Email Template
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 37
WORD COURSES WORD FUNDAMENTALS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Microsoft Word is a powerful word processor with a lot of features to help you create
professional documents. With so many features, though, it can be pretty daunting at first.
In this course, you’ll learn the fundamentals of using Microsoft Word. You’ll get a feel for the
interface and learn how to create, open, and save new Word documents. You’ll also learn how
to view and navigate documents, and how to print and share them
WORD FUNDAMENTALS
• Understand the Screen
o The Word Screen
• Create New Documents
o Create a Blank Document
o Create a Document from a Template
• Open a File
o Open a Document
o Open a PDF for Editing
• Save a File
o Save a New Document
o AutoSave Documents
o Save Progress
o Save As a New File and/or Location
o Save to Different File Formats
• AutoRecover
o Recover a Document
o AutoRecover Settings
• Navigate a Document
o Move the Insertion Point
o Scroll in a Document
o Use the Navigation Pane
• View Documents
o Change Document Views
o Zoom
o Show or Hide Formatting Symbols
• View Multiple Documents
o Switch Windows
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 38
o View Documents Side by Side
o Split the Window
• Print
o Print a Document
• Share a Document
o Share a Document
o Manage Access to a Document
• The Quick Access Toolbar
o Customize the Quick Access Toolbar
• Help
o The Tell Me Field
o The Help Pane
• Document Properties
o View and Edit Document Properties
o View Advanced Properties
• Check Accessibility and Compatibility
o Check Accessibility
o Check Compatibility
• Close and Exit
o Close a Document
o Close Word
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 39
WORD WORKING WITH AND EDITING TEXT LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
While Word has plenty of additional features, its main function is to be a word processor. This
means that inserting and editing text is its primary focus.
In this course, you’ll learn the basics of inserting and editing text. You’ll learn how to select text,
as well as how to cut, copy, and paste text. You’ll also learn how to check spelling and grammar,
view your word count, find and replace text, and insert symbols and outside text into your
documents.
WORK WITH AND EDIT TEXT
• Select and Edit Text
o Select Text
o Edit Text
• Cut, Copy, and Paste
o Copy and Paste
o Cut and Paste
• Undo, Redo, and Repeat
o Undo a Single Change
o Undo Multiple Changes
o Redo
o Repeat
• Check Spelling and Grammar
o Spelling and Grammar Errors
o Correct a Spelling or Grammar Error
o Ignore a Spelling or Grammar Error
o Add a Word to the Dictionary
• Word Count and Thesaurus
o Find the Word Count
o Use the Thesaurus
• Find and Replace Text
o Find Text
o Advanced Find
o Replace Text
• Insert Symbol
o Insert a Symbol
• Insert Text from Another File
o Insert Text from File
• Use AutoCorrect
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 40
o Add New AutoCorrect Entries
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 41
WORD FORMATTING TEXT AND PARAGRAPHS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Once you understand the basics of entering text, it’s time to move on to learning how to format
that text in a way that looks nice and is very functional on the page.
In this course, you’ll learn how to format text by changing font, size, color, and other effects.
You’ll also learn ways to format paragraphs, including alignment, indenting, spacing, borders,
and shading. This module also shows how to format text and paragraphs as different types of
lists, how to copy formatting, and how to find and replace formatting.
FORMAT TEXT AND PARAGRAPHS
• Format Fonts
o Change the Font
o Change the Font Size
o Change the Font Color
o Apply Bold, Italic, or an Underline
o Change the Cas
o Clear Formatting
• Create Lists
o Numbered Lis
o Bulleted List
o Multilevel Lists
o Change the List Styles
o Custom Numbering
• Paragraph Alignment
o Align a Paragraph
• Borders and Shading
o Add a Border
o Add Shading
o Additional Border and Shading Option
• Line and Paragraph Spacing
o Change Line Spacing
o Change Paragraph Spacing
• Copy Formatting
o Copy Text Formatting
• Indent Paragraphs
o Increase or Decrease Indent
o Custom Indentation Options
o First Line and Hanging Indents
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 42
• Tab Stops
o Enable Formatting Marks and the Ruler
o Set a Tab Stop Using the Ruler
o Set a Custom Tab Stop
o Move or Remove a Tab Stop
• Find and Replace Formatting
o Find and Replace Text Formatting WORD FORMATTING THE PAGE LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION FORMAT THE PAGE
Once you’ve filled a page with text, it’s time to step back and think about how that text appears
on the page. When you format a page, you change how much of the page is covered in text as
well as how that text flows through the page.
In this course, you’ll learn how to adjust a page’s margins, size, and orientation. You’ll also learn
how to add content to the header and footer of a page, including page numbers. Finally, you’ll
learn how to break text into columns, how to manually break between pages, and format what,
if anything, appears on the page’s background.
• Adjust Margins
o Choose a Margin Size
o Set Custom Margins
• Page Size and Orientation
o Change Page Size
o Change Page Orientation
• Headers and Footers
o Use a Header or Footer
o Remove a Header or Footer
o Create a Custom Header or Footer
• Page Numbers
o Add Page Numbers
o Format Page Numbers
o Remove Page Numbers
• Columns
o Format Columns
o Use a Column Break
• Page Breaks
o Insert Page Breaks
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 43
o Remove a Page Break
o Insert a Blank Page
o Use Paragraph Line and Page Breaks
• Page Background Elements
o Add a Watermark
o Add Page Color
o Add Page Borders
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 44
WORD TABLES LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
You can use tables in your documents to arrange text and data neatly in a grid, organized by
columns and rows. Once you’ve entered information into a table, you can style a table to stand
out on the page or sort a table’s contents alphabetically or numerically.
In this course, you’ll learn how to create tables from scratch or from existing text. You’ll also
learn how to change a table’s size, position, and style, as well as how to sort a table’s contents.
• Tables
o Create Tables
o Insert a Table
o Add a Row or Column
o Delete a Row or Column
• Convert Tables
o Convert Text to Tables
o Convert Table to Text
• Resize Rows and Columns
o Manually Resize
o Distribute Rows and Columns
o Automatically Resize
• Table Styles
o Apply a Table Style
o Adjust Style Options
• Table Borders and Shading
o Add a Border
o Add Cell Shading
• Position a Table
o Align a Table
o Move a Table
o Adjust Text Wrapping
o Resize a Table
• Cell Alignment and Margins
o Text Alignment
o Add Cell Margins
• Merge and Split Cells
o Merge Cells
o Split Cells
o Split Tables
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 45
• Sort a Table
o Sort Tables
o Row Headers and Page Breaks
o Repeat Row Headers
o Adjust Page Break Options WORD GRAPHICS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Documents that include pictures, drawings, and graphics can be much more compelling and
effective than documents that only contain plain text. Once you know how to work with
pictures and graphics, you can make all kinds of documents, such as newsletters, greeting
cards, and pamphlets.
In this module, you’ll learn how to insert pictures, text boxes, shapes, and other sorts of
graphics into your documents. You’ll also learn how to position, layer, rotate, align, and group
the graphics you insert. GRAPHICS
• Pictures
o Insert a Picture
o Insert an Online Picture
o Crop a Picture
o Use Picture Styles
o Use Artistic Effects
• Screenshots and Remove Background
o Insert a Screenshot
o Remove a Background
• Text Boxes
o Insert a Text Box
o Draw a Text Box
o Link Text Boxes
• Shapes
o Insert a Shape
o Shape Styles
o Add Text
• Icons
o Insert an Icon
o Format an Icon
• Drawings
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 46
o Create a Drawing
o Change Pen Type
o Erase a Drawing
• Add Descriptive Text
o Add Alt Text
• WordArt
o Insert WordArt
o Format WordArt
• Chart
o Insert a Chart
o Add Chart Data
o Change the Layout
o Modify Chart Elements
• SmartArt
o Insert SmartArt Diagrams
o Add Text
o Format SmartArt
• Modify Objects
o Resize an Object
o Move an Object
o Rotate an Object
o Delete an Object
• Position and Text Wrap
o Wrap Text Around an Object
o Position an Object
o Align an Object to Text
• Layer Objects
o Use the Layer Object Buttons
o Use the Selection Pane
• Flip and Rotate Objects
o Flip or Rotate an Object
• Distribute and Align
o Distribute or Align an Object
• Group Objects
o Group
o Ungroup
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 47
WORD STYLES, THEMES, AND TEMPLATES LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
You can use styles in your documents to apply multiple formatting options in a single step. You
can also update a style after you’ve applied it, automatically updating all the text using that
style. You can also apply themes to a document, which help to create a unified appearance
across different types of graphics.
In this module, you’ll learn how to apply and modify text styles, as well as document themes.
You’ll learn how document templates work and how to create custom themes and style sets. STYLES, THEMES, AND TEMPLATES
• Apply and Modify Styles
o Apply a Style
o Change Style Sets
o Create a Style
o Modify a Style
o Only Show Styles in Use
• Themes
o Apply a Theme
o Customize a Theme
• Templates
o Use a Document Template
o Create a Document Template
o Edit a Custom Template
o Custom Themes and Style Sets
o Create Custom Color Sets
o Create Custom Fonts Sets
o Create Custom Themes
o Create Custom Style Sets
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 48
WORD LONG DOCUMENTS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
If you’re working on a longer document, such as a thesis paper or book, Word has several tools
you can use to organize the document’s sections and references.
In this module, you’ll learn how to create an outline as well as add bookmarks, cross-
references, sections, hyperlinks, captions, footnotes, endnotes, and citations. You’ll also learn
how to quickly jump between sections of a document and create tables of contents and
indexes. LONG DOCUMENTS
• Outlines
o Outline View
o Demote or Promote Items
o Collapse and Expand Headings
• Navigate Long Documents
o Turn on the Navigation Pane
o Use the Navigation Pane
• Bookmarks
o Add a Bookmark
o Find a Bookmark
• Pagination and Hyphenation Options
o Control Pagination
o Control Hyphenation
• Sections
o Insert a Section Break
o Customize a Section Layout
• Cross References
o Insert a Cross-reference
• Links
o Insert a Link
• Table and Figure Captions
o Add a Figure Caption
o Add a Table Caption
o Add Table of Figures
• Footnotes and Endnotes
o Create Footnotes and Endnotes
o Modify Footnote and Endnote Properties
• Citations
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 49
o Create a Citation
o Add a Bibliography
• Table of Contents
o Insert a Table of Contents
o Customize a Table of Contents
o Update a Table of Contents
• Index
o Insert an Index Entry
o Insert an Index
o Update an Index WORD WORKING WITH COMPLICATED DOCUMENTS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
This course is designed for the more experienced Microsoft Word user. Do you work
with long documents that require extensive formatting, tables of contents, various
page sizes, and various headers and footers? If the answer is yes, this is the course
for you. This fast paced class will take topics covered in previous Word courses and
combine them so at the end of the course you will master creating a complicated
Microsoft Word document. WORD TEMPLATES AND MACROS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
This course is designed for the more experienced Microsoft Word user who has a
desire to automate tasks using Microsoft Word Macros and how to create and
design customized templates.
WORD MAIL MERGE AND NEWSLETTERS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
This course is designed for the individual who has been using Microsoft Word and
who would like to know more intermediate/advanced features of the program. We
will cover in detail how to perform a Microsoft Word Mail Merge. We will create a
letter mail merge, a labels mail merge and an envelopes mail merge. In addition, we
will use skills from previous Microsoft Word courses such as sections, columns and
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 50
graphics to create and setup a newsletter.
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 51
POWERPOINT COURSES POWERPOINT THE BASICS LENGTH 3 HOURS
This course is designed for the individual who has been tasked with creating a
PowerPoint presentation and has minimal or no experience with the program POWERPOINT ADVANCED FEATURES LENGTH 3 HOURS
As a PowerPoint user, you are familiar with the basics of creating a presentation and
you are able to convey information effectively in a simple way Static content in
presentation, however, will not keep your audience interested In this course, you will
enhance presentations with feature that will transform basic presentations into a
powerful means of communication.
You will enhance your presentation with features that will transform it into a powerful
means of communication You will customize the PowerPoint interface to suit your
requirements and use the new and enhanced features to create dynamic and visually
appealing presentations You will then finalize a presentation and secure it to
authenticate its validity
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 52
ACCESS COURSES ACCESS LEVEL 1 LENGTH 6 HOURS
Most organizations maintain and manage large amounts of information One of the
most efficient and powerful ways of managing data is by using relational databases
Information can be stored, linked, and managed using a single relational database
application and its associated tools In this course, you will examine the basic
database concepts, and create and modify databases and their various objects using
the Microsoft® Office Access™ relational database application
This course is designed for students who wish to learn the basic operations of the
Microsoft Access database application to perform their day-to-day responsibilities,
and to understand the advantages that using a relational database application can
bring to their business processes The Level 1 course is for the individual whose job
responsibilities include designing and creating new databases, tables, and
relationships; creating and maintaining records; locating records; and producing
reports based on the information in the database
Upon successful completion of this course, students will be able to:
• examine the basic database concepts and explore the Microsoft Office Access environment
• design a simple database
• build a new database with related tables
• manage data in a table
• query a database using different methods
• design forms
• generate reports
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 53
ACCESS LEVEL 2 LENGTH 6 HOURS
You have the basic skills needed to work with Microsoft® Office Access™ databases,
including creating and working with Access tables, relationships, queries, forms, and
reports But so far, you have been focusing only on essential database user skills In
this course, you will consider how to maintain data consistency, how to customize
database components, and how to share Access data with other applications
Microsoft Office Access : Level 2 is designed for students who would like to learn
intermediate-level operations of the Microsoft Office Access program The Level 2
course is for individuals whose job responsibilities include maintaining data
integrity; handling complex queries, forms, and reports; and sharing data between
Access and other applications This course is also a prerequisite to taking more
advanced courses in Access
Upon successful completion of this course, students will be able to:
• modify the design and field properties of a table to streamline data entry and maintain data integrity
• retrieve data from tables using joins
• create flexible queries to display specified records, allow for user-
determined query criteria, and modify data using queries
• enhance the capabilities of a form by grouping form controls
and making other aesthetic improvements to make forms work
more efficiently and intuitively for the user
• customize reports to organize the displayed information and produce specific print layouts
• share data across different applications
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 54
PROJECT COURSES PROJECT LEVEL 1 LENGTH 6 HOURS
You need to gather information about the various tasks involved, resources required
to accomplish the tasks, and the overall cost in order to plan a project Microsoft®
Office Project Professional acts as a tool that assists you in managing your projects
In this course, you will create and modify a project plan
Course Objective: You will create a project plan containing tasks, organize these
tasks in a work breakdown structure containing task relationships, create and assign
resources, and finalize the project to implement the project plan PROJECT LEVEL 2 LENGTH 6 HOURS
Microsoft Project : Level 2 is the second course in the Microsoft Project series In
Microsoft Project : Level 1, you used your project management skills to create a
complete project plan The plans need to be updated and modified regularly to
keep the project moving on track This course will build upon the knowledge gained,
and give you the opportunity to work with a project plan once it reaches the
project implementation phase
Upon successful completion of this course, students will be able to:
• exchange project plan data with other applications
• update a project plan
• manage project costs
• report project data visually
• reuse project plan information
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 55
VISIO COURSES VISIO PROFESSIONAL LEVEL 1 LENGTH 6 HOURS
Diagrams and charts play a pivotal role in knowledge dissemination, making complex
data easy to understand Microsoft® Office Visio® Professional has a host of features
that are instrumental in creating pictorial representations of information In this
course, you will learn the essentials of Visio
This course is designed for persons who have an understanding of basic workflows
and the concept of end-to-end flowcharting
Upon successful completion of this course, students will be able to:
• explore the Visio interface
• create a route map
• enhance a basic diagram
• create process diagrams
• create an organization chart
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 56
GOOGLE APPS GOOGLE DRIVE COURSES GOOGLE DRIVE PART 1 LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Google Drive is a secure, online storage drive where you can save and synchronize files. Drive
can house any kind of file, but Google files, such as Google Docs, Sheets, and Slides can be
opened and edited online directly from Drive. When files are saved to Google Drive, they are
accessible from a web browser or any device using a Google Drive application
Google Drive is a great tool for collaborative editing of files. This course covers the
fundamentals of working with Google Drive, including creating and organizing files and folders,
sharing content, working with files offline, and much more
• Google Drive Views
o View My Drive
o Switch to Other Views
• Find Files
o Search for Files
o Toggle List and Grid View
o Sort Files
o Filter Results
o Show File Location
• Open Files and Folders
o Open a Folder
o Open a Folder in the Path
o Preview a File
o Open a File
• Create Files and Folders
o Create a Google File
o Copy a File
o Rename a File
o Create a Folder
• Move and Add Content to New Locations
o Move Files or Folders
o Add Files to My Drive
• Star and Color Code Content
o Star a File or Folder
o Remove from Starred
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 57
o Color Code a Folder
• Manage Workspaces
o Create a Workspace
o Add files to a Workspace
o Remove a File from a Workspace
o Hide or Remove a Workspace GOOGLE DRIVE PART 2 LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
This is a continuation of the Google Drive Part 1 course. We will build upon our existing
knowledge of the software application and take a deeper dive into more advanced features. GOOGLE DRIVE PART 2
• Delete and Restore Files
o Delete a file
o Restore a Deleted File
o Permanently Delete a File
• Share Content
o Share a File or Folder
o Get a Sharable Link
• Change access to Content
o Set Sharing Expiration
o Remove Access
o Change Owner
• Upload and Download Content
o Upload a File or Folder
o Automatically Convert Uploads
o Download a File or Folder
• Manage File Versions
o View the History of a File or Folder
o Upload a New Version
o Download or Delete a Previous Version
• Sync with Your computer
o Install Drive File Stream
o Open Drive File Stream
o Make Content Available Offline
o Pause or Resume Syncing
• Manage Notifications
o Adjust Notifications
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 58
o View Drive File Stream Notifications
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 59
GOOGLE SLIDE COURSES GOOGLE SLIDES FUNDAMENTALS, EDITING & ORGANIZING A PRESENTATION LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Google Slides is an online presentation application that helps you transform your ideas into
professional presentations that are convincing and informative Whether you’re delivering
annual sales statistics to a large audience or creating a personal slide show of your recent trip
abroad, Slides has all the tools you need to get your message across
This class is an introduction to working with Slides You’ll learn how to create, open, and print
presentations, as well as how to manage your presentation files and get help in Slides. We will
also cover the basics of working with slide text and objects, including how to cut, copy, and
paste content and how to find and replace text. You will also learn steps helpful for adding
speaker notes and slide numbers, moving and skipping slides, duplicating and copying slides,
and changing presentation views. SLIDES FUNDAMENTALS
• Create Presentations
o Create a Blank Presentation
o Name a Presentation
o Save and Close
o Create a Presentation from a Template
• Open a Presentation
o Open a Presentation from Google Drive
o Open a Presentation from Google Slides
• File Management
o Rename a Presentation
o Start a Presentation
o Copy a Presentation
o Move a Presentation
o Delete a Presentation
• Print a Presentation
o Print a Presentation
• Get Help
o Search for a Command
o Search Help Topics EDIT AND ORGANIZE A PRESENTATION
• Add and Lay Out Slides
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 60
o Insert a Slide
o Change A Slide Layout
o Insert a Specific Slide Layout
o Add Text to a Placeholder
o Delete a Slide
• Cut, Copy, and Paste
o Copy and Paste
o Cut and Paste
• Undo and Redo
o Undo
o Redo
o Repeat the Last Action
• Find and Replace
o Find Text
o Replace Text
• Add Speaker Notes
o Add Speaker Notes
o Toggle the Speaker Notes Pane
• Add Slide Numbers
o Add Slide Numbers
o Remove Slide Numbers
• Move and Skip Slides
o Move a Slide
o Skip a Slide
o Unskip a Slide
• Duplicate and Copy Slides
o Duplicate a Slide
o Copy and Paste a Slide
• Change Views
o Switch to Grid View
o Reorganize Slides in Grid View
o Return to Filmstrip View
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 61
GOOGLE SLIDES-FORMATTING, THEMES, GRAPHICS AND ANIMATIONS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Slides offers a wide array of text formatting options and themes that give you complete control
over the design of your slides. Themes help you design your presentation using a foundation of
coordinating palettes and styles. Presentations can look pretty dull if they only contain text.
Graphics not only bring visual appeal to your slides, but they also strengthen your message and
make your presentation more memorable.
Adding animations to you slides enable you to emphasize particular text or graphics on the slide
or to initially hide an element until you’re ready to unveil it to your audience.
In this course, you’ll learn how to insert and edit shapes and images, arrange and format
objects, apply slides transitions, and add animations to objects. FORMATTING AND THEMES
• Format Text
o Change the Font
o Change the Font Size
o Apply Text Effects
o Change Text Color
o Change the Case
o Align Text
• Borders and Shading
o Add a Border
o Change Border Color
o Change Fille Color
• Format Lists
o Format Numbered and Bulleted Lists
o Change List Style
• Insert Links
o Add a Web Link
o Add a Link to a Slide
o Visit a Link
• Copy and Clear Formatting
o Copy Text Formatting
o Copy Formatting to Multiple Items
o Clear Formatting
• Use Themes
o Apply a Theme
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 62
o Update a Theme
o Edit a Master Layout GRAPHICS AND ANIMATIONS
• Insert and Edit Shapes
o Insert a Shape
o Move and Resize a Shape
o Format a Shape
o Change a Shape
• Insert Images
o Insert an Image from Your Computer
o Insert an Image from the Web
• Edit Images
o Crop an Image
o Mask an Image
• Arrange Objects
o Rotate an Object
o Flip an Object
o Bring Forward/Send Backward
o Group Objects
o Align Objects
• Format Objects
o Adjust Size and Position
o Recolor an Image
o Adjust an Image's Appearance
o Apply Shadow or Reflection Effects
• Apply Slide Transitions
o Apply a Transition
o Modify a Transition
• Add Animations to Object
o Add an Animation
o Change Animation Order
o Remove an Animation
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 63
GOOGLE SLIDES-INSERTING OBJECTS, DELIVERING A PRESENTATION AND COLLABORATING LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
In the previous course we learned to add pictures. Besides pictures, you can add many other
types of objects to your presentation, including text boxes, diagrams, and videos. Each type of
object has a unique purpose and can boost your presentation in different ways. You can also
add charts and tables to your presentation to help articulate complex data in a way that can be
easily consumed.
The ultimate goal for building a presentation in Slides is to deliver it to others. There are several
delivery tools to make presenting your information easier, including navigation shortcuts, a
laser pointer, and closed captioning. This course will also cover how to present a slideshow,
how to use slideshow tools, and how to use Presenter view.
You can use Google Slides to collaborate on presentations with other users. We will cover how
to download and email presentations, share presentations, collaborate with other users on
presentations, work with versions of a presentation, and install add-ons. INSERT OBJECTS
• Insert a Text Box
o Insert a Text Box
o Format Text Box
o Resize and Move a Text Box
o Insert Charts
• Insert a Chart
o Edit a Chart
• Insert Tables
o Insert a Table
o Enter Text into a Table
o Insert a Row or Column
o Delete a Row or Column
• Insert Diagram
o Insert a Diagram
• Insert Word Art
o Insert Word Art
o Format Text Borders
o Resize Word Art
• Insert Videos
o Insert a Video
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 64
o Format Video Options DELIVER A PRESENTATION
• Present a Slideshow
o Present a Slideshow
o Navigate a Slideshow
• Use Slideshow Tools
o Use the Pointer Tool
o Use Closed Captioning
• Use Presenter View
o Open Presenter View
o Navigate in Presenter View
o Use the Timer
o View Notes
o Run Q&A SHARE, COLLABORATE, AND CONVERT
• Download and Email Presentations
o Download a Presentation
o Email a Presentation
• Share Presentations
o Share a Presentation
o Change Share Settings
o Publish to Web
• Collaboration
o Add Comments
o Reply to a Comment
o Resolve a Comment
• Work with Versions
o View Versions
o Create a Named Version
o Restores a Version
• Add-Ons
o Install an Add-On
o Access Add-Ons
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 65
GOOGLE SHEETS COURSES GOOGLE SHEETS FUNDAMENTALS AND EDITING LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Google Sheets is a powerful spreadsheet application that provides quick and accurate
numerical calculations and helps make data look sharp and professional. The uses for Sheets
are limitless: businesses use Sheets for creating financial reports; scientists use Sheets for
statistical analysis; and families use Sheets to help manage their investment portfolios.
Entering, editing and removing data are some of the most common tasks you will likely carry
out in Sheets. By mastering the skills needed to accomplish these tasks efficiently, you are well
on your way to becoming a proficient user. As with most Google Suite applications, there is
often more than one way to achieve your end goal in Sheets.
This course will help you get started with Sheets. Learn how to create a new spreadsheet,
navigate a spreadsheet, and print your spreadsheets. We will explain some of the primary and
alternative methods for creating, editing, moving, and deleting data. In some cases, you can use
shortcuts or apply a change to multiple instances at once to do more with your spreadsheet in
less time. SHEETS FUNDAMENTALS
• Create Spreadsheets
o Create a Spreadsheet
o Name a Spreadsheet
o Save and Close
o Create a Spreadsheet from a Template
• Open a Spreadsheet
o Open a Spreadsheet from Google Drive
o Open a Spreadsheet from Google Sheets
• Navigate Spreadsheets
o Select a Cell
o Navigate Between Cells and Pages
o Navigate Between Sheets
• File Management
o Rename a Spreadsheet
o Star a Spreadsheet
o Copy a Spreadsheet
o Move a Spreadsheet
o Delete a Spreadsheet
• Print Spreadsheets
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 66
o Print a Spreadsheet
• Get Help
o Search for a Command
o Search for Help Topics EDIT SPREADSHEETS
• Select Cells and Ranges
o Select a Cell
o Select a Row
o Select a Column
o Select a Range of Cells
o Select All Cells
o Edit Cell Data
o Enter Cell Data
• Edit Cell Data
o Enter Cell Data
o Replace Cell Data
o Edit Cell Data
o Clear Cell’s Contents
• Cut, Copy, and Paste Data
o Copy and Paste
o Cut and Paste
• Undo, Redo, and Repeat
o Undo and Redo
o Repeat the Last Action
• Use Paste Special
o Paste Formulas
o Paste Values
o Transpose Data
o Paste Special Options
• Insert and Move Cell
o Insert Cells
o Insert Rows or Columns
o Move Cells
• Delete Cells
o Delete Cells
o Delete Rows and Columns
• Hide Rows and Columns
o Hide a Row or Column
o Unhide a Row or Column
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 67
• Find and Replace Text
o Find Text
o Find and Replace Text
• Check Spelling
o Check Spelling
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 68
GOOGLE SHEETS FORMATTING LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Formatting the contents of your spreadsheet can make even the most basic set of data easier
to understand. From fonts, to colors, to borders, Sheets allows you to completely customize the
formats of nearly anything in your worksheet.
This course will demonstrate the most common options for formatting text, numbers, cells,
rows, and columns to make your worksheet more visually attractive and professional FORMAT SPREADSHEETS
• Format Text
o Change Font
o Change Font Size
o Apply Font Effects
o Clear Text Formatting
• Align and Merge Cells
o Change Horizontal Alignment
o Change Vertical Alignment
o Wrap Text
o Merge Cells
o Unmerge Cells
• Cell Borders and Background Colors
o Add a Cell Border
o Edit a Cell Border
o Change Fill Color
• Format Numbers and Dates
o Apply Currency Format
o Apply Date Format
o Apply a Custom Date and Time Format
o Create a Custom Number Format
• Adjust Row Height and Column Width
o Adjust Row Height or Column Width Manually
o Adjust Row Height or Column Width Automatically
o Specify a Row Height or Column Width
• Freeze Rows and Columns
o Freeze a Row or Column
o Unfreeze Rows or Columns
• Copy and Paste Formatting
o Paste Copied Formatting
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 69
• Apply Conditional Formatting
o Create a Conditional Formatting Rule
o Delete a Conditional Formatting Rule GOOGLE SHEETS FORMULAS AND FUNCTIONS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Sheets is capable of performing extremely complex calculations as long as the right formulas
are in place. In this module, we’ll introduce the basics of working with simple formulas that new
Sheets users find to be most applicable. You can use Sheets to quickly perform common
operations, such as adding, subtracting, multiplying, and dividing. You can even find the
average of a large dataset in an instant FORMULAS AND FUNCTION
o Formula Basics
o Create a Formula
o Update a Formula Result
o Edit a Formula
• Autofill
o Use Autofill to Duplicate Data
o Use Autofill to Enter a Series
• Sums and Averages
o Insert a SUM Function
o Insert an AVERAGE Function
• MIN and MAX
o Insert a MAX Function
o Insert a MIN Function
• COUNT
o Insert a COUNT Function
• Insert Functions
o Insert a Function
o Get Help on Functions
• Absolute and Relative Cell References
o Relative References
o Absolute References
• Cell Range Names
o Name a Cell Range
o Use a Cell Range Name in a Formula
o Go To a Named Range
o Edit and Delete Cell Range Names
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 70
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 71
GOOGLE SHEETS MANAGING SHEETS AND DATA LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Once your spreadsheet is full of data, you may want to use multiple sheets. If your spreadsheet
contains a collection of sheets, it is useful to know how to add, move, copy, and hide sheets. In
addition to managing your sheets, you can manage your spreadsheet’s data by sorting it,
filtering it, and applying data validation to it. This course will also teach you how to protect
your spreadsheets. MANAGE SHEETS AND DATA
• Insert, Rename, and Delete Sheets
o Insert a Sheet
o Rename a Sheet
o Delete a Sheet
• Duplicate, Move, and Hide Sheets
o Duplicate a Sheet
o Move a Sheet
o Hide a Sheet
o Unhide a Sheet
• Sort Data
o Sort by One Column
o Sort by Multiple Columns
• Filter Data
o Filter Data
o Advanced Filters
o Clear a Filter
• Data Validation
o Create a Validation Rule
o Edit or Remove Data Validation
• Protect Spreadsheets
o Protect a Spreadsheet
o Edit or Delete Protection
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 72
GOOGLE SHEETS INSERTING OBJECTS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
In some cases, basic text and numbers aren’t enough to make your spreadsheet shine. For
instance, you can present data, relationships, or trends graphically with charts. You can also add
an image, like a logo, to brand your spreadsheet. By inserting a link, you can quickly connect
users of your spreadsheet to other files, webpages, email, or even a special location in the
current spreadsheet INSERT OBJECTS
• Insert a Chart
o Create a Chart
o Move a Char
o Resize a Chart
• Customize a Chart
o Modify a Chart
o Change Chart Type
o Switch Rows and Columns
o Change a Chart Title
o Change a Chart Legend
• Insert Images
o Insert an Image
• Insert Links
o Insert a Link
o Use a Link
o Remove a Link
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 73
GOOGLE SHEETS SHARE, COLLABORATE, AND CONVERT LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
There are several options for sharing spreadsheets that make it easy for others to review and
provide feedback. You can add comments directly to a cell so your note has context. If you track
changes in your document, any adjustments made in the review process will be transparent and
can be accepted or rejected.
This course also covers sharing spreadsheets as well as viewing and restoring previous versions
of a spreadsheet. In addition, there are many add-ons available for install that can makes
Sheets even more powerful. SHARE, COLLABORATE, AND CONVERT
• Upload and Convert Spreadsheet
o Upload a Spreadsheet
o Convert a Spreadsheet
o Download and Email Spreadsheet
• Download a Spreadsheet
o Email Spreadsheet
o Share Spreadsheets
• Share a Spreadsheet
o Change Share Settings
• Collaborate
o Add Comments
o View a Comment
o Reply to a Comment
o Resolve a Comment
• Work with Versions
o View Versions
o Restore a Version
o Create a Named Version
• Add-Ons
o Install an Add-On
o Access Add-Ons
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 74
GOOGLE DOCS COURSES GOOGLE DOCS FUNDAMENTALS AND EDITING LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Google Docs is an online word processor with a lot of features to help you create professional
documents. With so many features, though, it can be pretty daunting at first.
While Google Docs has plenty of additional features, its main function is to be a word
processor. This means that inserting and editing text is its primary focus.
In this course, you’ll learn the fundamentals of using Google Docs, such as how to create, open,
and manage documents. You’ll also learn how to print documents and how to get help in
Google Docs. In addition this course will cover the basics of inserting and editing text. You’ll
learn how to select text, as well as how to cut, copy, and paste text. You’ll also learn how to
insert page breaks, undo and redo commands, view your word count, check spelling and
grammar, and find and replace text DOCS FUNDAMENTALS
• Create Documents
o Create a Blank Document
o Name a Document
o Save and Close
o Create a Document from a Template
• Open a Document
o Open a Document from Google Drive
o Open a Document from Google Docs
• File Management
o Rename a Document
o Star a Document
o Copy a Document
o Move a Document
o Delete a Document
• Print Documents
o Print a Document
• Get help
o Search for a Command
o Search Help Topics EDIT A DOCUMENT
• Select and Edit Text
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 75
o Select a Block of Text
o Select a Word, Paragraph, Everything
o Edit Text
• Cut, Copy, and Paste
o Copy and Paste
o Cut and Paste
o Move with Drag and Drop
• Page Breaks
o Insert a Page Break
• Undo and Redo
o Undo
o Redo
• Word Count and Dictionary
o View Word Count
o Use the Dictionary
• Check Spelling
o Correct a Spelling or Grammar Error
o Ignore a Spelling or Grammar Error
o Add a Word to the Dictionary
• Find and Replace
o Find Text
o Replace Text
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 76
GOOGLE DOCS FORMATTING TEXT AND PARAGRAPHS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Once you have the basics of entering text, it’s time to move on to learning how to format that
text in a way that looks nice and is very functional on the page.
In this course, you’ll learn how to format text by changing font, size, color, and other effects.
You’ll also learn ways to format paragraphs, including alignment, indenting, and spacing. This
course also shows how to format text and paragraphs as different types of lists, how to copy
formatting, how to create tab-stops, and how to format your text into columns FORMAT TEXT AND PARAGRAPHS
• Format Text
o Apply Bold, Italic, or an Underline
o Change the Text or Highlight Color
o Use Additional Formatting Options
o Change Font
o Change Font Size
• Create Lists
o Bulleted and Numbered Lists
o Change List Style
o Change List Levels
• Align and Indent Paragraphs
o Align a Paragraph
o Indent Text
• Line and Paragraph Spacing
o Change Line Spacing
o Change Paragraph Spacing
• Paragraph Styles
o Use Paragraph Styles
o Update Paragraph Styles
o Reset Paragraph Styles
• Copy and Clear Formatting
o Copy Text Formatting
o Copy Formatting to Multiple Items
o Clear Formatting
• Tab-Stops
o Set a Tab-Stop
o Align Text to a Tab-Stop
o Move or Remove a Tab-Stop
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 77
• Columns
o Apply a Column Layout
o Customize a column Layout
o Insert a Column Break GOOGLE DOCS FORMATTING THE PAGE AND INSERTING OBJECTS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Once you’ve filled a page with text, it’s time to step back and think about how that text appears
on the page. When you format a page, you change how much of the page is covered in text, as
well as how that text flows through the page.
You can include various objects in your documents to make them more appealing or organized.
Documents that include images can be much more compelling and effective than documents
that only contain plain text. When you’re working with longer documents, it’s helpful to include
bookmarks and a table of contents, to make them easier to follow.
In this COURSE, you’ll learn how to adjust a page’s margins, size, and orientation. You’ll also
learn how to add extra content to the header and footer of a page, including page numbers.
You’ll also learn how to insert images, links special characters, table of contents, and
bookmarks FORMAT THE PAGE
• Page Setup
o Adjust Margins
o Change Page Orientation
o Change Page Size
o Add Page Color
• Headers and Footers
o Add a Header or Footer
o Remove a Header or Footer
• Page Numbers
o Add and Remove Page Numbers INSERT OBJECTS
• Insert Images
o Insert a Picture
o Adjust Text Wrap
• Insert Links
o Insert a Link
• Insert Special Characters
o Insert a Special Character
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 78
• Insert Table of Contents
o Insert a Table of Contents
o Update a Table of Contents
• Insert Bookmarks
o Add a Bookmark
o Link to a Bookmark
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 79
GOOGLE DOCS INSERTING TABLES, SHARING, AND COLLABORATING LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
You can use tables in your documents to arrange text and data neatly in a grid, organized by
columns and rows. Once you’ve entered information into a table, you can style a table to stand
out on the page.
If you’re working with a team on a document, you can use Docs’ document collaboration tools
to make sure that everyone’s on the same page. You can leave comments, review the revisions
others make, or even work with different versions of a document.
In this class, you’ll learn how to create tables and how to adjust a table’s borders, shading, size,
and position. You will learn how to upload and convert documents, download and email
documents, share documents, collaborate with other users on a document, suggest edits, work
with different versions of a document, and install useful add-ons TABLES
• Insert Tables
o Insert a Table
o Enter Text into a Table
o Insert a Row or column
o Delete a Row or Column
o Delete a Table
• Table Borders and Shading
o Format Borders
o Add Cell Shading
• Resize and Position Tables
o Resize Rows and Columns
o Align a Table
o Move a Table SHARE, COLLABORATE AND CONVERT
• Upload and Convert Documents
o Upload a Document
o Convert a Document
• Download and Email Documents
o Download a Document
o Email a Document
• Share a Document
o Share a Document
o Change Share Settings
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 80
• Collaborate
o Add Comments
o Reply to a Comment
o Resolve a Comment
• Suggest Edits
o Edit with Suggesting Mode
o Accept or Reject Suggested Edits
• Work with Versions
o View Versions
o Create a Named Version
o Restore a Version
• Add-Ons
o Install an Add-On
o Access Add-Ons
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 81
GMAIL COURSES GMAIL READING, COMPOSING AND SENDING EMAIL LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Gmail lets you send and receive email messages while intelligently sorting your inbox. Sending
and receiving emails is by far the most used aspect of Gmail.
This course introduces the basics of viewing the email messages that you receive, navigating
your inbox, changing your inbox type, viewing email categories, and changing your inbox
theme. We will show you how to send, reply to, and forward email. You’ll also learn how to
personalize your messages with different formatting options, pictures, and attachments. You’ll
see how to schedule an email to send at a later time, send email messages confidentially, and
view your saved email drafts and previously-sent messages VIEW YOUR EMAIL
• Navigate Your Inbox
o The Inbox
o The Compose button
o Left Pane Links
o The Search Field
o The Toolbar
o Right side Panel
• Read Email
o Read an Email
o Open Email in a Separate Window
o Toggle Read Status
• Change Your Inbox Type
o Change to Important First View
o Change to Unread First View
o Change to Starred First View
o Change to Priority Inbox View
• Print an Email
o Print an Email
• View Email Categories
o Inbox Categories
o View an inbox Category
o Enable or Disable Tabs
• Change Your Inbox Theme
o Change the Inbox Theme
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 82
o Create a Custom Theme
• Get Help
o Search for Help COMPOSE AND SEND EMAIL
• Compose an Email
o Compose an Email
• Reply to and Forward Email
o Reply to Email
o Forward an Email
• Format Email Text
o Display Formatting Options
o Format Message Text
o Clear Text Formatting
• Add Attachments
o Attach a File
o Attach a File from Google Drive
• View and Save Attachments
o Save an Attachment
• Insert Pictures into Emails
o Insert a Photo
• Insert Links into Emails
o Insert a Link
• Check Spelling
o View Spelling Errors
o Fix Spelling Errors
o Check Spelling
• Schedule an Email
o Schedule an Email
o Cancel a Scheduled Email
• View Drafts and Sent Items
o Save an Email as a Draft
o View Email Drafts
o Edit and Send Email Drafts
o View Sent Emails
• Send and Receive Confidential Email
o Send a Confidential Email
o Read a Confidential Email
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 83
GMAIL ORGANIZING YOUR INBOX LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Gmail’s ability to keep your inbox organized is one of the reasons it’s so widely used. Labels
allow you to effectively sort messages into several categories at once, making it easy to find just
what you’re looking for.
In this course, you’ll learn how to use labels to organize your email, how to search and filter
your email, and how to keep track of important messages. You’ll also learn how to archive and
delete email, how to mute conversations, and how to snooze a message for later. ORGANIZING YOUR INBOX
• Create and Apply Labels
o Create a Label
o Apply a label to an Email
• View and Manage labels
o View labeled Email
o Show or Hide Labels
o Change a label Color
o Manage Labels
• Search for Emails
o Search a Search
o Refine a Search
• Filter Emails
o Create a Filter
o Create a Filter using Example Email
o Manage Filters
• Flag Important Emails
o Star an Email
o Star Multiple Emails
o Toggle Important Market
o View Starred Emails
o View Important Emails
• Archive and Delete Emails
o Archive an Email
o Delete an Email
o View the Trash
o Restore a Deleted Email
o Empty the Trash
• Mute Email
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 84
o Mute an Email Conversation
o View a Muted Conversation
o Unmute an Email Conversation
• Snooze Email
o Snooze an Email
o View Snoozed Email
o Unsnooze an Email
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 85
GMAIL CUSTOMIZE EMAIL SETTINGS LENGTH 3 HOURS-VIRTUAL (2) 90 MINUTE ONLINE SESSIONS COURSE DESCRIPTION
Once you’ve gotten the hang of reading, sending, and organizing your email, you can customize
Gmail’s settings to personalize how it works.
In this course, you’ll get an overview of Gmail’s settings page and learn how to enable
notifications. You’ll also learn how to add a signature or automatic vacation response, how to
access other email accounts in your Gmail inbox, and learn how to use Gmail’s keyboard
shortcuts CUSTOMIZE EMAIL SETTINGS
• Change Gmail Settings
o View and Modify Settings
o Settings Categories
o Return to the Inbox
• Enable Desktop notifications
o Enable Desktop notifications
o View a Gmail Notification
• Add a Signature
o Create a Signature
• Add a Vacation Response
• Add Other Email Accounts to Gmail
o Link Another Email Account
o Send Email from Another Address
o Changed Linked Account Settings
• Enable Keyboard Shortcuts
o Enable Keyboard Shortcuts
o Use Keyboard Shortcuts
o View Keyboard Shortcut Help
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 86
ADOBE APPLICATIONS ACROBAT COURSES ADOBE ACROBAT LEVEL 1 LENGTH 6 HOURS COURSE DESCRIPTION
You may have used different applications to create documents for your own reference
However, you may now be required to share your files electronically by email, over a
network, or on the web, so that recipients can view, print, and offer feedback In this course,
you will use Adobe Acrobat 90 to make your information more portable, accessible, and
useful to meet the needs of your target audience
• access information in a PDF document
• create PDF documents
• navigate to specific content in a PDF document
• modify PDF documents
• work with multiple PDF documents
• review a PDF document
• validate a PDF document ADOBE ACROBAT LEVEL 2 LENGTH 6 HOURS COURSE DESCRIPTION
As a business professional, you have some experience in using Adobe® Acrobat Now, you
are ready to further develop your PDF documents In this course, you will use Adobe® Acrobat
90 Pro to convert technical documents to PDF files, enhance and control PDF content
accessibility, customize PDF documents for interactive use online, and prepare PDFs for
commercial printing
You will use Adobe® Acrobat® 90 Pro to convert documents to PDF files, enhance and
customize PDF documents for interactive use online, and prepare them for printing
• create PDF files from technical documents
• enhance the utility and accessibility of PDF documents
• create interactive PDF forms using Adobe LiveCycle Designer
• make a PDF document ready for commercial printing
• finalize PDF files for commercial printing
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29
This course catalog is developed by CSUSM Extended Learning in partnership with OnSiteComputer
Training and is not to be duplicated or shared with competing vendors. Page 87
Contact CSUSM Extended Learning for pricing and additional information.
DocuSign Envelope ID: A5320A30-4F58-4099-96E5-BF6368D60A29