Per-Seat Remote Training

Audience Requirements:

• Strong internet connection
• Dual monitors
• Headset (for better audio and interaction)
• Once registered, print out all materials sent by trainer

Does NOT Cover:
This class will not teach analytical reporting (OLAP cubes and charts.)

DataBlock Designer Training
Days 1 – 2
4 hrs each day, 12:00-4:00pm ET

In this hands-on training, we will show the basics of building a DataBlock dashboard and report query.

Topics covered:

• DataBlock creation
• Dashboard variables
• Writing SQL using the Visual Designer
• Using and updating the Data Dictionary
• Object level security
• Scheduling reports
• Library of Objects

Report Writer Training
Day 3
4 hours, 12:00-4:00pm ET

In this hands-on training, we will show the attendees how to build and modify CSV, Extract, Crosstab, and
Banded reports.

Topics Covered:

• Creating each report type (CSV, Extract, Banded)
• Expressions
• Sorting & filtering
• Library of Objects
• Scheduling Reports

Audience Requirements:
Intermediate knowledge of Banner, and an understanding of query logic or basic SQL.

Attendees will also need:

• Strong internet connection
• Dual monitors
• Headset (for better audio and interaction)
• Once registered, print out all materials sent by trainer

Does NOT Cover:
This class will not teach creation of Extract, Banded, or Cross-tab reports.

Argos DataBlock Designer Training
Days 1 – 3
4 hrs each day, 12:00-4:00pm ET

Topics covered:

• DataBlock creation
• Dashboard variables
• Report query
• OLAP cube
• Dashboards with multiple forms
• Drill through charts
• Using the Visual Designer with subqueries, functions, and unions
• Security
• Object level security
• Report query field level security
• Scheduling reports
• Library of Objects & templates
• Using and updating the Data Dictionary
• Support Resources

Audience Requirements:
Intermediate users who use pre-built DataBlocks to build a variety of reports. These users should be comfortable learning new software tools and basic report creation.

Attendees will also need:

• Strong internet connection
• Dual monitors
• Headset (for better audio and interaction)
• Once registered, print out all materials sent by trainer

Does NOT Cover:
Creation of DataBlocks.

Argos Report Writer Training
Days 1 – 3
4 hrs each day, 12:00-4:00pm ET

Topics covered:

• Creating each report type (CSV, Extract, Banded, Crosstab)
• Expressions
• Sorting & filtering
• Grouping in Banded and Extract reports
• Library of Objects and templates
• Using Datasets in Banded reports

Audience
Employees who are new to the DataBlock Designer role and who do not have much experience in writing SQL queries.

Audience Requirements:
Completed Argos Advanced – DataBlock Designer training (or have similar familiarity with the tool).

Little to no SQL experience required.

Attendees will also need:

• Strong internet connection
• Dual monitors
• Headset (for better audio and interaction)
• Once registered, print out all materials sent by trainer

SQL for Argos (Part 1) Training
Days 1 – 3
4 hrs each day, 12:00-4:00pm ET

Topics covered:

• Database concepts
• SELECT, FROM, WHERE, ORDER BY
• Alias and Data Dictionary
• Joins: inner, outer right, outer left
• Call an Oracle function in the SELECT and WHERE clause: upper, to_date, to_char, string, sysdate, between
• Call a Banner function in the SELECT and WHERE clause
• Use the Object Source DataBlock to find a function and use it correctly
• Identify when to use a case statement
• Case statements
• Use a column number in the ORDER BY clause
• Group operations

Audience
Employees who are new to the DataBlock Designer role and who do not have much experience in writing SQL queries.

Audience Requirements:
Completed Argos Advanced – DataBlock Designer training (or have similar familiarity with the tool).

Completed SQL for Argos (Part 1) training.

Little to no SQL experience required.

Attendees will also need:

• Strong internet connection
• Dual monitors
• Headset (for better audio and interaction)
• Once registered, print out all materials sent by trainer

SQL for Argos (Part 2) Training
Days 1 – 3
4 hrs each day, 12:00-4:00pm ET

Topics covered:

• Unions
• Having
• Datasets in Banded and Extract reports
• Multiple data sources
• Dashboard navigation techniques
• Charting
• OLAP
• Subqueries
• Subqueries with in, not in, exist, not exist
• WITH clause

Prerequisites
Intermediate knowledge of Banner or Colleague, and an understanding of query logic or basic SQL.

Attendees will also need:

• Strong internet connection
• Dual monitors
• Headset (for better audio and interaction)
• Print out all materials sent by trainer (post-registration)

FormFusion Training
Days 1-2
4 hrs each day, 12:00-4:00pm ET

FormFusion Training – Introduction

Day 1 (4 hrs., 12:00-4:00pm ET)

• FormFusion Application Introduction
• User Interface & Navigation
• Processes and Print Parameters
• MapForm Template Component
• MapForm Properties and Field Mapping (Floating & Offset Fields)
• Basic Exercise (PO Template)
• FormStamp Template Component
• FormDirector Template Component
• Directors: Print, Email, Imaging, Script, DocuSign

FormFusion Training – Advanced Topics

Day 2 (4 hrs., 12:00-4:00pm ET)

• Continuation of any topics overflowed from Day 1
• CaptureForm Template Component
• CaptureForm Variables and Queries
• Template Copy (FormStamp & FormDirector)
• Additional Form Options
• Conditional Logic of Object, Form and Output
• Basic Template Design Exercise (Transcript or Student Bill Template)
• Test Print Template Option
• Additional Material (if there is remaining training time)
• Template Security Configuration
• FormFusion Troubleshooting Process Deep Dive
• Comprehensive FormFusion Support Options Overview

Audience
Employees who are new to the MAPS Administrator role or need a refresher.

Attendees will also need:

• Strong internet connection
• Dual monitors
• Headset (for better audio and interaction)
• Once registered, print out all materials sent by trainer

MAPS Admin Training
Days 1 – 3
4 hrs each day, 12:00-4:00pm ET

Topics covered:

• Data source connections
• Connections to MAPS and Argos internal databases
• LDAP connection setup for users/groups from Active Directory
• API configurations
• Email server connection
• FTP server connection
• Installation of Argos Data Dictionary
• Installation and setup of Windows printers
• Setup of Users/Groups
• SSL setup
• API security
• Database (ADO) security
• Log files and audit setup
• Backups
• Universal Launcher