CSCI100 Intro to Computers

Updated 2014.08.27

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 test over Word and PowerPoint will be on Monday, December 9 (9:00 section) or Thursday, December 12 (8:00 section). Test is from 8:00 to 9:50.

Day #2. Wednesday, 8/27/2014: 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 (Monday is Labor Day)

·        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 #1. Monday, 8/25/2014: Windows, Internet

·        Syllabus

·        BCU IT Competency: Requirement, Objectives

·        Get Office:

1.      Buy Office 365 University. $80 for 4 years but don’t buy it until you’re a senior!

2.      Download a 1-month free trial.

3.      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 Wednesday:

·        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. Wednesday. 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 #3. Wednesday, 9/3/2014: XL 1. Formatting

Homework due Monday

Day #4. Monday, 9/8/2014: XL 2. Formulas and Relative Cell References

Homework due Wednesday

Day #5. Wednesday, 9/10/2014: XL 3. Formulas with Absolute/Mixed Cell References

Homework due Monday

·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 #6. Monday, 9/15/2014: XL 4. Databases: Sorting and Filtering

Homework due Wednesday

Day #7. Wednesday, 9/17/2014: XL 5. Charts

Homework due Monday

Day #8. Monday, 9/22/2014: XL 6. Logical Functions

Homework due Wednesday

Day #9. Wednesday, 9/24/2014: XL 7. Databases: Pivot Tables, Pivot Charts

Homework due Wednesday (Monday is a test over Excel)

Day #10. Monday, 9/29/2014: XL Test, part 1: XL1-XL6

Day #11. Wednesday, 10/01/2014: XL 8: 3D Workbooks

Homework due Monday

Day #12. Monday, 10/06/2014: XL 9. Financial Functions

Homework due Wednesday

Day #13. Wednesday, 10/08/2014: XL 10. VLOOKUP, another way to make decisions

Homework due Monday

Day #14. Monday, 10/13/2014: XL 11. Databases: Advanced Filters and "D" Functions

Homework due Wednesday

Day #15. Wednesday, 10/15/2014: XL 12. Dates and Times

Homework due Monday

Day #16. XL Review.

Day #16. Monday, 10/20/2014: Word 1. Skills for writing a short document

Homework due Monday (Wednesday is a test)

Day #17. Wednesday, 10/22/2014: Excel Test, XL7-XL12.

Day #18. Monday, 10/27/2014: Word 2. Skills for writing a term paper

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

Homework due Wednesday

Day #19. Wednesday, 10/29/2014: Word 3. Positioning text with tabs

Homework due Monday

Day #20. Monday, 11/03/2014: Word 4. Positioning text with tables

Homework due Wednesday

Day #21. Wednesday, 11/05/2014: Word 5. Images

Homework due Monday

Day #22. Monday, 11/10/2014: Word 6. Newsletter skills

Homework due Wednesday

Day #23. Wednesday, 11/12/2014: Word 7. Large Documents, Styles

Homework due Monday

Day #24. Monday, 11/17/2014: Word 8. Mail Merge

Homework due Wednesday

Day #25. Wednesday, 11/19/2014: PowerPoint 1

Homework due Monday

Day #26. Monday, 11/24/2014: PowerPoint 2

Homework due Monday (Wednesday is Thanksgiving vacation)

Day #27. Monday, 12/01/2014: PowerPoint 3

Homework due Wednesday

Day #28. Wednesday, 12/03/2014: Review for Final

Practice Tests

Homework due at the end of the period today:

 

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

Other search engines: Ixquick, DuckDuckGo, Blekko

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

Nate Silver, spring 2014: Who should learn to program? Journalists.

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

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

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

The future of Office: Microsoft Office 2019

What happens on the Internet in one minute

Bud logs in

Keeping track with KeePass: password manager

A “Knowledge Engine

Awesome Internet application: SkyDrive

How much junk is on your computer? Check it.

Nerd news: Leap Motion

How the Internet works

Where is the "cloud"?

How to acquire a Superpower. No mask, tights, or cape required.

Computer myths from TV and the movies

Printing a house

Visualizing data: 200 countries, 200 years

Some useful free programs

Prezi: an interesting PowerPoint alternative

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

Malwarebytes: removes malware

Paint.net: powerful photo-editor

Audacity: powerful audio editor

KeePass: password manager

Top 5 soon-to-be-obsolete technologies

Windows 8

Computer Hardware

Useful program: Belarc Advisor