Start Term
2026-2027
Course Title
Spreadsheet Fundamentals
Course Code
TEDA1011
Course Hours
60
Course Credits
2
Description
This course teaches essential spreadsheet skills for data analysis while integrating basic statistical principles. Students become proficient in spreadsheet functionalities such as data entry, formatting, and formula use, progressing to techniques like identifying outliers, employing descriptive statistics, examining relationships between variables, and harnessing the power of pivot tables for comprehensive data summarization and analysis using spreadsheets. Through practical exercises and real-world case studies, students learn to navigate spreadsheet software effectively, analyze data sets, and derive meaningful insights, culminating in the ability to apply statistical concepts within spreadsheet environments for informed decision-making and analysis.
Upon course completion, students will be able to:
• Recognize basic functions and tools within a spreadsheet environment.
• Develop analytical reasoning by identifying and addressing data challenges methodically, applying statistical techniques to derive meaningful conclusions.
• Describe how to view, enter and edit data, including moving, copying and filling data.
• Demonstrate fundamental statistical concepts within spreadsheets, calculating descriptive statistics, and quantifying relationships between variables.
