Decimal-Fraction Pattern in Microsoft Excel

Mr. Paisley has given us another Excel assignment, and this time you have to discover the formula for filling out all the cells.

You’ll each get a sheet with all the relevant number values for a conversion from 1/1 t0 16/16 and all the fractional values in between. There is clearly a pattern that you can see where fractional equivalents occur (i.e. 1/1-16/16, 1/2-2/4).

Now, you can fill in all the numbers by hand if you wish. But you’ll receive higher credit if you figure out where to put the formula (and whether you should use $’s to lock in references to other cell values) and then use the Fill Handle Technique to automate the completion of the worksheet.

We’ve done that in the other four Excel assignments, so you know what dragging the Fill Handle is all about. This time you have to discover the formula. It’s not that hard.

Please use Microsoft Excel (not Google Spreadsheet) and then submit it the Student Journal by attaching it to your Response.

Good luck!

Publishing posters, programs and prompt books for Communication Studies

Another new project comes to us from Communication Studies. We’re going to use Microsoft Word and our special duplex (two-sided) printer to create and publish programs and prompt books for your Communication Studies production.

Here’s what you need to do:

1. Get your copy (scripts) handy. Although you made these in teams in Communication Studies, each one of you will need to produce a prompt book, program, and Photoshop poster for your team’s scenes.
2. Open a new document in Microsoft Word.
3. In “Page Setup,” choose landscape orientation, and change the margins to .5″ all the way around, left, right, top, bottom.
4. Start with your title page (you can put a picture on it if you want). Then enter your scripts just like they look in the script Ms. Dennett.
5. After we enter all the text, we go to “Page Setup” and choose “book fold.” Follow the instructions we say in the video. Important: you must save your document as “Word 97-2003 Document” by using the “save as” choice.
6. When we’re ready to print, you’ll submit the work to me, and I’ll explain how I set the printer to duplex printing. Then I’ll print your work for you.
7. We’ll need to do some special stapling with a special stapler from the office (I’ve got it in the room).
8. We’ll all do this for the programs as well as the prompt books. Every student has to make a program, with each team writer responsible for getting the scene synopsis and cast of characters for each group’s scene, based on the best synopsis of the group. Then email the material to each group member so every student can make a program using the winning synopsis for their group.
9. The programs need to include the synopsis and cast of characters for each group. Everyone should design one, but only the best will be used on the day of the presentation.
10. Posters (in Photoshop) need to include: 1. Communication Studies Present: Edited Scenes from Romeo and Juliet; 2. October 23rd 6:30 PM; 3. Cafegymatorium; 3. Use pictures of Shakespeare and Romeo and Juliet from the Internet. As with other Photoshop art, save as a JPEG to turn it in.

We could do the booklets in fancier, more expensive computer applications, but Word is just fine for this. Later, we can learn to do it like the professionals do, in Adobe InDesign.

As for the posters, use what you learned in the first Photoshop poster project.

By the way, I’ll be giving you grades for the production of each of these three connected projects. You may also get credit in Communication Studies, so it’s a two-fer!

Let’s Get Visual (about Geometry, I Mean)

Welcome to our next project. “Let’s Get Visual” is all about working on a number of skills at the same time. We can learn about slide shows in PowerPoint, line drawings and color fills in Illustrator, and the key formulas and theorems in Geometry. I wouldn’t be surprised if we learned some adjunct skills along the way.

(Adjunct -noun : something added to something but not essential to it.)

Here’s what we’re going to do:

1. Make landscape-oriented graphic images in Illustrator that depict the great formulas and theorems of Geometry, using the standard dimensions of a PowerPoint slide (960 x 720 pixels, or 10″ x 7.5″).
2. Design these images in the most artful yet direct way, i.e. creative, tasteful, colorful, and informative). Idea: How would Leonardo da Vinci, an artist, scientist, and mathematician, make these pictures?
3. As we do each one, we add it to our “Let’s Get Visual (about Geometry, I Mean)” slide show until we have built a great presentation of the many formulas and theorems that govern Geometry.
4. Write a script that explains each slide.

Things to remember:

• You can use color and fills.
• You can’t copy and paste drawings of the formulas and theorems from the Internet.
• You can use graphics and elements from the Internet in an adjunct capacity.
• You’ll want to add notes (a PowerPoint skill) to each slide for later printing for when you present.
• You may want to search for mathematical fonts on your computer or on the Internet so that you can make your drawings authentic and effective.

Note. There is no deadline to finish this project at this point. However, there will be deadlines to finish particular slides.

Let’s get visual and have fun reinforcing your Geometry skills and knowledge. Be creative! Be precise!