Back To School Night Schedule Production
To Produce Schedules for Back to School Night (BTSN) or Parent Teacher Conferences (PTC)
To Produce Schedules for Back to School Night (BTSN) or Parent Teacher Conferences (PTC)
- First Export the schedule data from WH
- Go to Lists in WH and find the list called Student Schedules w. Block.
- Edit this list and change the School Year Label to the Current year
- Run this list and then export it to Excel - Note that WH does not REALLY create an excell file.
- In order to convert this file to a true excel format, open it and select Save As. Choose Excel Workbook and give it a new name
- Next you will have to import the data into an Access Database in order to produce the report
- Open the access file: M:\data\US\btsn-ptc_Schedules.accdb
- Open the table called schedule data
- If there is old data in this table, we need to clean it out first...
- click on any field, use ctrl+A to select all records
- Hit the delete button. You will be warned that you are about to delete a lot of records. (that's okay)
- When all records are gone, close the table
- Right click on the table and select "Import."
- Browse to the excel file that you saved. Be sure to select the one that you created by chosing "save-as" in excel. If you select the one that you exported directly from WH, it won't work. Remember, that wasn't really an excel file.
- Click the button to "Append a copy of the records to the table:"
- Be sure to select the tablet "scheduleData" and click OK
- If the ScheduleData table is open, you will get an error message asking for permission to close it.
- The next screen will give you a preview of the data to import. Click Next
- Click "Finish" on the next (and final) screen
- Once the data has been imported, you can preview and print the report that you want
- Double click on either the BTSN Schedules or the Parent Conf Schedules report
- Under Veiws at the top of the screen, select "Print Preview."
- Click Print to print the report. They will output in order of grade (10,11,12,9) and then by student last name.