OPAL Class Descriptions

Access

Access – Getting Started with Access

  • Understand relational databases
  • Explore a database
  • Create a database
  • Create a table
  • Create primary keys
  • Relate two tables
  • Enter data
  • Edit data

Access – Building and Using Queries

  • Use the Query Wizard
  • Work with data in a query
  • Use Query Design view
  • Sort and find data
  • Filter data
  • Apply AND criteria
  • Apply OR criteria
  • Format a datasheet

Prerequisite: Some experience with Access.

Access – Advanced Queries

  • Perform calculations on groups of records using totals
  • Create crosstab queries to summarize grouped data
  • Create action queries
    • to add records to an existing table
    • to delete specific records from a table
    • to update to modify data in tables
  • Use a make table query

Prerequisite: Some experience with Access Queries.

Access – Using Forms

  • Use the Form Wizard
  • Create a split form
  • Use Form Layout View
  • Add a field to a form
  • Modify form controls
  • Create calculations
  • Modify tab order
  • Insert an image
  • Check Spelling

Prerequisite: Some experience with Access.

Access – Using Reports

  • Use the Report Wizard
  • Use Report Layout View
  • Review Report Sections
  • Apply group and sort orders
  • Add subtotals and counts
  • Resize and align controls
  • Format a report
  • Create mailing labels

Prerequisite: Some experience with Access.

Access – Automating with VBA and Macros

  • Working with forms
  • Working with events
  • Control statements
  • Program flow

Prerequisite: Some experience with Access.

Chromebook

Chromebook Overview

  • Introduction to Chromebooks via a presentation
  • Fast boot up, SSD hard drive
  • Screen elements
  • Online Google productivity suite of apps
  • Keyboard differences and keyboard shortcuts
  • Creating more than one account on a Chromebook
  • Pros & cons

ADA

Making ADA Accessible Documents

  • Exploring ADA topics via a presentation
  • Word Formatting
    • Styles and navigation
    • Paragraph spacing
    • Tables
    • Alt text
    • Accessibility checker
  • Save as PDF
  • Open document in Acrobat Pro
    • Use accessibility checker
    • Read out Loud

Prerequisite: Some experience with Word.

Adobe Products

Adobe Acrobat Pro DC: Editing PDF Basics

  • Introduction to the Acrobat screen
  • Convert a PDF image to a PDF with text recognition
  • Editing text and images
  • Add pages from other files
  • Using comments
  • Adding signatures

Adobe Acrobat Forms

  • Start with a Word document that includes underscores and/or tables
  • Save as PDF
  • Open in Adobe Acrobat Pro
  • Introduction to the Acrobat screen and Prepare Forms tools
  • Introduce different types of Fields
  • Insert Fields
  • Modify Fields
  • Test the Form
  • Insert a signature

Prerequisite: Some experience with Word.

Photoshop – Getting Started

  • Open image files
  • Select and use tools in the Tools panel
  • Set options using with the options bar,
  • Use various methods to Zoom in and out
  • Select and use panels and context menus
  • Layers panel
  • Adjustments panel

Photoshop – Layer Basics

  • Use layers to organize artwork
  • Create, view, hide and select layers
  • Rearrange layers to change stacking order
  • Resize and rotate layers
  • Apply a gradient
  • Apply blending and filters to layers
  • Add text and layer effects
  • Add an adjustment layer
  • Flatten layers with save as

Prerequisite: Some experience with Photoshop.

Illustrator – Getting Started

  • Differentiate between the various selection tools
  • Use different selection techniques
  • Recognize smart guides
  • Save selections for future use
  • Hide and lock Items
  • Use tools and commands to align shapes and points
    • To each other
    • To the artboard
  • Group and Ungroup items
  • Work in isolation mode

Illustrator – Using Shapes

  • Create a document with multiple artboards
  • Use tools and commands to create a variety of shapes
  • Work with Live shapes
  • Round Corners
  • Work with drawing modes
  • Work with the Shaper tool
  • Use image trace to create shapes

Prerequisite: Some experience with Illustrator.

InDesign – Getting Started

  • What is InDesign?
  • Overview of the Welcome Screen
  • Overview of the Create New Document window
  • Overview of InDesign screen elements
  • Insert text frame, edit text using Text tool
  • Insert picture1, move and crop picture using Selection tool
  • Use the Eyedropper tool to collect colors from picture
  • Save color swatches and assign names in the Swatches panel
  • Insert placeholder text
  • Create Columns
  • Create a paragraph style
  • Insert pictures, detect edges and text wrap

InDesign – Working with Text

  • Import text from file
  • Create columns
  • Connect text frames
  • Introduce fonts and the fonts control panel
  • Leading
  • Tracking
  • Kerning
  • Paragraph spacing
  • Text wrap around a picture
  • Align text to the baseline grid
  • Drop Caps
  • Type on a path

Prerequisite: Some experience with InDesign.

InDesign – Working with Images

  • Use different methods to insert images
    • Create the frame first
    • Do not create frame first
    • File/Place
    • Bring in multiple images using Bridge
  • Understand content vs frame
  • Apply the different Object Fitting options
    • Fit frame proportionally
    • Fit content proportionally
    • Fit frame to content
    • Fit content to frame
    • Center content
  • Understand Linked vs Embedded images
  • Introduce the Preflight Panel for errors and broken links
  • Use the rectangle tool to create rectangles and polygons
  • Use the pen tool
  • Crop an object out of an image

Prerequisite: Some experience with InDesign.

Excel

Excel – Getting Started

  • Understand spreadsheet software
  • Explore the Excel window
  • Understand formulas
  • Enter labels and values
  • Use Autosum
  • Edit cell entries
  • Enter and Edit a simple formula
  • Switch worksheet views
  • Choose print options

Excel Made Easy – Make spreadsheets work for you

  • Common problems and how to fix them:
    • Using blank rows and columns to create space -- properly create white space by resizing rows and columns and using horizontal and vertical alignments
    • Improper set up of heading row -- use different text wrap options
    • Applying background colors by selecting entire rows or columns -- apply color to specific range
    • Not separating the data range from other data on the sheet -- know when to add blank rows
    • Manually creating subtotals by category -- use built-in subtotals
  • Testing spreadsheet construction using the sort and filter tools (when a spreadsheet is properly constructed, the tools in Excel work for you)
  • Other topics as they arise if time permits

Prerequisite: Some experience with Excel.

Excel – Automating Spreadsheets

  • Data Form
  • Data Validation
  • Data Validation dependent lists
  • External referencing and 3D
  • Vlookup function

Prerequisite: Some experience with Excel.

Excel – Working with Formulas and Functions

  • Create a complex formula
  • Insert a function
  • Type a function
  • Copy and move cell entries
  • Understand relative and absolute cell reference
  • Copy formulas with relative cell references
  • Copy formulas with absolute cell references
  • Round a value with a function

Prerequisite: Some experience with Excel.

Excel Functions & Formulas: Dates & Times

  • Calculate number of days between dates
  • Calculate hours worked between 2 times
  • Today function
  • Datedif function
  • Networkdays function
  • Workday function

Prerequisite: Some experience with Excel.

Excel – Formatting a worksheet

  • Format values
  • Change font and font sizes
  • Change font styles and alignment
  • Adjust column width
  • Insert and delete rows and columns
  • Apply colors, patterns and borders
  • Apply conditional formatting
  • Rename and move a worksheet
  • Check spelling

Prerequisite: Some experience with Excel.

Excel – Working with Charts

  • Plan a chart
  • Create a chart
  • Move and resize a chart
  • Change the chart design
  • Change the chart format
  • Format a chart
  • Annotate and draw on a chart
  • Create a pie chart
  • Sparklines

Prerequisite: Some experience with Excel.

Excel – Data Analysis & Using Tables

  • Grouping
  • Filters
  • show only a specified data set
  • Summary options
  • Remove duplicates
  • Multi level sorting
  • Table management tools
    • Insert/Table
    • Table Ribbon
    • Automatic Filtering (Total row shows totals for the filtered data, not the whole table)
    • Add rows and columns
    • Table Style options, banded rows, Total row, etc
    • Working with basic functions & formulas (automatic fill, subtotal function)
    • Convert to Range (make sure to remove formatting first)

Prerequisite: Some experience with Excel.

Excel – Conditional Formatting

  • Use and modify built-in formatting rules
  • Create new rules
  • Format cells based on values
  • Use icon sets to indicate relative values of cells
  • Format blank cells or cells with specific text
  • Format dates relative to the current date
  • Format cells in one column based on values in another column in the same row
  • Format an entire row based on a value in one column in that row
  • Color alternate rows
  • Highlight values in one list that are not in a second list
  • Highlight values in one list that are in a second list

Prerequisite: Some experience with Excel.

Excel – Comparing Lists

  • Remove duplicates based on one column
  • Remove duplicates based on the entire row
    • Data/ Remove Duplicates
    • Advanced Filter
  • Finding uniques or duplicates among 2 different lists using conditional formatting
    Using 2 different methods:
    • Using countif with range names
    • Selecting both lists simultaneously
  • Possible additional topics: Compare Files, Data forms, Sorting

Prerequisite: Some experience with Excel.

Excel – Pivot Tables

  • Creating Pivot Tables Reports
  • Modifying Pivot Tables
  • Creating Pivot Charts
  • Insert Slicers
  • Insert Timelines

Prerequisite: Some experience with Excel.

Excel – Working with Range Names

  • Defining Range Names
    • Using Name Box
    • Create from Selection
  • The Name Manager
  • Using Range Names in formulas
    • F3 key
    • Applying to existing formulas
  • 3-D Names

Prerequisite: Some experience with Excel.

Excel – Intro to Macros and VBA

  • Running Macros
    • Macro Recorder
    • Shortcut Key
  • Creating Macros
    • Macro Recorder
    • The Visual Basic Editor
  • Personal Macro Workbook
  • Inserting a Macro Buttons
    • Object
    • Toolbar

Prerequisite: Some experience with Excel.

Excel – Intermediate Macros and VBA

  • Creating user defined functions
  • Using loop structures
  • Creating decision making code
  • Overview of debugging code

Prerequisite: Some experience with Excel macros and VBA.

Excel – Shortcuts, Tips & Tricks

  • Amazing Excel Facts
  • Customizing Excel
  • Keyboard Shortcuts
  • Worksheets
  • Charts
  • Headers/Footers
  • Formatting
  • Formulas

Prerequisite: Some experience with Excel.

Excel – Lookup Functions

  • Using the VLOOKUP statements
  • Using the HLOOKUP statements
  • Use Data Validation
  • IS Function
  • MATCH function
  • INDEX

Prerequisite: Some experience with Excel.

Google

Gmail – Getting Started

  • Screen elements
  • Create and send email
  • Reply to email
  • Edit recipients or subjects when replying
  • Save and print attachments
  • Understanding labels vs folders
  • Star important email
  • Use Importance markers
  • Archive or delete email
  • Search your inbox
  • Open your Google Calendar and events
  • Open notes in Google Keep
  • Open your to-do lists in Google Tasks

Gmail – Customize Your Inbox Appearance

  • Choose the Density (spacing) of items in your inbox
  • Use a Theme
  • Change your Inbox Type
  • Include a Reading Pane
  • Use Conversation View
  • Create and manage Signatures
  • Turn Hover Actions off or on
  • Move or hide Hangouts/Chat and Meet

Prerequisite: Some experience with Gmail.

Gmail – Customize How You Send and Receive Email

  • Undo Send
  • Schedule Send
  • Send and Archive
  • Email templates
  • Smart Compose
  • Smart Reply
  • Snooze
  • Nudges
  • Vacation responder
  • Contact Groups
  • Confidential Mode

Prerequisite: Some experience with Gmail.

Gmail – Labels and Filters

  • Understanding labels vs folders
  • Create labels
  • Search your email using labels
  • Remove and apply labels
  • Manage labels
  • Archiving using the inbox label
  • Use filters to automatically organize messages
  • Create a filter
  • Manage filters

Prerequisite: Some experience with Gmail.

Google Calendar – Getting Started

  • Create an event
  • Add guests
  • Add rooms, location, or conferencing
  • Add an event description and attachments
  • Choose an event color, calendar, and default visibility
  • Set up notifications
  • Save events
  • Duplicating an event
  • Update an existing event
  • Change event owner
  • Check guest responses
  • Delete an event
  • Restore a deleted event
  • Reply to an invitation
  • Propose a new time
  • Open notes in Google Keep

Prerequisite: Some experience with Gmail.

Google Calendar – Customization

  • Choose the Density (spacing) of Calendar
  • Choose a Color Set for your calendar
  • Change the default color for each calendar you view
  • Use different calendar views (day, week, month, year, schedule)
  • Manage general event settings
  • Set default guest permissions
  • Manage your view options
  • Set a custom view
  • Set your working hours
  • Customize individual calendars:
    • Access permissions
    • Event notifications
    • Other notifications
    • Daily email of each day’s agenda
  • Customize individual events:
    • Color
    • Notifications
    • Guest permissions

Prerequisite: Some experience with Gmail and Google Calendar

Google Calendar – Viewing and Sharing Calendars

  • Share your calendar
  • Manage access permissions for your calendar
  • View other people's calendars
  • Create additional calendars
  • Subscribe and unsubscribe to calendars of interest
  • Create a shared calendar
  • Import and export events and calendars
  • Delete a calendar
  • Copy events from one calendar to another
  • Change calendar owner

Prerequisite: Some experience with Google Calendar

Google Calendar – Out of Office, Reminders, Tasks

  • Create an Out of Office Event
  • Manage an Out of Office Event
  • Reminders vs tasks
  • Create a personal reminder
  • View reminders
  • Change a personal reminder
  • Complete or remove a personal reminder
  • Create a task
  • View tasks
  • Edit tasks
  • Creating multiple task lists

Prerequisite: Some experience with Google Calendar

Google Calendar – Using Appointment Slots

  • Appointment Slots: any time individuals with Google accounts need to schedule one-on-one appointments with someone with a work or school Google account
  • Create a calendar to use Appointment Slots (optional)
  • Create a block of time to hold the Appointment Slots
  • Customize duration, repeats, calendar (if applicable)
  • Customize description with information or links
  • Require sign-in to your own organization (optional)
  • Duplicate and edit the block of time for different times or days
  • Share the appointment calendar with people who help you manage the meetings (optional)
  • Copy link to calendar’s appointment page to send to by email or use on a webpage
  • Individuals follow that link to choose a time slot
  • See reserved slots in the block of time
  • Delete a reservation when someone cancels
  • Print list of people who reserved slots

Prerequisite: Some experience with Google Calendar

Google Charts

  • Plan a chart
  • Different chart types
  • Create a chart
  • Move and resize a chart
  • Chart editor – Setup
    • Chart type
    • Data range
    • Switch rows and columns
    • Headers and labels
  • Chart editor – Customize
    • Style
    • Titles
    • Legends, axes, gridlines
    • Colors
  • Insert existing chart into a Doc

Prerequisite: Some experience with Google Sheets.

Google Docs – Getting Started

  • Create a new Doc
  • Type a title and paragraph
  • Basics of formatting
  • Insert an image, text wrap
  • Organize into a folder
  • Download to Word
  • Upload a Word document to Google Docs
  • Share

Prerequisite: Some experience with internet browsers is helpful.

Google Docs – Formatting Documents

  • Format with fonts
  • Use the Format Painter
  • Set document margins
  • Create sections and columns
  • Insert page breaks
  • Insert page numbers
  • Add headers and footers
  • Insert and format a table
  • Insert and format images

Prerequisite: Some experience with Google Docs.

Google Docs – Navigating the Menu Options

  • Detailed investigation of what to find under each of the menu tabs in Google Docs
  • Includes a pdf (sent in advance) to follow along and take notes

Prerequisite: Some experience with Google Docs.

Google Docs – Formatting Paragraphs and Lists

  • Change line and paragraph spacing
  • Align paragraphs
  • Indent text: tab key, indent icon
  • Use the ruler to set custom indents
  • Use tabs
  • Add tab stops
  • Add bullets and numbering
  • Add borders and shading

Prerequisite: Some experience with Google Docs.

Google Sheets – Getting Started

  • Create a new Sheet
  • Basics of data entry
  • Basics of formatting
  • Basics of functions/formulas: sum, average
  • Organize into a folder
  • Download to Excel
  • Upload Excel to Google Sheets
  • Share

Prerequisite: Some experience with internet browsers is helpful.

Google Sheets – Navigating the Menu Options

  • Detailed investigation of what to find under each of the menu tabs in Google Sheets
  • Includes a pdf (sent in advance) to follow along and take notes

Prerequisite: Some experience with Google Sheets.

Google Sheets – Hiding, Protecting and Selective Sharing

  • Hiding/Unhiding Sheets
    • Who can hide/unhide sheets
    • Where to see that there are hidden sheets
  • Protecting Sheets and Cells
    • How to open the Protected Sheets & Ranges panel
    • Protect an entire sheet, a sheet except for certain cells, or a set of cells or a range in a sheet
    • Set separate permissions for protected cells for other editors
    • Allow editing but set a warning message
    • See which cells/ranges are restricted
  • Share only specific column(s) from one spreadsheet to another

Prerequisite: Some experience with Google Sheets.

Google Sheets – Conditional Formatting

  • Create rules to change text formatting or background color of cells, rows, or columns based on values
    • Numbers
    • Text
    • Dates
    • Formulas
  • Use single colors, or set a color scale
  • Highlight blank or non-blank cells
  • Apply formatting to one or more cells based on the contents of other cells
  • Highlight when the same value occurs more than once
  • Format an entire row based on the value of one of the cells in that row
  • Absolute vs relative cell references
  • Use wildcard characters to match multiple expressions
  • Delete a rule
  • Set multiple rules
    • Order of application
    • Re-ordering rules
  • Use alternating row colors

Prerequisite: Some experience with Google Sheets.

Google Docs & Sheets – Getting Started

Docs

  • Create a new Doc
  • Type a title and paragraph
  • Basics of formatting
  • Insert an image, text wrap
  • Organize into a folder
  • Download to Word
  • Upload a Word document to Google Docs
  • Share

Sheets

  • Create a new Sheet
  • Basics data entry
  • Basics of formatting
  • Basics of functions/formulas: sum, average
  • Organize into a folder
  • Download to Excel
  • Upload Excel to Google Sheets
  • Share

Prerequisite: Some experience with internet browsers is helpful.

Google Drawings – Creating Diagrams

  • Create a new Drawing in Drive (standalone)
  • Add shapes
  • Arrange and size shapes using guides
  • Use lines and connectors
  • Add text inside shapes
  • Add text boxes
  • Add Word Art
  • Insert an image from computer, web, Drive, Google Photos, URL, device camera
  • Draw free-hand, including on inserted images
  • Make large and small adjustments to object locations
  • Customize objects (color, size, border)
  • Copy objects
  • Group objects to move together
  • Insert Diagram templates
  • Customize Diagrams
  • Create a new Drawing in a Doc, Sheet or Slide
  • Insert an existing Drawing into a Doc
  • Copy and paste an existing Drawing into a Slide
  • Download a standalone Drawing from Drive
  • Download a Drawing from a Slide

Prerequisite: Some experience with Google Drive.

G Suite – Collaborating and Using Version History

  • Available in Docs, Sheets and Slides unless noted
  • Email existing collaborators from within a file
  • Chat in real time (must be enabled by district Google Admins)
  • Use Suggesting mode (Docs only)
  • Comment
  • Assign a Comment to a person
  • Version History
  • Cell History in Sheets (does not include format history)
  • Compare changes between two Docs

Prerequisite: Experience with Google Drive, and Docs and/or Sheets.

Google Slides

  • Screen elements
  • Create new presentation
  • Introduce Slide layouts
  • Edit slides
  • Add slides
  • Delete slides
  • Move slides
  • Speaker notes
  • Designs, custom backgrounds
  • Print options
  • View options, view presentation
  • Add transitions and text animations
  • Presenter view (if time allows)

Prerequisite: Some experience with with internet browsers is helpful.

Google Drive and G Suite Overview

  • What is Google Drive?
  • Compare with MS Windows & Office
  • Screen elements
    • Drive
    • New
    • Star
    • Recent
    • Preview
    • Trash
    • Views: Grid, List
    • Shared with me
    • Shared Drives
  • Create a document
    • Point out differences with MS Word: name file, auto save, star, move to folder, comments, suggest mode, make a copy
  • Create a folder
  • Organize files
  • Download options
  • Upload
  • Share
    • Version history

Prerequisite: Some experience with internet browsers is helpful.

Google Drive – “Shared with me” and “Shared drives”

Sharing Files and Folders

  • Share file or folder with a link
  • Share file or folder with specific individuals
  • Stop sharing

Shared with me

  • Organize files in Shared with me
  • Shortcuts to Drive

Shared Drives

  • Create a Shared Drive
  • Add members and set access levels
  • Change member access levels
  • Remove members
  • Create a new folder in a Shared Drive
  • Move files into a Shared Drive
  • Delete and restore files from Trash
  • Delete a Shared Drive

Prerequisite: Some experience with Google Drive.

Google Forms – Getting Started

  • Demo filling out a Google Form which displays each type of question available in forms
  • Create a new form
  • Create questions using the different question types
  • Look at question options such as: add Title and Description, add Image, add Section
  • Look at Settings options
  • Preview the Form
  • Send the form to be filled out vs Sharing the form with collaborators
  • Look at Responses Summary and Responses Spreadsheet

Prerequisite: Some experience with Google Sheets and internet browsers is helpful.

Google Forms – Branching into Sections

  • Short review of Forms
  • Show which question types allow the “Go to section based on answer” option
  • Insert sections
  • Navigate each potential answer to the related section
  • From each section
    • Insert return to main list option
    • Insert submit option
  • Preview the form
  • Test the form
  • Look at responses

Prerequisite: Some experience with Google Forms.

Google Forms – Quizzes

  • Create a Quiz
  • Look at Settings and Options
  • Set up Questions, Answer Keys, and Feedback
  • Look at Responses from students
  • Grade Responses

Prerequisite: Some experience with Google Forms.

Google Search Tips

  • Google.com or the browser address field (Chrome and Firefox)
  • Optional: Set your default search engine to Google
  • Start with the basics
  • Choose words carefully
  • Don’t worry about the little things (spelling and capitalization)
  • Find quick answers
  • Punctuation & symbols
  • Search operators
  • Filter your search results
  • Advanced Search
  • Find free-to-use images
  • Turn SafeSearch on or off
  • Delete searches & browsing activity
  • Google Easter Eggs

Prerequisite: Some experience with internet browsers.

Publications

MS Publisher – Getting Started

  • Creating a publication using a template
  • Adding and deleting pages
  • Inserting text from other files
  • Inserting graphics
  • Connecting text frames and adding “continued” notes
  • Inserting page numbers
  • Using Building Blocks such as advertisements and calendars
  • Working with the master pages

Mail

Outlook – Getting Started

  • Communicate with email
  • Use email address
  • Create and send emails
  • Understand folders
  • Receive and reply to emails
  • Send Attachments
  • Forward and Organize emails

Mail Merge

Mail Merge in G Suite Using autoCrat

  • Explain mail merge process
  • Explain autoCrat is an add-on for Google Sheets
  • Show how to install add-on
  • Introduce the Doc and Sheet that will be used
  • Set up folder for merged Docs to go into
  • Step through autoCrat explaining each step (some steps are optional)
  • Save the job, show run, edit, delete options
  • Have a student account open to see how the document is received via email
  • Show some of the optional steps if time permits

Prerequisite: Some experience with Google Docs and Sheets.

autoCrat – using Form Triggers and Dynamic Folders

  • Short review on mail merge using autoCrat

Form Triggers:

Using the example of a simple Field Trip sign up form:

  • Short review on forms
  • Build a Form and Responses Sheet
  • Create the Doc that will be used as a confirmation letter that is sent out as people sign up for Field Trips
  • Create a folder for the merged Docs to go into
  • From the Responses Sheet: Step through autoCrat including the optional Form Trigger steps
  • Have a student account open to see how the confirmation letter is received when that student account signs up for a Field Trip using the Form

Dynamic Folders:

Using the example of a teacher using autoCrat to send a document to each individual student’s folder that the teacher shares with them:

  • Create as many folders as there are individuals in your data Sheet
  • Collect each folder’s ID
  • Place each folder’s ID in an ID column in the data Sheet according to who the folder belongs to
  • Create the Doc that will be used as a letter to each student
  • Create a folder for (your copy) of the merged Docs to go into
  • From your data Sheet: Step through autoCrat including the optional Dynamic Folders steps
  • Look in each student’s folder to see that each one has one letter

Prerequisite: Some experience with autoCrat is helpful.

Mail Merge Using Microsoft Office

  • Explain the merge process
  • Use the Mail Merge task pane and the MAILINGS tab on the ribbon
  • Use a letter template as the main document for a mail merge
  • Create and edit a data source
  • Insert merge fields in a main document
  • Use an IF field in a main document
  • Merge form letters
  • Select records to merge
  • Sort data records
  • Address and print mailing labels and envelopes
  • Change page orientation
  • Merge all data records to a directory

Prerequisite: Some experience with Word.

Operating systems

Windows & File Management

  • Understand files and folders
  • Create and save a file
  • Explore the files and folders on your computer
  • Change file and folder views
  • Open, edit, and save files
  • Copy files
  • Move and rename files
  • Search for files and folders
  • Delete and restore files

PowerPoint

PowerPoint – Getting Started

  • Define presentation software
  • Plan an effective presentation
  • Examine the PowerPoint window
  • Use templates
  • Enter slide text
  • Add a new slide
  • Apply a design theme
  • Compare presentation views
  • Inserting Speaker notes
  • Print a PowerPoint presentation

PowerPoint – Modifying a Presentation

  • Enter text in Outline view
  • Format text
  • Convert text to SmartArt
  • Insert and modify shapes
  • Rearrange and merge shapes
  • Edit and duplicate shapes
  • Align and group objects
  • Add slide footers

Prerequisite: Some experience with PowerPoint.

PowerPoint – Inserting Objects into Presentation

  • Insert text from Microsoft word
  • Insert and style a picture
  • Insert a text box
  • Insert a chart
  • Enter and edit chart data
  • Insert slides from other presentations
  • Insert a table
  • Insert and format WordArt

Prerequisite: Some experience with PowerPoint.

PowerPoint – Adding Animations and Finishing a Presentation

  • Modify masters
  • Customize the background and theme
  • Use slide show commands
  • Set slide transitions and timings
  • Animate objects
  • Use proofing and language tools
  • Insert audio files
    • Time the music for when to start and stop
  • Insert video
    • Trim the video to play to play a specific portion
    • Play the video full screen
  • Pack up your fonts, sound files, and movies to play anywhere

Prerequisite: Some experience with PowerPoint.

PowerPoint - Links and Action Buttons

Jeopardy Game

  • Create Slides
    • Add Action button
    • Add Home button
    • Link to appropriate slides
  • Make Slide duplicates
  • Create rectangles for the points in the game
  • Use the Selection pane to navigate the rectangles and name them strategically as this will be important for triggers
  • Use triggered animation to disable used squares

Prerequisite: Some experience with PowerPoint.

Word

Word – Getting Started

  • Explore the Word window
  • Ribbon
  • Start a document
  • Save a document
  • Select text
  • Format text using the Mini toolbar
  • Use a document template
  • Navigate a document

Word – Editing Documents

  • Cut and paste text
  • Copy and paste text
  • Use the Office clipboard
  • Find and Replace text
  • Check spelling and grammar
  • Research information
  • Add hyperlinks
  • Work with document properties

Prerequisite: Some experience with Word.

Word – Formatting Text, Paragraphs and Lists

  • Format with fonts
  • Use the Format Painter
  • Change line and paragraph spacing
  • Align paragraphs
  • Work with tabs
  • Work with indents
  • Add bullets and numbering
  • Add borders and shading
  • Insert online pictures

Prerequisite: Some experience with Word.

Word – Formatting Documents

  • Set Document margin
  • Create section and columns
  • Insert page breaks
  • Insert page numbers
  • Add headers and footers
  • Insert a table
  • Add footnotes and endnotes
  • Insert citations
  • Manage sources and create a bibliography

Prerequisite: Some experience with Word.

Word – Shortcuts, Tips & Tricks

  • Customizing Word
  • Keyboard Shortcuts
  • Fonts
  • Graphics
  • Tables
  • Headers/Footers
  • Formatting
  • Page Layout

Prerequisite: Some experience with Word.

Word – Graphics

  • Add, arrange and format text boxes
  • Insert clip art and pictures
  • Draw AutoShapes
  • Text wrapping, aligning and grouping objects
  • Flipping and rotating
  • Layering, shadows and 3-D
  • WordArt

Prerequisite: Some experience with Word.

Word – Forms

  • Display the Developer tab on the ribbon
  • Show Legacy Form tools
  • Review Word Templates
  • Create the document that will be the form
  • Add Controls
  • Set Control properties
  • Show how to protect the entire Form, or parts of the Form
  • Save as a Word Template
  • Fill out the Form

Prerequisite: Some experience with Word.

Word – Styles

  • Understand how Styles are used for navigation and Design elements
  • Use Styles
  • Modify Styles
  • Create Styles
  • Delete Styles

Prerequisite: Some experience with Word.

Word – Tables

  • Creating tables
  • Adjusting table size
  • Adding, deleting, and moving rows and columns
  • Merging and splitting cells
  • Working with borders and shading
  • Sorting

Prerequisite: Some experience with Word.

Word - Long Documents, Manuals and Handbooks

How to work with lengthy documents in Word

  • Work with page numbering
  • Document sections
  • Table of Contents
  • Indexes
  • Styles
  • Tables that span multiple pages
  • Bookmarks
  • Cross-references

Prerequisite: Some experience with Word.

Zoom

Zoom – Attendee Beginner Tips & Tricks

  • Download or join from your browser?
  • Participant List
  • Edit your name in the Participant list
  • Microphone
  • Camera
  • Chat (Public or Private)
  • Full screen/Exit full screen
  • Share your screen (start and stop)
  • Leave the meeting

Templates

MS Office Templates

  • Define a template
  • Use existing templates in Word and Excel
  • Save our own document/spreadsheet as a template
  • Edit/delete a template

Prerequisite: Some experience with Word and Excel.

Google Docs and Sheets Templates

  • Introduce the concept of templates
  • Show premade templates
  • Start from an ordinary Google Doc that is a good candidate for a template: letterhead, memo, fax sheet, etc
  • Show where to save templates
  • Use a template
  • Edit a template
  • Delete a template

Prerequisite: Some experience with Docs and Sheets.