Theory
Good news: you already know this
Priya's team now needs to handle the survey data, numbers to sort, total and chart. She opens Google Sheets and smiles: it looks almost exactly like Excel.
That is the good news of this whole unit. Google Sheets is a cloud spreadsheet, and everything you learned in BCA105 and BCA106-01, cells, formulas starting with =, SUM, IF, VLOOKUP, sorting, transfers directly. Same skills, new home.
What Sheets adds is the cloud: real-time collaboration, auto-save, and a clever filter views feature for teams. This lesson orients you and covers sorting, so you can hit the ground running.
Theory
The same car, now with extra seats
If you can drive one car, you can drive another, the wheel, pedals and gears are the same. Google Sheets is Excel with the same controls (cells, formulas, sorting) plus extra seats: several people can 'drive' at once, editing live. You do not relearn spreadsheets; you bring your Excel skills over and gain collaboration. The learning curve is tiny; the payoff (teamwork) is large.
At a glance
Excel skills that transfer to Sheets
| Skill | In Sheets | Same as |
|---|---|---|
| Formulas | =SUM, =AVERAGE, =IF, =VLOOKUP | BCA105 / BCA106-01 |
| Sorting | Data > Sort range | BCA105 sort (whole table) |
| Formatting | Toolbar: bold, number formats | Excel formatting |
| Collaboration | Real-time co-editing, filter views | New (cloud only) |
Theory
Sorting, and the cloud twist on filtering
Sorting: Data > Sort range (or Sort sheet), ascending or descending. The BCA105 rule still holds: sort the whole data together so rows stay aligned (never one column alone).
Filtering has a clever cloud upgrade. A normal filter changes the view for everyone in a shared sheet, awkward when four people work at once. So Sheets adds filter views: each person can apply their own filter to analyse their slice without changing what others see. Priya filters to 'first-year responses', Karan to 'hostel students', simultaneously, no conflict. That is collaboration-aware filtering.
Quiz
In a shared sheet, Priya wants to filter to her own slice of data WITHOUT changing what her teammates see. What does she use?
- A filter view, it filters only her view, leaving others' views untouched
- A normal filter, which changes the view for everyone
- Sorting the whole sheet
- She cannot filter a shared sheet
Show the answer
A filter view, it filters only her view, leaving others' views untouched
A filter view applies a filter to only your own view of a shared sheet, so teammates' views are unaffected, perfect when several people analyse the same data at once. A normal filter would change what everyone sees, causing conflict in a shared sheet. Filter views are Sheets' collaboration-aware filtering, exactly the kind of cloud twist this subject highlights.
Think first
Does your VLOOKUP knowledge transfer?
Priya learned VLOOKUP in BCA106-01. Will it work the same way in Google Sheets? What does that tell you about learning Sheets?
Show the answer
Yes, VLOOKUP (and SUM, IF, SUMIF, and the whole formula toolkit) works essentially the same in Google Sheets as in Excel, same syntax, same exact-match FALSE argument, same logic. The lesson: you are not learning a new spreadsheet, you are using your Excel skills in a cloud home that adds collaboration. Focus your attention on the cloud differences (real-time editing, filter views, sharing), because the spreadsheet fundamentals you already own.
Watch out
Where marks leak
Treating Google Sheets as a totally new tool, it is a cloud spreadsheet like Excel; formulas and sorting transfer (BCA105/BCA106-01). Forgetting the BCA105 rule that sorting must include the whole data (not one column). And missing the cloud extra, filter views let individuals filter without affecting others (versus a normal filter that changes everyone's view). The exam theme: same spreadsheet, plus collaboration.
Theory
Lean into what is new
Because the spreadsheet basics are familiar, spend your energy on the cloud-specific wins: co-editing the data live, filter views for parallel analysis, and (next lessons) formulas across sheet tabs, charts, and sharing controls just like Docs. Your Excel foundation makes Sheets almost free. Next: adding sheet tabs and formulas, then charts, then sharing, the Sheets essentials for the team's survey analysis.
Summary
Key takeaways
- Google Sheets is a cloud spreadsheet that works like Excel; formulas and sorting transfer from BCA105/BCA106-01.
- Sort via Data > Sort range, keeping the whole data together (the BCA105 rule).
- A normal filter changes the view for everyone in a shared sheet.
- Filter views let each collaborator filter their own view without affecting others (a cloud collaboration feature).
- Real-time co-editing and auto-save come built in, like Docs.
- Memory hook: the same car (Excel skills), now with extra seats (collaboration).