CURRICULUM - JACKSON CAMPUS

Application Fundamentals and Relational Databases

Part I: Application Fundamentals

Coders coding at the Mississippi Coding AcademiesLanguage: Python

Book: Gries, Paul, Campbell, Jennifer, Montojo, Jason (2013)
Practical Programming: An Introduction to Computer Science Using Python 3 (2nd Edition). Dallas, TX: The Pragmatic Bookshelf.

Modules:

  • Introduction to Programming
  • Function Design
  • Modular Program Organization
  • Decision Making and Looping
  • File IO
  • Basic Algorithm Analysis
  • Data Collection Types
  • OOP
  • GUIs

Part II: Relational Databases

Language: SQL

Book: Gries, Paul, Campbell, Jennifer, Montojo, Jason (2013)
Practical Programming: An Introduction to Computer Science Using Python 3 (2nd Edition).
Dallas, TX: The Pragmatic Bookshelf.

Modules:

  • Database Fundamentals
  • Database Design
  • SQL Basics
  • Data Sorting
  • Functions
  • Advanced SQL Operations
  • Transactions

Cumulative Project:

Application Fundamentals and Databases: CLI program managing inventory and revenue for a fictional rental agency (Python).

Essentials of Front End Development

Part III: Essentials of Front End Development

Languages: HTML/CSS/JS/jQuery

Books: Duckett, Jon (2011). HTML & CSS: Design and Build Websites.
Indianapolis, IN: John Wiley & Sons, Inc. Duckett, Jon (2014).
JavaScript and jQuery: Interactive Front-End Web Development. Indianapolis, IN: John Wiley & Sons, Inc.

Modules:

  • Web Page Construction and Structure
  • HTML Elements
  • CSS Formatting
  • Front End Process and Design
  • Basics of Programming in JavaScript
  • Document Object Model (DOM) and Events
  • Implementing jQuery
  • Asynchronous Web Development, Ajax and JSON
  • Accessing Application Programming Interfaces (APIs)

Cumulative Project:

Front End Fundamentals: Dynamic web page storefront for a fictional company (HTML/CSS/JavaScript).

Full Stack MVC Web Development

Part IV: Full Stack MVC Web Development

Framework: Django

Resources: Django Documentation.
Django Software Foundation, 2017, http://docs.djangoproject.com/en/1.10/. Accessed 01 Feb. 2017.

Modules:

  • Basics of Django and the Model Template View
  • Planning and Constructing Models
  • Mapping Data Structures
  • Site Administration
  • URL Routing
  • Creating Generic and Custom Views
  • Displaying Data with Templates
  • Building Forms

Cumulative Project:

Full Stack MVC Fundamentals: Functional web application managing a database of inventory for a fictional rental agency (Django).

Professionalism and Personal Growth

Employment Preparation

We will be continuing to work with employers to open up opportunities to allow the coders to shadow or intern at the employers’ workplace. The coders will also be working through tailored coursework to prepare them for their desired position.

Additional Coursework and Topics

Coursework: Individual and Group Projects, Online Courses (as determined by the teachers) Modules: Command Line, Version Control (Git), Unit Testing Workplace: Resume Building, Writing Reports, Public Speaking, Personal Branding

Smart Start

Students will also work through the MS Smart Start Curriculum. This is will help students with learning the soft skills aspect of MSCA.

Student work samples can be found on the website.