Tag Archives: Excel

Microsoft Office 2000 Toolbar Screenshots

I took screen captures of the various toolbars in Microsoft Office for illustrative purposes in my Computer Applications I course. They can be inserted into an Excel spreadsheet, have their display size increased, and be printed out as wall banners though I do not have them in that format like my Microsoft Office 2003 Toolbar Screenshots. They definitely have their uses.

Bulk Download

Individual Images

Advertisements

Microsoft Office 2003 Toolbar Screenshots

I took screen captures of the various toolbars in Microsoft Office for illustrative purposes in my Computer Applications I course. I even inserted them into an Excel spreadsheet, increased their size, and printed out wall banners. They definitely have their uses. I also have Microsoft Office 2000 Toolbar Screenshots.

Bulk Downloads

Individual Images

Pass-Fail Course Grade Algorithm

I routinely use a spreadsheet program to calculate my course grades. It’s just easier for me than to use the software supplied by our state which isn’t quite so user friendly. I currently use Microsoft Excel 2003 and the algorithms below are written to work with it.

Variables and Conventions

  • S1 = Attendance Status as either “LOST CREDIT”, “CONCERN”, or “OK”
  • T1 = Appeal Status and Conditions for loss of credit as either empty (blank) or containing written conditions
  • Z1 = Course Grade in the range 0 to 100 with rounding active and 70 being the lowest passing score.
  • LC is short for Lost Credit
  • CR is short for Credit Restored

Algorithm

=IF(S1<>”LOST CREDIT”,IF(Z1<69.5,”FAILING”,”PASSING”),IF(T1=””,IF(Z1>=69.5,”LOST CREDIT PASSING”,”LOST CREDIT FAILING”),IF(Z1<69.5,”CREDIT RESTORED FAILING”,”CREDIT RESTORED PASSING”)))

Now, since the only practical categories are either Passing, Failing, and Lost Credit Passing (LC Passing) and the other results fall within these categories, we can simplify the algorithm like so:

=IF(S1<>”LOST CREDIT”,IF(Z1<69.5,”FAILING”,”PASSING”),IF(T1=””,IF(Z1>=69.5,”LC PASSING”,”FAILING”),IF(Z1<69.5,”FAILING”,”PASSING”)))

This has an additional benefit in Microsoft Excel. Having only 3 categories allows Conditional Formatting to be applied to emphasize the contrast. I changed the background color on cells in these categories to be either green, yellow, or red depending on the category.

Invalid Formula Error

If you copy and paste the above algorithm into Excel, you may get an invalid formula error even if you correctly swap out the variables (Z1, T1, etc.) for cell references. I am assuming that the version above gets pasted in as smart quotes and excel only recognizes straight quotes. The problem was fixed once I typed over the pasted double quotes using the keyboard.

Total Points to Percentages Lookup Sheet Generator

Total Points to Percentages Lookup Sheet Generator

Ever used one of those old-fashioned slide rules to calculate a grade out of 100% when you had an odd number of questions? Well, I didn’t know about those things when I first started teaching. So, the very first year I taught I made my own using a spreadsheet.

Download

Instructions

  1. Open the spreadsheet
  2. Enter the “Total Number of Questions” (and “Total Curve”, if desired) in the boxes indicated.
  3. Select the “Percent Grades” tab to view and print.

How to take Student Computer Work Home

How to take Student Computer Work Home

Sometimes students need to take their computer work home with them. This guide explains how to pick the right format to save in and the right media to save on for Word Documents, Excel Spreadsheets, PowerPoint Presentations, and Windows Movie Maker Projects.

Download

By the way, if you are interested in installing a FREE OFFICE SUITE that includes programs for word processing, spreadsheets, presentations, and more then download and install OpenOffice from OpenOffice.org.

This file uses images from Refresh Cl Icons by TpdkDesign.net and Aqua Candy Revolution Icons by McDo Design available from Icon Archive.