DATABASE ADMINISTRATOR: MANAGING CRITICAL DATA
LESSON PLAN OVERVIEW Career: Database administrator is a career in Information Technology. Database administrators use special software to store and organize data, perform capacity planning, design and configure databases, monitor performance, maintain data security, troubleshoot problems, and backup and recover data. Lesson: This lesson will introduce students to ways database administrators make decisions by analyzing large amounts of data. The lesson will challenge students to create and manage a database with significant amounts of data in Microsoft Excel. Grade Level: Middle Grades Learning Objectives: 〉 〉 〉 〉
Students will explore the role of database administrators and how they maintain large amounts of data. Students will understand the relationship between data and a database and how to analyze information. Students will create a spreadsheet to understand the collection and management of data. Students will also gain an insight into the database administration profession, including common job tasks, salary, career pathway, and credentials required to perform the job.
Materials Needed: Activity #1: Understanding Data and a Database 〉
Student Worksheet: Cartesian Planes and Quadrant Graphing
Activity #2: Creating and Managing a Database 〉 〉
TABLE OF CONTENTS Lesson Plan Overview ............. 1 Teacher Guide ......................... 2 Lesson Instructions ...................2 Class Message & Video ..............2 Class Discussion Questions ........3 Activities Overview ...................3 Career Insight ......................... 4 Standards Alignments ............. 5 Educator Rubric ....................... 6 Activity #1: Understanding Data and a Database ....................... 7 Instructions .............................7 Handouts.................................8 Activity #2: Creating and Managing a Database ............ 11 Instructions ........................... 11
Student Worksheet: Creating and Managing a Handouts............................... 12 Database Access to a computer with spreadsheet software like Microsoft Excel or Google Sheets. (If a computer is not available, students can use paper and pencil.)
Copyright © 2023 by SAI Interactive, LLC. Learning Blade & Career Blade are registered trademarks of SAI Interactive, LLC.