CISA 315 - Introduction to Electronic Spreadsheets (2024)

American River College

CISA 315 Introduction to Electronic Spreadsheets 2 Units	Section#: 12264	Class Meetings: Online- Asynchronous
Semester: Summer 2024	Session: First 8 Weeks	https://canvas.losrios.edu/ https://ic.arc.losrios.edu/~chapekc

Instructor's Information

Name: Carl W. Chapek - M. Ed.
Office Hours: Online - By Appointment

Office/Voice Mail:916-394-9397 (Personal) 916-286-3692 x12289 (ARC Voicemail)
Email: chapekc@arc.losrios.edu <preferred mode of communication>

Text and Other Required Materials:

Description:	SIMNET 365/2021 - Excel IN PRACTICE Access Code
Author:	Nordell
Edition:	22
Published Date:	2022
ISBN:	9781266783692
Publisher:	McGraw-Hill

Course Description:

StudentLearning Outcomes (SLO):

• Navigate to and from storage locations, create a new spreadsheet, open an existing spreadsheet, plus properly close and save a spreadsheet.
• Understand spreadsheet software, identify spreadsheet window components, and enter labels, values, and simple formulas into a spreadsheet.
• Revise cell and worksheet entries, choose worksheet views, and use the auto-summation feature
• Create complex formulas and functions, and round a value with a function
• Define relative cell reference and absolute cell reference, copy formulas and functions with relative and absolute cell references, and revise relative and absolute cell references formulas and functions
• Format all or portions of a worksheet using standard layouts, formats, styles, alignments, and themes
• Apply colors, patterns, borders, special number formats, and conditional formatting; as well as rename and move worksheets
• Format data using text functions, consolidate data using a formula, and identify and revise errors within formulas and functions
• Apply logical formulas such as the IF, OR and AND functions, as well as calculate payments with the PMT function
• Plan, design, create, and revise embedded as well as stand-alone charts based on commonly used standards
• Perform basic chart tasks such as selecting labels and values, choosing a chart type, and moving and resizing a chart
• Perform basic chart formatting tasks such as changing a chart's design, annotating and drawing on a chart, and inserting images and objects within a chart

IMPORTANTDATES:

Class Drop Policy: It is the student’s responsibility to notify and complete all the necessary documentation with the admissions and records office.

Class Attendance/Participation: In the following paragraphs, you will find the definition for "Excessive absences", and other attendance issues from the ARC catalogue. I will be following this rules. As for "Excessive Absences", it talks about 6% of the class hours. This class has 54 hours. 6% of 54 hours is 3.24hour. Our class time is 1hr 20min, so that is approximately 3 classes. If you miss 3 classes, you could be dropped.

Excessive absences: The Los Rios Community college District (LRCCD) attendance requirements are as follows: Per Policy P-2222, students are expected to attend all sessions of the class in which they are enrolled. Any student with excessive absences may be dropped from class. Any student who is a no show shall dropped.

Nonattendance at First Class: As stated in LRCCD Regulation R-2222, students who fail to attend the first session of a class may be dropped by the instructor.

Excessive Absence Defined: As stated in LRCCD Regulation R-2222, a student may be dropped from any class when that student’s absences exceed six percent (6%) of the total hours of class time. Instructors shall state in each course syllabus what constitutes excessive absence for that course.

No Shows: As stated in LRCCD R-2222, students who fail to attend the first session of a class may be dropped by the instructor. In addition, students who have not attended at least one of the first three sessions of a class will be dropped as a “no show” following the third session of the class per Title 5 section 58004. If a class is scheduled for only one session per week, then students who have not attended at least one of the first two sessions of a class will be dropped as a “no show” following the second session of the courses

Taken from the American River College 2023-2024 CATALOG page 40

Need for Assistance: If you have a learning disability, a physical disability, or other special needs, please let me know as soon as possible if you need special accommodations. These discussions are best handled during my office hours or by special appointment. All needs that have beenverified through the DSP&S on campus will be accommodated.

Accommodations: ARC offers equal access to programs, services and facilities so that students with disabilities have the opportunity to participate fully in campus activities. Specialized counseling services, interpreters for the deaf, tutors, note takers, readers, test facilitators, adapted computers and mobility aids are provided upon request. These services are free and the program is open all terms. Please contact the DSPS office at (916) 484-8382 / 484-8798 TTY for more information. Please bring a notification letter from the Disability Services and Programs for Students (DSPS) outlining your approved accommodations directly to the instructor as soon as possible so that arrangements can be made.

Contacting the Professor: The preferred mode is through discussion boards on the course web page so that everyone in class can participate. Question like: administrative aspect of this class (e.g. a due date), or about the grades (Not your grade specifically) go to the Open Discussion Board. Your instructor will monitor the Discussion Boards and intends to respond within 48 hours to any new question. There will be no response to questions already answered.

When you have a question, start a new thread in the Discussion Board and put the chapter and topic in the subject line. As the class progresses, there will be many posting and the “subject line” helps everyone decide whether to read a specific posting. For example, if there is a question on debits to assets, the subject line of the new thread could read: “Chapter 2 Functions”. Anyone in the class can respond to these questions. Remember, if you teach, you will learn the material better...so take a look and see if you can help someone else. Your instructor will monitor the forum and make any corrections if necessary or respond to unanswered questions.

Emails will be another way we communicate. Don’t send one to the instructor without thinking twice. Emails are not the preferred method of communicating because they take more time and other students cannot see the topic. So, this method should be limited to:

• Issues not appropriate for classmates to see (e.g. your standing in the class, grade, and enrollment issues, etc.),
• A question not answered in a Discussion Board after 48 hours,
• Requests to make up material, because of an excused absence (see attendance).

Emails must include a complete sender and subject line, and in the body, a salutation and the student’s name. All email contact must have the following subject line: CISC310-Subject. Make sure to substitute “Subject” with what you are asking about. Students may send an email when there is an issue with the grading of a quiz. If a student only wants to understand why a quiz question was marked incorrect, the student should post a question on the discussion board after the quiz has been completed by all students. If a student wants to dispute the quiz answer, send an email. If there was a mistake, it will be corrected. If a student disagrees with the answer to a question, the student should state what he/she believes the correct answer should be and why. In most cases, you should cite a knowledgeable source (text or other authority) for the different answer. A challenge based on a question being worded differently than information in the text or not found in the chapter will likely be denied because the quiz is to test your understanding of material, not your ability to find the exact words. If the instructor agrees with your dispute, then all students’ grades will be amended. If the instructor does not agree, the student can follow up only with a written letter (not an email) and the instructor will provide the mailing address for the letter. There will be no debates of quiz questions via email or discussion board posting.

Communication in an online/hybrid/or in-person course, using Canvas, is mostly written. Without non-verbal feedback during communication, it is difficult to get a complete message. Be careful in writing emails. You are writing in a “business” environment, not to a relative or close friend, and your message needs to be a professional one which includes proper grammar, spelling, capitalization and sentence structure. My communication tends to be terse and direct. When you only see it in writing, it may seem blunt...or some may say...”not nice”...but it is not personal. You will not be able to see my smile or the look of concern on my face. I will give you feedback on your progress and your work. It will not be based on your potential or your level of effort—it will be based on what you have submitted or not submitted.

Netiquette

Follow the Core Rules of Netiquette (http://www.albion.com/netiquette/introduction.html). to ensure we all behave online in an adult appropriate manner, when using the course discussions.

Academic dishonesty (cheating/plagiarism): Academic honesty is expected. Students are required to do their own work. If cheating or plagiarism occurs, a grade of zero (0) will be assigned for the assignment or exam. The matter will be referred to the Business/Computer Science (BCS) Dean and the Campus Discipline Officer for appropriate action which could include, but may not be limited to, failing the class or even being expelled from school, depending on the severity and/or number of times an issue of academic dishonesty has arisen during a student’s coursework.

Academic integrity: A more "positive" way to look at this is to define integrity instead of defining dishonesty. Academic integrity implies the following:

The grade of a particular assessment of a particular student reflects the academic performance (competency, knowledge and/or skill)

• of the student and only of the student who turn in the assessment at the time of the assessment
• following all the rules of the assessment as well as general rules already discussed in the syllabus unless otherwise stated
• using only resources (duration, open book, calculators, past assignments, etc.) that are permitted by the instructor
• If you would like to use a resource that is not permitted explicitly by the instructor, always ask first before using it, preferably before the date of the assessment so that you do not get surprised.

Lab/ClassroomPolicies:

1. No food or drinks are allowed at or under desks. All eating or drinking must be done outside the classroom and labs.
2. No typing, talking, or printing, while the instructor is lecturing. Please be courteous to your fellow students.
3. No instant messaging, personal E-mail, viewing of inappropriate material, or other non-class-related use of the Internet.
4. Cellphones must be turned OFF, or set to vibrate, before coming to class.
5. No working on assignments for other classes during lab.
6. No children or guests allowed.
7. Students are expected and required to stay focused on the assignment for each class and work cooperatively with others to facilitate the learning process for all students.
8. No software is allowed to be installed or used on PCs unless specifically authorized by the professor.
9. Students are expected to conduct themselves in a courteous and respectful manner towards their fellow students, the professor and the Instructional Assistants (IA) at all times.
10. Please be attentive and take good notes during lectures and while receiving instructions in lab. Students are expected to bring their notes to class with them each class meeting—you will need them for lab assignments!
11. Students shall follow the Instructor's and/or the Instructional Assistant's specific directions at all times.

Gradingand Homework:

CourseOutline:

Disclaimer: This syllabus is subject to change. All changes will be discussed before the changes WILL takeeffect.