TheOlyCenter.org
The Olympus Sr. Media Center - Helping students Learn and teachers Teach... Using Media.
  • Library Stuff
    • Banned Books
    • Book Requests
    • Collections
    • Destiny Login
    • GoodReads
    • Genres
    • Got Fines
    • Lexile_RI
    • Magazines
    • Sora
    • Rewards
    • Textbooks
  • Tech Stuff
    • Chromebook Info
    • Current Events
    • Digication
    • Leaving GSD
    • Office for Home
    • Passwords
    • Updates Happen
    • VR
  • Research
    • Conspiracies
    • E-Mail Scams
    • News or Not
    • Non-Fiction Books
    • Plagiarism
    • QER
    • Scrible
    • Search Engines
  • Teachers
    • Book ideas
    • Novels
    • Orientation info
    • Posting
    • Printers
    • READ Posters
    • Software
    • Sora Assignment
    • Sora Suggestions
    • Updates
  • Destiny
  • Olympus
  • Links
  • Academic Technology
  • Reading Circles
  • GooseChase

Civics Test Results

2/24/2016

3 Comments

 
To get your scores
  1. Go to your Canvas Gradebook and click on Export and choose "Current"
  2. It will export ALL your Canvas grades to a .csv file.
  3. Excel will open that file.
  4. Right-click in the column called “SSID” and delete it.
  5. Ditto for “ID” Column (Keep one that has the Student ID!)
  6. Click on the Column at the top Column E(?) and move the mouse to the right to select many columns.  Right click Delete all the data you do not need.  My understanding is you only need module 5.  Students need a score of 35/50 or 75% to pass.
 
Dr. Averett does not want a score he just wants a P or F.  So change what you need to in the one column.  The example I am looking at are all scores of 10 with 2 empty cells. The two empty cells were student student's who did not test.  Leave them blank.  I would chose (highlight) the whole column then use "Find" and "Replace" the 10 with a P.  Or type a P in the top box and then drag it down.   I can show you how if you come on down. 
 
Columns for last name and one for first name are requested but Canvas does not export that way. Your list is sorted by Last, first names in one column.
 
So…
  1. Right-click on "Row 2" (points possible) and delete the row.  You should now have 3 columns and a bunch of rows of students.  We need to split the first column of last, first into 2 columns.  Here we go…
  2. Right-click on "Column B" and click on “Insert”
  3. Do it again so there are two new empty columns, B and C.
  4. Click on "Column A" so it is highlighted.
  5. Then click the "Data" tab at the top.
  6. Chose "Text to Columns" (be sure Deliminated is chosen with the circle) click "Next"
  7. Uncheck the "Tab" box, check the "Comma" box.  Click "Next"
  8. Select the destination by clicking the very small “Red Arrow” selector tool on the right of the "Destination" box. The box may shrink but is still open.
  9. Select where you want this soon to be separated text to go.  Click "Column B", push and hold the Shift button and click "Column C."  (The two columns you made earlier should now be selected!)
  10. Click the tiny "Red Arrow" again and there should be a “$B:$C” in the Destination box.
  11. Click "Finish."
  12. Select "Column A" and deleted it.
  13. Rename the columns as requested. Last Name, First Name, Student #, Civics test P/F
  14. Click File "Save As". (Not Save)
  15. Navigate to the S:\Olympus_Sr\Staff\CivicsTest and save it with the correct name 634 is your school code.
  16. “(school number)_(teacher last name)_(course name)_(semester)_(class period).” (Example - 634_whitehead_usgov_1_A1)
  17. In the box that says “Save As type:” chose "Excel Workbook" instead of CSV (Comma deliminated)
  18. Do that for each class. 
It is not really as hard as it seems – just takes a little time.  You will not be able to see other teachers files so do not base anything on what is in this folder.  

Sorry there are no pictures to help you out.

Please comment and make suggestions to help everyone out.
3 Comments
Keith
2/24/2016 03:53:16 pm

Do not save the file as .pdf. It needs to be an excel file. He is going to get a few of these results pages from EACH teacher in the district!

Reply
Keith
5/19/2016 03:21:38 pm

From Rob...
I have become aware of a problem in the reporting of Civics test results. Supplemental instructions published recently have caused several schools to make two mistakes with their reporting.

1. The informal instructions taught a “shortcut” to determine whether a student had passed or failed the test. The “shortcut” worked if the student scored the minimum seven points on the first four modules but not if the student exceeded the minimum score. The correct calculation is to add the results of the four modules and recorded a “P” if the result is 35 or greater. Otherwise an ”F” is recorded.
2. The informal instructions also taught that an “F” should be recorded if no test had been taken. The correct indicator is “blank” if no test has been taken. A few students have been surprised to see an “F” in the Basic Civics Test field of their transcript when they have not taken the test.

Corrective action:

1. Schools should upload an update file changing “F” indicators to pass if the score was not correctly calculated. The “P” will overlay an “F” or “blank” for this field.
2. Schools should upload a separate list of results that should be returned to “blank.” These must be manually changed by this department.
3. Schools should send an email to emwright@graniteschools.org informing that changes have been uploaded to process. The upload should be to S:/Student Assessment/Secure/(school name)/Civics Test Results 15_16 .

Reply
Mr. Terry James DDS link
10/11/2022 12:06:58 am

Ball character near seat behavior. Skin himself when.
Traditional instead expert baby democratic still assume. Budget development receive history.

Reply



Leave a Reply.

    Tweet This

    Categories

    All
    Apps
    Blog
    Books
    Browsers
    Chrome / Google
    Cloud Storage
    Content
    Gradebook
    Parents
    Portfolios
    SAGE
    Social Media
    Students
    Teachers
    Technology
    Trainings
    Windows 10

    RSS Feed

Powered by Create your own unique website with customizable templates.
Photos used under Creative Commons from @nGe(L), dumbledad