MICROSOFT ExcelWorkshop (2013)
CIS 115 (On-line Course), November 2 – December 14, 2014
INSTRUCTOR:Chris Olds
PHONE:517-796-8595FAX: 517-796-8633
E-MAIL:.
Within in JetNet’s system is preferred.
OFFICE LOCATION: William Atkinson, WA 226C (Main campus)
OFFICE HOURS:Mondays 7 to 9 PM at WA 226C by appointment only, Tuesdays 8:30 to 9 AM and Noon to 12:30 PM at JNC, Wednesdays 12:30 to 1 and 3 to 3:30 PM at WA 120 and 3:30 to 5PM at WA 226C, Thursdays 12:30 to 1 PM and 4 to 4:30 PM at HIL, and Fridays 12:30 to 4 PM online only. Other times by appointment only.
Course Description
Create business applications using the Excel® spreadsheet within the Windows® graphical user interface (GUI). This course covers basic commands, cell ranges, formulas, and mathematical , financial, and statistical functions.
PREREQUISITES
None.
OBJECTIVES
To learn the fundamentals of Microsoft Excel 2013
To learn practical procedures to create workbooks suitable for coursework, professional purposes, and personal use
TOPICS
Create and Save a New Workbook
Working with Formulas and Functions
Formatting a Worksheet
Working with Charts
Analyzing Data Using Formulas
Managing Workbook Data
Use the Spelling Checker
Preview and Print Worksheets, Close a Workbook, and Close Excel
Managing Data Using Tables
TEXTBOOK and OTHER RECOMMENDATIONS
- Microsoft Excel 2013: Introductory Illustrated Seriesby Reding/Wermers. ISBN: 978-1-285-09320-8
- Recommended: USB memory stickor SkyDrive
PREREQUISITE POLICY
A 2.0 or “C” is a passing grade. Only courses with passing grades count toward graduation. Other colleges transfer in only courses with passing grades. Many financial aid sources, including most employers, require passing grades. Additionally, earning less than a 2.0 in a class results in not being able to participate in the next level of courses in a discipline which requires this course as a prerequisite. If you attempt to register for the next course sequence and have not pass the prerequisite course, you will be dropped from that course.
ASSOCIATE DEGREE OUTCOMES
The Jackson College Board of Trustees has developed a list of essential skills which all of its associate degree graduates will enhance during their college experience. The Board has said:
“JC's goal is to prepare students to live productive and meaningful lives. Implicit in this goal are efforts to prepare students to: (a) live and work in the twenty-first century, (b) be employed in situations which will require retraining several times during a productive life, and (c) function in a rapidly changing informational society.”
ADO7—Developing: “Curiosity” by demonstrating interest in learning, and “Problem Solving” by incorporating new knowledge with old, converting complex concepts into useful personal language, and solving new problems in new contexts. Students will synthesize key elements from the course into a cohesive capstone project and by completing course assignments. (75% of students should score 70% or higher.)
GRADING PROCEDURE
The work for this course includes a capstone project, weekly class exercises (chapter-created documents), and weekly “Independent Challenge” assignments.Please see schedule for work which is expected to be submitted on a weekly basis.Remember, this is not a self-paced course; there are specific due dates. You may work ahead!
Points will be deducted for failure to follow instructions,spelling errors, incorrect answers, and incomplete work. You should double-check your work before submitting as you will not be allowed to resubmit your class exercise and Independent Challenge end of chapter assignmentsfor a higher grade.Your grade will be determined by the following criteria:
Introduction e-mail to instructor (5 points)
8 Class exercises (10 points each)
8 Homework Assignments (20 points each)
(Course work will be accepted up to one week after the due-date – any work submitted after this grace period will not be accepted. If you take advantage of the one week grace period for late work, I expect that you will get caught up and submit future work on time. The grace period should not be taken advantage of on a regular basis.
CapstoneProject (50 points)
GRADING SCALE (based on accumulated points/percentages):
94 – 100%4.064 – 69.5%1.5
88 – 93.5%3.558 – 63.5% 1.0
82 – 87.5%3.052 – 57.5%0.5
76 – 81.5%2.5below 52%0.0
70 – 75.5%2.0
CLASS EXERCISES
The class exercises for this course are the workbooks created working through each chapter/unit. You should read the detailed information provided by the authors as well as complete each step. You should save when the authors indicate. When the authors indicate you should print, you should save the file with the author’s suggested file name, and send it to me at the end of the chapter. As you work through a chapter, you may send me more than one file. (You may use a zip program or compression utility to send me multiple files.) You should double-check your work before submitting it. Compare your work with the illustrations in the book.Class exercises are graded on effort, accuracy, and completeness.You will not be allowed to resubmit your class exercises work for a higher grade. Each class exercise is worth a maximum of 10 points.(See our course schedule for due dates.)
WEEKLY INDEPENDENT CHALLENGE ASSIGNMENTS
At the end of each chapter, you will be assigned an Independent Challenge assignment. Check JetNet for our course schedulefor more details. The weekly “Independent Challenge” will be due with the class exercise for that chapter. You should double-check your work before submitting it and compare it to the illustrations in the textbook. Your work will be graded on effort, accuracy, and completeness.You will NOT be allowed to resubmit your Independent Challenge work for a higher grade.
ATTENDANCE/PARTICIPATION POLICY
Since this is an online course, I treat frequency of work submitted as attendance. Since regular attendance/participation is necessary for successful college work, work should be submitted on a weekly basis. JC email and JetNetmessages should be checked at least twice a week. Student work will be evaluated on effort, accuracy and completeness. If you miss up to one week of work, you may still submit the work for evaluation (as long as they are submitted within one week of the due date—remember work submitted over one week late will receive no points).
Attendance will be reported periodically to the Registrar’s Office during the first half of the course. Definitions include: “H”—the student is not doing acceptable work and needs “help” to be successful, “Q”—the student has not participated/attended and the instructor believes he/she has unofficially withdrawn, and “V”—the instructor “verifies” that the student is participating/attending and doing acceptable work. You will be able to verify your attendance reporting via e-services from our JC homepage.
WITHDRAWAL
Check your registration form for the withdrawal date. Students who stop attending class without completing a withdrawal form and who have not received a “Q” in the attendance reporting period, will receive a grade of 0.0. It is the student’s responsibility to withdraw from a course. You should initiate a withdrawal at the main campus Registrar’s Office or at any JC center if you cannot complete the course. You should also contact me when considering a withdrawal.
INCOMPLETES
No incomplete grades will be given in this class except under extenuating circumstances and if the student has completed at least 75% of the work and has at least 2.0 in the course. The grade of “I” is not awarded to students who did not attend, or seldom attended, or to those who simply are not pleased with their final grades. Students receiving an “I” submit only the remaining work that had not been completed at the end of the semester. Students do not redo work that had already been graded.
EXTRA HELP/CENTER FOR STUDENT SUCCESS
Tutors (plus additional services for academic success) can be accessed by calling 796-8415 or by stopping by the Center for Student Success, Bert Walker Hall Room 123.
Students requiring special assistance (including those affected by the Americans with Disabilities Act) should contact the Center for Student Success. This is the first step in acquiring the appropriate accommodations to facilitate your learning.
STUDENT RESPONSIBILITIES
The student is responsible to complete the material covered each week and submit when it’s due. The student is also responsible to initiate a withdrawal from the course if the work cannot be completed and the student does not qualify for an incomplete. Finally, the student is responsible to notify his/her instructor if he/she is going to miss any work.
AUDITS
Students who do not wish to receive a grade from the course may opt for an “audit,” which means they will not receive a grade. They may turn in their work and take tests for evaluation. Students who sign up to “audit” and now wish to receive a grade must contact the Registrar’s Office at main campus or personnel at the extension centers by the drop/add date listed on your registration form. You can also perform the audit function online at click on the e-Services link, and then to Registration.
ACADEMIC HONESTY POLICY
Academic honesty is expected of all students. No part of this course contains collaborative work! It is the ethical behavior that includes producing their own work and not representing others’ work as their own, either by plagiarism, by cheating, or by helping others to do so. While JC encourages students to collaborate in study groups, work teams, and with lab partners, each student should take responsibility for accurately representing his/her own contribution.
Plagiarism is the failure to give credit for the use of material from outside sources. Cheating means obtaining answers/material from an outside source without authorization.
Faculty members who suspect a student of academic dishonesty may penalize the student by taking appropriate action up to and including lowering the final grade by .5 and assigning a failing grade for the paper, Chapter, report, exam, or the course itself. Instructors will document instances of academic dishonesty in writing to the Dean of Faculty.
In the event of a student dispute, both student(s) and faculty should follow the Conflict Resolution Policy. This policy is presented in Student Rights and Responsibilities (student handbook) and the faculty Master Agreement.
Fall 2014
Event / Dates / NotesSemester Dates / September 2 - December 21
Classes Begin / Sept. 2 / Day and Evening Classes Begin
CIS 115 Begins / November 2
CIS 115 Ends / December 14
Holiday, No Classes / November 26 - 30 / Thanksgiving Break Offices Closed
Last day of classes / December 21
Grades Due / December 22 / 15 week or late starting 12 week courses
MS Excel Workshop (2013): CIS 115 On-Line
Tentative Class Schedule*
Week / Assignment/Homework** / Due DateWeek 1 /
Getting Started with MS Office 2013 (Unit A) & Getting Started with Excel 2013 (Unit A)
Homework: Class Exercise on pages Office 1-15 & Independent Challenge 1 on page 16. Class Exercise on pages Excel 1-17 & Independent Challenge 1 on page Excel 21.Also, explore JetNet. E-mail or send a message via JetNet to your instructor about yourself: 1). why are you taking this course, 2). what’s your major, 3). your experience with MS Excel, 4). what you hope to learn in this course, and 5). what grade you hope to earn in this course. / Friday, 11/7/2014 @ 12:00 Noon
Week 2 /
Working with Formulas & Functions (Unit B) &Formatting a Worksheet (Unit C)
Homework: Class Exercises on pages Excel 25-41 & Excel 51-69, Independent Challenge 1 on page Excel 45, Independent Challenge 1 on page Excel 73-74. / Friday, 11/14/2014 @ 12:00 NoonWeek 3 /
Working with Charts (Unit D) &Analyzing Data Using Formulas (Unit E)
Homework: Class Exercises on pages Excel 79-95 & Excel 105-121, Independent Challenge 1 on page Excel 100, Independent Challenge 1 on page Excel 125. / Friday, 11/21/2014@ 12:00 Noon
Week 4 /
Managing Workbook Data (Unit F) &Managing Data Using Tables (Unit G)
Homework: Class Exercises on pages Excel 129-145 & Excel 153-169, Independent Challenge 1 on page Excel 149, Independent Challenge 1 on page Excel 173. / Friday, 12/5/2014@ 12:00 Noon
Week 5 / Capstone Project
Homework: See JetNet for details. / Friday, 12/12/2014
@ 12:00 Noon
*Schedule is tentative and may be modified during the semester
**All work submitted must be clearly identified with the assignment name, and step number/page number as necessary. You will need to zip/compress some assignments.
***No class exercises will be accepted one week beyond its due date. Please frequently check JetNet for weekly information and tips.If you take advantage of the one week grace period for late work, I expect that you will get caught up and submit future work on time. The grace period may not be taken advantage of on a regular basis. If you do submit three or more assignments within the grace period for late work, each future assignment will receive a 10% deduction for each week that it is late.
Class Exercises and Independent Challenge assignments are due as indicated above. Assignments will be evaluated on effort, accuracy, and completeness.
1
Excel (Online)