CIS 115: Microcomputer Applications

Enrollment Message:

Terms of Use (More Info in Syllabi): Dual enrollment (DE) courses follow St. Clair County Community College (SC4)’s 12-week calendar. You consent to pay the SC4 in-district tuition/fees. Michigan Virtual will invoice eligible charges following enrollment/withdrawal date. Students or enrolling schools must buy required text/materials listed in syllabi. SC4 accepts SAT scores for DE eligibility. If student hasn’t taken the SAT, then SC4 will evaluate the student’s H.S. transcript. Upload files to Michigan Virtual’s Student Learning Portal (SLP). DE courses are limited to students attending public/private schools in Michigan. Nonresident or homeschooled students are not eligible. Students must complete the webform in their registration email. SC4 will contact the student directly with acceptance by mail and info on accessing the portal, college email, and online course content. SC4 will transmit scores electronically or by mail via Michigan Virtual. DE scores will not appear in the SLP.

Course Number: CIS 115

Credit Hours: 4

Contact Hours: 4 (Lecture); 0 (Lab); 0 (Other)

COURSE RATIONALE: This course introduces students from any program to the uses of a microcomputer to accomplish word processing, spreadsheets, or basic database applications. Keyboarding skills are not required but will be of assistance to prospective students. The course assumes no prior knowledge of computers on the part of students.

CATALOG DESCRIPTION: CIS 115: Microcomputer Applications. This is a hands-on class using the microcomputer in a variety of applications, including word processing, electronic spreadsheet, and database management. The course will emphasize systems as well as applications software. Fundamentals such as identifying computer hardware, file management and problem solving methodologies will be presented.

Prerequisites:  None

Course Objectives/Outcomes: Upon completion of this course, students will be able to...

Computer concepts & operating systems

  1. identify computer hardware for input, processing, output and storage
  2. differentiate system and application software
  3. recognize standard terminology for a Graphic User Interface
  4. organize the contents of a disk and its directories applying the following:
    1. File Commands:
      1. copy
      2. rename
      3. delete
      4. move
    2. Create sub-directories
  5. discuss security concerns for Personal Computer users

Spreadsheets

  1. discuss the attributes of a cell including:
    1. address
    2. contents
    3. text & number
  2. demonstrate the proper use of formulas using the following:
    1. operators
    2. mathematical order of precedence
  3. demonstrate the proper use of the following types of functions:
    1. ranges within functions
    2. statistical functions (SUM, AVERAGE, MIN, MAX)
    3. logical functions (IF)
    4. financial functions
    5. date functions
  4. distinguish between absolute and relative cell referencing
  5. visually represent data in a logical chart type (3 major chart types)
  6. design spreadsheets for effective analysis & communication mindful of:
    1. appearance and readability
    2. validity of data
    3. conversion of data to information

Databases

  1. recognize database terminology
  2. organize an effective database using:
    1. database terminology
    2. hierarchy of data (byte/character, field, record, files/tables, database)
    3. database structure
  3. create relationships between tables by joining them
  4. design effective queries by using:
    1. selection criteria
    2. computed fields
    3. sorted data
    4. aggregate functions

Word processing & presentation graphics

  1. discuss the following common document formats:
    1. business letter
    2. MLA research paper
    3. memo
    4. e-mail
    5. envelopes
    6. presentations with presentation graphics software
  2. employ character, paragraph, and page formatting in word processed documents
  3. apply standard formatting to the following documents:
    1. MLA research paper
    2. business letter in block format

Course Outline:

Computer Concepts & Operating Systems

  • Identify computer hardware
  • System & application software
  • Graphical user interfaces
  • File management
  • Personal computer security issues

Spreadsheets

  • Excel Chapter 1 – Introduction to Excel
  • Excel Chapter 2 – Formulas and Functions
  • Excel Chapter 3 - Charts

Databases

  • Access Chapter 1 – Introduction to Access
  • Access Chapter 2 – Relational Databases and Queries
  • Access Chapter 3 – Customize, Analyze, and Summarize Query Data
  • Webpage development using standard software, such as Dreamweaver

Word Processing & Presentation Graphics

  • PowerPoint overview – you may wish to teach this in the first unit so that students can use it to prepare and present topics in that unit
  • Discuss common document formats
  • Formatting (character, paragraph and document)
  • Apply document formats and formatting to the following documents:
    • MLA research paper
    • Business letter in block format

Resources Included: Upon confirmation of the student's course registration, SC4 will mail an acceptance letter to each student's home address. This letter will contain additional information about login access to the SC4 Portal and establishing a college email account. Students will receive login information to the Canvas learning management system (LMS) via their college email account. The email will provide login procedures necessary to access the online course(s) for which a student is enrolled.

Additional Costs: Required Textbook / Materials: Students or their enrolling schools are responsible to purchase the required textbook and materials listed in the syllabus. Students are responsible for all tuition, books/supplies, and fees the school or school district does not pay; this includes the non-refundable student fee for dropped courses.

To locate your required textbook, use the SC4 Catalog Advanced Search to locate the Section Details and Book Details pertaining to your course section.

  1. If you have the section number for the course in which you have been registered by SC4, then you can select the Subject of the course name (e.g., Biology) along with the Course Number (e.g., 101) and Section number (e.g., 60) and then click the Search button in order to locate your section description. Click on the Section name and number hyperlink, and scroll down to view the Books Details and Pricing as well as the Book Details, including the required ISBN, title, author, and price. For additional help with textbook information, you may contact the SC4 Bookstore: (810) 989-5725 https://www.bkstr.com/stclaircountyccstore/home.
  2. If you do not yet have your section number or have not yet registered for the course, then you can locate this information by entering the Term (e.g, Fall 2021), the Course Subject (e.g., Accounting) and Course number (e.g., 211), and select “Online Course” for the Location, prior to clicking on the Search button. Click on “View Available Sections”. Finally click on a section to locate the Section Details and Book Details as described above. NOTE: Prior to purchasing required materials, students should verify that the book details match those displayed in their assigned section once SC4 has completed their dual enrollment registration.

Scoring System: Michigan Virtual does not assign letter grades, grant credit for courses, nor issue diplomas. Michigan Virtual will transmit the final letter grade awarded by SC4 for each dual enrollment course completed to the student and his/her enrolling school.
CIS 115 Grading Rationale: Assignments, quizzes, and other projects or portfolios (50%); Tests--written and production (40%); Final Exam--written and production (10%)

Time Commitment: Dual enrollment semester sessions are 12-weeks long: Students must be able to spend 1.5 or more hours per day in the course to be successful.

Technology Requirements: Students will require a computer device with headphones, a microphone, webcam, up-to-date Chrome Web Browser, and access to all web resources linked within the online course content provided by the SC4 Canvas learning management system.

Instructor Support System: For technical issues within your course, contact your SC4 instructor or the college at 810-984-3881.

Instructor Contact Expectations: Students can use their college email or other means provided by their instructor within the course syllabus or within their learning management system once the term has begun when they need instructor assistance. The instructor may describe additional communication options.

Academic Support Available: Disability Services - Support services are available to students at SC4 upon request. For information regarding services provided by St. Clair County Community College, contact the Achievement Center at (810) 989-5759. Students must self-identify their need for assistance.

Required Assessment: Online assessments consist of formative and summative assessments represented by computer-graded multiple choice, instructor-graded writing assignments including hands-on projects, model building and other forms of authentic assessments.

Technical Skills Needed: No special skills are required beyond being able to operate a computer and use word processing software.

Additional Information: [1] Dual enrollment courses follow unique start, end and last day to withdraw dates for St. Clair County Community College (SC4)’s academic calendar for 12-week courses [https://sc4.edu/admissions/academic-calendar/].

[2] You are consenting to pay the SC4 in-district tuition and fees for the course(s) selected [https://sc4.edu/admissions/tuition-and-fees/]. Michigan Virtual will send an invoice for eligible charges following the enrollment/withdrawal date of each term. Students or their enrolling schools are responsible to purchase the required textbook and materials listed in the syllabus.

[3] SC4 accepts the SAT as qualifying scores for dual enrollment eligibility. If a student has not taken the SAT, then SC4 will evaluate the student’s high school transcript to determine college readiness. Upload the student’s SAT report and/or high school transcript to Michigan Virtual’s Student Learning Portal (SLP) [https://michiganvirtual.org/about/support/knowledge-base/slp-add-sat-and-transcript-files-to-student-account/].

[4] Dual enrollment courses are limited to students attending public or private schools in the State of Michigan. Nonresident or homeschooled students are not eligible to dual enroll.

[5] SC4 will transmit a student’s scores electronically or by mail via Michigan Virtual. Dual enrollment scores will not appear in the SLP.

[6] Students must complete the online webform linked in their registration email before the enrollment will be confirmed.

[7] SC4 will contact the student directly with an acceptance letter and information on accessing the SC4 Portal, a college email account, and the online course content.

Details


School Level: Postsecondary
Standards: None
NCAA Approved: N/A - Non-Core
Alignment Document: Document
Course Location:
NCES Code: 10004
MDE Endorsement Code: NR - Computer Science
MMC Minimum Requirements: EDP/Career Interest Elective

When Offered: _Internal Use Only

Content Provider: SC4
Instructor Provider: SC4

Course Type: DUAL4