{"@id":"https://credentialengineregistry.org/resources/ce-34787e2a-06f7-40fe-8319-9ef0ece7e0b3","@type":"ceterms:MicroCredential","@context":"https://credreg.net/ctdl/schema/context/json","ceterms:ctid":"ce-34787e2a-06f7-40fe-8319-9ef0ece7e0b3","ceterms:name":{"en-US":"Fundamental Spreadsheet Skills"},"ceterms:image":"https://d2umcf2gmasgod.cloudfront.net/671291c513923d950566d963.png","ceterms:keyword":{"en-US":["data literacy"]},"ceterms:ownedBy":["https://credentialengineregistry.org/resources/ce-34e96e45-7ba7-4870-b3cf-055d9621d354"],"ceterms:requires":[{"@type":"ceterms:ConditionProfile","ceterms:name":{"en-US":"Open Badges Criteria"},"ceterms:description":{"en-US":"Key  Method\n\nThe educator develops and demonstrates a set of essential spreadsheet skills that allows them to analyze and present data.\n\nMethod  Components\n\nQuantitative data often come in forms that require work to make them meaningful to an educator. Spreadsheets (for instance, Google Sheets or Microsoft Excel) are probably the most critical tool for working with quantitative data as a classroom educator. Although spreadsheets offer many advanced functions that allow for powerful analyses and sophisticated display of data, educators routinely employ a specific set of spreadsheet skills when using data to drive classroom instruction.\n\nThis set includes the following 10 skills:\n\nDo basic arithmetic. Educators use spreadsheets to do basic arithmetic (e.g., find the sum of a set of numbers, find the percent correct on an assessment).\nCalculate averages. Educators use spreadsheets to report the average for a single row of data (e.g., a student's average on an assessment) or column (e.g., average performance for all students on a single item).\nTranspose data. Educators take a set of data that is oriented one direction and transpose it so that it is oriented in the other direction (e.g., transpose a set of standards listed in a column and so they display in rows).\nSort data. Educators sort data so that it is ordered in a particular way (e.g., from highest to lowest score, alphabetically by last name).\nFilter data. Educators filter data by a particular field, value, or range of values (e.g., display the scores from second period only, show scores on constructed response items only).\nPaste data as \"special\" to change its form. Educators take data in one form (e.g., from an underlying calculation) and present it in another form (e.g., as a raw value); this operation involves \"pasting special,\" or pasting data in the desired format.\nUse conditional formatting. Educators conditionally format cells to help call out patterns in the data (e.g., turn all cells with a value below 70% red).\nUse \"if\" statements. Educators write \"if\" statements to count or calculate based on a particular parameter (e.g., count the number of students who answered \"a\" on an item).\nCalculate weighted averages. Educators create overall averages that give weight to particular components more than others (e.g., calculating at a final average grade that weights homework, quizzes, performance tasks, and unit assessments differently).\nConcatenate data. Educators use the concatenate feature to merge (and manipulate) data from multiple cells (e.g., create a new column that takes the data in the column for first name and combines it with the first letter of the word in the column for last name)."},"ceterms:subjectWebpage":"https://digitalpromise.box.com/s/31chk1k09mvrgq80olb4lcdhmgbpfxne"}],"ceterms:inCatalog":"https://microcredentials.digitalpromise.org/explore/fundamental-spreadsheet-skills","ceterms:inLanguage":["en"],"ceterms:description":{"en-US":"Educator presents quantitative data in ways that enhance analyses or improve accessibility."},"ceterms:credentialId":"https://microcredentials.digitalpromise.org/explore/fundamental-spreadsheet-skills","ceterms:subjectWebpage":"https://microcredentials.digitalpromise.org/explore/fundamental-spreadsheet-skills","ceterms:copyrightHolder":["https://credentialengineregistry.org/resources/ce-34e96e45-7ba7-4870-b3cf-055d9621d354"],"ceterms:availableOnlineAt":["https://microcredentials.digitalpromise.org/explore/fundamental-spreadsheet-skills"],"ceterms:availabilityListing":["https://microcredentials.digitalpromise.org/explore/fundamental-spreadsheet-skills"],"ceterms:credentialStatusType":{"@type":"ceterms:CredentialAlignmentObject","ceterms:framework":"https://credreg.net/ctdl/terms/CredentialStatus","ceterms:targetNode":"credentialStat:Active","ceterms:frameworkName":{"en-US":"Credential Status"},"ceterms:targetNodeName":{"en-US":"Active"},"ceterms:targetNodeDescription":{"en-US":"Awards of the credential are ongoing."}},"ceterms:usesVerificationService":["https://credentialengineregistry.org/resources/ce-1472586c-b08c-4f22-9013-5b4d9a58d277"]}