Home
Calendar
About Bijou
Mission & Goals
Principal's Page
Students
Student Support/Resources
Courses
Counseling
Library
Staff
D11 Home

"To the dull mind all nature is leaden. To the illumined mind the whole world burns and sparkles with light." -- Ralph Waldo Emerson

Points Quick Reference Guide

Specific Data-Entry Steps

Enter Student Names

à    Last, First

à    No Nicknames, etc.

Look it up on Zangle! It’s all there!

à    Enter Grade, Start date, Class start date as needed.

Select and Enter the Start of the Block date in the first two cells of the “Start of Block” column one at a time. They are both shown selected below:

Select those two cells and then point the cursor at the tiny square in the lower right corner of your selection.

Most of the time your cursor looks like a fat plus sign when you are on the Excel worksheet à

BUT when you put it right on the tiny square, it turns to a skinny plus sign when it’s ready for you to proceed à

This is when you Click and Drag – When your cursor is the skinny plus, Click, and then Drag all the way to the bottom of the data in that column only.

The correct date should display all the way.

Do the same thing for the Current Date.

The Current Date should be the last date of the previous week that the students turned in work, usually Friday but sometimes Thursday.

AutoFilter -

Display only one course or group of courses at a time

The blue row numbers on the left show that the only course data being displayed is “CompApps” – all others are hidden, making it easy to enter the Computer points only.

This is how to Turn On AutoFilter...

Click in Cell A1

Click on Data > Filter > AutoFilter:

  This is how to See Only One Course for data entry:

Click on the little Down-arrow that is embedded in the Course title cell,

Then click on the name of the course you want to see exclusively.

From the list above you can see several Math courses. You may want to see all Math courses and only math courses.

This is How to see all courses that have a common theme:

Click on the Down-Arrow

Click (Custom…)

The Custom AutoFilter dialog box opens up.

[The default is for the left pane to show “equals,” but there are a number of other choices if you decide to get fancy.

We want equals, so we’ll leave it.]

In the right pane -

Enter the common word (in this case it is Math)

Followed be an asterisk:   *

-which is a “wildcard” allowing anything to follow the keyword “Math”

All courses with a name that begins with Math will display,
ß like this

            This is why you want all your courses to be named
            with a beginning word like “Math,” “Eng,” “Soc” or “Art”
                        – it allows you to sort them together for easier data
            entry or display.

Record Credits and Half-credits

When you enter a “100” in the “Total Pts - Class” cell, Date! appears in the Credit cell of the same student:

You then click on that cell and enter the date you wrote the credit:

When you have a Half-Credit to record, enter a “Y” in the 1/2 CT cell of the student who earned it:

Half-> appears in the Credit cell of the same student:

You then enter the date for the half credit in the Comments cell for that student.

Excel will usually change the date format to a default date format, so you can enter
 “10-9” and Excel will likely change it to “10/9” or “ 10/9/2006 ” automatically, depending on the cell you’re in. See screenshots above.

Changing a student’s Status – Holds and Drops

Students may drop out of school, or simply out of a particular course.

If they have dropped your course, enter an “H” in the status cell for that student in the appropriate course to indicate that student is on “Hold” for that course:

- Most students who are on hold have had a schedule change and will be back in that course, so you need to Hold on to their points.

If a student has dropped out of Bijou , you will do nothing until the front office has contacted all teachers with the news that a student has withdrawn from Bijou.

When you have been so notified, you can enter a “D” into the status cell for that student:

AutoFilter to hide Drops and Holds

Using AutoFilter (see above) you can sort those Drop and Hold students out for your weekly Points Charts like this -

Click on the Down Arrow for the Status column.

Click (Blanks) à

All Ds and Hs will be hidden.

Click All to show them again.

- You can also click D or H to see just those categories.

You can hide those students and still show specific courses as described above…

This is showing only CompApps students:

And now we hide the Holds including the student Highwaist, Dred:

...and Row 58 is hidden in the second one.

Creating Charts

Add a Chart – BUT FIRST…

Make sure your screen is maximized!

 Frequently I see a screen like this, and the person to whom it belongs has said they cannot find their tabs at the bottom:

There are 2 places to look here.

Notice there are 2 different Xs in the upper right corner.

This means that while the main Excel window is maximized,

 the Workbook window is not.

You want to have the Workbook window maximized, too.

You can’t see the tabs at the bottom because of this.

ß Look closely at the upper-right corners.

The upper group of 3 little boxes shows what looks like 2 little pages, in between the – and the X,

which means that the main Excel window is maximized.

The lower group of 3 little boxes shows what looks like 1 little page in the same spot.

This means that your Workbook window is NOT maximized.

You want to click on the single little page button in the lower window, which is your Workbook window,

so that you can Restore it to full size, or Maximize it.

 When you do, your screen will look similar to the next screenshot:

Note that you can see the tabs at the bottom of the screen:

  And that in the upper right corner, there are some changes:

The same symbols are all there, but the lower ones, the ones for your Workbook window,

 look a little less like buttons, and the middle one is 2 little pages now.

That means that your Workbook window is now maximized, and all your tabs should be visible, or at least findable.

Now it’s time to actually

Add a NEW Chart when you have too many students for the existing number of charts…

Have your charts numbered, like Chart1, Chart2, etc., like the example above.

Right click on your latest chart’s tab at the bottom of the screen, and click on Move or Copy:              

In the Move or Copy  dialog box, Click the Create a copy box, then scroll down

in the Before sheet: window and click the spot where you want to place the new chart, then click OK.

A new chart tab with the same name PLUS a (2) after it will appear where you intended it to.

Change the name (in this case to Chart10) by right-clicking on the tab and click on Rename,

which is right above Move or Copy as shown above.

Select the old number and the (2), replace with the new number (in this case 10):

Chart the Right Students

The new chart has the same students as the one you just copied it from.

You have to change the Source Data so that you can show the extra students on the new chart.

Right-click somewhere in the plot area and click Source Data…

The main data table should open up with the Source Data dialog box open in it:

The data you are interested in is in the selected window in the middle of the Source Data dialog box, the Data range: window:

[Here, Jack! refers to the worksheet with the data you are charting (your name instead, of course); $E$1 and $E$122:$E$136 refer to the cells with students’ names and their label; $N$1:$P$1 refers to the labels for the data you will chart. The data references are hidden here; you can see them on the next page - $N$122:$P$136 refers to the data range of the actual data]

Behind the Source Data dialog box, you can see the data and what I call “Crawling Ants”

They show the data that is referred to in the Data range: window. In this example it is showing the data is read from cells E122 to E136, and you can’t see all of it at once.

You CAN scroll down to find the end of the data you want to plot on your new chart:

In this example, the new
students’ data go all the way
to row 149, 14 new rows in all.

You want to change those numbers in the Data range: window so that your new chart is showing all the new student data.

Here you have clicked in the Data range: window
and the cursor I bar is in the number “122”

Since the old range is 122:136, you want the change to start at 137. How far you go is up to you, but in this case we’ll go to 151.

 [See the rest of the references from the previous page?]

However, the row numbers show up in 2 spots. Here is the second location, further along in the string:

  And you need to change them in both places:

  Then,

Click OK in the Source Data dialog box.

You will immediately be back in the new chart (here Chart10) and should see that your student data is up-to-date on the chart:

Sort Data

You may want to simply sort your data after entering new students.

For clarity, you should probably do this with the AutoFilter turned off.

As shown earlier, Click on Data > Filter > AutoFilter

It acts like a toggle, and if AutoFilter was on it will now be turned off.

To sort, click in cell A1

-or-

If you have deleted any data in rows, you need to go to the last student’s Comment cell and click and drag to cell A1. (If there are blank rows Excel may not select what you want to sort correctly)

Click on Data > Sort…

This opens the Sort dialog box:

For consistency, we need to all -

  Sort by Student

Then by Course

Default settings should be Ascending, shown on the right,
and Header row near the bottom under My list has   

Then click OK

Protect Worksheet

When you are DONE with all your data entry at the end of the point block.

To protect a worksheet -

1. SELECT and Right-click on each of the columns you want to protect.
   You can select them all, but the most important to protect are B, E, O, P and Q
2. After right-clicking, Click Format Cells à

Click the Protection tab in the Format Cells dialog box, then click or unclick the Locked checkbox as appropriate.
 

1. 
2.  
3.  
4.  
5.  
6.  
7.  
8.  
9.  
10. 
    
    
    
    
    
    
    
    
    
    
    
    
    NOTE – you only need to do steps 1 through 3 once per worksheet.

Click on Tools > Protection > Protect Sheet… à

5. In the Protect Sheet dialog box,
   Under
   Allow all users of this worksheet to:
   - Leave the defaults,
   -or-
   also scroll down and click Use AutoFilter to allow others to sort while they search for a student’s points.
   
   
   Then click OK

NOTE – you can put in a password, but overall security is not what we’re shooting for here. Our main purpose is to keep accidental changes from occurring, so I suggest not entering a password.

If someone checks your recorded points for a student and accidentally makes a change they shouldn’t, they should see this message window pop up:

All they can do is click OK.

When they exit they may see a window like this one:

- but only if they made a change to an unprotected cell.

If you protect all the columns, from A through R (Status through Comments) they won’t be able to and will likely NOT see this window.

If they do, we can only hope that, most of the time, they would realize they want to click No.