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.

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.

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.

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

An exciting new class format open only to OPAL members: 15 minute classes, to fit into your busy days. Demonstration classes are offered on a very focused topic.

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  – MAKE SPREADSHEETS WORK FOR YOU

• Common issues 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
• Test 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
• Modifying Pivot Tables
• Creating Pivot Charts
• Insert Slicers
• Insert Timelines

Prerequisite: Some experience with Excel.

EXCEL - GETTING STARTED WITH POWERPIVOT

With PowerPivot, Excel is able to create a pivot table from multiple tables.

• A quick review of pivot tables
• Present the case study of setting up data in multiple tables
• Understand the concept and use of key field vs foreign field
• Create table relationships
• Create a pivot table based on more than one table

Prerequisite: Some experience with Excel Pivot Tables.

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.

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

• Choose the Density (spacing) of items in your inbox
• Use a Theme
• Change your Inbox Type for more efficient email management
• Include a Reading Pane
• Use Conversation View
• Create and manage Signatures
• Turn Hover Actions off or on
• Move or hide 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/SCHEDULES

• Appointment Slots vs Appointment Schedules
• Need a work or school Google account to create
• Anyone can schedule an appointment with you (Slots requires a Google account)
• Slots (optional): Create a dedicated calendar that others could help manage
• Schedules: Updates from and to your Google Calendar
• Create a block of time to split into Slots/Schedule of available appointments
• Customize duration, repeats, description (including links), (optional) Slots calendar
• (Optional) require people booking to sign into your organization (Slots) or verify email for non-Google accounts (Schedules)
• Get link to send in email or embed 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 – RESTRICTING PARTS OF A SHEET

• 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 SHEETS - sORT & fILTER

• Use different methods for sorting data
• Sort by color (this will touch on Conditional Formatting)
• Filter data using: data points, text filters, date filters, number filters, and formulas
• Use Filter Views: create, save, share, and delete Filter Views

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.

GOOGLE WORKSPACE – 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 GOOGLE WORKSPACE 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.

GOOGLE SITES – CREATE YOUR OWN WEBSITE

• Requires a Google account
• Possible uses: plan and advertise meetings and activities, collaborate on a team project, share information to a limited number of users or to the public
• Look at some simple Google Sites
• Create and name a new Site
• Customize layout, background, header and theme
• Set up site navigation
• Add and edit content
• Share and collaborate
• Preview, publish and unpublish the site
• Search in a site

Prerequisite: Experience with Google Drive and Google Workspace

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 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.

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 – 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 A 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.

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

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.

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 – basics of hosting a meeting

• Settings
• Using the Waiting Room
• Co-hosts
• The Participant List
• Chat (Public or Private)
• Full screen/Exit full screen
• What to do about participant audio issues
• Share your screen (start and stop)
• Participant Screen Sharing
• Ending the meeting
• Finding the chat log after the meeting

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