CISA 315: Introduction to Electronic Spreadsheets
Spring 2024 1st 8 weeks (2 Units, course codes 10560/10561
Lecture: Online
Lab: Online
Professor Damon Antos' contact information
Phone:
916-484-8252
Web site: https://ic.arc.losrios.edu/~antosd/
Email: antosd@arc.losrios.edu
Office Location: STEM 314 (faculty offices)
Spring 2024 Office Hours: Mon: 11:00am-11:30am (virtual), Tue: 4:00pm-5:20pm (office), Wed: 11:00am-11:30am (virtual)

Course Description

This course introduces professional electronic spreadsheet skills that cover the entire spreadsheet production process. Topics include basic skills such as creating a worksheet, entering data, adding formulas and functions, formatting the worksheet, and checking for errors. This course also introduces similar skills essential to creating professional charts from a worksheet. These skills include planning and creating a chart, formatting a chart, summarizing data with sparklines, and identifying data trends.

Course Advisory: CISC 100 (Computer Fundamentals with Hands-on Lab) or CISC 300 (Computer Familiarization)

Required Textbook:

All textbook content is provided at no cost by the instructor within the Canvas LMS for the class. Most of the content is derived from Beginning Excel 2019 by Noreen Brown; Barbara Lave; Hallie Puncochar; Julie Romey; Mary Schatz; Art Schneider; and Diane Shingledecker is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.

The forementioned textbook is not used in its entirety, and addtional readings and resources are provided with attribution within the Canvas LMS.

CISA 315 Textbook image

Student Learning Outcomes

Upon completion of this course, the student will be able to:

Evaluation and Grading

Quizzes and exams must be taken by the date specified in the course lesson plan. If you know ahead of time that you will need to miss a quiz or exam, arrangements may be made for you to take it early. Additionally, it is understood that at some time during the course an absence is unavoidable, perhaps resulting in a missed quiz. Therefore, the lowest activity, exercise, and quiz scores will be dropped from final grade calculations.

Unless specified otherwise, Activities and Exercises are due by midnight on the date specified in the course lesson plan. Late assignments will be severely penalized. Occasionally, assignments are reviewed during lecture on the due date; and frequently, assignments depend on work to be completed in prior assignments. If work is completed late on an assignment, it may result in a dependent assignment to be late as well. For this reason I strongly discourage late assignments by deducting 10 points for each 24 hour period (or fraction thereof) that it is turned in late.

For classes with a lab component, particularly for hybrid sections with an abbreviated lab period, you might not have enough time to complete your lab assignment during the lab portion of the class. Plan to spend some non-class time to complete it. Additional lab hours are available on campus. During certain times of the day some areas of the Business & Computer Science Lab are reserved for classes, so be sure to check the Open Lab Schedule for information concerning BCS Lab availability.

The grade in this course will be determined by student performance in several areas, and will be weighted as described in the following charts. Extra credit points will occasionally be given in quizzes, exercises, or the final examination.

Each student is evaluated on a number of different dimensions throughout this class:

Grade Assessment Weighting
Quizzes
6 best of 7@30 points each
(180 points) 18.0%
Activities
13 best of 14@20 points each
(260 points) 26.0%
Exercises
8@40 points each
(320 points) 32.0%
Final Examination (240 points) 24.0%
Total Points 1000 points

Grade Assignment by Total Points
Points Obtained Total % Grade
Assigned
900+ 90% A
800+ 80% B
700+ 70% C
600+ 60% D
less than 600 below 60% F

Students are responsible for checking the accuracy of all of their own assignment scores on the class website. If there is a posted score appears to be incorrect, please notify the instructor within three days. If a score is not posted within one week of the due date for any submitted assignment, notify the instructor. Final scores will be posted within five days of the last final exam, and official class grades will be posted within ten days of the end of the term.

Attendance and Participation

All absences in this class are considered unexcused. All students are given the opportunity the drop the lowest grades for most assignments, thus accommodating last-minute sickness or emergencies.

Class participation is required in both face-to-face and on-line sections of this class. During the face-to-face portion of class, attendance will be taken at the start of each class meeting, and again at the end of the daily class activity. Students not present at the end of the day's class activity will not receive credit, and may be considered absent for that day.

Excessive absences may result in withdrawal from this course. LRCCD (Regulation R-2222) specifies that "a student may be dropped from any class when the student's absences exceed six percent (6%) of the total hours of class time." Note: missing one week in a full-term class results in missing at least 6.25% of the total hours of class time. Furthermore, students who have not attended the first session of class will be dropped as a no-show. 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.

Face-to-face or hybrid class sections

If you are late or miss class, please take responsibility to find out what you have missed. All class meetings include a mandatory in-class activity. Classes which meet once per week may have multiple activities. If you fail to complete an activity during class, you will be assumed absent for that day. If you attend class but fail to complete the activity, make sure to notify your instructor of your attendance.

The instructor will not review missed lecture material or in-class activities with you. Refer to the class Lecture Notes and Assignments web page for missed notes and assignments.

Special note related to hybrid sections

Do not expect any lecture material to be presented during the lecture period. Hybrid classes employ a flipped classroom technique. Students are expected to study/view lecture videos, screencasts, and online textbooks and quizzes embedded in each class module on Canvas on their own time before attending the corresponding lab. The lecture time for hybrid classes is designed for interactively answering student questions and completing quizzes and exams.

The lab portion of class is conducted separately from lecture. Students will attend the lab section in which they enrolled. Students will always be assigned a new activity to complete during each lab, but due to the nature of the hybrid modality, lab time is compressed. It is expected that students will have time to begin each activity during the interactive lab session, and perhaps substantially complete it by the end of the session, but it is not expected. Students will, however, have enough time to make significant progress, and get questions answered relating to the lab before lab time expires. Furthermore, lab activities are ungraded. Any reasonable attempt may be submitted at the end of the lab session to receive full points. It is at the option (and highly encouraged) for the student to continue work on the lab activity and submit a more complete final version by midnight. Many lab submissions require a peer review the following day-it is in your own best interest to submit a complete assignment to receive the most useful feedback from your peers.

Fully on-line class sections

Missing the on-line orientation is equivalent to attending the first day of class. Absences are determined from the percentage of missed Zoom meeting sessions, quizzes, discussion board postings and other assignments, and late assignment submissions. You are expected to complete all assignments on time. E.g. missing three of six assignments during one week in an eight-week class is equivalent to missing 6.25% of total class time. (Missing one week of an eight week class is missing 12.5% of class; one-half is 6.25%.)

Dropping the Class

If you want or need to drop the class, you may do so by using the on-line eServices enrollment and registration system. The instructor's signature is not required to drop a class. Students must drop themselves officially from the class, or they will be assigned an "F" grade in the class. DO NOT assume that the instructor will automatically drop you off the class roster—it is the student's responsibility to officially drop their class.

Accommodations

Students who may need an academic accommodation based on the impact of a disability and who require instructional, curricular, or test accommodations are responsible for making such needs known to the instructor as early as possible. Every possible effort will be made to accommodate students in a timely and confidential manner. Individuals who request accommodations must be registered with the Disability Services and Programs for Students (DSPS) Office, which authorizes accommodations for students with disabilities. Contact the office by phone: 916.484.8382, email: ARCDSPSDE@arc.losrios.edu, or video phone: 916.993.3087

Communication Policies

All face-to-face and on-line students are welcome to take advantage of the instructor's on-campus office hours. Telephone calls are not answered during virtual office hours, or office hours scheduled in a lab classroom. If leaving a voice-mail message, please clearly state your name and a phone number or an alternative method of reaching you such as an email address.

As for all on-line communication, please be respectful and refer to a netiquette guide before emailing or posting to discussion boards.

Students are encouraged to ask or answer class content questions on the general Tips and Tricks discussion board on the class website. Please do not email your instructor directly for answers on these questions. All students are given the opportunity to review this board periodically, and respond to fellow students when able. (If, after fellow students are unable to respond to your question, then you will receive your instructor's response on the discussion board.) All interactions on this discussion board are looked upon favorably by the instructor. At the end of the class term, students earning a borderline final score that provide significant assistance on this discussion board will be assigned the higher class letter grade.

Questions of a more specific nature, such as individual scores and feedback on individual assessments, students should email the class instructor directly. On Monday through Thursday, you should generally expect a response within twenty-four hours. Emails received during virtual office hours are responded to within one hour.

All assignments and due dates are listed on the Lesson Plan page. However, both online and face-to-face students tend to forget an assignment or two during the term. Expect a weekly email reminder from your instructor regarding assignments due and upcoming course topics. Check your email frequently.

Ethical Student Behavior

When entering the classroom or computer lab, students are responsible for turning off all cell phones, pagers or any other device which would, in the opinion of the instructor, distract the activities in class. Only students registered in this class are allowed in our classroom or computer lab; children and other family members are not allowed.

No copying, plagiarism, or collaboration will be tolerated in this class. Unless the instructor specifies otherwise, all work assigned in this class, including homework, laboratory, and application or programming assignments, and all examinations, are to be individual efforts. This means that students may discuss their assignments with others, but the actual work must be completed individually.

Every student is required to actively participate to ensure the success of the class assignments. Students are encouraged to discuss problems and/or help each other in Labs and work together to facilitate the learning process, however all students must do their own homework, quizzes and lab assignments. Any copying, plagiarism or "duplicate printing" of any part of homework or lab assignments is expressly forbidden and may result in penalties. The following is a list of examples of Academic Dishonesty.

  1. Copying in part or in whole from someone else's test
  2. Submitting work previously presented in another course when contrary to directions prohibiting such acts from either course.
  3. Altering or interfering with grading in the class.
  4. Using or referring to any sources or materials not authorized by the professor during the test, quiz or examination
  5. Committing other acts that misrepresent one's own academic work
  6. Acting in part or in whole to compromise the integrity of the course examinations, quizzes or projects through replication, duplication, or electronic means.
  7. Submitting a written paper purchased or obtained from an outside source
  8. Representing another's creation (painting, photo, music, computer program, etc.) as your own product and work.
  9. Incorporating words, passages, ideas of another person's writing without citing appropriate credit or acknowledgment and representing it as your own.
  10. Duplicating any previous academic work from another and then submitting them as your own for academic credit.
  11. Forging signatures on Add/Drop slips or altering other college documents
  12. Stealing examinations, test, quizzes, or scoring key for tests.
  13. Removal of class exams or class assignment projects without instructor approval
  14. Altering graded work after it has been returned from the instructor and resubmitting without the instructor's approval
  15. Having another person or student submit academic work in your name
  16. Giving your academic work to another student to copy
  17. Purposely sharing your paperwork with another student to copy for a test or assignment especially when it is not a group project or group response to a test
  18. Lying to an instructor or to a college official to improve your grade
  19. Accessing the college computer system to change your grades or those of other students

Possible Penalties for Academic Dishonesty or Disruptive Behavior

Students will receive a grade of "Zero" or "F" for the current assignment. If the assignment is a large percentage of the grade, or the student has demonstrated academic dishonesty on multiple occasions during the course, the student may receive a failing grade. A report of all incidents of Academic Dishonesty will be documented and sent to the Student Discipline Officer. Multiple incidences could lead to suspension and or expulsion from the Los Rios Community College District.

These actions may also apply to students who knowingly or unknowingly allow their work to be copied—keep your work secure.

Expected Student Performance

Personal behavior that promotes an atmosphere favorable to effective instruction and learning is always appropriate. Concern and respect for others both in the classroom and on-line contribute to such an environment. Students should cooperate by willingly demonstrating interest and responsibility throughout this class. Please

Classroom Standards of Conduct

Students shall comply with the following standards of conduct while in the Classroom and Labs.

  1. All students must complete and sign an ARC HS1000 form, and must insure that they have a correct e-mail address listed with ARC E-Services as well as the course website.
  2. No food or drinks are allowed at or under desks. All eating or drinking must be done outside the classroom and labs.
  3. No typing, talking or printing while the instructor is lecturing. Please be courteous to your fellow students.
  4. No instant messaging, personal E-mail, viewing of inappropriate material, or other non-class-related use of the Internet.
  5. No beepers, pagers, or cellphones that are turned on are allowed in class or lab. Turn them OFF before coming to class.
  6. No working on assignments for other classes during lab.
  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 ARCs 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.

Lesson Plan

CISA 315 Lesson Plan
Lesson Topics Assignment
Sat, Jan 13

First 8 week classes begin

  • Syllabus overview
  • How to be successful in this course
  • Using the ARC computing environment
  • Weekly Schedule:
    • Read textbook
    • Watch screen casts/videos
    • Quiz
    • Lab activities
    • Lab exercises

Activities and Exercises are due by midnight on the date due unless it is stated otherwise.

Study Module
Course Syllabus and Tips and Tricks discussion board
Study Module 0
Course Orientation
Monday, January 15 Martin Luther King, Jr.'s Birthdayay
Wed, Jan 17

Wednesday, January 17 is last day to drop this class without notation on record, and to qualify for tuition refund.

Thu, Jan 18
  • M1.1 Overview of Microsoft Excel
  • M1.2 Entering, Editing, and Managing Data
  • M1.3 Formatting and Data Analysis
  • M1.4 Printing
Study Module 1
Fundamental Skills
Fri, Jan 19
  • Exercise due

Friday, February 23 is last day to withdraw from this class with a "W" notation on record.

Due: Exercise 1
Syllabus Review quiz,
Introductory Survey,
Student Learning Contract,
Post and Reply to Introductions Discussion Board,
File Upload Practice
Mon, Jan 22
  • Assignments due
Quiz 1
on Module 1
Due: Activity 1
M1.1-M1.4 CH1 Merchandise City Sales Data
Due: Activity 2
Basic Monthly Budget for Medical Office
Wed, Jan 24
  • Peer reviews due
Due: Peer Reviews
for Activities 1 & 2
Thu, Jan 25
  • M2.1 Formulas
  • M2.2 Introductory Statistical Functions
  • M2.3 Functions for Personal Finance
  • M2.4 Preparing to Print
Study Module 2
Mathematical Computations
Fri, Jan 26
  • Exercise due
Due: Exercise 2
Sales and Inventory Items
Mon, Jan 29
  • Assignments due (post-poned due to holiday)
  • Note: Students who submit Activity 3 or 4 by Monday will be assigned peer reviews Tuesday morning
Quiz 2
on Module 2
Due: Activity 3
M2.1-M2.4 CH2 Personal Budget
Due: Activity 4
Financial Plan for a Lawn Care Business
Wed, Jan 31
  • Peer reviews due
Due: Peer Reviews
for Activities 3 & 4
Thu, Feb 1
  • M3.0 Introduction
  • M3.1 More on Formulas and Functions
  • M3.2 Logical and Lookup Functions
  • M3.3 Conditional Formatting
  • M3.4 Preparing to Print
Study Module 3
Formulas, Functions, Logical and Lookup Functions
Fri, Feb 2
  • Exercise due
Due: Exercise 3
Hotel Occupancy and Expenses
Mon, Feb 5
  • Assignments due
Quiz 3
on Module 3
Due: Activity 5
M3.1-M3.4 CH3-Gradebook and Parks
Due: Activity 6
Household Budget
Wed, Feb 7
  • Peer reviews due
Due: Peer Reviews
for Activities 5 & 6
Thu, Feb 8
  • M4.0 Introduction
  • M4.1 Choosing a Chart Type
  • M4.2 Formatting Charts
  • M4.3 Using Charts with Microsoft Word and Microsoft PowerPoint
  • M4.4 Preparing to Print
Study Module 4
Presenting Data with Charts
Fri, Feb 9
  • Exercise due
Due: Exercise 4
Midas Coffee Company
Mon, Feb 12
  • Assignments due
Quiz 4
on Module 4
Due: Activity 7
M4.1-M4.4 CH4 Charting
Due: Activity 8
Charting Historical Data
Wed, Feb 14
  • Peer reviews due
Due: Peer Reviews
for Activities 7 & 8
Thu, Feb 15
  • M5.0 Introduction
  • M5.1 Table Basics
  • M5.2 Intermediate Table Skills
  • M5.3 Preparing to Print
Study Module 5
Tables
Friday, February 16 Abraham Lincoln's Birthday
Sat, Feb 17
  • Exercise due
Due: Exercise 5
Charting Sales Data
Monday, February 19 George Washingon's Birthday
Tue, Feb 20
  • Assignments due (post-poned due to holiday)
  • Note: Students who submit Activity 9 or 10 by Monday will be assigned peer reviews Tuesday morning
Quiz 5
on Module 5
Due: Activity 9
M5.1-M5.3 CH5 HR Report
Due: Activity 10
Tables for a Tourism Company
Wed, Feb 21
  • Peer reviews due
Due: Peer Reviews
for Activities 9 & 10
Thu, Feb 22
  • M6.0 Introduction
  • M6.1 Multiple Sheet Basics
  • M6.2 Formulas with 3-D References
  • M6.3 Templates
  • M6.4 Preparing to Print
Study Module 6
Multiple Sheet Files
Fri, Feb 23
  • Exercise due
Due: Exercise 6
Tables for a Retail Company
Mon, Feb 26
  • Assignments due
Quiz 6
on Module 6
Due: Activity 11
M6.1-M6.4 CH6 Personal Budget
Due: Activity 12
Creating a Multiple Sheet Workbook for a Sports Team
Wed, Feb 28
  • Peer reviews due
Due: Peer Reviews
for Activities 11 & 12
Thu, Feb 29
  • M7 M6.3-continued: Creating Custom Templates
  • M7 Inserting, Formatting, and Modifying Graphics
  • M7 Find and Replace
  • M7 What-If Analysis
  • M7 Flash Fill
  • M7 Sparklines
Study Module 7
Advanced Features
Fri, Mar 1
  • Exercise due
Due: Exercise 7
A Multiple Sheet Workbook for National Parks Data
Mon, Mar 4
  • Assignments due
Quiz 7
on Module 7
Due: Activity 13
Module 7 chapter workbooks
Due: Activity 14
Team Template and Retirement Planning
Wed, Mar 6
  • Peer reviews due
Due: Peer Reviews
for Activities 13 & 14
Fri, Mar 8
  • Exercise due
  • Final Exam Due
Due: Exercise 8
Templates, 3D References, Goal Seek
Due: Final Exam
Maximum of 120 minutes