BUSA 215 Information Science and Data Management

This course combines lectures and hands-on learning of Microsoft Office applications and the Windows operating system to increase productivity within business and educational environments. The course emphasizes basic to intermediate skills for word processing, spreadsheets, and databases to improve data and file management and productivity within an organization. Some discussion of how various software components work together efficiently and effectively will be addressed. Access to a PC and a basic understanding of Windows is required.

 

Credits

3 Credits

BUSA 215Information Science and Data Management

Please note: This is not a course syllabus. A course syllabus is unique to a particular section of a course by instructor. This curriculum guide provides general information about a course.

I. General Information

Department

II. Course Specification

Course Type

Program Requirement

Credit Hours Narrative

3 Credits

Semester Contact Hours Lecture

45

Semester Contact Hours Lab

0

Semester Contact Hours Clinical

0

Repeatable

N

III. Catalog Course Description

This course combines lectures and hands-on learning of Microsoft Office applications and the Windows operating system to increase productivity within business and educational environments. The course emphasizes basic to intermediate skills for word processing, spreadsheets, and databases to improve data and file management and productivity within an organization. Some discussion of how various software components work together efficiently and effectively will be addressed. Access to a PC and a basic understanding of Windows is required.

 

IV. Student Learning Outcomes

Upon completion of this course, a student will be able to:

V. Topical Outline (Course Content)

Manage files and folders, copy and move files and folders, and use the Recycle Bin. Create, save, and print a Microsoft Office 2013 document. Use the ribbon and dialog boxes to perform commands in Microsoft Office 2013. Create a flyer with a picture. Format text, paragraphs, and documents. Write a resume by using a Word table. Write a cover letter and use a template to create a cover sheet. Create a research paper that includes citations and a bibliography. Create a multiple-column newsletter and merged mailing labels. Create a sales report with an embedded column chart and sparklines. Calculate the value of an inventory. Analyze inventory by applying statistical and logical calculations to data and by sorting and filtering data. Summarize the data on multiple worksheets. Present fund data in a pie chart. Make projections by using what-if analysis and present projections in a line chart. Create pivot tables Create a new database. Create a database from a template. Sort and query a database. Create complex queries. Create forms to enter and delete records and to display data in a database. Create reports to display database information.

VI. Delivery Methodologies

Required Exams

Capstone Case Grader for each application Simulated exam for each application Final Project covering each application

Specific Course Activity Assignment or Assessment Requirements

Capstone Case Grader for each application,  Simulated exam for each application,  Pivot Tables Capstone Case Grader, and a common final project.