Video Support Library

Aeries Support Library  MS Office Video Library SBCUSD Video Library

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

Scheduling Using the New Classes Page
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

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
Upload Grades from Gradebook
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

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

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

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

Create Your First Presentation
Highlight Text and Change Fonts
Add Bullets to Text
Apply and Change a Theme
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

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

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

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

Creating and Approving Agenda Items

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

Financial 2000
Purchasing Overview

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
Managing your Google Groups

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

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

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
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. © 2022 Intrado Corporation. All rights reserved.