CGS 1510C - Electronic Spreadsheet: Syllabus

CGS1510C

Electronic Spreadsheet

529546

Table of Contents

Faculty Contact Information	Methods of Instruction
Course Description	Traditional Pace Chart and Assignments
General Course Outcomes	Grading and Exam Policy
Course Prerequisites	Communication Policy
Course Attendance & Participation Policy	Other Policies and Procedures
Computer Requirements	Student Success Tips and Resources
Required Course Materials

Faculty Contact Information

Course Instructor:		Professor XXX
Office Phone:		954-201-XXX
Department Phone:		954-201 -XXX
Email:		All communication should be through the course email tool. Use my BC email ONLY if you are unable to access the course email: farchila@broward.edu
Virtual Office Hours:		I will be available live during my Office Hours when you can expect to contact me by phone or email and expect a real-time response.
BC Safety Office Phone#:		954-201-HELP (4357)

Return to Table of Contents

Course Description

This course provides hands-on applications with a spreadsheet software package. Through lecture and lab practices, students will develop skills that create, manipulate and utilize spreadsheets.

Return to Table of Contents

General Course Outcomes

The following competencies are covered in Section 1:

• Demonstrate how to plan and create a worksheet or workbook.
• Demonstrate how to format data and text.
• Demonstrate how to use functions and formulas to calculate areas of a worksheet.
• Demonstrate how to create charts and graphs from Excel data.
• The student shall be able to create tables, pivot table and pivot charts.
• The student shall manage multiple worksheets and workbooks.
• The student shall be able to create Excel applications.
• The student shall be able to apply advanced functions.
• The student shall utilize financial tools and functions in Excel.
• The student shall be able perform What-if-analysis.
• The student shall be able to connect to external data sources.
• The student shall be able to enhance Excel with Visual Basic functions.

Return to Table of Contents

Course Prerequisites

To maximize your chances for success in this course, make sure that you meet the following course prerequisites:

• Course Prerequisites and Co-requisites: None
• Computer Knowledge and Skills:
  • Students in this course should be familiar with the following computer skills.
    • File Management - You should be familiar with finding and saving files on your computer.
    • The Internet - You should be familiar with connecting to the Internet through an Internet Service Provider or Network Connection.
    • Web Browser Software - You should be familiar with using web browser software to navigate the Internet and locate information.
    • Email - You should be familiar with sending and receiving email messages.
    • Discussions - You should be familiar with posting and reading discussion messages in a threaded format.
    • Attachments - You should be familiar with sending email messages with attached files.
    • Word Processing - You should be familiar with creating, editing, saving, and printing documents using Microsoft Word.

Return to Table of Contents

Course Attendance and Participation Policy

Attendance/Withdrawal Policy:

Participation:

Regular, active, and meaningful participation is a critically important component of this course and is essential to your success. It is recommended that you log into the course several times during the week. Frequency and quality of participation may affect your success in the program.

• Active participation is expected of all students in this course.
• Check your email and course discussions regularly. Ask questions.
• Post and respond to messages.

Return to Table of Contents

Computer Requirements

To complete this course, you must have access to computer hardware and software that meets the standards listed below.

• Assignments that require word processing must be submitted in Microsoft Word format. Documents created using Microsoft Works, or files that have ".txt", ".pdf", or ".asci" extensions will not meet course requirements. If you do not have proper software on your computer, you can use the Microsoft Word program on any of the "open lab" computers at any BC Learning Resource Center or in public libraries. Please virus check documents before sending them. AVG offers a free online virus check.

Return to Table of Contents

Required Course Materials

Required Text:

New Perspectives on Microsoft® Excel® 2013, Comprehensive
With SAM 2013 Assessment, Training, and Projects v1.0 Printed Access Card

Plus Microsoft Office 365 180-Day Trial Printed Access Card
ISBN-10: 1285731301 | ISBN-13: 9781285731308

Books for online courses are available at the Central Campus bookstore
A. Hugh Adams Central Campus Bookstore
Admissions & Student Service Center - Bldg. 19
Tel: (954) 201-6830
Fax: (954) 201-6895

CourseSmart Link: New Perspectives on Microsoft Excel 2013

In addition, this course utilizes the following required software or hardware tools:

1. SAM Student Learning Management System.
   Please click here to see instructions for setting up your SAM account.

Return to Table of Contents

Methods of Instruction

This is a 3-credit hour fully online course. Normally, a 3-credit hour on-campus course would meet two times each week (during a 16 week term) for a total of 3 hours per week or 48 hours per term. This is a self paced fully online course so students will have to guide themselves accordingly. There is a pace chart included below that will show you how to successfully complete this course in a 4 week period.

• Instructions for Discussion Postings: Post your response to each topic directly in the forum topic. Do not attach files. You may draft your posting in a text editor and then copy paste it to the post. Your initial posting should be at least 2 paragraphs in length with proper grammar and spelling. Please respond/comment to at least 2 of your classmates' post. Each response should be at least 1 paragraph in length with proper grammar and spelling. "I agree with xxxxx" as a response is not a discussion.
• Instructions for Quizzes: Quizzes must be completed in SAM and BCOnline. 
• Instructions for Assignments: Assignments must be submitted in the appropriate assignment folder of a module. Emailed assignments will NOT be accepted.
• Instructions for Challenge and Evaluation Exams: Instructions are provided in each section based on the section requirements for the Challenge and Evaluation Exams. The Course Evaluation Exam must be taken at the Broward College Central Campus eTesting Center or North Campus eTesting Center.
  

Return to Table of Contents

Traditional Pace Chart and Assignments

Read and refer to this document regularly. It will tell you what assignments you should complete, and how to complete them.

Purpose

The purpose of this Pace Chart is to give students in this course an indication of how long they will on average spend to complete this course. This Pace Chart is only a guideline and depending on a students' proficiency with computers, learning style, prior knowledge of the subject and personal motivation, actual times may differ widely from the guidelines given.

Entire Course

The entire course should be completed within a six (6) week time frame. Students who can demonstrate competencies faster than the recommended time could complete the course in a four (4) week period.

Section 1

All modules in Section 1 should take at most four (4) weeks assuming at least twelve (12) hours per week are spent on each module.

Week/Section/Learning Outcomes	Learning Materials	Assignments & Assessments
Week 1/Section 1
Course Challenge
Upon successful completion of these sections, the student shall be able to: Demonstrate how to plan and create a worksheet or workbook. Demonstrate how to format data and text. Demonstrate how to use functions and formulas to calculate areas of a worksheet.	Read content for Modules 1 - 3	Complete assignments for Modules 1 - 3 Complete assessments for Modules 1 - 3 Complete discussions for Modules 1 - 3
Week 2/Section 1
Upon successful completion of these sections, the student shall be able to: Demonstrate how to create charts and graphs from Excel data. The student shall be able to create tables, pivot table and pivot charts. The student shall manage multiple worksheets and workbooks.	Read content for Modules 4 - 6	Complete assignments for Modules 4 - 6 Complete assessments for Modules 4 - 6 Complete discussions for Modules 4 - 6
Week 3/Section 1
Upon successful completion of these sections, the student shall be able to: The student shall be able to create Excel applications. The student shall be able to apply advanced functions. The student shall utilize financial tools and functions in Excel.	Read content for Modules 7 - 9	Complete assignments for Modules 7 - 9 Complete assessments for Modules 7 - 9 Complete discussions for Modules 7 - 9
Week 4/Section 1
Upon successful completion of these sections, the student shall be able to: The student shall be able perform What-if-analysis. The student shall be able to connect to external data sources. The student shall be able to enhance Excel with Visual Basic functions.	Read content for Modules 10 - 12	Complete assignments for Modules 10 - 12 Complete assessments for Modules 10 - 12 Complete discussions for Modules 10 - 12
Course Evaluation

 

Return to Table of Contents

Course Progress and Evaluations Policies

• Assignment Submissions
  • Assignment suggested deadlines are posted in the Traditional Pace Chart above. Assignments must be submitted through the course learning management system. No assignments will be accepted via email unless requested to do so.
  • If no assignments are submitted for a full week you may be contacted by your course instructor and/or advisor to make sure satisfactory progress is being made in this course.
  • Discussion postings are expected to be posted according to the Traditional Pace Chart.
• Proctored Evaluations
  • This course has one required proctored evaluations that must be taken at one of the campus e-Testing Centers or at an alternate pre-approved testing location.
  • BC e-Testing Centers are located on:
  • Central Campus Building 17 (library) Room 220, visit the Central Campus eTesting Center website to view their hours of operation.
  • North Campus Building 62 (Academic Success Center) Room 135, visit the North Campus eTesting Center website to view their hours of operation.
  • Proctor U - Online Proctored Testing.  You the opportunity to take your exams at home with online proctoring. Using a webcam and a reliable high-speed internet connection, you can take your exams anywhere. Here you will find information on utilizing this online testing application right from your work or home. YOU MUST COORDINATE THIS TEST WITH YOUR INSTRUCTOR.
  • Allow plenty of time to complete your Course Evaluation prior to the scheduled closing time of the eTesting Center. When the eTesting Centers close, tests must be submitted whether they have been completed or not. You will not be able to return to complete the test at a later date. Sundays are the busiest days so you may have to wait for a seat. Nothing is permitted in the eTesting Centers except a pen/pencil unless the instructor has provided a list of approved testing aids (i.e., textbook, calculator, headphones, etc.).  Lockers and scratch paper are provided.  See the testing center websites listed above for a complete list of rules.
  • You will need to show a BC identification card or picture ID in order to be able to take the test in the testing center.
  • Students who live outside Broward County can contact me for instructions on how to take proctored evaluations at an alternate authorized location or in an online proctored environment. There are added costs associated with these optional methods of testing and both must be pre-approved at the start of the term.
• Parking for Proctored Evaluations: Students who take only online courses (no on-campus ones) do not pay parking fees and therefore are not eligible to obtain a parking hang tag.
• Students on North can park for free at the library and make the short walk to Building 62.
• Students on both North and Central can email onlinecompdegree@broward.edu at least three days in advance of the evaluation to receive a temporary parking pass. The parking pass will be emailed to your BC email account, which you can print and place on your dashboard on the day of the evaluation.
• Online Practice Quizzes
  • These quizzes can be taken any time during the course, and may be taken via any computer with an Internet connection.
  • Collaboration between students and discussion of quiz answers are NOT acceptable.
  • You will initially only be able to attempt each quiz twice. Additional attempts will have to be released by the instructor after discussion with student. Make sure you have a solid Internet connection. If your ISP disconnects you during a quiz, that will count as an attempt.
• View your Progress
  • Online quiz and the Course Evaluation grades will be available after finishing the quiz or Course Evaluation. View "Grades" from the course homepage.
  • Feedback for assignments will be posted within 4 BC working days of the submission date of the assignment.
  • Feedback for discussion postings will be posted within 4 BC working days after completing posting to the discussion.
  • Final course grades may be obtained through students MyBC portal.
• How your Grade will be Determined

Return to Table of Contents

Communication Policy

Expectations for Course Communication

• Email: Use the email tool only for private, personal, one-to-one communication with a specific individual or groups of individuals. Please do not send course related emails to the instructor's BC email address. Solicitations will not be tolerated. Assignments sent to the instructor's BC email will notbe accepted.
  • Alternate Communication: In the event that the course communication tools are unavailable for more than 24 hours, the instructor will communicate with students (if necessary) via their BC email addresses. Access your BC email account at http://mail.broward.edu/
• Discussions: Use the Course Cafė discussion thread to post questions that might be of general interest to all students such as questions about assignments, lessons, etc. Feel free to respond to other students if you think you can help them. Proofread the content of your posts before making them public; proper grammar and sentence structure are expected. Remember that the discussion tool is public - everyone will be able to view posts and responses. See the Netiquette section below for expectations regarding appropriate behavior in online discussions.
• Faculty Response Policy: Course emails and discussion posts will be answered within 48 hours. Emails sent on Saturday or Sunday may not be answered until Monday. It is recommended that you post course-related questions in the discussion area. If you need info related to the Course Evaluation or assignment, plan ahead and submit your questions well ahead of the date you intend to complete them. Your instructor is not online 24 hours per day, so please allow time for responses.
• Chat: Chat allows you to talk with other students in the course in real-time outside of your on-campus class meetings. Students must set up times to meet other students in the chat tool. This is a useful tool for coordinating group projects.
• Netiquette: In all online communication, it is expected that all students will follow rules of online "netiquette". Netiquette is a set of rules for polite online behavior that all members of this class are expected to follow. Read some general netiquette rules here. Basically, these rules say "be respectful and be polite to each other" and "be patient," etc. No one is perfect and we all have different approaches to life, work, and school.
  
  • Individuals who violate the netiquette policy or engage in disruptive online behaviors such as flaming (posting disrespectful or hostile comments), posting inappropriate comments, or shouting (posting messages using all capitals) may have their course access privileges revoked and/or they may be referred to the Student Dean. Students who continue to engage in unacceptable online behavior after being warned, may be permanently denied access to the course and/or may receive a U for the course.
  • Please don't use email shorthand like ROTFL (rolling on the floor laughing) or BTW (by the way) - not everyone knows what these abbreviations mean. If you want to use emoticons (smileys) to convey feelings, please stick with the basics happy :-) sad :-( or wink ;-). Others are less well known and are subject to different interpretations. The idea is to be clear in your communications.
• Privacy Notice: Course access records, email postings, discussion postings, and chat room conversations will be stored. This is one more reason to make sure that your communications adhere to the netiquette policy.

Return to Table of Contents

Other Policies and Procedures

Special Needs - Students having special needs as defined by the Americans with Disabilities Act should:

• Notify the Office of Disability Services as early in the term as possible. It is the student's responsibility to contact the Disability Support Office prior to document disability prior to receiving services.
• Notify the instructor after you have contacted the Office of Disability Services so that the instructor can consult with the Office of Disability Services to discuss what reasonable accommodations would be appropriate for your situation.

Academic Honesty

• When you are given access to D2L you are expected to keep confidential your username and password and to never allow anyone else to log-in to your account. Sharing access or passwords to D2L is considered a breach of the academic honesty policy and could result in you being removed from your class. When you log-in to D2L, you do so with the understanding and agreement that you will produce your own work, complete course assignments and discussions yourself, and to take course exams, tests or quizzes without the assistance of others.

• Each student's academic work must be the result of his or her own thought, research, or self-expression. Academic misconduct includes, but is not limited to the following: cheating, plagiarism, unacceptable collaboration, falsification of data, aiding and abetting dishonesty, unauthorized or malicious interference, hacking computer property or software, and online disturbances. Please refer to the Student Code of Conduct Policy and the Student Code of Conduct section located in the Student Handbook for more information.

• Academic honesty violations will be considered a breach of policy and may result in academic penalties (zero points on the assignment/test in question, a failing grade for the course), disciplinary action, and/or referral to the Dean of Student Affairs.

Changes to the Syllabus

• The instructor reserves the right to make changes to this syllabus. In the event that changes become necessary, students will be notified through course email.

24/7 Helpdesk Information

• For year-round, 24 hour technical assistance use the information below to reach the BConline Helpdesk.
  • Phone number: 1 866 468-0009
  • Chat: https://chat.perceptis.com/c/broward
  • You can also open your own ticket online and can track any of your open help desk tickets at the BConline Support Center.

Return to Table of Contents

Student Success Tips

In order to be successful in this course, you need to be organized and manage your time well so that you can complete all assignments and assessments in a timely manner. Make sure that you do not allow yourself to procrastinate, and that you communicate with the instructor or your classmates via the Course Cafe if you have any questions on any course materials or need assistance completing any assignments.

Online Resources for Students

• Click here to access a wide variety of support resources for students enrolled in online courses, such as library services, advising and counseling, tutorials, tutoring services, disability services and more.

Return to Table of Contents

U.S. Department of Labor Disclaimer

This product was funded by the U.S. Department of Labor’s Employment and Training Administration. This product  was created by the grantee and does not necessarily reflect the official position of the U.S. Department of labor. The Department of Labor makes no guarantees, warranties, or assurances of any kind, express or implied, with respect to such information, including any information on linked sites and including, but not limited to, accuracy of the information or its completeness, timeliness, usefulness, adequacy, continued availability, or ownership

Except where otherwise noted, this work is licensed under a Creative Commons Attribution 4.0 International License.

The Academic Use of Textbook Material Disclaimer

The material contained in this course uses direct excerpts from the required textbook for this course: New Perspectives on Microsoft® Excel® 2013, Comprehensive
With SAM 2013 Assessment, Training, and Projects v1.0 Printed Access Card Plus Microsoft Office 365 180-Day Trial Printed Access Card ISBN-10: 1285731301 | ISBN-13: 9781285731308

The use of this material is authorized under the publisher's academic use license which requires the user to purchase the required textbook.