Technology

Technology

Tuesday, July 18, 2023

CO Voicemail Setup

 If you have not set up your voicemail yet, here are some instructions:

1. Press the envelope icon 
2. Press 0 for mailbox options
3. Follow the prompts to record the following things
     -Your unavailable message (1)
     - Your busy message (2)
     - Your name (3)


Your voicemail password is your extension number. 

All voicemails should be delivered to your email inbox. 

Let me know if you have any trouble. 


Andrew

Monday, June 12, 2023

Adding Students and Transcripts to Parchment

Adding/Updating Students

Run the Parchment Upload ad hoc and paste the five fields into the CSV template 

Log in to Parchment

Learners>> Actions dropdown>>Choose Upload Multiple Learners>>Give the file a name>>Upload>>Hit Continue a few times (mapping will be accurate if you use the template linked above)

(Any blank fields will cause the upload NOT to work)

Uploading Transcripts

Run a batch of current transcripts. This will need to be done after January posting and after June posting.  

Log in to Parchment

Select Credentials>>Add Credentials


Upload the file. 

After processing (5-10 mins), go back to the same place and click Match Credentials. These students will need to be added. 



Monday, May 16, 2022

Finding Mac/Physical Address in Windows 10

 

How to find MAC address using Control Panel

To determine the physical address of a network card on Windows 10 with Control Panel, use these steps:

  1. Open Control Panel.
  2. Click on Network and Internet.
  3. Click on Network and Sharing Center.




  4. Click the Change adapter settings from the left pane.

    Double-click the Ethernet or Wi-Fi adapter depending on your connection.



  5. Click the Details button.


    Source: Windows Central

  6. Confirm the MAC address of the network adapter (called physical address sometimes).




Thursday, January 27, 2022

Running Presidential Awards

 APs usually ask for this after Semester 1 ends


Use the Ad Hoc folder called Presidential Awards

1. Run the ad hoc for milestones (if they have been imported). This will give you performance levels. 

2. Grades for Presidential will give you posted Q2 grades. Filter and removed anything other than (ELA, math, sci, ss). 

3. Transcript Grades for Presidential will give you all 5th graders posted grades from last year. Filter and removed anything other than (ELA, math, sci, ss). 


Combine the sheets for numbers 2 and 3 above making sure the fields line up. Sort on the last and first name. You will also need to concatenate the name fields. You might have to use the text to columns feature to format the numbers correctly. 

Once you have done this, subtotal at each change in full name to show the average of all the grades. Then paste special (values) to get the averages in another sheet. Then filter on the word averages and paste special one more time in another sheet. Sort these averages. 

Then all you need to do is add the performance levels in this sheet. 

Convert Numbers in Excel

 https://support.microsoft.com/en-us/office/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885


Cells with numbers stored as text with green triangles

Numbers that are stored as text can cause unexpected results. Select the cells, and then click Excel Error Alert button to choose a convert option. Or, do the following if that button isn't available.

1. Select a column

Selected column

Select a column with this problem. If you don't want to convert the whole column, you can select one or more cells instead. Just be sure the cells you select are in the same column, otherwise this process won't work. (See "Other ways to convert" below if you have this problem in more than one column.)

2. Click this button

Data tab, Text to Columns button

The Text to Columns button is typically used for splitting a column, but it can also be used to convert a single column of text to numbers. On the Data tab, click Text to Columns.

3. Click Apply

The rest of the Text to Columns wizard steps are best for splitting a column. Since you're just converting text in a column, you can click Apply right away, and Excel will convert the cells.

4. Set the format


Sunday, August 9, 2020

Excel: Sort by Month and Day

 

  1. Insert a blank column next to your Date column.
  2. Assuming your first date is in cell A4, in the blank column, enter the formula: =TEXT(A4,"MMDD")
  3. Copy this formula down to the bottom of your data.
  4. Sort your data on this column.

Tuesday, June 30, 2020

Disable SLDS (for summer)

Do this so that kids cannot see their schedule. 


To disable SLDS- you will need to go to Index> Sys Admin> Custom > Custom Tab>SLDS Portal > Uncheck the publish to Portal box> Save