This course is of interest to students who want to learn the basic concepts and skills required for information management and data analysis.

Lab	In addition to classes, this course has one structured laboratory session per week.

Prerequisites: None

Availability: ⚠︎ This course is not planned to be offered in the near future.

Course Objectives

To provide students with an understanding of basic concepts and necessary skills required to use spreadsheet, database and presentation software to manage, analyze and present data.

Representative Workload

• Assignments (5) 15%
• Quizzes/Labs (9) 9%
• Midterm Exam 20%
• Final Exam 56%

Representative Course Outline

• Use Windows operating system to organize files and manage files
• Use MS-Excel software to:
• Understand the basics of electronic spreadsheets
• Process data from large multi-sheet workbooks by performing simple and/or complex calculations with built-in functions and formula
• Make decisions, find desired outcomes and graph data
• Summarize and analyze data
• Design workbooks
• Use MS-Access software to:
• Understand the basics of a database and Database Management System
• (DBMS)
• Design simple and complex queries to retrieve the desired information from a
• database
• Implement security and integrity for a database
• Design a database
• Use MS-PowerPoint to create efficient presentations
• Integrate data from more than one application (MS-Word, MS-Excel, MS-Access and MS-PowerPoint)

• Labs:
1. System Software
2. Spreadsheet I
3. Spreadsheet II
4. Spreadsheet III
5. Spreadsheet IV
6. Database I
7. Database II
8. Database III
9. Presentation Software and Integration

Notes

• Students can receive credit for only one of Computer Science 1600, the former Computer Science 2650, the former Computer Science 2801, or the former Business 2700.

Page last updated May 24th 2021