CS 120: Information Management and Analysis
This course will cover, in depth, the essentials of word-processing, spreadsheets, photo editing, presentation software and web page design. Applications will be presented from various fields.
This course concentrates on using computers to store, analyze, process, and visualize data, primarily with Excel. We will briefly cover presentation software and word processing. The class will conclude with an introduction to building websites.
Policies are covered in the syllabus.
Get and use Office 365: http://365.western.edu
- Student Information Sheet
- Practice 1 - Basic Formulas Worksheet 1 (do not turn in)
- Assignment 1 - Friendly Sam CIS120/Excel Homeworks/Sam - Due Wednesday, August 31
- Practice 2 - Edit, Fill, Format and Validate CIS120/Excel Homeworks/Worksheet 2 (do not turn in)
- Practice 3 - Graphing and Verification CIS120/Excel Homeworks/Graph And Verify (do not turn in)
- Assignment 2 - Employee Evaluation CIS120/Excel Homeworks/Evaluation - Due Wednesday, September 14
- Exam 1 Review - media:CS129-f16-review1.xlsx (do not turn in)
- Practice 4 - Graphs media:CIS120-f16-excel-graphs.xlsx (do not turn in)
- Practice 5 - Conditional Formatting media:CS120-f16-conditional-formatting.xlsx
- Practice 6 - Searching media:CS120-f16-searching.xlsx
- Assignment 3 - Graphing and Conditional Formatting CIS120/Excel Homeworks/River - Due Monday, September 24
- Practice 7 - Advanced Formulas - do not turn in
- Assignment 4 - Sales Report - Due Wednesday, Oct 5
- Test 2 Review Topics
- Practice 8 - Filter and Sort Filter and Sort (do not turn in)
- Assignment 5 - Census data - Due Monday, October 24
- Practice 9 - Pivot Tables media:pivotpractice.xlsx
- Assignment 6 - Pivot Tables - Due Monday, October 31
- Practice 10: Tables media:tables-f16.zip (do not turn in)
- Assignment 7: Word Homework - Due Wednesday, Nov 9
- Assignment 8: Powerpoint - Due Wednesday, Nov 16
- Practice 11: Gimp - covers the skills needed for the homework and the test
- Assignment 9: Web Graphics using Powerpoint and Gimp - Due Monday, December 5
- Assignment 10: /Websites-f15 - Using Wordpress to create a website. Due Wednesday, Dec 14.
- Practice 9: Instructions: media:wordw1.doc, Text to edit: media:word2.doc, A picture you need to use: lion.jpg
- Practice 10: CIS120/Powerpoint Homework - not turned in.