Presentation
Form Letter Practice Test
Download the following files and move them to a folder inside your Tech folder, e.g. "username/Documents/Tech/Form Letter"
- Letterhead graphic (save to Form Letter folder)
- Ty Murray Photo (save to Form Letter folder)
Save this file to your Form Letter folder and open it in Microsoft Word:
Assemble the sample document with the above files and the following instructions:
To get an idea of what your final product should look like, check out the sample solution.
6-8 - Excel filtering, conditional formatting
Follow Kevin's instructions for downloading and working with the following Excel file.
Holiday Feast PowerPoint Assignment
Your assignment is to complete a five-page PowerPoint Presentation. The topic should be Holiday Feasts (e.g. Thanksgiving Feast, etc.). If you do not take part in any holiday feasts, then ask Kevin for a suggestion.
Be sure to save often. Save your presentation with a descriptive name (PowerPoint filenames should end with the extension .ppt).
1. Apply a “theme” to all of your slides
on a Mac: Format → Slide Design… (or use the Formatting Palette*)
on a PC: Format → Apply Design Template…
To change the layout of the slide titles, pictures, etc.
*Go to the View menu and check Formatting Palette. Select View > Slide Sorter then select a slide to assign different themes to different slides.
Format → Slide Layout…
To change the background color, add a background picture
on a Mac: Format → Slide Background…
on a PC: Format→Background…
2. Add titles, text & pictures. Either use ClipArt, which is built into PowerPoint, or use Google Image Search (via your web browser, e.g. Safari) and find the pics you want. When you locate the image, click on it, then click See full-size image. Save the image to your Tech folder (File → Save As...). Go back to PowerPoint and:
Insert→Picture→From File… (locate the image you saved, in your Tech folder for example)
Insert→Picture→Clip Art… (for pictures in PowerPoint’s Clip Art)
3. Set up animations for text & pictures
Slide Show→Custom Animation…
4. Add a new slide by going to Insert→New Slide… Choose the layout you want.
GO BACK TO STEP I: With each new slide, repeat I,II and III.
Go on to step V only after you have made five slides.
5. Add transitions by going to Slide Show→Slide Transition…
(easiest when you use slide sorter view).
6. When you finish with all 5 slides, rehearse your slide show by going to
Slide Show→Rehearse Timings. Click the mouse for each animation and transition, then record the time between clicks to make it run automatically.
Grading Table
|
Category |
Points/Pts. Possible |
|---|---|
|
Descriptive filename |
/5 |
|
Layout and titles for each slide (design template, background |
/10 |
|
Images on each slide (3 pts./slide) |
/15 |
|
Custom Animation on each slide (5 pts./slide) |
/25 |
|
Slide Transitions between each slide (4 pts./transition) |
/20 |
|
Did you Rehearse Timings? (2 pts./slide) |
/10 |
|
Spelling |
/10 |
|
Effort Didn’t try very hard – 1 • 2 • 3 • 4 • 5 – Great |
/5 |
|
Total |
/100 |
5th Grade - Excel Lists
Follow Kevin's instructions for downloading and working with the following Excel file.
Downloading Pictures
Q: What is the best way to get pictures off of the Internet?
A: First remember that many images on the Internet are copyrighted. Please see this page for how to cite your sources for any formal work. Follow the steps below to save pictures from Safari web browser. Other web browsers (Internet Explorer, Firefox) work in a similar fashion.
- Open Safari and perform a Google Image Search for whatever you're looking for. A google image search box is on the school home page, or can be found at http://images.google.com/.
- After you locate a picture you want to use, click on its thumbnail image.
- Click the See full-size image link. Note the website address where the image is located to cite your source.
- Go to File > Save... and navigate to the folder where you wish to save the picture (e.g. your Tech folder, inside Documents).
5th Grade
Import some text into Ten Thumbs so that you can type stuff that makes sense.
Here's how:
- Download typing.txt. It will be saved inside the Downloads folder inside your home folder.
- If Ten Thumbs isn't already open, open the program, select your name & click OK.
- Click the Extra Practice button along the bottom.
- Click the Import Text button in the upper-right.
- Select the file you saved in step 1 and click Open.
678 Calendar Assignment
Please see page 1 of the handout to get started. We are not going to follow page 2 of the instructions handout. Instead, we are going to add pictures for each month as suggested by the class.
I. GENERAL INSTRUCTIONS
In order to add pictures for each month, you must insert a blank row and the days of the week at the top of each month. Some months overlap in the middle of a week, in which case you will have to duplicate the overlapping week to show up on both months' calendar pages.
In order to add pictures for each month, you must insert a blank row and the days of the week at the top of each month. Some months overlap in the middle of a week, in which case you will have to duplicate the overlapping week to show up on both months' calendar pages.
II. STEP-BY-STEP INSTRUCTIONS
A. Insert a blank row for the January picture.
- Select Row 1 (or any other row beneath where you want to insert the blank row).
- Go to Insert > Rows
- With Row 1 selected, go to Edit > Clear > Formats to make it blank.
- Resize the row height as big as it will go (409). You may have to adjust the page zoom to 100% to do so.
- You may have to drag up the blue line in Page Break Preview to include the picture row.
- Select the 7 cells in your new, blank row and click the Merge and Center button
on the Formatting Toolbar. This gives you a big cell in which to paste your picture at the end of these instructions.
B. Repeat a week (at the end/beginning of a month):
- Select the 2 rows of the week below the week to repeat.
- Copy (cmd+C)
- Go to Insert > Copied Cells
- Drag the page break in Page Break Preview to appear in the correct place.
C. Put a picture row and weeks row at the top of each month.
- Select Rows 1 and 2 (or any other picture & weekday rows).
- Copy (cmd+C)
- Select the next date week at the top of the month where the picture & weekdays are needed.
- Go to Insert > Copied Cells
- Repeat steps 2-4: You still have a blank row and a weekday row selected, so copy it again, repeating steps 2-4 until there is a blank picture row, followed by a weekday row, at the top of each month.
- After all the picture+weekday rows are inserted, drag the page breaks in Page Break Preview to appear above and below each picture row/page.
- Find the picture in Safari and save it (see here for instructions).
- Go back to Excel and click in the cell where you want the picture.
- Go to Insert > Picture > From File... and locate the picture you saved in Step 1.
E. When you are finished, turn in your assignment by saving it as a PDF instead of printing it on trees :-).
- Go to File > Print...
- Click the PDF button in the lower right and select Save as PDF... (see below).
- After selecting Save as PDF, navigate to your home folder and select Public so I can easily collect your assignment off the server without killing any trees!
Intermediate Excel
6th graders are in the Sierras. 7th & 8th Graders use Excel to create a 15 x 15 times table.
A Group:
B Group:
WELCOME BACK!
Here's what we will go over the first day of Technology Class:
- Where to sit and how to choose a seat
- How to handle lab equipment
- Computer and Internet Use Agreement (link to BSUSD home page - see Forms under District Information)
- Cyber Safety
678
Excel data list. Click below to download data for Group A and Group B.
Group B left off just before copying column D, which contains formulas, and using Edit > Paste Special... to paste values into column E.
Group A left off at hiding and revealing columns.
5th Grade
I graded students' computer guts definitions, except for LF and EB. PA has to make some minor changes. Everyone else has completed the assignment.
678
Group A opened the data.xls file from TUHSD curriculum and worked on inserting a header row, hiding/unhiding columns, sorting.
678
Table of Contents
We review the use of text alignment, fonts and font sizes, and learn how to use Format > Tabs... to set advanced tab options for use in a Table of Contents. Below is an example. See notes following example for further instructions.
Note that the "Increase Indent" button is used for indented text (e.g. "Global Warming...).
Note that the "Numbering" button is used for evidence pieces (e.g. 1. "Ode to a Chair").
Note the use of bold lettering for clarity. 12 pt. font used throughout, except for 14 pt. title, "Table of Contents."