Lets Talk TechieNot! Edie Miller Project and Application Support - - PowerPoint PPT Presentation

let s talk techie not edie miller project and application
SMART_READER_LITE
LIVE PREVIEW

Lets Talk TechieNot! Edie Miller Project and Application Support - - PowerPoint PPT Presentation

RMUG 2014 Laramie County Community College Lets Talk TechieNot! Edie Miller Project and Application Support Manager Laramie County Community College 1 Housekeeping Laramie County Community College Please turn off all cell phones


slide-1
SLIDE 1

RMUG 2014 Laramie County Community College

Let’s Talk Techie…Not! Edie Miller Project and Application Support Manager Laramie County Community College

1

slide-2
SLIDE 2

RMUG 2014 Laramie County Community College

  • Please turn off all cell phones during this

presentation

  • If you must leave this session early, please do

so as discreetly as possible

  • Please avoid side conversations during the

session Thank you for your cooperation! Housekeeping

2

slide-3
SLIDE 3

RMUG 2014 Laramie County Community College

  • Communication, the Art of Understanding
  • The Administrative Computer System
  • Terminology
  • Terms Associated With the Computer System
  • Terms Associated With the Database
  • Terms Associated With Colleague
  • Data Integrity Tips
  • Questions and Suggestions

Agenda

3

slide-4
SLIDE 4

RMUG 2014 Laramie County Community College

Communication, the Art of Understanding

4

Different Audiences = Different Perspectives

slide-5
SLIDE 5

RMUG 2014 Laramie County Community College

A Computer System

5

slide-6
SLIDE 6

RMUG 2014 Laramie County Community College

The Ellucian Bed Analogy

6

Colleague Reporting Operating Analytics (CROA) Colleague Cisco Platform SQL Database Windows Operating System

slide-7
SLIDE 7

RMUG 2014 Laramie County Community College

Terms Associated With the Computer System

7

  • Ellucian
  • Name of the software vendor – aka Datatel
  • Colleague
  • Name of the administrative software
  • SQL Database
  • Name of the relational database
  • Cisco Platform
  • Name of the computer hardware (varies)
  • Windows Operating System
  • Name of the operating system
  • Colleague Reporting Operating Analytics (CROA)
  • Reporting tool to create Colleague reports and

queries

slide-8
SLIDE 8

RMUG 2014 Laramie County Community College

Ellucian

8

“Ellucian helps education institutions thrive in an open and dynamic world. We deliver a broad portfolio of technology solutions, developed in collaboration with a global education community, and provide strategic guidance to help education institutions of all kinds navigate change, achieve greater transparency, and drive efficiencies. More than 2,400 institutions in 40 countries around the world look to Ellucian for the ideas and insights that will move education forward, helping people everywhere discover their futures through learning.”

slide-9
SLIDE 9

RMUG 2014 Laramie County Community College

Listeners

9

Listeners are a separate process that runs on the database server. It receives incoming client connection requests and manages the traffic of these requests to the database server.

slide-10
SLIDE 10

RMUG 2014 Laramie County Community College

SQL Database

10

SQL (pronounced see-qwell) is an acronym for Structured Query Language SQL is a structured programming language used to search, sort, and extract data within database applications on computers.

slide-11
SLIDE 11

RMUG 2014 Laramie County Community College

Operating System

11

An operating system (OS) is a collection of software that manages computer hardware resources and provides common services for programs. The operating system is the system that runs the

  • computer. Application programs, like Colleague require

an operating system to function. The most well known operating system is Windows.

slide-12
SLIDE 12

RMUG 2014 Laramie County Community College

Database

12

A database is like a house for the data on a computer. A relational database is a database that has a collection of tables of data items. Data in a single table represents a relation.

slide-13
SLIDE 13

RMUG 2014 Laramie County Community College

Operational Data Store - ODS

13

ODS a separate repository of data from one or more source transactional systems. Level of detail is the same as the transactional systems. Data is organized for reporting needs rather than transactional needs. A snapshot of data captured at a given point in time which is updated on a regular interval.

slide-14
SLIDE 14

RMUG 2014 Laramie County Community College

14

DataOrchestrator ODS Database

ST HR FA CF

CORE

Web Intelligence & Dashboards CA

Defines data elements from Colleague to extract for reporting Refreshed daily from Colleague End user interface (View, create, modify, and schedule reports) Hides complexity of underlying ODS structure; provides simple list of data fields for reporting

slide-15
SLIDE 15

RMUG 2014 Laramie County Community College

Universe

15

Universe is used to capture elements of the database as an object so these objects can be selected by the user to use in a variety of ways. The universe does not contain data. It contains pointers to the data.

slide-16
SLIDE 16

RMUG 2014 Laramie County Community College

Behind the Scenes of the Universe

16

slide-17
SLIDE 17

RMUG 2014 Laramie County Community College

Behind the Scenes of the Universe

17

slide-18
SLIDE 18

RMUG 2014 Laramie County Community College

Users View of the Universe

18

slide-19
SLIDE 19

RMUG 2014 Laramie County Community College

Colleague Reporting Operating Analytics

19

CROA is a reporting tool used to generate query reports from the Operational Data Store (ODS).

slide-20
SLIDE 20

RMUG 2014 Laramie County Community College

Mnemonics

20

Mnemonics are simple menu items in Colleague. Mnemonics can be found doing a word search.

slide-21
SLIDE 21

RMUG 2014 Laramie County Community College

Files, Records, Fields, and Keys

21

Files are a resource for storing information. Computer files can be considered as the modern counterpart of paper documents which traditionally are kept in office file folders. PERSON, COURSES, STUDENT.TERMS Records are items that contains other elements. The elements of records are usually called fields. PERSON record 0010123 COURESE record 820 STUDENT.TERMS record 0010123*14/SP*UG

slide-22
SLIDE 22

RMUG 2014 Laramie County Community College

Files, Records, Fields, and Keys

22

Fields are place holders for specific data in files PERSON file contains fields like FIRST_NAME HOME_PHONE COURSES files contains fields like COURSE_NAME COURSE_DESC Keys are the unique record identifier to data in a specific file PERSON record 0010123 COURESE record 820 STUDENT.TERMS record 0010123*14/SP*UG

slide-23
SLIDE 23

RMUG 2014 Laramie County Community College

Computer File System

23

File Key Field Record Data

slide-24
SLIDE 24

RMUG 2014 Laramie County Community College

What is a …

24

slide-25
SLIDE 25

RMUG 2014 Laramie County Community College

What is a …

25

slide-26
SLIDE 26

RMUG 2014 Laramie County Community College

Data Integrity Tips

26

Data Quality Get it right first time and keep it right. Data Definitions Document what the data is and what the valid data entries are. Data Retention Create and maintain archiving and purging policies. Ensure users have regular and effective housekeeping routine. Data Stewards Define data stewards in each functional area and hold them accountable.

slide-27
SLIDE 27

RMUG 2014 Laramie County Community College

Garbage In Garbage Out

27

slide-28
SLIDE 28

RMUG 2014 Laramie County Community College

Resources

28

Ask.com http://answers.ask.com/computers/programming Wyoming CROA 2012 KickOff PowerPoint by Adam Lange Ellucian Colleague Reporting from the DataOrchestrator ODS Data Models Wikipedia, the free encyclopedia

slide-29
SLIDE 29

RMUG 2014 Laramie County Community College

Questions and Suggestions

Edie Miller edmiller@lccc.wy.edu 307.778.1324

Questions and Suggestions

29