Information Technology 281

I. Course Title: Data Management and Analysis with Spreadsheets (GE)

II. Course Number: ITEC 281

III. Credit Hours: 3 credits

IV. Prerequisites: None

V. Course Description: 

A study of basic techniques for data analysis and management using electronic spreadsheets.  Coverage includes the study of quantitative analysis of small and large data sets using built-in functions, user defined formulas, and data visualization tools.

Note(s): General Education and Applied Learning designated course.

VI. Detailed Description of Content of the Course:

Topics include:

  1. Creating and formatting spreadsheets.
  2. Creating user inputted formulas
  3. Using built in functions
  4. Depicting data visually in multiple formats for analysis
  5. Using built in tools for summarizing, managing and analyzing large datasets

VI. Detailed Description of Conduct of Course:

Course delivery methods will include lectures, examples, and student exercises.  Exercises will focus on problem solving using specific spreadsheet techniques.

VII. Goals and Objectives of the Course:

Students who complete the course will be able to:

  1. Demonstrate the ability to efficiently solve a problem using a spreadsheet, employing where necessary the advanced features learned in the course including construction and/or using appropriate formulas and functions.
  2. Demonstrate the ability to format data using built in features such as tables, colors, conditional formatting, borders, alignment and print layout functions.
  3. Demonstrate the ability to filter, sort, summarize and analyze data sets using spreadsheet tools
  4. Demonstrate the ability to create and use custom formulas in a spreadsheet.
  5. Demonstrate the ability to provide appropriate charts and graphs of data for analysis of data.
  6. Students will be able to reflect on how the skills they learn in this class will apply to professional roles.

VIII. Assessment Measures:

At least 50 % of the course assessment will be based on actual spreadsheets produced, formatted, corrected, or extended by the students.  This may include problems solved for homework or during in-class testing.   The remainder of the course assessment can consist of more traditional tests, quizzes, papers, or presentations.  All of which will be used to measure each student’s performance.

 

Other Course Information: None

 

Review and Approval 

October 22, 2008

June 1, 2012

June 20, 2015

March 01, 2021