Spreadsheet Software and Data Fundamentals

Issued by Southern Illinois University Edwardsville

Earners of the Spreadsheet Software and Data Fundamentals credential demonstrated understanding of spreadsheet software and data fundamentals including data entry, data analysis, and data functions.

Type Validation
Level Foundational

Skills

Data Analysis
Data Entry
Data Fundamentals
Spreadsheet Functions
Spreadsheet Software

Earning Criteria

Assessments include quizzes and a final project. Data entry assessments include data structure and proper recording; spreadsheet applications; shortcut keys; calculator functions; freezing panes. Data analysis assessments include average, median, minimum, maximum, and variance calculations; functions; creating plots. Data function assessments include spreadsheet ribbon; $ancor; VLOOKUP; sort, filter and subset; column and row removal; formatting times and dates; cleaning individual data.