I_CSCI_2033_290_26464_201520: Excel Excel jan 12 – mar 8
Tulsa Community College: NEC Spring 2015 - Online
TEACHING METHODS / COURSE PURPOSE / COURSE STRUCTURE / ACADEMIC DISHONESTYCONTACT YOUR PROFESSOR / CONTACT THE DIVISION OFFICE
Professor: Logan Phillips / Division Dean: / Mr. Patrick Green
Phone: / 918-595-7451 / Division Name: / Business and Information Technology
E-mail: / / Phone Number: / 918-595-7439 / Office Number: / NEC 2372
Office: / dM-TH 8:30 – 300 or by appointment
You may email me about anything. I answer email within 24 hours. If you email me and let me know a time when you would like for me to telephone you, I will do my best to contact you at that time (day or evening).
Unless your question is personal, it is more constructive to use the Water Cooler Forum on the course site. This gives other students the opportunity to learn from your question. More importantly, often your classmates will have a unique perspective on your question.
COURSE PREREQUISITE & MINIMAL TECHNICAL SKILLS:
The prerequisite for this course is CSC1203-Computer Concepts. This course requires a prior introduction to Basic Computers.
Course Pre-requisite: The prerequisite to this course is CSC1203-Computer Concepts or instructor approval. This course requires a prior introduction to Microsoft Office. This is not an introductory course. Specifically, the student must know how to use the Windows Explorer to manipulate (save, copy, delete, and move) files, have basic Internet skills, and an introductory knowledge of the Microsoft Office Suite.
Next Suggested course(s):
Microsoft Word, Access, PowerPoint, Network Fundamentals, Introduction to Computer Programming. Please a counselor for direction concerning your educational career.
COURSE DESCRIPTION:
As a student in this course, you will learn the most important topics of Microsoft Office Excel 2013. Limited prior computer knowledge is assumed.
This course provides an in-depth coverage of the concepts and techniques required to use a spreadsheet to express, analyze, and solve business-related problems and to assist in the preparation for the Microsoft Office Specialist Excel expert exam. Prerequisite: CSCI 1203 or instructor approval.
TEXTBOOK AND OTHER MATERIALS
Textbooks: / Microsoft Office 2013 (In Practice) Excel Complete (BOOK PURCHASE IS OPTIONAL)ISBN: 978-0-07-748691-4
Software: / SimNET to purchase:
https://secure.decasoftware.com/SimNet/NewRegistration.aspx?subdomain=TULSACC
SimNet if you have a code
https://tulsacc.simnetonline.com/Students/Registration/Registration.aspx
Students MUST purchase. Follow the above links register for the software, then follow instructions on blackboard to register your course.
Microsoft Office 2013: Excel 2013, Word 2013, and Windows Operating system 7 or 8. Students may download Microsoft Office 2013 Free from Blackboard’s Student Resources tab. Students are invited to complete their assignments at the Microcomputer Labs located on each of TCC’s campuses. All files are submitted in a zip format.
Hardware: / A USB drive and an up-to-date PC Computer are required. Although students with a MAC computer system have successfully completed the course, the instructor does not have access to a MAC computer system.
Textbooks/Software can be purchased from the bookstore at NE Campus or Online from the NE Campus, or purchased directly from SimNet.
Bookstore Link
PURPOSE OF THE COURSE
BUSINESS APPLICATION SPECIALIST PROGRAM GOALS:
This is a comprehensive Excel course designed to meet the goals established by the TCC Information Technology workforce development advisory committee. This course is designed to prepare business professionals and information managers with the diversity of computer technology and applications software skills needed (1) to complete business tasks and projects efficiently and profitably, (2) to collaborate and connect to vital business resources, (3) to use Excel with an executive focus, and (4) to prepare for the Microsoft Business Application Specialist Exam.
COURSE OBJECTIVES:
A. Students who successfully complete this course will:
Syllabus Page 2
1. Communicate effectively in the course using terminology and concepts related to Excel.
2. Format financial reports
3. Create worksheets that record and analyze data
4. Chart financial data
5. Construct tables, PivotTables and Pivot Charts
6. Manage multiple worksheets and workbooks
7. Use advanced functions, conditional formatting, and filtering
8. Apply functions and create custom formats
9. Integrate Excel with other Windows programs
10. Use financial tools and functions
11. Perform what-if analyses
12. Import financial data from external sources
13. Expand Excel with Visual Basic for Applications
Syllabus Page 6
B. Relationship of Objectives to Assessments:
· The Discussion Board questions are designed to enhance the student’s ability to utilize Excel terms and concepts in written communication.
· The purpose of the multiple-choice exams is to verify the student’s mastery of terms and concepts that are necessary for discussing Excel worksheets in a realistic business environment and for building a knowledge base that will allow students to complete business tasks with Excel efficiently and profitably.
· The intent of the Projects is to enhance the students’ understanding of soft skills such as decision making and problem-solving and to provide practice in applying them appropriately in real-world, professional situations that involve financial spreadsheets.
· The course has been designed to guide the student into becoming a self-learner with the ability to learn any financial spreadsheet application software quickly. Software applications used in business vary, and versions change frequently. The ability to “learn on your feet” is a necessity in today’s workplace.
STRUCTURE OF THE COURSE
TEACHING METHODS:
1. Assignments: All assignments are accomplished using the SimNet website.
· For each SimPath you will have a Pre-Test, Guided Practice, and Post Exam
· In addition to the SimPath you will have guided projects. These are accomplished on the SimNet website
· Each SimPath contains suggested videos, or further instruction on blackboard. These are optional, but can be used to enhance learning.
· Assignments are graded by the professor (not a computer program). In order to give each assignment the attention it deserves and the student adequate feedback, a minimum of five days are needed to complete the grading process.
2. Discussion Board: For each TutoSimPath(chapter), a Forum has been established on Blackboard’s Discussion Board. You may earn three points by posting a response that thoroughly addresses the question and demonstrates satisfactory time and thought and by responding to another student’s post. Students are expected to display tolerance for others’ views on the Discussion board forum and through e-mails. Comments and language should be respectful and appropriate for a college community.
3. Exams: Three unit exams will be given. Completing the SimPaths proves the student’s mastery of Excel’s techniques and procedures. The purpose of the exams is to prove the student’s knowledge of terminology and concepts. The exams will be timed so it is important that the student not only knows the material but also knows it well enough to move quickly through the exams. The exams consist of multiple-choice questions and application based questions.
4. Water Cooler Forum: If you have a question about the course site or an assignment, you may post the question to the Questions and Answers Forum on the Discussion Board. I will monitor this Forum to assure you receive a speedy response.
5. Cumulative Exam A comprehensive exam will be provided. Test is given online using SimNet website.
EVALUATION:
1. Letter grades will be determined using a standard percentage point evaluation: A = 100%-90%, B = 89%-80%, C = 79%-70%, D = 69%-60%, and F = below 59%.
2. There are 1170 points available in the course.
Grading Scale:
Grading ScaleA / 1053 / - / 1170
B / 936 / - / 1052
C / 964 / - / 935
D / 702 / - / 963
F / 0 / - / 701
*Please note that the grading scale is subject to change.
REQUIRED EMAIL ADDRESS:
All TCC students receive a designated outlook email address. All communications to you about TCC and course assignments will be sent to this address. Information can be found at http://www.tulsacc.edu/office365/students.
COMPUTER ACCESS:
It is highly recommended that you have regular (daily) computer access, preferably a home computer with broadband Internet access. This course can be completed using the computers at TCC. Computers at other public-access areas may not have the complete version of Excel installed. Be aware that using public computers may create a hardship. All course requirements remain the same whether your computer access is public or private (home).
LATE ASSIGNMENTS:
All Assignments are due the final Tuesday of class at 11:59:59pm. No assignments will be accepted after this time. No exceptions.
If students are not participating, due dates may be instituted to encourage course completion.
ACADEMIC DISHONESTY:
1. The cornerstone for intellectual achievement is academic integrity. Tulsa Community College recognizes that academic honesty is the vital key to a student’s true intellectual growth and ultimate personal satisfaction and success.
2. Academic dishonesty or misconduct is not condoned nor tolerated at campuses within the Tulsa Community College system. Academic dishonesty (cheating) is defined as the deception of others about one’s own work or about the work of another.
a. Assignments: Each student is expected to complete assignments individually and independently. Students may NOT work together on the same computer and submit duplicate assignments. Two or more students completing an assignment and turning in multiple copies, all represented either implicitly or explicitly as individual work will be considered copying.
b. Exams: Students may use their textbook and class notes when taking an online exam. However, collaborating with another individual will be considered cheating.
c. Copying and cheating are serious offenses and may be punishable by failure either on the exam or the assignment, or failure in the course. For more information, refer to the "Academic Dishonesty" policy in the Student Conduct Handbook, and the document entitled “Academic Integrity” in Blackboard’s Course Information area.
ATTENDANCE:
To be successful in this course, frequent participation is important. New material may be added for an assignment or material may be updated when an assignment is made. You should check the course site several times a week.
1. The last date of attendance will be considered to be the date of the last correctly submitted assignment.
2. Assignments are expected to be submitted, and exams are expected to be taken by the target dates on the course agenda. If a student misses two target dates, they are considered to have an excessive absence and will be subject to Administrative Withdrawal.
3. Non-attendance of this course does not constitute official withdrawal and may result in a grade of “F.”
4. To request a change to Audit (A) or Incomplete (I), the student must be maintaining a passing grade. To withdraw from the class or to change from Credit to Audit, the student should initiate an official withdrawal through the Counseling Office at any TCC campus. . Students who stop participating in the course and fail to withdraw may receive a course grade of “F,” which may have financial aid consequences for the student.
Never Attended: ‘WN' grade will be assigned if you do not make contact with your instructor within the first week of class
INSTITUTIONAL STATEMENT:
Each student is responsible for being aware of the information contained in the TCC Catalog, TCC Student Handbook, Student Code of Conduct Policy Handbook, and semester information listed on the class schedule. All information may be viewed on the TCC website: www.tulsacc.edu
GENERAL EDUCATION GOALS:
Tulsa Community College graduates value cultural diversity, ethical behavior, and the unique role of public education insustaining a free society. The following general education goals function independently and in concert.TCC graduatesdemonstrate:
Communication Skills- effective written, oral, visual, technological, and interpersonal interactions.
Critical Thinking-aestheticand qualitative reasoning for creative inquiry, analysis, synthesis, and evaluation ofinformation, both abstract and concrete.
Empirical Skills- problem solving and quantitative reasoning in support of scientific and mathematical concepts.
Teamwork- the ability to collaborate in support of shared purposes and goals.
Personal Responsibility- choices and actions that recognize consequences and exhibit ethical decision-making.
Social Responsibility- the ability to evaluate one’s own ethics and traditions in relation to others and to embrace thediversity of human experience while engaging local, regional, and global communities.
DISABILITY RESOURCES: It is the policy and practice of Tulsa Community College to create inclusive learning environments. Accommodations for qualifying students in compliance with the Americans with Disabilities Act (ADA) and Section 504 of the Rehabilitation Act are available. To request accommodations, contact the Education Access Center (EAC) at or call (918) 595-7115 (Voice). Deaf and hard of hearing students may text (918) 809-1864.
SYLLABUS CHANGES:
Occasionally, changes to the syllabus may be necessary. Students will be notified of any changes to the syllabus on Blackboards Announcement Page.
Course Withdrawal:
The deadline to withdraw from a course shall not exceed3/4 the duration of any class. Check the TCC Academic Calendar for the deadline that applies to the course(s). Begin the process with a discussion with the faculty member assigned to the course. Contact the Advisement Office at any TCC campus to initiate withdrawal from a course ('W' grade) or to change from Credit to Audit. Withdrawal and/or change to an audit from a course after the drop/add period can alter the financial aid award for the current and future semesters. Students may receive an outstanding bill from TCC if the recalculation leaves a balance due to TCC. Students who stop participating in the course and fail to withdraw may receive a course grade of “F,” which may have financial aid consequences for the student. Non-attendance does NOT constitute withdrawal from the class. Students must formally withdraw. The responsibility is yours!
Notice:
It is a violation of the law to create unauthorized duplicates of copyrighted microcomputer software. Tulsa Community College makes every effort to support these copyright agreements and does not support illegal duplication of copyrighted material.