CSCI100 Intro to Computers

Updated 2014.11.24

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 #25. Monday, 11/24/2014: PowerPoint 1

·        Interesting technology: Mini-drones

·        PowerPoint Resources.

·        Sample file

Homework due Monday, 12/01/2014

·        A Briar Cliff Christmas. Put your PowerPoint file in the drop box.

 

Earlier classes are below…

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Day #26. Monday, 12/01/2014: PowerPoint 2

·        PowerPoint Resources. Watch the videos for Day #2.

Homework due Wednesday

·        Sioux City Summer. Pics. Put your PowerPoint file in the drop box.

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

·        Word practice test.

·        Evaluations

Practice Tests

·        Word practice test: Instructions, File to edit, Video solution

·        PowerPoint practice test: Instructions, File to edit, Video solution

Homework due at the end of the period today:

·        Questionnaire.

Day #24. Wednesday, 11/19/2014: Word 8. Mail Merge

·        Star Trek universal translator

·        Skype with anybody, anywhere!

·        Word 2013 resources

Homework due Monday

·        Mail Merge. Instructions. Put BOTH files in the drop box at the same time. Hand in TWO files: (1) the Invitation Template (should be 1 page long) and (2) the Invitation Letters file (should be 14 pages long).

Day #23. Monday, 11/17/2014: Word 7. Styles

·        Free computer security. Don't pay for it.

·        Word 2013 resources

·        User guide, Wizard of Oz

Homework due Wednesday

·        Styles: Web design document. Instructions. File to edit.

Day #22. Wednesday, 11/12/2014: Word 6. Newsletter skills

·        Keeping track of password with KeePass: password manager

·        Word 2013 resources

Homework due Monday

·        Newsletter. Instructions. Unformatted file.

Day #21. Monday, 11/10/2014: Word 5. Images

·        Paint.net: powerful photo-editor

·        Word 2013 resources

·        Pics: Desert, overexposed, underexposed

Homework due Wednesday

·        Superstar poster. Instructions. Create from scratch.

Day #20. Wednesday, 11/05/2014: Word 4. Positioning text with tables

·        Where is the "cloud"?

·        Another cut/paste option: source format or destination format? Doc1. Doc2.

·        Word 2013 resources

Homework due Monday

·        Tabs and tables. Instructions. Unformatted file. Your result should look like this.

Day #19. Monday, 11/03/2014: Word 3. Positioning text with tabs

·        Sprout

·        Word 2013 resources.

Homework due Wednesday

·        None.

Day #18. Wednesday, 10/29/2014: Word 2. Term paper skills

·        Just like Star Trek

·        Grade estimator

·        Word 2013 resources.

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

Homework due Monday

·        Christmas Carol. Instructions. Unformatted file. Your result should look like this.

Day #17. Monday, 10/27/2014: XL Test #2

·        Excel Test

Day #16. Wednesday, 10/22/2014: Word 1. Short documents

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

·        Word 2013 resources.

·        Today's sample file.

·        Excel practice test

·        Excel practice test solution

·        Excel practice test video

·        The test will be hands-on, open-book. It will cover financial functions, pivot tables/charts, 3D cell references, VLOOKUP, advanced filters and "D" functions, and dates/times

Homework due Wednesday (Monday is a test)

·        Letter to the President. Instructions.

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

·        Excel Resources.

·        Cool applications of Excel's date functions: Birthday, Calendar

Homework due Wednesday

·        Dates and Times: Employees.

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

·        Excel Resources.

Homework due Monday

·        Advanced Filters, “D” functions: Real Estate.

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

·        3D Printing

·        Excel Resources.

Homework due Wednesday

·        VLOOKUP: Gradebook.

Day #12. Wednesday, 10/08/2014: XL 9. Financial Functions

·        What happens on the Internet in one minute

·        Excel Resources.

·        Compound Interest

·        Financial functions template

·        Financial functions examples

Homework due Monday

·        Financial functions. Deposit a digital copy in the drop box. Use the Financial functions template

Day #11. Monday, 10/06/2014: XL 8: 3D Workbooks

·        Interesting stuff: 200 countries, 200 years

·        Excel Resources.

Homework due Monday

·        3D Workbooks: Sales.

Day #10. Wednesday, 10/01/2014: XL Test, part 1: XL1-XL6

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

·        Practice test

·        Practice test solution file

·        Practice test solution video: Part 1, Part 2 (watch in full screen, at HD resolution)

Day #9. Monday, 9/29/2014: XL 7. Databases: Pivot Tables, Pivot Charts

·        The future of Office: Microsoft Office 2019

·        Excel Resources.

Homework due Monday, 10/06/2014 (Wednesday is a test over Excel)

·        Pivot tables: Hawkeye Football. Deposit a digital copy in the drop box.

Day #8. Wednesday, 9/24/2014: XL 6. Logical Functions

·        Excel Resources.

·        Sample File.

Homework due Monday at 7:30 a.m.

·        Logical functions: Stock Recommendations. Deposit a digital copy in the drop box.

Day #7. Monday, 9/22/2014: XL 5. Charts

·        Excel Resources.

·        Sample file

Homework due Wednesday at 7:30 a.m.

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

Day #6. Wednesday, 9/17/2014: XL 4. Databases: Sorting and Filtering

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

·        Excel Resources.

Homework due Monday at 7:30 a.m.

·        Sioux City Weather. Deposit a digital copy in the drop box.

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

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

·        Excel Resources.

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

Homework due Wednesday

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

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

·        Nerd news

·        Excel Resources

·        Sample file.

Homework due Monday at 7:30 a.m.

·        Formulas: Commissions. Deposit a digital copy in the drop box.

Day #3. Monday, 9/08/2014: XL 1. Formatting

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

·        Excel Resources

·        Sample file

Homework due Wednesday at 7:30 a.m.

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

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.

Homework due Monday

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, 2014: 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, 2014-2020

Google Glass

How good is your password?

How much junk is on your computer? Check it.

How the Internet works

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

Inexpensive smart phone

Interesting displays

Cool printer

Internet of Things (IoT)

Johns Hopkins closes medical library

KeePass: password manager

Microsoft's vision of the future

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

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, 2014): Windows XP

Windows 8