2018 – 2019
Florida Department of Education
Student Performance Standards

To teach the Information Technology Assistant (OTA0040) course, instructors must hold at least one of the teacher certifications listed below.  It is recommended that teachers hold the most appropriate certification based on the CTE program in which they are assigned. 

OTA0040	Course Title	Teacher Certification	Length	
OTA0040	Information Technology Assistant	ACCTING @7  7 G
ADMIN ASST 7 G
BUS ED 1 @2
COMM ART @7 7 G
COMP PROG 7 G
COMPU SCI 6
INFO TECH 7 G
MANAG SUPV 7 G	150 Hours	

Course Number:  OTA0040 
Occupational Completion Point:  A 
Information Technology Assistant – 150 Hours – SOC Code 15-1151	
01.0	Demonstrate knowledge, skill, and application of information systems to accomplish job objectives and enhance workplace performance. – The student will be able to:	
01.01	Develop keyboarding skills to enter and manipulate text and data.	
01.02	Describe and use current computer technology and software to perform personal and business related tasks in the workplace. (e.g. digital calendars, meetings, appointments, e-mail contacts)	
01.03	Identify and describe types of file systems and classify common file extensions based on software application programs used in the workplace environment.	
01.04	Use reference materials. (e.g. on-line help, tutorials, manuals, vendor bulletin boards)	
01.05	Demonstrate basic computer file management skills and file naming conventions to accurately organize files into hierarchies by labeling file folders for easy accessibility.	
01.06	Discuss the process of troubleshooting problems with computer hardware peripherals, including input and output devices in the workplace environment.	
01.07	Describe ethical issues and problems associated with computers and information systems, including federal laws against anti-piracy with computers and PC software security protection.	
01.08	Identify operating system file naming conventions.	
01.09	Demonstrate proficiency with file management and structure. (e.g., folder creation file creation, backup copy, delete, open, save)	
01.10	Demonstrate a working knowledge of standard file formats.	
01.11	Explain the history and purpose of various operating systems. (e.g., DOS, Windows, Mac, and Unix/Linux)	
02.0	Develop an awareness of microprocessors and digital computers. – The student will be able to:	
02.01	Explain the general architecture of a microcomputer system.	
02.02	Explain the need for and use of peripherals.  	
02.03	Demonstrate proficiency using peripherals.	
02.04	Identify the basic concepts of computer maintenance and upgrades.	
02.05	Differentiate between diagnosing and troubleshooting.	
03.0	Demonstrate an understanding of operating systems. – The student will be able to:	
03.01	Identify types of networks and how they work.	
03.02	Identify the role of servers and clients on a network.	
03.03	Identify benefits and risks of networked computing.	
03.04	Identify the relationship between computer networks and other communications networks. (e.g., wifi, teleconference, telepresence)	
03.05	Identify intranets, extranets and how they relate to the Internet.	
03.06	Demonstrate basic understanding of network administration.	
04.0	Use technology to enhance the effectiveness of communication skills utilizing word processing applications. – The student will be able to:	
04.01	Select and use word processing software and accompanying features to enhance written business communications.	
04.02	Share and maintain documents by applying different views and protection to a document and manage document versions.  Share and save a document and apply a template. (e.g., pdf, html, blog, hyperlinks)	
04.03	Format content to a document by applying font, paragraph attributes, indent and tab settings to text and paragraphs.  Apply spacing settings to text and paragraphs.  Navigate and search through a document, create and manipulate tables.	
04.04	Apply page layout and reusable content by editing and manipulating page setup settings and applying themes.   Create and manipulate page backgrounds, headers and footers.	
04.05	Use image design theory and software to create illustrations, shapes, and graphics and include a selection in a document.  Insert and format pictures, shapes, and clipart.  Apply and manipulate text boxes.	
04.06	Proofread documents by validating content through the use of spell and grammar check.  Configure autocorrect settings, insert and modify comments in a document.	
04.07	Apply references and hyperlinks, create end and footnotes, and create a table of contents in a document.	
04.08	Perform various mail merge options, macros and tracking revisions.	
05.0	Use technology to enhance communication skills utilizing presentation applications. – The student will be able to:	
05.01	Manage and configure the presentation software environment, including: adjusting views, manipulating window, configuring toolbar and file options.	
05.02	Create slide presentations utilizing various project development elements, including: adding and removing slides, slide layouts, format slide design, insert or format placeholders.	
05.03	Locate, create and incorporate graphical and multimedia elements, including: shapes, graphics, images, bullets, hyperlinks, video, and audio into a slide presentation appropriate for the project. 	
05.04	Explore and apply design and color theory to create dynamic and appealing visuals.  	
05.05	Create and manipulate graphical and multimedia elements to improve or develop new contacts appropriate for the project, including: creation of images, color selections, tone, hue and contrast.	
05.06	Demonstrate various business-related elements that can be created, embedded and manipulated in a slide presentation, including: charts, graphs, tables, spreadsheets, flowcharts, and organizational charts.	
05.07	Apply slide transitions and create custom animations to slide presentations appropriate for the target audience.	
05.08	Demonstrate different delivery methods for slide presentations, including: packaging for CD delivery, video projection – on mouse click, rehearsed timings, printing options - outlines, handouts, slides and notes.	
06.0	Use technology to enhance the effectiveness of communication utilizing spreadsheet and database applications. – The student will be able to:	
06.01	Manage the worksheet environment by navigating through and printing a worksheet.  Personalize the environment by manipulating the ribbon tabs, group settings, importing data/database, manipulating properties, files and folders.	
06.02	Create cell data, apply auto fill and hyperlinks.	
06.03	Format cells and worksheets by applying cell formats, merging and splitting cells, create row and column titles, hide and unhide column titles, rows and columns.  Manipulate page set up options.  Create and apply cell styles.	
06.04	Manage worksheets and workbooks by creating and formatting worksheets and manipulating views/themes.	
06.05	Apply formulas and functions by creating formulas, enforcing precedence and cell formula references.  Apply conditional formula logic, name and cell ranges.	
06.06	Demonstrate data visually by creating and modifying charts and images. (e.g., pivot tables)	
06.07	Share worksheet data through email, changing file type and different versions.  Manage comments. (e.g., mail merge)	
06.08	Analyze and organize data through filters, sorting and applying conditional formatting. (e.g., macros)	
06.09	Create different forms for inputting data into a database application.	
06.10	Interpret queries for specialized reports using a database application.	
06.11	Interpret data on line graphs, pie charts, diagrams, and tables commonly used in spreadsheet software applications that incorporate industry data. 	
07.0	Use technology to enhance communication skills utilizing electronic mail. – The student will be able to: 	
07.01	Describe and perform e-mail capabilities and functions.  Create and send messages, manage signature and automated messages.  Save, send, schedule, and manage junk mail, e-mail and spam.  Configure message sensitivity, security and delivery options.	
07.02	Use the Internet to perform e-mail activities, including:  attaching external files, saving e-mail attachments, viewing mailbox details, establishing appointments, creating contact groups, and sending a meeting to a contact group to communicate in the workplace.	
07.03	Manage tasks and organize information. (e.g., forward e-mail)	
08.0	Investigate individual assessment and job/career exploration and individual career planning that reflect the transition from school to work, lifelong learning, and personal and professional goals. – The student will be able to:	
08.01	Analyze personal skills and aptitudes in comparison with various business related job and career options.	
08.02	Use career resources to develop an information base that reflects local and global business related occupations and opportunities for continuing education and workplace experience.	
08.03	Demonstrate job-seeking skills required for entry-level employment, including resume, cover letter, thank you letter, online/hard copy application, mock interview, and follow-up call.	
08.04	Design, initiate, refine and implement a plan to facilitate growth and skill development related to anticipated job requirements and career expectations.	
08.05	Demonstrate an awareness of specific job requirements and career paths (e.g., requirements, characteristics needed) in business environments.	
08.06	Demonstrate an awareness of the potential impact of local and global trends on career plans and life goals.	
08.07	Describe the importance of building community and mentor relationships in a variety of professional and workplace situations. 	
08.08	Simulate work-based projects in an information technology environment.	
09.0	Incorporate appropriate leadership and supervision techniques, customer service strategies, and standards of personal ethics to accomplish job objectives and enhance workplace performance. – The student will be able to:	
09.01	Demonstrate awareness of the following workplace essentials:  quality customer service; business ethics; confidentiality of information; copyright violations; accepted workplace rules, regulations, policies, procedures, processes, and workplace safety, and appropriate attire and grooming.	
09.02	Demonstrate ways of accepting constructive criticism on team projects within the workplace.	
09.03	Apply appropriate strategies to manage and resolve conflicts in work situations.	
09.04	Demonstrate human relations, personal and interpersonal skills appropriate for the workplace, including: responsibility, dependability, punctuality, integrity, positive attitude, initiative, respect for self and others, and professional dress.	
10.0	Demonstrate competence using computer networks, internet and online databases to facilitate collaborative or individual learning and communication. – The student will be able to: 	
10.01	Demonstrate how to connect to the Internet and use appropriate Internet protocol.  Identify and describe web terminology, addresses and how browsers work.	
10.02	Demonstrate proficiency using basic features of GUI browsers, including: bookmarks, basic configurations, e-mail configurations, and address books.  Describe appropriate browser security configurations. 	
10.03	Describe information technology terminology, including Internet, intranet, ethics, copyright laws, and regulatory control.  	
10.04	Demonstrate proficiency using search engines and search tools.	
10.05	Use various web tools, including: downloading files, transfer of files, telnet, PDF, plug-ins, and data compression.  Identify Boolean search strategies. 	
10.06	Understand and apply level one Universal Resource Locator (URL) and associated protocols. (e.g., com, org, edu, gov, net, mil)	
11.0	Demonstrate competence in page design applicable to the WWW – the student will be able to:	
11.01	Describe and apply color theory as it applies to Web page design.	
11.02	Access and digitize graphics through various resources. (e.g., scanner, digital cameras, on-line graphics, clipart, CD-ROMs)	
11.03	Explain the need for web-based applications.	
11.04	Describe appropriate use of social networking sites and applications, blogs and collaborative tools for file sharing and using listservers.  (dangers of piracy, copyright, plagiarism)	
11.05	Describe web applications, including sharing photos and video clips, messaging, chatting and collaborating.	
12.0	Develop an awareness of emerging technologies. – the student will be able to :	
12.01	Compare and contrast emerging technologies and describe how they impact business in the global marketplace. (e.g., wireless network, tablets, cell phones, satellite technology, nano technology,  smart devices, home networks, peer-to-peer)	
13.0	Develop awareness of computer languages and software applications. – the student will be able to:	
13.01	Compare and contrast the appropriate use of various software applications.  (e.g., word processing, desktop publishing, graphic design, web browser, e-mail, presentation, database, scheduling, financial management, Java applet, music)	
13.02	Demonstrate the use of various software applications. (e.g., word processing, desktop publishing, graphic design, web browser, e-mail, presentation, database, scheduling, financial management, Java applet, music)	
13.03	Introduction of language terminology. (e.g., HTML, Python, Java, Flash, Pearl, code.org)	
13.04	Create web pages.	
13.05	Use storyboarding techniques. 	
13.06	Use basic functions of WYSIWYG editors. 	
13.07	Use basic functions of HTML, DHTML, and XML editors and converters. 	
13.08	Enhance web pages through the addition of images and graphics including animation. 	
14.0	Demonstrate comprehension and communication skills. – The student will be able to:	
14.01	Read and comprehend technical and non-technical reading assignments related to course content, including manuals, books, magazines and electronic sources.	
14.02	Use listening, speaking, telecommunication and nonverbal skills and strategies to communicate effectively with supervisors, co-workers, and customers.	
14.03	Apply the writing process to the creation of appropriate documents following designated business formats. (e.g., note taking, research, MLA/APA)	
14.04	Demonstrate an awareness of project management concepts and tools. (e.g., timelines, deadlines, resource allocation, time management, delegation of tasks, collaboration)