CSCI100 Intro to Computers

Updated 2014.05.07

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, May 12 (9:00 section) or Thursday, May 15 (8:00 section). Test is from 8:00 to 9:50.

Day #1.  Windows, Internet

·        Syllabus

·        BCU IT Competency: Requirement, Objectives

·        Get Office:

1.      Buy Office 365 University. $80 for 4 years.

2.      Download a 1-month free trial.

3.      Free online version with SkyDrive.

·        Using the Briar Cliff Network

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

·        Windows: Windows 7, Windows keyboard shortcuts

·        Internet: Internet Resources

Homework due Wednesday:

·        Class policies for assignments and tests (print, 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.

·        Web scavenger hunt. Insert your answers into this Word document and put in the drop box.

·        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. XL 1. Formatting

·        Keyboard shortcuts quiz

·        Excel Resources. Sample file

Homework due Monday, 2/03/2014 at 7:30 a.m.

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

Day #3. XL 2. Formulas and Relative Cell References

·        Excel Resources.

·        Sample file.

Homework due Wednesday, 2/05/2014 at 7:30 a.m.

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

Day #4. XL 3. Formulas with Absolute/Mixed Cell References

·        Excel Resources.

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

Homework due Monday, 2/10/2014 at 7:30 a.m.

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

·        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 #5. XL 4. Databases: Sorting and Filtering

·        Windows keyboard shortcuts quiz

·        Excel Resources.

Homework due Monday, 2/17

·        Iowa Football. Deposit a digital copy in the drop box.

Day #6. XL 5. Charts

·        Excel Resources.

Homework due Wednesday, 2/19

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

Day #7. XL 6. Logical Functions

·        Excel Resources.

Homework due Monday, 2/24/2014

·        Logical functions: College Admissions. Deposit a digital copy in the drop box.

Day #8. XL 7. Databases: Pivot Tables, Pivot Charts

·        Excel Resources.

Homework

·        Pivot tables: Product Sales. Deposit a digital copy in the drop box.

Day #9. XL 8: 3D Workbooks

·        Excel Resources.

Homework

·        3D Workbooks: Jewelry Sales. Deposit a digital copy in the drop box.

Day #10. XL 9. Financial Functions

·        Excel Resources.

·        Financial functions template

·        Financial functions examples

Homework

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

Day #11. XL 10. VLOOKUP, another way to make decisions

·        Excel Resources.

Homework

·        VLOOKUP: Auto Insurance. Deposit a digital copy in the drop box.

Day #12. XL 11. Databases: Advanced Filters and "D" Functions

·        Excel Resources.

Homework

·        Advanced Filters, “D” functions: Employees. Deposit a digital copy in the drop box.

Day #13. XL 12. Dates and Times

·        Excel Resources.

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

Homework

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

Day #14. XL Review.

·        Excel practice test: Test file, Sheet 1 instructions, Solution file, Solution Video part 1, Solution Video part 2, Solution Video part 3

·        The first part of the Excel test will be Wednesday, 3/26/2014. It is hands-on, open-book. It will cover formatting, relative and absolute cell references, sorting and filtering, pivot tables, and charts. All remaining topics will be covered on Monday, 3/31/2014.

Day #15. Excel Test, Part 1.

Day #16. Excel Test, Part 2.

Day #17. Word 1: Skills for writing a short document

·        Word 2013 resources.

·        Today's sample file.

Homework

·        Film Festival. Instructions. Unformatted file. Your solution should look like this.

Day #18. Word 2: Skills for writing a term paper

·        Word 2013 resources.

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

Homework

·        Treasure Island. Instructions. Unformatted file. Your result should look like this.

Day #19. Word 3. Positioning text with tabs

·        Word 2013 resources.

Homework

·        None.

Day #20. Word 4. Positioning text with tables

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

·        Word 2013 resources

Homework

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

Day #21. Word 5: Images

·        Word 2013 resources

·        Pics: Desert, overexposed, underexposed

Homework due Wednesday, 4/23/2014 at 7:30 a.m.

·        Fourth of July poster. Instructions. Create from scratch. Your result should look like this.

Day #22. Word 6: Newsletter skills

·        Word 2013 resources

Homework

·        Newsletter. Instructions. Unformatted file. Your result should look like this. Note that the line between the columns did not display in this view, even though the line is there.

Day #23. Word 7: Large Documents

·        Word styles and large documents. Word 2013 resources

Homework due Wednesday, 4/30/2014 at 7:30 a.m.

·        Styles: Path-works document. Instructions. File to edit. Your document should look like this.

Day #24. Word 8: Mail Merge

·        Word 2013 resources

Homework due Monday, 5/05/2014 at 7:30 a.m.

·        Mail Merge. Instructions. Your solution will look something like this (multiplied by 18).

Day #25. PowerPoint 1

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

Homework due Wednesday, 5/07/2014 at 7:30 a.m.

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

Day #26. PowerPoint 2

·        Evaluations

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

·        Word practice test.

Homework due at the end of the period today:

Homework due Monday, 5/12/2014 at 7:30 a.m.

·        Twins, 2012. Put your PowerPoint file in the drop box.

Practice Tests

·        Word practice test: Instructions, Sample file, Video solution

·        PowerPoint practice test: Instructions, Sample file, Video solution

 

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

·        How secure is your password? Check it.

·        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