CS 235: Spreadsheet Applications
This course involves advanced application of spreadsheets as the solution for business problems. Numerical analysis and forecasting are taught along with charting figures and utilizing spreadsheet programs for database.
- Use the V-lookup function
- Use functions associated with financial analysis
- Format spreadsheets
- Create charts
- Link worksheets
- Use absolute referencing
Student Learning Outcomes
Upon completion of this course, students will be able to:
- Analyze complex business datasets using advanced lookup and reference functions (e.g., V-LOOKUP, INDEX/MATCH) to retrieve and organize information for decision-making
- Evaluate financial health and investment opportunities by constructing dynamic financial models utilizing built-in financial functions
- Create professional, interactive dashboards that utilize advanced charting and conditional formatting to synthesize numerical data into actionable visual insights
- Design robust, multi-sheet architectures using absolute referencing and external linking to ensure data integrity across integrated business workbooks
- Apply forecasting techniques and statistical analysis tools to project business trends and perform "What-If" sensitivity analysis
- Construct efficient spreadsheet-based databases using data validation, filtering, and pivot tables to manage and query large-scale business information
General Education Objectives: When the course is completed you will be able to:
- incorporate appropriate listening techniques.
- Required & Supplemental Resources are supplied in weekly modules within Canvas. No textbook is required.
- Visit Student Portal and download Desktop version of Office 365 (Excel & Word specifically)
Incomplete Policy: Students will not be given an incomplete grade in the course without sound reason and documented evidence as described in the Student Handbook. In any case, for a student to receive an incomplete, he or she must be passing the course.
Missed Classes: As an active member of the class, your attendance is vital. You are responsible for obtaining material distributed on class days due to an absence.
Missed Tests/Quizzes: Tests to be given periodically throughout the quarter will be announced. (The instructor reserves the right to quiz announced and unannounced on lectured material; unannounced quiz cannot be made up.) Each test is taken only one time. Students will be permitted to make up one missed test. If more than one test is missed, a zero will be recorded for any additional tests not taken. The makeup schedule will be announced by the instructor.
Class Information: I can be contacted at the phone numbers listed or @huntingtonjuniorcollege.edu. I will respond to messages received between Monday 8 AM and Friday 1 PM within 24 hours. However, messages received after 1 PM Friday I will respond within 48 hours or no later than midnight Monday.
Need for Assistance: If you have any condition, such as a physical or learning disability, which will make it difficult for you to carry out the work as I have outlined, or which will require academic accommodations, please notify me as soon as possible.
| Student Evaluation | Grade Weight |
|---|---|
| Discussions | 20% |
| Participation | 15% |
| Assignments & Exams | 60% |
| Knowledge & Progress Checks | 5% |
| Total | 100% |
| Letter Grade | Percentage |
|---|---|
| A | 90-100 |
| B | 80-89 |
| C | 70-79 |
| D | 60-69 |
| F | 59-below |
(tentative and subject to change)
| Module | SLOs | Assessments |
| One - Basics & Navigating | 1 |
|
| Two - Formatting & Basic Math | 1, 2 |
|
| Three - Absolute Referencing ($) | 2 |
|
| Four - Sorting & Filtering | 1 |
|
| Five - V-Lookup | 3 |
|
| Six - Financial (PMT) | 2 |
|
| Seven - Linking Worksheet | 5 |
|
| Eight - Data Visualization | 4 |
|
| Nine - Forecasting & What-If | 6 |
|
| Ten - Integration | All SLOs |
|
Emails will be responded to no later than 48 hours or by the end of business on Monday for mail received over the weekend.
Academic Honesty Policy
The college has a firm policy against academic dishonesty, including cheating or plagiarism. Students guilty of academic dishonesty will be administratively dropped from the course with a grade of ‘F’ and subject to disciplinary action, which may include suspension and dismissal.
Please refer to the Academic Honesty Policy for detailed information.
Late Assignment Policy
Meeting deadlines, being dependable, and applying appropriate time management are all foundational elements of professional behavior. These same attributes are also required while participating in college courses because the skills, knowledge, and student learning outcomes must be obtained in a specific order and within a certain amount of time.
We at Amerion College understand that sometimes students encounter circumstances that make it difficult to always meet the required course deadlines. This Late Work Policy is in place to accommodate that. In all circumstances, whenever possible, contact your instructor when you anticipate that you will be submitting work late.
The deadlines for most courses typically follow the pattern below, but it is your responsibility to confirm this and be aware if there are any assignments that may have different deadlines for one reason or another.
The first post in each Discussion Board is usually due on the Wednesday night of each module/week.
Most other assignments are due by 11:59 pm on Sunday evening of each module/week.
- All assignments must be submitted by the required due date.
- Missing assignments due to absence must be submitted within 1 week of return.
- Late submissions of assignments will result in a reduction of 10% of the total points possible per day (e.g., 1 day late = -10%, 2 days late = 20%, etc.) up to one week. Anything over 1 week late will result in a grade of 0.
- To receive full credit for late work, students must provide documentation for an excused absence, or it will be subject to the same treatment as any other late work. Documentation examples include court documents, hospitalization, etc.
Instructors may also choose to deduct less points at their discretion.
If for some reason a student temporarily loses the ability to connect to Canvas due to technical issues it is the student’s obligation to submit assignments by the original due dates. Temporary remedies can be connecting via a public WiFi spot, using school facilities to connect, or use of private networks through friends and family.
In extreme cases, when none of these solutions are available, the student may contact their instructors through other means and ask permission to submit their work directly, in a method that can be received by the instructor. Under no circumstances can methods of delivery outside of Canvas be used without explicit instructor permission. (If this ever happens the instructor should somehow note it).
Minimum Technology Requirements
Having access to a reliable desktop or laptop is required for Amerion College online courses. This requirement ensures students have the essential technologies to complete online courses successfully. Mobile devices, such as mobile phones and tablets may be utilized as additional tools to assist with completing online courses.
Online video conferences and calls are often the best way for instructors to assist students in many situations. A web camera and microphone are necessary for successful online conferences.
Safari and Chrome: Office 365 is designed to work with the current version of the Safari and Chrome browsers. Microsoft Edge: Office 365 is designed to work with the latest version of the Microsoft Edge browser.
Internet Explorer: Office 365 is designed to work with Internet Explorer 11. We recommend that you upgrade to Internet Explorer 11 if you are using an earlier version. Office might continue to work with versions of Internet Explorer other than Internet Explorer 11, but Office can’t provide any guarantees.
Firefox: Most Office 365 apps are designed to work with the current version of Firefox.
Some courses may have additional technology requirements beyond those listed here. Additional requirements will be listed in your Canvas course room.
Basic Office 365 apps are free and available to students with their Amerion College Outlook account. For additional questions and help with the required technologies, please contact support@amerion.edu
Minimum Technical Skills Requirements
To complete online courses successfully, you must be able to perform the following basic technical skills before starting the class
- Use the learning management system, Canvas
- Use Amerion College email with attachments
- Download, save, and upload files in Canvas
For additional questions regarding the required technologies, please contact support@amerion.edu
Technology Support
To be a successful online learner, certain technologies are necessary. Please keep in mind that certain classes may have additional technical requirements. You should be able to find additional technical requirements in your syllabus or your canvas course room. If you have any questions about the technology requirement, please do not hesitate to reach out to us at 304-697-7550 or support@amerion.edu
Accessibility Information
Amerion College is committed to full compliance with Section 504 of the Rehabilitation Act of 1973, and the Americans with Disabilities Act of 1990. For additional information, please access accessibility policy. Please do not hesitate to reach out to us at 304-697-7550 or pjustice@amerion.edu if you have any additional questions.
Copyright Policy
As an institution of higher education, Amerion College strongly believes in intellectual property. As such, Amerion College respects intellectual property and has made it a priority to ensure all employees and students respect the copyrights of others. If you have any questions about our copyright policy, please access the copyright policy.
Privacy Policy
The college understands the importance of protecting your information and privacy. Our Privacy Policy provides additional information on the Family Educational Rights & Privacy Act.
Third party privacy policies:
Other Student Success Services
Please access Student Success page for other student success services information, such as financial aid, lab hours, parking, library, transcripts, and career services on the college
If you need to speak with a person regarding any college policies and guidelines, please don't hesitate to get in touch with the college at 304-697-7550
This information is standard for each course but specifics may vary based on the delivery method of the course you are taking. Please follow the information provided by your instructor.
This syllabus is subject to change.