MSWord Lab Assignment #1

Open this file and complete the assignment as described on page 70 (don't forget to proofread it for spelling, grammar and punctuation). You will need to follow Chapter 1, with

• your name on the cover as first author, and three other names, with no page number on the cover.
• prepared for your Philosophy 101 class.
• a date that updates automatically so that it will show the date when I open it.
• extra page break(s) removed

I'll show some sample solutions from my jump drive.

Print and hand in the document, and e-mail me the Word file as an attachment. It should be called something like:

beatty_word1.docx

Due next class, Monday, Sept. 8.

MSWord Lab Assignment #2

Open this file and complete the assignment as described on page 132. As before, spellcheck, but also proofread. You will need to use the skills outlined in Chapter 2 (and don't forget the "yellow" pages for step-by-step if needed). Also

• Add your name to the front cover (By John Beatty CSC151) in a different color and font size. As before, no page # on the cover. Make it a plain page (insert a page break).
• Create a TOC (Table of Contents) page (p. 1). It should include all the Heading 1 styles (6) and the Index. Use tabs plus leaders for the page numbers
• Use page numbers with shapes on the bottom of the page
• Put the company name and Annual Report in a footer
• Justify the text (alignment) and set line spacing to 1.5
• Put a double border around the list of divisions and set tabs to align the name, city and number
• Add a bullet list for the key Goals for 2008 items, and change the type of bullet from the default (circle)
• Add a numbered list to the six steps at the end of that same section with numbers and parentheses: 1) etc.
• Make an Index with at least six items and format it in two columns.

Again, take note of the sample I will show from my flash drive.

Print out and also e-mail the file as an attachment.

It should be called (use your real last name)

lastname_word2.docx

Due Monday, Sept. 15.

MSWord Lab Assignment #3

Complete the assignment described on p. 196. There is no text file to open. You will be making a one-page flier from scratch, with

• A table to organize the list of event categories, with table styles and some border/shading effects
• Word Art for the title: Poconos Science and Engineering Fair (note the change). Include a style that uses reflected text
• Dates are (now) October 4 through October 6 (use an en dash) and the place is La Salle
• Your name, phone and e-mail address as the contact person. Call yourself the Assistant Coordinator
• A link to La Salle's home page (not the portal) below your contact information
• Clip art beside the categories, and in the bottom right. Make sure that the bottom one has a transparent background

As before, take a look at the examples on my flash drive.

Print out and also e-mail the file as an attachment.

It should be called (use your real last name)

lastname_word3.docx

Due Monday, Sept. 22

Test #1

Excel Lab Assignment #1

Complete the assignment described on p. 70. Start with this file (it already has some formulas in it) and:

• Enter your name
• Use a Date format (Home tab) that fits in the cell
• Use the Accounting format so that amounts display as $1,000, and so on
• Change the date of the event to 29 May 09 and add a comment to that cell (see p. 114)
• Make the top (title) cell text Arial bold, light gray, with a blue background
• Use a formula for cost of reception in D10 and E10 (where's that info?)
• Add a double border on the cells above the totals (Cells group-Format Cells)
• Add a footer with the class name CSC151 and a page # (Page layout tab, and a Custom footer)

Due Monday, Sept. 29. We'll leave some time to finish it then, if need be.

As before, take a look at the examples on my flash drive.

Print out (landscape) and also e-mail the file as an attachment.

It should be called (use your real last name)

lastname_excel1.xslx

Excel Lab Assignment #2

Complete the assignment on p. 138 (also handed out). Start with this file and:

• Add your name in A26 and the date (use Today function) in A27
• Add a footer that has a page number and the text "CSC 151"
• Add background color to the title, change the font color there
• Indent the Revenue and Expenditure items (Home-Alignment)
• Add the same background color to the Net Margin row to emphasize it
• Net Operating Margin = total revenue - total expenditures
• Net Margin = Net operating margin - capital projects
• Set up reference cells for the 10% increase and 8 % increase in columns N and O to use in your formulas
• Your Net Margin in 2012 will be $5,844,412
• Create an IF function in cell F26 that tests whether that amount is > $5,000,000 and returns "OK" if it is (and "NO" if it was not). Hint: You'll need to use the exponentiation operator: ^ .

Due Monday, Oct. 6. We'll leave some time to finish it then, if need be.

As before, take a look at the examples on my flash drive.

Print out (landscape, 3 pages total) and also e-mail the file as an attachment.

It should be called (use your real last name)

lastname_excel2.xslx

Excel Lab Assignment #3

Complete the assignment on p. 188 (also handed out). Start with this file and:

• Add a custom footer to the worksheet and the chart, with CSC 151 and an automatic date (see p. 224)
• Use Autosum to get totals for the table
• Format the numbers in the table as Number and decrease decimals to zero
• Align, bold numbers and use borders on table; merge and center the title and make the text white in a black box
• Make a chart on a separate worksheet labelled "Enrollment chart"
• Put the legend at the bottom
• Write your own MSWord memo (.docx) of three sentences that summarizes the trends, suggests reasons for the trends, and concludes that the trends are likely to continue in the near future
• The memo needs to include the embedded chart and table that you make in Excel, and an auotmatic date in the header (Usual categories: To, From, Subject, Date)
• Add an appropriate graphic (clip art) to the chart beside the title (The Changing Student Population)

Due Wednesday, Oct. 8. We'll leave some time to finish it then, if need be.

As before, take a look at the examples on my flash drive.

Print out (landscape, 2 Excel pages plus the Word report) and also e-mail the two files as attachments.

It should be called (use your real last name)

lastname_excel3.xslx
lastname_excel3.docx

Test#2

Break

PowerPoint Lab Assignment #1

Complete the assignment described on p. 70. Start a new presentation and make 6 slides with appropriate graphics (clip art, photos):

1. Title slide
2. Introduction
3. Goals
4. Background
5. Awards
6. Summary/conclusion + contact information

• Apply a theme (Design tab)
• Set up a transition from each slide to the next (Animations—can be the same for all)
• Animate at least one image with one of the preset animations (Fade, Wipe, Fly-in)
• Animate one other image with a custom animation (Entrance, Emphasis or Exit) that activates On Click
• Add Notes to the second slide that give your name, and "CSC PowerPoint #1"

Due Monday, Oct. 27. We'll leave some time to finish it then, if need be.

As before, take a look at the examples on my flash drive.

Print out as handouts, 4 per page, and also e-mail me the file as an attachment.

It should be called (use your real last name)

lastname_power1.pptx

PowerPoint Lab Assignment #2

Complete the assignment described on p. 144. Start a new presentation and make 8 slides with appropriate graphics (clip art, photos):

1. Title slide ("Honoring Our Explorers")
2. Introduction (Presentation to ...)
3. Current situation
4. Benefits of the voyage
5. Outline of plan/routes
6. List of provisions
7. Qualifications of the explorer
8. Summary/why the voyage is needed

• Download an online template (see handout for some suggestions)
• Reset the background for one of the slides (Design tab)
• Set up a transition from each slide to the next (Animations—can be the same for all)
• Animate three slides with a title that Fades, Wipes or Flies in, and then that activates With Previous so that the tile fades in and then other text/images enter without another click (see demo on flash drive)
• Add Notes to the first slide that give links to your sources for the information (e.g. wikipedia.org, about.com)
• Create a footer that has your name and the slide number

Due Monday, Nov. 3. We'll leave some time to finish it then, if need be.

As before, take a look at the examples on my flash drive.

Print out as outline view, and also e-mail me the file as an attachment.

It should be called (use your real last name)

lastname_power2.pptx

PowerPoint Lab Assignment #3

Complete the assignment described on p. 206. Start with this file and finish the 7 slides as in the handout:

1. Title slide ("Beatty Performing Arts Center")
2. About the center
3. Revenue projection 3-D column chart
4. Project timeline w/Art
5. Sponsorships (pyramid)
6. Organization chart (committees)
7. Conclusion-slogan-Please help ...

• Add appropriate sound to the first slide that plays when that slide is on. Also set the speaker icon so that it is hidden during the slide show
• Edit, spell check as usual
• Change the chart style on slide 3
• On the fourth slide, in addition to creating Smart Art with a style, format the three text boxes with Shape Styles so they look like buttons
• On the fifth slide, create Smart Art with a pyramid layout, change colors and apply a style. Size text to fit if needed.
• On the sixth slide, create Smart Art with an Organization Chart (Hierarchy group); use the text pane to enter text and create boxes; use Demote-Promote to set up the levels (Design-Create Graphic group); change the color in the Smart Art Styles group; (bonus--there's still a spelling error in the committee info)
• Add an auto shape or a freeform shape with a texture fill and shape effect (glow, shadow, etc.) to the final slide
• Create a footer that has your name and CSC151 on the Handouts

Due Wednesday, Nov. 5. We'll leave some time to finish it then, if need be.

As before, take a look at the examples on my flash drive.

Print out as handouts, 4 per page, and also e-mail me the file as an attachment.

It should be called (use your real last name)

lastname_power3.pptx

Dreamweaver/Web assignment

You will create and publish online a personal 5-page Web site using Dreamweaver.

It must be published and viewable online. You need to e-mail me the URL so that I can view the site. It will be of the form:
http://www.lasalle.edu/~smithj1/index.html

The five pages will have the following content (order is up to you after the home page). Start with a 2-column fixed right sidebar header and footer layout. You can then use Save As to make your other 4 pages:

1. Home page. This needs to briefly explain what the site contains, and what the user can do or see there.
2. About me/Interests. Include a paragraph describing who you are, where you're from, and so on. Mention any La Salle organizations, other volunteer or organized activities, hobbies, some favorite TV show, movies, music.
3. Portfolio. This will include links to work you've done at La Salle (including for this class) or before. Remember that if you link to any MSOffice file it must be saved in Office 97-2003 format (.doc, .ppt. .xls). You must post a minimum of five documents.
4. Links. Places on the Web that you think are important, useful and interesting. Include a brief description of each site on this page so that the user knows what to expect there. Post at least 5 links.
5. Photo Gallery. Put up pictures of yourself, friends, activities—whatever you think will make your site interesting both for entertainment, but also for career puposes later on. Remember the basic formats: JPEG for photographs, and GIF for cartoons or graphics.
   The gallery will be built in a table with thumbnails that link to the larger images, and alt text that explains each one.

We will add details to these as we go. The completed Web site is due posted online now Monday, Dec. 8 (as we said, e-mail me the URL so that I can view the site).