CIT155- Syllabus.docx - COURSE OUTLINE Instructor Mrs Jo Ann Lauer Semester\/Session Fall 2019 Course Number CIT155-Z03A Course Title Excel Spreadsheets

CIT155- Syllabus.docx - COURSE OUTLINE Instructor Mrs Jo...

This preview shows page 1 - 3 out of 6 pages.

COURSE OUTLINE Instructor: Mrs. Jo Ann Lauer Semester/Session: Fall 2019 Course Number: CIT155-Z03A Course Title: Excel Spreadsheets Course Credits: 3 Lecture hours: 3 Lab hours: Other hours: Pre-requisite(s): Basic skills using a personal computer and Windows operating system, keyboarding and basic exposure to Microsoft Office. Ability to effectively manage Windows files and folders. Co-requisite(s): None Course Description: This course is a comprehensive use of electronic spreadsheets in solving business and technical problems using Microsoft Excel. Students learn through applied and project-based activities that go beyond the mechanics of the software. It engages students to utilize critical thinking activities for applied learning and problem solving. Topics include preparation of a variety of documents and mastery of specialized software functions. LEARNING OUTCOMES: Upon successful completion of the course, the student will: 1. Organize and create effective worksheets and workbooks with formulas and functions. 2. Create and modify charts. 3. Create and manage formal Excel tables for problem solving. 4. Create and modify PivotTables and Pivot Charts. 5. Use What-If analysis with data tables, Goal Seek, Scenario Manager and Solver. 6. Use advanced statistical functions. 7. Create structured worksheets, supporting problem-solving. 8. Work with large volumes of data and import data from various sources. 9. Collaborate on and distribute workbooks. 10. Create and use templates and create and run macros. 11. Locate and download Web data and successfully integrate it in Excel-based projects. Section Dates Days Time Room Class Section(s) Time & Location: Z03A 9/3 – 12/9 On Line Course Instructor: Mrs. Jo Ann Lauer Office Hours: Tuesday and Thursday: 8:30 a.m. to11 a.m. Any time by email at [email protected] Telephone: 412-237-6585 Mailbox Location: 226 Office Location : M506 E-Mail Address: [email protected]
Image of page 1
Materials and Resources: Required Text(s): Microsoft Excel 2016 Levels 1 & 2 Benchmark Series , Nita Rutkosky, Jan Davidson, Audrey Roggenkamp, and Ian Rutkosky. Paradigm Publishing, Inc.: St. Paul, MN: 2017. ISBN: 9780763872687 with Access Code for etext and workbooks Required Materials: Recommended Text(s): Flash Drive storage device
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 6 pages?

  • Fall '19

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes