Kansas State University

search

IT News

Author: Shalin Hai-Jew

Jan. 28: Exploring Microsoft Excel (Essentials)

Exploring Microsoft Excel (Essentials) training is scheduled 1:30-3:30 p.m. Friday, Jan. 28, 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. 28: Exploring Microsoft Excel (Essentials)”

June 3: Exploring Microsoft Excel (Essentials)

Exploring Microsoft Excel (Essentials) training is scheduled 1:30-3:30 p.m. Friday, June 3 (Fri.), 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 “June 3: Exploring Microsoft Excel (Essentials)”

Sept. 3: Exploring Microsoft Excel (Essentials)

Exploring Microsoft Excel (Essentials) training is scheduled 1:30-3:30 p.m. Friday, Sept. 3, 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 “Sept. 3: Exploring Microsoft Excel (Essentials)”

Aug. 30: Getting Started with ETDR Templates

""Are you a master’s or doctoral student? If so, it is likely that you will be conducting research as part of your studies. At some point, you may be writing a thesis, report, or dissertation to record your work to share with the profession and the world. K-State has made available templates (in Microsoft Word and LaTeX) for students to use, in order to ensure that they include all required information in the proper formatting.

“Getting Started with ETDR Templates” is an online training on Zoom from 1-2:30 p.m., Monday, Aug. 30.    

Continue reading “Aug. 30: Getting Started with ETDR Templates”

Aug. 6: LIWC2015 for Computational Linguistic Analysis

LIWC“Using LIWC2015 for Computational Linguistic Analysis” will be presented from 1:30-3:30 p.m., Friday, Aug. 6, via Zoom. (Link will not be live until the event.

The Linguistic Inquiry and Word Count (LIWC) tool enables users to conduct computational linguistic analyses on single texts, collections of texts, and text corpora, in order to better understand the latent data.

This presentation will include an overview of the linguistic analysis sequence: research design, curation of text sets, data cleaning, exploration of texts and data analytics using LIWC, and common methods for reporting the research information.

Continue reading “Aug. 6: LIWC2015 for Computational Linguistic Analysis”

July 30: Intro to MS Visio Pro

An introductory training for Microsoft Visio Pro is scheduled 1:30-3:30 p.m. Friday, July 30, on Zoom(Session is not live until the scheduled time.)

About Microsoft Visio Pro

Microsoft Visio Pro is a common diagramming tool that enables the creation of vector graphics.

Some common examples include the following:

  • Flowcharts to describe work or research processes
  • Basic diagrams
  • BPMN (Business Process Model and Notation) diagrams (with built-in validation based on rule sets)
  • Database systems
  • Floor plans
  • Network designs
  • Data-created visuals (with uploaded Excel spreadsheets used in Visio templates from MS Visio Online and/or the Excel backstage)
  • Automapping of websites to three levels
  • And more

Continue reading “July 30: Intro to MS Visio Pro”

Working on a Grant Application?

At K-State, many staff members support principal investigators (PIs) and co-PIs in pursuing grant funding for research, teaching and learning, and social supports (“extension”). Many of these grant applications require logic models, data tables, data visualizations (including Gantt charts), geographical maps, and other contents.

Division of Information Technology has recently released knowledge base articles that may support these endeavors.

The lead article is Exploring Some Conventions in Grant Applications.

Other articles in this series are as follows:

If you have suggestions for improvement of these articles, feel free to email shalin@ksu.edu.

July 23: Intro to Adobe Illustrator 2021

“Intro to Adobe Illustrator” is scheduled 1;30-3:30 p.m. July 23 on Zoom. This session introduces Adobe Illustrator as the leading software for editing and creating scalable vector images (graphics).

This session will introduce the general graphical user interface (GUI) for this software. Then, it covers some basic uses and shows some walk-throughs of work sequences.

Continue reading “July 23: Intro to Adobe Illustrator 2021”

July 19: Getting Started w/ ETDR Templates

Are you a master’s or doctoral student? If so, it is likely that you will be conducting research as part of your studies. At some point, you may be writing a thesis, report, or dissertation to record your work to share with the profession and the world. K-State has made available templates (in Microsoft Word and LaTeX) for students to use, in order to ensure that they include all required information in the proper formatting.

“Getting Started with ETDR Templates” is an online training on Zoom from 1 – 2:30 p.m., Monday, July 19.    

Continue reading “July 19: Getting Started w/ ETDR Templates”

July 16: Intro to NVivo

NVIVOAn “Intro to NVivo” training is scheduled from 1:30-3:30 p.m. Friday, July 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 “July 16: Intro to NVivo”