CIT 105P Topic of Class: How to use software tools & understand PCs. Type of Class: HW/SW, Hands-on Lab Class Homework: MS Office Pro Software Type of Homework: (100 pts, 10%) Lab Assignments Final Segment: (100 pts, 10%) Final Project Quizzes: (800 pts, 80%) Quizzes, 80 Questions Total%: (1000 pts Total, 100%) Extra Credit: Yes; See Assignments Page
- People usually take both CIT105P & CIT106P together (as recommended), since they are offered as part of the CIT PACE Block of classes (although it is no longer required to take them together).
- If you are taking these classes together remember that you are enrolled in two different classes that have two different perspectives on computers:
- CIT 105P: A Hardware/Software View of Computers (Hands-on Lab Assignments - practical work).
- CIT 106P: A Societal View of Computers (Reading & Writing Assignments - concepts and issues).
- See the Orientation video on tips to get started.
- Look at the Calendar Schedule and the Weekly Info for more details of how to coordinate the assignments.
- The Assignments Page for more detail on the Assignments themselves.
- See the Syllabus Page for more info about getting the textbook.
- See the Email HW Page for info on how to submit Homework Assignments.
- The software for CIT105P, Microsoft Office Pro, is available in the UMKC Computer Labs. Educational and Home versions are available commercially for less that $100, though without the database. The Pro will run a couple of hundred dollars per year via subscription depending on how many computers are being licensed to run it. The campus bookstore has discounted student versions. It is not required to purchase the software, but you are expected to use this particular software.
- Microsoft Office Pro provides the various software tools used in the CIT105P class:
- Word Processing (Word),
- Spreadsheet (Excel),
- Database (Access), - - - (Note, the database is not available for Macs.)
- Presentation software (Power Point).
- Also these applications, though they are not covered in the course:
- Publisher (desktop publishing)
- Outlook (email client)
- One Note (general purpose information holder)
- No book is listed for the software and most of what you need will be on these pages and available by exploring the program. However, the Dummies books for Microsoft Office give a good reference source for a low price (around $35). If you are working with MS Office and need a reference, this is a good book to keep around.
- Course Materials and Quizzes can be found on the Blackboard Course Content link on the left side of your screen.
- Grades are available on the Blackboard My Grades link (or on the Tools link), also on the left side of your screen.
Estimated Work Hours (for an 8-week session*)
CIT105P is a 4 credit hr class. Each credit requires 45 student work hrs per session.
This figures out to 4 * 45 = 180 work hrs per course.
To plan your class work hours for this course, use the following guidelines.
(*Based upon an 8-week session; Double your weekly time for 4-week session.)
Reading time is based upon an average of 25 pages per hour.
CIT105P Student Work Hours
Online Engagement: (~8 hours per week) Read Website, read instruction docs 2.5 20 Take Quizzes (1-3 Chapters weekly) 1 8 Online Practice Exercises 4 32 Offline Preparation: (~16 hours per week) Skim & Study Chapters (1-3 Chapters weekly) 5 40 Study for Quizzes (1-3 Chapters weekly) 4 32 Homework Assignments 4 32 Final Project 2 16 TOTAL HOURS 22.5 180
Below is a set of starting links to various YouTube tutorials on the software programs used above. This is just a starting set. You will see large numbers of such videos of various usefulness.
Remember, the most useful tutorial is your own, very personal, experience on the keyboard, simply trying out every nook and cranny and keystroke you can find. Too much reading or too much viewing before actually typing away on the keyboard will impede your progress. The best way to learn is to jump in. You won't blow up your compter.
The actual physical experience of working in the programs and exploring the programs will make more sense faster. The experience helps you make sense of the "instructions" because that physical experience gives you a working context in your head. That in turn will help your keyboarding experiences. Move back and forth between reading/viewing and working to retain the most information.
Hints and Tips and Tutorials (A Starting Point, ONLY!)
Microsoft Access Tutorials on YouTube (a starter list only)
Just Google for "Microsoft Access tutorial" for more (hint, there are tons of these)
Access - making a database - Access 2016
Tutorial for Beginners - Access 2016
Beginners MS Access 2007 Database Tutorial 1 - Introduction and Creating Database
Beginners MS Access 2007 Database Tutorial 2 - Table Filter, Sort & Introduction Forms
Beginners MS Access 2007 Database Tutorial 3 - How To Create Forms with Buttons and Charts
Beginners MS Access 2007 Database Tutorial 4 - Creating Queries
How to Create a Stock Management Database in Microsoft Access 2010
Same, without the distracting background music
A Few YouTube links for Microsoft Excel (a starter list only)
Just Google for "Microsoft Excel tutorial"
Excell 2016 tutorial
Excel 2016 Tutorial: Learn Excel in 30 Minutes - Just Right for your New Job Application
Excel Tutorial | 20 Tricks & Shortcuts That Can Make Anyone An Excel Expert
A few YouTube links for Microsoft Word (a starter list only)
Just Google for "Microsoft Word tutorial"
Microsoft Word 2016 - Full Tutorial for Beginners [+General Overview]* - 13 MINS!
Introduction to Microsoft Word 2016 - Getting Started Tutorial for Beginners
Word Basics - Tutorial for Beginners - Microsoft Word 2010, 2013, 2016 Office 365, Getting Started
A few YouTube links for Microsoft PowerPoint (a starter list only)
Just Google for "Microsoft PowerPoint tutorial"
PowerPoint 2016 Tutorial - A Complete Tutorial on Using PowerPoint - Full HD 1080P
10 Things PowerPoint Beginners Want to Know How to Do
How to avoid death By PowerPoint | David JP Phillips | TEDxStockholmSalon
Microsoft PowerPoint 2016 - Full Tutorial for Beginners [ 14 MINUTES! ]*