CSCI100 Intro to Computers

Updated 2014.04.23

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 #22. Wednesday, 4/23/2014. Word 6: Newsletter skills

·        Skills needed in the workplace, 2014-2020

·        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.

 

Earlier classes are below…

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Day #21. Wednesday, 4/16/2014. 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 #20. Monday, 4/14/2014. 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 #19. Wednesday, 4/09/2014. Word 3. Positioning text with tabs

·        Windows XP

·        History: IBM 360

·        Word 2013 resources.

Homework

·        None.

Day #18. Monday, 4/07/2014. 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 #17. Wednesday, 4/02/2014. 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 #16. Monday, 3/31/2014. Excel Test, Part 2.

Day #15. Wednesday, 3/26/2014. Excel Test, Part 1.

Day #14. Monday, 3/24/2014. Excel 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 #13. XL 12. Wednesday, 3/19/2014. 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 #12. XL 11. Monday, 3/17/2014. §Databases: Advanced Filters and "D" Functions

·        Excel Resources.

Homework

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

Day #11. XL 10. Wednesday, 3/05/2014. VLOOKUP, another way to make decisions

·        Excel Resources.

Homework

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

Day #10. XL 9. Monday, 3/03/2014. 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 #9. XL 8: Wednesday, 2/26/2014. 3D Workbooks

·        Excel Resources.

Homework

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

Interesting Stuff

·        Microsoft Office 2019

Day #8. XL 7. Monday, 2/24/2014: Databases: Pivot Tables, Pivot Charts

·        Excel Resources.

Homework

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

Interesting Stuff

·        What happens on the Internet in one minute

Day #7. Wednesday, 2/19/2014. 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 #6. XL 5. Monday, 2/17/2014: Charts

·        Excel Resources.

Homework due Wednesday, 2/19

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

Day #5. XL 4. Wednesday, 2/12/2014: 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.

Interesting Stuff

·        Keeping track with KeePass: password manager

Day #4. XL 3. Wednesday, 2/05/2014: 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.

Interesting Stuff

·        How secure is your password? Check it.

Day #3. XL 2. Monday, 2/03/2014: 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.

Interesting Stuff

·        A “Knowledge Engine

Day 2. Wednesday, 1/29/2014: 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 #1. Monday, 1/27/2014: 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 #23. Monday, 4/28/2014Word 7: Large Documents

·        Word styles and large documents. Word 2013 resources

Homework

·        Styles: Web design document. Instructions. File to edit. Put your Word document in the drop box.

Day #24. Wednesday, 4/30/2014. Word 8: Mail Merge

·        Word 2013 resources

Homework

·        Mail Merge. Put both of your files in the drop box at the same time. Your solution will look something like this (multiplied by 18).

Day #25. Monday, 5/05/2014. PowerPoint 1

Homework

Day #26. Wednesday, 5/07/2014. PowerPoint 2

Homework

Day 27. Review for Word/PPT final.

Practice Tests

Assignment due at the end of the period

 

·Nerd news: Leap Motion

Some useful free programs

Final Test