SCAD Technology Training

You can use the split pane feature in Word and Excel to view a document in different views. This will allow you to independently view different areas of the document in different ways at the same time.

First you will need to go to the View tab in Word or Excel and select the Split  button from the Window group.

This will split the page in two (four panes for Excel) and give you a horizontal line across the page that you can adjust up or down.

You can now change the view or edit each pane independently. To do this, click in the pane that you want to edit or change the view for. This will allow you to scroll, change the view or make any edits in that specific pane.

When you would like to return to normal view, click on the Remove Split Pane button on the View tab in the Windows group (this button changes to say remove split when the split is applied).

All SCAD faculty, staff and students have at least two campus passwords (outside of any others assigned separately). Your SCAD network/email (or netID) password and your MySCAD password. Both passwords are required to be reset every six months and you can find the links to change them at any time in MySCAD on the My Info Tab in the My Personal Info Channel.

Your network/email password will log you into all SCAD campus computers, email, wireless, MyFile, SCAD Connect, Webspace and several other applications. Your MySCAD passwords only log you into MySCAD and any other applications that utilize Banner.

You will be sent an email one month prior to your network/email password expiring, prompting you to change the password. You will continue to receive this email every seven days until the password is changed. If you do not change your password in this 30 day period, your account will be placed on hold and you will need to contact the Technology Support Center.

You will not receive advanced notice of password expiration from MySCAD. Once your password expires, you will be prompted to change it upon the next login.

Please note that you cannot use the same password 10 times in a row when resetting and for security purposes, you should set your network password and MySCAD password to different passwords.

In addition to contacting the SCAD support center via telephone and email, you can also enter your own tech support tickets.

To access Web Help Desk to enter your ticket, you can go to https://techhelp.scad.edu or use the Web Help Desk link in MySCAD on the Workspace tab in the My IM&T channel.

Then login with your SCAD network user name and password (this is the same information you use to log into the campus computer).

Upon logging in, you will see the screen to enter your ticket. First select the request type. The available options are: eLearning issue (problems with Blackboard), event request (A/V requests), issue/problem (A specific problem that you are experiencing), or service request.

Then continue to make selections as other drop-down menus become available. Once those are all completed, please complete the subject, request detail, location and select Save.

You will see a screen that gives you your ticket number that you can use for reference. Your work order will then be received by the support center and either addressed or assigned to a technician.

You can also log into Web Help Desk to see view the status of a work order. This can be seen under the History button at the top of the page. You will have the option to view any work orders you have submitted and also an option to update them.

You can use the FAQs link to view the various FAQs that are available in Web Help Desk.

Word 2010 has a feature that makes inserting screenshots very easy.

1.To insert the screenshot, have the window open that you would like to insert.

2. Then click on the screenshot button in the Illustrations group on the Insert tab.

2. Then select the screen shot that you would like to be added into the document. It will show up in your document and you can edit the shot from there.

3. You can also do a screen clipping by selecting the screen clipping option under screen shots.

4. When using the screen clipping option, make sure you have the window open and available directly from your Word document.

5. Once you select screen clipping, your Word document will minimize to show you the last available window where you can drag and select the area of the screen that you would like to clip. This will then be added automatically to the document.

Excel 2010 has a feature that will allow you to set-up multiple sheets at a time with the same formatting and data. So, if you normally copy and paste the data and formatting to each sheet in workbook, you will be able to to do it all in one step.

1. First, open your workbook, hold down your CTRL key and select all your worksheets (the sheet tabs will all be white rather than gray with just the selected tab white). This will group your sheets. All changes done while your sheets are grouped will apply to all sheets

2. Now insert your data and formatting. You can insert data and then format in any way that you like.

Sheet 1 Formatting

3. Once you are done, click on any of the other grouped sheets to see the data and formatting (make sure you click on any other sheet to ungroup the sheets before you insert anything that should just apply to one sheet).

Sheet 2 Formatting

This will make sure that all your data and formatting are uniform across all sheets and will save steps later on when needing to set-up those sheets.

If you would like to record audio to go with a PowerPoint presentation and then upload the presentation into Adobe Connect for a meeting or training, your best option is to use Adobe Presenter. Presenter is a PowerPoint plug-in that should be installed on all SCAD staff and faculty PC machines (please note that Presenter is only available on PC not MACS, if you have a need to record audio from a MAC please contact the Technology Training Coordinator at training@scad.edu).

1. Once you have prepared your PowerPoint slides and are ready to record the audio, click on the Adobe Presenter tab.

2. You will then click the Record button in Audio group. You will  see a prompt to test your microphone recording levels. You should go through this step to make sure your microphone is working and the optimize your recording sound.

3. Next, you will see the recording window. To record the audio for the current slide just click on the red record button.

4. When you have finished recording for that slide, click on the Stop Recording button.

5. When you are ready to record for the next slide, click the next button and repeat the process.

You can go back to any slide and redo the recording for that slide at any time.  Once you have completed the recording, you will need to publish the presentation to Adobe Connect. This will publish to your content folder in Connect (you must have attended a Connect training session and have meeting creation rights in Connect to have a content folder). Below are the steps for publishing the presentation.

1. Go back to the Adobe Presenter tab and click on the Publish button in the Presentation group.

2. In the Publish Presentation window, you will need to select the left tab that reads Adobe Connect Pro.

3. If your Server name does not say SCAD Connect, you will need to add the server. To do that click on the edit servers button. Then click Add on the next window.

4. In the Add Server window enter the following information then click OK:

Name: SCAD Connect

URL: scadconnect.scad.edu

5. Once the SCAD Connect server is selected on the Publish window, click Publish.

6. You will see a status bar as the presentation begins to publish. After it has processed, you will be prompted to log into Connect. You will need to login with your network user name and password.

7. Upon logging in, you will be taken directly to your Connect content folder (it knows your folder based on your login), click on the Publish to This Folder button.

8. You will then need to complete the information for the presentation. The Title is the only required field to be completed (It will automatically populate with the file name), all others are optional. Once you have put in the information click on the Next button.

9. On the next screen, click Finish.

10. The presentation will publish and you will receive a prompt that your presentation has published successfully.

Your presentation is now accessible in Connect under the Content menu.

If you need to recover a deleted email, you have up to five weeks to recover it from within your email. In the first seven days after deletion, you can recover it directly from you trash folder. Emails are deleted out of your trash folder after seven days.

Please note: Trash folders are not backed up. This means if there is a problem with the email system and email has to be recovered, items in the trash folder cannot be recovered.

To recover an item from you trash:

1. Click on your trash folder on the left, then look in the mail window to find the message

2. You can then move the message back to your inbox or any other folder that you would like to place it in. You can do this by clicking and dragging the message or by selecting the message and using the move button on the mail toolbar.

3. Once an item has been deleted from the trash folder, you still have another recovery option for 30 more days. To use this option, right-click on your trash folder and select Recover Deleted Items.

4. Once you select the Recover Deleted Items option, you will see a recovery window. Scroll through the items and select the item you would like to recover. Then click the Recover To button.

5. You will then select the folder that you would like the email to be sent to and click Ok. Your email will be moved to the selected folder.

If you have a long list with duplicates, rather than spending the time scanning yourself, use Excel’s remove duplicates feature to make quick work of the task.

Steps to remove duplicates:

1. Highlight the column you would like to remove the duplicates from.

2. Click on the Data Tab and the Remove Duplicates button in the Data Tools group.

3. When the Remove Duplicates window appears, make sure the correct column is selected and click OK.

4. Excel will search the selected column and automatically remove all duplicates (please note: Excel will not prompt you to ok the removal of a duplicate, it will be removed automatically).

5. You will then see a window notifying you of how many duplicates were removed from the list.

It is very important when using Lynda.com through MySCAD that you create your Lynda.com profile. This profile logs your activity within Lynda.com so you can receive credit, if needed, for completing a training. If you do not complete the profile, you are only credited as a generic SCAD user in the system and we can not pull any reports on your individual activity. If you did not complete your profile when prompted upon your first login into Lynda.com, you can still complete it.

Instructions for completing profile:

Log into SCAD’s Lynda.com site by clicking on the Lynda.com link in the My IM&T channel on the Workspace tab of My SCAD.

Hold your cursor over the My Account link in the upper right-hand corner and select My Profile.

Click the Edit link

Fill in your information and click Save.

Connect 9 now gives you more flexibility when you editing a recording. You now have the ability to hide certain pods during recording and edit out identifying information. Meeting hosts can hide one of more of the Chat pod, Attendee pod, or the Q&A pod from a recording. When the Share pod is the only remaining pod in the recording, it expands to full screen to improve the viewing experience.
Meeting hosts can hide the names of all attendees from meeting pods such as the chat pod, the Q&A pod, and the attendee pod, before sharing a recording. This is useful to protect the identity of the participants.

To hide pods:
• Click on the Settings button at the bottom left of the screen.
• The settings window will appear
• Select which pods you would like to hide or hid attendee names
• Be sure to click Save in the lower right-hand corner if you want to keep the changes