BUSN 1370 Syllabus
BUSN 1370 - Spreadsheet Applications
3 Credit Hours
This course is designed to develop skills with spreadsheet software. Use and design of spreadsheets for practical business applications and business problem-solving will be an integral part of this course.
Upon successful completion of this course, students will: create and edit spreadsheets of varying complexity format cells, columns and rows as well as entire workbooks in a uniform and attractive style analyze numerical data and project outcomes to make informed decisions plan, research, create, revise and publish worksheets and workbooks in varying formats demonstrate the ability to take numerical data and create meaningful information to solve problems and create “what if” scenario
No course pre-requisites or co-requisites are required. However, basic file management and minimal familiarity with the elements of the new Microsoft Office interface are required knowledge for this course and are included at the beginning of the textbook. These chapters will not be covered within the course. It is highly recommended that students review these chapters as they will give a foundation for what will be expected in this course.
- Preparing an Excel Workbook
- Inserting Formulas in a Worksheet
- Formatting an Excel Worksheet
- Enhancing a Worksheet
- Moving Data within and between Workbooks
- Maintaining Workbooks
- Creating Charts and Inserting Formulas
- Adding Visual Interest to workbooks
- Advanced Formatting Techniques
- Advanced Functions and Formulas
- Working with Tables and Data Features
- Summarizing and Consolidating Data
- Complete installation of Microsoft Excel 2013
- Internet Access
- Installation of SNAP. We will be viewing Tutorials and taking Concept and Skill Exams online using Snap Training and Assessment. SNAP is a web- based program offering an interactive site for learning Microsoft Excel 2013.
SNAP is a web-based training and assessment system that optimizes learning and skill development for students. SNAP tests and strengthens YOUR skills in the actual Microsoft Office applications.
Attention Mac user: SNAP 365 is a way to use SNAP 2013 without having Office installed on your computer. SNAP 365 is an access code you enter into our SNAP system and is good for 180-days from activation. It converts your learning experience to one similar to using a PC. All skills-based exams, all Grade It assignments - everything can be done live in the application. *Note: SNAP 365 requires a separate purchase of SNAP Web-Based Training and Assessment for Microsoft Office 2013 but you do not need Microsoft Office loaded on your computer.
Textbooks, Supplementary Materials, Hardware and Software Requirements
Please visit the Virtual Bookstore to obtain textbook information for this course. Move your cursor over the "Books" link in the navigation bar and select "Textbooks & Course Materials." Select your Program, Term, Department, and Course; then select "Submit."
Each student must have a SNAP activation code. This code comes in a pamphlet with your book if you purchase it through the bookstore. It can also be purchased separately at http://paradigm.emcp.com/computer-technology/snap-2016-web-based-training-and-assessment.html. You only need one SNAP code for all your courses using SNAP.
Minimum hardware requirements can be found here.
Minimum software requirements can be found here.
Common applications you might need:
Purdue OWL Online Writing Lab (for APA, MLA, or Chicago style)
The Writing Center Online Writer's Handbook
- Technical support information can be found on the TN eCampus Help Desk page.
- Smarthinking virtual tutoring is available FREE of charge. to access Smarthinking, visit the course homepage and select Smarthinking under Course Resources. You also view sample sessions to see what Smarthinking offers and how it works.
- Information on other student issues or concerns can be located on the TN eCampus Student Resources page.
Please see "Instructor Information" in the Getting Started Module for instructor contact information, virtual office hours, and other communication information. You can expect to receive a response from the instructor within 24-48 hours unless notified of extenuating circumstances.
Participation, Assessments, & Grading
All tests will be completed online and they will be timed. There will be Concept Exams (multiple choice) and Skill Exams (skill-based). There will be an online Final Exam but no midterm exam. Your Final Exam will consists of 2 parts. First a Concept Test which will cover the major concepts explained in the book and in the Key Words and Concepts files. This will be a multiple choice and matching exam. The second part will be a Skills Exam. This exam will test your Excel skills in the program. Both will count 50% of your Final Exam grade. The Final Exam is not proctored.
Student grades will be based on Discussion Questions, Tutorials, Concept exams and Skill Exams completed each week. At the end of the semester a Final Exam will be given.
Percentage Assigned Grade
|Week 1||Do you have your SNAP code and book? Did you take the Pre-Test? Did you take the Attendance Verification test? Did you post an introduction to the class in the discussion area?|
|Week 2||Level 1 Chapter 1 Preparing an Excel workbook|
|Week 3||Level 1 Chapter 2 Inserting Formulas in a worksheet|
|Week 4||Level 1 chapter 3 Formatting an Excel Worksheet|
|Week 5||Level 1 Chapter 4 Enhancing a Worksheet|
|Week 6||Level 1 Chapter 5 Moving Data within and between Workbooks|
|Week 7||Level 1 Chapter 6 Maintaining Workbooks|
|Week 8||Fall Break or Spring Break – NO ASSIGNMENT|
|Week 9||Level 1 Chapter 7 Creating Charts and Inserting Formulas|
|Week 10||Level 1 Chapter 8 Adding Visual Interest to Workbooks|
|Week 11||Level 2 Chapter 1 Advanced Formatting Techniques|
|Week 12||Level 2 Chapter 2 Advanced Functions and Formulas|
|Week 13||Level 2 Chapter 3 Working with Tables and Data Features|
|Week 14||Level 2 Chapter 4 Summarizing and Consolidating Data|
|Week 16||Take Final Exam online|
Students are required to log into this course in D2L each week and answer discussion questions and to check for messages from the instructor. Students are also required to log into their SNAP account at snap2013.emcp.com and complete the tutorials, concept and skill exams for each module. Students are expected to communicate with the instructor as a learning resource, students must check the course bulletin board frequently for announcements, and students must actively participate during class.
Late assignments except for documented medical or military reasons are not accepted and will receive a grade of zero. I understand you will have some circumstances beyond your control so I will drop the lowest grade of 1 Skill Exam and 1 Concept Exam. You will have about one week to turn in your assignments so late assignments should not be a problem. If you have a wedding, military service, or some other planned event during this semester you can always complete assignments early. If your computer is not working, that is NOT an acceptable reason. Every student must have access to a computer to complete the assignments. It is your responsibility to have access to a computer with the correct software loaded on it.
Course Ground Rules
The following two statements (1., 2.) were derived from the TBR System-wide Student Rules document, released January 2012:
RULES OF THE TENNESSEE BOARD OF REGENTS STATE UNIVERSITY AND COMMUNITY COLLEGE SYSTEM OF TENNESSEE SYSTEMWIDE STUDENT RULES CHAPTER 0240-02-03 STUDENT CONDUCT AND DISCIPLINARY SANCTIONS
1. Standards of Conduct:
- Students are required to adhere to the same professional, legal and ethical standards of conduct online as on campus. In addition, students should conform to generally accepted standards of "netiquette" while sending e-mail, posting comments to the discussion board, and while participating in other means of communicating online. Specifically, students should refrain from inappropriate and/or offensive language, comments and actions.
- In their academic activities, students are expected to maintain high standards of honesty and integrity. Academic dishonesty is prohibited.
Such conduct includes, but is not limited to:
- an attempt by one or more students to use unauthorized information in the taking of an exam
- to submit as one's own work, themes, reports, drawings, laboratory notes, computer programs, or other products prepared by another person,
- or to knowingly assist another student in obtaining or using unauthorized materials.
Plagiarism, cheating, and other forms of academic dishonesty are prohibited.
Students guilty of academic misconduct, either directly or indirectly through participation or assistance, are subject to disciplinary action through the regular procedures of the student’s home institution. Refer to the student handbook provided by your home institution to review the student conduct policy.
In addition to other possible disciplinary sanctions that may be imposed, the instructor has the authority to assign an "F" or zero for an activity or to assign an "F" for the course.
Other Course Rules:
Students are expected to:
- Participate in all aspects of the course
- Communicate with other students
- Learn how to navigate in Brightspace
- Keep abreast of course announcements
- Use the assigned course management (Brightspace) email address rather than a personal email address
- Address technical problems immediately:
- Observe course netiquette at all times.
Guidelines for Communications
- Always include a subject line.
- Remember without facial expressions some comments may be taken the wrong way. Be careful in wording your emails. Use of emoticons might be helpful in some cases.
- Use standard fonts.
- Do not send large attachments without permission.
- Special formatting such as centering, audio messages, tables, html, etc. should be avoided unless necessary to complete an assignment or other communication.
- Respect the privacy of other class members
- Review the discussion threads thoroughly before entering the discussion. Be a lurker then a discussant.
- Try to maintain threads by using the "Reply" button rather starting a new topic.
- Do not make insulting or inflammatory statements to other members of the discussion group. Be respectful of other’s ideas.
- Be patient and read the comments of other group members thoroughly before entering your remarks.
- Be cooperative with group leaders in completing assigned tasks.
- Be positive and constructive in group discussions.
- Respond in a thoughtful and timely manner.
The Tennessee Virtual Library is available to all students enrolled in TN eCampus programs and courses. Links to library materials (such as electronic journals, databases, interlibrary loans, digital reserves, dictionaries, encyclopedias, maps, and librarian support) and Internet resources needed by learners to complete online assignments and as background reading will be included within the course modules. To access the Virtual Library, go to the course homepage and select the Virtual Library link under Course Resources.
Students with Disabilities
Qualified students with disabilities will be provided reasonable and necessary academic accommodations if determined eligible by the appropriate disability services staff at their home institution. Prior to granting disability accommodations in this course, the instructor must receive written verification of a student's eligibility for specific accommodations from the disability services staff at the home institution. It is the student's responsibility to initiate contact with their home institution's disability services staff and to follow the established procedures for having the accommodation notice sent to the instructor.
The instructor reserves the right to make changes as necessary to this syllabus. If changes are necessitated during the term of the course, the instructor will immediately notify students of such changes both by individual email communication and posting both notification and nature of change(s) on the course bulletin board.
The information contained in this syllabus is for general information purposes only. While we endeavor to keep this information up-to-date and accurate, there may be some discrepancies between this syllabus and the one found in your online course. The syllabus of record is the one found in your online course. Please make sure you read the syllabus in your course at the beginning of the semester. Questions regarding course content should be directed to your instructor.