Class Information

 

 

HTML5 and CSS3 Fundamentals

 

Students will get an introduction to HTML/CSS and the client-server context. Some examples are borrowed from the book and others are explicitely developed by myself in order to prepare the student adequately for the advanced class and future courses in the JCCC web track. Students will create a resource project and a final project called Steamworks.

Course Material

 Basics of Web Design HTML5 CSS3, 3rd Edition, Terry Felke-Morris, Pearson  Ed.

Core Concepts (JCCC Objectives)
The following core items will be covered:
1.    Internet and Web Basics
2.    HTML Basics
3.    Web Design Basics
4.    Cascading Style Sheets Basics
5.    Graphics and Text Styling Basics
6.    More CSS Basics
7.    Page Layout Basics
8.    More on Links, Layout, and Mobile
9.    Table Basics
10.    Web Publishing Basics
 

Outline

  • What is HTML?
    • Defining Hyper-text markup language
  • HTML Context
    • What is a server?
    • The Client-server Construct
    • Static vs. Dynamic languages
    • Client vs. Server side languages
  • HTML Editing
    • An introduction to editing an HTML document
    • The Windows problem: “hidden extensions”
    • Creating a file with Notepad
    • Creating a single tag and saving
    • Two modes: text and browser rendering
    • Rendering and viewing source
    • Browser tools and inspecting
  • HTML editors
    • Text editor vs text-based web editors, IDEs
    • Syntax highlighting and code suggestion 
  • The HTML5 DOM
    • Document type
    • Core tags and markup structure
    • Structure vs. user visible
  • The Editing Process
    • Open in editor
    • Edit code
    • Save
    • View in browser
    • Inspect as needed
    • Repeat
  • HTML on the Server
    • Getting a server (local test server)
    • The document root
    • Navigating to a local server
      • localhost
      • 127.0.0.1
      • Machine name
      • Ip address
    • Local pathing/file structure and the url
    • URL structure
  • HTML’s relationship to other web languages
    • Web languages
    • Front-end vs. Back-end 
  • Resource Project Site
    • Home Page
      • In page CSS
    • Tags Page
      • External CSS
      • Anchor types
      • Numerous tags
    • Menus
      • The duplication menu
      • The frame menu
    • Images Page
      • Storing and referencing images
    • JavaScript Page
      • Understanding JavaScript's relationship to HTML/CSS
      • Simple Example
      • jQuery Example & External Script Libraries
    • Layouts Index Page
      • The folder level problem
      • Layout 1 - Simple stack column layout
      • Layout 2 - Two column layout
      • Layout 3 - Media Queries
      • Layout 3 - Simple Flex
      • Layout 4 - Simple Bootstrap
    • CSS Animations Page
    • Forms Index Page
      • A simple web contact form page
      • Form handling
      • Understanding the server stack relationship
    • Form elements page
  • CMS Editing
    • How CMS works
    • Wordpress example
  • The Steamworks Project
    • Putting it all together
    • Assets & Requirements
    • Putting your own take on it
    • Borrowing code 

Teacher Recommended Resources

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

HTML5 and CSS3 Advanced

 

Overview

Students will explore advanced concepts in HTML/CSS in the client-server context. Some examples are borrowed from the book and others are explicitely developed by myself in order to prepare the student adequately for future courses in the JCCC web track.

Core Concepts (JCCC Objectives)
1.    Introducing HTML5 and CSS3
2.    Markup, HTML5 Style
3.    More HTML5 Semantics
4.    HTML5 Forms
5.    HTML5 Audio and Video
6.    Introducing CSS3
7.    CSS3 Gradients and Multiple Backgrounds
8.    CSS3 Transforms and Transitions
9.    Embedded Fonts and Multicolumn Layouts
10.    Flexbox and Media Queries
11.    Geolocation, Offline Web Apps, and Web Storage
12.    Canvas, SVG, and Drag and Drop
 

This custom curriculum has been developed by Dan Guinn, all rights reserved.

Custom Outline
Coming Soon!


 

 

JavaScript

 

Overview
Tour JavaScript, an important part of modern web applications. Learn to respond to user interactions and update web pages dynamically using the Document Object Model. Features from ECMAScript 6 (ES6) covered.

Core Concepts (JCCC Objectives)

  • Core language features (variable, decisions, loops, arrays)
  • The Document Object Model (DOM)
  • Handling Events
  • HTTP and AJAX
  • Working with Forms
  • Working with objects and JSON
  • Core ES6 features (let, arrow functions and more)
  • JavaScript classes
  • Using Promises

Custom Class Outline

  • What is JavaScript?
    • How does JavaScript relate to HTML/CSS?
    • What is the role of JavaScript?
    • Behavior emphasis and programmatic logic
    • Context
  • Where to Implement JavaScript
  • Hello World!
    • Forms of output
      • document.write()
      • alert()
      • innerHTML
      • console.log()
  • The C based language style
  • Basic Programming logic
    • Variables
    • Comments
    • Assignment operators
    • Concatenation
    • Comparison operators
    • Mathematical operators
    • Algebra: Remembering PEMDAS
    • Default Functions and User defined functions
    • Variable scope
    • Data types
      • Strings
        • String methods
      • Numbers
        • Number methods
        • The math object
        • Random
      • Dates
        • Date formatting
        • Date methods
  • Programming Conventions
    • Objects
    • Arrays
      • Array methods
    • Conditions
      • If, else
      • switch
    • Loops
      • for
      • While
  • Exercises:

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

jQuery

 

$( )

Overview

Coming Soon!

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

ReactJS

 

Overview

Get up to speed with React, an open-source library for building web-based user interfaces. Set up a React project using Webpack. Build a basic React component. Use React features such as handling events, using routes passing properties and state.

Core Concepts (JCCC Objectives)

  • Introduction to Webpack and project setup
  • JSX files
  • React components
  • React properties
  • Working with state in components
  • Routes
  • Event handling
  • Component lifecycle

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

NodeJS

 

Overview

Build asynchronous, event-driven applications using Node.js, a server-side platform built in JavaScript.  Cover the basics of Node.js before creating simple services to store and retrieve objects using MongoDB.

Core Concepts (JCCC Objectives)

  • Setting up Node.js
  • Asynchronous programming with Node.js
  • Modules and npm
  • Creating a simple server
  • Using Express to create web applications
  • Creating simple RESTful services
  • Setting up MongoDB
  • Using MongoDB in Node.js
  • Deploying Node.js applications

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

Wordpress Intro

 

Overview

Set up, create and customize a WordPress site, beginning with creating a website and multiple pages. Install and modify themes. Discuss how to use WordPress as a content management system, create menus, and modify the CSS behind the theme. Add videos and podcasts. Coursework includes RSS for syndication and basic analytics.

Core Concepts (JCCC Objectives)
1.    First Steps with Wordpress
2.    Getting Familiar with WordPress
3.    Settings
4.    Managing Accounts
5.    Setting up a WordPress Theme
6.    Widgets and Plug-ins
7.    Adding Content
8.    Menus
9.    Working with Media
10.    Managing Comments
11.    Getting Fancy with Themes
12.    Advanced Theme Development
13.    Custom Content Types
14.    One Installation, Multiple Blogs
15.    More Ways to Customize WordPress
16.    Best Practices
 

Outline

  • What is Wordpress?
    • What is a blog?
    • What is a CMS?
  • Wordpress Setup
    • The Client-Server Construct & LAMPP Stack
    • Running a Server
    • The Web Root
    • PHP/MariaDB (MySQL) and Wordpress
    • Getting Wordpress
      • Wordpress.com vs Wordpress.org
      • Hosted vs. Privately Hosted
      • Install steps
      • Wait! What just happened?!!!
  • Wordpress Administration
    • Public/Private Area
    • Navigating to your new site
    • The dashboard and menu
    • Navigation tips (top level and sub-menus)
      • Home
      • Updates: Keeping your installation up to date
    • The CMS/WYSIWYG Concept
    • Post
      • What are post?
      • Managing blog post
    • Media Managing your media library
      • Where do my images go?
      • What does Wordpress do with them?
    • Pages
      • What are pages?
      • How are pages different from post?
      • Managing pages
    • Comments
      • What are comments?
      • Managing comments
    • Users
      • What can you do with user adminstration?
      • User types explained
        • Subscriber
        • Contributor
        • Author
        • Editor
        • Administrator
    • Tools
      • What are tools?
    • Settings
      • What can you manage in Settings?
    • Appearance
      • Wordpress Themes
      • Customize
      • Widgets
      • Menus
      • Header
      • Editor
      • Changing Themes and How That Changes Things
      • Tweaking a design with CSS
    • Plugins
      • What are plugins?
      • The power of plugins
    • Knowing your environment limitations
      • Wordpress.com
      • Wordpress.org
      • Free Wordpress hosting
      • Paid Wordpress hosting
  • Building and Managing Your Site!

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

Wordpress Dev

 

Overview

  • Core
  • Themes
  • Plugins

The Client-Server Model

The CMS Construct

Preserving the Core

Using and Managing Themes

Developing Themes
  • Theme Components
  • Theme Plugin Structure
  • Your First Themes
    • Bootstrap
    • Flex

Using and Managing Plugins

Developing Plugins

  • Plugin Components
    • PHP Functions
    • Header
    • Hooks
      • Actions
      • Filters
    • Supporting Assets
  • Plugin File Structure
  • Your First Plugin
    • A minumal plugin example
  • Plugin Functionality and Use Case
    • A simple, full-featured plugin 
  • Plugin Components Further Explained 
    • Default Hooks
    • Custom Hooks
    • Plugin APIs
  • Advanced Features

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

PHP

 

< ?php ? > 

Overview

Coming Soon!

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

Search Engine Optimization

 

Overview

Take a systematic approach to the art and science of search engine optimization (SEO).  Set the foundation of SEO efforts, move to building an SEO strategy. Use tools and tasks needed for a comprehensive SEO plan.

Outline

Before You Begin

  • Website Fundamentals
  • Website Conversions and Usability
  • SEO Templates

Part 1: Content

  • Content Marketing
  • Tools and Strategies
  • Content Strategy
  • Blogging
  • Headlines
  • Attracting Global Traffic with Content

Part 2: Code

  • Keywords
  • Keyword Mapping
  • Optimizing your Site

Part 3: Credibility

  • Links
  • Measuring your Credibility
  • Link Building
  • Earning High-Quality Backlinks
  • Guest Blogging
  • Tools and Tricks

Part 4: Connections

  • Google Plus
  • Winning on Social Media
  • Social Media Hacks

Part 5: Cash

  • 5 Website Monetization Models
  • Making Money with your Blog
  • Subscriber and Lead Growth Tools
  • Content Monetization Engines

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

Google Analytics

 

Overview
This class provides significant introduction to Google Analytics and assist the student in becoming certified in Google Analytics.

Part 1: An Introduction and Overview of Google Analytics

  • Disclaimers - What this class is and is not.
  • Types of Web Measurement - Digital Marketing Measurement Models
    • What are they? Why? Implementation?
    • Definition: A methodology that includes the gathering of information through resources such as reports, dashboards and online conversions for the purpose of improving strategy and campaign performance results.
  • Basic Concepts:
    • Collection of data (data harvesting)
    • Processing of data into actionable information
    • Translating information into key performance indicators (KPI)
    • Formulating strategic initiatives
    • Ascertain Value
  • The Cyclical Model - A Web Development Interaction Approach:
    • Implement - (Develope/Experiment as an Informed Action)
    • Measure
    • Analyze
    • Learn
    • Recommend
  • THE DATA SOURCE: Clickstream (Book, page 5-7)
    • Avoid the “single source of relevant truth” concept with respect to overall analytics as quality analytics will include multiple streams of information. 
    • On site (site interaction) and Off-site Analytics (Global Internet)
  • The Google Analytics Approach: A, B, Cs of Measurement
    • Audience
    • Acquisition
      • Source
      • Organic Search
      • Direct
      • Social Media
      • Referral
    • Behavior
      • What is the user doing?
    • Conversion
      • What are the desired goals?
      • Destination
      • Duration
      • Page Screen Visits
      • Event
  • Setting up Google Analytics
    • Prerequisite: You need a Google account. 
    • Two Components:
      • Domain Account must be added to your Google Analytics account.
      • Code for Google Analytics must be added to your site.
      • The client/server model
    • Goto: https://analytics.google.com/
    • Sign in with your Google account.
    • You should see the following, click sign-up:

Google Analytics Sign-up Screenshot

  • You will be presented with a form to add your website. You will need to have a web site that you are able to add code to. If you do not have a web site you can use the Google Analytics Demo Account. If that is the case, skip these site setup steps and see instructions later in this outline.
    • Fill in your Account Name, Website Name, Website URL, and select an Industry Category and Reporting Time Zone.
    • Under Data Sharing Options, check the boxes next to the options that you want.
    • Click Get Tracking ID.
    • From the Google Analytics Terms of Service Agreement that opens, click “I Accept.”
    • Script setup (analyticsjs):
      • Information: https://developers.google.com/analytics/devguides/collection/analyticsjs/
      • Getting the needed code: Admin -> Property Settings -> Tracking Info -> Tracking Code
  • How the Script Works:
    • An example of the Google Analytics code in the wild.
      • HTML and JavaScript Explanation and script placement.
    • An example of Google Analytics event tracking in the wild.
      • Google Chrome Developer Tools
      • Taking a look at the GA cookies in application cookies.
      • How JavaScript functions and parameters work.
      • Analyzing a Google Analytics page hit in network traffic:
        • A Sample url hit string for this page. You may see several of these in network traffic during the page load. 
        • The url is ampersand delimited. Notice some of the discernable information in the tracking url:
          • http://www.google-analytics.com/r/collect? -  The domain and page where your hit registers.
          • v=1 
          • &_v=j62
          • &a=120461928
          • &t=pageview - The type of action.
          • &_s=1
          • &dl=http%3A%2F%2Fdanguinn.com%2Fjccc-students%2F - The url of this page
          • &ul=en-us - The language of this page
          • &de=UTF-8 - The encoding of this page
          • &dt=DANGUINN.COM%20-%20Jccc-students - The title of this page
          • &sd=24-bit
          • &sr=1366x768 - The screen resolution
          • &vp=490x638
          • &je=0
          • &fl=27.0%20r0
          • &_u=AACAAEABI~
          • &jid=699500873
          • &gjid=464394241
          • &cid=1479283727.1502992055 - Random user identifier
          • &tid=UA-75557500-1 - The tracking code of this page.
          • &_gid=748479334.1505590455
          • &_r=1&z=686253164
        • These data points get translated into the dimensions (categories) of metric data in Google Analytics.
      • A Simple Event Code: onclick="ga('send', 'pageview', 'what you are tracking');"
  • Google Analytics Demo Account: Google provides a free test account of a live web store you can experiment with:
  • Google Analytics Interface Walkthrough
    • Home
    • Customization
    • Reports
      • Realtime
      • Audience
      • Acquisition
      • Behavior
      • Conversions
    • Dashboard Concept (why a dashboard?)
  • Answering Basic Analytical Questions about the Google Analytics Demo
    • Audience - Who came to the site?
      • Where geographically?
      • Have they been here before?
      • How often do they come back?
      • What devices do they use?
    • Acquisitions - How did they get here?
      • What channels are driving the most traffic?
      • What sites are sending traffic to the site?
      • Which campains are driving the most traffic?
      • What channels are generating the most monetarily?
    • Behavior - What did they look at?
      • Which pages?
      • Where did they enter and leave?
      • What actions did they take?
    • Conversions - Were they successful?
      • Did they complete the goals?
      • Did they complete a transaction?
      • Did they drop out?
  • The Google Complimentary Ecosystem in Other Google Products:
    • Show Blogger
    • Show YouTube
    • Using them together to track a campaign

Part 2 

  • Going Deeper
    • Review
    • Additional knowledge
    • Getting Google Certified!
  • HTML Elements and how your developer can help you.
    • Inline coding reviewed
    • Sample scripts of "event listeners" (double meaning)
    • HTML - elements ids and classes
    • Using JavaScript and jQuery to target multiple or single events without inline coding
  • Email Marketing Concept Introduction
    • Email Markup and HTML
    • Click metrings on all links
    • Tracking types
      • Direct to tracking enabled page
      • Track and forward
      • URL tracking with url parameters enabled
        • Medium (required)
        • Source (required)
        • Campaign (required)
        • Content
        • Term
  • Getting back in the interface
    • Accounts, Properties, Views
    • Permissions
    • Views - Recommended types: Master, Test, Raw/Unflitered
    • Things you might have missed...
      • sending reports on schedule
      • notes
    • Metrics vs. Dimensions
    • Source vs. Medium
  • Google Analytics Academy - Let's do this... together!

Putting it All Together


Links & Resources:

Related resource, webmaster tools: 

Google Analytics Solutions:

Getting to your cloud instance of Google Analytics:

Support and Development:

Adding the Test Site: Demo Account Google Merchandise Store

Google Analytics Academy

Google UTM Tracking Template

Campaign URL Builder

Basic Web Knowledge

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

Programming Fundamentals

 

Overview
Receive an introduction to fundamental programming skills, focused on object-oriented topics such as classes, objects, methods, and properties. Course content uses JavaScript (ES6) to build on programming skills.

Core Concepts (JCCC Objectives)

  • Values, Types, and Operators
  • Program Structure
  • Functions
  • Data Structures: Objects and Arrays
  • Higher-order Functions
  • Objects, Prototypes, Methods, Properties and Constructors
  • Bugs and Error Handling
  • Modules
!

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

Excel VBA Programming

 

Overview

Learn how to code and create VBA Applications in Excel.

Course Concepts (JCCC Objectives)
Visual Basic Editor
1.    Visual Basic for Applications
2.    Object programming
3.    The Object Browser

Programming basics
1.    Data basics
2.    Scope of variables
3.    Scope of procedures

Control structures
1.    Decision structures
2.    Loop structures

Custom dialog boxes
1.    User forms
2.    Events

Debugging and error handling
1.    Errors
2.    Debugging
3.    Error handling
 

Course Material: Course Material: Excel 2010: VBA Programming

Teacher Provided Resources

Class Outline &

  • Visual Basic for Applications Quick Reference
  • Class Objectives Part 1
    • What is VBA?
    • VBA vs. Macros & Formulas
    • VBA & OOP
    • VBA Editor Features
      • Project Explorer
      • Properties Window
      • Code Window
      • Object Browser
        • Search
    • Events & Buttons Excercises
    • Unit Summary / Practice Activity
    • VBA Programming Basics
      • Datatypes
      • Variables
      • Opertators
      • Expressions
    • VBA Functions & Procedures
      • The Ecapsulation Concept
    • VBA Scope
      • Procedure-level
      • Private module-level
      • Public module-level
      • Application level (not in book)
    • Control Structors Introduction
      • If Then
      • If Then Else
      • Select Case
  • Class Objectives Part 2
    • Control Structures Cont.
      • For Next
      • For Each
      • Do Loop
      • Do While
    • Unit Summary / Practice Activity
    • Forms
      • Creating Forms in the VBE (Visual Basic Editor)
      • Controls
      • Events
      • Form Validation
    • Unit Summary / Practice Activity
    • Debugging & Error Handling
      • Step Into
      • Step Over
      • Step Out
      • The VBE Immediate Window
      • The Locals Window
      • On Error GoTo
      • On Error Resume Next
    • Unit Summary / Practice Activity
    • Extra (If Time Allows) - Ribbon Editing
  • Advanced Extras

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

Access VBA Programming

 

Overview

Coming Soon!

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

SQL Fundamentals

 

Overview
Learn the key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language.

Class Outline Pt1:

  • What is a database?
  • Popular databases
  • Database terminology
  • CRUD
  • The Client/Server Model
  • SQL Management Tools
  • Our databases (Access, Oracle, MySQL)
  • Data Migration & SQL Scripts
  • Your first SQL script
  • Three Rolls of SQL
    • Data Definition
    • Data Manipulation
    • Data Authorization
  • Introduction to the SELECT clause

Class Outline Pt2:

  • Review
  • Navigating to Other Network Databases
  • Form Usage
  • Data Types
  • DISTINCT SELECTS
  • OPERATORS
  • LIKE
  • AND
  • LIMIT
  • BETWEEN

Class Outline Pt3:

  • Review
  • Case sensative LIKE
  • FUNCTIONS
    • Aggragate Functions
    • Scalar Functions
    • Mathematical Functions
    • Text Functions
    • Date Functions
  • INSERT - Create
  • SELECT - Read
  • UPDATE - Update
  • DELETE - Delete
  • SET 
  • ALIASES
  • Introduction to the JOIN Concept
  • Types of JOINS
    • NATURAL JOINS
    • INNER JOINS
    • SELF JOINS
    • OUTER JOINS

Class Outline Pt4:

  • Review
  • JOIN Types (part 2)
  • CLASS PROJECT (Putting SQL in context. SQL in Relation to Applications)
    • Application Connections
    • A login query
      • Encryption functions
    • Application SELECTS (creating SELECT statements for applications)
    • SQL and the Application CRUD processes in action
      • Application Record IDs
      • SELECT (details)
      • UPDATES
      • DELETES
      • Form INSERTS
  • Recommendations for furture growth with SQL
  • Evals

Resources:

Reference:

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

Excel Fundamentals

 

Overview

Content introduces essential uses, tools and features of Microsoft Excel. Enter, edit and format data. Manage data in a single worksheet. Manage workbooks. Link worksheets and create basic functions. Design and edit charts. Organize large amounts of data.

The student will receive a specialized training spreadsheet developed for Excel instruction by the instructor called "Excel Super Powers."

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

Excel Advanced

 

Overview

Designed for students looking for discussion on tables, pivot tables, pivot charts, financial functions, structured references, goal seek, and workbook protection. 

The student will receive a specialized training spreadsheet developed for Excel instruction by the instructor called "Excel Super Powers."

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

Access Fundamentals

 

Overview

Coming Soon!

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

Introduction to Web Development

 

Overview
This class introduces students to the tools, technologies and methodologies to build websites. The goal is to understand industry vocabulary and techniques used by people already in the web development world.

Outline

  • Web Development Process
    • Requirements gathering
    • Wireframing, creating prototypes
    • Development
    • Testing
    • Deployment
    • Popular processes:
      • *What is SDLC?
      • Waterfall,*RAD, Agile, Scrum, *Kanban
      • Project interaction concepts
    • *Analytic Conversion Concept
  • * Client-Server Construct
    • Web Server Technologies
    • Web Languages Overview
  • Tools of the Trade
    • Editors vs IDE's
    • *SDLC Tools
      • Atlassian Products: Jira, Confluence, SourceTree, Bitbucket, Hipchat
      • Slack
    • Version Control Systems (GIT, SVN, Bitbucket)
    • NodeJS and NPM
    • *Other Servers: XAMPP, WAMPP, LAMPP Stacks
  • Key Web Technologies
    • HTML
    • CSS
    • JavaScript
    • JavaScript Libraries and Frameworks (jQuery, Angular, React, etc.)
    • Content Management Systems (WordPress, Drupal, etc)
    • *Server-side languages, PHP, JSP, Ruby on Rails
    • *Web Services & Feeds: REST, SOAP, XML, JSON, RSS
    • Databases
  • Other things to consider
    • Responsive Web Design
    • Security
    • SEO

*Supplemental Content added by instructor to JCCC Objectives.

Recommended Reading:
https://en.wikipedia.org/wiki/Waterfall_model
https://en.wikipedia.org/wiki/Rapid_application_development
https://www.atlassian.com/agile/
https://www.atlassian.com/agile/scrum
https://www.atlassian.com/agile/kanban

Comparison of common types:
http://www.satejinfotech.in/the-different-software-development-models-part-1/
https://www.atlassian.com/software/jira/comparison

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

Excel Intermediate

 

Expand Excel knowledge with an in-depth look at conditional formatting, advanced text and analysis functions, vlookup, outlines and subtotals.

The student will receive a specialized training spreadsheet developed for Excel instruction by the instructor called "Excel Super Powers."

This custom curriculum has been developed by Dan Guinn, all rights reserved.


 

 

  Custom Training

Do you require custom technical training or tutoring? I regularly develop curriculum for numerous languages and concepts in web development, Excel, Excel VBA development and other languages. Various options are available for meeting your instruction needs. Here they are for your consideration:

  • Private one-on-one tutoring in a professional training environment
  • Onsite contract instruction, individual or groups
  • Group training, in a professional training environment

Contact me (information on resume), with any questions or consultation. 

 

 

Robots.txt
sitemap.xml
sitemap
sitefeed.rss
rss