CSCI 105 Dr. Yessick
Introduction to Computer Applications

Contact

	dyessick@coastal.edu
	dyessick@gmail.com

Syllabus

Syllabus

Assignments

Assignments Ch 5, 6, 7

To be Completed by March 15.

• Ch 5. Complete the Skills Review on page 148. Share your document as view only with dyessick@gmail.com.
• Ch 5. Create a resume (it may be very basic or as elaborate as you wish). Share your resume as view only with dyessick@gmail.com. Export your resume as a pdf and email it as an attachment using your gmail account to dyessick@gmail.com.
• Ch 6. Complete the Skills Review on page 177. Share your sheet with dyessick@gmail.com.
• Ch 7. Create a short presentation (5-7 slides) on a subject of your choosing. Invite dyessick@gmail.com to a live presentation. Export the presentation as a PDF and email it as an attachment using your gmail account to dyessick@gmail.com.

Excel Assignments CH 8,9,10,11,12

To be Completed by April 21.

Overview of Excel Assignments and Grading

I have divided the excel work into three sections. Each section will carry equal weight. Note this is true even if one section has more work in it.

You may skip any instructions that direct you to print.

You may combine the workbooks for each section submit one book with multiple sheets. Add a sheet with just your name/section/date on it.

Include your name, section (or time/distance) and chapter in the file name and in the workbook (preferably on every sheet).

Submit your work to dyessick@gmail.com using your gmail account. Include your name in the message and csci105 in the subject line.

chapter files for excel. The chapter files for excel are also on the resource disk that came with your book. The chapters are misnumbered on the resource disk. For example, Chapter 8 of your book request files named chapter 1. On the resource disk the chapter may be 12, I have forgotten.

If you have trouble downloading the resource files from the web (for example if they download as zip files that don't make sense), you should use your resource disk to grab the files.

• Section 1
  • Chapter 8

    Nothing to submit.

  • Chapter 9

    You may combine the workbooks and submit one book with multiple sheets. Include your name, section (or time/distance) and chapter in the file name and in the workbook (preferably on every sheet).

    • Exercise 3 pg 323 High School Art Collection
    • Exercise 4 pg 324 Financial Functions
• Section 2

  Chapter 10 You may combine the workbooks and submit one book with multiple sheets. Include your name, section (or time/distance) and chapter in the file name and in the workbook (preferably on every sheet).

  • Exercise 2 pg 378 Comparison of Rows and Columns
  • Exercise 3 pg 379 Home Arts
  • Exercise 4 pg 380 Study Analysis
  • Exercise 5 pg 381 Computer Sales Analysis

• Section 3

  Warning -- Historically this material is particulary challenging. Read the chapters carefully. If you are stuck move on to the next one.

  • Chapter 11
    • Exercise 4 pg 411 Sample Size and Confidence Levels
    • Exercise 5 pg 411-412 Thermocouple Calibration Curve
    • Exercise 7 pg 413 Extracting Vanilla
  • Chapter 12
    • Exercise 4 pg 449 Loan Calculations IV
    • Exercise 7 pg 450 Time-Value-of_Money II

PowerPoint Assignments (Second Book)

To be Completed by May 1.

Overview of PowerPoint Assignment and Grading

Since many of you are still struggling to complete the excel assignments, the powerpoint assignment is being issued as a elective bonus assignment. I will give it the same weight as one section of the excel assignments.

I didn't have the opportunity to select the text for this course. I'm not a huge fan of our powerpoint text. While it has all the information you need to complete the assignment it is lacking in graphics and illustrations. For this reason I'm posting alternatives sources of information to the textbook. You can use these online resources or your text to complete the assignment.

MS PowerPoint articles

Basics
Views
Adding a background
Smart Art
Animating Smart Art
Office Online PowerPoint Help
Office Online PowerPoint Demo's

The Assignment

Create 5 slides

Use master view to format the background using a gradient fill with green to yellow.

Applay a transition to each slide

I don't care about content. The goal is learn specific features of the tool. The 5 slides should be as follows.

1. A title slide with your name. The title can be be just CSCI 105 PowerPoint. You name is the critical component.
2. Create a slide with a heading, 4 bullets items, and some clip art. For full credit one bullet item should have 3 sub-bullets. Add an animation to one or more bullet points.
3. A slide with two photographs. For full credit add picture frame borders. Overlap the images and fade the back image (You can do this two or three different ways, any will do. Adjust the image transparency, or brightness is easiest). Tilt the images 15 degrees. Add a caption under one of the images.
4. Add smart art (any). For full credit animate the smart art.
5. Use shapes and lines to draw a house. For full credit animate the objects so that the house is constructed when the slide starts and deconstructed after a few seconds.

Notes:
"clip art," "pictures/images," and "smart art" are distinct items in power point lingo. Do not confuse smart art with clipart, as they are not the same thing. Clip art itself comes in two varieties. Gif images are traditional forms of clip art. PowerPoint also supports vector graphics. Vector graphics are often require less memory and they are decomposable as well. The 5th slide (Animated house) is built using vector graphics.

Office Hours and Appointment Availability

	Monday	Tuesday	Wednesday	Thursday	Friday-Sunday
0900	Prep	Appointments	Prep	Appointments	R o b o t i c s
1100	Lunch
1230	Appointments	CSCI 140-03 CSCC 319	Appointments	CSCI 140-03 CSCC 319
0145	Office
0230	CSCI 140L-03 CSCC 321	Appointments	CSCI 140L-03 CSCC 321	Appointments
0430 ...	R o b o t i c s