CSCI100 Intro to Computers

Updated 2014.12.16

Syllabus     Catalog Description     BCU's Academic Integrity Statement     Email Guidelines     Grades Online     Windows Resources     Internet Resources     Word resources     PowerPoint Resources     Excel Resources     Email resources

The final test (over Word and PowerPoint) will be:
8:00 class: Monday, May 11, 8:00 to 9:50                     9:00 class: Thursday, May 14, 8:00 to 9:50                       10:00 class: Friday, May 15, 10:00 to 11:50
All students are expected to take the final at the time scheduled for their class. Make travel plans accordingly.
Last day to drop: April 10.

Day #1. Wednesday, 1/21/2015: Windows, Internet

·        Syllabus

·        BCU IT Competency: Requirement, Objectives

·        Getting Office: Office 365 University is now free.

·        Free online version with SkyDrive.

·        How secure is your password? Check it.

·        Using the Briar Cliff Network

·        BCU Email: Using Briar Cliff Email from the web, Emailing guidelines, file naming conventions

Homework due Monday:

·        Class policies for assignments and tests (print a hard copy, READ, sign, and bring to next class).

·        Fill out online before 7:30 a.m. Monday. This is an assignment: Computer experience survey, Word Processing skills survey, Spreadsheet skills survey.

·        Memorize Windows keyboard shortcuts (nothing to hand in) in preparation for a quiz next class. The quiz will begin promptly at the class starting time.

Day #2. Monday, 1/26/2015: Windows, the Internet

·        Quiz over Windows keyboard shortcuts (8:00 to 8:05)

·        How the Internet works

·        Windows: Windows 7, Windows keyboard shortcuts

·        Using the Internet: Internet Resources

Homework due Wednesday

·        Web scavenger hunt. Either (1) print the Word document and hand-write your answers, or (2) insert your answers into the Word document and print it. Hand in a hard copy.

Day #3. Wednesday, 1/28/2015: XL 1. Formatting

·        Getting <window>+<tab> to work: choose Aero

·        Excel Resources

·        Sample file

Homework due Monday at 7:30 a.m.

·        Formatting: WKRP. Deposit a digital copy in the drop box.

Day #4. Monday, 2/02/2015: XL 2. Formulas, Functions, and Relative Cell References

·        Nerd news

·        Excel Resources

·        Sample file.

Homework due Wednesday at 7:30 a.m.

·        Formulas: NFL Top Passers. Deposit a digital copy in the drop box.

Day #5. Wednesday, 2/04/2015: XL 3. Formulas with Absolute/Mixed Cell References

·        Employers want students to know Office: Skills needed in the workplace, 2015-2020

·        Excel Resources.

·        Sample file. Budget, addition table, loan payment table.

Homework due Monday

·        Absolute/Mixed cell references: Budget. Deposit a digital copy in the drop box.

Day #6. Monday, 2/09/2015: XL 4. Databases: Sorting and Filtering

·        Another way to find things on the Internet: the Wolfram Knowledge Engine

·        Excel Resources.

Homework due Wednesday

·        Sorting and filtering: Football. Deposit a digital copy in the drop box.

Day #7. Wednesday, 2/11/2015: XL 5. Charts

·        Excel Resources.

·        Sample file

Homework due Monday

·        Charts. Deposit a digital copy in the drop box.

Day #8. Monday, 2/16/2015: XL 6. Logical Functions

Homework due Wednesday at 7:30 a.m.

Day #9. Wednesday, 2/18/2015: XL 7. Databases: Pivot Tables, Pivot Charts

Homework due Wednesday, 2/25/2015 (Monday is a test over Excel)

Day #10. Monday, 2/23/2015: XL Test, part 1: XL1-XL6

Practice Test (complete on your own—not to be handed in)

Day #11. Wednesday, 2/25/2015: XL 8: 3D Workbooks

Homework due Monday

Day #12. Monday, 3/02/2015: XL 9. Financial Functions

Homework due Wednesday

Day #13. Wednesday, 3/04/2015: XL 10. VLOOKUP, another way to make decisions

Homework due Monday

March 7-15: Spring Break

Day #14. Monday, 3/16/2015: XL 11. Databases: Advanced Filters and "D" Functions

Homework due Wednesday

Day #15. Wednesday, 3/18/2015: XL 12. Dates and Times

Homework due Monday

Day #16. Monday, 3/23/2015: Word 1. Short documents

Homework due Monday (Wednesday is a test)

Day #17. Wednesday, 3/25/2015: XL Test #2

Day #18. Monday, 3/30/2015: Word 2. Term paper skills

·Today's files: Lincoln (find/replace), Red-Headed League (find/replace), Christmas Carol.

Homework due Wednesday

Day #19. Wednesday, 4/01/2015: Word 3. Positioning text with tabs

Homework due Monday

Monday, April 6: No class—Easter Monday

HOUR OF CODE Day #20. Wednesday, 4/08/2015:

Day #21. Monday, 4/13/2015: Word 4. Positioning text with tables

Homework due Wednesday

Day #22. Wednesday, 4/15/2015: Word 5. Images

Homework due Monday

Day #23. Monday, 4/20/2015: Word 6. Newsletter skills

Homework due Wednesday

Day #24. Wednesday, 4/22/2015: Word 7. Styles

Homework due Monday

Day #25. Monday, 4/27/2015: Word 8. Mail Merge

Homework due Wednesday

Day #26. Wednesday, 4/29/2015: PowerPoint 1

Homework due Monday

Day #26. Monday, 5/04/2015: PowerPoint 2

Homework due Monday

Day #27. Wednesday, 5/06/2015: Review for Final

Practice Tests

"Homework" due at the end of the period today:

 

Earlier classes are below…

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanksgiving Vacation

 

Earlier classes are below…

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Day #27. Review for Word/PPT final.

Assignment due at the end of the period

 

·Nerd news: Leap Motion

Some useful free programs

Final Test

 

Bell ringers

Bell Ringers

Another cool printer

Another kind of "search" engine: Wolfram Alpha

April 6, 2015: IBM 360 turns 50 years old: IBM 360

Audacity: powerful audio editor

Awesome Internet application: SkyDrive

Bud logs in

Chips in everything?

Clean up your computer: CCleaner

Clean up your computer: MalwareBytes

Computer Hardware

Computer myths from TV and the movies

Employers want students to know Office: Skills needed in the workplace, 2015-2020

Google Glass

How good is your password?

How much junk is on your computer? Check it.

How the Internet works

Inexpensive smart phone

Interesting displays

Cool printer

Johns Hopkins closes medical library

KeePass: password manager

Microsoft's vision of the future

Nerd news: Leap Motion

Other search engines: Ixquick, DuckDuckGo, Blekko

Paint.net: powerful photo-editor

Pope Benedict vs. Pope Francis: Change in cell phone use in 8 years. Pic

Prezi: an interesting PowerPoint alternative

Rolltop

Secunia PSI: (personal software inspector) keeps programs up to date

Skype with anybody, anywhere!

Star Trek is here!

Ten things everybody should know how to do in a word processor.

Top 5 soon-to-be-obsolete technologies

Useful program: Belarc Advisor

Visualizing data: 200 countries, 200 years

Where is the "cloud"?

Why you should ditch Windows XP (April, 2015): Windows XP

Windows 8