Information Systems and Computer Skills

This course presents object oriented analysis, design and programming using the C++ language. Emphasis is placed upon proper programming logic, style and syntax, with the understanding that today’s software products often must be scalable in size and complexity up to multiple users in an enterprise-wide or otherwise distributed system such as the Internet.

LEARNING OBJECTIVES

• Learn C+ programming basics
• Understand the variables and assignments, input and output, data types and expressions
• Learn Flow Control including ‘if’ statements, ‘loops’, ‘switch’ statements, and the ‘conditional operator’
• Learn Procedural Abstractions and Functions, Static Arrays and Strings, Pointers and Dynamic Arrays
• Understand Object Oriented concepts, Object Oriented Analysis and Design, Objects and Classes
• Learn Polymorphism: Operator Overloading and Data Conversions, Inheritance, Virtual Functions
• Build Templates

This Microsoft Excel Level 1 course focuses on basic spreadsheet skills, including how to navigate the Ribbon, and key features in Excel; how to create simple accurate worksheets, which includes basic formulas, formatting, absolute and relative cell references, and how to use Excel to analyze data more efficiently and effectively, and create professional looking charts. This course is intended for new users and for those who may be self-taught. 

LEARNING OBJECTIVES

• Demonstrate proficiency in MS Office Excel interface to include the Ribbon, Command and Contextual Tabs, Galleries, Quick Access Toolbar, and Options preference settings
• Plan, design, create and manage effective Excel worksheets
• Navigate efficiently through worksheets and workbooks
• Selection shortcut techniques including nonadjacent ranges
• Identify appropriate mathematical processes necessary to achieve accurate results in Excel
• Build specific mathematical and statistical formulas in Excel (AutoSum, Average, Min, Max, Count)
• Create basic mathematical formulas in Excel (to include understanding of Order of Operations)
• How to insert/delete multiple rows and columns
• Identify and utilize appropriate formatting and formatting practices for data in Excel, including themes and styles
• Devise formulas utilizing relative, absolute and mixed cell references
• Modify status bar to use AutoCalc for accuracy checks of formulas
• Gain an understanding of various charts used to represent quantitative data in in Excel
• Modify charts according to charting best practices
• Manage large volumes of data through the use of Tables in Excel, using a total row, sort and filter features, using single and multiple criteria
• Print standard and customized documents to include orientation, page setup, margins, page breaks, and sizing, as well as applying headers and footers with automatic page numbering
• Auto-size columns and rows
• Basic Sorting and Filtering
• Build and manage automatic lists
• Apply basic conditional formatting

Microsoft Excel Level 2 is an intermediate course focused on linking spreadsheets, manipulating multiple sheet tabs for viewing, calculating, grouping, creating custom conditional formatting rules using formulas, using Pivot Tables, using Excel as a database, defining range names, automatic subtotals, outlining, using all commonly used functions, IF, nested IFs, SUMIF, COUNTIF, VLOOKUP, the PMT function, one and two-input data tables related to PMT, Goal Seek, Date and Text functions, Advanced Filter with DSUM, DAVERAGE, DMIN, and DMAX, identifying and correcting formula errors, formatting a data series and chart axis, referencing external data sources, creating and using charting templates, continued work with and understanding Absolute and Relative cell references, advanced page setup and printing techniques, and receiving an introduction to Macros. 

LEARNING OBJECTIVES

• Apply Quick Analysis Feature
• Produce and link multiple spreadsheets
• Build and manipulate auto subtotal commands
• Practice with data validation drop down lists and rules, and basic conditional formatting
• Receive an introduction to data analysis with Pivot Tables
• Learn to use Excel as a database – DSUM, DAVERAGE, DCOUNT
• Create and use range names
• Use all common functions, such as IF, SUMIF, COUNTIF, VLOOKUP, Date and Text functions
• Use the PMT function and associated GOAL SEEK and one and two-input data tables
• Display and print formulas in a worksheet
• Use Excels tools for identifying and correcting formula errors
• Learn advanced charting functions
• Manage advanced print commands to include Print Area, Print Titles, Gridlines, Comments
• Reference external data sources
• Save a "reader friendly" custom view, freeze panes, split screens, side-by-side sheet tab views
• Create and use templates
• Work with auto format, create a custom number format, use find and replace formatting
• Continued work with and understanding of Absolute and Relative cell references
• Create custom conditional formatting using formulas
• Apply basic spreadsheet protection

This advanced level Microsoft Excel course focuses on real time data analysis, creating and managing calculations and instant reports with PivotTables, formatting reports, and creating Pivot Charts, combining data from multiple tables using Consolidate and Data Models, automating advanced filtering techniques, using Scenario Manager and Solver to analyze data, recording a Macro, playing a Macro, and assigning a Macro a shortcut and button, creating forms with command buttons, and importing external data through use of queries and get data techniques, including CSV files, charting data on Maps. 

LEARNING OBJECTIVES

• Summarize and analyze large amounts of data in a logical, organized manner
• Create interactive pivot tables and pivot charts to perform real time data analysis, including specifying the data analyzed, changing a calculation, selecting what appears, and formatting and charting a pivot table
• Learn to manipulate pivot table data using drill downs, grouping, custom sorts, slicers, custom calculations, custom reports and instant reports
• Create advanced conditional formatting rules using formulas
• Perform data imports and exports, including CSV files and use of queries
• Record, play, edit, and assign a keyboard shortcut and button to a Macro
• Create a macro to automate advanced filtering techniques
• Save a workbook as a macro-enabled page
• Compare Excel lists for unique values using conditional formatting, removing duplicates, MATCH, INDEX, Advanced Filters
• Random sampling
• Create custom views for instant show/hide data
• Perform "What if" analysis using Scenario Manager and Solver
• Use Consolidate to link multiple ranges of different sizes, locations, and content
• Protect formula cells, worksheets, and workbooks
• Collaborate with Excel
• Add and work with hyperlinks and Excel workspaces – manipulating multiple windows and virtual desktops
• Add, edit, and search records to a list using a Data Form
• Create basic Excel forms with command buttons using Excel form controls
• Use Excel’s new Map feature
• Link Excel data into Word and PowerPoint for automated reporting

Outlook is a multi-layered software application with many functions “tucked away”. This is an opportunity to take a closer look at the automation within Outlook. The focus is on saving time, increasing organization, and efficiency. Manage Tasks and To Do lists and ultimately make Outlook work for you! 

Appropriate for new and experienced users. 

LEARNING OBJECTIVES

• Short cuts and tips to work smarter usingOutlook
• Navigation
• Best practices for managing invitations
• Major functions of Outlook and how to apply them in efficient and effective ways
• How to integrate Outlook with other Office applications for maximum benefit

OneNote’s power only begins at the note-taking stage. OneNote can be used as a collection tool for managing all that data going on among the other Office software! You may even decide on a comprehensive result – a polished enotebook – compiled as you work and available to your team and/or client as an ongoing electronic reference. Increase your efficiency by learning the details behind the best practices for integrating data. Make the OneNote process work the way you want. 

LEARNING OBJECTIVES

• Learn short cuts and tips to work smarter using OneNote
• Construct a basic notebook with linked pages and sections
• Customize a page template for a specific documentation need
• Use tags to search data

This class is developed to include the apps and topic areas most used by your business. Microsoft Office 365 (O365) is a supported cloud storage and online collaboration service. It provides a place to securely store files, allows access from almost anywhere on any device. Gives the ability to easily and securely share files and folders with an individual or an entire group of people. O365 makes it possible for collaboration with others on Word, Excel, PowerPoint, etc. in real-time, without the need to pass application files around and track changes. Gives access to online versions of Word, Excel, PowerPoint, OneNote, and other applications.

LEARNING OBJECTIVES 

• Office 365 navigation
• Access documents from anywhere at any time 
• Link and share documents departmentally and cross-functionally 
• Use the updated features in Word, Excel, PowerPoint and Outlook to build and develop more effective documents

SQL is the standard language for communicating with databases. Students are taught how to create, update and delete records in databases, as well as how to return records from multiple tables. Students will write SQL code demonstrating the key capabilities of the language, and they will also learn how to save their code for future use as stored procedures. Students will work with conditional and logic structures, custom functions code loops, transaction management and other advanced aspects of the SQL language. This class emphasizes a learn-by-doing approach with numerous hands-on exercises. As always, this class may be designed for introductory, intermediate or advanced level staff.

LEARNING OBJECTIVES

• Learn how to create, update, delete and return records
• Develop or hone skills in writing SQL code
• Demonstrate increased capabilities with SQL language
• Advanced Classes: 
  • Gain technique in logic structures, custom functions code loops, transaction management
  • Think critically about core relational database concepts and query optimization