skip to Main Content

Aloha

Pacific Center for Adavanced Technology Training (PCATT) is located in Downtown Honolulu, with ample parking. We are on the city bus line, which makes it convenient to commute from anywhere on Oahu.

SEE CAMPUS MAP

Get In Touch

pcatt@hawaii.edu
(808) 845-9296
874 Dillingham Blvd, Honolulu, HI 96817

Our Location

Business Computing

Creating Charts and Graphs in Excel

Learn the features of Excel that create visual aides, images, and charts including column, line, pie, bar, area, scatter, stock, surface and others. Integrate these tools and displays into your presentation to create impressive reports, and display perfomrance. This is an applications course.

Learner Outcomes

To be able to enter and process all aspects of a data base which can be converted into visual displays of various forms: Student will complete a simulation event.

Section - COM6021-006

Section - COM6021-007

Introduction to Survey Creation & Analysis

This high-level course utilizing multiple applications is designed for you to engage as a first step for survey creation and analysis.  Learn the most important question for the design of your survey and potential biases.  Create and send surveys using Google Forms/Sheets.  Understand Mean Perceived Learning Scores (MPLS) with Likert Type survey questions as you begin analyzing the responses for an understanding of the survey results.  An introduction to basic statistics including understanding Z-scores and standard deviations to identify statistical significance while utilizing tools (including ANOVA and Post Hoc tests in MS Excel and "R").

Prerequisites

Prerequisites:  A Fun Introduction to Computers or Equivalent Experience

Learner Outcomes

Learner Outcomes:

1).  Achieve and demonstrate basic understanding of survey design and efficiency creating surveys in Google Forms utilizing Likert Type questions.

2).  Achieve and demonstrate basic analysis of the Google Forms survey responses.

3).  Achieve and demonstrate basic understanding of MPLS (Mean Perceived Learning Scores) and statistical analysis.

4).  Achieve and demonstrate understanding of statistical significance while using statistical tools from the output data of the surveys.

5).  Present results of the survey findings to assist in making ongoing organizational improvements.

 

Section - COM3040-001

Microsoft Excel Essentials

Go beyond the basics and learn how to write a formula, work with a built-in function, create a chart and organize data in a list.

Prerequisites

Spreadsheets for Beginners or previous experience with Excel or other spreadsheet programs. Follow-up Course: Microsoft Excel Intermediate.

Learner Outcomes

Upon successful completion of this course participants will be able to: 1. How to open and interact with Excel and how to save and close workbooks 2. How to enter various kinds of data, how to enter formulas and functions, how to move and copy data, 3. How to format text and numbers, how to align text, and how to apply borders and styles to cells and ranges 4. Know about various data-entry shortcuts; how to use paste options; and how to insert, delete, and hide data in your worksheets 5. How to create charts, change their type, and insert and control the elements they contain. 6. How to split and manage worksheet windows, set print options, print and preview workbooks, create headers and footers, and share workbooks with other users 7. About workbook properties, how to check workbooks for accessibility and compatibility issues, and how to use templates

Section - COM6017-020

Section - COM6017-021

Microsoft Excel Intermediate

Tap into the power of Excel by using more functions that are built-in and explore the needed techniques to build multiple sheet workbooks and to link and consolidate data among them.

Prerequisites

Microsoft Excel Essentials or instructor permission.

Learner Outcomes

Upon successful completion of this course participants will be able to: 1. Manage workbooks and customize the Excel environment 2. Use named ranges in formulas 3. Work with Excel tables and how to sort data, use filtering features, use structured references, validate data, and transpose rows and columns 4. Consolidate data from more than one range or workbook, and how to use subtotals

Section - COM6018-018

Section - COM6018-019

Back To Top