Please enable JavaScript to use CodeHS

Standards Mapping

for Florida Digital Information Technology I

87

Standards in this Framework

36

Standards Mapped

41%

Mapped to Course

Standard Lessons
1.01
Develop keyboarding skills to enter and manipulate text and data.
  1. 6.2 Using Databases
  2. 7.2 Programming with Karel
1.02
Describe and use current computer technology and software to perform personal and business related tasks in the workplace (e.g., e-mail, digital calendars, meetings, appointments).
1.03
Differentiate between types of file systems and classify common file extensions based on software application programs used in the workplace environment.
  1. 2.1 Operating Systems
  2. 2.4 Compatibility
  3. 2.6 Software and Applications
1.04
Utilize the Internet to find reliable resources and reference materials (e.g., on-line help, tutorials, manuals).
  1. 5.2 Troubleshooting Methodology
1.05
Apply research strategies to use and evaluate electronic research technologies for valid and reliable information.
  1. 1.3 Can All Information Be Trusted?
1.06
Demonstrate basic computer file management skills (e.g., naming, saving, retrieving, and organizing).
1.07
Analyze the process of troubleshooting problems with computer hardware peripherals, including input and output devices.
  1. 5.2 Troubleshooting Methodology
1.08
Describe ethical issues and problems associated with computers and information technology (e.g., fair use, privacy, public domain, copyright, piracy, plagiarism).
  1. 1.3 Can All Information Be Trusted?
  2. 1.4 Cyber Ethics and Laws
1.09
Explain the history and purpose of various operating systems (e.g., DOS, Windows, Mac, and Unix/Linux).
  1. 2.1 Operating Systems
  2. 2.3 Comparing Operating Systems
2.01
Explain the general architecture of a microcomputer system.
2.02
Explain the need for and demonstrate proficiency using common peripherals (e.g., printers, mouse, keyboard, external hard drive, flash drive).
  1. 4.3 Peripheral Devices
  2. 4.4 Storage Options
2.03
Examine the concepts of computer maintenance and upgrades.
  1. 2.8 Application Security
3.01
Differentiate between types of networks and how they work (e.g., clients, servers, Wi-Fi, teleconference)
  1. 4.7 Network Options
3.02
Identify security needs within a network environment (e.g., antivirus software, passwords).
  1. 1.5 Personal Data Security
  2. 1.6 Cybersecurity Essentials
  3. 2.8 Application Security
3.03
Distinguish between intranets, extranets and how they relate to the Internet.
  1. 9.4 Private Networks
3.04
Demonstrate basic understanding of cloud computing.
  1. 10.1 Cloud Computing
4.01
Select and use word processing software and accompanying features to create and enhance various written business communications (e.g., memos, reports, block business letters).
4.02
Save and export documents in various formats (e.g., pdf, html, blog, hyperlinks).
4.03
Format text content in a document (e.g., font, paragraph attributes, spacing, text styles, text boxes).
4.04
Manipulate page layout and reusable content (e.g., page setup, themes, templates, page backgrounds, headers and footers).
4.05
Perform various image-editing tasks using word-processing software to create and format images, illustrations, shapes, etc.
4.06
Proofread and revise documents by validating content through the use of word processing tools (e.g. spell check, thesaurus, find/replace, autocorrect settings).
4.07
Insert citations and hyperlinks, create end and footnotes, and create a table of contents in a document.
4.08
Perform various mail merge options, macros and tracking revisions.
4.09
Demonstrate an understanding of fonts (serif and sans serif) and font styles (bold, italic, etc.)
5.01
Manage and configure the presentation software environment (e.g., adjusting views, manipulating slide settings, configuring toolbar and file options).
5.02
Use presentation software to format and edit slides (e.g., adding and removing slides, slide layouts, format slide design, insert or format placeholders).
5.03
Locate, create and incorporate graphical and multimedia elements, including: shapes, graphics, images, bullets, hyperlinks, video, and audio into a slide presentation.
5.04
Enhance overall visual presentation by applying font selection, design themes, color schemes, templates, etc.
5.05
Create and manipulate graphical and multimedia elements using additional styles and effects (e.g., color selections, tone, contrast, shadows, picture styles).
5.06
Demonstrate various business-related elements that can be created, embedded and manipulated in a slide presentation, including: charts, graphs, tables, media, spreadsheets, and illustrations.
5.07
Customize presentation settings by using appropriate slide transitions and animations (e.g., on click, rehearsed timings)
5.08
Demonstrate different delivery methods for slide presentations, including: online delivery and sharing, video projection, printing options.
6.01
Manipulate the worksheet by using the ribbon tabs, group settings, importing data/database, manipulating properties, files and folders.
6.02
Create cell data and apply auto fill.
6.03
Format cells and worksheets (e.g., by applying and manipulating cell formats, styles, merging and splitting cells, create row and column titles, hide and unhide column titles, rows and columns, page setup options, and manipulating views/themes).
6.04
Create and analyze formulas and functions (e.g., apply conditional formula logic, name and cell ranges).
  1. 8.1 Spreadsheet Basics
  2. 8.3 Sort and Filter
  3. 8.6 Statistical Measures
6.05
Create and modify charts and images. (e.g., pivot tables)
  1. 8.5 Pivot Tables
6.06
Share worksheet data through various system (e.g., email, external media, cloud storage, mail merge).
6.07
Analyze and organize data through filters, sorting and applying conditional formatting. (e.g., macros)
  1. 8.3 Sort and Filter
6.08
Interpret data on line graphs, pie charts, diagrams, and tables.
  1. 8.4 Data Visualizations
7.01
Create different forms for inputting data into a database application.
7.02
Interpret queries for specialized reports using a database application.
  1. 12.3 Basic Querying in SQL
7.03
Create and modify a database by importing data from other sources
  1. 12.4 Filtering Queries in SQL
7.04
Create and manage database tables by hiding fields, importing data, adding total rows
7.05
Modify queries by renaming, adding/removing fields, sorting, formatting, and adding calculated fields
7.06
Create and format reports with multiple columns, calculated fields and images.
8.01
Describe and perform e-mail capabilities and functions (e.g., create, send, & forward messages, organize email folders, manage signature and automated messages, configure message sensitivity, security and delivery options).
8.02
Perform e-mail activities (e.g., attach external files, save e-mail attachments, view mailbox details, schedule appointments, create contact groups).
8.03
Demonstrate an understanding of the ethical issues associated with electronic correspondences (e.g., employer’s ownership of email, public access of government email, appropriate uses in the workplace, phishing attacks, permanence of electronic communications on the internet).
8.04
Describe the need for and appropriate use of electronic mailing list software applications (e.g., listserv)
9.01
Analyze personal skills and aptitudes in comparison with various business related job and career options. (i.e., hard and soft skills)
  1. 5.1 Communication is Key!
  2. 13.1 Communication is Key!
9.02
Use career resources to develop and analyze occupations and opportunities for internships, continuing education and on-the-job training.
  1. 5.1 Communication is Key!
  2. 13.1 Communication is Key!
9.03
Exhibit job-seeking skills required for entry-level employment, including resume, online job search, cover letter, online/hard copy application, mock interview, interview thank you letter, and follow-up call.
9.04
Design, implement, and evaluate a plan to facilitate growth and skill development related to anticipated job requirements and career expectations.
9.05
Demonstrate an awareness of specific job requirements and career paths (e.g., education, certifications, skills, previous experience) in business environments.
9.06
Demonstrate an awareness of the potential impact of local and global trends on career plans and life goals.
9.07
Describe the importance of building community and mentor relationships in a variety of professional and workplace situations.
9.08
Simulate work-based projects in an information technology environment
10.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.
  1. 5.1 Communication is Key!
  2. 5.3 Building a Knowledge Base
  3. 5.4 Star in a Video!
  4. 13.1 Communication is Key!
  5. 13.2 Building a Knowledge Base
  6. 13.3 Star in a Video!
10.02
Demonstrate ways of accepting and providing constructive criticism to enhance team projects.
10.03
Apply appropriate strategies to manage and resolve conflicts in work situations.
10.04
Demonstrate personal and interpersonal skills appropriate for the workplace (e.g., responsibility, dependability, punctuality, integrity, positive attitude, initiative, respect for self and others, and professional dress).
11.01
Demonstrate how to connect to the Internet and identify and describe web terminology, addresses and how browsers work.
  1. 3.4 What is the Internet?
  2. 3.5 IP Addresses
  3. 3.6 Routing and Packets
  4. 3.7 How Do Websites Work?
  5. 3.8 OSI Model
11.02
Demonstrate proficiency using basic features of GUI (Graphical User Interface) browsers, including: bookmarks, basic configurations, e-mail configurations, and address books.
11.03
Describe appropriate browser security configurations
  1. 2.9 Browser Configuration
11.04
Describe information technology terminology, including Internet, intranet, ethics, copyright laws, and regulatory control.
  1. 1.3 Can All Information Be Trusted?
  2. 1.4 Cyber Ethics and Laws
11.05
Demonstrate proficiency using search engines and search tools (e.g., Boolean search strategies)
  1. 1.3 Can All Information Be Trusted?
11.06
Use various web tools, including: downloading files, transfer of files, extensions, PDF, plug-ins, and data compression.
11.07
Differentiate between different domain extensions (e.g., .com, .org, .gov, .edu, etc.)
12.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)
  1. 2.6 Software and Applications
12.02
Explain and describe the need for web-based applications (e.g., sharing photos and video clips, messaging, chatting and collaborating.
12.03
Express an understanding of basic terminology used in programming (e.g., algorithm, binary, code, block-based, objects, functions)
  1. 3.1 Computers Speak Binary
  2. 7.1 Programming Concepts
  3. 7.2 Programming with Karel
  4. 7.5 Arrays and Objects
12.04
Compare and contrast emerging technologies and describe how they impact business in the global marketplace (e.g., wireless network, tablets, cell phones, satellite technology, nanotechnology, smart devices, home networks).
  1. 3.9 Impact of the Internet
13.01
Create a basic web page.
  1. 11.1 Introduction to HTML
  2. 11.2 Structure of an HTML Page
13.02
Use basic storyboarding techniques.
  1. 5.4 Star in a Video!
  2. 13.3 Star in a Video!
13.03
Use basic functions of WYSIWYG editors.
13.04
Use basic functions of HTML, DHTML, and XML editors and converters.
  1. 11.1 Introduction to HTML
  2. 11.2 Structure of an HTML Page
13.05
Enhance web pages through the addition of images and graphics.
  1. 11.5 Images
14.01
Read and comprehend technical and non-technical reading assignments related to course content (e.g., manuals, books, magazines, electronic sources).
14.02
Use verbal and nonverbal skills to communicate effectively with supervisors, co-workers, and customers.
14.03
Demonstrate an understanding of the writing process to create business documents (e.g., research methods, paper formatting (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).
15.01
Create and develop a professional social media presence (e.g., LinkedIn) to connect with potential employers, follower influencers, enhance networking opportunities, develop soft skills through written communication, and establish a professional business image.
15.02
Cultivate and manage awareness of digital identity and reputation.
  1. 1.1 Digital Footprint and Responsibility
15.03
Develop awareness of the permanence of actions and social awareness in the digital world.
  1. 1.1 Digital Footprint and Responsibility
15.04
Develop awareness of data-collection technology contributing to their digital footprint.
  1. 1.2 Personal Data and Collection