Admin

Video Support Library

Aeries Support Library  MS Office Video Library SBCUSD Video Library

Introduction
Logging into the Web Version
Overview of the Home Page
Adding and Editing Tasks, Calendar, and Resource Center
Overview of the Navigation Tree
Searching for an Individual Student
Looking Up Student Information
View All Reports
Favorites

Scheduling Using the New Classes Page
Overview
Changing a Schedule
Adding Classes

Scheduling - SMS Board
Overview and Settings
Managing Sections
SMS Builder
Scheduling Students

Student Scheduling

Intro & Dashboard
Course Request Packets
Mass Changes or Add Courses
Reports Related to Student Course Requests
Backup and Restore
Creating Sections in SMS
Copying Sections in the SMS
Reports Related to Building SMS
Mass Scheduling Students
Scheduling Individual Students
Student Schedule Conflicts
Reports Related to Student Scheduling
Printing Locator Cards and Class Rosters

Gradebook
Dashboard and Navigation
Mass Add Gradebook
Copy Gradebook
Add Gradebook
Gradebook Terms
Edit Gradebook
Mass Add Student
Linking Gradebooks
Gradebook Options
Categories for Gradebook
Final Marks
Narrative Grades
Rules
Backups
Restore
Add/Drop Student
Add Assignment
Push Assignments
Import Assignments
Manage Students
Scores by Class
Entering Scores by Standard
Scores By Student
Scores by Assignment
Reports for Gradebook
Load From Gradebook - Secondary

Common Gradebook Tasks
Mass Add Scores
Scoring Standards
Rubric Grading
0 Point Assignments
Override Not Applicable Scores
Quick Data Entry


Queries
Aeries Query Overview
Fields and Functions
Sorting
Multiple Sorting
Simple Conditions
Multiple Conditions
Multiple Conditions
Math Functions

Excel
Create Your First Workbook
Add Numbers
Basic Math
Understand and Use Cell References
Freeze Panes

Sort and Filter Data
Use Autofill and Flash Fill
Create A Chart
Add or Subtract Time
Average a Group of Numbers
Use Conditional Formatting
Intermediate Conditional Formatting
VLOOKUP: When and How to Use It
Create A Pivottable and Analyze Your Data
Advanced IF Functions
Array Formulas
Work with Macros
Create and Manage Drop-Down Lists
Password Protect Workbooks and Worksheets
Insert Headers and Footers
Print Worksheets and Workbooks

Outlook
Email Basics
Fonts, Hyperlinks, And Spell Check

Add and Use Contacts
Calendar Basics
Create and Use Personal Folders (Outlook Data Files)
Send and Open Attachments
The ins and Outs of Bcc
Group and View Email in Your Inbox
Recall and Replace Sent Messages
Send Automatic Replies When You’re Out of the Office
Use Instant Search to Find Calendar Items
Use Instant Search to Find Contacts
Use Instant Search to Find Messages and Text
Add Holidays to Your Calendar
Control Spam
Create or Delete a Search Folder
Import and Export Vcards to Outlook Contacts
Make Your Job Easier with Outlook
Reach Out with Contact Groups (Distribution Lists)
Send or Delete an Email Stuck in Your Outbox
Take Calendars to The Next Level
Templates and Stationery
Track Email with Read Receipts
Use Voting Buttons to Create or Respond to Polls
Archive or Back Up Your Mailbox
Password Protect Your Mailbox
Use Rules to Manage Your Email

PowerPoint
Create Your First Presentation
Highlight Text and Change Fonts
Add Bullets to Text
Apply and Change a Theme
Backgrounds
Apply Transitions Between Slides
Crop a Picture to Fit a Shape
Group Shapes or Pictures
Working with Watermarks
Work with Handout Masters
Add a Sound Effect to a Transition
Add Headers and Footers to a Presentation
Add Sound Effects to an Animation
Animate Pictures, Text, And Other Objects
Create a Flow Chart
Create an Org Chart
Create a Template from A Presentation
Design Motion Paths
Insert a Bar Chart
Insert a Line Chart
Insert a Pie Chart
Insert a Video from Your PC
Insert Music and Time It to Your Slides
Rehearse Timings for a Slide Show
Trigger an Animation Effect
Use Slide Masters to Customize a Presentation
Create Speaker Notes
Print Slides, Notes, or Handouts
Use Presenter View

Word
Create your First Document
Line Spacing
Spell-check Basics
Landscape and Portrait Orientation
Custom Margins
Mirror Margins
Track Changes
Work with Word Counts
Create Labels
Resumes
Introduction to Tables of Contents
Intermediate Tables of Contents
Advanced Tables of Contents
Using Styles
Working with Watermarks
Collapsible Headings
Mail Merge
Intermediate Mail Merge
Advanced Mail Merge
Creating Footnotes
Creating an MLA Paper with Citations and a Bibliography

Adobe
Basics of Creating a Fillable PDF Form
Fillable PDF Forms - Field Properties
Exporting PDF Form Data to Excel

Aeries
Entering Notice of Suspension
Entering Office Referral
Query for No Emergency Contact Number
Query for Student with No Photo
Uploading Individual Student Photos
Parent Portal - Student Data Confirmation

Asana
Anatomy of Projects and Tasks
Boards
Connecting Your Work
Conversations
Custom Fields
Dashboards
Integrations
Add Tasks to Multiple Projects
My Inbox
My Tasks
Project Views
Search Views
Shortcuts
Understanding Teams

Cybersecurity
Malware Awareness
Email Phishing
Internet Browsing Safety
Internet Scams
Social Engineering
Strong Passwords

Financial 2000
Purchasing Overview

Google
Forms - Introduction to Google Forms
Forms - Capturing Form Data & Publishing
Forms - Conditional Form Response
Drive - Introduction to Google Drive
Drive - Sharing Files with My Drive
Drive - Group Collaboration Team Drives

Office 365
OneDrive Introduction
OneDrive - Sharing Your OneDrive Files
Group Project Collaboration with MS Teams
Embedding Smartsheets into Your MS Teams

SAP
Creating Plant Maintenance Notifications
Creating a PM Notification 41
Creating a PMN 41 Equipment Transfer
Search for a Maintenance Notification
Time Entry Administrator Settings

Smartsheet
How to Set Up a Sheet
Creating and Defining Columns
Sharing Sheets
Attachments and File Sharing
Using Comments
Track and View Sheet Activity
Gain Visibility into Sheet Activity
Conditional Formatting
Update Requests
Alerts and Actions
Reminders
Update Request in Action
Approval Request in Action
Using Calendar View
Integrate Sheet Calendar with other External Calendars
Work more Visually with Card View
Using Card View
Using Gantt View
Gantt Chart with Dependencies
Using Forms to Collect Project Data
Forms and Process Automation

777 North F Street, San Bernardino, CA 92410 | Phone: (909) 381-1100 | Fax:

Website by SchoolMessenger Presence. © 2019 West Corporation. All rights reserved.