High Data Analytics and Database Design
-
Number of Credits
1
-
Estimated Completion Time
2 segments, 32-36 weeks
-
Earliest Start Date
November 2024
Pre Requisites
Procedural Programming or previous Python coding experience is recommended. If taking the course as part of the Data Science and Machine Learning Program of Study, Procedural Programming should be taken first.
Description
In this course, you will explore data and databases through the fictional pet services company Critter Sitters. By examining real-world examples, you will learn how data can tell a story and gain the skills to analyze and make decisions from it. You will also expand and apply your Python skills to data science principles, from data dashboards to statistical analysis. Additionally, you will learn about data management, including using and storing quality data and how to spot biases within it. You will uncover how to create a database, write queries, and explore strategies for securing databases. By the end of this course, you will have a foundational understanding of data and databases and the exciting career opportunities available in the data science field.
Follow the link below for the Department of Education Career & Technical Education Curriculum Frameworks:
https://www.fldoe.org/academics/career-adult-edu/career-tech-edu/curriculum-frameworks/
Segment One:
• Generating stories with data
• Considering data and bias
• Working with data in Python
• Using Pandas and Python
• Types of data visualization
• Selecting data charts
• Constructing interactive dashboards
• Calculating probabilities
• Creating probability trees
• Using basic statistic terminology
• Data sampling
• Hypothesis testing
• Cognitive bias
Segment Two:
• Database basics
• Sorting data
• Using SQL commands to query data
• Filtering data
• Grouping data
• Designing databases
• Joining and transforming data
• Foreign and primary database keys
• Best practices for SQL databases
• Data privacy
• Types of cyber attacks
• Risk assessment
Students will be required to download SQLite, a free database engine. Download instructions will be provided in the course.
Besides engaging students in challenging curriculum, the course guides students to reflect on their learning and evaluate their progress through a variety of assessments. Assessments can be in the form of practice lessons, multiple choice questions, writing assignments, projects, research papers, oral assessments, and discussions. This course will use the state-approved grading scale. Each course contains a mandatory final exam or culminating project that will be weighted at 20% of the student’s overall grade.***
***Proctored exams can be requested by FLVS at any time and for any reason in an effort to ensure academic integrity. When a proctored exam is administered to assess a student’s integrity, the student must pass the exam with at least a 59.5% to earn credit for the course.
Courses subject to availability.
Pursuant to s. 1002.20, F.S.; A public school student whose parent makes written request to the school principal shall be exempted from the teaching of reproductive health or any disease, including HIV/AIDS, in accordance with the provisions of s. 1003.42(3). Learn more about the process and which courses contain subject matter where an exemption request can be made.