CS 235: Spreadsheet Applications
Course Objectives: When the course is completed you will be able to:
- initiate the common formula functions in Excel.
- utilize appropriate advanced spreadsheet reporting features.
General Education Objectives: When the course is completed you will be able to:
- incorporate appropriate listening techniques.
How does this class apply to your career?
Microsoft Excel advanced spreadsheets is utilized for:
- Calculating budgets in the business
- Accounting worksheets such as Income Statement, Balance Sheets and Owner’s Equity
- Charting profits and forecasts with column, bar, line, or pie graphs.
Teaching Methodology: Lecture (and/or lecture reading material), and practical applications.
There is no formal textbook. All materials/information will be provided for completing this course.
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: Points are accumulated for tests and quizzes. A final comprehensive exam must be taken to complete the course. Failure to take the final exam will result in a failing grade for the course.
Grade Scale:
| Letter Grade | Percentage |
| A | 90-100 |
| B | 80-89 |
| C | 70-79 |
| D | 60-69 |
| F | 59-below |
(tentative and subject to change)
|
Week |
Subject Matter |
Assignment |
|
One |
Introduction and review of Excel |
Lab
|
|
Two |
Worksheet enhancements, create header and footer data for printing, validate ranges, create payment schedules, present and future value calculations. |
Create spreadsheets as instructed during lecture. Complete supplemental exercises for complete learning theory. Excel Computer Test for each subject matter.
|
|
Six |
Create charts and grouped worksheets for summary calculations.
Worksheet creation with Pie Chart is used for GE Assessment, Communication C: incorporate appropriate listening techniques.
Create absolute and mixed cell references and vlookup and hlookup formulas.
|
Create spreadsheets as instructed during lecture Complete supplemental exercises for complete learning theory.
Excel Computer Test for each subject matter.
|
|
Nine |
Continue vlookup and hlookup formulas |
Continue exercises with Computer Test on subject matter
|
|
Ten |
Review for final exam and Makeup Tests |
Complete review and makeup one missed test.
|
|
Eleven |
Final Exam |
Written comprehensive Final Exam
|
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.
Technology Support
To be a successful online learner, certain technologies are necessary. Please click here to review the essential technology requirements of the college. 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 1-800-344-4522 or 304-697-7550 or support@hjc.edu
Accessibility Information
Huntington Junior College is committed to full compliance with Section 504 of the Rehabilitation Act of 1973, and the Americans with Disabilities Act of 1990. For detailed information regarding the policy, please click here. Please do not hesitate to reach out to us at 1-800-344-4522, 304-697-7550 or pjustice@hjc.edu if you have any additional questions.
Copyright Policy
As an institution of higher education, Huntington Junior College strongly believes in intellectual property. As such, Huntington Junior 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 click here to access the copyright policy.
Privacy Policy
The college understands the importance of protecting your information and privacy. Please click here to access information on the Family Educational Rights & Privacy Act.
Other Student Success Services
Please click here 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 or 1-800-344-4522
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.