BUSA 215 Information Science and Data Management
This course provides applied instruction using computer systems and Microsoft Office suite application software within the business environment. The course includes both lecture and hands-on learning and emphasizes practical concepts of file management; the creation of documents using word processing, spreadsheets, databases, and presentation software; use of the Internet to access an retrieve data; and how various software components work together efficiently and effectively. This course is based on hardware and software that uses the Windows operating system.
General Education Competency
[GE Core type]
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
Business & Economics
II. Course Specification
Course Type
Program Requirement
General Education Competency
[GE Core type]
Credit Hours Narrative
3.00 Credits
Semester Contact Hours Lecture
45
Semester Contact Hours Lab
0
Semester Contact Hours Clinical
0
Grading Method
Letter grade
III. Catalog Course Description
This course provides applied instruction using computer systems and Microsoft Office suite application software within the business environment. The course includes both lecture and hands-on learning and emphasizes practical concepts of file management; the creation of documents using word processing, spreadsheets, databases, and presentation software; use of the Internet to access an retrieve data; and how various software components work together efficiently and effectively. This course is based on hardware and software that uses the Windows operating system.
IV. Student Learning Outcomes
Upon completion of this course, a student will be able to:
- Generate professional looking documents by applying formatting, headers, footers, borders, shading, tabs, indentation, citation, footnotes, clip art, and mail merge.
- Produce spreadsheets ranging from formatting, functions, charting, formulat construction, and pivot tables.
- Implement databses structure ranging from design, data entry, forms, reports, and queries.
- Design presentations usuing slide show design, images, animation, themes, SmartArt, tables, charts, and video.
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. Create a company overview presentation.
Create a new product announcement presentation.
Format a presentation to add visual interest and clarity.
Enhance a presentation with WordArt and
Create a presentation that includes data in SmartArt, tables and charts.
Customize a presentation with animation and video.
VI. Delivery Methodologies
Required Assignments
8 case graders for each application
Capstone Case Grader for each application
Simulated exam for each application
Pivot Tables
Required Exams
Capstone Case Grader for each application
Simulated exam for each application
Final Project covering each application
Required Text
Office 2016 Exploring Series; Peasrson Eduction, Copyright 2017
ISBN 978-1-3234-9056-3
myITlab LMS
Specific Course Activity Assignment or Assessment Requirements
8 case graders for each application
Capstone Case Grader for each application
Simulated exam for each application
Pivot Tables
Capstone Case Grader for each application
Simulated exam for each application
Final Project covering each application
1.
2.