Computer Coding - Year Two Curriculum - - - - - - - (Year 1 found here)
Building Data Driven Applications
Essential Question & Enduring Understandings
(CDOS-3b)
Concept/Knowledge/Content (CDOS-3b) Skills/Tasks (CDOS -3b)
How do map out my data design?

What is entity mapping?

What tools can I use to streamline the process?
Advanced Database Concepts
  • Explain conceptual data modeling and its relationship to database design
  • Creating an Entity by Identifying Relationships
  • Identify and model various types of entities
  • Explain naming and drawing conventions for entities
  • Analyze and model relationships between entities
  • Locate unique identifiers for an entity
  • Differentiate between one-to-many, many-to-many, and one-to-one entity relationships
  • Create a relationship between instances of the same entity
  • Relational Databases
  • Explain how a relational database differs from other databases
  • Describe the purpose of primary keys and foreign keys
  • Normalization
  • Explain normalized data
  • Define un-normalized data
  • Demonstrate proficiency in normalization of data by labeling and organizing within a database to avoid mistakes and coding confusion
  • Mapping Tables
  • Create a table using a database authoring tool
  • Edit tables using a database authoring tool
  • Create forms that will display table components with a database authoring tool
  • Demonstrate the functionality of the database and the layout/design capabilities of a database authoring tool
  • Identify the structural elements of a relational database table
  • Create a web site that displays the database project home
  • Link a web site to create a web-enabled interface to the client ‘s existing database
  • Edit created forms and specify appropriate field labels for data entry
  • Demonstrate Proficiency with Database Fundamentals
  • Demonstrate Understanding Using Arrays
  • Demonstrate Proficiency in Database Modeling

  • Show Managing Data Driven Application Abilities
  • Demonstrate Proficiency with Backend Administration Design & Development
  • Demonstrate Understanding Entity Mapping
  • Projects & Activities (CDOS -3b)
  • Building Data Applications
  • Including:
  • Online Journal System
  • Student Project System
  • Material Inventory System
  • Tournament Laddering System
  • Assessment Strategies (CDOS -3b)
    Common Core:
    Literacy in Technical Subjects (CDOS -2)
    Common Core:
    Program Approved
    Academic Area (CDOS -2)
    CFM Connection (CDOS -1,2,3a,3b)
    21st Century Skills (CDOS-3a)
    Technical /Pathway Assessment Standards (CDOS -3b)

    Client & Project Management
    Essential Question & Enduring Understandings
    (CDOS-3b)
    Concept/Knowledge/Content (CDOS-3b) Skills/Tasks (CDOS -3b)
    What documentation is needed to begin a project?

    How do you begin creating contracts?

    What is a specification document and why is it needed?

    How do you approach milestones and deadlines.
    Establishing a relationship
  • Prepare for the relationship
  • Learn about the customer
  • Understand your value
  • Enter into a partnership


  • Reaching agreement
  • Understand your client’s perspective
  • Understand your own perspective
  • Identify common ground


  • Planning for results
  • Assess readiness for change
  • Facilitate planning
  • Clarify roles and responsibilities
  • Deliver Specification Documents


  • Providing support
  • Anticipate problems
  • Support client decisions
  • Productive constructive feedback
  • Utilizing Change Control Documents


  • Assessing the relationship
  • Solicit feedback
  • Plan next steps
  • Recognize accomplishments
  • Getting the Signed Completion Document
  • Demonstrate Proficiency with:
  • Interviewing Client(s)
  • Soliciting Project Requirements
  • Establishing Mutual Expectations

    Demonstrate Abilities with:
  • Preparing Specification Documents
  • Managing Milestones & Deliverable Deadlines
  • Managing Multiple Developers on Projects

    Show Ability to Produce:
  • Change Control Documents & Procedures
  • Creating Project Reviews
  • Closing Contracts with Clients
  • Projects & Activities (CDOS -3b)
  • Create Specifications Documents for New Projects
  • "Pitch" Clients on Project Proposal
  • Manage Change Control Documents During Development
  • Delivery Contracts and Sign Offs
  • Assessment Strategies (CDOS -3b)
    Common Core:
    Literacy in Technical Subjects (CDOS -2)
    Common Core:
    Program Approved
    Academic Area (CDOS -2)
    CFM Connection (CDOS -1,2,3a,3b) CM5. Career Readiness Skills (1,5,9)
    21st Century Skills (CDOS-3a)
    Technical /Pathway Assessment Standards (CDOS -3b) 3b Career Majors -
  • (2) Business-Related Technology
  • (3) Information Management/Communication
  • (5) Resource Management
  • (6) Interpersonal Dynamics
  • JavaScript Fundamentals
    Essential Question & Enduring Understandings
    (CDOS-3b)
    Concept/Knowledge/Content (CDOS-3b) Skills/Tasks (CDOS -3b)
    In this unit, students will delve into the fundamental foundations of JavaScript. The curriculum focuses on key JavaScript concepts, syntax, and usage, providing students with a strong grounding in the language.

    Week 1-2: Introduction to JavaScript

    Introduce students to JavaScript, its origins, and its basic usage. -
    Content:
    - Where To - - Output - - Statements - - Syntax - - Comments -

    Week 3-4: Variables and Operators

    Cover variables, data types, and basic operators. -
    Content:
    - Variables - - Let - - Const - - Operators - - Arithmetic - - Assignment - - Data Types -

    Week 5-6: Functions and Objects

    Explore functions, objects, and event handling. -
    Content:
    - Functions - - Objects - - Events

    Week 7-8: Working with Strings

    Learn about strings, string methods, and string search. -
    Content:
    - Strings - - String Methods - - String Search - - String Templates

    Week 1-2: Introduction to JavaScript

    1. Basic Syntax:
    2. Variable Usage:
    3. Console Output:
    4. Comments:
    5. Data Types:
    6. Conditional Statements:
    7. Loops:

    Week 3-4: Variables and Operators

    1. Variable Scope:
    2. Arithmetic Operations:
    3. Assignment Operators:
    4. Data Type Conversion:
    5. Comparison Operators:
    6. Logical Operators:

    Week 5-6: Functions and Objects

    1. Function Declaration and Usage:
    2. Function Scope:
    3. Object Creation:
    4. Event Handling:

    Week 7-8: Working with Strings

    1. String Manipulation:
    2. String Search:
    3. String Templates:
    4. Regular Expressions (RegEx):
    5. Error Handling:
    6. Real-World Application:
    7. Code Documentation:
    Projects & Activities (CDOS -3b) Students will build a self-support, wiki style website detailing each new skill throughout the multiweek unit. This site will both explain the concepts and examples of use, but also provide sample code to be used for reference for future integration.
    Common Core:
    Program Approved
    Academic Area (CDOS -2)
    CFM Connection (CDOS -1,2,3a,3b) CM5. Career Readiness Skills (1,5,9)
    21st Century Skills (CDOS-3a)
    K-12 Computer Science and Digital Fluency Learning Standards (Digital Literacy) -
  • 9-12.DL.4 Independently select advanced digital tools and resources to create, revise, and publish complex digital artifacts or collection of artifacts.
  • 9-12.DL.5 Transfer knowledge of technology in order to use new and emerging technologies on multiple platforms.
  • Autonomous Robotics
    Essential Question & Enduring Understandings
    (CDOS-3b)
    Concept/Knowledge/Content (CDOS-3b) Skills/Tasks (CDOS -3b)
    What languages can used to code robots?

    What qualifies as Autonomous?

    What are the potential applications?

    What sensors can be utilized for autonomous operation?
  • Coding Basic Motor Controls
  • Initializing Motor Setups and Controls
  • Understanding Encoded Movement VS Timed
  • Coding Beyond The Wheels (Utilizing Arms and Levers)

  • Programming For Sensor Input/feedback
  • Basic Sensor Initialization and Placement
  • Monitoring Sensors in "Real Time"
  • While Loops vs. Repeat & For Loops
  • Training Color Sensors
  • Storing Sensor Historic Data

  • Compartmentalizing Code Sets
  • Building Functions
  • External Code Snippets
  • Passing Parameters (Multipurpose Functions)

  • Mapping and Data Storing
  • Creating the Learning Robot
  • Storing Mapping Data on External Storage
  • Course Mapping & Plot Adaption
  • Demonstrate Motor & Sensor Configuration Understanding
  • Show Basic Movement Skills Via Coding
  • Demonstrate Sensor Monitoring and Adaption
  • Demonstrate Code Compartmentalization Skills
  • Show Proficiency in Creating and Calling Functions
  • Demonstrate Understanding with Dynamic Variable Usage
  • Demonstrate Team Collaboration and "Co-Coding" Abilities
  • Projects & Activities (CDOS -3b)
  • Research VEX robotic design
  • Construct multi-functional robots
  • Code fully autonomous robots for pathfinding project
  • Code for vision sensor and object detection
  • Develop contextual autonomous programs based on color barcodes
  • Assessment Strategies (CDOS -3b)
    Common Core:
    Literacy in Technical Subjects (CDOS -2)
    Common Core:
    Program Approved
    Academic Area (CDOS -2)
    CFM Connection (CDOS -1,2,3a,3b) CM5. Career Readiness Skills (1,5,9)
    21st Century Skills (CDOS-3a)
    Technical /Pathway Assessment Standards (CDOS -3b) 3b Career Majors -
  • (2) Business-Related Technology
  • (3) Information Management/Communication
  • (5) Resource Management
  • (6) Interpersonal Dynamics
  • Game Theory and Online Delivery
    Essential Question & Enduring Understandings
    (CDOS-3b)
    Concept/Knowledge/Content (CDOS-3b) Skills/Tasks (CDOS -3b)
    What are the elements of succesful games?

    What Platforms can each game be played on?

    What databases are needed for your game?

    How do you manage multiple developers, writers and designers on a project?

    How do you optimize and balance memory vs. performance on multiple platforms?

  • Level Design
  • Storyboarding
  • Image Optimization

  • Collision Detection
  • Storing & Using Instance Variables
  • Developing with Functions
  • Basic Sprite Pathfinding
  • Multi Layout Management
  • Working with Layers
  • Managing Behaviors
  • Basic Animations
  • Timeline Management
  • Sound & Music / Mime Types
  • Cross Platform Development

  • Basic Data Management / Storage / Retrieval
  • Collaborative Development
  • Version Control
  • Quality Assurance
  • Demonstrates Proficiency with:
  • Research / Information Gathering
  • Project Brainstorming
  • Storyboarding
  • Preprocess Planning & Collaboration
  • Compartmental Code Management
  • Managing Data Driven Gameplay
  • File Management Fundamentals
  • Level Management
  • Projects & Activities (CDOS -3b)
  • Develop game storyboards
  • Construct multi level game maps
  • Code basic data functions
  • Work with design teams to spec graphical requirements
  • Implement collision maps and collision detection
  • Develop enemy AI & pathfinding functions
  • Assessment Strategies (CDOS -3b)
    Common Core:
    Literacy in Technical Subjects (CDOS -2)
    Common Core:
    Program Approved
    Academic Area (CDOS -2)
    CFM Connection (CDOS -1,2,3a,3b) CM5. Career Readiness Skills (1,5,9)
    21st Century Skills (CDOS-3a)
    Technical /Pathway Assessment Standards (CDOS -3b) 3b Career Majors -
  • (2) Business-Related Technology
  • (3) Information Management/Communication
  • (5) Resource Management
  • (6) Interpersonal Dynamics
  • Hands On Skills
    Introduction to Problem Solving
    Demonstrates Proficiency with:
    Project Brainstorming
    Research / Information Gathering
    Demonstrates Proficiency in Collaboration Fundamentals

    File Management
    Demonstrates Proficiency with:
    File Management Fundamentals
    Site Management
    Organizational Skills
    Disaster Recovery Planning

    WebSite Planning
    Demonstrates Proficiency with:
    Client Management Fundamentals
    Preprocess Planning & Collaboration
    Client Expectation Management
    Quality Assurance Planning
    Technology Usage Identification and Reporting
    Basic Website Planning & Construction

    Web Content HTML and CSS
    Demonstrates Proficiency with:
    Architecting Reusable Code Assets
    Identifying Code Type Via Syntax
    Large Web Application Planning
    Advanced CSS Techniques
    Dynamic CSS Management
    Full Site Design via CSS
    Using Inheritance in CSS
    CSS Inspection Tools
    Website Construction & Optimization
    Demonstrates Proficiency with:
    Website Optimization
    Using HTML Tables for data
    Tables vs. CSS for Layout
    Demonstrates Proficiency in Understanding 2D Table Structures
    Compartmental Code Management
    Prepping HTML Projects for Data Connectivity

    Form Structures
    Demonstrates Proficiency with:
    Form Processing & Output
    Server Side Processing & Requirements

    Database Fundamentals
    Demonstrates Proficiency with:
    Normalization Rules & Techniques
    Understanding and Using Arrays
    Related Data Structures
    Basic RDMS Understanding
    Managing Data Driven Applications
    Backend Administration Design & Development
    Employability Profile Skills
    Responsible for attendance, promptness, being prepared for work, and professional appearance.

    Participates in tasks from initiation to completion and interacts with supervisor when appropriate.

    Able to self-evaluate strengths and weaknesses, accepts feedback, sets goals, and monitors progress.

    Able to work with others and contribute ideas by communicating clearly.

    Able to solve problems using a variety of strategies.

    Demonstrates ethical behavior, personal responsibility for actions, and flexibility towards change.

    Able to safely manage materials, equipment, and space by respecting workplace policies and rules.

    Able to identify the source of conflict, suggests options to resolve it, and helps parties reach agreement.

    Able to critically observe, evaluate, and understand detailed visual information.

    Able to read industry materials in a variety of formats to locate, understand, and apply information.

    Able to use mathematics for industry-related requirements.