What This Document Is
This document contains digital notes for CSCI 1300, Introduction to Computer Science at Albany State University, covering practical applications within a spreadsheet program—likely Microsoft Excel—to reinforce fundamental computing concepts. It appears to be a collection of exercises and potential assignments designed to build proficiency in data manipulation and analysis.
Why This Document Matters
This resource is valuable for students enrolled in CSCI 1300 who need to develop hands-on skills in using spreadsheet software for data organization, analysis, and visualization. It’s intended to be used during lab sessions or as supplementary material to lectures, bridging theoretical knowledge with practical application. The exercises are relevant for anyone needing to manage and interpret data in an academic or professional setting.
Common Limitations or Challenges
This document provides a series of tasks, but it does not offer foundational instruction on *how* to use the spreadsheet software itself. Students are expected to have a basic understanding of spreadsheet interfaces and common functions before attempting these exercises. It also focuses specifically on spreadsheet-based tasks and doesn’t cover broader programming or computer science concepts in detail.
What This Document Provides
The full document includes a series of exercises focused on:
* Data sorting and filtering.
* PivotTable creation and manipulation, including using SUM, AVERAGE, and COUNT functions.
* Worksheet function application (MODE, STDDEV, VARIANCE, etc.).
* Data entry and calculation of totals.
* Chart creation for data visualization.
* Advanced spreadsheet techniques like named ranges, decision-making functions (SUMIF, IF, AND, OR), macros, and data consolidation.
* Formatting and presentation of worksheet data.
This preview does *not* include detailed step-by-step instructions for completing the exercises, nor does it provide solutions or example spreadsheets. It also does not include the survey data itself, only a reference to it.
