CoHEsion summit 2019 - st Louis General Information

Understanding CPOS: Courses (that Count) in Program of Study 8:30am – noon. 

Presented by Jessica Ashbrook, Lansing Community College. 

Come to this session for a functional overview of CPOS and how Lansing Community College implemented. A review of student and financial aid module setups, training and testing strategies, supporting Argos reports and lessons learned will help attendees gain a better understanding of CPOS and the path toward implementation.

Sizing Your Cloud Workload for Banner 8:30am – noon. 

Presented by David Kent Consulting

This technical workshop will help database and system administrators size their cloud tenants for Banner 9 and will introduce you to using cloud automation scripting. In part 1, we will dive into the practices we used at the University of the Virgin Islands to correctly size tenant compute and storage workload capacity prior to migrating their Banner system to the cloud. We will also cover how we made workload adjustments after the migration was completed to further improve performance post migration. Learners will gain the know-how needed to avoid common mistakes when moving applications to the cloud. In part 2, we will dive into using cloud automation scripting as a tool to drive down cloud costs by writing a script that automatically powers up and shuts down a Banner non-production system. We will conclude with a demonstration of how we dynamically add and remove nodes to a mid-tier cluster.  

Managing Change in Technology as a Functional User: It Only Hurts for a Little While!  1:00pm – 4:30pm.

Presented by Bobbie Brown, Texas Tech University

With so many technological changes charging at functional users, it is hard to manage those changes for employees, other users, and customers. Sometimes hard decisions must be made, downtime in services must be managed, and frustration in those who surround us become overwhelming. This session will focus on various real examples of the many technology changes we all face and provide suggestions to accommodate, manage, and maintain those changes. And keep your sanity and good reputation! Come prepared to take notes and have a great discussion with peers in the same boat!

Project Management

Presented by Joe Belnap, Utah Valley University. 

A project is a unique effort with specific deliverables, a budget, and a definite beginning and end. Approximately 80% of projects either are canceled prior to completion or fail to meet the expected objectives upon implementation. While some projects fail for completely legitimate unforeseen circumstances, most fail from inadequate or incomplete project management. Project management is a discipline; a skill that must be learned before undertaking a project. Technical knowledge and native intelligence are not enough to ensure success. Projects must be defined, planned, and tracked with precision and diligence. Applying this methodology greatly improves the ability of completing projects on time and within budget. This course presents a complete, systematic process that will make the difference between success and failure. All aspects of Project Management are covered:

• Introduction of basic project management concepts and techniques
• Project Definition and Organization
• Project Planning
• Tracking and Managing the Project.

Evisions - Argos: Building a DataBlock and Report from the Ground Up

Presented by Evisions

Join the Evisions team and spend a day walking through the building of a DataBlock and Report from the ground up! This hands-on experience will cover: 

• How to create DataBlock and report specification (as well as best practices around combining existing DataBlocks and reports)
• Creating a DataBlock. We’ll also walk through many of Argos’s advance features and functionalities (e.g., using inline views, charting, and drill-through capabilities)
• Creating a crosstab report (New report type that was part of the v6.2 release!)

At the end of the day, participants will walk away with a greater understanding of Argos, along with a fully functioning baseline DataBlock. 

     Building a DataBlock Requirements: Argos DataBlock Designer experience is required to participate in the hands-on 

     portion. If you are new to Argos, and do not have DataBlock Designer experience, please feel free to sit in and follow 

     along. 

Page Builder Code Camp

Strata Information Group

Join CoHEsion and Strata Information Group for a Banner 9 Page Builder Code Camp! This session will allow you to get some experience working hands-on with Page Builder by introducing the tool, providing sample exercise, and offering help as needed. Or if you already have Page Builder experience, come work on a current project where you can get feedback and collaborate with others. This will not be a formal instructor-led training, but rather each participant can move at their own pace and work with each other to learn the tool, with a facilitator available to help if anyone gets stuck. 

     Page Builder Code Camp Requirements: You will use your college’s Page Builder instance during the session and must 

     bring your own laptop computer. Page Builder is part of Banner Extensibility, and we strongly recommend using version 

     9.2 or higher. You will be responsible for testing and ensuring your access is properly configured and available during the  

     Code Camp, including VPN, login/permissions for Banner Extensibility, and database access as needed for grants, 

     compiling code, etc. Information on how to test and verify this access will be provided ahead of time, and Wi-Fi will be 

     provided in the conference center. We will not be able to help troubleshoot application installation problems or login 

     problems on the day of the event.

Oracle Database Performance Tuning

Presented by Sean Leahy, Texas A&M University. 

Acceptable performance of Ellucian Banner applications largely depends on an Oracle database that is performing at an acceptable level.  Tuning the Oracle database to support the workload of Banner applications and custom processes is essential.  This full day session will review the Oracle performance tuning method.  We will review how to tune the database proactively and reactively using Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH), and Automatic Workload Repository (AWR) snapshots. We will focus on memory usage issues and memory structures, concurrency issues in the form of locks or waits, and database configuration issues including incorrect sizing of log files.  We will also review SQL Tuning including object statistics, explain plans, and how to tune and optimize SQL statements using the SQL Tuning Advisor and SQL Access Advisor.  We will look at using SQL profiles and SQL Plan baselines to prevent regression. The session will be using Oracle Enterprise Manager Cloud Control (Cloud Control) and Oracle supplied PL/SQL packages using SQL*Plus.