Technology

Technology

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