SANTA CRUZ COUNTY REGIONAL OCCUPATIONAL PROGRAM Information Technology

CBEDS Title: Information Technology CBEDS Number: 4603 Career Path: Information Technology Sector Course Description: In this course you will be introduced to a variety of networking technologies, operating systems, communications networks, and programming languages. In the first module of the course you will learn the basics of computer science, operating systems, modern communication systems, and how the Internet works. Students will be provided with network accounts at Cruzio and learn the ins and outs of Linux and programming in the Bash Shell. In the second module you will learn the Fundamentals of Web Design, the infrastructures that support the WWWWorld Wide Web, the coding of HTML-Hyper Text Markup Language and the use of CSS-Cascading Style Sheets. The third module will focus primarily programming in PHP- Hypertext Preprocessor to run code on servers and using SQL-Structured Query Language to use, manage and update databases. At the conclusion of this segment you will create a dynamic database driven web site. In the last module students will work on hands-on application development and team-based projects.

Job Titles: Job Title

DOT codes

Statistical Clerk Computer Operator Media Clerk Computer Programmer Software Engineer Technical Support Specialist Data Base Administrator

209.387-014 213.362-010 247.382-010 030.162-010 020.162-010 033.162-010 039.162-010

Prerequisites: keyboarding or computer literacy course strongly encouraged

COURSE OUTLINE Upon successful completion of this course, students will be able to demonstrate the following skills necessary for employment or further education and training:

I. Career Preparation Standards (Note: additional hours for Career Preparation Standards are integrated into instruction in content area standards).

A. Understand how personal skill development--including positive attitude, honesty, self-confidence, time management, and other positive traits--affect employability. 1. Demonstrate an understanding of classroom policies and procedures. 2. Define business ethics and explain the importance of ethical standards in the business environment. 3. Discuss the laws that apply to sexual harassment and discuss tactics for handling harassment situations. 4. Discuss importance of personal skills in a business environment i.e. positive attitude, self-confidence, honesty, perseverance, self-discipline. 5. Define personal hygiene and identify acceptable business attire for the industry. 6. Prioritize tasks and meet deadlines.

B. Understand principles of effective interpersonal skills, conflict resolution and negotiation.

1. Discuss and demonstrate the dynamics of conflict resolution and negotiation and their importance within the business environment. 2. Work cooperatively, share responsibilities, accept supervision and assume leadership roles. 3. Demonstrate cooperative working relationships and prepare etiquette across gender and cultural groups.

C. Understand the importance of good academic skills, critical thinking and problem-solving skills in the workplace.

1. Recognize the importance of good reading, writing, math, and keyboarding skills in the business environment and implement a plan for self-improvement as needed. 2. Apply estimation, measurement and calculation skills to business applications, including whole number

math, decimals and fractions, counting and monetary function and use of tables as appropriate to industry. 3. Read, write and give directions. 4. Exhibit critical and creative thinking skills and logical reasoning skills. 5. Recognize problem situations; identify, locate and organize needed information or data; and propose, evaluate and select from alternative solutions.

D. Understand principles of effective communication.

1. Read and implement written instructions, technical manuals, written communication and reference books. 2. Present a positive image through verbal and nonverbal communication through use of appropriate methods. 3. Demonstrate proper etiquette in business communications, including an awareness of requisites for international communications (i.e. customs, time zones) 4. Demonstrate writing/editing skills i.e. write, proofread, and edit business correspondence, use correct grammar, punctuation, capitalization, vocabulary and spelling and select appropriate forms of technology for communication.

E. Understand occupational safety issues, including avoidance of physical hazards

1. Discuss and implement good safety practices, including avoidance and reporting of physical hazards in the work environment, safe operation of equipment and proper handling of hazardous materials. 2. Apply sound ergonomic principles in organizing one’s workspace.

F. Understand career paths and strategies for obtaining employment

1. Explore career opportunities and projected trends, investigate required education, training and experience, and develop and individual education plan. 2. Identify steps for setting goals and writing personal goals and objectives. 3. Examine aptitudes related to career options; relate personal characteristics and interests to educational and occupational opportunities.

4. Develop job acquisition documents, including job application, resume, appropriate cover and followup correspondence and portfolio. 5. Identify and demonstrate effective interviewing techniques.

G. Understand and adapt to changing technology. 1. Identify and demonstrate use of computer hardware and peripherals. 2. Identify and explain use of computer software. 3. Identify and use operating systems. 4. Input and retrieve information. 5. Understand the importance of lifelong learning in adapting to changing technology.

II.

Information Technology

A. Demonstrate a basic understanding of the major components of a computer and computer operating systems.

1. Recognize several different Operating Systems and their similarities and differences. 2. Demonstrate knowledge of the current Windows operating system. 3. Understand the importance of good operating practices and general maintenance of computers. 4. Demonstrate the ability to troubleshooting hardware and/or software problem. 5. Understand the importance of computer security. 6. Describe the different forms of malware and their elimination

B.

Number Systems, Data and File Formats 1. Understand the Decimal, Binary and Hexadecimal number systems 2. Convert numbers from one number system to another. 3. Understand the American Standard Code for Information Interchange (ASCII) 4. Recognize and understand the difference between different image formats (BMP, GIF, JPG)

5. Understand the RGB Color Coding System 6. Understand and recognize the different types of data file formats ( csv, xml, etc)

C. Demonstrate a basic understanding of the Internet and Network Fundamentals

1. Identify the types of hardware and software needed for on-line telecommunications. 2. Demonstrate an understanding of IP Networks. 3. Understand and use basic trouble shooting tools ( traceroute, ping, arp, etc) 4. Understand the difference between client and server side applications. 5. Demonstrate knowledge of electronic mail and their standard features. 6. Demonstrate knowledge of web browsers and search engines. 7. Upload and download files using a variety of programs and utiliites (browsers, ftp clients, curl, wget,etc) D. Demonstrate understanding of the Unix Operating System and the use of Unix Accounts 1. Demonstrate the ability to login remotely using a variety of methods. 2. Demonstrate the ability to navigate the Unix File System (ls, cd, mkdir, etc) 3. Create and change file permissions (chmod) 4. Demonstrate an understanding of common unix utilizes and programs (man, cat, more, tail, who, last, curl, wget, mail, cut, sed, etc ) 5. Edit a file using the visual editor (vi)

E. Demonstrate and understanding of programming in the Bash Shell 1. Demonstrate the ability to write a script to accomplish network administration tasks. 2. Write a script that takes user input 3. Write a script that manipulates data

F. Demonstrate an understanding of the Hyper Text Markup Language (HTML) 1. Understand the basics of HTML tags used in web pages. 2. Build a web page using a text editor. 3. Create a Web Page with Forms using Get and Post 4. Create a site with multiple pages and internal navigation 5. Upload web pages to a server. 6. Build a web page using online tools and websites (Wix, Weebly,etc)

G. Demonstrate and understand the basics of Cascading Style Sheets (CSS) 1. Define and understand the benefits of using Cascading Style Sheets 2. Use inline styles in an HTML Document 3. Create a stylesheet within an HTML Document and apply CSS to elements in the page. 4. Create external stylesheets and apply styles to HTML documents.

I. Demonstrate a basic understanding of relational databases 1. Recognize the appropriate use for a database application. 2. Connect and Login to an SQL Server 3. Plan and create a relational database in SQL 4. Create SQL statements to update/delete, modify entries in a table 5. Create SQL Statements to create, modify, delete tables 6. Demonstrate an understanding of Aliasing Tables and Columns in queries. 7. Demonstrate the use of Aggregate functions (sum, average, count, etc) in queries 8. Write a query to join multiple tables

J. Demonstrate an understanding of Programming in PHP 1. Create a hello world program 2. Understand the different types of variables in PHP 3. Write a PHP program that takes user input from the command line. 4. Write a PHP program that manipulates text (strings) 5. Demonstrate an understanding of the use of Arrays and Objects in PHP 6. Demonstrate an understanding of Flow Control (If, If else, Switch) 7. Demonstrate and understanding of Looping Constructs (For, While, Do/While) 8. Demonstrate an understanding of Functions. 9. Write a PHP Program that outputs valid HTML

K. Demonstrate and understanding of the use of Javascript 1. Use Javascript to validate form elements on a web page 2. Use Javascript for on Hover and other Mouse Click effects. 3. Use Javascript to modify elements of a web page.

L. Define and understand the use of Cloud Services 1. Create and use a Google Account for email, data storage (google drive), and the use of online applications (google docs) 2. Create and use an account on cloud9.com to access resources from a Unix Account

M. Understand the use of a Version Control Systems 1. Understand the need for a Version Control System 2.

Create and use an account on Github

3. Demonstrate the use of commands in Github to manage a software project (init, add, push, pull, status, etc)

N . Integrate PHP/HTML and SQL 1. Write a program that integrates an HTML Form with PHP 2. Write a PHP program to access an SQL Database 3. Write a set of programs to modify/update data in an SQL Database using HTML Forms. 4. Create a Database Enabled, Dynamic Website

Maximum hours of instruction: Classroom 180

Internship : _____

Note: Internship or work based learning hours will vary in number and area of concentration within the scope of the course outline, depending upon community training site, interest and skill level of each student.

Instructional Strategies: Lecture, simulations, guest speakers, field trips, role play, demonstration, lab, applied practice.

Instructional Materials:

* http://moodle.rop.launchbrigade.com – Course Management System * http://www.w3schools.com – Tutorials and Resources for HTML/CSS * http://khanacademy.com - Online Curriculum for PHP and Javascript * http://www.php.net - PHP Reference and Documentation

Articulation: NA UC A-G: This class is approved for _______ credit at __________________ High School/s. Academic Credit: Applied Arts Industry/licensing requirement met: N/A Certificates: ROP Course Completion Certificate Revised: 1/2015