Make your own free website on Tripod.com

 

 

 

 

 

 

 

 

CS205 COURSE HOMEWORK

Computer Literacy and Office Automation

Instructor: Joe Sunday

JosephJSunday@Hotmail.com

237-0985

 


Computer Concepts Module   Printed and Online

 

Procedure for Answering Questions:

For these questions you are required to supply typed answers.  Use any word processing software, such as Notepad. WordPad or Word, to record the answers to the questions.  The first items typed in the file should be your name, the assignment number and the section number.  Do not worry about formatting the document.  Save and print the document and turn it into the INBOX at the front of the room.     

 

Assignment 1: Read:  Computer Concepts Book - Unit A

Do:      Fill in the Best Answer on page 29

 

Assignment 2: Read:  Computer Concepts Book - Unit B

Do:      Fill in the Best Answer on page 61

                               

Assignment 3: Read:  Computer Concepts Book - Unit C

Do:      Independent Challenge 4 on page 94

                

Assignment 4: Read:  Computer Concepts Book - Unit E

Do:      Fill in the Best Answer on page 157

 

Assignment 5: Read: Office XP Book – Intro to Computers – Pages COM2 – COM30

 

Note:  To do this assignment on campus, you must obtain your Wright State student account from Computing and Telecommunications Services.  All WSU students are assigned accounts.  You will need to pick up the account information at the CATS help desk in the basement of the Library Annex. (Room 025) – bring a picture ID.

The mail reader used here on campus is http://webmail.wright.edu

 

Part 1 -       Do questions 1 (MC and Short Answer only) and 5 on page COM31.  As stated in the instructions in the book you will be using the website www.scsite.com/off2002/exs.htm and you should print your answers.

                 

Part 2 -      Look through web sites to find the computer system you would personally want to purchase.  Some popular manufacturers that you are likely to find on the web are Dell, Gateway, IBM and Apple or web sites for stores like BestBuy, CompUSA or Target.  You are not limited to these vendors.   E-mail me the web page that shows the information about the computer you chose.  Send the e-mail to me and in the body of the e-mail include your full name and the reason you choose the computer that you did.


Windows Module (1 assignment worth 5.5 points) – Written

 

 

Read:   Computer Concepts Book - Unit D

Microsoft Office – Introduction to Windows pages INT 1.04 – 1.61

 

Part A:

In the Concepts book, look at the file organization options in Question 1 of Independent Challenge 3 on page 126.  Consider the hard disk methods given in options a – g and choose the method that you like best and write a paragraph on the advantages and disadvantages of that method.

 

Part B:

Type in the definitions, instructions or step by step procedures for each of the following.

 

1)       What is an active and inactive window

2)       What is a path of a given file – include an example

3)       How do you show file properties

4)       What are the different views in Windows Explorer

5)       How does a file become fragmented

6)       What does a file that has an exe or com extension do

7)       Define the terms Byte, KB, MB, GB

8)       Define the terms root, subdirectory and file

9)       How do you do a proper shutdown of Windows

10)    How do you change a file name

11)    How do you erase files

12)    How to select a series of adjacent files from a list

13)    How to select a series of non-adjacent files from a list

14)    How to move and copy files from a drive/folder to another

15)    How to maximize, minimize and restore a window

16)    How to Format a disk

17)    Find (or search) for a specific file

 

 

Procedure for Printing Future Assignments:

All future printouts must have a required “header” and “footer”.  The header must have your name and the assignment number.  The footer must have your section number and the current date.  This required information can be positioned anywhere across the top and bottom of the page.

Note:   If you complete the homework assignments outside of the CS205 lab, the files must be in a format readable by Office XP.  You are responsible for presenting the files in a readable format!

 

Word Processing Module (2 assignments totaling 15 points) – Printed

Assignment 1: Read:  Microsoft Office - Word Project 1

Do:  Cases and Places 3, page WD 1.70

The finished results should be similar to the example in the chapter and must be on one page.  You must use each of the topics learned in this chapter and lecture (examples: bold, underline, italics, size, bullets….). Be sure to include the required header and footer. 

 

Assignment 2:  Read:    Microsoft Office - Word Project 2 (entire chapter) and 3 (pages 3.49-3.56)

Do:   In The Lab 2, page WD 2.60-2.62 (Part 1: Steps 1-5 and Part 2: Steps 1-5, 7-11)

-         The assignment requires a specific header and you should also include my required header and footer. 

-         In part 2 step 9, also use the help menu to remove the endnote separator.

-        Before part 2 step 11 do the following:  After the last paragraph of text, before the work cited page, insert a table containing a list of application software categories and their use (example: word processing, spreadsheets….).  The table should then be formatted to Classic 1 style and single spaced.  Your finished product will be on multiple pages.  Print the paper and handwrite the number of words, including the footnotes, on the print out.


Spreadsheet Module (3 assignments totaling 25 points) – Printed

*Assignments will not be accepted without “formula printout”*

Make sure that the whole formula is showing.  Points will be taken off if we can not see the whole formula. 

Assignment 1: Read:  Microsoft Office - Excel Project 1

Do:  In The Lab 1, page E1.58

Use the following clarifications for the specified steps provided in the book.

-         Skip step 6 (do not create a chart).

-         In step 7, type the requested information in cells A11:A15.

-         Before you print in step 9, be sure to include the required header and footer.

-         After step 10, display the formulas and then print again.  This formula printout should be in landscape and on one page.

-         Skip step 11 and save the revised spreadsheet.

 

Assignment 2: Read: Microsoft Office - Excel Project 2

Do:   In The Lab 1, page E2.69-2.70

Use the following clarifications for the specified steps provided in the book.

-         In step 3, use the sum function.

-         In step 11, make sure you have the proper header and footer and make sure it prints on one page.

-         In step 12, print the formulas in landscape on one page.

-         Skip steps 13-14.

-         After you are done with the steps in the book, create a 3-D pie chart using the Employee Names and their Net Pay.  Include a title, no legend, and with category name and percentage showing.  Create the chart as a new sheet.  Once it is finished, increase the title font, bold the labels, explode the smallest pie piece and elevate the chart to 50.  Add the required header and footer before printing.

-         Turn in your three printouts.

 

Assignment 3: Read:  Microsoft Office – Excel Project 3

Do:   In The Lab 1, page E3.69-3.71 (Part 1 and 2 only)

Use the following clarifications for the specified steps provided in the book.

-         In step 4, format column B-H to a width of 11.57

-         In step 5, format the assumptions so that they look the same as shown.

-         In step 7, be sure to use the “Absolute Reference Rule of Thumb” that we discussed in class.  Try to create your own formulas using the “math equation in words” given and do not look at the actual formula with cell references that is also given.

-         Before you print in step 10, add the required header and footer.

-         Skip step 11

-         In Part 2, include the required header and footer then print the chart only.

-         After you finish Part 2, go back to the spreadsheet and use the goal seek to determine a margin (cell B24) that would result in a net income in 2009 of $5,000,000.  Print the chart again and on that printout hand write the new margin that the goal seek computed.

 

Extra Credit: (5 points)  Do:  Cases and Places Number 1, page E3.79

There are few specific requirements for this assignment.  You still need the required header and footer.  With the information given in the case calculate the requested information.  You will have two sets of assumptions (% of output for each flower and price for each). You should use absolute references where needed.

Format the worksheet to look professional and print on one page.  Display the formulas and print again (in landscape and on one page).  Print the chart with the required header and footer.

 


Database Module (3 assignments totaling 25 points) – Printed

 

**You MUST use Office XP to complete the Access Assignments**

 

Assignment 1:  Read:  Microsoft Office – Access Project 1

Do:  In The Lab 1, page A1.56

Use the following clarifications for the specified steps provided in the book.

-         Skip steps 4 and 7. 

-         During step 9, when you create the report, include you full name in the title of the saved report.  Print the report.

-         When you are finished with the steps in the book do the following steps:

10)   Open the Product table in datasheet view.  Highlight all of the records.  Copy the records into the “clipboard memory”.

11)   Click on the Start button and open Microsoft Word.  In a new document make the file landscape and insert your required header and footer.  Paste the records from the “clipboard memory” into your Word document.

12)   On the task bar at the bottom of the screen, click on the Microsoft Access button.

13)   Open the Supplier table in datasheet view.  Highlight all of the records.  Copy the records into the “clipboard memory”.

14)   On the task bar at the bottom of the screen, click on the Microsoft Word button.  Paste the records from the “clipboard memory” into the Word document with the other table.  Print the document from Word with both tables (in landscape) and on one page.

15)  Turn in both printouts.

 

Assignment 2:  Read:  Microsoft Office – Access Project 2

Do:   In the Lab 1, page A2.44-2.45 (Continuation of Assignment 1)

DO NOT PRINT EACH STEP!!

Use the following clarifications for the specified steps provided in the book.

-         For each step, where it says to print, you should “SAVE AS” the query onto your disk.  Use the step number from the book to individualize the queries.

-         In step 2, do not use the “Simple Query Wizard”.  Create all queries in Design View

-         Skip steps 3, 7, 11, and 16.  (You should have 10 queries when finished.)

-        When you are all finished, open each query and copy to word as explained in Assignment 1.  You should be able to fit the results of all the queries on 2-3 pages.  Print these pages from Word.

 

Assignment 3:  Read:  Microsoft Office – Access Project 3

Do:   In The Lab 1, page A3.52-3.53 (Continuation of Assignment 2)

Use the following clarifications for the specified steps provided in the book.

-         Skip steps 2, 7, 10, and 14-15

-         Print the contents of the Product and Supplier tables as described in Assignment 1.  Turn in this printout along with your written answers from step 3.

 

Extra Credit: (5 points)  Do:  Cases and Places 1, page A1.62, A2.48 and A3.58

-         In the first chapter, create the tables explained in the book.  You will have one table for the clients and another table about the helpers.  After you have all of the data entered you will print the tables using the same instructions given in Assignment 1 and using the required header and footer.

-         In the second chapter, create and save 3 of the 6 queries given.  Print the results of these queries as you did in assignment 2.

-         In the third chapter, step (b) create the validation rule asked for and another of your own choice.

-         Print the tables again – using the same instruction in Assignment 1 with header and footer.  On your printouts record the following information:

-         Validation rules - Write on your printout EXECTLY what you typed in as the validation rules.

-         Your analysis of the database requested in step (d).

 


Presentation Graphics Module (1 assignment at 10 points) – On Disk or by E-Mail

 

Assignment 1:  Read:  Computer Concepts Unit F

Microsoft Office – PowerPoint Project 1 and 2

Do:  Create a PowerPoint Presentation on your own:

-         Choose a couple of pages from the Computer Concepts pages listed above, using the topics covered on those pages create a presentation that is at least 5 slides in length.

-         Use whichever template design you want.

-         You must use each of the following four slide layouts (at least one time each) then you can use any other layouts you wish:  Title Slide, Bulleted List, 2 Column Text and Text & Clip Art

-         On the Title Slide, include your name and the section number as the sub-title.  The section number should be a smaller font then your name.  Bold and Italicize your name.

-         Be sure to save the file to your disk often so that you do not loss your information.

-         On at least your 2 column text slide, you must use at least three levels of bullets.

-         On one slide, double space at least one paragraph.

-         On all of the slide, change the first level bullet to a picture of a disk (from the Wingdings Font).

-         On all of the slides, change the Title Font color to a shade of green.

-         Choose one slide and change the background color to something other then what it was originally.

-         Include a header/footer on all slides that contains the date, your name, and the slide number.

-         Relocate your title slide to the end of the presentation.

-         Add an appropriate clipart to your Text & Clipart slide.

-         Choose one transition style and apply it to all of the slides.

-         On your 2 Column Text slide, apply a build effect that is grouped by 3rd level paragraphs.  Apply to both columns of text.

-         Spell check your presentation.

-        This assignment is NOT printed.  When you are all finished, turn in your disk for grading.  Make sure your name and the file name are written on the label of the disk.