1. Introduction to Organize College Applications in Google Sheets
Whether you’re about to start applying to colleges, universities, or vocational schools,or you just want to begin exploring information about them,it’s important to take the time to set yourself up for success.
No matter which schools you’re applying to, they all have their own application requirements and deadlines.
In this lesson, you will use Google Sheets to track application materials for the schools you hope to attend.
Tracking your applications in a spreadsheet will help you organize the application processand successfully meet deadlines.
Your spreadsheet can include things like:The list of schools you are interested in,The list of all the application materials required for each school,Important dates in the application process,And anything else you would like to track.
This lesson uses Google Sheets, but you could apply these skills and conceptsin any spreadsheet application or even on a piece of paper.
As you complete this project in Google Sheets, you will:Create and title a new spreadsheet,Create a header row with the information you want to track,Type and format text,Format cells, columns, and rows,And use data validation to create dropdown menus.
To work on this lesson, sign in to your Google account.
Open a new tab in your browser, and navigate to Google.com.
If you are not signed in, do so now.
If you do not have a Google account, pause the video and create one now.
To begin, open Google Drive.
Create a new spreadsheetand rename it.
Then, move on to the next video to begin setting up your spreadsheet.
Now, it’s your turn:Create a new spreadsheet in Google Sheets,And rename it.
URL not accepted. Please paste a link to a Scratch project.URL not accepted. Please paste a link from google.com (such as a Google Doc).You don't appear to be signed in. Please refresh the page and try again.Something went wrong. Please refresh the page and try again.