Portfolio
- 1. Courses and Projects Completed at Atlantic Technical Center, Coconut Creek FL August 2011 - May 2012 John Jablonski May 2012
- 2. Business Computer Programming Subjects Programming Logic and Design Oracle Database Design SQL PL/SQL VBA JAVA Intro to IT National Career Readiness Certification
- 3. Programming Logic and Design Course Description Completed a course on Programming Logic and Design focused on the development of structured programs and use of good programming skills. The course covered topics related to the entire software development cycle with emphasis on the Planning of Logic step. Lessons included: Fundamental Programming Structures: sequences, decisions and loops. Features of good program design in structure, documentation and coding. Modularization Arrays File Handling and Applications. Course Text Book Programming Logic and Design: Introductory , 6th Edition Joyce Farrell ISBN-10: 1111823952 ISBN-13: 9781111823955 384 Pages Paperback 息2011 Published
- 4. Programming Logic and Design Hangman Word Game Project This project required the development of logic for a digital version of the classic Hangman word game. The project involved all fundamental programming structures and the use of parallel arrays to store the hidden word and users guesses. View Hangman Flow Charts & Pseudo Code
- 5. Oracle - Database Design Course Description Completed Oracle Academys Database Design course that provided a theoretical foundation and practical applications for data modeling and design of relational databases. The course imparted the skills and knowledge for the conceptual design of databases that meet user needs and facilitate physical implementations of normalized, maintainable and well defined relational databases. Some specific topics of study included: ERD Diagramming Conventions Documenting Business Rules CRUD Analysis Database Normalization Modeling Historical Data Drawing Conventions for Readability
- 6. Oracle - Database Design Final Project The courses final project required the design of a database for an animal shelter and the creation of a presentation of the proposed solution to the business. View Presentation
- 7. Oracle - SQL Course Description Completed Oracle Academys Database Programming with SQL course and gained the knowledge and programming skills for the creation, application, maintenance and administration of an Oracle database. Oracles Application Express SQL Workshop, a web application developer tool, enabled hands-on development experience. The lessons covered all four categories of SQL statements: Data Manipulation Language (DML), including advanced retrieval techniques such as ROLLUP, CUBE and set operators. Data Definition Language (DDL) Transaction Control Language (TCL) Data Control Language (DCL)
- 8. Oracle - SQL Final Project The courses final project required the use of the SQL concepts learned to design and build a functional database for a book store. The project included building all necessary tables with appropriate column constraints, designing application pages with Popup Lists of Values (LOVs) and creating reports. View Database Elements
- 9. Oracle PL/SQL Course Description Completed Oracle Academys Database Programming with PL/SQL Student course and gained the knowledge and skills to programmatically manipulate data and implement complex business logic at the database level. Specific skills developed from this course include: Developing efficient programs to access an Oracle database. Creating stored procedures and functions. Developing modular programming using packages. Using Dynamic SQL for run-time data manipulation. Creating triggers to maintain data integrity and automate tasks. Handling predefined and user-defined exceptions. Improving system performance through bulk binding.
- 10. Oracle PL/SQL Sample Projects Use of multiple cursors and parameters to create reports. Handling User Defined Exceptions. Creating Functions. Creating Packages with Overloaded Procedures. Creating Triggers to maintain data integrity where check constraints would be ineffective. View Code for Sample Projects
- 11. Programming VBA Course Description Completed a course on VBA programming that provided the knowledge and skills for increasing the functionality of Access and developing more robust business solutions. Specific topics studied included: Input validation, file processing and error handling Database programming with ADO Access SQL and Macros Object-oriented programming Course Text Book Microsoft速 Access VBA Programming for the Absolute Beginner, 4th Edition Michael Vine ISBN-10: 1133788955 ISBN-13: 9781133788959 400 Pages Paperback 息2012 Published
- 12. Programming VBA Final Project The courses final project required the use of multiple methods and functions taught in the class. I developed a flexible training/testing application that enabled the easy administration of tests using a multiple choice answer format. The application provides an easy means for the input of test questions, establishment of participant accounts and recording of results. View Presentation
- 13. Java Course Description Completed a course on Java. Major topics studied included: Object Oriented Design Control Structures Class Hierarchies and Inheritance, Methods Arrays File I/O Functionality Course Text Book Alice in Action with Java, 1st Edition Joel Adams ISBN-10: 1423900960 ISBN-13: 9781423900962 605 Pages Paperback 息2008 Published
- 14. Java Sample Projects Inheritance Project Demonstrates Inheritance by defining multiple classes and objects with various associated methods and constructors. View Java Files includes demo driver: testPatientBillingMethod Methods Project Paint Job Estimator Program takes inputs such as number of rooms and wall area to provide an estimated cost for professional painting. View Java Files I/O Functionality Project Demonstrates ability to read a data file and display contents. View Java Files Loops and Conditional Statements Project Interactive program accepts five numeric grades, assigns corresponding letter grades, calculates average and displays results. View Java Files
- 15. Intro to IT Microsoft Digital Literacy Certification Completed a Microsoft sponsored program designed to ensure a fundamental understanding of computers through five lessons related to digital technologies and their applications: Computer Basics The Internet and the World Wide Web Productivity Programs Computer Security and Privacy Digital Lifestyles
- 16. Intro to IT Microsoft Word 2010 Completed a course on Microsoft Word 2010 that covered all the basic and common tasks related to creating professional looking documents. Course placed special emphasis on Styles and Themes, Working with Headers and Footers, Reviewing Documents, Working with Tables, SmartArt Graphics, Templates and Mail Merge.
- 17. Intro to IT Microsoft Excel 2010 Completed a course on Microsoft Excel 2010 that covered all the basic and common tasks related to storing, manipulating and analyzing data in organized workbooks. The course highlighted the newest innovations in Excel 2010 such as the enhanced data viewing features of Sparklines and Slicers. In addition, special emphasis was placed on Reviewing and Sharing Workbooks, Templates, Charts, Conditional Formatting, PivotTables and Using What-If Analysis.
- 18. Intro to IT Microsoft PowerPoint 2010 Completed a course on Microsoft PowerPoint 2010 that covered all the basic and common tasks related to creating professional slide presentations. View Study Skills Presentation View Software Presentation
- 19. Intro to IT Microsoft Access 2010 Completed a course on Microsoft Access 2010 that covered all aspects of developing, maintaining and using this relational database program. Special emphasis was placed on working with forms, designing queries and creating reports. Created multiple databases, forms for data entry, queries and reports for course assignments.
- 20. Intro to IT Microsoft Visio Completed Microsofts online training for Visio 2007 and 2010. Created various types of diagrams for course assignments.
- 21. Intro to IT Networking and Internet Fundamentals Completed courses that provided an understanding of basic networking and Internet concepts. Networking focused on topologies while the Internet segment focused on data transmission topics.
- 22. Intro to IT HTML Completed a course that covered basic HTML programming concepts for creating and editing simple web pages. Created a personal web page.
- 23. National Career Readiness Certification Achieved GOLD Certification The National Career Readiness Certificate (NCRC) is an industry-recognized, portable, evidence-based credential that certifies essential skills needed for workplace success. Certification level is determined by the scores achieved on ACTs three core WorkKeys速 assessment exams: Applied Mathematics Reading for Information Locating Information View more information on the NCRC. For verification of certification visit: https://myworkkeys.act.org/mwk/emCertDetails.do?event=go&realm=17740116&certId=0K9J5QYK0HBH