jump to navigation

Excel Gradebook February 15, 2007

Posted by admin in : February 2007 Professional Development , add a comment

I. Intro – What Can Excel do for me
II. Workbook – Header and Footer; Columns and Rows
III. Worksheets – Insert, delete, rename, copy
IV. Cell Reference – Naming procedure
V. Cell Formatting – Font, font size, color, bold, italic, underline, borders, alignment, wrap text, number, currency, text.
Battleship with cell formatting
VI. Column & Row Formatting – Resize width and height
VII. Setup a Gradebook Worksheet;

1. Cell A1 Enter text ‘Gradebook for 6th Grade Math – Trimester 1
2. Highlight Cells A1 through L1.
3. Select Merge and Center tool
4. Cell A2 enter ‘Student Name’
5. Cell B2 enter Quiz 1
6. Auto Fill Quiz 2 through 10
7. Enter at least 5 students names in the A column
8. Enter Quiz scores for each student in Quiz 1 Column B
9. For Quiz 2 write a formula using cell references to calculate Quiz 1 scores – 2
8. Calculate the total score for each student – Use Sum function
9. Calculate the average score for each Quiz – Use Average function
10. Create borders on cells
11. Window > Freeze and Unfreeze Panes

VIII. Edit > Move or Copy Sheet > Copy.
IX. Rename Worksheets: Trimester 1; Trimester 2; Trimester 3

Color Code Tabs

X. Inserting and Deleting Columns and Rows
XI. Page Setup (File menu) – portrait or landscape?

100% or fit to one page wide by 1 page tall?
Print area?
Columns to repeat at top?
Rows to repeat at left?

XII. File > New > Templates – Microsoft Office Online

Gradebook
Family Budget

XIII. Tutorials – Atomic Learning
http://www.atomiclearning.com/excel_2003_intro

Functional Word February 15, 2007

Posted by admin in : February 2007 Professional Development , 1 comment so far

Scenario: You need to create a document with images for a presentation for your students.

Open the word document in U:\2007-Feb-PD-Day\FunctionalWord.doc

Save it as ‘Your Name’ in your My Documents directory

Change the Page Margins to be 1” top, bottom, left and right

File ->Page Setup

Bold the title and make it larger than 24 points

Format -> Font or using the Toolbar

Change the font of the document to a font of your choice.

Select All (Ctrl+A or Edit -> Select All) and change font using Format -> Font or using the Toolbar

Insert a clip art picture into your document. Move it to the place where you want it, have the text wrap around it.

Picture > Clip Art, Search for image of your choice, Double click to insert

Click on your picture and hold the left mouse button down while you move the image

Right Click on image -> Format Picture -> Click on Layout Tab and Select Square as the Wrapping Style

6. Insert a digital photo into your document from U:\2007-Feb-PD-Day\insert_image.jpg (or an image of your choice). Resize it and move it to the place in the document where you want it, lastly wrap the text around it.

Select Insert -> Picture -> From File, Look in directory above -> Select insert_image.jpg and click on Insert

Click on the image, select one of the corners and make the image smaller

c. Right Click on image -> Format Picture -> Click on Layout Tab and Select Square as the Wrapping Style

7. Set up document for Tracking Changes

a. Go to Tools (you may have to wait 10 seconds for the whole menu to appear) -> Track Changes

8. Save your document in U:\2007-Feb-PD-Day\YOUR NAME.doc and close.

9. Find a partner, ask them to open your document, edit some of the text by deleting and copying and pasting, insert a Comment, and save and close it.

a. Insert comments by going to Insert -> Comment and edit document by deleting and adding text

10. Open the document, and view their changes.

11. Accept or Reject their changes

a. Insert comments by going to Insert -> Comment and edit document by deleting and adding text

12. Now, accept or reject the changes by viewing the Accept or Reject toolbar.

a. Toolbars -> Reviewing

b. Click on Review Next Change icon Next Correction

c. Accept or Reject the Comment using the Accept(Accept) or Reject(Reject) icon

13. Now Save your document one last time.

14. Advanced: Insert a Table in your document and move some text and an image into the table

a. Click on Table -> Insert -> Table

b. Select 2 columns and 1 row

c. Select and drag text and an image into the table

At this point, you should go to Atomic Learning Word Tutorials:

Intro: http://www.atomiclearning.com/word_2003_intro

Intermediate: http://www.atomiclearning.com/word_2003_interm

Advanced: http://www.atomiclearning.com/word_2003_adv

Browse the topics and see which tutorials interest you and review one. If you have questions, please check with one of the technology department members or students as they circulate the room.

Getting the Most Out of Your Laptop/Tablet: February 14, 2007

Posted by admin in : February 2007 Professional Development, Windows XP , add a comment

Defragmenting the HD:Disk Cleanup
On a frequently used hard drive, the files become broken up into non-contiguous chunks as they are created, modified and deleted. This slows the drive down. The defrag utility reassembles the files.

  1. Right-click on My Computer and choose manage
  2. Click Disk Defragmenter in the left column, which will load the defragmenter in the main part of the window
  3. Make sure the C: drive is selected in the list at the top. then click the analyze button
  4. If the drive requires defragmentation, it will prompt you do start the process

Running a chkdsk on the HD:
If a drive is heavily fragmented, chances are it has some file system corruption also. Running chkdsk repairs the corruption.

  1. Open My Computer, then right click on the C: drive and select Properties
  2. Click the Tools tab, and then click Check For Errors
  3. Check both checkboxes, and click Start
  4. You will be asked if the check should be done at the next restart. Click Yes, then restart the computer

Running Disk Cleanup on Your Computer:
Disk Cleanup removes temporary files from you hard drive. This can free up gigabytes of space on an actively used computer.

  1. Open My Computer, then right click on the C: drive and select Properties
  2. Click on Disk Cleanup
  3. Disk Cleanup calculates free space it can clean up on your hard drive.
  4. Check all of the boxes except Microsoft Office Install Files.
  5. Click OK and confirm that you want to delete the files by clicking OK.
  6. Once this is done, you may want to defragment your hard drive again.

Power Management:
Depending on you power source (i.e. battery of AC) and your needs, you may need to adjust the power settings. Click on the green power meter in the taskbar, and choose Maximum Performance or Maximum Battery Life, depending on your requirements

Symantec liveupdate and manual virus scan:
If you take your laptop home with you over the summer, it won’t be able to contact our server to download virus definition updates. You will need to run the liveupdate process to manually download virus definitions.

  1. Every 1-2 weeks, open Symantec Antivirus by double clicking the yellow sheild icon in the system tray, or run it from the start menu
  2. Click the liveupdate button to start the update process

Wireless/Access Connections:
You connection to wireless networks is managed by Thinkvantage Access Connections. If the Access Connections status icon has a red “X” over it, you are not connected to the network. (SCREENSHOT NEEDED) To reconnect to the network:

  1. Press Fn-F5 on your keyboard.
  2. Make sure the “connection profiles” tab is selected in the window that pops up, and click on the profile of your choice, e.g. “Collegiate” or “home”.

To connect to your home wireless network with Access Connections, check out our tutorial: http://blogs.collegiateschool.org/tech/2006/12/13/configuring-access-connections-for-wireless-at-home/

System Tray:
If you computer is running slowly, you might have nonessential programs running in the background. Often these programs will have icons in the right side of the Task Bar, which is called the System Tray.

  1. If you hover your mouse pointer over an icon, a Tool Tip will pop up with the name of the program
  2. To quit a nonessential program, right click on it’s icon and choose quit or exit

Toolbars:
Don’t install toolbars!! See below:

Too Many Toolbars

Disk Photo Credit: http://farm1.static.flickr.com/153/330155843_2cbf7546e9.jpg?v=0

Professional Development Day Offerings January 29, 2007

Posted by admin in : February 2007 Professional Development, Internet Safety , add a comment

Functional Word: In this session, you will practice creating stylish documents using Word’s formatting tools, how to digitally peer edit documents, and save time using Office Templates.

Excel Gradebook: A Basic Excel Primer for faculty. Learn how to create a functional grading and budget spreadsheet in this session.

Excel Professional: Using spreadsheets in the office. Special focus on formatting cells, entering data, creating formulas using cell references, graphs and other advanced features of Excel.

Great Presentations with PowerPoint: Ever wanted to create a PowerPoint Presentation but did not know how? In this session you will learn good presentation habits and create a formatted presentation with text and images.

Creating a Publication with Publisher: Ever wanted to create a newsletter, flyer, banner, or some other publication? In this session you will have the chance to create one or more of these.

Getting the Most Out of Your Laptop/Tablet: (for tablet/laptop users) Explore how to optimize the performance of your laptop using hard drive, power management, wireless, and other utilities.

Getting the Most Out of Your SmartBoard: Immerse yourself in SmartBoard use from hooking up a laptop to SmartNotebook skills including capturing images and text from other programs and inserting images from the Gallery. Sessions will also include examples from veteran SmartBoard users.

Getting Your Files Organized: Do you have 500 files in your my Documents folder? Can you never find the file you are looking for? Do you know the difference between the My Documents on the z: drive and, and the LS/MS/US Share Folders? If you answered no, sign up for this session.

Getting the Most Out of FirstClass: Do you use FirstClass but feel like there is a lot more functionality that you don’t know about?

Internet Search and Library Resources: Do you want know the secrets of successful Internet Search? Learn about Google Scholar, site specific search, and many other techniques.