MAT 1400: Computer Mathematics
05/01/2025 to 05/30/2026 • Modified 04/28/2025Course Description
This year-long project-based course helps students understand the programming and logic behind computers and software. All assignments are related to the Excel spreadsheet, which uses VBA (Visual Basics for Applications), the programming language of Excel and other Office programs. The student will explore different aspects of computer programming utilizing built-in options of Excel and the manipulation of mathematics operations and principles. The course will incorporate biblical principles and philosophy that point to God as Creator and the order and logic that He continues to exhibit in His creation.
Next Start Date*
Next Monday
Program Restrictions*
- ESD: Elementary School Diploma (ESDP-ESD-D) Excluded
- MSD: Middle School Diploma (MSDP-MSD-D) Excluded
Prerequisite Requirements*
Any of the following:
- All of the following:
- MAT 0901 previously completed with a minimum grade of D
and - MAT 0902 previously completed with a minimum grade of D
or - MAT 0901 previously completed with a minimum grade of D
- All of the following:
- MAT 0901 previously completed with a minimum grade of D
and - MAT 0905 previously completed with a minimum grade of D
and - MAT 0906 previously completed with a minimum grade of D
or - MAT 0901 previously completed with a minimum grade of D
- All of the following:
- MAT 0902 previously completed with a minimum grade of D
and - MAT 0903 previously completed with a minimum grade of D
and - MAT 0904 previously completed with a minimum grade of D
or - MAT 0902 previously completed with a minimum grade of D
- All of the following:
- MAT 0903 previously completed with a minimum grade of D
and - MAT 0904 previously completed with a minimum grade of D
and - MAT 0905 previously completed with a minimum grade of D
and - MAT 0906 previously completed with a minimum grade of D
or - MAT 0903 previously completed with a minimum grade of D
- All of the following:
- MAT 1001 previously completed with a minimum grade of D
and - MAT 1002 previously completed with a minimum grade of D
or - MAT 1001 previously completed with a minimum grade of D
- All of the following:
- MAT 1001 previously completed with a minimum grade of D
and - MAT 1005 previously completed with a minimum grade of D
and - MAT 1006 previously completed with a minimum grade of D
or - MAT 1001 previously completed with a minimum grade of D
- All of the following:
- MAT 1002 previously completed with a minimum grade of D
and - MAT 1003 previously completed with a minimum grade of D
and - MAT 1004 previously completed with a minimum grade of D
or - MAT 1002 previously completed with a minimum grade of D
- All of the following:
- MAT 1003 previously completed with a minimum grade of D
and - MAT 1004 previously completed with a minimum grade of D
and - MAT 1005 previously completed with a minimum grade of D
and - MAT 1006 previously completed with a minimum grade of D
or - MAT 1003 previously completed with a minimum grade of D
- MAT 0900 previously completed with a minimum grade of D
or - MAT 1000 previously completed with a minimum grade of D
High School Diploma Requirements*
- Contributes 1 credit to LUOA – Mathematics, Mathematics Requirement.
Schedule
Module 1: Calculation, Estimation, & Interpretation
- Week 1: An Introduction to Computer Mathematics
- Week 2: Programmers – Translators of Computer Language
- Week 3: Algorithms
- Week 4: Users, Programming, and Functions in Excel
- Week 5: Bits, Bytes, and Making Decisions
Module 2: Statistics
- Week 6: Variables
- Week 7: Data, Percentages, and Calculations
- Week 8: More on Percentages and Data
- Week 9: Data, Correlations, and Quarter 1 Exam
Module 3: Macros
- Week 10: Macros
- Week 11: More on Macros
Module 4: Business as Usual
- Week 12: Big Business
- Week 13: Binomial Function Project
- Week 14: Business and Marketing
- Week 15: Marketing and Module Test
Module 5: Personal Finances
- Week 16: Personal Finances and Budgeting
- Week 17: Personal Finances and Credit
- Week 18: Credit and Quarter 2 Exam
Module 6: Patterns & Randomness
- Week 19: Patterns and Randomness
- Week 20: Coding and Cryptography
- Week 21: Intelligent Design
Module 7: Modern Programming
- Week 22: Modern Programming
- Week 23: Flowcharts
- Week 24: Sorting
- Week 25: Searching
Module 8: Advanced Data Issues, Processing, & Integration
- Week 26: Data Types and Investigations
- Week 27: Data Processing and Quarter 3 Exam
Module 9: Data Integration & Programming
- Week 28: Data Integration
- Week 29: Pseudocode and Programming
Module 10: Animation, Data, & the Internet
- Week 30: Animation
- Week 31: Inputting Data
- Week 32: The Internet Classroom
- Week 33: Library Functions, Boolean Logic, Loops, and Module Test
Module 11: Case Studies & Quarter 4 Exam
- Week 34: Case Study One
- Week 35: Case Study Two
- Week 36: Quarter 4 Exam