Creating and Importing a Class Using Microsoft Excel
This video should help you get started using your SMART Response System. The video will show you how to set up a class in Microsoft Excel in a format that will allow you to import the class list into SMART Response software. Although there are other ways to add students, this is the best way to enter an entire class into your SMART response system. Please click the video to begin the tutorial. When you are finished with the video, scroll down for more instructions.
Creating and Importing a Class List from Microsoft Excel
1. Open Microsoft Excel
2. Create 3 Columns
a. Student ID
b. Last Name
c. First Name
**It is very important that these columns follow this format for the list to import into SMART software.
3. Enter information for each student in the class.
4. Save document to a preferred file.
Importing Class Into SMART Response System
**Before completing this step, make sure the SMART Response Receiver is connected**
1. Open SMART Response Desktop Menu (This should be an orange icon on the taskbar at the bottom of your screen.)
a. If the icon is on your toolbar, skip to step 2. If the icon is not present, follow these directions:
· Click on Start Menu
· Click Programs
· Select SMART Technologies
· Select SMART Response
· Click Desktop Menu – This step should place the icon in your taskbar.
1. Open Microsoft Excel
2. Create 3 Columns
a. Student ID
b. Last Name
c. First Name
**It is very important that these columns follow this format for the list to import into SMART software.
3. Enter information for each student in the class.
4. Save document to a preferred file.
Importing Class Into SMART Response System
**Before completing this step, make sure the SMART Response Receiver is connected**
1. Open SMART Response Desktop Menu (This should be an orange icon on the taskbar at the bottom of your screen.)
a. If the icon is on your toolbar, skip to step 2. If the icon is not present, follow these directions:
· Click on Start Menu
· Click Programs
· Select SMART Technologies
· Select SMART Response
· Click Desktop Menu – This step should place the icon in your taskbar.
2. Click Teacher Tools (Could also say “click here to start a class” or “anonymous mode 0 students are signed in.”
3. When prompted, type in a classroom name for your receiver, then click Begin.
*If this step has already been completed, move on to the next step.
4. Click on “Create a new SMART Teacher file” and create your class information.
5. Enter all information as prompted and save to a preferred location on your computer.
6. Switch to “Gradebook View.”
7. Click “Add a Class”
a. Name class, period, and location.
b. Determine passing grade (60%)
8. Click on Created Class name.
9. Select “Add students to your class”
a. Select “Import students into:
1. Click on class
2. Click Next
3. Select “Microsoft Excel”
4. Click Next
5. Choose class list from file (should be an Excel file)
6. Click Open.
**To view the class that was imported, click “Students” tab at the top of the page.
The file below is a printable form of these directions.
3. When prompted, type in a classroom name for your receiver, then click Begin.
*If this step has already been completed, move on to the next step.
4. Click on “Create a new SMART Teacher file” and create your class information.
5. Enter all information as prompted and save to a preferred location on your computer.
6. Switch to “Gradebook View.”
7. Click “Add a Class”
a. Name class, period, and location.
b. Determine passing grade (60%)
8. Click on Created Class name.
9. Select “Add students to your class”
a. Select “Import students into:
1. Click on class
2. Click Next
3. Select “Microsoft Excel”
4. Click Next
5. Choose class list from file (should be an Excel file)
6. Click Open.
**To view the class that was imported, click “Students” tab at the top of the page.
The file below is a printable form of these directions.
creating_and_importing_a_class_list_from_microsoft_excel.docx | |
18 kb | |
docx |
creating_and_importing_a_class_list_from_microsoft_excel.pdf | |
File Size: | 308 kb |
File Type: |