Creating a Class Schedule Using Excel 1. Open Microsoft Excel. In cell A1 and type in “Class Schedule.” 3. Schedules; Favorites by app. Class schedule (by time) PowerPoint. Microsoft in education; Office for students; Office 365 for schools; Deals for students. Select all of column A by clicking on the gray “A” box at the top of the worksheet. Go up to “Format,” “Cells.” Under the “Number” tab, click on “Time”, and then under “Type,” click on “ 1:30 PM.” Click “OK.” 3. Begin your table by creating time intervals in column A. I usually use 15-minute intervals. Type in at least three different times. Once you have three times entered, you can let the computer do the rest of the work. Select the three times, and move your arrow to the small box in the lower right-hand corner of the box. Click and drag until you have reached the end of the day. Now click on cell B2. Type in “Monday.” Click on the lower right-hand box and drag until you have all the days of the week. Center your title by selecting cells A1-F1. Click on the “Merge and Center” button. Now you can create the lines on your schedule. Select all of the cells that you wish to divide with borders. Click on the “Borders” button and select “All Borders.” 8. Now, select columns B-F by clicking and dragging on the gray boxes above the chart. Go up to “Format,” “Column,” “Width.” Key in “15,” and click “OK.” 9. Now you can enter your class schedule. Be sure to type in the cell in which the class starts. Next, select two cells that you want to combine into one class. Click on the “Merge and Center” button. Continue doing this for all of your classes. Now, select the all of the cells that contain the days and classes. Click the “center” button. Now click “Format,” “Cells.” Choose the “Alignment” tab and under vertical, select “Top.” Also make sure to check the box next to “Wrap text.” 12. Now you can make the schedule easier to read by color coding some of the classes. (Recess, lunch, and specials) Select the cells that you want to change the color of and click on the arrow next to the “Fill Color” button. Choose your color and continue doing this with any classes you wish. If you are a teacher and you would like to keep your class schedule organized, it is important to have some kind of help to get this job done right. If you are a school looking to create schedules of each of your teachers, you also need a way to get this done in a manner that is professional and easy to do. This class schedule template is just the thing you need, no matter which of the above situations you fall into, as it will allow you to create something that is professional and easy to use – so easy to use that a school can quickly put one together for each of their teachers, and so that a single teacher can put one together for him/herself in no time at all. Advertisements Through the use of this template, you can identify a teacher by name at the top – whether this is your name if you are the teacher putting together the template, or the name of each of your teachers, if you are the school doing the job. You can also include the bell schedule up on the top, so that there is no confusion as to what is going on. Then, the real work begins. You can use this template to fill in all of the classes that the named teacher teaches, and their period start and end times to keep everything on track. There is even space at the bottom of the template for project work information, so you can add any notes that you need.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |