Course Policies and Syllabus for APA1711_502B: Computerized Spreadsheets This is an accelerated course. Be mindful of weekly due dates. Instructor: John Allen Fortner CPA ,CGMA Title: Professor Office: Daytona Campus Building 200 Room 415 Office Hrs: See Posting in Class Shell under News Phone: 386-506-3990 Fax 386-506-4492 Email: See my name under Classlist inside our course in Falcon Online Department Homepage: http://www.daytonastate.edu/CampusDirectory/DeptInfo.aspx?dept=BUS Course Description: APA 1711 is an introduction to using computerized spreadsheets for beginning spreadsheet students. This course includes worksheet commands, functions, formulas and design, printing and filing worksheets. Additionally, simple macros, graphing and database functions are introduced. Although this is a skills course which emphasizes learning a software, you will need to apply the skills you learn to problem solving in a business environment. (FA, SP) (3 Credit Hours) Minimum Technical Requirements Students enrolled in this course must be able to: Use all required features of Falcon Online such as discussion boards and the Dropbox Use internet programs specifically designed for this course. Send and receive attachments by e-mail Access to Microsoft Office including the following programs: Excel, Word, and Access. Student Learning Outcomes: Upon completion of this course, the student will be able to: 1. Create, modify, and utilize worksheets for many types of businesses. 2. Develop formulas, functions, data tables, amortization schedules, multiple worksheets, macros, what-ifanalyses, and charting and data validations for business problems. 3. Apply what-if analysis, charting, and data validation to business problems. 4. Import data and work with Pivot Charts, Pivot Tables, and trend lines to improve communication of financial information. 5. Integrate Excel functions by completing a comprehensive projects. Class Format: This is a 100% online course. In this class, it is Very Important to work through ALL the SAM Assignments listed in Content. This is a skills based course, and the book was carefully selected to provide you with a chapter-by-chapter tutorial of the software you are learning. Prior to taking this course, you should have some experience working with computer software, Internet, and basic keyboarding skills. Taking a course via distance learning is somewhat different from your typical classroom experience. This course is designed to provide you with various tools by which to meet the course objectives. You will participate in different forms of interaction with your instructor and fellow students with the convenience of working in your own surroundings much of the time. All assignments, discussions, and quizzes are designed to meet the Student Learning Outcomes of this course. Online discussions will replace in-class discussions and are a very important part of this course. Our online classroom is provided and serviced by Falcon Online http://www.daytonastate.edu/falcononline and students will utilize MindTap learning system via Falcon Online to complete all graded assignments for this course except weekly discussions.
Page 1 of 11
Required Textbook(s) and/or Materials: Purchase one of the following: 1. Shelly Cashman MS Office 365 & Excel 2016 W/Mindtap Access) by Freund. ISBN-13: 9781337353083 from the bookstore. 2. Purchase MindTap access code which includes an eBook (Shelly Cashman MS Office 365 & Excel 2016 Freund)—from the Cengage Publishing for direct from publisher pricing directly from this link: http://www.cengagebrain.com/course/1-23L2RP3
For Option 1: Here is a link to access the Follett Daytona State college bookstore. Daytona State College
NOTE: Cengage Publishing offers a 14 day trial period access to MindTap which will be accessed from within your APA1711 course in Falcon Online. This 14 day trial period will allow you to begin work on day 1 of the course, if you haven’t purchased your textbook.
Optional Materials: None Equipment and Supplies: Students are required to have:
Computers will need to be compatible with the MindTap program. [A list of internet technical settings (and instructions for setting them) can be found within the online class under Content in Falcon Online.] To check whether your computer meets the requirements for using MindTap, go to http://ng.cengage.com/static/browsercheck/index.html Please Note: the System Check is also accessible in the drop down box next to your name located in the upper right corner of your MindTap page. Internet access (as this in a fully online course). Note: Chromebooks may have difficulty working with the MindTap program used in this course. Daytona State College has computers on all campuses with high-speed Internet access and Microsoft Office 2016 programs (Word, Excel, Access, and PowerPoint).
Classroom Policies Disclaimer: Teaching policies and regulations for this course are not open for discussion or negotiation. This syllabus has been constructed to be as complete as possible but is by no means a binding document. I reserve the right to alter policies, procedures, and the syllabus as needed. Please utilize the website regularly as any changes to the syllabus will be posted there. How to proceed through the course: To be successful in this course, students should plan to have three hours of study time per week for each credit hour of class time (which equates to 9 hours of study time 3 hours x 3 credit hours).
Page 2 of 11
APA1711 is organized in MindTap according to Chapter and Due Date. All the graded assignments for the week will be completed in MindTap with the exception of participation and sign-in points. By following the detailed Class Schedule at the end of the syllabus, students will stay on target with course assignments and due dates. Handling of assignments: This course uses Falcon Online for discussion posts. All other assignments will be completed in MindTap. Assignments will not be accepted via email. See the “Course Schedule” on page 11 of the syllabus for a detailed schedule that includes due dates, late periods, and expected feedback dates. To access Falcon Online: http://daytonastate.edu/falcononline. Communication: With an online course, there are several communication tools available. Stuck on an assignment, need clarification on a deadline, lost in the syllabus? Post these types of o Questions to the Discussion Board as other may be having the same issues. Within the Discussion Forums, the instructor as well as fellow students will help answer the questions. Typical response time is within 48 hours (with the exception of holidays and weekends). Unexpected delays or question that is personal in nature: Issues that are personal in nature may be addressed by email, phone call, or office visits. Email response time is generally less than 48 hours (with the exception of holidays and weekends). The email address to use for contacting your instructor is the one attached to our online class. o Select Classlist within Falcon Online, scroll down to select your instructor’s name, and then scroll back up to select the Email option. o It is best to also CC yourself to retain copies of correspondence. Then you will know that the email was successfully sent. My office phone number is located at the beginning of the syllabus. Note my office hours if you call at the end of the week. Your message may not be received until the following Monday. (Meaning there may be a longer response time). Open office hours are available (and some by appointment, if accommodations are needed) to students each week. My office hours can be found under Content in Falcon Online below your syllabus. Daytona State offers tutors and assistance via the Academic Support Center. Student Interaction and Attendance Policy: Students should post/interact often in the discussion forum. Your interaction may assist other students and you may find assistance from other students. Students are expected to check in a minimum of four (4) days a week to stay current on Course News, Discussions and MindTap graded assignments. General discussions are for posting questions about course and assignments, syllabus, and the self-introduction. Late Work/Make-up Work and Exams: SAM Excel Training for each chapter assignments: the time period closes on the due date for each of the chapters SAM Excel Training. There is not a late period for the SAM Excel Training assignments for each chapter. SAM Projects for each chapter assignment: there are set due dates for MindTap SAM Projects for each chapter and the comprehensive projects. The MindTap system doesn’t allow late work. Classroom Etiquette: Within the online class, students should be courteous and respectful in their postings. The discussion forums replace classroom discussions, but the environment remains the same. Be professional in your writings using spellcheck and not texting lingo. Postings should not be derogatory in nature towards students, assignments, or class. Postings that do not meet the classroom etiquette standards will be removed from the discussion board. See Online Protocols on page 13 of the syllabus for greater discussion of online course etiquette.
Page 3 of 11
Evaluation/Assessment Methods CLASS PARTICIPATION/ATTENDANCE (worth 42 points): For each chapter that you successfully complete all of the assignments in a timely manner, you will receive 3.8 points per chapter. This will be entered at the end of the semester. MindTap REGISTRATION AND SIGN UP (worth 10 points): Students are required to register and sign in to MindTap by March 23nd. MindTap: SAM CHAPTER TRAININGS (worth 308 points): There will be a MindTap: SAM Training for each chapter. MindTap: SAM creates a simulated training session that walks through each aspect of the chapter. It presents the chapter material as tasks. Each task within the SAM Trainings is presented as follows: Intro: This provides a brief written overview of the task. Observe: Demonstrates the task being completed. Practice: Allows the students to complete the task with the help of guided directions. Apply: Provides the task and has the student complete based on knowledge of the lesson. (This is the required step in each task.)
Students are required to complete the assignment before they can complete the MindTap: SAM End of Chapter Project. The training assignments are expected to take students 45 minutes per chapter. There are set due dates for each chapter’s MindTap: SAM Training. See Class Schedule in the syllabus for specific dates. There are no late periods for these trainings for each chapter.
MindTap: SAM End of the Chapter Projects (worth 450 Exams): There will be a MindTap: SAM Chapter Project for each chapter. This project will have students apply concepts and skills learned in the chapter and in the SAM Training assignments. Students are required to complete the assignments in Excel 2016. All computers on campus have Excel 2016 loaded on them. There are 3 attempts on each project. The project instructions will be downloaded from inside each chapter’s MindTap: SAM Chapter Project along with the data file students will need to complete the project. The completed project will be uploaded back into the chapter’s MindTap: SAM Chapter Project link. There are set due dates for each chapter’s MindTap: SAM Chapter Project. See the Class Schedule for the specific dates. There are not late periods for the SAM: Chapter Projects. MindTap: SAM Capstone Projects (worth 190 points): There will be two MindTap: SAM Capstone Projects during the semester. These projects will have students apply concepts learned at selected points in the semester. Capstone Project 1 covers chapters 1-3 and Capstone Project 2 covers chapters 4-7. Students are required to complete the assignments in Excel 2016. All computers on campus have Excel 2016 loaded on them. There are 3 attempts on each project. Page 4 of 11
The project instructions will be downloaded from inside each MindTap: SAM Capstone Project along with the data file students will need to complete the project. The completed project will be uploaded back into the MindTap: SAM Captstone Project link. There are set due dates for each MindTap: SAM Capstone Project. See the Class Schedule for the specific dates. There are not late periods for the SAM: Capstone Projects.
Grading Policy COURSE GRADING Possible Pts Earned Points MindTap: SAM Trainings (11 x 28 pts each) (SLO 1, 2, 3) 308 MindTap: SAM Chapter Projects (10 x 45 pts each) (SLOs 1, 2,3,4 and 5) 450 MindTap: Capstone Projects (2 x 95 pts each ) (SLOs 1, 2, 3 and 5) 190 Weekly Class Participation ( 7 weeks x 6 pts) 42 ______ MindTap Sign-up and Registration 10 TOTAL POINTS POSSIBLE 1000 To calculate your grade for a category, take the earned points and divide by the Total Points. For example, if total earned points for the MindTap Chapter Trainings were 220, the grade for the MindTap Chapter Trainings would be 220 divided by 308 or 71%. Overall grades will be determined based on the following criteria: Letter Grade Definition Grade Point Value Point Range A Excellent 4.0 900-1000 B Good 3.0 800-899 C Average 2.0 700-799** D Poor 1.0 600-699 F Failure 0.0 0-599 **Students must receive a grade of “C” or better in all courses to meet BAS degree completion requirements.
INCOMPLETE POLICY An incomplete grade will NOT be given UNLESS the following criteria are met: A request in writing is submitted to the instructor prior to last three weeks of class, All assignments, term paper, and quizzes were completed at that point in time, The student has a grade C or higher at that point in time.
Page 5 of 11
Spring 2017 Course Schedule: Week
Wk 1Mar. 20
Wk 2Mar. 27
Wk 3Apr. 3
In Falcon Online: 1. Complete Self Introduction under Discussions and 2. Read over syllabus and other instructions under Content 3. Register and sign-in into MindTap via the link under Content.
In Textbook: Read Chapters 2 and 3
In Textbook: Read Chapters 4 and 5
Required Activity for Weekly Topic
Items that close during the current week
In Falcon Online: Self-Introduction: Post your Introduction (found under Discussions) In MindTap: 1. Register and Sign-in to MindTap
Self-Introduction Due by Mar. 20 Registration and Sign-in to MindTap is due by Mar. 22
2. Open and begin completing: -Chapter 1 MindTap:SAM Training -Chapter 1 MindTap: SAM Chapter Project
In MindTap: Open and begin working with: 1.) Chapter’s 2 and 3 MindTap:SAM Training
In MindTap: 1. Chapter 1 MindTap: SAM Training Closes Mar. 30 2. Chapter 1 MindTap: SAM Project Closes Mar. 31st
2.) Chapter’s 2 and 3 MindTap: SAM Chapter Projects
In Falcon Online: Read all posts including announcements, discussions, and class e-mails. Post tips that may be useful to your classmates.
In MindTap: Open and begin working with: 1.) Chapter’s 4 and 5 MindTap:SAM Training
In MindTap: 1. Chapter’s 2 and 3 MindTap: SAM Training closes Apr. 6 2. Chapter’s 2 and 3 MindTap: SAM Project closes Apr. 7
2.) Chapter’s 4 and 5 MindTap: SAM Chapter Projects
In Falcon Online: . Read all posts including announcements, discussions, and class e-mails. Post tips that may be useful to your classmates.
Page 6 of 11
Wk 4Apr. 10
Wk 5Apr. 17
In Textbook: Read Chapters 6 and 7
In Textbook: Read Chapters 8 and 9
In MindTap: Open and begin working with: 1.) Chapter’s 6 and 7 MindTap:SAM Training
In MindTap: 1. Chapter’s 4 and 5 MindTap: SAM Training closes Apr. 13 2. Chapter’s 4 and 5 MindTap: SAM Project closes Apr. 14
2.) Chapter’s 6 and 7 MindTap: SAM Chapter Projects
In Falcon Online: . Read all posts including announcements, discussions, and class e-mails. Post tips that may be useful to your classmates.
In MindTap: Open and begin working with: 1.) Chapter’s 8 and 9 MindTap:SAM Training 2.) Chapter’s 8 and 9 MindTap: SAM Chapter Projects
In MindTap: Open and begin working with: 1.) Chapter’s 10 and 11 MindTap:SAM Training
Wk 6Apr. 24
In Textbook: Read Chapters 10 2.) Chapter 10 MindTap: SAM Chapter and 11 Project
In MindTap: Open and begin working with: 1.) Mindtap: SAM Capstone Project 1 Wk 7May 1
Wk 8May 8
2.) Mindtap: SAM Capstone Project 2
In MindTap: 1. Chapter’s 6 and 7 MindTap: SAM Training closes Apr. 20th 2. Chapter’s 6 and 7 MindTap: SAM Project closes Apr. 21st In Falcon Online: Read all posts including announcements, discussions, and class e-mails. Post tips that may be useful to your classmates. In MindTap: 1. Chapter’s 8 and 9 MindTap: SAM Training closes Apr. 27 2. Chapter’s 8 and 9 MindTap: SAM Project closes Apr. 28 In Falcon Online: Read all posts including announcements, discussions, and class e-mails. Post tips that may be useful to your classmates. In MindTap: 1. Chapter’s 10 and 11 MindTap: SAM Training closes May 4th 2. Chapter 10 MindTap: EXAM closes May 5th In Falcon Online: Read all posts including announcements, discussions, and class e-mails. Post tips that may be useful to your classmates. In MindTap: 1. MindTap: SAM Capstone Project 1 closes May 9th 2. MindTap: SAM Capstone Project 2 closes May 10
MindTap Assignments are automatically graded. Grades will be converted once they go into Falcon Online. Class Withdrawal Process: The last day to withdraw from this course is April 24. For Instructions on Withdrawing from a class, visit Drop a Class. Guideline for what constitutes Dropping versus Withdrawing can be reviewed at How to Register (Drop/Add/Withdraw) for Classes Online Page 7 of 11
Student Rights & Responsibilities Students are responsible for reading and following all college policies outlined in the Student Handbook. Some of the most important are summarized below. The Handbook can be accessed at http://www.daytonastate.edu/academics.html under “Student Resources.” Academic Integrity In order to preserve academic excellence and integrity, the College expects you to know, understand, and comply with the Academic Integrity Policy, which prohibits academic dishonesty in any form, including, but not limited to, cheating and plagiarism. Grades conferred by instructors are intended to be, and must be, accurate and true reflections of the coursework actually produced and submitted by you. Cases of suspected academic dishonesty may be reported to the Judicial Affairs Office for resolution. Assignments suspected of academic dishonesty will earn a grade of F or may be referred to Judicial Affairs (per the professor’s discretion). Honor Pledge : I, as a member of the DSC community, pledge that I will neither give nor receive
unauthorized aid in my work nor will I present another’s work as my own, nor will I tolerate anyone who does. For more information on academic integrity, view Honor Code. See the Student Handbook. Daytona State College is committed to providing you with quality instruction, guidance, and opportunities for academic and career success by fostering academic excellence in a supportive and personalized learning environment. Maintaining high standards of academic honesty and integrity in higher education is a shared responsibility and an excellent foundation for assisting you in making honorable and ethical contributions to the profession for which you are preparing. In order to preserve academic excellence and integrity, the College expects you to know, understand, and comply with the Academic Integrity Policy, which prohibits academic dishonesty in any form, including, but not limited to, cheating and plagiarism. Grades conferred by instructors are intended to be, and must be, accurate and true reflections of the coursework actually produced and submitted by you. All cases of suspected violations of the Student Code of Conduct, including academic dishonesty, are reported to the Judicial Affairs Office for resolution. Forms of Academic Dishonesty Cheating- Cheating can be defined as: receiving or giving unauthorized assistance on a quiz, test, exam, paper, or project or unauthorized use of materials to complete such; collaborating with another person(s) without authorization on a quiz, test, exam, paper, or project; taking a quiz, test, or exam for someone else or allowing someone else to do the same for you. Plagiarism -Plagiarism can be defined as: submitting work in which words, facts, or ideas from another source are used without acknowledging that the material is borrowed whether from a published or unpublished source. For specific information on how to document information from other sources, students should check with their instructors, academic departments, or a recognized writing manual, such as the MLA or APA. Self-plagiarism -Recently the idea that students can plagiarize themselves has surfaced. When students turn in the same assignment for two different classes, they are self-plagiarizing. This rule also applies to sections of an assignment. Not only does ‘repurposing’ assignments deny students the opportunity to learn, but also it is not fair according to the college’s standards. Because of this, self-plagiarizing is coined ‘Double-dipping,’ which leads to devaluation of grades and therefore, a devaluation of the College. Daytona State College prohibits self-plagiarism. Page 8 of 11
Online Academic Integrity Violations -These violations include, but are not limited to the following: sharing your Falcon Online password, working on an assignment with someone else when it is supposed to be done on your own, looking at someone else’s work while taking a quiz or exam, using a cell phone to share quiz or exam information, revising a paper that was found on the Internet, or submitting a paper purchased form a website. Fabrication -Fabrication can be defined as: listing sources in a bibliography that one did not actually use in a written assignment; presenting false, invented, or fictitious data/evidence in a written assignment. Other Academic Misconduct: Other Academic Misconduct might include, but is not limited to: In a testing situation, conduct, such as, looking at a classmate's test, talking to a classmate, or leaving the classroom without the instructor's or proctor's permission. Obtaining help while taking online tests or quizzes in the form of another person consultation, Googling for answers, texting, or using other social media. Obtaining part or all of a test by theft/purchase, OR selling /giving part of all of a test to someone else. Soliciting someone to impersonate you online or in a classroom setting. Entering an office or building for the purpose of changing a grade on a test, assignment, or in a grade book or for the purpose of obtaining a test. Altering or attempting to alter academic records of the College which relate to grades; being an accessory to same.
Academic Support Services Students with Disabilities: The Student Disability Services (SDS) Office provides tools and resources to students with documented disabilities. Students who self-disclose a documented disability and provide the required documentation to the SDS Office can receive confidential and reasonable accommodations to assist in their academic success. If you need accommodations, please contact the SDS Office at (386) 506-3238. To call Florida Relay dial 7-1-1, or the appropriate toll-free number: 1-800-955-8771 (TTY), 1-800-955-8770 (Voice). You can also find more information at http://www.daytonastate.edu/sds. Veterans: If you are currently serving or have ever served in the U.S. Military, please feel free to visit the Veterans Center in the Lenholt Student Center (Bldg. 130, room 124) for any assistance or phone 386.506.3065. Please visit http://www.daytonastate.edu/admsvet/ The Division of Library and Academic Support provides the following unlimited services to students via tuition and fees at the time of registration. Academic Support Center: The Academic Support Centers (ASC) assist students on every campus to achieve their potential by providing the resources they need to become successful, independent learners. For more information please go to http://www.daytonastate.edu/asc/ or email [email protected]
Writing Center: For assistance with all stages of the writing process please visit the Writing Center (appointments recommended) www.daytonastate.edu/cwc Library and Research Services: The Daytona State Library offers many types of resources to support your research materials and assistance. www.daytonastate.edu/library Page 9 of 11
Technical Support is available for FalconMail, printing, web usage, Faclon Online, and more. Students may call 386-5063950 or e-mail [email protected]
Safety on Campus: Check your FalconMail after you register for information on accessing and updating your free Daytona State College Rave Alert account. You can also visit http://www.getrave.com/login/daytonastate.
ONLINE PROTOCOLS Protocols are the correct procedures for doing things. We need them for this class so that everyone knows what is expected of them, and so that everyone plays by the same rules.
Virtual Classroom Expectations The following ground rules will help your work in this course to go much more smoothly. Please carefully review these expectations and follow them. 1. Academic integrity will be appraised according to the student academic behavior standards outlined in the Daytona State College Student Handbook. Keep up with the reading. Make sure you keep up with your online discussions and utilize our online classroom’s tools. 2. Work with others. You are encouraged to form study groups (online and/or in person), and participate in the Graded Discussion Forum. 3. Network Acceptable Use Policy: Be certain to familiarize yourself with the College's policies governing the usage of your online account. You must view this document located at http://www.daytonastate.edu/commons/rightsresponsibilities.html
News, e-mail from your instructor, and discussion forums When you sign into the classroom, check the class news on the front page. Important announcements will appear there. Also, check your e-mail for messages from your instructor. 1. Check the News, read all discussion posts and check your e-mail every time you sign in. You should sign in at least five days a week. 2. Be patient. Do not expect an immediate response when you send a message. Generally, two days is considered a reasonable amount of time to receive a reply. 3. Always put APA1711 in the subject line and your FULL NAME in the body of the message. 4. Be courteous and considerate. Being honest and expressing your position thoroughly is very important, but being considerate of others online is just as important as in the classroom. 5. Make every effort to be clear. Online communication lacks the nonverbal cues that fill in much of the meaning in face-to-face communication. 6. Do not use ALL CAPS. This is considered “shouting” and the message is very hard to read. Check spelling, grammar, and punctuation (you may want to compose in word processing software then cut and paste the message into the discussion or e-mail). 7. Break up large blocks of text into paragraphs and use a blank line between paragraphs. 8. If you have a question regarding the course material, post the question in the Discussion Forum under the appropriate chapter/topic. Other students will appreciate seeing the question and your instructor’s answer. Students are encouraged to respond to other students’ questions. Learning by teaching is a powerful tool. 9. Never assume that your e-mail can be read by no one except yourself; others may be able to read or access your e-mail. Never send or keep anything that you would not mind seeing on the evening news. 10. Please keep all postings professional. Correct grammar and spelling are an important part of the business environment. Review your comments before you post them. Write as though you were sending the correspondence to an officer of your company. Page 10 of 11
ONLINE COURSE MAP Please take a few minutes to read about the many features within Falcon Online, our online classroom. Using all these features will help you succeed in the course! Access to each feature is easy within Falcon Online, just click the link. CONTENT – This is where you’ll find our Syllabus, Instructor Office Hours, Login link for MindTap, and Chapter PowerPoints for the course. DISCUSSIONS – The discussion forum takes the place of our classroom discussion and interaction. Go here to ask me questions about the course content or assignments, or talk with other students. CLASSLIST – This is where you’ll find the students enrolled in the course. You will also see the instructor listed. To email someone, check the box next to the person’s name and then scroll up to select “Email” at the top of the list. The email associated with our online course is FalconMail. You will need to check your FalconMail several times a week as that is where I will be sending emails. GRADES – Check your progress in the course. Only you can see your grades. MAIL –Select Mail and FalconMail to access the email for this course.
Page 11 of 11