Advanced Digital Competence in Information and Data Search and Management

TEACHING UNIT 1. ADVANCED STRATEGIES FOR SEARCHING, SELECTING, AND VERIFYING INFORMATION USING DIGITAL TOOLS 1. APPLICATION OF SEARCH OPTIMIZATION PARAMETERS 1.1 How Search Engines Work 1.2 Logical or Boolean Expressions/Operators 1.3 Advanced Search 1.4 Saving Search Criteria 2. USING SEARCH ENGINES IN SPECIFIC DATABASES AND OTHER INFORMATION SOURCES 2.1 Subject-specific databases 2.2 Other specialized information sources 2.3 Assessing objectivity, accuracy, and rigor 2.4 Comparing information sources to find clear and reliable content TEACHING UNIT 2. LEADERSHIP IN ORGANIZING INFORMATION AND DATA WITH DIGITAL TOOLS 1. PLANNING A STRATEGY FOR MANAGING A TEAM’S FILES AND FOLDERS 1.1 Automating Backups 1.2 Defining Storage Spaces 1.3 Organization and Naming Conventions. 1.3 Defining permissions for ownership, editing, and viewing files and folders. 1.4 Restricting access to files and folders 2. MANAGING RELATIONAL OR DOCUMENT-BASED DATABASES 2.1 Organizing a database 2.2 Data Relationships 2.3 Data Entry and Storage 2.4 Data Retrieval and Processing (Additions, Deletions, and Modifications) 3. ORGANIZING GROUP WORK STRUCTURES IN THE CLOUD 3.1 Shared Drives 3.2 File Organization and Permissions 3.3 Managing Large Amounts of Information LEARNING UNIT 3. MASTERY OF DATA ANALYSIS, EXPLOITATION, AND VISUALIZATION USING DIGITAL TOOLS 1. APPLICATION OF COMPLEX FUNCTIONS TO PROCESS AND TRANSFORM DATA 1.1 Combining Formulas and Functions 1.2 Text Functions 1.3 Database Functions 1.4 Logical and Conditional Functions 1.5 Statistical functions 1.6 Financial functions 1.7 Spreadsheet functions 1.8 3D functions 1.9 Use of subtotals 1.10 Goal Seek and detecting and auditing formulas 2. CREATING INTERACTIVE DATA VISUALIZATIONS 2.1 Charts with Different Styles 2.2 Representing Margins of Error 2.3 Representing Trends 2.4 Data Visualization Tools: Microsoft Power BI, R, Qlik, Tableau 3. SELECTING AND PROCESSING DATA FROM DIFFERENT SOURCES 3.1 Obtaining data from websites, using services or applications 3.2 Dashboards 3.3 Business intelligence tools 3.4 Web analytics 4. SETTING UP ALERTS, CONTROLS, AND CUSTOM FILTERS 4.1 Creating, modifying, and deleting alerts 4.2 Data control systems 4.3 Creating custom filters