Course Outline (view as calendar)
January 27 — Course Introduction
- Introduction to course
- Class software and book
- Course Materials
- There is no book for this course, rather a collection of videos listed in Blackboard
- Computer Components
- Software – two basic types
- Hardware – six basic types
- A quick history of PCs and Macs
- Windows 10 Essential Concepts
- Start Windows and sign in to an account
- Identify the objects on the Windows 10 desktop (Start menu, taskbar, settings...)
- Identify the apps in and versions of Microsoft Office
- Run an app
- Identify the components of the Microsoft Office ribbon
- Create folders
- Save and Manage files
- Use Microsoft Office Help and Windows Help
- Searching the Internet and MC library databases
- Serching with Venn Diagrams and Boolean Logic
- MC Library
- Here is a link to the Business Department Student Orientation where you can explore how becoming a Business major may benefit you. http://bit.ly/mcbusinessorientation
February 03 — Word Module 1 — Introduction
- Begin and edit a document
- Use features that improve readability
- View a document in different ways
- Prepare a document for distribution
- Apply Font attributes
- Format a paragraph
- Insert and format objects
- Homework #1 - Club Poster - Sample, Instructions, Data File - due 02/12
February 10 — Word Module 2 — Formatting Research Papers
- Use Documentation style manuals
- Apply Word Styles
- Format a term paper
- Create citations
- Create bibliographies
- Use Footnotes and Endnotes as content notes
- Use Find and Replace editing tools
- Apply a caption to an image, figure or chart
- Homework #2 - Term Paper- Sample, Instructions, Data File - due 02/19
February 17 — Word Module 3 — Creating & Modifying Tables
- Create and insert a table in a document
- Modify a table
- Enhance table data
- Create a resume in a table format
- Homework #3 - Cover Letter and Resume- Sample, Instructions, Data File - due 02/26
February 24 — Test #1 and PowerPoint Module 1 — Introduction to PowerPoint
- Create an effective PowerPoint presentation
- Plan a presentation
- Use PowerPoint Views
- Type speaker notes
- Assess presentation content
- Review a presentation
- Insert pictures
- Format and edit a presentation
- Use animations and transitions
- Insert a header and footer
- Run and navigate a slideshow
- Print in PowerPoint
- Homework #4 - Club Presentation - Sample, Instructions, Data File - due 03/04
March 02 — PowerPoint Module 2 — Presentation Development
- Suggestions for effective PowerPoint Presentations
- Explain slide show design principles
- Create and modify a presentation using a template
- Use other slide layouts
- Use the Outline View to create presentations and print
- Use SmartArt
- Create a table
- Add video to a presentation
- Add a chart to a presentation
- Annotate a slide show
- Understand copyright
- Homework #5 - Multimedia - Sample, Instructions, Data File - due 03/11
March 09 — PowerPoint Module 3 and Test #2 — Using Multimedia in PowerPoint
- Color a photo
- Add an artistic effect to a photo
- Align paragraph text
- Change views
- Ungroup, change the color of, and regroup an illustration
- Copy a slide element from one slide to another
- Insert and edit a video clip
- Insert an audio clip
- Control audio and video clips
- Insert entrance, emphasis, and exit effects
- Control animation timing
- Change theme colors
- Change a theme and variant on one slide
- Print handouts
COVID-19 Class Interruption
- Here is a link to a short video (two minutes) about what we do now that classes have been cancelled and moved online due to the COVID-19 virus. Here is the link to what's next for CMAP120. (posted 3/12/2020)
- Please check Blackboard for the following information:
- Links to Zoom virtual classes and office hours
- Videos from recorded classes
- Videos for chapter content
- Certificates of Completion drop boxes
March 16 — Spring Break
March 23 — Excel Module 1 — Introduction to Excel
- Identify Excel window elements, including the ribbon
- Plan worksheet design and enter and format data
- Create simple formulas using cell references
- Copy formulas using Auto-fill
- Display cell formulas and verify the contents of the formula
- Manage worksheets
- Insert, delete, and change columns and rows
- Copy, move, and paste ranges
- Apply alignment and font options
- Use the Page Layout tab options
- Ensure that data will print correctly prior to printing
- Homework #6 - TImesheet - Sample, Instructions, Data File - due 04/01
March 30 & April 06 — Excel Module 2 — Formulas and Functions
- Cell references
- Functions defined
- Math and statistical functions
- Date functions
- If function
- PMT function
- Homework #7 - GPA Calculator- Sample, Instructions, Data File - due 04/15
April 13 — Excel Module 3 — Charts
- NYT 2016 Presidential Election Polls - multiple displays of polling data and predicted outcomes (and Senate)
- Wind Map - turning numbers into pictures
- Decide the appropriate chart type for the data and the message.
- Create a chart.
- Edit the chart, including formatting labels, axes, and titles.
- Apply a chart layout and a chart style.
- Move a chart.
- Print a chart.
- Select and format chart elements.
- Add sparklines to a worksheet.
- Homework #8 - Inventory - Sample, Instructions, Data File - due 04/22
April 20 — Test #3 and Access Module 1 — Introduction to Access
- Understand database fundamentals
- Know when to use Access or Excel to manage data
- Describe the Access window
- Use an existing database
- Create a database
- Design a table
- Create and modify a table
- Import a table from Excel
- DatabaseStructures.pdf and DatabaseGuidelines.pdf
- Homework #9 - Nutrition - Sample, Instructions, Data File - due 04/29
April 27 & May 04 — Access Module 2 — Queries, Forms and Reports
- Establish table relationships
- Sort table data on one or more fields
- Create, modify, and remove filters
- Create a single-table query
- Specify query criteria for different data types
- Understand query sort order
- Run, copy, and modify a query
- Use the Query Wizard
- Create and modify a multi-table query
- Homework #10 - Course Schedule- Sample, Instructions, Data File - due 05/06
May 11 — Test #4 (Final Exam) at 10:15 a.m.