Course Descriptions & Syllabi

Course Descriptions & Syllabi

Search Course IDs and descriptions for:

Find complete words only

Note: some or all of the courses in the subjects marked as "Transfer" can be used towards a transfer degree: Associate of Science and Arts or Associate of Engineering Science at DACC. Transferability for specific institutions and majors varies. Consult a counselor for this information.

Areas of Study | | BOFF225 syllabus




COURSE NUMBER: BOFF225
COURSE TITLE:Spreadsheet Applications
DIVISION:Business
IAI CODE(S):
SEMESTER CREDIT HOURS:3
CONTACT HOURS:60
STUDENT ENGAGEMENT HOURS:135
DELIVERY MODE:Hybrid, Online

COURSE DESCRIPTION:
This course is an introductory course designed to develop skills in creating, maintaining, printing, and sharing spreadsheets and charts. Features and functions of Microsoft Excel and Google Sheets will be introduced. Developing multiple-sheet workbooks, formatting worksheets, moving data between worksheets and workbooks, styles and templates will also be introduced.

PREREQUISITES:
BOFF130

NOTES: Students should display basic computer literacy before enrolling in the course.


STUDENT LEARNING OUTCOMES:
Upon completion of this course, students will be able to:
  • Identify the various elements of a spreadsheet. Students will create professional spreadsheets to tabulate, record, and share numeric data.
  • Compile spreadsheets with appropriate formulas and functions to accurately manipulate data.
  • Integrate visual elements, such as charts and graphs, in spreadsheets to share data.
  • Develop and present a professional spreadsheet during a mock business meeting.
  • Evaluate spreadsheets for their level of professionalism and functionality.

TOPICAL OUTLINE:
  1. Preparing an Excel workbook
  2. Inserting formulas into a workbook
  3. Formatting a worksheet
  4. Enhancing a worksheet
  5. Moving data within and between workbooks
  6. Maintaining workbooks
  7. Creating charts
  8. Adding visual interest to workbooks
  9. Preparing and maintaining a spreadsheet in Google Sheets
  10. Sharing spreadsheets and data in Google Sheets
  11. Presenting data in a professional manner

TEXTBOOK / SPECIAL MATERIALS:
Benchmark Series – Excel 2016 Level 1
Rutkosky, Rutkosky, Roggenkamp & Seguin
EMC Paradigm Publishing
SNAP 2016 Access Code

See bookstore website for current book(s) at https://www.dacc.edu/bookstore

EVALUATION:
Quizzes – 20%
Discussion Posts – 10%
Assignments – 25%
Presentation – 15%
Final Project – 30%

The following percentages will be used to determine grades:

90-100% = A

  80-89% = B

  70-79% = C

  60-69% = D

  00-59% = F


BIBLIOGRAPHY:

STUDENT CONDUCT CODE:
Membership in the DACC community brings both rights and responsibility. As a student at DACC, you are expected to exhibit conduct compatible with the educational mission of the College. Academic dishonesty, including but not limited to, cheating and plagiarism, is not tolerated. A DACC student is also required to abide by the acceptable use policies of copyright and peer-to-peer file sharing. It is the student’s responsibility to become familiar with and adhere to the Student Code of Conduct as contained in the DACC Student Handbook. The Student Handbook is available in the Information Office in Vermilion Hall and online at: https://www.dacc.edu/student-handbook

DISABILITY SERVICES:
Any student who feels s/he may need an accommodation based on the impact of a disability should contact the Testing & Academic Services Center at 217-443-8708 (TTY 217-443-8701) or stop by Cannon Hall Room 103. Please speak with your instructor privately to discuss your specific accommodation needs in this course.

REVISION:
Fall 2019

Upcoming Events