Prelims Exam Pointers to Review_8f95bd7246012900cf9d72dfc650dda2.pdf

Prelims Exam Pointers to Review Date: September 25, 2024 | 7:00-10:00 AM @ Computer Lab A Part 1. WRITTEN EXAM Excel 1. Lesson 1-Introduction to Data 1. Lesson 1a-Introduction Microsoft Excel Management a....

Prelims Exam Pointers to Review Date: September 25, 2024 | 7:00-10:00 AM @ Computer Lab A Part 1. WRITTEN EXAM Excel 1. Lesson 1-Introduction to Data 1. Lesson 1a-Introduction Microsoft Excel Management a. What is Microsoft Excel a. Definitions of Data, Knowledge, b. Excel Environment Information, and Wisdom c. Must-Know Excel Terms (EXCEPT their Characteristics & d. Functions in Excel Applications in Various Fields) b. The DIKW Hierarchy 2. Lesson 2a-Formatting Cells, Cell c. Understanding Data Formats References, & Macros d. What is Data Management? a. Formatting Cells i. Definition of Data b. Conditional Formatting & Management Presets ii. Data Management Process c. Relative and Absolute in the Healthcare System References iii. Challenges of Data d. Macros Management 3. Excel Cheat Sheet – Keyboard Shortcuts 2. Lesson 2-The Data Collection Process only a. Definition to Data Collection b. Data Collection Methods c. Common Challenges in Data Part 2. LAB EXAM Collection (From 1-5 Only) d. Crafting Effective Questions Practice the following in Excel: i. SMART Framework 1. Formatting Cells ii. Things to avoid when asking 2. Conditional Formatting questions 3. Relative and Absolute Referencing 3. Lesson 3-The Data Storage Process 4. Data Validation a. Definition to Data Storage 5. Creating Formula and Using Functions b. Storage Media Types 6. Transforming a data into table c. Data Backup and Recovery 7. Sorting and Filtering d. Data Security in Storage – Security Measures e. Challenges in Data Storage f. Introduction to Databases Type of Written Exam: Multiple Choice via LENS i. Definition of a database ii. Components of a database Note: Since there are not enough computers in iii. What is DBMS? the computer lab, please bring your own laptop iv. Types of DBMS (if you have one) to use as your device for the exam.