Kansas State University

search

IT News

Category: Data management

Jan. 29: Exploring Microsoft Excel (Essentials)

Exploring Microsoft Excel (Essentials) training is scheduled 1:30-3:30 p.m. Friday, Jan. 29, on Zoom.  

About Microsoft Excel

Microsoft Excel is the foremost spreadsheet program in use today.

It is commonly used to:

  • Conduct calculations
  • Clean data
  • Graph or plot data (to identify data patterns)
  • Create data visualizations (both static and interactive)
  • Apply visual styles to data tables and data visualizations
  • Create interactive data visualizations (interactive pivot tables, interactive dashboards with sliders, and others)
  • Create simple macros for continuing data handling (with Visual Basic programming language)
  • Process data for analytics in other software programs
  • Enable the share-ability of information
  • Access online survey data (in analyze-able format), and more…

Continue reading “Jan. 29: Exploring Microsoft Excel (Essentials)”

Mediasite: Managing content storage

As the spring semester begins, now is an excellent time to evaluate the content you have uploaded to Mediasite and remove presentations you no longer intend to use. An on-demand Mediasite webinar, Managing Content Storage, will guide you through reviewing a content storage reportarchiving presentations into an offline format, and deleting unneeded or archived Mediasite content. Continue reading “Mediasite: Managing content storage”

Winter electronic workspace remote work clean up

Over the past year, we have had a unique working environment, and many of us have worked remotely for several months or longer. To properly manage records and workspaces, it is important to clean up our spaces regularly.

Between semesters provides a perfect opportunity to dedicate time to proper records management. For common questions about cleanup practices and what should stay and what should go, please use the suggestions below for general guidance.

FAQs:

  • How do I know what is and is not a record? A University record can exist in any format: paper, audio, electronic, or other formats. The easiest way to determine if something is a record is to ask yourself, “is this conducting official university business?” if the answer is yes, then it is likely a record. Other non-records include drafts, duplicate copies of the official record, messages where the information has no operational value, superseded lists, and correspondence where you are not the official recipient, such as “cc” or “bcc” in the case of emails.
  • How do I know when I should destroy, archive, or transfer a record? All official records of the University can be found on the KSU Records Retention Schedule. If you can’t find the record on the schedule, we will need to create a retention schedule. To remain in compliance with the State of Kansas public records laws, follow official retention schedule guidance. Contact the University Records Manager if you believe a retention schedule is needed.
  • What is the difference between paper and electronic records? The format does not matter in the determination of what is a record and what is not. Regardless, if the record exists in paper or electronic format, they fall under the same retention schedule. Internal department policy may need to be developed to determine the official record for ease of management in your office.
  • Working remotely offers a unique challenge to the management of electronic records.
    • Avoid saving official University records to your personal device, be it your cell phone, tablet, personal laptop, or desktop computer. Alternative storage locations could be OneDrive or department shared drive accessed via VPN. Follow your departmental guidance for storage solutions.
    • Delete digital file copies when your work is complete to remove the risk of duplicate files cluttering your storage space.

Much of the above information has focused on electronic records clean up, but it is also important to routinely clean up your paper file locations. Confidential and secure records should be routinely destroyed via shredding.

If you are a teaching faculty and are curious about what you need to keep/destroy from semester to semester, retention schedules that may help you determine what to keep and destroy are provided below. Other records retention guidance can be found on the Archives and Records Management website.

If you have additional records questions, contact Ryan Leimkuehler, the University Records Manager at rleimkue@ksu.edu.

Oracle database upgrade scheduled for Dec. 19

K-State’s Oracle database will be upgraded from 6 a.m. – 12 p.m. Saturday, December 19. During the upgrade, K-Staters can not change or reset passwords, search the people directory, or create an eID.

The upgrade will allow K-State to stay current and ensure that security patches continue to get applied to our databases running in Amazon Web Services.

Impacted systems include eProfile, identity management services and support, the People Directory, Grouper, and more. Backend support tools will be unavailable. The status of the upgrade will be shared on the IT Status page.

ImageNow upgrade Dec. 4-7

ImageNow will be unavailable from 4 p.m. Friday, December 4 through 8 a.m. Monday, December 7. The downtime will be used to upgrade ImageNow to Perceptive Content Foundation version EP2. Once the upgrade is complete, existing ImageNow users will have access to the upgraded desktop client and a new web client. Continue reading “ImageNow upgrade Dec. 4-7”

ImageNow upgrade to be rescheduled

The ImageNow upgrade scheduled for Friday, November 6 through Monday, November 9, has been delayed because of performance-related issues. The upgrade will be rescheduled for an upcoming weekend in November. ImageNow users can continue to use the tool while the Division of Information Technology works to resolve the performance issues in the test environment. 
Continue reading “ImageNow upgrade to be rescheduled”

Nov. 13: Advanced NVivo

NVIVO“Advanced NVivo” is a follow-up presentation from the “Introduction to NVivo” offered earlier this term. This training will be held 1:30-3:30 p.m. Friday, Nov. 13, online via Zoom.

This presentation will address the following:

  • Any extant questions from the basic introduction of NVivo 12 Plus / NVivo
  • How to set up qualitative data to be explored and queried
  • How to use the software on interview, survey, focus group, and similar data
  • How to query the collected data in an NVivo project (word frequency counts, text searches, matrix coding queries, matrix queries, proximity text searches, and other forms of text parsing)
  • How to create data visualizations (word trees, word clouds, dendrograms, ring lattice graphs, sociograms, and others) (for analysis and presentations)
  • How to conduct four types of auto-coding (by extracted themes and subthemes, by sentiment analysis, by structured data, and by supervised machine learning based on existing human coding)
  • How to set up a qualitative cross-tabulation analysis
  • How to output a basic report (including a custom codebook)

The presenter will be using the Windows version of the software. Continue reading “Nov. 13: Advanced NVivo”

Oct. 16: Intro to NVivo

NVIVOAn “Intro to NVivo” training is scheduled from 1:30-3:30 p.m. Friday, Oct. 16, for all faculty, graduate students, and staff who may be using this qualitative (and mixed methods, multimethods) data analysis tool. This session will occur on Zoom.

This presentation, which covers NVivo 12 Plus / NVivo (newest) basics, will address the following:

  • The basic parts of the NVivo 12 Plus interface
  • How to start and structure a research project (including a team project)
  • How to set up a project around a base language (Chinese/PRC, English/US, English/UK, French, German, Japanese, Portuguese/Brazil, and Spanish
  • How to ingest various multimedia file types (and curate heterogeneous and semi-structured digital data and digitized contents)
  • How to ingest some social media contents
  • How to begin manual and/or automated coding various media file types
  • How to run data queries in the tool and analyze resulting data visualizations (word clouds, word trees, matrices, geographical maps, bar charts, and others)
  • How to back up the .nvp / .nvpx project file

Continue reading “Oct. 16: Intro to NVivo”

CRM introduction training scheduled for Fall 2020

CRM Introduction Training has been scheduled for the Fall 2020 semester starting on September 28.

Sessions will be held on:

  • Sept. 28 – 1:30-3 p.m.
  • Oct. 14 – 10-11:30 a.m.
  • Oct. 26 – 1:30-3 p.m.
  • Nov. 11 – 10-11:30 a.m.

All training sessions will be presented on Zoom.  The Zoom session ID will be shared on the morning of the training to attendees. Sessions last for 1.5 hours and are limited to 20 people per session. You must be enrolled in the session to attend.

To sign up for training, sign in to HRIS.

  1. Under Self Service, choose Learning and Development, then KSU Training Enrollment.
  2. On the Request Training Enrollment page, look for CRM Introduction WIT310.
  3. Select View Available Sessions.
  4. Select the Session you would like to attend.
  5. Select Continue.

Continue reading “CRM introduction training scheduled for Fall 2020”